This repo is a collection of T-SQL scripts I wrote while supporting SQL Server 2008 through 2016. Most are simply quality of life functions, while others such as my availability group SQL agent job ...

On Azure SQL Managed Instance, most, but not all SQL Server Agent features are currently supported. See Azure SQL Managed Instance T-SQL differences from SQL Server for details. Microsoft ...

Sometimes you don't need a full-fledged database-management environment. Maybe you just need to go in and add a field, change a table or write an ad hoc query. Certainly you can do all those things in ...

I'm new at this whole DBA thing, so maybe this is totally standard practice.<BR><BR>But we have a software vendor that wants remote access to our SQL server at an admin level to setup and install ...

“Free” is a term rarely associated with Microsoft offerings, especially at the server end of the spectrum. Exchange Server, SQL Server, SharePoint, Hyper-V — IT admins know functionality comes at a ...