I keep a list of blog post ideas in RememberTheMilk.comin case I run out of ideas. After piling up dozens of them, I’m giving up and setting some of my favorites free. If I couldn’t write these in 2011, I’ll probably never get around to it. If you’re looking for inspiration, here you go:
Why Bad People Hate Good DBAs – Developers hate us because we find flaws. Sysadmins hate us because we identify hardware problems. Network admins hate us because they can’t blame the database. Just because people hate you doesn’t mean you’re doing a good job, though.
5 Database Queries You Should Never Make – I just love this post title, but I couldn’t decide if I should go controversial (CLR, cursors, auto-close, etc). There are good uses for some nasty tools.
Role Playing for Outage Preparations – If you’re thinking about moving your databases to a hosting provider or the cloud, play pretend. If your database was inaccessible now, how would you troubleshoot it? Start by verifying network connectivity out of your office, then to your cloud provider, then to your specific database. If any of those is down, who do you call? Make sure your support team understands these borders – the DBA shouldn’t get a call if you can’t ping Yahoo.com.
If DBAs Wrote Spam – Can your database last all night? Are your users complaining about your lack of staying power? Ask your doctor about VARCHAR(MAX).
Appreciation for Deprecation – When a SQL Server feature is deprecated, how should you react? What does it mean? How should you monitor for your own team’s usage of deprecated features? Have you explained to your team what features should no longer be implemented in new code?
SSMS vs BIDS vs Visual Studio – SQL Server users have three tools to choose from when they interact with SQL Server. Which tool is right for who? When should you learn to use a new tool? What advantages do third party tools like Quest Toad and Aqua Data Studio offer?
Great Quotes for Technology People – Starting with this one from director David Fincher: “Everything seems really simple on paper until you take a camera out of the box.”
Cobol, Compass Adjusters, and the Cloud – Yes, you have to make sure your chosen field doesn’t become obsolete, but even when careers go away, they don’t really go away. It can even be an opportunity to make more money if you’re one of the few who are still really good at it.
sp_Captcha – One of my clients asked me to write a captcha in T-SQL. No, wait, hang on – it’s cooler than it sounds. They needed to make sure that only human beings ran a particular stored procedure, and that it was never automated by accident. I ended up writing a challenge/response system using a parameter. If the param was null, the stored proc would print a question that would be difficult for a computer to answer. The next time the stored proc was called, the answer would be passed in via the parameter. If the answer was right, the stored proc ran – if not, it emailed the DBA team and paused via waitfor. I can’t share that code, so I wanted to rewrite something similar.
Really Good Experts Know People, Not Answers – Expertise isn’t just about knowing a lot of stuff. It’s about knowing a lot of people who also know a lot of stuff. I don’t know much about CLR, for example, but the fact that I can point someone to Adam Machanic helps me more than using Google.
Guess The Date – I was going to have a showcase of everything that happened on the day SQL Server 2000 came out (but not include 2000’s release), and have people guess the date. Hopefully folks would also figure out that it was the 2000 release date too.
Plot a Path to a Precon – If your New Year’s resolution last year was to speak more, and you accomplished that, maybe it’s time to set a bigger goal. You too can speak at a conference pre-con session and get paid to share your knowledge for a day – but you gotta map the route to get there. Start by building an outline, and then build a series of 1-hour sessions that you can combine into a pre-con. Make sure each hour works, and then the combined session will be even more likely to succeed.
If Movie Reviewers Wrote Consultant Reports – “Two thumb drives up. The application starts out well, and then has a knockout twist halfway through. The staff left the project, and it becomes a horror film. The IT director manages to pull it off, though.”
The Shadetree DBA – In the 1960s when cars were simpler machines, we pulled our cars under a tree for some comfortable shade and set about working on ’em ourselves. The 1970s brought complex emissions equipment, and the 1980s brought unreliable car computers. These days, some cars can go tens of thousands of miles with nothing more than oil changes. Right now, databases are at the 1970s phase, but the cloud has the potential to make larger and larger databases run themselves without human
Ahhh. I feel better already getting these out of my to-do list. Sometimes you just gotta know when to let go.