SQL DBA Blog

  • Troubleshooting Database Mirroring Issues in SQL Server

    This article contains various ways for resolving database Mirroring issues in SQL Server, guiding you through the troubleshooting process. Maintaining high availability and data integrity in a SQL Server environment is one of the main priorities as a SQL DBA. One issue we may encounter is Mirrored databases…

    Read More

  • What’s New in SQL Server 2025

    Microsoft announced SQL Server 2025 at Microsoft Ignite, with major new features focused on AI and integrating Azure SQL DB capabilities into on-premises servers. Check out this Microsoft Announcement post for more information: Announcing Microsoft SQL Server 2025: Enterprise AI-ready database from ground to cloud Key Features –…

    Read More

  • Time To Revive This Blog

    As per title, I’m keen to revive this blog here at https://peter-whyte.com. I haven’t been publishing regularly for over a year, and it’s been many years since I changed the theme/design. So here we go, a new theme is in-place, updates are underway to improve the overall design,…

    Read More

  • How to Set Environment Variables in PowerShell

    Environment variables store key information on your system that programs can use to influence their behavior. For example, the AWS CLI uses the AWS_REGION variable to determine the region for API requests. This guide will cover:– Listing all environment variables– Retrieving the value of a specific environment variable–…

    Read More

  • How to Kill SPIDs in SQL Server

    In SQL Server, Session Process IDs (SPIDs) play a crucial role in identifying and managing SQL connections. The KILL (SPID) command serves as a tool for terminating troublesome sessions. This blog post provides an overview of the KILL command and its practical applications. The following is included in…

    Read More

  • How to Get Environment Variables on Windows

    Environment variables in Windows contain information about the system’s environment, such as the directories containing executables or the system’s PATH. Programs can use these variables to find resources on the computer. They can be set at the system level or for individual user accounts and can be modified…

    Read More

  • Git Log Author Command Example

    If you’re a Git user, you’ll be familiar with the git log command, which allows you to view the commit history for a repository. This blog post is to share an extra tip while using the command, utilising the –author parameter which allows you to filter the commits…

    Read More

  • Git Log Command Examples

    Git log is an essential command when working with git version control. It allows you to see the history of a repository, including details about each commit like the author, date, and commit message. It lets you know what’s changed, when it changed and by who. In this…

    Read More

  • How to Install PowerShell on Ubuntu 20.04

    This post is a guide on installing PowerShell on Ubuntu 20.04. The Ubuntu Linux distribution being used in this demo is running as a Windows Subsystem for Linux (WSL) instance. I have not yet encountered issues with the PowerShell, Ubuntu and WSL cocktail. Be sure to check out…

    Read More

  • How to Check Your SQL Server Version

    This post contains various ways for how to check the running Microsoft SQL Server version numbers, including: – Check SQL Version in SSMS Object Explorer – SQL Query to get SQL Version Info – Check SQL Server Log Files– Run the SQL Server Feature Discovery Report Why Check…

    Read More

Useful SQL DBA Posts

Performance & High Availability
– Get Full SQL Server System Info Fast
– Quick Performance Troubleshooting Scripts
– Identify Missing & Unused Indexes
– Get Wait Stats & Top Consuming Queries
– Get Exclusive Locks on Tables
– Get Always On Availability Group (AAG) Latency
– Get Mirroring Status & Latency
– Get Replication Latency
– Get Last Node Blip in SQL Server FCI
Security & Maintenance
– Get Estimated Database Backup/Restore Time
– Get Last Database Backup Dates/Times
– Get Database Sizes & Space Used
– How to Get Table Sizes
– Get Index & Heap Fragmentation Levels
– Get SQL User Permissions and Roles
– Creating SQL Users on Availability Groups
– Audit Failed Login Attempts

Categories

– Microsoft SQL Server
– Windows Server
– PowerShell
– Linux & WSL
– Other

Tags

Always On Availability Groups (AAG) (4) Certificates & Encryption (3) Change Data Capture (CDC) (2) Database Admin (76) Database Backups & Recovery (14) Database Mirroring (2) Deleting Data (1) Error Messages (5) Git Commands (5) Importing & Exporting Data (2) Linked Servers (3) Linux Admin (2) Logging & Monitoring (1) Measuring Databases (10) Microsoft Patching (2) PowerShell Scripts (1) SQL Server Agent (5) SQL Server Database Files (1) SQL Server Data Types (2) SQL Server Management Studio (SSMS) (15) SQL Server Network Connectivity (3) SQL Server on Linux (1) SQL Server Patching (2) SQL Server Performance (5) SQL Server Permissions (2) SQL Server Processes (5) SQL Server Replication (2) SQL Server Scripts (13) Windows Admin (21) Windows Authentication (2) Windows Automation (1) Windows Events (2) Windows Firewall (4) Windows Subsystem for Linux (WSL) (19)