While writing my previous blogs about SQL Server Configuration Manager, I encountered another error. In this blog, we would learn one of the possible causes of error 0x80010108 – The object invoked has disconnected from its clients.
Free 1 Hour Consulting – PASS Pre-Con 2018 – 21 Essential Scripts: Jump-Start Performance Tuning for Accidental DBAs
Today, I am going to talk about my the most anticipated pre-conference 21 Essential Scripts: Jump-Start Performance Tuning for Accidental DBAs scheduled at PASS Summit 2018. This session is going to be amazing fun and very unique. It is full day demo-oriented learning session.
SQL SERVER – Unable to Launch SQL Server Configuration Manager. Error: Cannot Connect to WMI Provider. [0x80070422]
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 2019 – Oracle JRE 7 Update 51 (64 Bit) or Higher is Required
This is my second blog about SQL Server 2019. My previous blog was about the release announcement of SQL Server 2019 CTP version. SQL Authority News – Microsoft Released SQL Server 2019 Preview. In this blog post, we will discuss about Oracle JRE 7 Update.
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.