May 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
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
swap columns

Swap Columns – SQL in Sixty Seconds #199

August 2, 2022
Pinal Dave
SQL Video
SQL Column, SQL in Sixty Seconds

Today we will see a quick video on how to swap columns in SQL Server. It is a widespread request. We will learn that in this video.

Read More
accessing relational

Accessing Relational Databases in Go at Pluralsight

July 25, 2022
Pinal Dave
SQL
Go Lang, Pluralsight

I just released my 42nd course on the learning platform Pluralsight. It was fun to build this new course Accessing Relational Databases in Go.

Read More
Hybrid Cloud Monitoring

Hybrid Cloud Monitoring

June 28, 2022
Pinal Dave
SQL
Idera, MySQL

AWS, MS Azure and GCP are extremely popular for hosting applications and databases. Let us discuss Hybrid Cloud Monitoring. 

Read More
Real-Time Monitoring of MySQL Server

Real-Time Monitoring of MySQL Server

June 23, 2022
Pinal Dave
SQL
Idera, MySQL

Everyone in the organization wants to know the reasons and resolution. For any DBA, they must know the real-time insight into their server.

Read More
File Based Log Monitoring

File-Based Log Monitoring on AWS MYSQL RDS

June 21, 2022
Pinal Dave
SQL
Idera, MySQL

The way the cloud platform works on Azure is very different from how it operates on Amazon MySQL RDS. Let us learn today.

Read More
MYSQL Long Running Queries

MYSQL Long Running Queries

June 16, 2022
Pinal Dave
SQL
Idera, MySQL

The data that used to be available freely now starts to get locked, and queries sprinting are now turning into long running queries.

Read More
Previous 1 … 3 4 5 6 7 8 9 … 804 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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

Go to mobile version