Have you been considering a career change and thinking about becoming a SQL Server DBA
(database administrator)? Perhaps you've been given the responsibility oflooking after a SQJ. Server
and you aren't quite sure what this really means or where you should start? Maybe you're just
interested in finding out what on earth DBAs do all day long! Many books will teach you the SQL
Server DBA functions but being a DBA is more than just simply understanding the tools of SQL
Server. It's also about applying solid processes and utilizing those tools for the overall benefit of your
business or client.
There are two types of DBAs: the reactive DBA and the proactive DBA. Reactive DBAs understand
how to use SQL Server but lack the process skills needed to manage SQL Server in an effective way.
Reactive DBAs spend much of their time "fighting fires," that is, fixing problems as they occur, such as
adding more disk space when it runs out, trying to improve performance when users complain of poor
response times, and implementing security once someone has stolen your customer list. Sure, reactive
DBAs fix problems when things get broken, but they do this at a cost to your business-costs measured
in idle time as employees sit waiting for the system to become available; costs calculated in missed
revenue opportunities. Reactive DBAs are unfortunately common and are often viewed as a necessary
evil by many businesses.
The proactive DBA on the other hand takes what they know about SQL Server and applies tested
processes to forewarn clients of potential issues so that future problems are avoided before they
become an issue. They test contingency plans for those rare occasions when unexpected problems do
occur and they plan resource requirements so spare capacity is always available before it's required.
They automate the day-to-day maintenance of SQL Server and work to continuously improve their
processes in order to ensure that the business they are working gets high, reliable performance from its
SQL Server databases. Proactive DBAs are respected and often seen as a valuable asset to their
As a DBA and a consultant I have had the pleasure of working with hundreds of DBAs in all types of
businesses. I have been lucky to see the outstanding results good practices can make, and the utter
shambles bad practices can lead to. Throughout this book I have shared many good practices so you
can easily learn as much as possible. This book is about teaching you to be a SQL Server DBA. But
most importantly, it teaches you how to be a proactive SQL Server DBA.
Irreversible Phenomena: Ignitions, Combustion and Detonation Waves
Ideals are simple and able to be easily understood, but never exist in reality.
In this book a theory based on the second law of thermodynamics and its applications are described. In thermodynamics there is a concept of an ideal gas which satisfies a mathematical formula PV = RT. This formula can approximately be applied to the...
Molecular Neurosurgery with Targeted Toxins
Pioneers and leading researchers explain the theory and techniques of using targeted toxins experimentally. The highly successful use of the 192 IgG-saporin and ME20.4-saporin immunotoxins to lesion the cholinergic basal forebrain in order to model the behavior, anatomy, physiology, and pharmacology of Alzheimer's disease in animals is...
The Satellite Communication Applications Handbook (Space Applications Series) Throughout the 1990s, the satellite communication industry experienced tremendous
growth, surpassing the expectations of all who have contributed to its success.
The gross revenues in 2000 reached $60 billion, big chunks of which were
contributed by satellite manufacture, launch, satellite transponder sales and leases,
SmartWatch Design Fundamentals: WatchFace Design for Samsung Galaxy SmartWatches
Gain concepts central to smartwatch design, editing and animation correction using the popular open source Galaxy Watch Designer software package. This visual guide builds upon the essential concepts of smartwatch design, decoration, digital imaging, animation, function integration, and visual effects, and gets more advanced as chapters...
Managing Software Debt: Building for Inevitable Change
Shipping imperfect software is like going into debt. When you incur debt, the illusion of doing things faster can lead to exponential growth in the cost of maintaining software. Software debt takes five major forms: technical, quality, configuration management, design, and platform experience. In today’s rush to market, software debt is...
Personal Firewalls for Administrators and Remote Users
Personal firewalls explained—for remote corporate and home users.
In today's work environment, increasing numbers of mobile employees are using PCs, laptops, and handheld devices to connect to corporate servers. That's great for productivity, but it can also pose a security nightmare. Many of these...