Mastering SQL Server Profiler

Mastering SQL Server Profiler
Title Mastering SQL Server Profiler PDF eBook
Author Brad McGehee
Publisher Red Gate Software
Pages 306
Release 2009
Genre Client/server computing
ISBN 1906434115

Download Mastering SQL Server Profiler Book in PDF, Epub and Kindle

The Guru's Guide to SQL Server Architecture and Internals

The Guru's Guide to SQL Server Architecture and Internals
Title The Guru's Guide to SQL Server Architecture and Internals PDF eBook
Author Ken Henderson
Publisher Addison-Wesley Professional
Pages 1076
Release 2004
Genre Computers
ISBN 9780201700473

Download The Guru's Guide to SQL Server Architecture and Internals Book in PDF, Epub and Kindle

bull; Contains the most depth and breadth of coverage of any book on SQL Server architecture, internals, and tuning bull; Will be a key reference for anyone working with SQL Server, no matter what their skill level bull; The latest book in the bestselling series of Guru's Guides from Ken Henderson

Mastering SQL Server 2008

Mastering SQL Server 2008
Title Mastering SQL Server 2008 PDF eBook
Author Michael Lee
Publisher John Wiley & Sons
Pages 795
Release 2009-01-16
Genre Computers
ISBN 0470467398

Download Mastering SQL Server 2008 Book in PDF, Epub and Kindle

As Microsoft’s bestselling database manager, SQL Server is highly flexible and customizable, and has excellent support—the 2008 version offers several significant new capabilities. This book offers accurate and expert coverage on the updates to SQL Server 2008 such as its enhanced security; the ability to encrypt an entire database, data files, and log files without the need for application changes; a scalable infrastructure that can manage reports and analysis of any size and complexity; and its extensive performance data collection.

Microsoft SQL Server 2012 Performance Tuning Cookbook

Microsoft SQL Server 2012 Performance Tuning Cookbook
Title Microsoft SQL Server 2012 Performance Tuning Cookbook PDF eBook
Author Ritesh Shah
Publisher Packt Publishing Ltd
Pages 707
Release 2012-07-26
Genre Computers
ISBN 1849685754

Download Microsoft SQL Server 2012 Performance Tuning Cookbook Book in PDF, Epub and Kindle

Over 80 recipes to help you tune SQL Server 2012 and achieve optimal performance.

Mastering SQL Server 2000

Mastering SQL Server 2000
Title Mastering SQL Server 2000 PDF eBook
Author Mike Gunderloy
Publisher John Wiley & Sons
Pages 1232
Release 2006-02-20
Genre Computers
ISBN 0782153364

Download Mastering SQL Server 2000 Book in PDF, Epub and Kindle

Complete. Authoritative. Practical. The only SQL Server book you need. Mastering SQL Server 2000 is the one indispensable resource for anyone working with the latest version of SQL Server. Whether you build or administer SQL Server databases or write applications that communicate with them, you'll find the background knowledge and the practical instruction you need to accomplish any task, from the most basic to the most advanced. Coverage includes: Understanding SQL Server architecture Designing an efficient normalized database Writing Transact-SQL statements and batches Creating databases Creating tables and views Creating stored procedures and triggers Administering SQL Server Managing SQL Server security Designing applications using ADO, SQL-DMO, and SQL-NS Using Data Transformation Services Integrating SQL Server with the Internet Optimizing SQL Server performance Understanding and managing replication Using Analysis Services to analyze data Using Microsoft English Query Troubleshooting common problems

Microsoft SQL Server 2012 Step by Step

Microsoft SQL Server 2012 Step by Step
Title Microsoft SQL Server 2012 Step by Step PDF eBook
Author Patrick LeBlanc
Publisher Pearson Education
Pages 631
Release 2013-02-15
Genre Computers
ISBN 073567003X

Download Microsoft SQL Server 2012 Step by Step Book in PDF, Epub and Kindle

Your hands-on, step-by-step guide to building applications with Microsoft SQL Server 2012 Teach yourself the programming fundamentals of SQL Server 2012—one step at a time. Ideal for beginning SQL Server database administrators and developers, this tutorial provides clear guidance and practical, learn-by-doing exercises for building database solutions that solve real-world business problems. Discover how to: Install and work with core components and tools Create tables and index structures Manipulate and retrieve data Secure, manage, back up, and recover databases Apply techniques for building high-performing applications Use clustering, database mirroring, and log shipping

Brad's Sure Guide to SQL Server Maintenance Plans

Brad's Sure Guide to SQL Server Maintenance Plans
Title Brad's Sure Guide to SQL Server Maintenance Plans PDF eBook
Author Brad McGehee
Publisher
Pages 281
Release 2010-01
Genre Client/server computing
ISBN 9781906434342

Download Brad's Sure Guide to SQL Server Maintenance Plans Book in PDF, Epub and Kindle

In his new book, Brad's Sure Guide to SQL Server Maintenance Plans, Brad McGehee takes you on a comprehensive tour of two SQL Server tools designed to help DBAs ensure that a "required minimum" level of maintenance takes place on their SQL Server instances: the Maintenance Plan Wizard and the Maintenance Plan Designer. Table of Contents * Chapter 01: Why is Database Maintenance Important? Chapter 02: Before you Create any Maintenance Plans Chapter 03: Getting Started with the Maintenance Plan Wizard Chapter 04: Task Scheduling Chapter 05: Check database Integrity Task Chapter 06: Shrink Database Task Chapter 07: Rebuild Index Task Chapter 08: Reorganize Index Task Chapter 09: Update Statistics Task Chapter 10: Execute SQL Server Agent Job Task Chapter 11: History Cleanup Task Chapter 12: Define Back Up Database (Full) Task Chapter 13: Define Back Up Database (Differential) Task Chapter 14: Back Up Database (Transaction Log) Task Chapter 15: Maintenance Cleanup Task Chapter 16: Using the Maintenance Plan Designer Why read this book? Millions of SQL Server instances run in the offices of small and medium-sized organizations and there are many "accidental" DBAs out there whose job it is to maintain them. Often, they find that they don't have the knowledge, experience, or critically the time, to perform the correct level of maintenance on their SQL Server databases, much as they might like to. This can mean poor performance and reduced availability. Regardless of the size of your organization, if your mission critical data becomes unavailable, then business will suffer greatly. The Maintenance Plan Wizard and Designer allow you to configure and schedule eleven core database maintenance tasks, ranging from integrity checks, to database backups, to index reorganizations and rebuilds. Brad walks through every one of these tasks covering: * The intent of each task and why it's important * How to configure each task and what all the options mean * Scheduling considerations: when and how often should you run the task? * Customizing and extended your Maintenance Plans using the Designer Used carefully, these Maintenance Plan tools represent powerful time-saving devices for any DBA. At each stage of the book, Brad explains clearly the correct and incorrect uses for the tool, and indicates where more advanced solutions, using T-SQL or PowerShell scripting, would be more appropriate.