My First Ever SQL Saturday Pre-Con

My First Ever SQL Saturday Pre-Con

Like most people I have a bucket list of things to do before I depart for other things. However I chose to have two bucket lists, one personal and one professional. I’m now one step closer to ticking another one off of my professional bucket list, the title should give you a big clue. A […]

50 Shades of Brown – The Series

50 Shades of Brown – The Series

This series is all about problems you will face at some point in your career as a data professional specifically around the areas of Disaster Recovery and High Availability. As HA/DR is such an intricate topic please don’t expect this to be one of those one a day series.

SQLBits XIV – Welcome to the UK

A number of you will have heard of SQLBits before. It’s Europe’s largest conference dedicated to SQL Server. What was something just for people from the UK has been transforming into something much larger, more multicultural and more engaging as the community grows. Now we find that quite a large contingent of people are from […]

(Ctrl+E) was pressed. Waiting for the second key of chord…

(Ctrl+E) was pressed. Waiting for the second key of chord…

I first came across the error “(Ctrl+E) was pressed. Waiting for the second key of chord…” last year, these weird errors have a tendency to come at the worst times.

PASS DBA Virtual Chapter Webcast 20141112

PASS DBA Virtual Chapter Webcast 20141112

Today I have the honour of presenting a session for the PASS Database Administration Virtual Chapter. The great thing about the PASS Virtual Chapters are that they are completely free, you just need to be a member of PASS in order to register. That’s right, free SQL Server training and if you miss it, don’t […]

I need your help

I need your help

The Situation On the 19th November I am going to be presenting two sessions for the Luxembourg PASS chapter at the Microsoft offices there, you can register for the event here. One session is on Wait Statistcs, which is fine. I’ve done it before as a webcast for Dell Software and will be doing a […]

Experts Perspective Webcast: Wait Watchers – Gain Performance Increases Fast

Experts Perspective Webcast: Wait Watchers – Gain Performance Increases Fast

Following in the footsteps of such greats community leaders as Brent Ozar and Kevin Kline I have the opportunity, nay privilege of hosting the “Experts Perspective” webcast series. The only difference being for the next event which is held this week on 14th August 2014 that I won’t be hosting it, I’ll be hosting and […]

PASS DBA VC Session 25th June

PASS DBA VC Session 25th June

It’s always an honour to be able to speak at an event, but events can be expensive to attend and they don’t always occur at a time or location that is convenient for you. Thankfully those smart people at PASS have created a number of Virtual Chapters so you can watch sessions live from the […]

Spring may be long gone but you still need to clean up MSDB

Spring may be long gone but you still need to clean up MSDB

System databases are often neglected, part of this is due to Microsoft’s message of SQL Server will run and look after itself. In fairness it does to a certain extent (no, that’s not a pun), it’s configured out of the box not to be the fastest, but to be stable. The problem is that SQL […]

Data loss in clustered index occurs when you run online build index in SQL Server 2012

Data loss in clustered index occurs when you run online build index in SQL Server 2012

Scared? Don’t worry, there is a workaround and a hotfix. More on that in a moment. This morning I checked my Twitter feed and saw this post from Nicholas Cain, it’s really important to take note of this so I decided to write a few lines in the hope that more people would see this […]