-
StatPress TopPosts
Category Archives: General
SQL Saturday 67 Slides Are Now Available
I recently debuted a new presentation, “What To Do When It All Goes So Wrong”. The presentation is designed to give Database Administrators a basic overview of the skills they need to handle virtually any crisis that may arise. While the target audience is DBAs, I feel that most IT Professionals can benefit from the concepts. Continue reading
Would You Like To Play A Game?
Do you have a favorite line from a holiday movie? Can you change it around slightly to make it SQL related? If so then this is the game for you. Starting this morning and going until we get bored or run out of ideas we will be playing #tsqlHolidayMovieLines on Twitter.
Continue reading
Careful with the New MCM Requirements
Be careful with the new MCM requirements. You only need the SQL 2008 certifications now. If you have already started down the 2005 path then at least you know you are not alone. I should add that I have been in contact with the right people (not naming here since they may or may not be part of the first line support) to get the incorrect page updated. It may take a couple of weeks to get the incorrect page updated with the coming holiday but I am confident they will get it taken care of. Continue reading
When is that Restore Going to Finish?
This post describes a query to get the estimated completion time of a process on SQL Server. Continue reading
Posted in General
Tagged dm_exec_requests, estimated_completion_time, percent_complete, SQL 2005, SQL 2008, SQL 2008 R2, SSC, SSP
5 Comments
What Did that Geek Just Say?
The National Institute of Standards and Technology, NIST, maintains a Dictionary of Algorithms and Data Structures. The dictionary is a great place to go to find out what people are talking about. It is also a great place to looking for different ways of doing things. I sometimes even go to the site just to look for entertaining technical concepts, like the “Cactus Stack”, “Stooge Sort” or even “Big-O Notation”. Continue reading
Quote of the Day
Today is the first day of the rest of your life. Make it yours, own the day. Repeat tomorrow. This has been your wake up call. Continue reading
Community Based Training
There is a real un-served niche in the market for DBA delivered community training materials. The idea would be to work together as a community to create common course materials and delivery scripts that would be presented by individual DBAs to the teams they support. Everyone would get roughly the same experience while having a trainer that can speak directly to their specific questions or even look at examples using their specific data. Continue reading
Why Do I Need All These Servers?
Working in a large corporate environment I am frequently getting requests for a new server to do this or that. Running through the usual questions to determine scope and scale, the price can get high pretty quickly. Inevitably, talk turns to ideas on how to cut the cost while still delivering a robust platform. Continue reading
Posted in General
Tagged Development, Disaster Recovery, DR, HA, High Availability, Production, QA, Release Management, SSC, Staging, Testing
2 Comments