AT TIME ZONE – SQL Server 2016
The other day I was required to find out more about offsets and timezones and I came across a new T-SQL function in SQL Server 2016 AT TIME ZONE. This function gives us the current offset in the target time zone.
SQL Server 2016 SP1 – CREATE OR ALTER
With the release of the exciting Service Pack 1 for SQL Server 2016 we get a new T-SQL command – CREATE OR ALTER. CREATE OR ALTER <valid for procedures, views, functions, and triggers> as below for a view; Although
CREATE DATABASE, AS COPY OF in Azure SQL Database
Recently I had a conversion about the options available to create a copy of a production database for testing and development. There are, the enhanced, CREATE DATABASE and the standard Restore database options available. We’ve got the restore database option,
STRING_SPLIT SQL Server 2016 and Azure SQL Database
STRING_SPLIT is one of the more useful T-SQL enhancements that comes with SQL Server 2016 and Azure SQL Database to split a string. Simply it takes a string and a delimiter and splits this into rows. SELECT * FROM STRING_SPLIT(‘sql tom ato’,’ ‘)
SQL Server 2016 – DROP TABLE IF EXISTS
With the new version of Community Technology Preview 3 of SQL Server 2016 we have a new T-SQL command DROP TABLE IF EXISTS <tablename> This is a fantastic yet simple addition, easier to read and remember. Other statements are supported
Increase mirroring partner timeout
Recently I’d been asked to increase the partner timeout of all the mirrored databases on an instance. There were many databases on this instance so I decided to use the undocumented feature sp_MSforeachdb instead. This system stored procedure returns all
Sum of a group in Reporting Services
Let’s imagine we’re producing some simple reports and we only can track the number of pies returned across a whole despatch and not for each despatch type. We have a single query whose results breakdown each DespatchID into the various