SQL Server Performance Tuning Expert - SQL Authority with Pinal Dave

SQL Certifications, SQL Error Messages, SQL Log, SQL Server

Recently I was consulting a customer and they had plans to change certificate used by SQL Server. After making changes to certificate, we found that we were not able to start the SQL Server Service. Let us learn about how to fix error 26014 about unable to load User Specified Certificate.

Oct14

SQL Server – Understanding Connection Timeouts and Query Timeouts

SQL Connection, SQL Server

SQL Tips and Tricks

Have you ever got into a situation wherein you feel you see something and work for a solution in a completely opposite direction? Recently I was out of the country for a session and at the breakfast table I found a dark red bottle of ketchup which I used for my sandwich. Lesser did I know it was actually a spicy sauce. And on closer look this time, I found the mistake I did and how I ruined my whole breakfast. These are times when you oversee something which looks like one and you land up as something completely different. This blog post we will be Understanding Connection Timeouts and Query Timeouts.

Oct13

SQL SERVER – Error – Attempted to Perform an Unauthorized Operation

SQL Error Messages, SQL Server, SQL Setup

As you might know I try hard to help the community via various channels. Comment on my blog is one of that channels. Here is a blog post which talks about error about Unauthorized Operation.

Oct12

SQL SERVER – Msg 3047, Level 16, State 1: The BackupDirectory Registry Key is Not Configured Correctly

SQL Error Messages, SQL Server

While writing my earlier blog, I broke a few settings and started getting new errors. Earlier, when I used to run below command, it used to work fine. However, just a day ago, it has given me error related to the BackupDirectory Registry Key.

Oct11

SQL SERVER – Performance Benefit of Using SPARSE Columns?

SPARSE Columns, SQL Server

I have written a number of blogs around working with SPARSE Columns in the past and a primer to what SPARSE Columns can be got from the list mentioned:

Oct10

SQL SERVER – Error: Property BackupDirectory is Not Available for Settings

SQL Backup, SQL Error Messages, SQL Server

I break a lot of things on my SQL environment and I believe that is a very good way to learn things. Today, I wanted to perform a restore of a database using a backup which I took earlier. In this blog post, let us learn how I fixed Property BackupDirectory is Not Available for Settings.

Oct9

What is a Backup Timeline for Restore Process? – Interview Question of the Week #092

SQL Interview Questions and Answers

SQL Backup, SQL Restore, SQL Server