Feb 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
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check
Feb27

SQL SERVER – Dude, Where is the SQL Agent Job History? – Notes from the Field #017

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Notes from the Field, SQL Backup and Restore
6 Comments
[Note from Pinal]: Everybody knows what is SQL Agent Jobs. We know that they run at regular interval and does the task assigned. However, there are way many more things we should know about SQL Jobs but do not know it or never learnt to care about it. One of…
Read More
Feb26

SQL SERVER – Find Anything in Object Explorer in SSMS

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Server Management Studio
9 Comments
This blog post is a follow up post of an excellent write up by my friend Vinod Kumar. I suggest you read his blog post here SSMS Tips–Object Explorer Details. After reading his blog post, I called him up and had an interesting conversation with him. Here is our conversation:…
Read More
Feb25

MySQL – Profiler : A Simple and Convenient Tool for Profiling SQL Queries

Pinal Dave
SQL
Devart, MySQL, SQL Utility
2 Comments
In terms of working with highly loaded databases, any badly-designed request can cause significant performance degradation. Depending on the used DBMS features, various methods are used for query optimization. However, a general rule can be pointed out for all types of DBMS: the fewer server resources are expended when executing…
Read More
Feb24

SQL SERVER – Contest Post – Notes from the Field – Learning Performance Tuning and Database Health

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Notes from the Field
7 Comments
One of the most appreciated and loved the series on SQLAuthority.com is Notes from the Field. I often received how did I come up with the idea behind it. Here is the story for the same. Inceptions of Notes from the Field There are two aspects of any technology 1)…
Read More
Feb23

SQLAuthority News – Two Whitepapers from AzureCAT Team on SQL Database

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
3 Comments
Recently I was reading about SQL Database on Azure. There are lots of confusion around SQL Database around SQL Azure and I have been looking for a good authentic documentation which I can refer as well as I can use that in my day job. After a quick research I…
Read More
Feb22

SQLAuthority News – 4 Whitepapers on Windows Azure

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQL White Papers
1 Comment
Windows Azure is getting quite a lot of traction in the industry and I often get questions about if there is authentic learning on this subject. Microsoft has published following 4 white paper which covers many interesting topics related to SQL Server and Windows Azure. Application Patterns and Development Strategies…
Read More
Feb21

SQL SERVER – Statistical Analysis in SQL Server – A Quick Introduction

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Scripts
1 Comment
SQL Server has very few statistical functions. Oracle has lots of them. XLeratorDB closes the gap. If you want to try out the example of this blog post, I suggest you download the 15-day free trial of XLeratorDB NOW. Most SQL Server users would never think of T-SQL as a…
Read More
Previous 1 … 427 428 429 430 431 432 433 … 829 Next

SQL SERVER – Basics of Delayed Durability in SQL Server 2014

SQL Authority News - Discount Code for for SQL Live! 360 in November delayeddurability

SQL SERVER – How to Setup Delayed Durability for SQL Server 2014?

SQL SERVER – Simple Example of Delayed Durability

SQL SERVER – Delayed Durability Database Level and Transaction Level

SQL SERVER – Video Introduction to Delayed Durability – SQL in Sixty Seconds #074

Hey DBA – Go Make a Proactive Investment Today! – Notes from the Field #045

SQL Authority News – Discount Code for for SQL Live! 360 in November

Previous 1 … 427 428 429 430 431 432 433 … 829 Next

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 22 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 100 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.


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