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
Jan22

SharePoint Conference Singapore 2013: A Great Experience

Pinal Dave
SQLAuthority News
Conferences, SharePoint, SQLAuthority Author Visit
2 Comments

I had the great pleasure of presenting at SharePoint Conference Singapore 2013, my second visit to the event. I shared three database tips in a session inspired by SQL in Sixty Seconds, and the room overflowed. Here is my recap, with photographs.

Continue Reading
Jan21

Grandfather-Father-Son Retention: Choosing Which Backups to Keep

Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Scripts, SQL Server
No Comments

Which backups survive when you keep three days, two weeks and two months? A small query answers it, and then you check the real files.

Continue Reading
Jan20

Designing a Date Dimension

Pinal Dave
SQL Tips and Tricks
Business Intelligence, Data Warehousing, SQL DateTime, SQL Server
No Comments

A date dimension makes reporting calendars explicit with fiscal periods, holidays, weekdays, and a repeatable SQL Server build script.

Continue Reading
Jan19

Why Table Size Numbers Disagree: Reserved, Used and Unused Space

Pinal Dave
SQL Tips and Tricks
SQL Data Storage, SQL DMV, SQL Server, SQL Server DBCC
No Comments

Reconcile table size reports by reading reserved, used, data, index, and unused pages from sys.dm_db_partition_stats on SQL Server.

Continue Reading
Jan18

SQL SERVER – A List of Various SQL Server RTM and Service Pack Number

Pinal Dave
SQL Tips and Tricks
Database, SQL Scripts, SQL Server, SQL Service Pack
10 Comments

Which SQL Server version are you running, and is it the latest? My list of RTM and Service Pack Number values to check your production server against.

Continue Reading
Jan17

SQL SERVER – An Interesting Case of Redundant Indexes – Index on Col1, Col2 and Index on Col1, Col2, Col3 – Part 4

Pinal Dave
SQL Tips and Tricks
SQL Index, SQL Scripts
4 Comments

A recap of this case of redundant indexes, from Jon and Mike’s basics to the demos where redundant indexes are useful with small and large result sets.

Continue Reading
Jan16

Configure Database Mail in SQL Server: SQL in Sixty Seconds #039

Pinal Dave
SQL Video
Database Mail, SQL in Sixty Seconds, SQL Server Agent, SQL Server Configuration
3 Comments

To configure Database Mail, you need an SMTP account, a profile and permission to use it. The tests here build all three with T-SQL on SQL Server 2025, show the exact errors for missing access, and follow a failed send through the mail log.

Continue Reading
Previous 1 … 504 505 506 507 508 509 510 … 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