5 Top Features Your Company Can Use in SQL Server 2014 Standard Edition

5 Top Features Your Company Can Use in SQL Server 2014 Standard Edition

In a few days SQL Server 2014 will be made available, we’re not all lucky enough to be running Enterprise Edition even the largest of corporations still have a large number of Standard licences about their estate. The big question is; What can SQL Server 2014 do for you and your small – mid sized […]

Grant View Server State

Grant View Server State

There are lots of Dynamic Management Objects (DMO’s, more commonly referred to generically as DMV’s) that require extra permissions. Without having these permissions there are a number of diagnostic queries that you cannot perform. Whilst one way to deal with this is to make users a member of the sysadmin group, it really doesn’t adhere […]

Speaking at Luxembourg SQL Server User Group

Speaking at Luxembourg SQL Server User Group

Tomorrow evening I have the honour of speaking at Microsoft’s office in Clausen, Luxembourg. The session I will be presenting is entitled “Natural Born Killers; Performance Issues to Avoid” which I serialized in a succession of blog posts here – Natural Born Killers (The series). Natural Born Killers; Performance Issues to Avoid Learning SQL is […]

Remaining Vigilant, my contribution to #DBAJumpStart – Part 3

Remaining Vigilant, my contribution to #DBAJumpStart – Part 3

This post is part of the SQL Community Project #DBAJumpStart by John Sansom. As I mentioned previously, this post has been split into 3 more manageable chunks as I know you’re all busy people. Today heralds the third and final instalment of the mini series, you can find part one here  and part two here.  […]

Remaining Vigilant, my contribution to #DBAJumpStart – Part 2

Remaining Vigilant, my contribution to #DBAJumpStart – Part 2

This post is part of the SQL Community Project #DBAJumpStart by John Sansom. As I mentioned yesterday, this post has been split into 3 more manageable chunks as I know you’re all busy people. You can find yesterdays post here – Remaining Vigilant, my contribution to #DBAJumpStart – Part 1 “If you could give a DBA […]

Remaining Vigilant, my contribution to #DBAJumpStart – Part 1

Remaining Vigilant, my contribution to #DBAJumpStart – Part 1

This post is part of the SQL Community Project #DBAJumpStart by John Sansom. “If you could give a DBA just one piece of advice, what would it be?” Last year John asked 19 successful and experienced SQL Server professionals and me (for some baffling reason) this exact question. Due to some technical problems and a […]

A Tale of Two SQL Server Webcasts

A Tale of Two SQL Server Webcasts

Things have been quiet on my blog of late (hosting issue) but now things are back online. Talking of online, on 20th March 2014 I shall be taking part in not one but two SQL Server webcasts – Dell like to keep me busy. In the morning (10:00 GMT) I shall be hosting a session […]