One of your five a day
The vector data type in Azure SQL Database has now gone into Public Preview. With the ever increasing integration with AI and Machine Learning (ML) it’s important to be able to consume and handle vector data. More information is available
SQL Server 2022 brings some exciting new language features such as DATE_BUCKET https://learn.microsoft.com/en-us/sql/t-sql/functions/date-bucket-transact-sql?view=sql-server-ver16 As per the information, this function returns the date-time value corresponding to the start of each date-time bucket. This means it much easier and more readable now
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
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 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’,’ ‘)
Previously we provisioned three Azure SQL Servers, one Primary with two Readable Secondaries. Next we need to create a new user with db_datareader permissions in this example, perhaps for a reporting application. First we need to add an allow rule
With our last post and the availability of readable secondaries on all tiers I thought I’d run through the requirements. Firstly we need to create three servers. In this example we’ll create one each in North Europe, West Europe and West US, as below; Then we will add a
SQL Azure used to require the Premium (P) tier to take advantage of Active Geo-Replication for Azure SQL Database. Since April 25th this is no longer the case and all tiers, including Basic (B) at around $5/£3 month, now support this
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
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