March 2023 Discount: Comprehensive Database Performance Health Check | Testimonials

  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check
  • Training
optimizedcloud

Optimizing Cloud Costs with Diagnostic Tools: A Business Imperative

March 8, 2023
Pinal Dave
SQL Tips and Tricks
Idera

In this blog post, we will explore how a comprehensive diagnostic tool like SQL Diagnostic Manager can benefit businesses by saving costs.

Read More
Virtual Log Files

SQL Server 2022 – Managing Virtual Log Files

February 28, 2023
Pinal Dave
SQL Tips and Tricks
SQL Log, Transaction Log, VLF

Virtual Log Files (VLFs) are internal divisions of physical log files created by the SQL Server Database Engine. They have no fixed size.

Read More

SQL SERVER 2022 and Instant File Initialization for Log File

February 24, 2023
Pinal Dave
SQL Tips and Tricks
Instant File Initialization, SQL Server 2022, Transaction Log

This blog post will explore how Instant File Initialization for Log File growth events in SQL Server 2022.

Read More
linenumber

SQL Server: How to Display Row Numbers in Query Editor for Efficient Query Editing

February 2, 2023
Pinal Dave
SQL Tips and Tricks
SQL Server, SQL Server Management Studio, SSMS

Let us learn how to Display Row Numbers in Query Editor for Efficient Query Editing. Comprehensive Database Performance Health Check

Read More
shrinklog

SQL SERVER – Reasons – Not Able to Shrink the Transaction Log

August 24, 2022
Pinal Dave
SQL Tips and Tricks
Shrinking Database, SQL Log, SQL Server, System Database

Recently during consulting engagement Comprehensive Database Performance Health Check, my client asked if I knew why they could not shrink the transaction log.

Read More
Find Owner

SQL SERVER – Find Owner of Database – Change Owner of Database

May 3, 2022
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server Security

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. 

Read More

SQL SERVER – Sample Script for Compressed and Uncompressed Backup

March 21, 2022
Pinal Dave
SQL Tips and Tricks
SQL Backup, SQL Scripts, SQL Server

I was recently asked if I have a handy script that can help us take compressed backup and uncompressed backup. Well, of course.

Read More
1 2 3 4 … 526 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

© 2006 – 2023 All rights reserved. pinal @ SQLAuthority.com

Go to mobile version