Recently I had a very interesting scenario with a client when they faced an error about already object named that exist in the database.
SQL SERVER – Convert Date Time AT TIME ZONE
My client last week about Comprehensive Database Performance Health Check. The question was how to Convert Date Time AT TIME ZONE.
Multiple Backup Copies Stripped – SQL in Sixty Seconds #156
Yesterday I blogged about SQL SERVER – Creating Multiple Backup Copies. I got an amazing response to the blog post. Let us learn it today.
SQL SERVER – Creating Multiple Backup Files – Stripped
One of my long-term clients (Comprehensive Database Performance Health Check) recently asked me question if I know a way of creating multiple backup files.
SQL SERVER – AlwaysOn and Propagation of Compatibility Level
It is not possible to Propagation of Compatibility Level in AlwaysOn or mirroring from primary to secondary mirroring. Let us learn it today.
SQL SERVER – STRING_ESCAPE() for JSON – String Escape
Well, in situations like this we should consider using the function STRING_ESCAPE() which works for JSON. Let us quickly discuss String Escape.
Forwarded Records and Performance – SQL in Sixty Seconds #155
Earlier I wrote a blog post on Forwarded Records and Performance and lots of people liked the blog post. Here is you can read the blog post SQL SERVER – What is Forwarded Records and How to Fix Them?
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.