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
Mar7

SQL SERVER – Using Buffer Pool Extension with In-Memory OLTP?

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
In-Memory OLTP
1 Comment
I am always amazed to see the questions asked by my blog reader which lead me to learn more about SQL Server.  Here is the question which took me little time to figure out the answer. If you are new to SQL Server 2014 new features which I have in…
Read More
Mar6

SQL SERVER – ReadOnly Databases with ReadOnly File Attribute

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Backup and Restore
1 Comment
As part of continued series of ReadOny databases, the earlier blog had an interesting comment that read as some people were getting errors of 5120 and others. This got me curious and was in the pending list of solutions in some way. One of the readers had mailed me saying,…
Read More
Mar5

SQL SERVER – Using Raw Files in SSIS – Notes from the Field #070

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Notes from the Field, SSIS
2 Comments
[Notes from Pinal]: SSIS is very well explored subject, however, there are so many interesting elements when we read, we learn something new. A similar concept has been Using Raw Files in SSIS. Linchpin People are database coaches and wellness experts for a data driven world. In this 70th episode…
Read More
Mar4

SQL SERVER – Database Stuck in “In Recovery” Mode After Restart

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Backup and Restore
26 Comments
Read this blog and I am sure it will bring some instances in your environments. This is one of the common issues I have observed while working with SQL Server from long time now. In this blog we will discuss little details about the issue and possible action you might…
Read More
Mar3

SQL SERVER – Security Conversations and Notes with a DBA

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Server Security
No Comments
One of the great things about working in Pluralsight is that I get to meet a lot of people (trust me on this). I am lost for words when it comes to how my day job helps me in achieving some of the coolest things presentations at a number of…
Read More
Mar2

SQL SERVER – Script to Convert Date to Julian Dates

Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Function, SQL Scripts, SQL Server
No Comments

There are many methods to store date values. One of them is Julian date. It is a seven digit number where first four is the year part and the next three digits are the number of days from Jan 01.

Read More
Mar1

Interview Question of the Week #009 – Is GO T-SQL Statement?

Pinal Dave
SQL Interview Questions and Answers
SQL Command, SQL Scripts, SQL Server
13 Comments

I often get this question in the email – more frequently than I would like to get.
Question: “Is GO T-SQL statement?”

Read More
Previous 1 … 371 372 373 374 375 376 377 … 831 Next

SQL SERVER – Using Buffer Pool Extension with In-Memory OLTP?

SQL SERVER – ReadOnly Databases with ReadOnly File Attribute

SQL SERVER – Using Raw Files in SSIS – Notes from the Field #070

SQL SERVER – Database Stuck in “In Recovery” Mode After Restart

SQL SERVER – Security Conversations and Notes with a DBA

Interview Question of the Week #009 - Is GO T-SQL Statement? juliandate-800x300

SQL SERVER – Script to Convert Date to Julian Dates

Interview Question of the Week #009 - Is GO T-SQL Statement? gostatement1

Interview Question of the Week #009 – Is GO T-SQL Statement?

Previous 1 … 371 372 373 374 375 376 377 … 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