Server Admin

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 […]

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 […]

SQL Server Webcast: The Day After Tomorrow; Why YOU need to Baseline

Every day I consider myself extremely fortunate to be in a profession that I really enjoy, as there’s always something new to learn and experiment with. We also have a fantastic SQL Server community which I am proud to be a part of. After being approached by Quest (now Dell Software) , I jumped at […]

How to provide a better customer service

How to provide a better customer service

Far too many people just concentrate on the technical aspect of disaster recovery without looking at the human element. In this post I attempt to help readdress the balance with these customer service tips

New Year Aspirations – Jonathan Allen – DBA

New Year Aspirations – Jonathan Allen – DBA

The eigth interview in the SQL Server “New Years Aspirations” series is with Jonathan Allen talking about being a DBA.

#SQLThursday is here

Struggling to source quality free content on SQL Server? Finding it difficult to fill the void between #TSQL2sDay and Un-SQL Friday? Join me for the first EMEA SQL Server webcast of the year Deploying SQL Server Tips & Tricks  on Thursday 19th January 2012! Starting this month I’m proud to announce that I will be […]

Missing Performance Counters

Missing Performance Counters

We had an incident today where a set of SQL performance counters were not showing in Perfmon. The performance counters in question were the SSISPipeline set on a 64bit instance of SQL Server 2005, the reason why they were not showing was that in a 64 bit installation the registry setting that stores the location […]

SQL Patch Updates

The following KB articles/patches for SQL Server have been released over the last few days: SQL Sever 2005 You have to reinstall some drivers when you install SQL Server 2005 FIX: A Deadlock occurs when two transactions try to perform a DML operation on a table that contains a TABLOCK locking hint or an XLOCK […]

Recovering TempDB

In a previous post “Moving TempDB” I provided step by step instructions on how you can move your TempDB database with an emphasis on reducing disk IO contention. If you have read this post you will notice that I did not change the path for the TempDB database files from the USB stick back to […]

Moving TempDB

One of the planned projects in my schedule for the coming financial year is to add some new disks in to one of our SQL servers. As part of this project I will be moving the TempDB database onto a different disk thereby helping to reduce the IO contention on the server.