What's New in SQL Server 2016, Community Technology Preview 3 (CTP 3.1)

What's New in SQL Server 2016

Benefits of SQL Server 2016:
Enhanced in-memory performance provides up to 30x faster transactions, more than...

You should always have an “I got hit by a bus” backup plan

You have an on call, you have a business continuity plan, you have a disaster recovery plan but what happens...

The Discomfort Zone

Over the Thanksgiving holiday, I read a book entitled The Phoenix Project. This book has been in my Kindle library...

Why would you want to name a transaction?

Something that i keep seeing in documentation, in forum code and in real systems is transactions that have names
BEGIN TRANSACTION...

Atlanta BI Edition SQL Saturday Precon

The explosion of Business Intelligence (BI) capabilities coming from Microsoft these days have left many of us in a frenzy. ...

Changing Course On Learning

With all the new stuff on the Microsoft Data Platform, it’s really hard to keep up with it all. I had...

Covering Indexes

Microsoft continues to improve indexes and options for additional performance enhancements. One I see frequently is the need for a...

Puzzled by T-SQL

Live blogging this a bit as I try things. This will update a bit, so you’ll have to read through.
Adam...

Question of the Day: Check, Please

This one is live today, it’s about Powershell and restoring databases, based on some scripting I had been working on....

Row-Level Security part 2 – Controlling Write Access

My previous post was focused on controlling read operations. With the latest enhancements to the row-level security, it is now possible...