How do you know if SQL Server is listening on a fixed or dynamic port? Here is a script that reads the TcpDynamicPorts registry value for your instance.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Interesting Function AGENT_DATETIME
AGENT_DATETIME in msdb converts integer date and time values in YYYYMMDD and HHMMSS format into a datetime. Here is how it works, with examples.
SQL SERVER – The Basics of the File System Task, Part 1 – Notes from the Field #071
Andy Leonard explains the basics of the SSIS File System Task, a handy tool when loading data to and from flat files. This is part 1 of the series.
SQL SERVER – Error – Msg 6401, Level 16: Cannot roll back Transaction
Is there such a thing as nested transactions in SQL Server? A simple demo shows why rolling back a named inner transaction fails with Msg 6401.
SQL SERVER – FIX – A connection cannot be made to redirector. Ensure that ‘SQL Browser’ service is running. (Microsoft.AnalysisServices.AdomdClient)
I opened SQL Server Management Studio and instead of a database engine. Below is the error which I received for SQL Browser:
Add a User Across Databases: A Tested Script With Cleanup
To add a user across databases you need one login and, in every chosen database, a user and a role. This post gives a tested script that does it, checks it and removes it again on SQL Server 2025. It also answers the model database question and shows the server-level shortcut.
Interview Question of the Week #010 – What is the Difference Between Primary Key Constraints and Unique Key Constraints?
Compare primary keys and unique key constraints in SQL Server, including NULL rules, foreign keys, and filtered unique indexes.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.