Thursday, November 18, 2010

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

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

"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.

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.

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

Enjoy Reading!!!



  1. Very useful links to free ebooks..thanks Bala

  2. great reading, thanks for the postings

  3. Another good free pdf download you can add to the list is from Paul Randal of

    CommonSQLServerMyths.pdf (732.96 kb):

  4. Very useful link for eBook in PDF format, Thanks alot :)

  5. Excellent find thanks for posting.

  6. Yes, I agree, great find, thanks for sharing.

  7. Yes an excellant find, thanks for sharing

    Joe Tigeleiro
    DBA at Pearson Education
    Greater New York City

  8. These e-books are all great especially for students of who wants to learn SQL. Thanks for sharing!
    Sql training

  9. Appreciated! Its a great help for 'SQL Server' Readers n' Learners.
    Keep it up.

    Cheers !!