Introducing SQL Operations Studio

Note: This is content that I originally wrote for our upcoming book, SQL Server 2017 Administration Inside Out, that did not meet the publishing deadline. A new cross-platform tool for SQL Server and Azure SQL Database Microsoft has announced the preview of SQL Operations Studio, an exciting addition to the administration and development tooling (DevOps) for[…]

MySQL has this feature that SQL Server needs

In the grand scheme of things, MySQL and SQL Server operate in different realms. It’s difficult to compare them because MySQL is predominantly used for websites as part of the free LAMP stack (Linux, Apache, MySQL and PHP), while SQL Server’s range is much broader than that. There’s one neat feature that MySQL has, which[…]

SQL Server 2017 Administration Inside Out

For the last five months or so, I have been helping some really smart people put words on paper, both the physical and electronic kind, which is hopefully going to culminate in an actual technical book that I can point to and say “Yes, that’s the name I invented for myself when we moved to[…]

Is Transparent Data Encryption just security theatre?

I love theatre. In six months I am putting on two one-act plays for a local festival, because I don’t already have enough on my plate. Security theatre, on the other hand, I don’t like. It is security for the sake of appearances, that offers little to no solution to the problem it claims to[…]

Gimmicks that work: XE Profiler in SQL Server Management Studio

I have a favourite new feature of SQL Server Management Studio 17.3 (SSMS), and that’s XE Profiler, which allows you to monitor your instance in real time using Extended Events from inside SSMS with just the click of a mouse. So is it Extended Events or Profiler? Let’s talk about the name XE Profiler quickly. It[…]

Why is a value in DATETIME2 8 bytes, but in BINARY it is 9 bytes?

In the #sqlhelp Slack channel on the SQL Server Community Slack workspace last month, Jemma Hooper asked: When trying to CAST or CONVERT a datetime2 value to binary(8), I’m getting a “binary or text data would be truncated” error. This seems really weird in context with the fact that SELECT DATALENGTH() on a DATETIME2 value[…]