Monday, April 28, 2025

Legacy System Cloud Migration strategy

Migrating legacy systems to the cloud is a complex but highly beneficial process that can lead to improved performance, scalability, and cost efficiency. Here is a comprehensive strategy for cloud migration:


1. Assessment and Planning

A. Assess Current Systems

Inventory: Document all applications, databases, and dependencies.

Evaluate: Assess the current state, including performance, security, and compliance requirements.

Cost Analysis : Estimate current operational costs and potential savings from cloud migration.


B. Define Objectives

Business Goals: Align the migration with business objectives such as cost reduction, agility, or innovation.

Key Performance Indicators (KPIs): Establish metrics to measure success.


2. Choose the Right Cloud Model


A. Cloud Service Models

IaaS (Infrastructure as a Service): For migrating virtual machines and storage.

PaaS (Platform as a Service): For applications that benefit from managed services.

SaaS (Software as a Service): For applications that can be replaced with cloud-native solutions.


B. Deployment Models

Public Cloud: Cost-effective and scalable but with shared resources.

Private Cloud: Greater control and security, often used for sensitive data.

Hybrid Cloud: Combines public and private clouds for flexibility and optimized workload placement.

Multi-Cloud: Uses multiple cloud providers to avoid vendor lock-in and optimize services.


3. Migration Strategies


A. Rehosting ("Lift and Shift")

Description: Moving applications as-is to the cloud with minimal changes.

Use Cases: Quick migration with immediate benefits but may not fully leverage cloud-native features.


B. Refactoring

Description: Modifying applications to better fit the cloud environment.

Use Cases: Gaining efficiency, scalability, and cloud-native benefits.


C. Replatforming

Description: Making minimal changes to optimize for the cloud.

Use Cases: Minor tweaks to take advantage of cloud infrastructure without full refactoring.


D. Repurchasing

Description: Replacing legacy applications with SaaS alternatives.

Use Cases: When existing applications can be replaced with modern cloud solutions.


E. Retiring

Description: Decommissioning outdated or unnecessary applications.

Use Cases: Reducing complexity and cost by eliminating redundant systems.


F. Retaining

Description: Keeping some applications on-premises.

Use Cases: When certain applications are not suitable for cloud migration.


4. Data Migration and Integration


A. Data Migration

Plan: Develop a data migration plan including data cleaning and transformation.

Tools: Use cloud provider tools like AWS Database Migration Service, Azure Data Factory, or Google Cloud Dataflow.

Testing: Perform thorough testing to ensure data integrity and accuracy.


B. Integration

APIs: Develop APIs to integrate cloud and on-premises systems.

Middleware: Use middleware solutions for seamless data flow between environments.


5. Security and Compliance


A. Security

Identity and Access Management (IAM): Implement robust IAM policies.

Encryption: Use encryption for data at rest and in transit.

Monitoring: Continuous monitoring and alerting for security threats.


B. Compliance

Regulations: Ensure compliance with relevant regulations (e.g., GDPR, HIPAA).

Audits: Regular audits to ensure adherence to compliance standards.


6. Deployment and Testing


A. Phased Deployment

Pilot: Start with a pilot project to validate the migration process.

Stages: Migrate in stages to minimize risk and disruption.


B. Testing

Functional Testing: Ensure all functionalities work as expected in the cloud.

Performance Testing: Validate performance improvements and identify bottlenecks.

Security Testing: Test for potential security vulnerabilities.


7. Optimization and Monitoring


A. Optimization

Cost Management: Use cloud cost management tools to optimize expenses.

Performance Tuning: Continuously tune performance to ensure optimal operation.


B. Monitoring

Tools: Implement cloud-native monitoring tools like AWS CloudWatch, Azure Monitor, or Google Cloud Operations Suite.

KPIs: Monitor KPIs to ensure the migration meets business goals.


8. Training and Change Management


A. Training

Staff Training: Train staff on new cloud technologies and processes.

Documentation: Provide comprehensive documentation for new workflows.


B. Change Management

Communication: Keep all stakeholders informed about the migration process.

Support: Provide support for users during and after the migration.


9. Continuous Improvement


A. Feedback

Collect Feedback: Regularly collect feedback from users and stakeholders.

Iterate: Continuously improve based on feedback and performance metrics.


B. Updates

Stay Updated: Keep up with cloud provider updates and new features.

Innovate: Leverage new cloud services to innovate and improve business processes.


Conclusion

A well-planned and executed cloud migration strategy can transform legacy systems into agile, scalable, and cost-effective solutions. By following these steps, businesses can ensure a smooth transition to the cloud while minimizing risks and maximizing benefits.

Monday, April 29, 2024

City of Moncton, New Brunswick, Canada

 Nestled along the shores of the Petitcodiac River in New Brunswick, Canada, lies the vibrant city of Moncton. Boasting a rich blend of Acadian charm, cultural diversity, and natural beauty, Moncton offers a unique experience for visitors and residents alike.

At the heart of the city stands its downtown core, where historic architecture mingles with modern amenities. Stroll along Main Street and discover quaint cafes, boutique shops, and lively entertainment venues. The city's bustling market, held in the iconic Aberdeen Cultural Centre, showcases local artisans, farmers, and culinary delights.

Moncton's cultural scene is as diverse as its population. The Capitol Theatre, a grand venue dating back to 1922, hosts world-class performances ranging from Broadway shows to symphony orchestras. Meanwhile, the colourful murals adorning the city's buildings serve as a testament to Moncton's commitment to public art and creativity.

Nature enthusiasts will find solace in Moncton's many parks and green spaces. Centennial Park, spanning over 230 acres, offers endless recreational opportunities, from hiking and biking trails to winter sports like skating and cross-country skiing. And for those seeking adventure, the nearby Magnetic Hill provides an optical illusion that has baffled visitors for generations.

Moncton's sense of community is palpable, with festivals and events held throughout the year. From the lively celebrations of the Acadian Festival to the multicultural extravaganza of the Mosaiq Multicultural Festival, there's always something happening in this lively city.

With its perfect blend of history, culture, and natural wonders, Moncton invites visitors to explore its many treasures and experience the warmth and hospitality of its people. Whether you're a first-time visitor or a longtime resident, Moncton welcomes you with open arms.

Thursday, July 6, 2023

Email send Using Powershell

$username = 'donotreply@domain.com'

$password = 'XXXXXXXXX'

$body = Get-Content -Path C:\Users\Location.txt -Raw

[SecureString]$securepassword = $password | ConvertTo-SecureString -AsPlainText -Force 

$credential = New-Object System.Management.Automation.PSCredential -ArgumentList $username, $securepassword

Send-MailMessage -SmtpServer 2XX.XXX.xx.xx -Port 587 -From donotreply@domain.com -To email@domain.com -Cc email1@domain.com,email2@domain.com -Subject 'EMAIL SUBJECT' -Body $body  -Credential $credential -Attachments "C:\Users\locationfile.txt"; 




Split the same worksheet by Number of rows in XL

 ALT +F11


Split the same worksheet by Number of rows in XL

Past the sheet VBA code on sheet you wanted to split 


Sub SplitData()


Dim WorkRng As Range


Dim xRow As Range


Dim SplitRow As Integer


Dim xWs As Worksheet


On Error Resume Next


xTitleId = "KutoolsforExcel"


Set WorkRng = Application.Selection


Set WorkRng = Application.InputBox("Range", xTitleId, WorkRng.Address, Type:=8)


SplitRow = Application.InputBox("Split Row Num", xTitleId, 5, Type:=1)


Set xWs = WorkRng.Parent


Set xRow = WorkRng.Rows(1)


Application.ScreenUpdating = False


For i = 1 To WorkRng.Rows.Count Step SplitRow


    resizeCount = SplitRow


    If (WorkRng.Rows.Count - xRow.Row + 1) < SplitRow Then resizeCount = WorkRng.Rows.Count - xRow.Row + 1


    xRow.Resize(resizeCount).Copy


    Application.Worksheets.Add after:=Application.Worksheets(Application.Worksheets.Count)


    Application.ActiveSheet.Range("A1").PasteSpecial


    Set xRow = xRow.Offset(SplitRow)


Next


Application.CutCopyMode = False


Application.ScreenUpdating = True


End Sub

Wednesday, October 9, 2013

ORA-01940: cannot DROP a user that is currently logged in

SQL> DROP USER MYUSER CASCADE;

 

ORA-01940: cannot DROP a user that is currently logged in 

 

To Find The Currently Connected Users

 

SQL> SELECT S.SID, S.SERIAL#, S.STATUS, P.SPID 

FROM V$SESSION S, V$PROCESS P 

WHERE S.USERNAME = 'MYUSER' 

AND P.ADDR (+) = S.PADDR;

Important Oracle 11g changes to alter session kill session

Important Oracle 11g changes to alter session kill session

SQL> select inst_id,sid,serial# from gv$session where username='MYUSER';
   INST_ID        SID    SERIAL# 
---------- ---------- ---------- 
         1        36        11593
SQL>  alter system kill session '36, 11593,1'; 
 alter system kill session '36,
11593,1' 
* 
ERROR at line 1: 
ORA-00026: missing or invalid session ID
Now, it works:
SQL>  alter system kill session '36,11593,@1';
Check the jobs on below query
SQL>  select job from dba_jobs where log_user='MYUSER';
no row found

REFERENCE

Else 

SQL>select s.sid, s.serial#, s.status, p.spid from v$session s, v$process p where s.username = 'MYUSER' and p.addr (+) = s.paddr;

SID           SERIAL# STATUS    SPID

----------   ----------    --------       ------------
168               26          INACTIVE 4567318

SQL>!kill -9 4567318           - (kill the process in OS level)


Saturday, October 5, 2013

පැන මඩ කඩිති වැව් තාවලු වැහි කාලේ....

පැන මඩ කඩිති වැව් තාවලු වැහි කාලේ
පෙන්නා මග නොමග නොවැටී යන තාලේ
සිප් කිරි පෙවූ මූසිලයින් උඩු මාලේ
අපෙ ගුරුතුමා යයි තාමත් ඉස්කෝලේ

සාමා අමර විකුණති බස් පොළේ කජු
කුමාරෝද පිටු දන් දෙති එයින් මතු
උගත මනා ශිල්පය පිල් කඩ නොපැතූ
වේවැල වටා ඉකිබිඳ දඬුවමක් පැතූ

රන්මසු පටපිළී අබරණ උරණ වෙලා
සමන්පිච්ච කැකුළිය ගෙයි මිලින වෙලා
ගුරු නිවහනේ කඳුලට උල්පතක් වෙලා
ලොකු හාමිනේ ඇත බිතු සිතුවමක් වෙලා

ගී පද - මහින්ද චන්ද්‍රසේකර
ගී තනු- රෝහණ වීරසිංහ
ගායනය - සුනිල් එදිරිසිංහ