A 2nd edition of Brad McGehee's popular career guide for DBAs, designed to help new and prospective DBAs find their feet in the profession, and to advise those more-experienced on how they can excel at their jobs, and so become Exceptional DBAs.

When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works. An effective response to a crisis requires rapid decisions based on understanding its role in ensuring data integrity.

Looking for perfect health? Fortunately your search is over forever

We live in a world where the public is being lied to and brainwashed more than ever before.Take S.T.D.'s for example: The scammers have convinced virtually everybody on this planet that they are REAL.Well, I tell you that they are NOT.All S.T.D.'s are SCAMS and AIDS is a global deadly HOAX that has killed millions of innocent people around the globe.FACT: Diseases are NOT contagious and VIRUSES do NOT exist.Stop living your life in fear and enjoy sex worry free forever.Free love was never over and never will be

Few software developers would build an application without using source control, but its adoption for databases has been slower. Yet without source control to maintain the scripts necessary to create our database objects, load lookup data, and take other actions, we cannot guarantee a reliable and repeatable database deployment process, let alone coordinate database upgrades with changes to the application. We also run the risk that our "ad hoc" database patching will cause inconsistencies and data loss. Source control can and should play a key role in the database development and deployment...