Category Archives: Personal Development

Back in the saddle

I’ve been neglecting my blog for too long. Time to get it going again.¬†This is my new blog but I’ve been doing this since 2009. You can find my earlier posts here:

New content will follow shortly and I’ll gradually copy my older posts over.


Know your target market

Most companies think they understand their target market, but some really do. I have quite a few flash drives but I wouldn’t give any of them a high score for good looks. Until now!
I was passing a well-known electronics retailer when this caught my eye: 32GB, ¬£14.99 name = Intenso. AND IT’S TRANSPARENT!!
About 90 seconds later I owned one.

The unknown unknowns

I was spring cleaning some old scripts and I came across my first attempt at establishing a backup strategy. 12 hours later I’m still feeling a bit queasy. When I first put on the DBA hat, we were running with the simple recovery model and doing a full backup every night. I did some homework and thought I’d got it all figured out. My killer improvement? Use full recovery and every night do a log backup and then a full backup. That way we could recover to any point in time. Brilliant!*
Since then I’ve learned a lot. I know I’m much better than I was. But I can never quite shake that small nagging doubt: how much of what I’m doing now – believing it’s good practice – will I one day look back on and shudder? But this is a good thing. It keeps me on my toes, continually re-evaluating what I’m doing, and hungry to learn.
*Just to be clear, I’m being sarcastic. This NOT a good solution. If you have any doubts:
  1. Read Books Online about recovery models and backups.
  2. Read what Paul Randal has written about it in his blog and in TechNet Magazine.
  3. Check out Ola Hallengren’s database maintenance solution before you write your own.

How cool was SQL Bits 8?

The simple answer: very! Thanks very much to everyone who was involved in making it happen – both organisers and speakers. For a bargain price I got a deep dive day on performance monitoring and troubleshooting and two days of a wide variety of subjects. And it’s not just people regurgitating Books Online. This is practical, ‘street smarts’ know-how from people who really do this stuff for a living. If you’re not sure how to pay for it, here’s one approach. Last time I went to the free day and my boss was so impressed with all the good stuff I brought back that, when I asked if he would pay for the full monty this time, he didn’t even hesitate.
You get much more than just information though: there are other, less tangible benefits. It’s as good as a holiday to just geek out on SQL stuff and be exposed to aspects you haven’t used much. I came back full of new ideas and raring to make a difference. You also shouldn’t underestimate the boost you get from just mingling with others of our kind. I don’t know what it’s like where you work but at my company I am the DBA team and it gets a bit lonely sometimes.
Then there’s the chance to meet the rock stars and learn from them. We’re lucky to work in a largely fact-based field where just having a loud voice doesn’t get you very far. These people are prominent because they’re good at their thing. I’ve now met quite a few and, without exception, they’ve been very approachable and helpful. This time I got to chat with Aaron Bertrand and Kevin Kline and, apart from being great SQL guys, they were both really good company.
Half the SQL Server CAT Team were over from Redmond and available all three days to talk about anything. There are sponsor companies showing you there products. And not just sales staff. At one stand I was looking into a monitoring product and it turned out the guy showing me round it was the lead developer. You can find out more in five minutes like this than you can in an hour of reading specs and documentation on their website.
Last but not least, rest assured that there is swag. A year’s subscription to SQL Server Magazine, 6 months’ access to an on-line library of nearly 700 technical books, serious prize draws galore, and so on. And I won second prize in the SQL trivia bingo!
I’m sure I’m missing plenty of other stuff. SQL Bits is not a trade convention. It’s SQL Server people getting together, sharing what they know, and learning from each other.