This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
Feb12

Scheduling Recurring Events: Every Second Tuesday in T-SQL

Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Function, SQL Scripts, SQL Server
No Comments

Generate recurring events with stable weekday arithmetic, monthly ranking, and anchored fourteen-day rules instead of endless date rows.

Continue Reading
Feb11

SQL SERVER – Cannot Drop the Assembly ‘ISSERVER’, Because it Does not Exist or You do not Have Permission

Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server, SQL Server Security, SQL Upgrade, SSIS
1 Comment

An upgrade could not start SQL Server: Cannot drop the assembly ‘ISSERVER’, because it does not exist or you do not have permission. Here is another way to fix it.

Continue Reading
Feb10

What is Consolidation of Index? – Interview Question of the Week #212

Pinal Dave
SQL Interview Questions and Answers
SQL Index, SQL Performance, SQL Server
1 Comment

What is consolidation of index? When a table has overlapping indexes, like one on Col1 and one on Col1, Col2, here is how I think about combining them.

Continue Reading
Feb9

SQL SERVER – Enabling Older Legacy Cardinality Estimation

Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server Configuration, SQL Statistics
5 Comments

Legacy Cardinality Estimation temporarily stabilized one customer memory-grant problem. A query waited on RESOURCE_SEMAPHORE while the instance became unresponsive.

Continue Reading
Feb8

Current Language of a SQL Server Session: How to Check It

Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Function, SQL Scripts
1 Comment

To find the current language of a SQL Server session, read @@LANGUAGE or @@LANGID, or query sys.dm_exec_sessions. This post tests each one, switches the session to German and British, and shows how the language changes month names and how text turns into dates.

Continue Reading
Feb7

Visual Studio – FIX: The ‘SqlStudio Profile Package’ Package Did Not Load Correctly

Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Profiler, SQL Server, Visual Studio, Windows
1 Comment

Launching Visual Studio on my VM failed with: The ‘SqlStudio Profile Package’ package did not load correctly. I gathered a list of fixes that can solve it.

Continue Reading
Feb6

SQL SERVER – Availability Group Seen in SSMS but missing in Cluster Manager. What’s Wrong?

Pinal Dave
SQL Tips and Tricks
AlwaysOn, SQL Error Messages, SQL High Availability, SQL Scripts, SQL Server, SQL Server Cluster, SQL Server Management Studio
No Comments

A client’s availability group showed in SSMS, but no role appeared in Failover Cluster Manager. Here is the sequence of steps that causes this and what to do.

Continue Reading
Previous 1 … 179 180 181 182 183 184 185 … 846 Next

SQL Server slow? Let's fix it together in about four hours.

Pinal Dave

In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.

You keep every script, and the know-how to fix it yourself next time.

Want your whole team to learn it?

My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.

Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.


Who We Are

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

Pinal has authored 19 books and 125 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 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.


Shaivi Pinalkumar Dave is a book author and a women’s artistic gymnast.

  • Books
  • Testimonials
  • Privacy Policy

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