May 2026 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
  • Hire Me
  • Health Check
Sep3

SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Preparing XML in Memory – Day 34 of 35

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Joes 2 Pros, SQL Scripts
36 Comments
Answer simple quiz at the end of the blog post and – Every day one winner from India will get Joes 2 Pros Volume 5. Every day one winner from United States will get Joes 2 Pros Volume 5. Preparing XML in Memory If you want to take XML data and create…
Read More
Sep2

SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Shredding XML – Day 33 of 35

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Joes 2 Pros, SQL Scripts
67 Comments
Answer simple quiz at the end of the blog post and – Every day one winner from India will get Joes 2 Pros Volume 5. Every day one winner from United States will get Joes 2 Pros Volume 5. Shredding XML Our introduction to XML in the last 3 days of…
Read More
Sep2

SQLAuthority News – Programming & Development For Microsoft SQL Server 2008

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Joes 2 Pros, SQLAuthority Book Review
4 Comments
I just can not resist sharing this video which my wife took while I was reading the book I co-authored. After long debate with my wife I have decided to put this video on youtube for public viewing. I initially thought, it is good to just have this in personal…
Read More
Sep1

SQLAuthority News – SQL Wait Stats Joes 2 Pros Book Released Today – 30 Million Views Completed

Pinal Dave
SQLAuthority News
SQL Wait Stats, SQLAuthority Book Review
48 Comments

Happy Ganesh Chaturthi to all the friends of SQLAuthority.com. On today’s auspicious day I have three news to share – 1) Shaivi’s 2nd Birthday 2) New Book Released 3) 30 Millions Views.

Read More
Sep1

SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Using Root With Auto XML Mode – Day 32 of 35

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Joes 2 Pros, SQL Scripts
53 Comments
Answer simple quiz at the end of the blog post and – Every day one winner from India will get Joes 2 Pros Volume 5. Every day one winner from United States will get Joes 2 Pros Volume 5. XML Path Mode The XML Raw and Auto modes are great for displaying…
Read More
Aug31

SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Using Root With Auto XML Mode – Day 31 of 35

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Joes 2 Pros, SQL Scripts
64 Comments
Answer simple quiz at the end of the blog post and – Every day one winner from India will get Joes 2 Pros Volume 5. Every day one winner from United States will get Joes 2 Pros Volume 5. Using Root With Auto XML Mode Now let’s add a root…
Read More
Aug30

SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – What is XML? – Day 30 of 35

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Joes 2 Pros, SQL Scripts
86 Comments
Answer simple quiz at the end of the blog post and – Every day one winner from India will get Joes 2 Pros Volume 5. Every day one winner from United States will get Joes 2 Pros Volume 5. Let’s look at another example from the Employee table.  If you…
Read More
Previous 1 … 563 564 565 566 567 568 569 … 830 Next
SQL SERVER - The Lease between Availability Group 'PRODAG' and the Windows Server Failover Cluster has Expired tempdb

SQL SERVER – DBCC SHRINKFILE: Page 1:26423878 Could not be Moved Because it is a Work Table Page – TempDB Files

SQL SERVER - The Lease between Availability Group 'PRODAG' and the Windows Server Failover Cluster has Expired 10Questions

SQL SERVER – 10 Questions Where YES May Be a Wrong Answer – Performance Health Check

SQL SERVER - The Lease between Availability Group 'PRODAG' and the Windows Server Failover Cluster has Expired listener-error-01

SQL SERVER – AlwaysOn Listener Error – The WSFC Cluster Could Not Bring the Network Name Resource With DNS Name ‘DNS name’ Online

SQL SERVER - The Lease between Availability Group 'PRODAG' and the Windows Server Failover Cluster has Expired identity-01

SQL SERVER – Jump in Identity Column After Restart

SQL SERVER - The Lease between Availability Group 'PRODAG' and the Windows Server Failover Cluster has Expired errorbutton-800x800

SQL SERVER – Could Not Use View or Function ‘msdb.dbo.sysdac_instances’ Because of Binding Errors

SQL SERVER - The Lease between Availability Group 'PRODAG' and the Windows Server Failover Cluster has Expired recoverysuspect-800x403

What is the Difference between SUSPECT and RECOVERY PENDING? – Interview Question of the Week #114

SQL SERVER - The Lease between Availability Group 'PRODAG' and the Windows Server Failover Cluster has Expired AlwaysOn-800x201

SQL SERVER – The Lease between Availability Group ‘PRODAG’ and the Windows Server Failover Cluster has Expired

Previous 1 … 563 564 565 566 567 568 569 … 830 Next

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 22 years of hands-on experience. He holds a Masters of Science degree and numerous database certifications.

Pinal has authored 14 SQL Server database books and 104 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.

Pinal is an experienced and dedicated professional with a deep commitment to flawless customer service. If you need help with any SQL Server Performance Tuning Issues, please feel free to reach out at pinal@sqlauthority.com.

Pinal is also a CrossFit Level 1 Trainer (CF-L1) and CrossFit Level 2 Trainer (CF-L2).


Nupur Dave is a social media enthusiast and an independent consultant. She primarily focuses on the database domain, helping clients build short and long-term multi-channel campaigns to drive leads for their sales pipeline.


Comprehensive Database Performance Health Check

Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.

Once you learn my business secrets, you will fix the majority of problems in the future.


SQL Server Performance Tuning Practical Workshop

Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.

Essentially I share my business secrets to optimize SQL Server performance.


  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com