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
May22

SQL SERVER – Windows File/Folder and Share Permissions – Notes from the Field #029

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Notes from the Field, SQL Server Security
2 Comments
[Note from Pinal]: This is a 29th episode of Notes from the Field series. Security is the task which we should give it to the experts. If there is a small overlook or misstep, there are good chances that security of the organization is compromised. This is very true, but…
Read More
May21

MySQL – Scalability on Amazon RDS: Scale out to multiple RDS instances

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
MySQL, SQL Server
3 Comments

Today, I’d like to discuss getting better MySQL scalability on Amazon RDS.
The question of the day: “What can you do when a MySQL database needs to scale write-intensive workloads beyond the capabilities of the largest available machine on Amazon RDS?”

Read More
May21

SQL SERVER – Reset SA Password – SQL in Sixty Seconds #066

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQL Video, SQLAuthority News
Joes 2 Pros, SQLAuthority Book Review
3 Comments
It has been quite a long time since I posted SQL in Sixty Seconds Video. Here we are back with the new video. One of the most popular question, I often receive is very similar to following: “How do I reset the password for SA username?” “I have forgotten the…
Read More
May20

SQL SERVER – 3 Challenges for DBA and Smart Solutions

Pinal Dave
SQL
Devart, MySQL, SQL Utility
2 Comments

Developer’s life is never easy. DBA’s life is even crazier. Let us see in this blog post 3 Challenges for DBA and Smart Solutions.

Read More
May19

SQL SERVER – CTE can be Updated

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
CTE, SQL Scripts, SQL View
16 Comments
Today I have received a fantastic email from Matthew Spieth. SQL Server expert from Ohio. He recently had a great conversation with his colleagues in the office and wanted to make sure that everybody who reads this blog knows about this little feature which is commonly confused. Here is his…
Read More
May18

SQL SERVER – Migration Assistant Upgraded to Support SQL Server 2014

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
MySQL, SQL Documentation, SQL Download
2 Comments
We all start somewhere when it is about database. There are different reasons, why we go for one database over another database. Usually the reason is cost and convenience. After a period of time when business is successful and traffic is growing, the same two reasons of cost and convenience…
Read More
May17

Developer’s Life – Every Developer is a Spiderman

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Developer, Superhero
7 Comments
I have to admit, Spiderman is my favorite superhero. The most recent movie recently was released in theaters, so it has been at the front of my mind for some time. Spiderman was my favorite superhero even before the latest movie came out, but of course I took my whole…
Read More
Previous 1 … 416 417 418 419 420 421 422 … 831 Next

SQL SERVER – Windows File/Folder and Share Permissions – Notes from the Field #029

Developer's Life - Every Developer is a Spiderman MySQLScaleAWS

MySQL – Scalability on Amazon RDS: Scale out to multiple RDS instances

SQL SERVER – Reset SA Password – SQL in Sixty Seconds #066

Developer's Life - Every Developer is a Spiderman i10

SQL SERVER – 3 Challenges for DBA and Smart Solutions

Developer's Life - Every Developer is a Spiderman cteupdate2

SQL SERVER – CTE can be Updated

SQL SERVER – Migration Assistant Upgraded to Support SQL Server 2014

Developer’s Life – Every Developer is a Spiderman

Previous 1 … 416 417 418 419 420 421 422 … 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