Today we are going to learn a very simple and interesting concept used very little. It is about how to Display Dates in Different cultures FORMAT.
SQL SERVER – Replace Rowstore Clustered Index with Columnstore Clustered Index
Let us learn in this blog post how to Replace Rowstore Clustered Index with Columnstore Clustered Index. Comprehensive Database Performance Health Check
Copy Database – SQL in Sixty Seconds #169
At that time I use this technique of copy database while keeping the database online. This method is very simple and efficient.
Video Resources for 9 SQL SERVER Performance Tuning Tips
I had blogged about 9 SQL SERVER Performance Tuning Tips – SQL in Sixty Seconds #168. The video got an amazing response and lots of comments.
9 SQL SERVER Performance Tuning Tips – SQL in Sixty Seconds #168
This episode of SQL in Sixty seconds is very special as it contains 9 SQL SERVER Performance Tuning Tips. The length of the video is also longer.
Slowloris DDoS Attack Mitigation
Slowloris is one of the very popular tools for DDoS attacks and today we will be talking about Slowloris DDoS Attack Mitigation at Pluralsight.
Excel – Sum vs SubTotal – SQL in Sixty Seconds #167
Just like SQL Server, I work with MySQL, PostgreSQL, MariaDB, MongoDB, and Excel. Today we are going to see in excel which is about Sum vs SubTotal.
Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.
Once you learn my business secrets, you will fix the majority of problems in the future.
Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.
Essentially I share my business secrets to optimize SQL Server performance.