SQL Server Performance Tuning Expert - SQL Authority with Pinal Dave

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.

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.

An Index Reduces Performance of SELECT Queries (Video)
3 Common Mistakes to Kill SQL Server Performance (Video)
Click here for More Free Videos

For SQL Server Emergency Help, you can reach out to me at pinal@sqlauthority.com with words URGENT in the email subject line for other services mention “Comprehensive Database Performance Health Check“.

Jul21

SQL SERVER – Win USD 11,899 worth MSDN Subscription 5 Days to go

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Best Practices

Few days ago, I had posted content SQLAuthority News – FREE Microsoft Visual Studio 2010 Ultimate with MSDN. It has received tremendous response to them. This competition is still open for 5 more days. I am sure you can win the subscription if you leave the best comment. Win $…

Jul20

SQL SERVER – SELECT * FROM dual – Dual Equivalent

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Oracle

This blog post is for all the Oracle developers who keep on asking for the lack of “dual” table in SQL Server. Here is a quick note about DUAL table, in an easy question-and-answer format. What is DUAL in Oracle? Dual is a table that is created by Oracle together…

Jul19

SQL SERVER – Identifying Statistics Used by Query

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Scripts

“Can I know which statistics were used by my query?” Recently, someone asked this question in my training class of query optimization and performance tuning. I really liked the question. The answer for me is very simple. “No.” Well, if I stop here suggesting only “No,” it will be an…

Jul18

SQLAuthority News – SQL Server Quickstart Downloads from Microsoft

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQL Documentation, SQL Download, SQL White Papers

No Comments

Here are few recent published by Microsoft. Application Platform Optimization SQL Server Migration QuickStart The SQL Server Migration QuickStart includes a comprehensive set of technical content including presentations, whitepapers and demos that are designed to help you get details about how to approach your customers who want to improve the…

Jul17

SQLAuthority News – Community TechDays, Ahmedabad – July 24, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQL Spatial, SQLAuthority Author Visit

Dive deep into the world of Microsoft technologies at the Community TechDays and get trained on the latest from Microsoft. Build real connections with Microsoft experts and community members, and gain the inspiration and skills needed to maximize your impact on your organization while enhancing your career. What more… you…

Jul16

SQL SERVER – Datetime Function TODATETIMEOFFSET Example

Pinal Dave

SQL Tips and Tricks

SQL DateTime, SQL Function, SQL Scripts, SQL Server

Earlier I wrote about SQL SERVER – Datetime Function SWITCHOFFSET Example. After reading this blog post, I got another quick reply that if I can explain the usage of TODATETIMEOFFSET as well.

Jul15

SQL SERVER – Datetime Function SWITCHOFFSET Example

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DateTime, SQL Scripts

I was recently asked if I know how SWITCHOFFSET works. This feature only works in SQL Server 2008. Here is quick definition of the same from BOL: Returns a datetimeoffset value that is changed from the stored time zone offset to a specified new time zone offset. What essentially it…

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 94 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.