[2003-09-29] Real Life DBA: Dealing with a SQL Server Cluster Failover
I had just gotten out of a short meeting and went to my desk to see what important e-mail messages I might had missed. In my inbox was a series of messages sent from ELM Enterprise Manager 3.0, the software we use to monitor our SQL Server event logs. The message had arrived about 30 minutes earlier, when I was away from my desk.
[2003-09-17] Who Needs Change Management?
You've spent thousands of dollars on that cool technology; clustering, redundant controllers, redundant disks, redundant power supplies, redundant NIC cards, multiple network drops, fancy tape backup devices and the latest and greatest tape technology. You're all set. There's no way your going to have downtime.
[2003-09-15] Comparing database structures in MSSQL server
Many firms, developing client-server applications, have a lot of the databases, from developers DB to testers DB. Keeping DB in actual state can be automated easily only if there is centralized access to all of them and there are no developments on any of them. The last influences a lot of the DB structure because there is a possibility to break it while developing.
[2003-09-15] Deleting Records From Your Database
This tutorial will demonstrate how to delete records from the database.
IMPORTANT NOTE: The first thing you must understand is that delete is final (in other words, there's no going back so backup your database before doing anything!)
[2003-09-05] Learn About SQL Server Disaster Recovery from Greg Robidoux of Edgewood Solutions
Disaster recovery is a topic on the minds of many DBAs. Learn some of the basics about SQL Server disaster recovery from a leading expert in the area, Greg Robidoux of Edgewood Solutions. Greg is currently the Vice Chair for the PASS DBA Special Interest Group (SIG). In addition, he recently gave two presentations at the PASS Summit in Seattle on Change Management and Project Management for DBAs.