What do you get with Print?

Instant access to your digital copy whilst your Print order is Shipped

Paperback book shipped to your preferred address

Redeem a companion digital copy on all Print orders

Access this title in our online reader with advanced features

DRM FREE - Read whenever, wherever and however you want

AI Assistant (beta) to help accelerate your learning

Description

This is an easytofollow handson tutorial that includes real world examples of SQL Server 2014's new features. Each chapter is explained in a stepbystep manner which guides you to implement the new technology. 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 onpremise 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 InMemory OLTP features

Implement the delayed durability feature to improve transaction latency

Use a cloudbased replica to build an AlwaysOn Availability Group

Learn the other enhancements and new features that can help improve database performance

What do you get with Print?

Instant access to your digital copy whilst your Print order is Shipped

Paperback book shipped to your preferred address

Redeem a companion digital copy on all Print orders

Access this title in our online reader with advanced features

DRM FREE - Read whenever, wherever and however you want

AI Assistant (beta) to help accelerate your learning

Frequently bought together

$49.99

Getting Started with SQL Server 2014 Administration

$29.99

Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide

$57.99

Total $ 137.97

Customer reviews

Rating distribution

3.6

(5 Ratings)

5 star 20%

4 star 40%

3 star 20%

2 star 20%

1 star 0%

JD (DBA - South Wales) Jun 27, 2014

The attractive thing about this publication is that it contains a lot of useful and relevant information in just little over 100 pages.For many of us DBAs we're comfortable with SQL Server 2012/2008 and we are hearing a lot of noise in the SQL community about the new features and enhancements that SQL Server 2014 bundles up.For me the book demystified a few apprehensions I had over cloud technology.It guided me through the new functionality with easy to follow instruction and screen shots.Those sceptical about plunging into the depths of Windows Azure, Virtualisation, Always-On etc will find this book a very useful tool in future decision-making. For example, the prospect of housing your data and SQL environments in the "abyss" may be a daunting one - what this book does is highlight the advantages and pinpoints areas that require careful consideration, such as when to use Delayed Durability.Chapter 3 'In-Memory Optimised Tables' is an in-depth topic but the author clearly defines the differing isolation levels and index choices, making it easily understandable for the everyday DBA.The authors personal experiences of using Cloud-based and virtual technology seems to be evident and there is a plethora of useful easy-to-follow descriptions throughout the entire book.It's a compact book, and as the title suggests - its a useful reference for 'getting started' with some of the features SQL 2014 has introduced. I would recommend this to both newbie DBAs and established SQL 2012/2008 DBAs looking to gain an insight into the latest offerings.

Amazon Verified review

Ian Stirk May 29, 2014

Hi,I have written a detailed chapter-by-chapter review of this book on www DOT i-programmer DOT info, the first and last parts of this review are given here. For my review of all chapters, search i-programmer DOT info for STIRK together with the book's title.Another SQL Server 2014 book quickly follows the product's release, how does it fare?This is a small book of less than 100 pages spread over six chapters. The introduction says "This book is for people who want to learn the new features of SQL Server 2014..." this is at odds with the title which doesn't mention it relating to only new features, I wonder how many people will be caught out by this misleading title?People that want to read only about new features may ignore it, and people that want a general administration book may buy it! "Getting Started with SQL Server 2014's New Administration Features" would have been a more honest title.Below is a chapter-by-chapter exploration of the topics covered.Chapter 1 SQL Server 2014 and CloudThe chapter opens with a few definitions, Windows Azure being Microsoft's public cloud offering, and Microsoft Azure SQL Database the underlying database. It notes that using the cloud reduces concerns about hardware resources, and provides improved scalability.The database provides Software as a Service (SaaS) functionality. A step-by-step walkthrough of how to create a Windows Azure SQL database is given, together with its various settings. Connecting to the newly created database via SQL Server Management Studio (SSMS) is shown next. Finally, the process of migration an existing on-premises database to Microsoft Azure is illustrated.The next section discusses storing your SQL Server database files in Microsoft Azure, combining on-premise and cloud storage solutions. The files are stored as blobs in Microsoft Azure. Various benefits include low cost and elastic storage, together with improved High Availability (HA) and Disaster Recovery (DR). There's a step-by-step walkthrough of creating a database that uses cloud storage (including creating the relevant storage account and storage container).The chapter ends with a walkthrough of creating a Microsoft Azure Virtual Machine (VM), instead of building the VM on-premises.All the sections provide walkthroughs with good descriptions and screenshots. All the sub-chapter headings would have been easier to understand if they specified their function e.g. "Integrating Microsoft Azure SQL Database" would have been better as "Storing your SQL Server database files in the cloud"....ConclusionThis book is a short introduction, from an administrator's viewpoint, to the new features of SQL Server 2014. It's generally practical in its approach, containing step-by-step walkthroughs, together with supporting screenshots. It's generally an easy read, with good but limited explanations.The book's title is incorrect, it should reflect the book relates to new features of SQL Server 2014 only. Some people (myself included) would actually prefer a book that contains only the updated features. I can imagine some people looking for an introductory book for general SQL Server administration, getting annoyed at purchasing a book that contains specifically new features only.One of the problems with reviewing this book is the "Getting Started" part of the title, it provides an apology for the lack of depth and omissions. This is compounded by the book's small size, only 114 pages. For example, there's nothing about the new security enhancements (e.g. connect any database, impersonate any login). I wanted more! I had to keep reminding myself this is a "Getting started" book...Although the diagrams are correctly placed, it might have been useful to provide them with titles - making subsequent chapter scanning easier.I'm not sure for whom this book is intended, if you're new to SQL Server administration, you will need a more general book, not just the new features. If you're experienced with SQL Server administration, you probably need a more detailed book - perhaps this is the book you read before the detailed one (or lookup the detail on the Internet)?As a brief introduction to the new administration features of SQL Server 2014, I can recommend this book, but I suspect you'll soon need a follow-on book containing more detail.

Amazon Verified review

Vaibhav Gupta Jun 21, 2014

Hi ,This book provides introduction to new & important features of SQL Server 2014 and helps you understand why your organization should use this tool over previous versions. This book is for professional DBAs who understands basics of DBA practices and now looking forward to learn new features and going to migrate there environment to upgraded version.A good read !!!Regards,Vaibhav Gupta

Amazon Verified review

A. Zubarev May 06, 2014

I have been working with SQL Server starting from version 6 in late 90s. Ironically, I had never suspected I will end up using SQL Server or using it throughout the rest of my entire career, and I have no plans defecting. The short story is I joined an incubator company which later became a spin-off a large enterprise where there were almost no Microsoft products used (I initially worked on a Mainframe DB2, then on Unix as a C programmer using Informix and Oracle). At that small start up initially like company all the repeated attempts to install an Oracle database by a vendor have failed. Our CEO was enraged, the deadlines were pressing when my fellow contractor brought a set of freshly purchased MSDN CDs one morning into our office. He exchanged a few words I did not catch with our project manager and vanished in the coldness of our server room. Short time later he re-emerged with a smile on his face and a bunch of us emotionless hearing him say we have a SQL Server database setup for us to use in our belated POC. Frankly, our old-school CEO and many other managers took this optimism with a lot of skepticism. Months later the project went live, on time, all written in VB4 and T-SQL code. And it worked very well.Back then our primary goals were data processing speeds, storage capacity, CPU utilization, scaling and transactional sanity. Fast forward into today all the aforementioned concerns remain as valid. However, what changed is that there are more options to tackle these issues up, in different ways, faster and more efficiently if not with a lower budget. What is new and improved under a DBA or developer’s belt in terms of tooling and capabilities Getting Started with SQL Server 2014 Administration book is going to cover.Indeed, the book has the right timing and is right on the spot covering well the unique and most massive advancement in the entire RDBMs world – InMemory data processing, delayed durability And it does not stop there, the reader will get known how to create databases in Windows Azure, backup into the Cloud or restore from it, creating hybrid AlwaysOn environments, performance enhancements and a few more topics. So this is a book SQL Server 2014 Enterprise specific and for a modern DBA.Alas, the book does not cover any other aspects of even a junior DBA, e.g. there is no mention on how to install SQL Server 2014 on premises, securing it up, choosing a backup strategy, monitoring. Likewise, several other topics that are actually new in this build are also amiss as Lock Priorities, T-SQL (1 change), tempdb performance and the new security roles.To continue on the negatives, one general comment I have is that the book has no enough in-depth feature coverage for non Enterprise grade releases, should have more examples, the book should have been expanded beyond the 80 or so pages of useful content to include the management tools overview, performance troubleshooting, auditing, etc. even for a ‘getting started’ book. Thing is, the life of even a novice DBA would be very demanding in terms of achieving acceptable application response time, feature suggestion, or just the time to fix an issue.I am giving this book a 2.5 rounded up out of 5 mark as I can hardly see how it outweighs the benefits of the MSDN help or the waste amount of online articles.Disclaimer: I received the copy of the book for free from the publisher.

Amazon Verified review

AmazonCustomer Feb 21, 2018

Just 100 pages and the information are little. Book price is too much.

Amazon Verified review

FAQs

What is the digital copy I get with my Print order?

When you buy any Print edition of our Books, you can redeem (for free) the eBook edition of the Print Book you’ve purchased. This gives you instant access to your book when you make an order via PDF, EPUB or our online Reader experience.

What is the delivery time and cost of print book?

Shipping Details

USA:

Economy: Delivery to most addresses in the US within 10-15 business days

Premium: Trackable Delivery to most addresses in the US within 3-8 business days

UK:

Economy: Delivery to most addresses in the U.K. within 7-9 business days.
Shipments are not trackable

Premium: Trackable delivery to most addresses in the U.K. within 3-4 business days!
Add one extra business day for deliveries to Northern Ireland and Scottish Highlands and islands

EU:

Premium: Trackable delivery to most EU destinations within 4-9 business days.

Australia:

Economy: Can deliver to P. O. Boxes and private residences.
Trackable service with delivery to addresses in Australia only.
Delivery time ranges from 7-9 business days for VIC and 8-10 business days for Interstate metro
Delivery time is up to 15 business days for remote areas of WA, NT & QLD.

Premium: Delivery to addresses in Australia only
Trackable delivery to most P. O. Boxes and private residences in Australia within 4-5 days based on the distance to a destination following dispatch.

India:

Premium: Delivery to most Indian addresses within 5-6 business days

Rest of the World:

Premium: Countries in the American continent: Trackable delivery to most countries within 4-7 business days

Asia:

Premium: Delivery to most Asian addresses within 5-9 business days

Disclaimer:
All orders received before 5 PM U.K time would start printing from the next business day. So the estimated delivery times start from the next day as well. Orders received after 5 PM U.K time (in our internal systems) on a business day or anytime on the weekend will begin printing the second to next business day. For example, an order placed at 11 AM today will begin printing tomorrow, whereas an order placed at 9 PM tonight will begin printing the day after tomorrow.

Unfortunately, due to several restrictions, we are unable to ship to the following countries:

Afghanistan
American Samoa
Belarus
Brunei Darussalam
Central African Republic
The Democratic Republic of Congo
Eritrea
Guinea-bissau
Iran
Lebanon
Libiya Arab Jamahriya
Somalia
Sudan
Russian Federation
Syrian Arab Republic
Ukraine
Venezuela

What is custom duty/charge?

Customs duty are charges levied on goods when they cross international borders. It is a tax that is imposed on imported goods. These duties are charged by special authorities and bodies created by local governments and are meant to protect local industries, economies, and businesses.

Do I have to pay customs charges for the print book order?

The orders shipped to the countries that are listed under EU27 will not bear custom charges. They are paid by Packt as part of the order.

List of EU27 countries: www.gov.uk/eu-eea:

A custom duty or localized taxes may be applicable on the shipment and would be charged by the recipient country outside of the EU27 which should be paid by the customer and these duties are not included in the shipping charges been charged on the order.

How do I know my custom duty charges?

The amount of duty payable varies greatly depending on the imported goods, the country of origin and several other factors like the total invoice amount or dimensions like weight, and other such criteria applicable in your country.

For example:

If you live in Mexico, and the declared value of your ordered items is over $ 50, for you to receive a package, you will have to pay additional import tax of 19% which will be $ 9.50 to the courier service.
Whereas if you live in Turkey, and the declared value of your ordered items is over € 22, for you to receive a package, you will have to pay additional import tax of 18% which will be € 3.96 to the courier service.

How can I cancel my order?

Cancellation Policy for Published Printed Books:

You can cancel any order within 1 hour of placing the order. Simply contact customercare@packt.com with your order details or payment transaction id. If your order has already started the shipment process, we will do our best to stop it. However, if it is already on the way to you then when you receive it, you can contact us at customercare@packt.com using the returns and refund process.

Please understand that Packt Publishing cannot provide refunds or cancel any order except for the cases described in our Return Policy (i.e. Packt Publishing agrees to replace your printed book because it arrives damaged or material defect in book), Packt Publishing will not accept returns.

What is your returns and refunds policy?

Return Policy:

We want you to be happy with your purchase from Packtpub.com. We will not hassle you with returning print books to us. If the print book you receive from us is incorrect, damaged, doesn't work or is unacceptably late, please contact Customer Relations Team on customercare@packt.com with the order number and issue details as explained below:

If you ordered (eBook, Video or Print Book) incorrectly or accidentally, please contact Customer Relations Team on customercare@packt.com within one hour of placing the order and we will replace/refund you the item cost.
Sadly, if your eBook or Video file is faulty or a fault occurs during the eBook or Video being made available to you, i.e. during download then you should contact Customer Relations Team within 14 days of purchase on customercare@packt.com who will be able to resolve this issue for you.
You will have a choice of replacement or refund of the problem items.(damaged, defective or incorrect)
Once Customer Care Team confirms that you will be refunded, you should receive the refund within 10 to 12 working days.
If you are only requesting a refund of one book from a multiple order, then we will refund you the appropriate single item.
Where the items were shipped under a free shipping offer, there will be no shipping costs to refund.

On the off chance your printed book arrives damaged, with book material defect, contact our Customer Relation Team on customercare@packt.com within 14 days of receipt of the book with appropriate evidence of damage and we will work with you to secure a replacement copy, if necessary. Please note that each printed book you order from us is individually made by Packt's professional book-printing partner which is on a print-on-demand basis.

What tax is charged?

Currently, no tax is charged on the purchase of any print book (subject to change based on the laws and regulations). A localized VAT fee is charged only to our European and UK customers on eBooks, Video and subscriptions that they buy. GST is charged to Indian customers for eBooks and video purchases.

What payment methods can I use?

You can pay with the following card types:

Visa Debit
Visa Credit
MasterCard
PayPal

What is the delivery time and cost of print books?

Shipping Details

USA:

Economy: Delivery to most addresses in the US within 10-15 business days

Premium: Trackable Delivery to most addresses in the US within 3-8 business days

UK:

Economy: Delivery to most addresses in the U.K. within 7-9 business days.
Shipments are not trackable

Premium: Trackable delivery to most addresses in the U.K. within 3-4 business days!
Add one extra business day for deliveries to Northern Ireland and Scottish Highlands and islands

EU:

Premium: Trackable delivery to most EU destinations within 4-9 business days.

Australia:

India:

Premium: Delivery to most Indian addresses within 5-6 business days

Rest of the World:

Premium: Countries in the American continent: Trackable delivery to most countries within 4-7 business days

Asia:

Premium: Delivery to most Asian addresses within 5-9 business days

Unfortunately, due to several restrictions, we are unable to ship to the following countries:

Afghanistan
American Samoa
Belarus
Brunei Darussalam
Central African Republic
The Democratic Republic of Congo
Eritrea
Guinea-bissau
Iran
Lebanon
Libiya Arab Jamahriya
Somalia
Sudan
Russian Federation
Syrian Arab Republic
Ukraine
Venezuela

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

What do you get with Print?