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
Sep21

Reading Connection Details in Code: APP_NAME, HOST_NAME and Logins

Pinal Dave
SQL Tips and Tricks
SQL Connection, SQL Login, SQL Server Security
No Comments

An audit row blamed the wrong machine because a label was treated as proof. Here is which connection values you can trust, and which you cannot.

Continue Reading
Sep20

SQL SERVER – Connecting to Azure Storage with SSMS

Pinal Dave
SQL Tips and Tricks
SQL Azure
7 Comments

Connecting to Azure Storage from SSMS takes a few simple steps from Object Explorer. I also show where to find your storage account name and key.

Continue Reading
Sep19

SQL SERVER – SSMS: Index Usage Statistics, Physical Statistics & User Statistics

Pinal Dave
SQL Tips and Tricks
SQL Reports
1 Comment

Creating indexes is a science, not rules of thumb. I look at the SSMS reports for Index Usage Statistics, Physical Statistics and User Statistics.

Continue Reading
Sep18

SQL SERVER – Using the SSIS Term Extraction for Data Exploration – Notes from the Field #046

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

Tim Mitchell shows how SSIS Term Extraction helps with data exploration, so you understand the source data better before you build an ETL process.

Continue Reading
Sep17

SQL SERVER – SSMS: Resource Locking and Object Execution Statistics Report

Pinal Dave
SQL Tips and Tricks
SQL Reports, SQL Scripts, SQL Server
3 Comments

How many times did a procedure run, and how much CPU and IO did it use? The SSMS Resource Locking and Object Execution Statistics reports answer exactly that.

Continue Reading
Sep16

SQL SERVER – Location of Natively Compiled Stored Procedure and Naming Convention

Pinal Dave
SQL Performance
In-Memory OLTP, SQL Memory
2 Comments

Why is it called a natively compiled stored procedure when the code is T-SQL? I explain, and show a DMV query that finds where its DLL is loaded from.

Continue Reading
Sep15

SQL SERVER – Beginning In-Memory OLTP with Sample Example

Pinal Dave
SQL Performance
In-Memory OLTP, SQL Memory
3 Comments

Beginning In-Memory OLTP in SQL Server 2014 is easier than it looks. I explain why we need it in simple words, with a sample example to get you started.

Continue Reading
Previous 1 … 413 414 415 416 417 418 419 … 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