Did you know…you can’t do arithmetic operations with datetime2 like with datetime?

I’m currently working on a SQL code migration from Firebird to SQL Server and I hit an error that I...

The Uni-Code: The Search for the True List of Valid Characters for T-SQL Regular Identifiers, Part 2

(last updated: 2018-04-28)

Recap
In Part 1 of this 2 part series, I started with the loose definition in Microsoft’s documentation for...

RIP, Robert Davis

A sad day for me.
A Memorial and Grief fund has been set up, if you’d like to contribute.

4 Improvements to Azure SQL Database

If I was a wizard I would make these 4 improvements to Azure SQL Database. They are in no particular...

Webinar: Auditing with Extended Events

I’m giving a webinar today, April 5th, at 3 PM Eastern, on using Extended Events to audit your SQL Servers....

Ohhhhhh S…t!! A tribute to Robert Davis

Today marks 3 days since we’ve lost Robert Davis a.k.a SQLSoldier, one of the pillars of SQL Family community.

I was...

Interesting Azure ARM "Make it So" behaviour

I had a template that deployed a premium managed disk and a virtual machine. I defined the disk like:
{ "comments":...

Interesting Azure ARM "Make it So" behaviour

I had a template that deployed a premium managed disk and a virtual machine. I defined the disk like:
{ "comments":...

Interesting Azure ARM "Make it So" behaviour

I had a template that deployed a premium managed disk and a virtual machine. I defined the disk like:

{

"comments":...

Interesting Azure ARM "Make it So" behaviour

I had a template that deployed a premium managed disk and a virtual machine. I defined the disk like:
{ "comments": "Managed Disk.", "type": "Microsoft.Compute/disks", "name": "[variables('diskName')]", "apiVersion": "2016-04-30-preview", "location":...