I will be delivering four classes on my most popular training on 21 Essential Scripts: Performance Tuning in Europe in the month of September 2019.
MySQL Preferred Engine – MyISAM or InnoDB
Most of my time is spent with my clients on the Comprehensive Database Performance Health Check. MySQL Preferred Engine – MyISAM or InnoDB
SQL SERVER Management Studio 18 – Enable Dark Theme
We are all techies and we love to use a dark theme in our IDEs. I get quite often a question about how to enable dark theme in SQL Server Management Studio.
Understanding State of SQL Server Monitoring 2019 Report
Earlier Red Gate launched the industry’s first-ever report into the state of SQL Server monitoring. Recently they released Report for the year.
SQL SERVER Management Studio – Completion Time in Messages
When the queries end, we know how long the query ran from the duration of the query but we never know their completion time.
SQL SERVER – Find All Tables Containing Specific Column Name
During the recent Comprehensive Database Performance Health Check, I was asked if I know any trick to identify column with a Specific Name in the database.
How to Use Multiple Hints Together for a Query? – Interview Question of the Week #241
Question: How to Use Multiple Hints Together for a Query?
Answer: Of course, you can use multiple hints for a query. Here is an example of the same.