Category: Microsoft SQL Server
Microsoft SQL Server Blog which includes troubleshooting, performance tuning, and database administration guides from an experienced SQL DBA, Peter Whyte.
-
Where My SQL Server Writing Lives Now
The SQL Server side of this blog moved to sqldba.blog: what is over there, how it is organised, and what happens to the Windows and PowerShell material here.
-
Log and Filter sp_who2 Results in SQL Server
When managing SQL Server performance, the built-in sp_who2 procedure is a commonly used tool for quickly checking active processes and their resource usage…
-
How to Filter Objects in SSMS
SQL Server Management Studio (SSMS) offers a quick filtering feature that lets you narrow down your search by criteria such as name, schema, or creation date…
-
SQL Server Script: Enable or Disable All SQL Agent Jobs
SQL Server Agent jobs automate tasks within SQL Server, but there are times when you need to enable or disable multiple jobs, such as during maintenance…
-
How to View the Definition of a Stored Procedure
In this post, I’m sharing some SQL Scripts that will help you view the definition text of Stored Procedures and other objects in SQL Server.
-
SQL Script to Show Exclusive Locks on Tables
In this post I’m sharing a SQL script that will show exclusive locks for all tables in a database, with added info to help you understand what we’re looking at.
-
SQL Server Performance Tuning: Index Fragmentation Scripts
In this post I’m sharing more scripts to help with SQL Server performance tuning. This time, we’re looking at index and heap fragmentation which are useful for…
-
SQL to SQL: A Practical Guide from a DBA
If you’re looking to connect, migrate, or convert between SQL databases, this post is aimed at you.
-
How to Check and Manage SQL Server Services
As a SQL Server DBA, it’s important that we have quick and efficient ways to check SQL Services. We need to ensure our SQL Services are always available, and…
Three guides collect the posts by the job you are doing rather than by date.
PowerShellFiles, CSVs, the firewall, scheduled tasks WSLInstalling it, distros, files across both worlds Windows AdministrationServers, domains, DNS, the tools worth havingThis site started as a SQL Server blog in 2017 and the archive is still here. The new SQL Server writing, and all the scripts, moved to a site of their own.
sqldba.blogScripts, error library, wait types, SSMS- Linux & WSL (28)
- Microsoft SQL Server (51)
- Other (13)
- PowerShell (53)
- Windows Server Admin (38)