Tag Archives | general

The Internet – My saviour and My nemesis

Like any good SQL DBA these days, the internet is a godsend to my career and professional development. I can quickly and easily find articles and notes from world experts on complex topics, and even interact with those experts as well via twitter, email or skype. Compared to the bad old days of having to know someone’s phone number, or battling through tiers of support to get to someone who knew something this is absolutely amazing.

But, on the other hand…….

How many of us are now used to a user (of many levels) coming across to our desk, or dropping us an email about a great new technique they’ve just seen on a random internet search. The canonical examples are with (nolock) and the ever classic one about restoring deleted rows directly out of transaction logs.

As always these are things where the correct answer to “Is this a good idea?” is “It depends”.

As SQL Server DBAs/experts we’ve worked hard to build up a level of internal filtering that lets us look at the post on StackExchange or Twitter, step back and evaluate if it’s something that’s really a good idea. We’ll then have taken it away and played with it on development systems before we think about adding it to our toolkit so we’re fully aware of the techniques limitations. And if we ever do have to deploy it in a production environment we’re also well aware of the amount of work that’s needed, and the amount needed if it goes wrong, and we’ll know which mug will be fixing it,

Stuart Moore

Stuart Moore

Nottingham based IT professional with over 15 years in the industry. Specialising in SQL Server, Infrastructure design, Disaster Recovery and Service Continuity management. Now happily probing the options the cloud provides

When not in front of a computer, is most likely to be found on the saddle of his bike

More Posts - Website

Follow Me:
TwitterLinkedInGoogle Plus

Stuart Moore

About Stuart Moore

Nottingham based IT professional with over 15 years in the industry. Specialising in SQL Server, Infrastructure design, Disaster Recovery and Service Continuity management. Now happily probing the options the cloud provides

When not in front of a computer, is most likely to be found on the saddle of his bike

End of working 2011

Well, just about to wrap up working for 2011. For the first time in years I’ve actually got a completely clear christmas break with no planned work. And hopefully the last year’s work will help ensure no unplanned work callouts either.

Looking forward to 2012; I’ve just sorted my registration for all 3 days of SQLBits in London at the end of March, and it’s looking likely that I’ve scored some Dynamics CRM 2011 training off the back of a project.

Sort of dreading having to look at rebuying my ‘work’ library next year as tle SQL 2012 books start hitting the shelves. There is a temptation to look at an E-reader to save on space/cost, but the Kindle has never really impressed, and initial reports on the Kindle Fire for technical documents aren’t promising, this could finally push me over the edge in iPad ownership.

One of the last jobs for this year was setting up mirroring for an application between 2 geo-clustered SQL installs. Really looking forward to the AlwaysOn availability groups coming in SQL Server 2012 as it looks like it will remove a lot of the pain and overhead involved in these sort of scenarios, (In fact I’ve picked this session “AlwaysOn: Maximizing High Availability with SQL Server 2012” by Allan Hirt for my Thursday session at SQLBits.

About