SQL meme Monday
April 4, 2011
Just came across this post by Bob Pusateri. He came across a post by Tom LaRock. I like the idea. My first Meme Monday post: Restores – Test them you must or failures you will have. Consider yourself tagged. I look forward to seeing your post.
SQLU DBA Week – DBA Progress Report
March 4, 2011
This week was DBA Week At SQL University. We’ve seen two great posts from Robert Davis, a couple posts from me and some input from DBA Coach LaRock. Today we’ll lighten things up. It’s Friday so let’s close our notebooks and have a classroom discussion about our attitudes and learning. There are all sorts of
SQLU DBA Week – Set It And….
March 2, 2011
Welcome to the third day of DBA week at SQL University. On day one, I kicked off the “back to basics” journey I’ve chosen for fellow students with my post reminding you that you’re only as good as your ability to restore. Microsoft Certified Master Robert Davis brought us a good reminder on Day 2
SQLU DBA Week – You Can Restore It! (right?)
February 28, 2011
Welcome to my first contribution to SQL University’s Database Administration Week! I am going to go back to some basics here this week. I know you’ve probably been with us for a few semesters and you don’t want to hear that. That’s fine, Microsoft Certified Master Robert Davis is also covering DBA week and he
Prepare For the Disaster Before The Disaster
December 27, 2010
Kind of like some previous common sense posts inspired by mundane tasks (Day Job Tips learned from the garden, a dump trip, etc.), I was hit with another blog thought today. This goes well with my post – Plan To Fail or Don’t Expect To Succeed. Updated: Added a sound piece of advice in the
Create Your Own SQL Server Server Roles
November 14, 2010
So you’ve heard the buzz by now – Â SQL Server Denali is now available in a Community Technology Preview. This was announced, released and handed out in DVD form at the SQL PASS Summit this past week. I just got the chance to install it and I played with one feature that I could see
SQL 2008 R2 LoadFest – Session Notes
September 25, 2010
I spoke today at the SQL Server 2008 R2 Load Fest put on by Andy Novick of Novick Software. Great turnout, and it is always fun to see so many folks working together on the task of figuring out the nuances of SQL Server installations together. Also good to see that you were able to
SQL Server Licensing Myths
July 27, 2010
Which would you rather do, wade through the nuances of SQL Server licensing or a typical tax form? Some days, I think the latter would be a welcome respite. Let’s just put it this way, I bet Brent Ozar (BrentO on twitter) is happy that licensing wasn’t the biggest part of the MCM grade. (I
Linked Server Query Running Slow?
July 8, 2010
Is your SQL Server Linked Server Query running slow? Check your permissions. Maybe this is old news to you but it wasn’t for me –> It was a good day. We had finally migrated onto brand new hardware (and saw a 250% improvement in run times of most warehouse jobs). I had finally cleaned up
Hey Software Vendors – Get a Clue!
July 2, 2010
Psst. Hey Vendor – DBAs are secretly plotting against you! We hate what your products do to our environments. Sometimes we even work to get you replaced by someone else who makes a product in the same space but is “DBA-Approved”… (Quick Edit March of 2021). In the time since writing this post, I’ve grown