SQL Server 2012 Data Integration Recipes

Deliver advanced functionality faster and cheaper by exploiting SQL Server's ever-growing amount of built-in support for modern data formats. Learn about the growing support within SQL Server for

Learn how to develop powerful data analytics applications quickly for SQL Server database administrators and developers. Organizations will be able to sift data and derive the business intelligence ne

SQL Server Integration Services Design Patterns is newly-revised for SQL Server 2014, and is a book of recipes for SQL Server Integration Services (SSIS). Design patterns in the book help to solve com

Here is the ideal field guide for data warehousing implementation. This book first teaches you how to build a data warehouse, including defining the architecture, understanding the methodology, gather

Intended for SQL Server developers and administrators, this desk reference provides Transact-SQL solutions for modifying data, creating tables and indexes, performing calculations, executing stored pr

This book covers essentials of data warehousing. Each chapter introduces a data warehouse component, and then shows how to use Microsoft SQL Server 2005 and 2008 to build that component into an ongoin

From fundamentals to advanced topics, this book teaches readers not only how to use SQL Server Integration Services (SSIS), but also how to make integration projects stronger, faster, and smarter. The

Provides a comprehensive overview of T-SQL and its new features offered in SQL Server 2005 and discusses a wide variety of practical applications, including SQL Server 2005 T-SQL recipes and their use

Be guided through the techniques to back up and restore databases and files in SQL Server. Multiple techniques are presented for ensuring the integrity and consistency of database backups, as well as

Quickly find solutions to dozens of common problems encountered while using XML and JSON features that are built into SQL Server. Content is presented in the popular problem-solution format. Look up t

Learn SQL Server Reporting Services and become current with the 2016 edition. Develop interactive, dynamic reports that combine graphs, charts, and tabular data into attractive dashboards and reports

Every business has reams of business data locked away in databases, business systems, and spreadsheets. While you may be able to build some reports by pulling a few of these repositories together, act

Every day, organizations large and small fall victim to attacks on their data. Encryption provides a shield to help defend against intruders. Because of increasing pressure from government regulators,

Designed for senior web developers, this reference carefully considers the riches of the databound controls and database functionality features and cuts the best out of the herd. Master developer Steh

Protect your data from attack by using SQL Server technologies to implement a defense-in-depth strategy for your database enterprise. This new edition covers threat analysis, common attacks and counte

Carry out data analysis with PySpark SQL, graphframes, and graph data processing using a problem-solution approach. This book provides solutions to problems related to dataframes, data manipulation su

Build a custom BimlExpress framework that generates dozens of SQL Server Integration Services (SSIS) packages in minutes. Use this framework to execute related SSIS packages in a single command. You w

* An essential book for new and migration projects for SQL Server 2005: will ensure that that such projects have a well-designed database and secure, optimized data access strategies right from the st

Learn the intricate workings of DAX and the mechanics that are necessary to solve advanced Power BI challenges. This book is all about DAX (Data Analysis Expressions), the formula language used in Power BI―Microsoft’s leading self-service business intelligence application―and covers other products such as PowerPivot and SQL Server Analysis Services Tabular. You will learn how to leverage the advanced applications of DAX to solve complex tasks.Often a task seems complex due to a lack of understanding, or a misunderstanding of core principles, and how certain components interact with each other. The authors of this book use solutions and examples to teach you how to solve complex problems. They explain the intricate workings of important concepts such as Filter Context and Context Transition. You will learn how Power BI, through combining DAX building blocks (such as measures, table filtering, and data lineage), can yield extraordinary analytical power. Throughout Pro Dax with Power BI t

Loaded with code examples and practical solutions, this encyclopedic treatment includes all aspects of programming a database with SQL (Subsequent Server Language) 2005 and pulling the data into an ap