011 – Get The Tools! - WaterOx Consulting

Reading Time: 1 minutesJust get the freakin’ tools already! In WOxPod!, episode # 011 –...
The post 011 – Get The Tools! appeared...

Creating Clustered Index on a Table Variable column in MS SQL Server

If you need to create an index in order to improve performance of the queries running against table variable (@temptable)...

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...