Author: Peter Whyte
-
Open SSMS as a Different Domain User
🛠️Part of the SSMS Complete Guide, installing, configuring and fixing SQL Server Management Studio. When working in corporate SQL Server environments, you will often need to connect using a different Active Directory domain account. Common reasons include: SQL Server Management Studio (SSMS) does not allow switching users inside the connection dialog. To connect as another…
Written by
-
Working with SQL Server Database Master Keys
SQL Server uses an encryption hierarchy to protect secrets such as credentials, asymmetric keys and certificates. At the database level, that hierarchy is anchored by the database master key (DMK). Because all other encrypted objects depend on it, losing access to the DMK can render those objects unusable. This post walks through how to: It also…
Written by
-
Check SQL Server Connection Encryption and Protocol
Modern SQL Server environments often use encrypted connections by default, but that does not always mean what people think it means. When troubleshooting connectivity problems, certificate errors, performance questions, or unexpected client behaviour, DBAs usually need to answer one very specific question: What protocol and encryption is this connection actually using right now? This post…
Written by
-
How to Check SQL Server Version
Knowing exactly which SQL Server version and build is running is foundational DBA work. It comes up during patching, incident response, audits, upgrades, and when engaging Microsoft support. SQL Server exposes version information in several ways. Some are fast and visual, others are scriptable, and a few provide deeper installation detail when you need it.…
Written by
-
sqlcmd Examples for SQL Server
sqlcmd is a command line utility for connecting to SQL Server and executing Transact-SQL without a GUI. It is commonly used for automation, scripting, remote administration, and incident response, especially in environments where SSMS is unavailable, inappropriate, or too heavy. This post covers sqlcmd usage from a DBA perspective, how to find or install it,…
Written by
-
Install and Update SQL Server Management Studio (SSMS)
🛠️Part of the SSMS Complete Guide, installing, configuring and fixing SQL Server Management Studio. SQL Server Management Studio (SSMS) is the primary management tool for SQL Server and Azure SQL, and it’s also the official download and update path for SSMS going forward. In recent releases it’s changed significantly, not in how it looks, but…
Written by
-
SSMS Certificate Chain Not Trusted Error (Trust Server Certificate Fix)
🚨Part of the SQL Server Errors series, the exact messages and what actually causes them. If you have upgraded SSMS or a driver recently and a connection that worked yesterday has stopped working today, this is almost certainly what you are looking at. Nothing changed on the server. The client got stricter, and it is…
Written by
-
SQL Server Default Ports
SQL Server listens on TCP 1433 by default, and on a box running a single default instance that is usually the end of it. It stops being true as soon as anything else is going on. A named instance takes a dynamic port that can change when the service restarts, which is the whole reason…
Written by
-
Check When SQL Server Was Last Restarted
Knowing when SQL Server last restarted is one of the simplest checks a DBA can perform, and one of the most useful. It immediately answers questions around patching, failovers, configuration changes, and unexplained behaviour. Before assuming anything else, confirming uptime is always worth doing first. This post shows the most reliable way to check SQL…
Written by
-
Using PowerShell to Get Last SQL Failover Time
When reviewing availability events on SQL Server, one of the first questions is often: Did the cluster move, and when? This post shows how to use PowerShell to retrieve the last Windows Failover Cluster role movement for a SQL Server instance by querying cluster event logs. It’s a fast, reliable way to confirm node-level failovers…
Written by
Start Here
- DBA Scripts: The Complete Guide
- Run a Full Health Check
- DBA Scripts & Tools
- SSMS: The Complete Guide
- SQL Server Errors: The Complete Guide
- Wait Types Library
The Pillars
Blog Categories
- Backups & Recovery (16)
- DBA Scripts (151)
- High Availability (HA) (12)
- Installation & Configuration (38)
- Maintenance (24)
- Migration & Upgrades (14)
- Monitoring (6)
- Performance Tuning (35)
- Security (Encryption & Permissions) (20)
- Storage & Capacity (14)
- T-SQL Fundamentals (11)
- Troubleshooting (54)
- Wait Types (235)
Latest Posts
- SQL Server Login Migration: What Gets Silently Left Behind
- CREATE USER WITHOUT LOGIN vs Contained Database Users
- The sqldba MCP Server: Give Your AI Assistant a Verified SQL Server Reference
- Cannot Resolve the Collation Conflict (Error 468)
- Logical Consistency-Based I/O Error in SQL Server (Errors 823 and 824)
- Cannot Recover the Master Database (Error 3417) and What the Log Actually Says
Blog Tags
Access (4) Always On Availability Groups (4) Auditing (7) Backups (6) Blocking (4) Blocking Locking (6) Collectors (7) Database Backups & Recovery (8) Database Backups and Recovery (5) Database Maintenance (7) DBA Tools (24) Disk Space (5) Error Log (3) Extended Events (8) Features (6) High Availability (6) Indexes (7) Installation (7) Inventory (8) Maintenance (6) Migration (14) Monitoring (27) Performance (21) Performance Troubleshooting (9) PowerShell (4) Query Behaviour (5) Security (10) SQL Agent (5) SQL Scripts (17) SQL Server Administration (10) SQL Server Configuration (7) SQL Server Errors (5) SQL Server High Availability (4) SQL Server Internals (3) SQL Server Management Studio (SSMS) (6) SQL Server Monitoring (7) SQL Server Networking (9) SQL Server Security (7) Storage and Capacity (7) T-SQL (10) Temp DB (3) Tracing (7) Transaction Logs (4) Troubleshooting (24) Windows Server (4)