Jun 2026 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
  • Hire Me
  • Health Check
Mar31

SQL SERVER – How to Detect Schema Change Across Two Servers

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
4 Comments
If you are database developer or database administrator, you will absolutely feel the story. You can download the software discussed in this blog post to play it along. Story of My Early Career A very interesting scenario, I have encountered in my earlier career. In earlier days, we used to…
Read More
Mar30

SQL SERVER – Q and A from Facebook Page

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
No Comments
Social media has changed everything, there were times when we used to send emails but nowadays things have changed. We all have many different ways to connect with each other. Here are a few questions which I have received on the Facebook Page in the month of the march and…
Read More
Mar29

SQL SERVER – SQL Server 2014 Developer Training Kit and Sample Databases

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Documentation, SQL Download
4 Comments
SQL Server 2014 RTM is around the corner (2014). There is plenty of the interest in the SQL Server 2014 in recent time. One of the most frequently asked questions is about learning resources of SQL Server 2014. Everybody wants to learn SQL Server 2014 but there is not enough…
Read More
Mar28

MySQL – Generate Script for a Table Using SQL

Pinal Dave
SQL, SQL Tips and Tricks
MySQL
2 Comments
In SQL Server, to generate the CREATE TABLE script for a table, you need to rely on the SQL Server Management Studio (SSMS) tool and there is no inbuilt function supported to do this using SQL. However, in MySQL you can generate the script for a table using SQL. Let…
Read More
Mar27

SQLAuthority News – Sign up for SQL Authority Low Frequency Newsletter

Pinal Dave
Personal, SQL, SQL Server, SQL Tips and Tricks
2 Comments
One More Newsletter! You might already be receiving our emails in your mailbox, so why should you sign up for SQL Authority Newsletter (Sign-up). Well, a great question. Let me answer this first. Why should you sign up? First of all – it is not going to be a daily…
Read More
Mar26

SQL SERVER – SSIS Execution Control Using Precedence Constraints – Notes from the Field #021

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Notes from the Field, SSIS
No Comments
[Notes from Pinal]: Lots of people think that SSIS is all about arranging various operations together in one logical flow. Well, the understanding is absolutely correct, but the implementation of the same is not as easy as it seems. Lots of people start with lots of enthusiasm, but when it…
Read More
Mar25

MySQL – How to Connect to MySQL Server on Command Prompt

Pinal Dave
SQL, SQL Tips and Tricks
MySQL
2 Comments
I have so far authored 5 courses on MySQL at Pluralsight, and one of the most popular question, I keep on getting is how to connect to MySQL with Command Prompt. You may find it funny enough that people who are learning MySQL would know how to connect to command…
Read More
Previous 1 … 424 425 426 427 428 429 430 … 831 Next

SQL SERVER – How to Detect Schema Change Across Two Servers

SQL SERVER – Q and A from Facebook Page

SQL SERVER – SQL Server 2014 Developer Training Kit and Sample Databases

MySQL – Generate Script for a Table Using SQL

SQLAuthority News – Sign up for SQL Authority Low Frequency Newsletter

SQL SERVER – SSIS Execution Control Using Precedence Constraints – Notes from the Field #021

MySQL – How to Connect to MySQL Server on Command Prompt

Previous 1 … 424 425 426 427 428 429 430 … 831 Next

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


Shaivi Pinalkumar Dave is a book author and a women’s artistic gymnast.

Comprehensive Database Performance Health Check

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.


SQL Server Performance Tuning Practical Workshop

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.


  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com