This is default featured slide 1 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.This theme is Bloggerized by Lasantha Bandara - Premiumbloggertemplates.com.

This is default featured slide 2 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.This theme is Bloggerized by Lasantha Bandara - Premiumbloggertemplates.com.

This is default featured slide 3 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.This theme is Bloggerized by Lasantha Bandara - Premiumbloggertemplates.com.

This is default featured slide 4 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.This theme is Bloggerized by Lasantha Bandara - Premiumbloggertemplates.com.

This is default featured slide 5 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.This theme is Bloggerized by Lasantha Bandara - Premiumbloggertemplates.com.

Tuesday 1 October 2024

Demo session on "SQL Server Performance Tuning & Query Optimization (L3 Level)"

 Hi SQL DBA's,

Subject: Demo session on "SQL Server Performance Tuning & Query Optimization (L3 Level)" 

=======================

Date: 3rd October, 2024 - Thursday

Schedule

UAE--07:00 PM to 07:45 PM (45 minutes)

IST  --08:30 PM to 09:15 PM (45 minutes)

CDT--10:00 AM to 10:45 AM (45 minutes)

EST--11:00 AM to 11:45 AM (45 minutes)

=======================

Demo Zoom Link: https://us06web.zoom.us/j/85661364918?pwd=H0HBmeM1uzsyEbOi1Cmi8GjyB8AupO.1

Meeting ID: 856 6136 4918

Passcode: 12345

=======================

Actual Session Timings: 

=======================

UAE--07:00 PM to 08:15 PM (1 hour 15 mins) Monday to Friday

IST--08:30 PM to 09:45 PM (1 hour 15 mins) Monday to Friday

CDT--10:00 AM to 11:15 AM (1 hour 15 mins) Monday to Friday

EST--11:00 AM to 12:15 PM (1 hour 15 mins) Monday to Friday

=======================

Total Sessions: 30 (plus)

=======================

Duration: 1 hour 15 mins

=======================

Trainer: Aravinth

Experience: 20 + Years

========================

Training Index: Would be shared during demo session.

========================

Join WhatsApp Group: https://lnkd.in/d4NDEw85

========================

Registration Form: (UPDATED)

https://docs.google.com/forms/d/1tkioqnrc1E0FKqfdKmTkX19WvIibvBueO-2zY1KuIqI/edit

========================

Reach out to me for more details if needed:

Regards,

Praveen Kumar(SQL DBA Champs)

DBA Trainings Coordinator

WhatsApp: +91 98661 30093

Email: praveensqldba21@gmail.com

Tuesday 14 May 2024

Offering my paid mentorship services for SQL Server Database Administration (DBA).

Dear Connection,

I'm Offering my paid mentorship services for SQL Server Database Administration (DBA).

https://www.sqldbachamps.com/telegram/6643a8ebc41d2c0d0d3bfe4f

1. **Assessment and Goal Setting:** 

Begin with an initial meeting to assess the mentee's current skill level, experience, and career goals. Based on this assessment, set specific objectives and milestones for the mentorship program.

2. **Weekly Meetings:** 

Schedule regular meetings (weekly or bi-weekly) to discuss progress, challenges, and learning objectives. These meetings can be conducted via video calls, phone calls, or in-person if feasible.

3. **Technical Guidance:** 

Provide hands-on guidance on SQL Server administration tasks, such as installation, configuration, performance tuning, backup and recovery, security management, and troubleshooting.

4. **Best Practices:** 

Share best practices and industry standards for SQL Server administration. This includes topics like database design, indexing strategies, query optimization, and high availability solutions.

5. **Real-world Scenarios:** 

Present real-world scenarios and case studies to help the mentee apply theoretical knowledge to practical situations. Encourage problem-solving and critical thinking skills.

6. **Professional Development:** 

Offer advice on career development, such as resume building, interview preparation, networking, and staying updated with the latest trends and technologies in the field.

7. **Resource Recommendations:** 

Recommend books, online courses, tutorials, and other learning resources to supplement the mentorship program and support ongoing learning.

8. **Hands-on Projects:** 

Assign hands-on projects and exercises to reinforce learning and provide practical experience. These projects can range from simple tasks to complex database implementations.

9. **Feedback and Support:** 

Provide constructive feedback on the mentee's progress and performance. Offer support and encouragement to help them overcome challenges and reach their goals.

10. **Continuous Improvement:** 

Continuously evaluate and adjust the mentorship program based on feedback and evolving needs. Encourage the mentee to take ownership of their learning journey and strive for continuous improvement.

==============================================

Offer Available for first 100 members and till 30th June 2024.

https://www.sqldbachamps.com/telegram/6643a8ebc41d2c0d0d3bfe4f

==============================================

For more details, contact me at +91-98661 30093 or praveensqldba21@gmail.com

Thanks & Regards

Praveen Madupu

Mb: +971-557753590 (UAE)

WhatsApp: +91-98661 30093

Mail: praveensqldba21@gmail.com

Saturday 11 May 2024

Weekend SQL DBA Training (July-August) 2024

 Weekend SQL Server DBA Training (July-August) 2024

Schedule: 9 AM to 1 PM (Indian Standard Time) - Saturday & Sunday Duration: 4 hours per day (Total 8 weekends)
Total Duration: 64 hours Mode: Online
Fee: Rs 5,000/-\

Registrationhttps://www.sqldbachamps.com/telegram/663f79ce01204179049a59b9 1) SQL Server Installation & Configuration
2) DB Backups & DB Restorations
3) Security
4) Automation of Admin Tasks

5) High Availability & Disaster Recovery
a) DB Log shipping b) DB Mirroring c) DB Replication d) SQL Failover Cluster e) Always on with FCI, with StandAlone 6) SQL Server Upgradations & Migrations
7) SQL Performance Tuning (Basic Level)
8) SQL Server and DB Level Troubleshooting Please reach out to me @ +91 98661 30093 over whatsapp or praveensqldba21@gmail.com for more details.

Wednesday 8 May 2024

Are you passionate about sharing your expertise and helping others learn ?

 **Dear IT Professionals**

Are you passionate about sharing your expertise and helping others learn? 

Do you have valuable knowledge and skills that you'd like to impart to a global audience? 

If so, we invite you to become to become an trainer on our LMS platform: https://www.sqldbachamps.com

SQLDBAChamps is an upcoming online learning platform dedicated to providing high-quality courses in various IT disciplines. 

As a trainer on our LMS platform, you'll have the opportunity to:

- Reach a Global Audience: Share your expertise with learners from around the world who are eager to enhance their IT skills and advance their careers.

- Flexible Schedule: Create and deliver courses on your own schedule, allowing you to balance teaching with your other professional commitments.

- Earn Passive Income: Generate revenue by monetizing your courses through our platform's built-in payment system.

- Build Your Brand: Establish yourself as a thought leader in your field and expand your professional network by connecting with learners and fellow trainers.

Whether you're an experienced IT professional looking to share your knowledge or a seasoned trainer seeking a new platform to reach a broader audience, SQLDBAChamps provides the tools and support you need to succeed.

To get started, please update your details using below link and to get register as an IT Trainer. 

Our user-friendly interface makes it easy to create and publish courses, interact with students, and track your progress.

https://docs.google.com/forms/d/e/1FAIpQLSfMIXI7MRYStTOFK0aOACrm76asK0IJfKNqukFkbFwj6Ij3Dg/viewform?usp=sf_link

Join our community of educators and empower the next generation of IT professionals. 

Together, we can make a difference in the world of online learning.

Thank you for considering this opportunity. We look forward to welcoming you aboard!

Best regards,

Praveen Madupu

Sr SQL Server DBA

Mb: +91 98661 30093

https://www.sqldbachamps.com


Sunday 3 December 2023

Checklist for SQL Server Migration

Migrating a SQL Server instance involves moving databases and settings from one server to another. This process could be part of a hardware upgrade, moving to a new environment, or transitioning to a new SQL Server version. 

Here's a checklist to guide you through the SQL Server migration process:


**1. Assessment and Planning:**

   - Identify the goals and reasons for migration.

   - Document the existing SQL Server environment, including configurations, databases, and settings.

   - Review system requirements for the new SQL Server version.

   - Assess potential challenges and risks.


**2. Backup and Disaster Recovery:**

   - Perform a full backup of all user databases.

   - Backup system databases (master, model, msdb).

   - Document and test the disaster recovery plan.


**3. Create a Migration Plan:**

   - Outline the step-by-step migration process.

   - Identify downtime requirements and plan for minimal disruption.

   - Define rollback procedures in case of issues during migration.


**4. Install SQL Server on the New Server:**

   - Install the desired version of SQL Server on the new server.

   - Apply the latest service packs and cumulative updates.


**5. Configure the New Server:**

   - Set server configurations, including instance settings and security.

   - Configure SQL Server Agent, linked servers, and other components.


**6. Database Migration:**

   - Copy user databases from the old server to the new server.

   - Consider using backup and restore, detach and attach, or database mirroring for migration.

   - Verify the integrity of the migrated databases.


**7. Migrate System Databases:**

   - Migrate system databases (master, model, msdb).

   - Recreate logins and jobs on the new server.


**8. Update Connection Strings and Application Configurations:**

   - Update connection strings in applications to point to the new SQL Server instance.

   - Modify configurations in applications that reference the old server.


**9. Test Applications:**

   - Conduct thorough testing of applications to ensure compatibility with the new SQL Server environment.

   - Verify that stored procedures, queries, and other database interactions work as expected.


**10. Update DNS and Network Configurations:**

   - Update DNS records if applicable.

   - Update any network configurations or firewall rules to reflect the new server.


**11. Monitor and Optimize Performance:**

   - Monitor server performance after migration.

   - Optimize queries and configurations as needed.


**12. Update Documentation:**

   - Update documentation to reflect the changes in the SQL Server environment.

   - Document new configurations, settings, and any modifications made during the migration.


**13. Backup and Monitor Regularly:**

   - Establish a new backup routine on the new server.

   - Implement a monitoring system to track server performance and issues.


**14. Update Maintenance Plans and Jobs:**

   - Review and update SQL Server Agent jobs, maintenance plans, and other scheduled tasks.


**15. Communicate with Stakeholders:**

   - Notify relevant stakeholders about the completion of the migration.

   - Provide information on any changes or actions required on their part.


**16. Perform Post-Migration Checks:**

   - Conduct post-migration checks to ensure data integrity, security, and overall system stability.


**17. Decommission the Old Server:**

   - Once confident in the new server's stability, decommission the old server.


**18. Documentation and Knowledge Transfer:**

   - Update documentation to include any lessons learned during the migration.

   - Transfer knowledge to relevant team members who will be responsible for ongoing support.


Remember that each migration scenario is unique, and you may need to adapt this checklist based on your specific requirements and constraints. Always refer to the official documentation for the version of SQL Server you are working with for any additional considerations or changes in the migration process.

Checklist for SQL Server Inplace Upgrade

 An in-place upgrade of SQL Server involves upgrading an existing instance of SQL Server to a newer version without changing the instance name, server name, or databases. This process can be complex, and it's essential to follow a checklist to ensure a smooth upgrade. 

Below is a checklist you can use for an in-place upgrade of SQL Server:


**1. Review System Requirements:**

   - Verify that the hardware and operating system meet the requirements of the new SQL Server version.


**2. Backup:**

   - Perform a full backup of all user databases.

   - Take a backup of system databases (master, model, msdb).


**3. Document Configuration:**

   - Document server configurations, including instance settings, linked servers, and SQL Server Agent jobs.


**4. Review Deprecated Features:**

   - Check for any deprecated features in the current version that may not be supported in the new version.


**5. Check for Compatibility Issues:**

   - Use the SQL Server Upgrade Advisor to identify any potential issues with the upgrade.


**6. Stop Non-Essential Services:**

   - Stop any non-essential services or applications that might be accessing the SQL Server instance.


**7. Ensure Sufficient Disk Space:**

   - Verify that there is enough disk space for the upgrade process.


**8. Disable Maintenance Plans and Jobs:**

   - Temporarily disable any maintenance plans and SQL Server Agent jobs.


**9. Review and Update Applications:**

   - Check for compatibility with the new version and update applications if necessary.


**10. Check for Blocking Issues:**

   - Identify and address any long-running or blocking queries before the upgrade.


**11. Ensure Windows and SQL Server Authentication:**

   - Confirm that both Windows and SQL Server authentication modes are enabled.


**12. Check Collation Settings:**

   - Ensure that the collation settings for the new version match the existing settings.


**13. Temporarily Disable SQL Server Agent:**

   - Stop the SQL Server Agent service during the upgrade.


**14. Verify Database Compatibility Level:**

   - Ensure that the compatibility level of all databases is suitable for the new SQL Server version.


**15. Validate Linked Servers:**

   - Confirm that linked servers are working correctly.


**16. Check Resource Usage:**

   - Monitor resource usage on the server and address any performance concerns.


**17. Test the Upgrade in a Staging Environment:**

   - Whenever possible, perform a test upgrade in a staging environment to identify and address potential issues.


**18. Review and Apply Service Packs and Cumulative Updates:**

   - Ensure that the latest service packs and cumulative updates for the current version are applied before starting the upgrade.


**19. Document SQL Server Agent Jobs:**

   - Document SQL Server Agent jobs, including schedules and configurations.


**20. Plan for Downtime:**

   - Schedule the upgrade during a maintenance window to minimize downtime.


**21. Perform the Upgrade:**

   - Run the SQL Server setup program and follow the prompts to perform the in-place upgrade.


**22. Post-Upgrade Testing:**

   - After the upgrade, thoroughly test the SQL Server instance and applications to ensure everything is working as expected.


**23. Monitor Performance:**

   - Monitor the performance of the upgraded instance to identify and address any issues that may arise post-upgrade.


**24. Update Statistics:**

   - Update statistics for all databases.


**25. Update SQL Server Agent Jobs and Maintenance Plans:**

   - Re-enable and update SQL Server Agent jobs and maintenance plans as needed.


**26. Verify Backups:**

   - Confirm that backups are functioning correctly after the upgrade.


**27. Communicate with Stakeholders:**

   - Notify relevant stakeholders about the completion of the upgrade.


Remember that this checklist serves as a general guideline, and you may need to customize it based on your specific environment and requirements. Always refer to the official documentation for the version of SQL Server you are upgrading to for any additional considerations or changes in the upgrade process.

Saturday 14 December 2019

Find Status or percentage completed of any DBCC Shrink Databse files

1.First try to find the space used and empty space left in databases


SET NOCOUNT ON

DBCC UPDATEUSAGE(0)

-- DB size.
EXEC sp_spaceused

 --- Table row counts and sizes.
CREATE TABLE #t
(
    [name] NVARCHAR(128),
    [rows] CHAR(11),
    reserved VARCHAR(18),
    data VARCHAR(18),
    index_size VARCHAR(18),
    unused VARCHAR(18)
)

INSERT #t EXEC sp_msForEachTable 'EXEC sp_spaceused ''?'''

SELECT *
FROM   #t

-- # of rows.
SELECT SUM(CAST([rows] AS int)) AS [rows]
FROM   #t

DROP TABLE #t

2. Find the Status or percentage completed of any DBCC Shrink Databse files with below query

SELECT
    percent_complete,
    start_time,
    status,
    command,
    estimated_completion_time,
    cpu_time,
    total_elapsed_time
FROM
    sys.dm_exec_requests
WHERE
    command = 'DbccFilesCompact'