Ola Hallengren: Output File

I’m a huge fan of Ola Hallengren‘s free utility scripts. If you aren’t familiar with it, it’s a great tool to...

Understanding Keys and Certificates with Always Encrypted

Always Encrypted on SQL 2016 is pretty easy to set up. There’s even a single wizard to guide you through...

SQLSaturday Pensacola 2017

It's the start of a SQLSat summer for me, with Pensacola this weekend on Saturday June 3, then Houston two...

SQL Server Filtered Indexes By Example

What Are Filtered Indexes
Filtered indexes are essentially an index with a predicate on them filtering the data that gets stored...

Decrease Stored Proc Execution Time By Limiting the Table Size

Hi Guys,

Hope everyone is doing well. Last week, I was working on the most exciting task on which any database...

Angular 2 FAQs

1. What is angular module?
NgModule helps to organize an application into organized blocks of functionality. @NgModule decorator takes metadata that...

How I Became a...SQL Server DBA

Kevin Hill mentioned this idea/series on a SQL community slack channel back in April and I thought it would be a good way to get back to blogging. The timing...

Upgrading to Modern SQL Server eBook with ScaleArc

Recently I contributed my thoughts in a new ebook from ScaleArccalled “Industry Perspectives: Upgrading to Modern SQL“. Modernizing the datacenter...

Quitting VIM

I saw this post from Joel Spolsky lately, noting that Stack Overflow has been helping 1 million developers exit VIM....

Monday Coffee 2017-05-29

I’ve always said that this blog is my way of giving back to the SQL Server community but there is...