DBA expertise: PostgreSQL, SQL Server & MySQL
Welcome back to the Deadlock Buster series. Today we’re looking at PSBlitz, a PowerShell tool by Vlad Drumea. PSBlitz runs Brent Ozar’s SQL Server First Responder Kit under the hood to generate a comprehensive SQL Server health report. It’s fast, practical, and built for DBAs who want signal over noise. You can export the results to HTML or Excel for easy review and sharing….
Deadlocks are one of the worst scenarios a DBA will face. They happen when two sessions are fighting for resources and each one is holding a lock the other needs. At that point, the SQL Server engine will choose one session to kill — this is called the deadlock victim. The reality is you cannot eliminate…
As a database grows in size due to frequent insertions, deletions, and updates, even straightforward SELECT queries can become slower. When a table grows to a point where it’s unwieldy, the overall size of the database increases significantly. This is where table partitioning can be incredibly beneficial. Partitioning involves dividing a large table into smaller,…
SQL Server log shipping is one of the DR solutions which involves two or more SQL Server instances; the source server is called the Primary Server and the destination is called Secondary server(s). Log shipping involves the transferring of the transaction log file from the primary server to the secondary server. Log Shipping is a…
Contained Availability Groups (CAGs) in SQL Server 2022 allow you to create an availability group that is independent of the instance, separating logins, jobs, and database mail from the main SQL Server instance. This is particularly useful when you want to create an availability group for a specific application while keeping its authentication and configurations…
here we are referring to lock between deterrent userswhether the need lock how long they hold the locks . locks : the tool is used by SQl server concunrancey is called locks and locks clash in form of blocks there two type of blocks:1.dead locks2. live locks.locks : is tool used by SQL server to put hold…
DBATools is a collection PowerShell command over 700 command that can help DBA to achieve common task in a more automated manner in this section will demonstrate how to install dbatools , and how to use it deferent type of task that include 1- taking backup2- taking script of the job3-migirationand so on install DBATOOLS…