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

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

Refreshing the SQL Server PowerShell Provider

Sometimes SSMS gives you stale results and there you have the Refresh button to fix that. In SQL PowerShell, the same situation can arise where the SQL Server PowerShell...

Refreshing the SQL Server PowerShell Provider

Sometimes SSMS gives you stale results and there you have the Refresh button to fix that. In SQL PowerShell, the same situation can arise where the SQL Server PowerShell...

Refreshing the SQL Server PowerShell Provider

Sometimes SSMS gives you stale results and there you have the Refresh button to fix that.
In SQL PowerShell, the same...