Forcing Parallelism – T-SQL Tuesday

T-SQL Tuesday is a monthly event where SQL Server bloggers write a post based on a subject chosen by the...

Getting Started Blogging–#SQLNewBlogger

It’s a new year, and the perfect time for you to start blogging about your SQL Server work. I think...

A Whole Day of PowerShell and SQL – Join Chrissy LeMaire & I at #sqlsatvienna

SQL Saturday Vienna 2017 is only just around the corner.
On Friday, January 20, 2017, a lot of local and international...

Monday Coffee 2017-01-09

I’m almost back into the swing of things now after the Xmas break, that holiday feeling has just about left...

SQL Server 2016 SP 1

By David Postlethwaite

SQL Server 2016 SP1 was released in November 2016 only five months after the initial release.

There have been...

Should We Allow Paid Sponsor Presentations at PASS Summit?

For many years the PASS Summit program committee has enforced a bright line rule – no sponsor content in the educational...

Disk Space Monitoring using SQL Server DMV

DMV : sys.dm_os_volume_stats
Being a SQL Server database administrator, you may often receive alerts or asked by Senior DBAs to check, if...

Moving to WordPress.com

For years I’ve hosted WordPress somewhere, most recently in Azure using Project Nami so that I could store all the...

Columnstore Indexes – part 95 (“Basic Query Patterns”)

Continuation from the previous 94 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
In this blog post I am continuing...

Understanding Network Latency and Impact on Availability Group Replication

When designing Availability Group systems one of the first pieces of information I ask clients for is how much transaction log their databases generate. *Roughly*, this is going to...