Getting Started with SQL Server 2014 Administration

Getting Started with SQL Server 2014 Administration, 9781782172413 (1782172416), Packt Publishing, 2014

Optimize your database server to be fast, efficient, and highly secure using the brand new features of SQL Server 2014

About This Book

Design your SQL Server 2014 infrastructure by combining both onpremise and WindowsAzurebased technology
Implement the new InMemory OLTP database engine feature to enhance the performance of your transaction databases
This is a handson tutorial that explores the new features of SQL Server 2014 along with giving real world examples

Who This Book Is For

If you want to create an highly efficient database server then this book is for you. This book is for database professionals and system administrators who want to use the added features of SQL Server 2014 to create a hybrid environment, which is both highly available and allows you to get the best performance from your databases.

What You Will Learn

Design a SQL Server infrastructure combining on-premise servers and Windows Azure Storage
Create a backup strategy that allows you to store your SQL Server backup in the Windows Azure cloud
Improve database performance by using the In-Memory OLTP features
Implement the delayed durability feature to improve transaction latency
Use a cloud-based replica to build an AlwaysOn Availability Group
Learn the other enhancements and new features that can help improve database performance

In Detail

The release of SQL Server 2014 has brought with it some great new features and enhancements that database administrators can use to make their database servers faster, highly available, and protected from disaster. As the lines between on-premise and on-cloud based solutions become even more blurred, enterprise database applications such as SQL Server 2014 have evolved to allow DBAs to utilize both services to maintain their key service level agreements, ensuring that their important databases are always available. SQL Server 2014 has a strong focus on business intelligence, making it a vital tool if you are looking to improve the performance of your processes as a relational database professional.

Getting Started with SQL Server 2014 Administration will guide you through your first steps of learning SQL Server 2014 by introducing you to its new features and helping you create a hybrid environment, which is both highly available and allows you to get the best performance from your databases. This book is for anyone who wants to boost their database application performance to the next level.

Comments

Amazing Books

CNET Do-It-Yourself PC Upgrade Projects

McGraw-Hill, 2008

Supercharge and customize your PC

Now you can get the most out of your PC with the fun and practical projects packed inside this easy-to-follow guide. Produced in conjunction with CNET.com, the place you go for the latest in tech and consumer electronics, this book shows you how to exploit the media, communications,...

Modelling Distributed Systems (Texts in Theoretical Computer Science. An EATCS Series)

Springer, 2007

A distributed system is driven by separate components that are executed in parallel, and protocols for such systems form a major aspect of system design in todays world of wireless and mobile networking. Process algebras are languages for the description of elementary parallel systems and are used to study the behavioural properties of distributed...

Graph Classification and Clustering Based on Vector Space Embedding

World Scientific Publishing, 2010

Due to the ability of graphs to represent properties of entities and binary relations at the same time, a growing interest in graph based object repre sentation can be observed in science and engineering. Yet, graphs are still not the common data structure in pattern recognition and related fields. The reason for this is twofold. First,...

Elliptically Contoured Models in Statistics and Portfolio Theory

Springer, 2013

Elliptically Contoured Models in Statistics and Portfolio Theory fully revises the first detailed introduction to the theory of matrix variate elliptically contoured distributions. There are two additional chapters, and all the original chapters of this classic text have been updated. Resources in this book will be valuable for researchers,...

Getting Started with nopCommerce

Packt Publishing, 2013

You don't have to be a techie to use the power of nopCommerce to sell your products online. This guide walks you through the many features of the engine to create a complete working store in easy steps.

Overview

Learn to install and configure nopCommerce in order to start selling products online

...

Creating Striking Graphics with Maya and Photoshop

Sybex, 2004

Welcome to Creating Striking Graphics with Maya and Photoshop and the cutting edge of photo-realistic and surrealistic design. If you’re a Photoshop artist coming to this book, sit back and enjoy the ride. The intent of the book is not to overwhelm you with technical details, but to help ease you into the world of Maya...