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

May23

SQL SERVER – Running SSIS Package in Scheduled Job

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Server, SQL Utility

109

I previously wrote article SQL SERVER – Import CSV File into Database Table Using SSIS. I was asked following question by reader that how to run the same SSIS package from command prompt. In response to the same I have written article SQL SERVER – Running SSIS Package From Command Line. Within few minutes of the blog post, I received email from another blog reader asking if this can be scheduled in SQL Server Agent Job.

May22

SQL SERVER – Download PowerPivot Security Architecture Diagram

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

No Comments

Security Architecture Diagram is very interesting and very important aspect of the database. I am currently attending the MVP Open Day event and one of the attendee asked if I can write about PowerPivot Security Architecture. This subject is very well explained earlier using diagram by Microsoft. Microsoft has published…

May21

SQL SERVER – Running SSIS Package From Command Line

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts

May20

SQL SERVER – Management Studio and Browser in Same Application – SSMS Browser

Pinal Dave

SQL Tips and Tricks

SQL Server, SQL Server Management Studio, SQL Utility

First of all – I must confess that I was not aware of this feature till I noticed it today. At home, I have multiple monitors, but when I am traveling, I have single laptop along with me. It is often that when I am working with SQL Server I have to refer web for information on the subject I am working on. Let us understand about SSMS Browser in this blog post.

May19

SQL SERVER – Connecting to Server Using Windows Authentication by SQLCMD

Pinal Dave

SQL Video

SQL Scripts, SQL Server, SQL Utility, sqlcmd

Recently I got a call from an old friend I used to call “DJ”. Here is the exact conversation we had about SQLCMD.

May18

SQL SERVER – FIX – ERROR – Service Logon Failure (ObjectExplorer)

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Scripts

Just another day I received following error while starting my agent. As soon as I received following error I felt like Deja Vu. I had similar feeling few days ago. I quickly looked at my blog post history and I found out following article SQL SERVER – Fix : Error…

May17

SQLAuthority News – Facebook Page and Twitter – Connect Using Social Media

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

I often get question if I am active on social media. I am very much active on social media. I have noticed that we have all are active on Facebook, I have created Facebook page where you can do discussion and follow on my updates. SQLAuthority.com Page I am very…

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.