Download SQL Server ebooks for free

You can download the following ebooks and enhance your SQL knowledge.

SQL Server Team-Based Development

By Phil Factor, Grant Fritchey, Alex Kuznetsov, and Mladen Prajdić

This book shows how to use of a mixture of home-grown scripts, native SQL Server tools, and tools from the Red Gate SQL Toolbelt, to successfully develop database applications in a team environment, and make database development as similar as possible to "normal" development.

Following are the topics covered in this book:

Chapter 1: Writing Readable SQL

Chapter 2: Documenting your Database

Chapter 3: Change Management and Source Control

Chapter 4: Managing Deployments

Chapter 5: Testing Databases

Chapter 6: Reusing T-SQL Code

Chapter 7: Maintaining a Code Library

Chapter 8: Exploring your Database Schema

Chapter 9: Searching DDL and Build Scripts

Chapter 10: Automating CRUD

Chapter 11: SQL Refactoring

http://www.red-gate.com/specials/Ebooks/teamdevelopment.htm

SQL Server Tacklebox

Essential Tools and Scripts for the day-to-day DBA

By Rodney Landrum

The book focuses on these topics:

1.      Installing SQL Server

2.      SQL Server Documentation

3.      How to Move Data Into and Out of SQL Server

4.      How to Manage Data Growth

5.      How to Use System Tables and DMVs to Investigate What SQL Server is Doing

6.      Monitoring and Notification

7.      Security Monitoring

8.      Finding and Fixing Data Corruption

http://www.red-gate.com/products/sql_Monitor/offers/monitor_tacklebox.htm

"Brad's Sure Guide to SQL Server Maintenance Plans"

Brad’ Sure Guide to SQL Server Maintenance Plans is now available as a free, 269 page PDF eBook. The book is designed for part-time or novice DBAs who want to learn how to properly create Maintenance Plans using the tools that come with SQL Server Management Studio (SSMS) in SQL Server 2005/2008.

These two tools include:

• Maintenance Plan Wizard – a Wizard that steps the user through the process of setting up basic Maintenance Plans, with limited options.
• Maintenance Plan Designer – a drag-and-drop GUI interface in SSMS that facilitates the design and creation of more flexible, customizable maintenance plans.

http://www.red-gate.com/products/SQL_Backup/offers/backup_maintenance_plans.htm?utm_source=sqlaloha&utm_medium=blogpost&utm_content=maintenance201001&utm_campaign=sqlbackup

Defensive Database Programming

By Alex Kuznetsov

The goal of Defensive Programming is to produce resilient code that responds gracefully to the unexpected.

To the SQL Server programmer, this means T-SQL code that behaves consistently and predictably in cases of unexpected usage, doesn't break under concurrent loads, and survives predictable changes to database schemas and settings.

Inside this book, you will find dozens of practical, defensive programming techniques that will improve the quality of your T-SQL code and increase its resilience and robustness.

http://www.red-gate.com/specials/Ebooks/defensive_database_programming.htm

Introducing Microsoft SQL Server 2008 R2

By Ross Mistry and Stacia Misner!

The book contains 10 chapters and 216 pages, like so:

PART I   Database Administration

CHAPTER 1   SQL Server 2008 R2 Editions and Enhancements 3
CHAPTER 2   Multi-Server Administration 21
CHAPTER 3   Data-Tier Applications 41
CHAPTER 4   High Availability and Virtualization Enhancements 63
CHAPTER 5   Consolidation and Monitoring 85

PART II   Business Intelligence Development

CHAPTER 6   Scalable Data Warehousing 109
CHAPTER 7   Master Data Services 125
CHAPTER 8   Complex Event Processing with StreamInsight 145
CHAPTER 9   Reporting Services Enhancements 165
CHAPTER 10   Self-Service Analysis with PowerPivot 189

http://blogs.msdn.com/b/microsoft_press/archive/2010/04/14/free-ebook-introducing-microsoft-sql-server-2008-r2.aspx

Enjoy Reading!!!