Script to find the complete weeks within two given dates

Sometimes we need to find out the complete weeks within two given dates. Below script will help in finding the...

Microsoft Azure Data Catalog

Just announced is the Microsoft Azure Data Catalog, which is an enterprise metadata catalog / portal for the self-service discovery of...

PASS Summit Precon – The Complete Primer to SQL Server Virtualization

I am very pleased to announce that Argenis Fernandez and I will be presenting a new precon training session at...

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