In today’s blog post we will discuss one of the most popular questions I receive – Why Do I Give All the Performance Tuning Scripts to My Customers?
Consulting 103 – Why Do I Assure SQL Server Performance Optimization in 4 Hours? – SQL Server Performance Tuning
In today’s blog post we will discuss one of the most popular questions I receive – Why Do I Assure SQL Server Performance Optimization in 4 Hours?
Consulting 102 – Why Do I Give 100% Guarantee of My Service? – SQL Server Performance Tuning
In today’s blog post we will discuss one of the most popular questions I receive – Why Do I Give 100% Guarantee of My Service?
Consulting 101 – Why Do I Never Take Control of Computers Remotely? – SQL Server Performance Tuning
In today’s blog post we will discuss one of the most popular questions I receive – Why Do I Never Take Control of Computers Remotely?
How Does QUOTED_IDENTIFIER Works in SQL Server? – Interview Question of the Week #217
Question: How Does QUOTED_IDENTIFIER Works in SQL Server?Answer: If you search on the internet, you may find quite lots of notes about it. So in this blog post, I will explain in very simple words.
SQL SERVER – Read Only Routing Error: Client Unable to Establish Connection Because an Error was Encountered During Handshakes Before Login
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.
SQL SERVER – When You Should Not Attend SQL Server Performance Tuning Practical Workshop for EVERYONE?
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:
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
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.
How to Track Data Platform Service Level and Performance Before and After Consolidation?
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.
SQL SERVER – Error: 825 – A Read of the File at Offset Succeeded After Failing 1 Time(s)
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)