Category Archive

SQL Server

Two files with crossed mappings to a database, representing SQL Server error 5161 file id mismatch

SQL Server Error 5161: An Unexpected File ID Was Encountered and How to Fix It

What SQL Server error 5161 means, why it appears after TempDB or file path changes, and how to fix it...

Server with an old and a new name tag, representing fixing @@SERVERNAME after a rename

Fix @@SERVERNAME After Renaming a SQL Server Host

Why @@SERVERNAME keeps the old name after a Windows rename or VM clone, how to fix it with sp_dropserver and...

Many cubes flowing through a funnel into one block with a bar chart, representing SQL Server aggregate functions

SQL Server Aggregate Functions: COUNT, SUM, AVG, STRING_AGG and the NULL Traps

SQL Server aggregate functions explained: COUNT(*) vs COUNT(1) vs COUNT(column), SUM and AVG traps, NULL handling, GROUP BY and HAVING,...

Keyboard and terminal window, representing the sqlcmd command-line tool for SQL Server

sqlcmd: Running Scripts, Automating Tasks and Practical Tips for SQL Server’s Command-Line Tool

How to use sqlcmd for SQL Server automation: the two versions, key parameters such as -b and -v, scripting variables,...

Database with an open audit logbook, a clock and a shield representing SQL Server Audit

SQL Server Audit: A Production Guide to Setup, Targets and Monitoring

How to run SQL Server Audit properly in production: choosing a target and failure behavior, what to audit, the Always...

ID card, key and locks, representing SQL Server authentication and authorization

SQL Server Authentication vs Authorization: Logins, Users, Roles and Least Privilege

The difference between authentication and authorization in SQL Server: Windows, SQL and Entra ID logins, logins vs users, orphaned users,...

Database with its label being replaced, representing renaming a SQL Server database

How to Rename a SQL Server Database Safely (and Why You Can’t Access It Afterwards)

How to rename a SQL Server database with ALTER DATABASE MODIFY NAME, fix Msg 5030 and login error 4064, rename...

Corrupted SQL Server storage being repaired with clean pages restored from backup

SQL Server Database Corruption: Causes, Warning Signs and How to Recover Without Losing Data

What causes SQL Server database corruption, the 823, 824 and 825 warning signs to watch for, and how to recover...

SQL Server error log with highlighted error lines under a magnifying glass next to a database

SQL Server Error Log: Where to Find It, How to Read It and What to Watch For

Where the SQL Server error log lives, how to read and search it with SSMS and T-SQL, which messages need...

Database with a stopwatch, a filtering funnel and a magnifying glass representing SQL Server Extended Events

SQL Server Extended Events: A Practical Guide to Sessions, Targets and Analysis

How Extended Events works, how session settings affect performance, which target to use when, and ready-to-use sessions for long-running queries,...

Prev 1 … 3 4 5 6 7 … 10 Next