Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
Beginning SQL Server 2000 DBA: From Novice to Professional

Buy
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 business.

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.
(HTML tags aren't allowed.)

Irreversible Phenomena: Ignitions, Combustion and Detonation Waves
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
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)
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,
ground
...

SmartWatch Design Fundamentals: WatchFace Design for Samsung Galaxy SmartWatches
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
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 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...

©2019 LearnIT (support@pdfchm.net) - Privacy Policy