Use this fast and complete guide to optimize the performance of MongoDB databases and the applications that depend on them. You will be able to turbo-charge the performance of your MongoDB applications to provide a better experience for your users, reduce your running costs, and avoid application growing pains. MongoDB is the world's most popular document database and the foundation for thousands of mission-critical applications. This book helps you get the best possible performance from MongoDB.MongoDB Performance Tuning takes a methodical and comprehensive approach to performance tuning that begins with application and schema design and goes on to cover optimization of code at all levels of an application. The book also explains how to configure MongoDB hardware and cluster configuration for optimal performance. The systematic approach in the book helps you treat the true causes performance issues and get the best return on your tuning investment. Even when you're under pressure and
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
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
Readers will learn by example how to use Microsoft SQL Server 2016 Integration Services (SSIS) as they design and implement extract, transform, and load (ETL) solutions to support a business applicati
Practical SQL is an approachable and fast-paced guide to SQL (Structured Query Language), the standard programming language for defining, organizing, and exploring data in relational databases. The bo
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
A fully updated, definitive guide to SQL Server 2016 Reporting ServicesCreate, deploy, and manage robust business intelligence reports using the expert tips and best practices contained in this thorou
Gain a solid understanding of T-SQL—and write better queriesMaster the fundamentals of Transact-SQL—and develop your own code for querying and modifying data in Microsoft SQL Server 2016. Led by a SQL
Nowadays, virtually every significant SQL Server database application needs to incorporate some form of high availability right from the outset.SQL Server 2016 High Availability Unleashed is the first
A practical guide to data mining using SQL and ExcelData Analysis Using SQL and Excel, 2nd Edition shows you how to leverage the two most popular tools for data query and analysis—SQL and Excel—to per
Business Intelligence with SQL Server Reporting Services helps you deliver business intelligence with panache. Harness the power of the Reporting Services toolkit to combine charts, gauges, sparklines
Master Windows Server installation and configuration with hands-on practice and interactive study aids for the MCSA: Windows Server 2012 R2 exam 70-410MCSA: Windows Server 2012 R2 Installation and Con
Learn how to write, tune, and port SQL queries and other statements for a Big Data environment, using Impala—the massively parallel processing SQL query engine for Apache Hadoop. The best practices in
Packed with practical examples, this book looks at a different aspect of performance tuning in each chapter and shows you how to apply them to their existing Java applications. Anyone with an interest
PL/SQL is Oracles proprietary variant of the industry standard Structured Query Language (SQL.) In order to effectively develop or maintain - or even use - an Oracle database you need to have a good w
Learn the latest SQL Server 2014 database design methods for career advancement; among them in-memory OLTP tables, FileTable FILESTREAM storage and ColumnStore indexes. Relational database design teac
Fill the gap between planning and doing with SSIS 2014The 2014 release of Microsoft's SQL Server Integration Services provides enhancements for managing extraction, transformation, and load operations
This is the Lab Manual to accompany Exam 70-411 Administering Windows Server 2012.This 70-411 Administering Windows Server 2012 textbook covers the second of three exams required for Microsoft Certifi
As with previous versions of this Oracle Press bestseller, Oracle Database 11g Performance Tuning Tips & Techniques provides instructions that explain the best ways of maintaining a high-performance O
Now available in paperback— Service Broker is a key Microsoft product in support of message–based processing between applications. Pro SQL Server 2008 Service Broker helps you to take full advantage o
This is a practical guide providing comprehensive solutions for SQL query problems, and is full of concrete real-world examples to help you create and troubleshoot your SQL queries in SAP Business One
The soup-to-nuts guide on all things SQL! SQL, or structured query language, is the international standard language for creating and maintaining relational databases. It is the basis of
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
The ideal on-the-job reference guide for SQL Server 2008 database administrators If you manage and administer SQL Server 2008 in the real world, you need this detailed guide at your desk. From planni
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
This tutorial breaks down the role of "SQL Server Administrator" into its key focus areas and tasks while providing the techniques and practices that make an administrator effective.
A guide to the Oracle database server covers such topics as events, fixed tables, SQL statements, PL/SQL packages, application development performance, Oracle NET, and utilities.
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
As Microsoft’s bestselling database manager, SQL Server is highly flexible and customizable, and has excellent support—the 2008 version offers several significant new capabilities. This book offers ac
Maximize the Business Intelligence Tools in Microsoft SQL Server 2008 Manage, analyze, and distribute enterprise data with help from this expert resource. Delivering Business Intelligence with Micros
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.
This textbook outlines the structure of Oracle?‥?s primary database language PL/SQL as a server-side Web scripting language for developing AJAX Web applications. It covers topics like Oracle SQL, Ora
The new edition of the successful previous version is 25 percent revised and packed with more than 200 pages of new material on the 2008 release of SQL Server Integration Services (SSIS) Renowned aut
A guide to designing and implemeting database solutions using SQL Server covers such topics as relational theory, data modeling, database security, normalization, and concurrency.
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
Unlocks the power of Structured Query Language (SQL) in Microsoft Access. This book guides the reader through step-by-step examples that use SQL script in Microsoft Access to create tables, add record
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
