The PFE Chronicles

Some advice and experience for you from SQL Server PFEs

Incremental statistics ... How to Update Statistics on 100TB Database

I really like the idea of Incremental Statistics and what it can offer customers, specifically...

Author: Chris Lound Date: 04/03/2016

SSMS March 2016 Now Doesn’t Fail to Install

Last week I wrote here about how the March 2016 SSMS installation fails if the visual studio 2010...

Author: Chris Lound Date: 04/03/2016

SSMS March 2016 Fails to Install

It’s super frustrating when software fails to install, it’s especially frustrating when the log file...

Author: Chris Lound Date: 03/27/2016

Restoring the master database, but not in this way!

When working on issues, we do a whole series of investigation steps, these tend to lead to other...

Author: Chris Lound Date: 03/21/2016

AlwaysOn Secondary with Out-Of-Memory Errors…

Environment Three node Availability Group set, with two asynchronous secondaries. Windows Server...

Author: Dr. David Thulborn Date: 03/16/2016

How often do you head to Performance Monitor to only spend what seems like an age finding the...

Author: Jonathan Allen msft Date: 03/15/2016

SQL 2012 Latest Update Confusion

The latest release of SQL 2012 updates has risen a little bit of confusion, especially around why...

Author: Chris Lound Date: 02/18/2016

SQL 2016 Load Balanced Readable Secondary Replicas

Continuing the theme of new features in SQL 2016, today I’ll introduce read workload load balancing...

Author: Chris Lound Date: 02/11/2016

See you at SQL Bits!

Hopefully a lot of readers will have heard of the SQLBits conference that runs every year in the UK,...

Author: Jonathan Allen msft Date: 02/09/2016

IT Innovation Series - free tech events in the UK

Have you seen the free training from MSDN in February, March, April and May across the UK? Check out...

Author: Jonathan Allen msft Date: 01/28/2016

SQL Server 2016 DTC Support In Availability Groups

In this post I’ll discuss the new support for Distributed Transactions in SQL Server 2016, how this...

Author: Chris Lound Date: 01/25/2016

SQL Server 2012 Cumulative Updates

SQL Server 2012 has just had 2 new CUs released, if you are still running on SQL Server 2012 SP2...

Author: Jonathan Allen msft Date: 01/21/2016

Hello world!

Welcome to the PFE Chronicals, a blog composed of thoughts and advice from SQL Server Premier Field...

Author: Jonathan Allen msft Date: 12/07/2015

<Previous