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.
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
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 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’,’ ‘)
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
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
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