Sql Server 2016, ships with a new system catalog view that returns the current UTC Offset for a given time…
When I decided to move forward with creating this website, I decided early on that I didn't want to repeat…
Just kidding. It's still the redheaded step child. But seriously, every time I roll up my sleeves and dive into…
Tested on: SQL Server 2016 Developer Edition Accurate as of: January, 2018Use this script to rename a database when the…
Tested on: SQL Server 2016 Developer Edition Accurate as of: January, 2018The following snippet generates a SQL Server View that…
Tested on: SQL Server 2016 Developer Edition Accurate as of: January, 2018 In this query, I've added a record number…
Tested on: SQL Server 2016 Developer Edition Accurate as of: January, 2018One way to identify active tractions, is using DBCC…
The following queries demonstrate the T-SQL SUBSTRING function. I've also included a comparison with the C# function of the same…
Tested on server version: SQL Server 2016 Developer Edition Reference info accurate on: January, 2018 The following script demonstrates how…
Tested on server version: SQL Server 2016 Developer Edition Reference info accurate on: January, 2018 The following view returns a…