Credentials and Proxies: Getting Started

If you’ve been a DBA for more than a day, you probably have a pretty good idea of what a...

My favourite books

As I mentioned in the blog post Speaking at SQL Server Days 2015, I’ll be giving a session at the...

The Seven-Day Weekend by Ricardo Semler

This great book by Ricardo Semler is something that some of my friends have been recommending me to read for...

Table Size Script Update for 2015

Newest update to the script to help discover and track object sizes within a database.
Related Posts:

Refresh SQL Modules November 9, 2018

Drop That Schema October 27, 2017

An Experiment...

Table Size Script Update for 2015

As was recently promised, I have an update to an old tried and true script for calculating the size of...

Hekaton - In Memory OLTP - Getting Started / FAQ :- 1

SQL Server 2014 introduced a major feature called "In Memory - Hekaton" Tables, in which even the fundamental concepts of SQL...

Start SQL Server in Single User Mode

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

Clearing Out a Database With SQL Compare

I ran into a question recently about how to clear out a database of all objects. I assume someone was...

Using the DAC

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

SQL Server – Sparse Column Property using SELECT INTO

Hi friends, in our day to day work we used SELECT…INTO clause to create replica of a table for different...