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 ...

This repository contains structured and practical SQL scripts based on the full course: "Transact-SQL Queries using SQL Server". It includes step-by-step exercises, real-world scenarios, and advanced ...

If you ever need to sort character strings stored in SQL Server fields, check out this demonstration of how to write a common sorting algorithm using SQL Server TSQL code. You are probably familiar ...

this will return: "(1 row(s) affected)" But now I need to know, what data was actually inserted? SQL Server has answered this question in 2005 with the OUTPUT statement: This will return a dataset ...

We are getting a new SQL server to run a vendor application.<BR><BR>The other sys admins want to get Symantec Backup Exec version 10D's SQL Agent for the server.<BR><BR>I personally think it would be ...

With the official release of Microsoft's latest database offering, let's see what was improved and what still needs some work. Today, at Ignite, Microsoft announced the general availability of SQL ...