While playing with my virtual machine, I encountered an interesting error. In this blog we would learn how to fix error cannot connect to WMI provider [0x80070422] while launching SQL Server Configuration Manager.
How to STOP the Usage of SELECT * For Views? – Interview Question of the Week #193
Question:Â How to STOP the Usage of SELECT * For Views?
SQL Server – Formatted Date and Alias Name in ORDER BY Clause
CONVERT function can be used to change the format of DATE to various formats like MM/dd/yyy, dd/MM/yyy, yyy/MM/dd, etc. But have you ever noticed that this will produce resultset with a different order if the alias name is used in ORDER BY Clause? Well, I just learned about the formatted date from my recent consulting engagement Comprehensive Database Performance Health Check.
Video – Database Performance Analyzer – Table Tuning Advisors
Earlier this week, I blogged about Database Performance Analyzer – Table Tuning Advisors and I received quite a lots of request to elaborate more on the topic of Table Tuning Advisors. In the response to the requests, I have decided to create a video which explains how Table Tuning Advisors of Database Performance Analyzer works. To make it more realistic, I have also included a real-world problem one of my customer whom I have recently helped to fix their SQL Server Performance during Comprehensive Database Performance Health Check.Â
SQL SERVER – Database Performance Analyzer – Table Tuning Advisors
I am a SQL Server Performance Tuning Expert and I consultant with multiple organizations across the world when they have performance tuning issues. I am often showed one or more of the tables of the system and asked to tune system around those tables. The task of table tuning is very challenging.
SQL Authority News – Microsoft Released SQL Server 2019 Preview
The wait is over. Microsoft has just announced SQL Server 2019 Preview in the Ignite conference. Lots of people were wondering if there is going to be any SQL Server 2018. The answer is Microsoft is going to skip this year as a release for SQL Server and will release SQL Server 2019 early next year.
SQL SERVER – Selecting Random n Rows from a Table
Every day I spend a good amount of time with different customers helping them with SQL Server Performance Tuning issues. Today we will discuss the question asked by a developer at the organization where I was engaged in Comprehensive Database Performance Health Check. The developers wanted to know if there is any way he can randomly select n rows from a table.