SQL Authority with Pinal Dave

Hire Me Free Learning Videos

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

Aug30

SQL SERVER – Types of Triggers

Pinal Dave

SQL Tips and Tricks

SQL Scripts, SQL Server, SQL Trigger

A client of Comprehensive Database Performance Health Check asked me questions about types of triggers. Let us learn about it.

Aug27

SQL SERVER – How to Break Mirroring?

Pinal Dave

SQL Tips and Tricks

SQL Mirroring, SQL Scripts, SQL Server

I am helping my clients with a Comprehensive Database Performance Health Check. Today we will see a very simple script to break mirroring in SQL Server.

Aug26

SQL SERVER – Database Trigger for Index Can Prevent Index Rebuild

Pinal Dave

SQL Performance

SQL Scripts, SQL Server, SQL Trigger

No Comments

Well, the answer is very simple. Today we are going to discuss Database Trigger for Index Can Prevent Index Rebuild. Let us learn it today.

Aug25

Prevent Unauthorized Index Modifications – SQL in Sixty Seconds #183

Pinal Dave

SQL Video

SQL in Sixty Seconds, SQL Scripts, SQL Server, SQL Trigger

Many people asked me to create a video on the same topic, so we have Prevent Unauthorized Index Modifications. Here is the video.

Aug24

SQL SERVER – Prevent Users from Changing Index

Pinal Dave

SQL Tips and Tricks

SQL Index, SQL Scripts, SQL Server, SQL Trigger

No Comments

Many people like this blog post and asked me to follow up questions about whether this method can be used to prevent users from changing the index.

Aug23

SQL SERVER – Trigger on Database to Prevent Table Creation

Pinal Dave

SQL Tips and Tricks

SQL Scripts, SQL Server, SQL Trigger

No Comments

In this blog post, we will be discussing a very interesting scenario of Trigger on Database to Prevent Table Creation. Let us learn today.

Aug20

Quest Database Training Days are Back

Pinal Dave

SQL

Quest

I am very fortunate that I got another opportunity to present for Quest Database Training Days. Yes, it is true that Quest Database Training Days are Back.

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 17 years of hands-on experience. He holds a Masters of Science degree and numerous database certifications.

Pinal has authored 13 SQL Server database books and 40 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,500 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.

October Discount: Comprehensive Database Performance Health Check | Testimonials

SQL SERVER – Types of Triggers

SQL SERVER – How to Break Mirroring?

SQL SERVER – Database Trigger for Index Can Prevent Index Rebuild

Prevent Unauthorized Index Modifications – SQL in Sixty Seconds #183

SQL SERVER – Prevent Users from Changing Index

SQL SERVER – Trigger on Database to Prevent Table Creation

Quest Database Training Days are Back

Exclusive Newsletter