One of my clients is primarily using SQL Server 2008 R2 for most of their application. SQL SERVER 2008 R2 – I Support You Beyond July 9 2019
SQL SERVER – Global Variable @@DEF_SORTORDER_ID – Old and May be Deprecated
I always blog about things which are new and updated but today we are going to write about something which is very old and it is near deprecated. We are going to about the global variable @@DEF_SORTORDER_ID. Let us see what it is and how it was used once.
Recorded Class Instant Learning – SQL Server Performance Tuning Practical Workshop
There is a huge demand for this workshop as it contains around 3 hours and 49 minutes of unique recorded content which is considered as absolutely Trade Secret for SQL Server Performance Tuning Consultant.
DBA Fundamentals – 3 Performance Tuning Tricks you Always Wanted to Know
Today we will see a free online video which I did for DBA Fundamentals Virtual Chapters for PASS. The title of the video is 3 Performance Tuning Tricks you Always Wanted to Know.
Download SQL Server Management Studio 18.0 (General Availability)
I am really happy that Microsoft has finally announced the general availability of SQL Server Management Studio 18.0. It is the latest version of SSMS available and it works flawlessly with SQL Server 2019 and earlier versions of SQL Server.
How I Know If I am DBOWNER or Not in SQL Server? – Interview Question of the Week #222
Question: How I Know If I am DBOWNER or Not in SQL Server?
SQL SERVER – Performance Monitoring Week – Wrap Up
I absolutely love my job using Comprehensive Database Performance Health Check, which has inspired me to write Performance Monitoring Week.
SQL Server Monitoring Week – SQL Plan Warnings
Today I begin a week-long series where I will be discussing various SQL Server Monitoring Tools. My primary job is to help people with my consulting workshop Comprehensive Database Performance Health Check. While I help the customer with their various SQL Server performance issues, I often see my customers struggle with the monitoring their SQL Server’s health. One of the primary discussion at the end of consultation which we do is what tool is the best for their environment and how it can prevent them to walk into another trouble. Today we will talk about SQL Plan Warnings in brief.
SQL Server Monitoring Week – Spotlight Cloud
Today I begin a week-long series where I will be discussing various SQL Server Monitoring Tools. My primary job is to help people with my consulting workshop Comprehensive Database Performance Health Check. While I help the customer with their various SQL Server performance issues, I often see my customers struggle with the monitoring their SQL Server’s health. One of the primary discussion at the end of consultation which we do is what tool is the best for their environment and how it can prevent them to walk into another trouble. Today we will talk about Spotlight Cloud in brief.
SQL Server Monitoring Week – SQL Monitor
Today I begin a week-long series where I will be discussing various SQL Server Monitoring Tools. My primary job is to help people with my consulting workshop Comprehensive Database Performance Health Check. While I help the customer with their various SQL Server performance issues, I often see my customers struggle with the monitoring their SQL Server’s health. One of the primary discussion at the end of consultation which we do is what tool is the best for their environment and how it can prevent them to walk into another trouble. Today we will talk about SQL Monitor (SM) in brief.