First, let me clarify, the words in the subject of this blog are the exact words used by my client and whatever you do and say but “customer is always right!”. Here is the complete story where we faced issue related to AlwaysOn Replica.
SQL SERVER – How to Auto Start SQL Followed by a Crash?
Sometimes I do get some quick questions from my existing clients. I try to help them as much as possible. Most of the time, I provide them link to my blog or someone else’s blog. If there is no relevant information based on my search, then I provide them relevant information and write a blog for future reference. This blog is an outcome of one such email communication. Here is the short question about auto start SQL.Â
SQL SERVER – How to Remove TempDB File?
In the last 11 years of blogging, I have never received a question which I have received yesterday. The question which I often receive is about how to add TempDB files in SQL Server but I have never received a question about how to remove a TempDB file.
SQL SERVER – Move Database Files for a Mirrored Database Without Breaking Mirroring
Database mirroring is a very popular solution for high availability. Later on I am finding quite a many people DBAs opting for mirrored databases.
Data Starvation – Balance Your SQL Server – Part 2
In Part 1 I covered how much data your SQL Server should be processing and the effects if it isn’t. Here we check to make sure that you’re achieving that speed. Let us continue learning about data starvation in this blog post.
Learn PowerBI and Advanced Analytics – Instructor-Led and Self Paced Training
If you are reading this blog, you must be aware that I focus on relational database and also in particular for SQL Server Performance Tuning. I always believed that any system in the world can use more performance. Well, while I focused on relational database, I accept that I have focused very little on the subject of PowerBI and Advanced Analytics.Â
SQL SERVER – Compatibility Level 80 and Table Hint Behavior
It has been a while since I worked with SQL Server 2000. However, as an independent consultant, SQL Server never stops to surprise us. Recently, during one Comprehensive Database Performance Health Check, I found a very interesting situation which is about compatibility level 80. If you are not familiar with compatibility level, it sets database behaviors to be compatible with the specified version of SQL Server.
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.