Book Description:
Written by industry professionals who have been working with SQL Server 2008 since the earliest code, this reference expertly covers the programming fundamentals for SQL Server 2008 with crucial real-world context and extensive code samples.

Get the hands-on programming instruction, practical examples, and best practices you need to master the core programmability features in SQL Server 2008. Led by three experts in database design and business intelligence solutions, you ll learn the essential tools and techniques for developing robust applications.
Read more and Download →

Sams Teach Yourself SQL in 24 Hours, Third Edition presents the key features of SQL (Structured Query Language) in an easy to understand format with updated code examples, notes, diagrams, exercises, and quizzes. New material covers more information on transactions, constructs, embedded databases, and object-oriented programming. In this edition, the authors include examples based on a database like MySQL, a very popular open source database.
Read more and Download →

SQL Server 2005 provides the database application programmer with a rich new development platform by hosting the .NET Framework Common Language Runtime environment (CLR). With new capabilities come new roles and responsibilities for the Database Administrator (DBA). This whitepaper helps the DBA determine appropriate use of this new feature and guidance on when other alternatives may provide better performance, flexibility or capabilities. As well as offering guidance on suitable uses for the Database Engine .NET Framework Programming API this whitepaper also suggests code, change and release management processes that should be tailored to each DBA?s individual circumstances to ensure a professional and safe deployment.
Read more and Download →

Welcome to Sams Teach Yourself Microsoft SQL Server 7.0 in 21 Days. We hope this book will help not only teach you about SQL Server but also prove valuable for everyday work involving SQL Server. We have worked hard to see that the skills you learn from this book will easily translate into real-world methods and solutions.
There are certain skills you need to successfully install, administer, troubleshoot, and configure SQL Server. The kinds of skills you must know can be divided into two general categories:
* SQL Server programmer
* SQL Server administrator
Read more and Download →

Database administrators in enterprises today face the challenging task of determining an appropriate physical design that consists of partitioned tables, indexes, and indexed views and that both optimizes server performance and is easy to manage. Database Engine Tuning Advisor (DTA) in Microsoft SQL Server 2005 can assist in this task. Given a workload of SQL queries and updates, DTA recommends an appropriate physical design, and generates a script to implement the recommended physical design. For more advanced database administrators, DTA exposes a powerful mechanism to perform efficient exploratory what-if analysis of different physical design alternatives. DTA can be used against both SQL Server 2005 and SQL Server 2000.
Read more and Download →