Automatic database restore

Often times database administrators were asked to restore production database backup to UAT or development environment, sometimes it will needed...

Reblog: What’s the deal with Excel and SSIS?

SQLKover update: When I read this old blog post of mine, all I can think about is: Power Query to...

100th post

This is my 100th blog post here at LessthanDot!

(I’m not lying, check for yourself)

I started blogging at the end of...

Podcast about my career and the SQL Server Community with Chris Bell

During my time at SQL Saturday in Philadelphia (Early June), Chris Bell invited me to be a guest on his...

Why I won’t be running SQL Server Standard Edition on Business Critical Servers!

I keep getting questions around what core features are missing in Standard Edition of SQL Server,and why there is a...

Introduction To Dynamic Data Masking in SQL Server 2016

In release of SQL Server 2016 CTP 2.0 another new feature that is released is Dynamic Data Masking.  Using Dynamic...

Overview of Published Articles – 2015Q2

Here is an overview of the articles I published in the secondt quarter of 2015.
INTENSE SCHOOL
Book Review: Query Tuning & Optimization by...

SQL Server Storage best practices

Server storage is one of the most important things for SQL Server performance. Chances to utilize a lot of RAM and...

Proper Aliasing will help you somewhere TIP#104

Recently, When we were delivering session on “SQL SERVER” one of the persons asked why we require Aliasing so I...

Layer a database into a SQL Server container

In my previous post on running SQL Server in a container I showed how you could use the Spoon (https://spoon.net)...