SQL Server Performance Tuning Expert - SQL Authority with Pinal Dave

AlwaysOn, Computer Network, SQL High Availability, SQL Server, SQL Server Management Studio, SSMS

I have helped many clients in deploying Always On Availability Group. Based on their requirement they keep using additional features provided by availability groups. This time they wanted to use always-on availability group read-only routing feature. Their goal was to offload read-only workload to the secondary replica. This was failing with error: Client unable to establish a connection because an error was encountered during handshakes before login.

Mar22

SQL SERVER – When You Should Not Attend SQL Server Performance Tuning Practical Workshop for EVERYONE?

SQL Performance

SQL DMV, SQL Index, SQL Performance, SQL Training, Workshop

So far many of you know that my SQL Server Performance Tuning Practical Workshop for EVERYONE is extremely popular and it is almost full when I am writing this email. I can now accommodate a maximum of 5 individuals in the class as we are reaching capacity. However, yesterday I received a very interesting email which asked me a specific question about the word EVERYONE. Let us read the exact text of the email so you get a clear idea:

Mar21

SQL SERVER – Stretch Database – Free Trial Subscriptions Can Provision Basic, Standard S0 through S3 Databases, up to 100 eDTU Basic or Standard Elastic Pools and DW100 Through DW400 Data Warehouses

Data Warehousing, SQL Azure, SQL Error Messages, SQL Scripts, SQL Server

I wrote a blog earlier about my first experience (and error encountered) with “Stretch Database” feature. In this blog I would talk about the error – Free Trial subscriptions can provision Basic, Standard S0 through S3 databases, up to 100 eDTU Basic or Standard elastic pools and DW100 through DW400 data warehouses.

Mar20

How to Track Data Platform Service Level and Performance Before and After Consolidation?

SQL Governor, SQL Server

When you are planning data platform consolidation, it is very important to track down the changes in the overall system performance after the actual migration is done. You should understand the differences in the configurations and performance of the instances and databases. Then you will also understand better how well the actual planning work went, and which are the possible challenges in the data platform.

Mar19

SQL SERVER – Error: 825 – A Read of the File at Offset Succeeded After Failing 1 Time(s)

Computer Network, Hardware, SQL Error Messages, SQL Log, SQL Server

One of my clients contacted me to give advice about an error. In this blog, we would discuss error message – A read of the file at offset succeeded after failing 1 time(s)

Mar18

SQL SERVER – Stretch Database – ERROR: The Provided Location is Not Available for Resource Group

SQL Azure, SQL Backup, SQL Error Messages, SQL Server, SQL Server Security

This was my first experiment with this feature called Stretch Database. I have started the wizard and encountered at the very end. Here is the error message.

Mar17

Do Queries Always Respect Cost Threshold of Parallelism? – Interview Question of the Week #216

SQL Interview Questions and Answers

Parallel, SQL Performance, SQL Scripts, SQL Server