The TempDB in SQL Server

Every SQL Server instance has a shared database named TempDB. It is a database where temporary objects are stored and...

Enormous response from the last promotional campaign

After I posted this blog MDX Cookbook is a popular book, I received another email from my MDX book publisher.

...

When a calculated measure is added NON EMPTY stopped working

We use NON EMPTY key word on the rows axis to remove rows with NULL values. It works only when all...

Goodness-of-Fit Testing with SQL Server Part 7.1: The Kolmogorov-Smirnov and Kuiper’s Tests

By Steve Bolton
…………“The names statisticians use for non-parametric analyses are misnomers too, in my opinion: Kruskal-Wallis tests and Kolmogorov-Smirnov statistics,...

SQL Server Podcasts

Great news, I have decided to do some podcasts on the fundamentals of SQL Server, my aim is to help...

Last Day to Submit Your Letter of Interest for the 2016 PASS Nominating Committee

I submitted my letter just a few minutes ago. It’s a template, doesn’t take more than 5 minutes to fill out and...

The OUPUT Clause in an INSERT–#SQLNewBlogger

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

Data loading into Azure SQL Data Warehouse

Azure SQL Data Warehouse (SQL DW) is a new platform-as-a service (PaaS) that distributes workloads across multiple compute resources, called massively parallel processing (MPP)....

I’m presenting for the Pass Security Virtual Chapter!

Tomorrow (3/24/2016) at noon CT I’ll be presenting my SQL Server Security Basics session for the Pass Security Virtual Chapter....

The ‘In Recovery’ Mystery

Last week I received an email from one of our sysadmins asking why one of our databases kept showing as...