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.

It provides an accessible overview of the field of statistical learning, an essential toolset for making sense of the vast and complex data sets that have emerged in fields ranging from biology to finance to marketing to astrophysics in the past.

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 explores the exciting enhancements and new capabilities engineered into SQL Server, ranging from improvements in operation to those in reporting and management.

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

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.

This book is designed to specifically teach beginners how to use Microsoft Access, but even longtime users of the program can learn something.

This book is the only in-depth look at how to improve your SQL query performance through careful design of execution plans.

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

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.

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

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.

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

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.

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 is the previous page of Microsoft SQL Server and Access®, we are in the processing to convert all the books there to the new page. Please check this page again!!!