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.
SQL SERVER – ReadOnly Databases with ReadOnly File Attribute
A reader attached a database that came up ReadOnly and would not switch to ReadWrite. Here is how the ReadOnly file attribute causes it, with repro steps.
SQL SERVER – Using Raw Files in SSIS – Notes from the Field #070
Tim Mitchell explains how using raw files in SSIS helps when data cannot simply be processed on the fly in a single data flow pipeline.
SQL SERVER – Database Stuck in “In Recovery” Mode After Restart
Is your database stuck In Recovery after a SQL Server restart? I explain the analysis, roll forward and rollback phases and what you can do meanwhile.
SQL SERVER – Security Conversations and Notes with a DBA
At a Pluralsight booth, a DBA from the banking world asked me many SQL Server security questions. Here are my notes from those security conversations.
SQL SERVER – Converting YYYYDDD Ordinal Date Codes Safely
This Julian date example uses an ordinal YYYYDDD code. I distinguish that business encoding from an astronomical Julian day number.