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
SQL Server 2016 SP1 Standard Edition Enterprise Features
On November 16th 2016 Microsoft released the availability of SQL Server 2016 Service Pack 1 (SP1). Normally a service pack release isn’t the most exciting news to blog about, but this release is different – This SQL Server 2016 SP1
Goodbye AdventureWorks!
Well it’s time to say Goodbye AdventureWorks! With the recent release of SQL Server 2016 the team have also upgraded the sample database. Our long standing and familiar AdventureWorks, which has been around since SQL Server 2005, has finally been
Temporal Tables in SQL Server 2016 – Part 2
In Temporal Tables in SQL Server 2016 – Part 1 we looked at the basic setup and querying of temporal tables in SQL Server 2016. In this part we’ll look at some of the other standard SQL Server options we can
Temporal Tables in SQL Server 2016 – Part 1
With SQL Server 2016 we have a few new features which are also available in Standard Edition, such as temporal tables; This is found in the SQL Server – What’s new PDF available at http://download.microsoft.com/download/8/A/2/8A2BC8C5-BBA0-4A9C-90BC-AC957D3454D9/SQL_Server_2016_Editions_datasheet.pdf Temporal tables are system-versioned tables
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 DBCC Extended Checks (EXTENDED_LOGICAL_CHECK)
Although SQL Server 2016 is now in RC1 it looks as though there will be some changes to the default options in DBCC CHECK with regards to the EXTENDED_LOGICAL_CHECKS option. With the increasing amount of spatial data being used in today’s databases its
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
Query plan operators not used in SQL Server 2016: Bookmark Lookup
I was having at look at the query plan operators today in preparation for a talk I will be giving on Plan execution and cache and noticed that some of the operators present are not used in SQL Server 2016, most notable the “Bookmark