Expert T-SQL Window Functions in SQL Server takes you from any level of knowledge of windowing functions and turns you into an expert who can use these powerful functions to solve many T-SQL queries. Replace slow cursors and self-joins with queries that are easy to write and fantastically better performing, all through the magic of...

SQL Server 2012 Data Integration Recipes provides focused and practical solutions to real world problems of data integration. Need to import data into SQL Server from an outside source? Need to export data and send it to another system? SQL Server 2012 Data Integration Recipes has your back. You'll find solutions...

Oracle Exadata Survival Guide is a hands-on guide for busy Oracle database administrators who are migrating their skill sets to Oracle's Exadata database appliance. The book covers the concepts behind Exadata, and the available configurations for features such as smart scans, storage indexes, Smart Flash Cache, hybrid columnar...

Linux and Solaris Recipes for Oracle DBAs, 2nd Edition is an example–based book on managing Oracle Database under Linux and Solaris. The book is written for database administrators who need to get work done and lack the luxury of curling up fireside with a stack of operating-system documentation. What this book provides...

• Configure ArcGIS for Server to achieve maximum performance and response time
• Understand the product mechanics to build up good troubleshooting skills
• Filled with...

• Learn cluster management and techniques to improve performance in Vertica
• Deploy local segmentation and get to grips with the concept of projections
• A simple,...

You have some experience with creating SSIS packages, but encountered some of the limitations of the out-of-the-box tasks and transformations. You are not an experienced programmer, but maybe you have adjusted an...

Pragmatic Enterprise Architecture is a practical hands-on instruction manual for enterprise architects. This book prepares you to better engage IT, management, and business users by equipping you with the tools and knowledge you need to address the most common enterprise architecture challenges. You will come away with a pragmatic...

Welcome to the seventh volume of the must-have reference series for game developers, Game Programming Gems, the series that helped define the standards for game programming and continues to be an essential source for new, innovative techniques. "Game Programming Gems 7" provides the tools and inspiration that game developers need to...