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

A journey to a movie recommender in U-SQL

I haven’t gotten to involved in the whole “Big Data” movement to much,  I’ve kept an arms length watch and...

SQL Saturday #486 Richmond – A Window Into Your Data

Thanks for attending my session on window functions in TSQL. I hope you learned something you can take back and...

Failover all databases to other server

Quick snippet I threw together to help with failing over synchronized databases to the other server in bulk. No way...

Previewing the new SSRS 2016 portal

Ran into an issue with the “Preview New Reporting Portal” link on a fresh install of 2016 giving me a...