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
May7

SQL SERVER – Using Package Configurations in SSIS 2012 and Beyond – Notes from the Field #079

Pinal Dave
SQL Tips and Tricks
Notes from the Field, SQL Server, SSIS
No Comments

Moving to SSIS 2012 or 2014 and worried about losing the Package Configurations you built? Good news: the classic option is still there. Here is how to use it.

Continue Reading
May6

SQL Server – Knowing the Use of Deprecated or Discontinued Features

Pinal Dave
SQL Tips and Tricks
SQL Deprecated Feature
5 Comments

After an upgrade, a DBA’s management asked if any deprecated or discontinued features were still in use. Here is how to find that out on a live server.

Continue Reading
May5

SQL SERVER – Generating Row Number Without Ordering Any Columns

Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server
75 Comments

ROW_NUMBER needs an ORDER BY clause, but what if you do not want to sort by any column? Here is a simple trick to generate a row number without ordering.

Continue Reading
May4

SQL SERVER – Who ALTER’ed My Database? Catch Them Via DDL Trigger

Pinal Dave
SQL Tips and Tricks
4 Comments

A reader’s database kept switching back to compatibility level 80 every day. Here is how a DDL trigger can catch who ALTERed the database and when.

Continue Reading
May3

Interview Question of the Week #018 – Script to Remove Special Characters – Script to Parse Alpha Numerics

Pinal Dave
SQL Interview Questions and Answers
SQL Function, SQL Scripts
No Comments

Remove special characters with a corrected SQL Server loop and a 2025 regex expression, while defining ASCII and collation rules.

Continue Reading
May2

Great Indian Developer Summit 2015: Three SQL Sessions and a CPU Check

Pinal Dave
SQLAuthority News
GIDS, SQL CPU, SQL Performance
No Comments

Great Indian Developer Summit 2015 brought me to Bangalore and Hyderabad for three SQL Server sessions. This page keeps the dates, topics and photos. It also adds a CPU check I would start with today, tested on SQL Server 2025, because one session was about CPU performance.

Continue Reading
May1

SQL AZURE – How to Disable and Enable All Constraint for Table and Database

Pinal Dave
SQL Tips and Tricks
SQL Azure
3 Comments

sp_msforeachtable does not work in Azure SQL Database. Here is how to disable and enable all constraint for table and database in SQL Azure using DMVs.

Continue Reading
Previous 1 … 378 379 380 381 382 383 384 … 847 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