Recertification, too easy?

3 years I was awarded the MCSE: Data Platform certification and as per the recertification rules, I needed to recertify...

SQL Data Generator –Specific Domains for a Column

I was mocking up some test data and wanted to limit my list of values to specific items. In this...

Monday Morning SQL Break – March 21, 2016

Monday, Monday, Monday… let’s start with a wrap-up of last week’s blog and twitter activity.  If you haven’t already, follow me...

Cross Database Query in Azure SQL Database

You can’t query across databases in Azure SQL Database… or can you?
Let’s check. I’ve created two new databases on an...

TOP 1 killed my performance; Rob Farley helped me resurrect it.

tl;dr; There is no short version of this. It’s LONG. It’s interesting but you might want to skip it if...

Database Growth Trends – Idera Diagnostic Manager

How fast are your databases growing?  Should I panic about a 1 TB database that has 100 GB free on disk?  Am I safe with a 100 GB database...

Database Growth Trends – Idera Diagnostic Manager

How fast are your databases growing?  Should I panic about a 1 TB database that has 100 GB free on...

Columnstore Indexes – part 81 (“Adding Columnstore Index to InMemory Tables”)

Continuation from the previous 80 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Microsoft is doing an amazing job with...

Weekly Round-up 21st March 2016

Here are some of the more interesting links that I have found this week

SQL Server
SQL Server 2016 RC1 has...

Columnstore Indexes – part 80 (“Local Aggregation”)

Continuation from the previous 79 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Given the number under-the-hood performance & manageability improvements...