Blog Posts

• SQL Script to Get AAG Latency

  November 30, 2024

  In this post, I’m sharing a script that I use frequently as a Production SQL DBA to check Always On Availability Group (AAG) latency. Always On Availability Groups (AAG) are a high-availability and disaster recovery solution in SQL Server, allowing you to synchronize databases across multiple replicas. These…

  Read More

  ---

• SQL Server User Permissions Audit Script

  November 29, 2024

  As a Production SQL DBA, checking user permissions is a task I handle frequently. Whether it’s for proactive audits, troubleshooting access issues, or responding to unexpected requests, having a quick and reliable way to verify user permissions is needed. One of the most useful tools I rely on…

  Read More

  ---

• Creating SQL Logins on an Availability Group (AG) Environment

  November 28, 2024

  In an Always On Availability Group (AG) environment, SQL logins must be configured with consistent Security Identifiers (SIDs) across all replicas to avoid issues like orphaned users and ensure seamless authentication during failovers. For Domain users in SQL, this sync’s automatically and we just need to create the…

  Read More

  ---

• CIDR Conversion Table / Subnet Calculator

  November 27, 2024

  This blog post provides a quick reference table for CIDR notation, subnet masks, and host counts, making it a valuable tool for tasks like configuring security groups, firewall rules, and subnetting. It simplifies network planning and ensures accurate IP address allocation for efficient and secure network setups. CIDR…

  Read More

  ---

• Removing Quotes from Multiple CSV Files in a Directory Using PowerShell

  November 26, 2024

  Managing CSV files often involves cleaning up data before processing. A common task is removing unwanted quotation marks from the contents of CSV files. I wrote a blog post on how to remove quotes from a single CSV file using PowerShell some years ago, which I have just…

  Read More

  ---

• Keeping SQL Server and Critical Systems Up to Date

  November 25, 2024

  Applying the latest patches to SQL Server, Windows OS, and underlying hardware is a vital part of maintaining secure, high-performing systems. For many organizations, this is done on a regular schedule—monthly, quarterly, or aligned with specific maintenance windows. However, for business-critical, 24/7 systems, patching takes extra planning and…

  Read More

  ---

• How to Set the Default Database for SQL Server Users

  November 24, 2024

  This blog post contains a quick guide on how to change your default database when you or your users next log in to SQL Server via SSMS. When you log into SQL Server using SSMS and open a new query window, you will automatically be set to use…

  Read More

  ---

• How to Open SSMS as a Different Domain User

  November 24, 2024

  If you’re working with SQL Server in a corporate environment, you might need to connect to the server using a different Domain User account, opening SQL Server Management Studio (SSMS) as a another user. This may be required if your computer is joined to a different Domain than…

  Read More

  ---

• Troubleshooting Database Mirroring Issues in SQL Server

  November 23, 2024

  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 being left in a Disconnected or In Recovery state. In this article, we’ll share the different methods on how…

  Read More

  ---

• What’s New in SQL Server 2025

  November 22, 2024

  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

  ---