Have you ever found yourself with the need to copy SQL Server logins from one server to another? It'll come in handy if you're setting up a failover site, building a replacement server, setting up a ...

Welcome to my box of tricks (SQL scripts) for Microsoft SQL Server instance and database administration! I've put considerable effort, over many years, into creating my own scripts, as well as ...

I'm not much of a BATCH scripter (More of a BASH scripter) but I have an issue I need to work out and would like some help (Though I've probably already hexed myself by admitting I work in Linux). I'm ...

SQL Trace and [!INCLUDE ssSqlProfiler] are deprecated. The Microsoft.SqlServer.Management.Trace namespace that contains the Microsoft SQL Server Trace and Replay objects are also deprecated. [!INCLUDE ...

If you don’t have a backup of your MS SQL database, then follow the below ways to recover deleted data. Transaction log files record each change made to the ...