SQL Server Tacklebox- P3: This book, as with almost all books, started out as an idea. I wanted to accumulate together those scripts and tools that I have built over the years so that DBAs could sort through them and perhaps adapt them for their own circumstances. | Introduction Chapter 7 Surely like me you are afraid of break-ins. I would not like to come home and find my things strewn about wondering what all was taken. If you work for a large company that is regulated by one or more government mandates like HIPAA or SOX Sarbanes-Oxley you cannot afford to be without a security monitoring solution. Here I will introduce a set of scripts to show how to analyze login accounts the first barrier between the outside world and your data. I will also give pointers to other solutions that will help you track down potential breaches in your outer wall defenses. Chapter 8 In this chapter I will unveil the monster. It is the Data Corruption beast. Despite advances in hardware the number one cause of corruption it does still exist. You will need to first hunt out corruption before you can slay it. And you need to find it early in its lair so as to not spread the corruption to backup files. Here I will intentionally though begrudgingly corrupt a database and show some of the ways to discover and fix it emphasizing the need for a solid backup strategy. Code Download All of the scripts provided in this tacklebox as well as the full DBA Repository solution presented in Chapter 2 are available to download from http RedGateBooks RodneyLandrum . x Chapter 1 Eating SQL Server INSTALLATIONS FOR BREAKFAST For many DBAs choosing an appropriate SQL Server installation is a lot like ordering breakfast at a diner there is something to suit all appetites tastes and budgets and the range of choices can often be mind-boggling. A sample SQL Server breakfast menu might look something like this The Express Breakfast For the cost-conscious 1 SQL Server Express on top of a Windows XP Professional 1 large hard drive 2 Gig of RAM The Continental Enough to hold you over for a while 1 SQL Server Standard Edition 32 bit on Windows Server 2003 Standard 1 instance of Reporting Server 1 instance of Analysis Server 250
