This book will cover different aspects of the Transact SQL (TSQL) language. It takes the readers step by step through the TSQL language, one concept at a time. Each topic covers a particular aspect of TSQL with discussion and examples.

This book is the only in-depth look at how to improve your SQL query performance through careful design of execution plans, leads you right from the basics of capturing plans to diagnose the most common causes of poor query performance, and so optimize your SQL queries, and improve your indexing strategy.

This book is for anyone using SQL Server as a programmer, an administrator, or even a user, who wants to understand how SQL Server manages multiple sessions, and what causes excessive blocking.

This book shows you how to set-up a reliable, tested, SQL Server backup and restore plan. Get tips for recovering your data with minimum downtime. Learn how to minimize data loss when disaster strikes.

How to use of 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 "normal" development.

This book investigates all of the DMVs that are most frequently useful to the DBA in investigating query execution, index usage, session and transaction activity, disk IO, and how SQL Server is using or abusing the operating system.

The book will get you started with query processing fundamentals to help you write powerful, performant Transact-SQL (T-SQL) queries. You will then focus on query execution plans and learn how to leverage them for troubleshooting.

This book is an introductory text that introduces Microsoft Access Office 365 and relational database design. Attempted to give a suitable introduction to normalization theory for the beginning database usersas, well as entity relationship diagrams.

Speed up your development with ORMs and discover the gotchas' involved. Learn the best practices for efficiently indexing tables. Get expert advice on writing well-formed SQL queries. Topics covered: ORM Tips, T-SQL Tips, Index Tips, Database Design Tips.

With this book, you will learn how to build and deploy your own ETL solution in a drag-and-drop development environment by using SSIS packages, control flows, data flows, tasks, and more.

In this book, the authors explain how SQL Server 2014 incorporates in-memory technology to boost performance in online transactional processing (OLTP) and data-warehouse solutions.

This book delivers a business intelligence solution is broken down into simple steps to help you turn raw data into an interactive reporting dashboard. It walks you through the layers of a BI solution, how to develop a tabular data model with SSAS

You will learn how to implement a business intelligence solution through SQL Server Analysis Services. You'll start with developing a database, and learn which architecture is most appropriate for the database's end use.

This book provides the hands-on introduction you need to get started, and explores all of the technology's most important strengths and weaknesses.

This book is designed to specifically teach beginners how to use Microsoft Access, but even longtime users of the program can learn something. The techniques and the concepts covered, however, will work with all recent versions.

This book guides you step-by-step through every phase of FILESTREAM implementation, from enabling the feature, to creating FILESTREAM tables, to manipulating FILESTREAM data through the streaming APIs.

The author's insight will leave you with an excellent foundation in the practicalities of the Query Optimizer, and everything you need to know to start tuning your queries to perfection.

The author has taken the time to reallv drill into the behavior of a small set of execution plan operators in an effort to explain the optimizer's behavior. He's explored why things happen, how you can change them, positively or negatively, and he's done it all in an approachable style.

This book is designed to provide the fundamental knowledge and resources you need to make intelligent choices about optimal installation and configuration of SQL Server hardware, operating system and the SQL Server RDBMS.

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.

Find out how the Maintenance Plan tools let you configure and schedule core database maintenance tasks such as integrity checks, index reorganizations and rebuilds.

It explains what "statistics" are, why they are there, how they are created, updated and removed. He shows how to inspect them and to maintain them. It also lists all the problems that are related to these statistics objects, and how to solve them.

This book brings you a variety of articles on all aspects of SQL Server from administration to XML and everything in between.

Each one tackles a key area of database development, administration or deployment and provides both a management view and a technical view of that topic. Each starts with the business reasons that will underpin a certain technology requirement, etc.

This book explores the exciting enhancements and new capabilities engineered into SQL Server, ranging from improvements in operation to those in reporting and management.

This book is for anyone who has an interest in SQL Server 2008 R2 and wants to understand its capabilities.