SQL Server troubleshooting thoughts from Graham Kent, (ex) Senior Support Escalation Engineer at Microsoft Sweden.
Update 23th August
This position has now been filled - thanks for everything who submitted their CVs.
The Microsoft SQL Server support team in Stockholm is looking to hire a contractor to help out over the next year or so, to cover some staff absences. If you’d be interested to come and work with us and learn more about SQL Server internals than you probably would anywhere else in the world (apart form Redmond maybe), then this might be the contract for you.
Although you’ll get some training and access to innumerable amounts of internal only documentation, we’re looking for someone very experienced who can hit the ground running and could be expected to work the majority of our easier support cases without too much assistance. Therefore you’d need a minimum of 5 years experience (preferably more) working with SQL Server day to day in an administrative capacity (probably as a production DBA). Specialities of particular interest to us would be:
Setup / configuration / migration
Administration of HA solutions (clusters, DBM, replication etc)
Crashes, Hangs and Unexpected behaviour
Beyond that if you have experience of other Microsoft server products (Windows, SharePoint, BizTalk, SCCM, Navision), windbg, c# or c++, it won’t do you any harm.
If you think you’d be interested, then please send a brief summary (it’ll come out in plain text so keep it simple) of your experience via the “email blog author” section (to reduce my spam levels!). If we’re interested then we’ll get back to you with proper email details so you can send in a full CV and talk to our agency. You need to be resident in Sweden (Swedish language or other Nordic languages would be of use, but are not essential) and available to work full time in Kista / Akalla from some point around August.
Here’s a script to play with which is useful for simple management tasks. I wrote it to help someone with a TokenAndPermUserStore cache issue (http://support.microsoft.com/kb/927396/) which are relatively uncommon nowadays. I actually sent it to someone today which is why it came to mind, but it occurred to me that the template of the script itself is quite useful for any such TSQL SQL Agent based task, i.e. it does these tasks:
Runs a DMV query
Checks results of query and if appropriate takes an action
Writes what it did to the SQL error log as an info message
I use the theory for many different tasks. Feel free to use and alter it as you will, subject to the usual legal caveats of course!