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
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
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
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
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
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
Take a deep dive into the many uses of dynamic SQL in Microsoft SQL Server. This edition has been updated to use the newest features in SQL Server 2016 and SQL Server 2017 as well as incorporating the
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
Expert SQL Server 2008 Development is aimed at SQL Server developers ready to move beyond Books Online. Author and experienced developerAlastair Aitchison shows you how to think about SQL Server devel
Gain insight into essential data science skills in a holistic manner using data engineering and associated scalable computational methods. This book covers the most popular Python 3 frameworks for bot
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
Foundations of SQL Server 2008 R2 Business Intelligence introduces the entire exciting gamut of business intelligence tools included with SQL Server 2008. Microsoft has designed SQL Server 2008 to be
Pro SQL Server 2008 Replication is for Microsoft database developers and administrators who want to learn about the different types of replication and those best suited to SQL Server 2008. This book w
Pro SQL Server 2008 Failover Clustering is dedicated to the planning, implementation, and administration of clustered SQL Server 2008 implementations. Whether deploying a single–instance, two–node clu
SQL Server 2005 Express Edition is a free relational database management system from Microsoft and provides a major subset of full SQL Server 2005 functionality. Many users learn on SQL Server 2005 Ex
Learn the basics of Microsoft Azure and understand how SQL Server on Azure VMs (Infrastructure-as-a-Service) and Azure SQL Databases (Platform-as-a-Service) work. This book shows you how to deploy, op
Provides information on the administration of SQL Server 2008, covering such topics as performing backups and recovery; monitoring server activity; managing security; and automating routine maintenanc
A beginner's guide to SQL Server 2005 offers a detailed overview of the new features of the relational database program and describes the core jobs and roles involved in developing an SQL Server datab
Get SQL Server up and running on the Linux operating system and containers. No database professional managing or developing SQL Server on Linux will want to be without this deep and authoritative guid
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
Take a deep dive into one of the most significant SQL Server features–support for In-Memory Online Transaction Processing. The latest developments are covered, including support of off-row storage, co
Automate your database administration workload through a combination of PowerShell and T-SQL. Automate SQL Server build processes, monitor multiple instances from a single location, and automate routi
Pro SQL Server 2008 Mirroring is your complete guide to planning, using, deploying, and maintaining database mirroring as a high-availability option. Mirroring protects you by maintaining one or more
SQL Server 2008 Query Performance Tuning Distilled presents a direct trouble–shooting methodology for identifying poorly-performing stored procedures and queries, isolating the causes of that poor per
Focusing on "out of the box" business applications, a UK management information consultant introduces Microsoft SQL Server 2008 as database management software that does not require use of dedicated g
Provides information on using SQL Server 2008 Express to create databases, covering such topics as security and compliance, creating indexes, backup and recovery, building a view, and T-SQL.
An updated guide to Microsoft's enterprise-level reporting tool discusses the new features of SQL Server 2008, with detailed coverage of such topics as building reports, using Report Designer, designi
Build a core level of competency in SQL so you can recognize the parts of queries and write simple SQL statements. SQL knowledge is essential for anyone involved in programming, data science, and data
This book is a complete guide to setting up and maintaining maintenance plans for SQL Server Database Administrators. Maintenance plans too often consist of a backup task and that’s it, but there is s
Oracle PL/SQL Recipes is your go to book for PL/SQL programming solutions. It takes a task-oriented approach to PL/SQL programming that lets you quickly look up a specific task and see the pattern for
SQL Azure represents Microsoft’s cloud-based delivery of its enterprise-caliber, SQL Server database management system (formerly under the code name "Oslo").Pro SQL Azure introduces
This instructional guide to the SQL Server 2008 Integrated Full-Text Search (iFTS) is designed for developers and programmers who need to streamline database searches and improve access to each index.
Written for both novice and professional web developers, this tutorial on the SQL Server 2008 covers installation, features, terminology and management of all database solutions. Dewson has written se
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
