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

Jan5

SQL SERVER – Start Services or Stop Services with PowerShell – Question to Readers?

Pinal Dave

SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks

Powershell, SQL Server

Recently I received a very interesting question- I have no idea about its answer so I will request your help to answer this question.
Question:
“I am using a Powershell script to shutdown SQL Services. Here is the command I use.

Jan4

Developers – Seven Foods Developers Love

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Humor

I am a developer and I have certain food choices. When I look around, I see many more developers and interestingly enough, I have noticed their eating habits very closely. It seems that all the developer has similar taste in food. Here is a quick list of the food which…

Jan3

MySQL – MySQL Query Optimization and Performance Tuning – Online Video Courses

Pinal Dave

SQL Performance

MySQL, Pluralsight, SQL Server, SQL Training

In year 2013, I had focused on MySQL along with SQL Server in database products. As I learn more and more MySQL, I quickly realized that there is no proper course or structured information for MySQL Performance Tuning. I had decided to build a course around common MySQL Performance Problems. I have decided to build the performance tuning course in two parts. 1) MySQL Indexing for Performance and 2) MySQL Query Optimization and Performance Tuning. I had released MySQL Indexing for Performance course earlier this year and right before the end of the year 2013 the second course MySQL Query Optimization and Performance Tuning has released as well.

Jan2

SQL SERVER – Tools for Proactive DBAs – Central Management Server – Notes from the Field #009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SQL Backup and Restore

[Note from Pinal]: This is a ninth episode of Notes from the Fields series. If you are DBA and Developer there is always a situation when you want to execute the same query on multiple servers. This can work out very well if you have a servers in single digit,…

Jan1

SQLAuthority News – Happy New Year 2014 – Resolution of the New Years

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

First of all, happy New Year to all of you – 2014 has started! Every year I make at least one resolution, some I do for the public on my blog. The reason is simple – if I declare something in front of all of you, there is a good…

Dec31

Developers – Top Ten Influential Movies for Developers – Add Your Favourite

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Professional Development, SQL Humor

Today is Dec 31st and last day of the year. I suggest everyone should go out and meet friends & family. At least everyone should spend their time with people they like and have fun with. In past many times, I have gone out to a new years party, however,…

Dec30

SQL SERVER – MySQL – LIMIT and OFFSET – Skip and Return Only Next Few Rows – Paging Solution

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

MySQL, SQL Scripts, SQL Server

Working with MySQL and SQL Server together has its own sets of fun. Here is one example how you can implement paging in MySQL or SQL Server. Both of them have LIMIT and OFFSET mechanism. You can Skip few rows and return few rows from the sorted result set with the help of OFFSET keywords. Let us see how we can do that quickly in the both of the database. We will use AdventureWorks sample database for SQL Server and sakila sample database for MySQL.

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