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.
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.
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.
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.