Earlier I wrote a blog post about how Data Compression for Performance can help improve the efficiency of SQL Server.
Get Current Time Zone – SQL in Sixty Seconds #187
Lots of people often ask me how to get the current time zone in SQL Server when I am working on Comprehensive Database Performance Health Check.
Detecting Memory Pressure – SQL in Sixty Seconds #186
Lots of people who watched the video also asked me to build a similar video. Let us see today a video where I explain how to detect memory pressure.
CPU Running 100% – SQL in Sixty Seconds #185
I got lots of responses to this blog and people wanted me to create a video for this topic. Here, I have a video for CPU Running 100%.
Generate Script of SQL Server Objects – SQL in Sixty Seconds #184
Today we will see the same concept translating in the video. Let us learn about Generate Script of SQL Server Objects in video format.
Prevent Unauthorized Index Modifications – SQL in Sixty Seconds #183
Many people asked me to create a video on the same topic, so we have Prevent Unauthorized Index Modifications. Here is the video.
MAX Columns Ever Existed in Table – SQL in Sixty Seconds #182
Earlier I wrote about SQL SERVER – MAX Columns ID Used in Table and lots of people asked me to create a video on this topic. Let us see the video.