SQLBITS 2016 Agenda has been Published

The agenda for this year’s SQLBITs has been published you can find it here  http://sqlbits.com/information/event15/Agenda.aspx?20160507
Our very own David Postlethwaite has...

.Net 4.6.1 and MultiSubnetFailover

Im not a big clustering/HA expert, but I obviously understand the need for such things to exist
However, the standard...

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 used by other databases. Because it’s only one database...

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 used by other databases. Because it’s only one database...

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

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