Jun 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
Jan21

SQL SERVER – Backups are Non-negotiable Lifeline for DBAs

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Idera
2 Comments
I have had my share of DBA friends who have told me a number of horror stories from their experiences. Thinking back, these look like moments to laugh away but there are some serious learnings we get from these experiences. I am a personal believer of learning something in everything…
Read More
Jan20

SQL SERVER – How DBAs Have to be Proactive in Identifying and Fixing Problems Before They Happen

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Dell
6 Comments
In real life our dear ones always love to have surprises. If we do things even before they can think, we are in for some fun for rest of the days/weeks. I vividly remember a conversation with my daughter in recent past. I had made a deal to get her…
Read More
Jan19

SQL SERVER – How to Find Weak Passwords Using T-SQL?

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Server Security
1 Comment
Recently one of my blog reader emailed me below question. Hi Pinal, Need your urgent help. In recent past, we have been attacked by the hacker who was able to get in to our SQL Server via sysadmin account and made big damage to our data. To make sure it…
Read More
Jan18

Interview Question of the Week #003 – How to Write Script for Database Cursor?

Pinal Dave
SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks
No Comments
Just another day I heard a senior DBA discussing advantages and disadvantages of the cursor. Well, personally I am a firm believer of the set based operations. However, there are few places where cursors are the only solutions. It is quite possible that different experts have different opinion about cursor;…
Read More
Jan17

SQL SERVER – Watching Table Variable Data in TempDB

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
MySQL
8 Comments
I cannot get enough of working with TempDB and the learning never stops. Previously, when I wrote about SQL SERVER – Is tempDB behaving like a Normal DB?, SQL SERVER – Inside Temp Table Object Creation and Difference TempTable and Table Variable – TempTable in Memory a Myth many did…
Read More
Jan16

SQL SERVER – Configuration and Performance of SQL Server is Now Easy to Master

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
Confio
4 Comments
This is one of the toughest topics to address, and I am always looking at new tools that can help me learn and understand SQL Server better. In many cases, I fall back to MSDN documentation and official statements from the Microsoft site because a lot of R&D generally has…
Read More
Jan15

SQL SERVER – The Easy Functions of SQL Server – Notes from the Field #062

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Notes from the Field, SQL DateTime
2 Comments
[Note from Pinal]: In this episode of the Notes from the Field series database expert Kathi Kellenberger explains about easy and amazing functions of SQL Server. Kathi is an amazing instructor, she was the SQL author I have read in my early career. The reason, I love SQL Server because her writing has…
Read More
Previous 1 … 378 379 380 381 382 383 384 … 831 Next

SQL SERVER – Backups are Non-negotiable Lifeline for DBAs

SQL SERVER – How DBAs Have to be Proactive in Identifying and Fixing Problems Before They Happen

SQL SERVER – How to Find Weak Passwords Using T-SQL?

Interview Question of the Week #003 – How to Write Script for Database Cursor?

SQL SERVER – Watching Table Variable Data in TempDB

SQL SERVER – Configuration and Performance of SQL Server is Now Easy to Master

SQL SERVER – The Easy Functions of SQL Server – Notes from the Field #062

Previous 1 … 378 379 380 381 382 383 384 … 831 Next

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 14 SQL Server database books and 109 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.


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

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