Expert T-SQL Window Functions in SQL Server
by Kathi Kellenberger, Clayton Groom
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 window functions.First introduced in SQL Server 2005, window functions came ...
Price: $23.82 | Publisher: Apress | Release: 2015
Expert Performance Indexing in SQL Server, 2nd Edition
by Grant Fritchey, Jason Strate
This book is a deep dive into perhaps the single-most important facet of good performance: indexes, and how to best use them. The book begins in the shallow waters with explanations of the types of indexes and how they are stored in databases. Moving deeper into the topic, and further into the book, you will look at the statistics that are accumulated both by indexes and on indexes. You'll better under...
Price: $56.42 | Publisher: Apress | Release: 2015
Expert SQL Server in-Memory OLTP
by Dmitri Korotkevitch
Expert SQL Server In-Memory OLTP is a deep dive into one of the most significant features of SQL Server 2014 - support for In-Memory Online Transaction Processing. The book describes the architecture and internals of the In-Memory OLTP Engine and explains how to develop, deploy, and maintain systems using it. With it you can dramatically increase transactional throughput to handle thousands of transactions ...
Price: $55.40 | Publisher: Apress | Release: 2015
Pro Couchbase Server, 2nd Edition
by David Ostrovsky, Mohammed Haji, Yaniv Rodenski
This new edition is a hands-on guide for developers and administrators who want to use the power and flexibility of Couchbase Server 4.0 in their applications. The second edition extends coverage of N1QL, the SQL-like query language for Couchbase. It also brings coverage of multiple new features, including the new generation of client SDKs, security and LDAP integration, secondary indexes, and multi-dimensi...
Price: $45.06 | Publisher: Apress | Release: 2015
by Mike McQuillan
Introducing SQL Server is a fast and easy introduction to SQL Server and the world of relational databases. You'll learn how databases work and how to use the T-SQL language by practicing on one of the most widely-used and powerful database engines in the corporate world: Microsoft SQL Server.Do you quake at the sight of a SELECT statement? Start to shiver when people start talking about tables and row...
Price: $35.58 | Publisher: Apress | Release: 2015
by Peter Carter
Get a fast start to using AlwaysOn, the SQL Server solution to high-availability and disaster recovery. Read this short, 150-page book that is adapted from Peter Carter's Pro SQL Server Administration to gain a solid and accurate understanding of how to implement systems requiring consistent and continuous uptime.Begin with an introduction to high-availability and disaster recovery concepts such as Rec...
Price: $38.95 | Publisher: Apress | Release: 2015
Apache Solr Enterprise Search Server, 3rd Edition
by David Smiley
Solr is a widely popular open source enterprise search server that delivers powerful search and faceted navigation features - features that are elusive with databases. Solr supports complex search criteria, faceting, result highlighting, query-completion, query spell-checking, relevancy tuning, geospatial searches, and much more.This book is a comprehensive resource for just about everything Solr has to off...
Price: $47.86 | Publisher: Packt Publishing | Release: 2015
by Fabrizio Volpe, Alessio Giombini, Lasse Nordvik Wedo, Antonio Vargas
This book begins with the fundamental security-related tasks you should be aware of when working with Lync, before moving on to walk you through the authentication mechanisms. You will get hands-on experience with the steps required to integrate Lync with Office 365, Exchange, or trusted forests. You will explore how to use various tools such as the Bandwidth calculator, Lync resource kit tools, stress and ...
Price: $49.99 | Publisher: Packt Publishing | Release: 2015
by Ray Rischpater
JSON (JavaScript Object Notation) is a lightweight text-based data interchange format used to create objects to transfer data over the Internet. It's widely used today by common web applications, as well as mobile applications.This book gives you clear ways that you can exchange objects using JSON, regardless of whether you're developing a web or traditional networked application. You'll star...
Price: $44.99 | Publisher: Packt Publishing | Release: 2015
Chef Infrastructure Automation Cookbook, 2nd Edition
by Matthias Marschall
Chef is a configuration management tool that lets you automate your more cumbersome IT infrastructure processes and control a large network of computers (and virtual machines) from one master server, making for a smoother network without the usual hassle.Are you a system engineer or administrator who has a fundamental understanding of information management systems and infrastructures? Maybe you've alr...
Price: $44.99 | Publisher: Packt Publishing | Release: 2015