This blog post will cover 11 tips for avoiding common SQL server mistakes. From indexing to security, these tips will help you optimize your database’s performance.
Compressed Backup and Performance – SQL in Sixty Seconds #196
I was recently asked if I have a handy script that can help us take compressed backup and uncompressed backup. Backup and Performance
SQL SERVER – Sample Script for Compressed and Uncompressed Backup
I was recently asked if I have a handy script that can help us take compressed backup and uncompressed backup. Well, of course.
SQL SERVER – Source Database in Restoring State
A client whom I often help with Health Check recently reached out to me with an interesting problem about Source Database in Restoring State.
SQL SERVER – Get Last Restore Date
Let us learn how to get the last restore date for the backup in SQL Server. Here is a very simple script for the same. Let me know your feedback.
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.
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.