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

May18

SQL SERVER 2016 – Management Studio Highlighting Current Line Option

Pinal Dave

SQL

SQL Server, SQL Server 2016, SQL Server Management Studio

With every new release, there is changes that are being made to the tools that support it. It is tough sometimes to keep up with the pace. I am always an old school guy and I try not to change the style that involves changes to the way things function. When I installed SQL Server 2016 Management Studio, there was something fresh about the IDE, but I was trying to get to terms to why I was feeling little weird. Let us learn about Highlighting Current Line Option in SSMS 2016.

May17

Comparison – Logical Architecture between Oracle and SQL Server

Pinal Dave

SQL

Oracle

Learning is a journey and that is something I love to keep in mind. Even after being so many years in the industry, I don’t stop learning from peers and people around me. This is the best way I can get better at something. I have been writing about the comparisons working with Oracle and SQL Server in the past and I personally thought this was a great way to learn something new by understanding the concepts of something that we always know. The learning is easy when we are able to make an analogy or metaphor as part of our learning. Do you guys ever use a similar approach while learning something that is completely new in your day-today life? Let us learn about Logical Architecture today.

May16

SQL SERVER – Steps to Migrate Clustered Disk / LUN

Pinal Dave

SQL Tips and Tricks

SQL Scripts, SQL Server

This was a clustered instance, so we need to take care of dependency also. Here are the steps which I have outlined for Migrate Clustered Disk.

May15

Primary Key and Null in SQL Server – Interview Question of the Week #071

Pinal Dave

SQL Interview Questions and Answers

SQL Constraint and Keys, SQL Scripts, SQL Server

No Comments

Question: Can Primary Key on any table contain NULL values? Why? Answer: Primary key on any table in SQL Server can not contain a null value.

May14

SQL SERVER – FIX: SQL Profiler Error – Cannot Retrieve Trace Definition for SQL Server Version

Pinal Dave

SQL

SQL Error Messages, SQL Profiler, SQL Server

No Comments

As soon as I opened profiler and clicked on “connect” button, I was welcomed with below the message box. This is one of the funniest error message which I have seen from long time. There is no message!!! Let us see how to fix SQL Profiler Error.

Hitting OK on above, came to below message.

The version shown in the message 13.0.900 is the version of my SQL instance (SQL Server 2016 CTP) on which I was connecting. Here is the text of the second error message.

May13

SQL SERVER – Understanding FAILOVERCLUSTERROLLOWNERSHIP with SQL Server Cluster Rolling Upgrade

Pinal Dave

SQL Tips and Tricks

SQL Server, SQL Server Cluster

I started to hunt in the blog and saw there were a number of posts around (FAILOVERCLUSTERROLLOWNERSHIP) the cluster that caught my eyes:

May12

SQL SERVER – Data Lineage Tracking in ETL Processes – Notes from the Field #124

Pinal Dave

SQL

ETL, Notes from the Field, SQL Server, SSIS

[Notes from Pinal]: Everybody knows about ETL Processes. It is a simple process where data is extracted, transformed and loaded into an application or database. However, still today, not many people know about how to do data lineage tracking in ETL processes.

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.