Category: Microsoft SQL Server
Microsoft SQL Server Blog which includes troubleshooting, performance tuning, and database administration guides from an experienced SQL DBA, Peter Whyte.
-
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. Ways to Query Stored Procedure Text Like a lot of tasks in MSSQL, there’s various ways we can get this information, including:> sys.sql_modules:…
-
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. Exclusive locks are a natural thing in SQL Server which ensures data integrity during updates or deletions by…
-
How to Get SQL Server’s IP Address
When managing or troubleshooting SQL Server, you might need to get the IP address your SQL Server instance is listening on. While servers can listen on multiple IP addresses, SQL Server offers a straightforward way to determine which address is used for your current connection. In this post…
-
Identify Missing & Unused Indexes in SQL Server
Indexes are crucial for SQL Server query performance. Everyone needs an Index. However, improper indexing strategies can degrade database performance, leading to slow queries and cause resource bottlenecks. Effectively managing indexes involves not only identifying the missing ones that could improve performance, but also pinpointing unused indexes that…
-
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 pinpointing inefficiencies on your database. Fragmentation, whether in indexes or heaps, can lead to slower queries, inefficient storage, and increased maintenance…
-
Show User Activity and Blocking in SQL Server
In this post I’m sharing a SQL script that will show currently running and blocking queries in SQL Server, with some other useful info along the way. This is script I run often as a DBA. It’s useful for identifying blocking or long running transactions, or checking in…
-
Download and Install SQL Server Management Studio (SSMS)
In this short post, I’ll share how to easily download and install SQL Server Management Studio (SSMS) on your Windows computer. I’ll include some tips to help improve your SSMS experience too! Step 1: Download SSMS Go to the official Microsoft website to download the latest version of…
-
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. Whether you’re working with SQL Server, MySQL, PostgreSQL, or others, I’m hoping to help explain some common tasks you might need to perform. Contents: > Connecting SQL Databases > Linked Servers:…
-
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 we often need to restart or make changes to them in SQL Server Configuration Manager. This includes the SQL…
Categories
- Linux & WSL (26)
- Microsoft SQL Server (103)
- Other (13)
- PowerShell (50)
- Windows Server Admin (44)
Tags
Always On Availability Groups (AAG) (4) AWS (4) AWS Redshift (6) Database Admin (72) Database Backups & Recovery (14) Database Mirroring (2) Error Messages (5) Failover Cluster Instances (FCI) (1) Git Commands (6) Importing & Exporting Data (2) Linked Servers (3) Linux Administration (2) Logging & Monitoring (1) Microsoft Patching (2) MySQL (4) Postgres (6) PowerShell Scripts (2) SQL Certificates & Encryption (3) SQL Server Agent (5) SQL Server CDC (2) SQL Server Data Types (2) SQL Server Management Studio (SSMS) (17) SQL Server Networking (3) SQL Server on Linux (1) SQL Server Patching (2) SQL Server Performance Tuning (6) SQL Server Processes (SPIDs) (7) SQL Server Replication (2) SQL Server Scripts (13) SQL Server Security (4) SQL Server Storage (10) Windows Admin (20) Windows Authentication (2) Windows Automation (1) Windows Events (2) Windows Firewall (4) Windows Subsystem for Linux (WSL) (18)