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
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
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
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
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
Pro Ubuntu Server Administration teaches you advanced Ubuntu system building. After reading this book, you will be able to manage anything from simple file servers to multiple virtual servers to high–
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
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
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
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
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
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
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
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
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
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
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
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.
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
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
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
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
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
MODEL clause, and advanced grouping syntax---features that will help in creating good queries for reporting and business intelligence applications. Pro Oracle SQL also helps you minimize parsing over
Pro (IBM) WebSphere Application Server 7 Internals covers the internal architecture and implementation of the WebSphere Application Server (WAS) version 7 product set and how other IBM products extend
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.
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
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 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 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
Pro Python System Administration, Second Edition explains and shows how to apply Python scripting in practice. It will show you how to approach and resolve real-world issues that most system administr
Pro SharePoint 2010 Administration is a practical guide to SharePoint 2010 for intermediate to advanced SharePoint administrators and power users, covering the out-of-the-box feature set and capabilit
Provides information on the administration of Ubuntu Server, covering such topics as working with Linux commands, using Web services, setting up a file system, and virtualization.
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
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