Tetelestai – It is Finished
April 11, 2009
I recently read a post by Michael Deputy that talked about his Blog Direction. He brought a good point up: Focus on what’s important. Well today I am doing just that. I am a Christian as I say plainly in many locations and in my about us page. I am thinking I may periodically post … Read more
Manage Your Transactions (So they don’t manage you – Part 1)
April 9, 2009
This is part 3 in a series on shrinking and transaction management. Click here for part 4. You can see them all in the Shrinking & Transactions category. If you are one of the people who have been reading this blog, you know where I stand on shrinking databases/log files. I don’t like the practice (Post 1, … Read more
Alphabet Blocks and a Solid Foundation
March 22, 2009
Continuing in the theme from last week’s post correlating the DBAs role to aspects of various careers (Pilots, Chefs and Doctors) an illustration came to me this past weekend. I was playing blocks with my 1 year old son. The game with him consists of me trying to hold him back for as long as … Read more
PASS Call for Speakers (…and my answer to that call)
March 21, 2009
I was in a company offsite meeting yesterday so I missed the fanfare on twitter and the blogosphere about the opening of the call for speakers. Brent Ozar blogged about it, Thomas LaRock blogged about it… Countless others on my blogroll also blogged about it. The bottom line is go to the PASS speaker resources … Read more
Checklists, Recipes and Algorithms
March 16, 2009
What do checklists, recipes or algorithms have to do with Database Administration? A lot… If we study a few career paths we can see how a checklist or process flow makes their lives easier. I love stealing ideas from everyday life, working them into something useful for my DBA career and I think we have … Read more
Analysis Services Command Job Step Failure
March 5, 2009
Just uncovered an already reported and fixed (in SQL Server 2008) bug with Analysis Services job steps reporting success even if your MDX or XMLA in the step failed. The troubleshooting that worked up to the issue also reiterates points I made when discussing troubleshooting methodologies and empirical evidence. The Problem Some changes were made … Read more
Where do I start?!?!
March 5, 2009
As a SQL Server DBA, where do I start? So you are a new DBA. Maybe you are someplace that hasn’t had a DBA, maybe you are someplace that didn’t have a great DBA. Requests are piling up, your head is spinning with the instances you are discovering and people are getting excited that there … Read more
What SQL instances are installed on my network?
February 25, 2009
Find All SQL Server Instances On Your Network! It’s been awhile since a tool has given me that giddy, starstruck feeling but it’s happened this week… If you ever struggle with instance discovery and management, I hope you get excited and try this tool out as well. Bear with me as I walk through it. … Read more
First Computer(s)
February 21, 2009
So the tagging phenomenon continues. I was tagged by Michelle Ufford (Twitter, Blog) in a meme that was started by Dennis Gobo (Twitter, Blog) asking the question about your first computer(s) and top 3 favorite games. My very first computer at home was the TRS-80 Color Computer 2 That’s right. There isn’t a monitor. You … Read more
Just add a join hint!
February 20, 2009
When I posted about Empirical Evidence and finding a Troubleshooting Methodology, I talked about implementing a solution just because it seemed to work. This can manifest itself in different ways. Some are alright and harmless (what your shotgun hit happened to be the right fix) and some can be dangerous and hide the real problem. … Read more