SQL Server Database Recovery Process Internals – database STARTUP Command

A database recovery process is an essential requirement for database systems, It can be a tedious job and the process...

SQLSaturday Madison – April 7-8

The first event I ever spoke at was SQLSaturday in Madison, Wisconsin, back in 2012. I was petrified – would anyone...

TempDB Multiple Datafiles

Problem

Most DBAs are aware that (prior to SQL 2016) one of the most common, post installation changes that needs to...

Who Stuck These Letters In My DateTimes?

Parsing, creating, and modifying JSON in SQL Server 2016 is really easy. JSON dates and times are not.
Coming from a predominantly SQL background, the JSON DateTime format took some...

Why Before How

I’ve spent a lot of time browsing and participating in online technical forums. In my early years in the industry...

Custom keyboard shortcuts in SQL Server Management Studio (SSMS)

People love taking shortcuts because it’s the easiest way to do things faster; computers are no exception. Shortcuts, particularly ones...

Data Channel - Interview 04 - Martin Catherall on In Memory OLTP

Welcome to the 4th Interview of Data Channel.
We have Mr.Martin Catherall, 3 time Data Platform MVP from Australia / New...

Getting a VHD into Azure with PoSh

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...

How easy it is to implement Row Level Security in SQL SERVER 2016 ?

To understand RLS (ROW LEVEL SECURITY) let’s understand the different problems first.Problem 1 Suppose, you have a Multi-tenant e-commerce website...

Insufficient Disk Space (T-SQL Tuesday #88)

This month’s T-SQL Tuesday – hosted by Kennie T Pontoppidan(@KennieNP) – is called “The daily (database-related) WTF“. He asked us to be...