Online Training event: Designing a Mobile Dashboard Solution with Microsoft DataZen

I’d like to make you aware of a three-hour training event that I will be presenting, hosted by SQL Server...

Online Training event: Designing a Mobile Dashboard Solution with Microsoft DataZen

I’d like to make you aware of a three-hour training event that I will be presenting, hosted by SQL Server...

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

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

Automatic database restore

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

But I Don’t Have a Test Server…

I frequently see statements on forums along the lines of “I don’t have a test server, so I’m going to...

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

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

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