SQL Server Standard Edition Survival Guide

Are you trying to force SQL Server Standard Edition to do something that may only be capable in enterprise edition? In this course, you'll learn how to experience standard edition technologies as closely to the enterprise edition as possible.
Course info
Level
Intermediate
Updated
Jul 12, 2017
Duration
2h 30m
Table of contents
Description
Course info
Level
Intermediate
Updated
Jul 12, 2017
Duration
2h 30m
Description

A major consideration most people face when implementing SQL Server is the cost. Are you buying the right edition for the features that you need? Are you using the features in standard edition to their full potential? In this course, SQL Server Standard Edition Survival Guide, you'll learn how to use the features and technologies not only as they are, but also make your SQL Server Standard Edition experience as close to the feature set in enterprise as possible. First, you'll cover how to support reliable, high availability in disaster recovery implementations. Next, you'll explore how to ensure you have industrial strength security, and how to build high performance systems. Finally, you'll discover when enterprise edition is the better choice. By the end of this course, you'll have a better understanding of the feature sets available, and the confidence and skills needed to survive on standard edition.

About the author
About the author

Currently an IT leader in Denver Colorado's financial sector Russ has focused on database development, modelling, administration, and BI since 1997 across the Microsoft stack. Russ is a passionate trainer and SQL community volunteer presenting regularly at PASS SQL Saturday events and local user groups around the US.

More from the author
More courses by Russ Thomas
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
How you doing? This is Russ Thomas. I'm a long-time database administrator, developer, architect, and currently a data platform manager in the Denver area. When you get to the level of senior anything, the suits and ties in the company expect you to start doing more than just keeping systems running or building cool new technologies. They want you to use your company's financial resources wisely. When it comes to SQL Server, this comes down to managing licensing and getting real good at managing the tradeoffs a feature needs versus feature costs. It's kind of like this, you know how handing out SA privileges to everyone makes getting system access a whole lot easier, but it makes securing the system almost impossible. Well handing out Enterprise edition to every project that comes your way definitely makes system architecture easier, but far more costly than necessary. In this course, we're going to take a deeper look at that feature comparison chart that most of us are familiar with, but probably could never have memorized. We're going to do this in order to give you the tools you need to know when Standard edition is all you need. So some of the major topics that we're going to cover include supporting reliable high availability and disaster recovery implementations, ensuring that you have industrial strength security, building high performance systems, and finally, we're going to cover when Enterprise edition really is the better choice. We'll see you in the course.

Miscellaneous Tricks, Tips, and Random Features
Welcome back to this SQL Server Standard Edition Survival Guide course. This is module five, Miscellaneous Tricks, Tips, and Random Features. Once again, this is your host, Russ Thomas. Now in this module, we're going to cover kind of an eclectic collection of features. They can truly be called miscellaneous, but don't take that to mean that they're niche or low importance or just filler for a course. Some of the items we're going to cover in this module are actually really useful. To start off, I want to go through the rest of the features that have traditionally been Enterprise only, but now make their way into Standard as of SQL 2016 Service Pack 1. This was a really good thing to happen in the worlds of those looking to stay on Standard edition. From there, we're going to hit some of the other features that as of this recording are still Enterprise only, don't fit in any of the previous categories, but do have other options to accomplish the same objective, meaning you have options if you would like to stay on Standard edition. The last module was somewhat heavy on dialog and diagram, so I'm going to try and hit some more of the Abacos use cases and use some more live demonstrations for the next 20 minutes or so. First up, data compression, one of those really nice features that up until now was only available in Enterprise. Thank you, Service Pack 1.