Category: Microsoft SQL Server
Microsoft SQL Server Blog which includes troubleshooting, performance tuning, and database administration guides from an experienced SQL DBA, Peter Whyte.
-
Killing SQL Server Processes (SPIDs)
In SQL Server, processes (SPIDs) can sometimes become blocked, leading to performance issues. As a Database Administrator, you may need to terminate such processes to maintain system efficiency. This guide demonstrates how to identify and kill blocking SPIDs. Contents: > Creating a Blocking SPID> Killing a Blocking SPID>…
-
Renaming a computer that hosts SQL Server
When renaming a computer hosting SQL Server, you need to update system metadata to maintain connectivity for remote connections and applications. This process involves updating SQL Server’s registered hostname to match the new computer name. To rename a computer that hosts SQL Server, checkout my latest post on…
-
Installing SQL Server 2017
Installing SQL Server is relatively straightforward, but ensuring proper configuration from the outset helps avoid issues later. This guide walks through the key steps and best practices for setting up SQL Server 2017, highlighting essential pre-installation considerations and post-installation tasks. Before starting, consult Microsoft’s official docs: Planning a…
-
Get Estimated Database Backup/Restore Time Script
This post contains a SQL script to get estimated completion times and process information for your currently running database backups & restores in SQL Server. Backing up a database can often take a very long time. It depends on various factors, one obvious reason being, that the bigger…
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)