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.
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.
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.