Items related to SQL Server 7 Administration

SQL Server 7 Administration - Softcover

Linsenbardt, Mark A.; Stigler, M. Shane; Stigler, Shane

 
9780072121476: SQL Server 7 Administration

Synopsis

Case studies: boxed text elements providing real scenarios based on the authors' consulting experience--but not containing company names. Each case study describes the type of business, number of databases running, number of users, and the situation that was solved with specific steps. On-line scripts: These are downloadable from Osborne's website and include SQL statements that can be used to build stored proceduers that apply to all databases and script examples of advanced techniques that must be tweaked for specific scenarios.

"synopsis" may belong to another edition of this title.

About the Author

Shane Stigler, MCSE, MCT (Las Vegas), is president of Stigler Consulting, an international consulting firm for medium and large companies on corporate MIS management and network design. He is also a corporate trainer for Productivity Point International; his clients include Bank of America, Citibank, Mirage, the City of Las Vegas and others. Mark Linsenbardt, MCSE, MCT (Las Vegas), is an independent consultant, trainer, speaker and author.

From the Back Cover

Maintain high-performance, mission-critical SQL Server databases Install, manage, and troubleshoot SQL Server 7

From discussions of simple-machine installations to complex replication models able to handle linked machines on multiple continents, this book is filled with real-world examples and expert advice. Written by professional SQL Server administrators for professional SQL Server administrators, the book features the authors' own real-world experience and helps you address the problems you confront most often. No SQL Server DBA should be without this authoritative, hands-on resource.

  • Install SQL Server and handle unattended installations
  • Understand the construction and usage of all the system databases, including the Master, Model, MSDB, Distribution, and TempDB databases
  • Implement security measures--mapping logins, permissions, application roles, stored procedures, and views
  • Handle data storage, manipulation, and backup, including the use of DTS, new stored procedures, and Enterprise Manager wizards
  • Monitor, troubleshoot, and achieve blazing performance with various tools, including event viewer, query analyzer, SQL Profiler, Windows NT Performance Monitor, and more
  • Automate SQL Server to perform simple and complex tasks at regular intervals
  • Implement real-world data replication.

"About this title" may belong to another edition of this title.