Beginning SQL Server 2008 for Developers is the starting-point in the Apress roadmap of titles for developers who wish to base their projects upon Microsoft's flagship database management system. The book takes developers from the point of installing SQL Server 2008, through the process of storing,
Beginning SQL Server 2000 DBA: From Novice to Professional
β Scribed by Tony Bain, Baya Pavliashvili, Joseph Sack, Michael Benkovich, Brian Freeman (auth.)
- Publisher
- Apress
- Year
- 2004
- Tongue
- English
- Leaves
- 689
- Edition
- 1
- Category
- Library
No coin nor oath required. For personal study only.
β¦ Synopsis
SQL Server 2000 is the leading relational database in the Windows market. The increased manageability of SQL Server 2000 has also increased its popularityβanyone, not just database administrators, can use a SQL Server database.
This book recognizes that aspiring database administrators need more than just a basic knowledge of the available features in order to be considered "a safe pair of hands" for the database and the mission-critical data that is stored in it. Aspiring database administrators can benefit from the direction and advice of an expert mentor who not only understands the features available and how they should be used, but also knows what it takes to be a good and effective database administrators. In essence, this book is that "mentor," which is what sets it apart from the other books on the market that only present feature overviews.
Database novices will learn the core job and roles involved in administering a SQL Server database. You'll follow the life cycle of the database from installation, design, and modeling through to development, tuning, and securing, and onto growth and migration. This comprehensive guide provides practical advice, answers typical questions that you'll encounter from managers and developers, and offers practical steps to overcome issues with which new database administrators traditionally struggle.
At every stage of the life cycle, this book supplies a range of tried-and-tested practices and techniques that will help you to establish and maintain a healthy database system.
β¦ Table of Contents
Front Matter....Pages i-xiii
Being a DBA....Pages 1-19
SQL Server Installation....Pages 21-92
Creating a Database....Pages 93-146
DML and Querying....Pages 147-190
Basic Management Tasks....Pages 191-230
Security....Pages 231-290
Connectivity....Pages 291-330
Backup and Recovery....Pages 331-399
Replication....Pages 401-468
Development with Transact-SQL....Pages 469-532
Data Warehousing and Analysis....Pages 533-568
Data Transformation Services....Pages 569-600
Monitor, Profile, and Tune....Pages 601-623
Keeping the Plates Spinning....Pages 625-651
Back Matter....Pages 653-682
β¦ Subjects
Software Engineering/Programming and Operating Systems
π SIMILAR VOLUMES
Maybe it's just me, but it looks like the font size in this book is about a 9 ? The examples got even smaller (8 ?) and printed in a weird font that makes the text look smashed together. Wish I could have kept it, but I'm not going to kill my eyes. The search is on for another book.
SQL Server 2005 will increase your programming options, productivity, analysis, and database management. If you have some basic knowledge of relational databases and want to start a career as a developer using SQL Server, then this book is your ideal first step. It explains the core jobs and roles f
<p>SQL Server 2008 is a firstβrate database management system. It offers more capability than any previous release of SQL Server. More than just a classic relational database management system, SQL Server 2008 includes exciting and powerful features that make it useful for everything from large corp
<p>Assuming neither database nor programming background, Beginning SQL Server 2005 Express for Developers introduces all the fundamental database administration and SQL programming features of SQL Server 2005 Express Edition, the free relational database management system from Microsoft that provi
Assuming neither database nor programming background, Beginning SQL Server 2005 Express for Developers introduces all the fundamental database administration and SQL programming features of SQL Server 2005 Express Edition, the free relational database management system from Microsoft that provides a