May 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
Oct14

MySQL – MariaDB – Writing the Very First Stored Procedure

Pinal Dave
SQL
MariaDB, MySQL, SQL Stored Procedure
No Comments

While it was easy to write a stored procedure in SQL Server, for MariaDB and MySQL one has to know a bit of syntax to write the very first stored procedure. 

Read More
Oct13

How to Know If Index is Forced on Query? – Interview Question of the Week #246

Pinal Dave
SQL Interview Questions and Answers
Query Hint, SQL Index, SQL Performance, SQL Scripts, SQL Server
No Comments

Question: How to Know If Index is Forced on Query?

Answer: Let me tell you a brief story so you understand the context of the question.

Read More
Oct12

SQL SERVER Management Studio – ALT Keys Trick to Select Vertical Text

Pinal Dave
SQL Tips and Tricks
SQL Server Management Studio, SQL Shortcut, SSMS
2 Comments

Nicklas Bågvinge sent me a very interesting SSMS tip. Let us learn how we can select vertical text in SSMS using ALT + SHIFT keys.

Read More
Oct11

SQL SERVER Management Studio – ALT + SHIFT Keys Trick to Select Vertical Text

Pinal Dave
SQL Tips and Tricks
SQL Server Management Studio, SQL Shortcut, SSMS
7 Comments

Nicklas Bågvinge sent me a very interesting SSMS tip. Let us learn how we can select vertical text in SSMS using ALT + SHIFT keys.

Read More
Oct10

SQL SERVER Management Studio – Removing Completion Time in Messages

Pinal Dave
SQL Tips and Tricks
SQL Server, SQL Server Management Studio, SSMS
4 Comments

I have received many curious emails and questions while working with clients on Removing Completion Time in Messages. Let us learn them today.

Read More
Oct9

SQL SERVER – Installation Error: 25641- For target, “package0.event_file”, the parameter “filename” passed is invalid. Target parameter at index 0 is invalid

Pinal Dave
SQL
SQL Error Messages, SQL Log, SQL Server, SQL Server Security
1 Comment

While installing SQL Server 2012 in a client environment, they faced an interesting error about for target. Here is the information that is taken.

Read More
Oct8

SQL SERVER Tools I Use and Recommend (Updated: October 2019)

Pinal Dave
SQL
Recommend Tools, SQL Server, SQL Utility, Tools
6 Comments

One of the most popular questions, I had received what tools I use personally when I work with SQL Server. I recommended share my preference.

Read More
Previous 1 … 128 129 130 131 132 133 134 … 830 Next

SQLAuthority News – SQL SERVER 2008 – Updated Brochure Available for Download

SQL SERVER – Fix : Error : Msg 2714, Level 16, State 6 – There is already an object named ‘#temp’ in the database

SQLAuthority News – Top 10 Strategic Technologies for 2009

SQLAuthority News - Launch of Gandhinagar SQL Server User Group Int4

SQL SERVER – IntelliSense Does Not Work – Enable IntelliSense

SQL SERVER – Reseed Identity of Table – Table Missing Identity Values – Gap in Identity Column

SQLAuthority News - Launch of Gandhinagar SQL Server User Group backup4

SQL SERVER – Very Powerful and Feature-Rich Backup, Zip and FTP Utility SQLBackupAndFTP

SQLAuthority News - Launch of Gandhinagar SQL Server User Group MarchUG6

SQLAuthority News – Launch of Gandhinagar SQL Server User Group

Previous 1 … 128 129 130 131 132 133 134 … 830 Next

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 22 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 104 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.


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