In this blog post, we will explore how a comprehensive diagnostic tool like SQL Diagnostic Manager can benefit businesses by saving costs.
SQL Server 2022 – Managing Virtual Log Files
Virtual Log Files (VLFs) are internal divisions of physical log files created by the SQL Server Database Engine. They have no fixed size.
SQL SERVER 2022 and Instant File Initialization for Log File
This blog post will explore how Instant File Initialization for Log File growth events in SQL Server 2022.
SQL Server: How to Display Row Numbers in Query Editor for Efficient Query Editing
Let us learn how to Display Row Numbers in Query Editor for Efficient Query Editing. Comprehensive Database Performance Health Check
SQL SERVER – Reasons – Not Able to Shrink the Transaction Log
Recently during consulting engagement Comprehensive Database Performance Health Check, my client asked if I knew why they could not shrink the transaction log.
SQL SERVER – Find Owner of Database – Change Owner of Database
As there was no owner, it was not possible to open that database in the SSMS. We had to find Owner of the Database and change it later on.Â
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.