I just put the finishing touches on a new custom monitor in Operations Manager. This monitor rolls up into the ‘Availability’ monitor for the SQL 2000 and SQL 2005 DB targets. The monitor will run a script that reads from the msdb database, joined to the master database. The idea is that we only want … Read more
The other day we had one of our backup drives fill up. Turns out that it was our BizTalk development server, which had been running for a few months now. We have been evaluating BizTalk for a while and are close to going to production. One of the items discussed prior to a production deployment … Read more
The original idea for this blog was to write about some of the craziest things you would ever want to do with MS SQL Server. Things like building DTS packages that have a single T-SQL task that executes a stored procedure, or building a database that has but a single table with 800 million rows … Read more
Of course, nothing ever happens at work until you want to log off and head home. Such was the case yesterday. I was shutting down my laptop when I received a phone call from a colleague who needed help with a query. Seems as if the results of their select were returning decimals with a … Read more
Here is something that happened in our shop last week. We had a developer sound a fire alarm because he found that his server was paging. He was kind enough to send along a screenshot from task manager: This server is running 2003 R2, x64 Enterprise, SP2, with 4 CPU (hyper-threaded). The task manager has … Read more
The other day I needed to describe the funny sound my car was making to my mechanic. If anyone is reading this there is probably a good chance that you have tried to do something similar at some point in your life. maybe not your car, but at some point you have had the need … Read more
