sqlsathistory

Nr: 483

Back to Main list

SQLSaturday #483 - Colorado Springs 2016

Start Time (24h)	Speaker	Track	Title
08:30:00	Chris Hyde	Advanced Analysis Techniques	SQL Server R Services in SQL 2016
08:30:00	Eric Peterson	Enterprise Database Administration Deployment	Very Large Databases in your future
08:30:00	Andy Tabisz	Application Database Development	Creating Access Web Apps with SQL Azure and SharePoint
08:30:00	Michael Fal	Enterprise Database Administration Deployment	Managing Availability Groups (What happens after the build!)
08:30:00	Jeff Renz	Application Database Development	IoT - The Internet Of Things
09:45:00	Robert Smith	Application Database Development	Table Partitioning 101
09:45:00	William E Pearson III	Strategy and Architecture	Design and Implement BI Like Edison!
09:45:00	TJay Belt	Cloud Application Development Deployment	Hadoop, Hive, JSON, and Data! Oh, my!
09:45:00	Reeves Smith	Advanced Analysis Techniques	The New Revolution in Data Science, R Integrated into SQL Server
09:45:00	Andre DuBois	Enterprise Database Administration Deployment	Essential steps to ensure survivability of your SQL Server database
09:45:00	Kevin Kline	Enterprise Database Administration Deployment	SQL Server Internals and Architecture
11:00:00	Phillip Labry	BI Platform Architecture, Development Administration	Analysis Services Tabular Jumpstart
11:00:00	Mike Byrd	Application Database Development	SQL Server Foreign Keys – De-mystifying the Rest of the Story
11:00:00	Michael Bourgon	Enterprise Database Administration Deployment	Overlord - tracking changes real-time, in your environment
11:00:00	David Klee	Enterprise Database Administration Deployment	Infrastructure Tuning for SQL Server Performance
11:00:00	Meagan Longoria	Analytics and Visualization	Overcoming Chartaphobia And Moving Toward Enlightening Data Viz
11:00:00	Rob Volk	Enterprise Database Administration Deployment	Revenge: The SQL! - Director's Cut
13:30:00	Steve Wake	BI Information Delivery	Power BI is Awesome!
13:30:00	Jason Horner	BI Platform Architecture, Development Administration	Dimensional Modeling Design Patterns: Beyond Basics
13:30:00	Michelle Poolet	Strategy and Architecture	FROM OLD TO NEW; NAVIGATING THE CHOPPY WATERS OF A CRM/ERP PLATFORM MIGRATI
13:30:00	Paul Nielsen	Application Database Development	What's your DQ (Data Quotient) ?
13:30:00	Amy Herold	Professional Development	Making the Leap from Developer to DBA
13:30:00	Kevin Kline	Enterprise Database Administration Deployment	End-to-End Troubleshooting for SQL Server
14:45:00	Vijayakumar Thurupathan	Cloud Application Development Deployment	Protecting your data in the Cloud
14:45:00	Tim Ford	Enterprise Database Administration Deployment	How Good Is Your Indexing Strategy?
14:45:00	David Klee	Enterprise Database Administration Deployment	My Brain Has Blue Screened - Let's Laugh
14:45:00	Carlos Bossy	Advanced Analysis Techniques	Predictive Analytics Fundamentals
14:45:00	Gabriel Villa	Cloud Application Development Deployment	Getting Started with Databases on Amazon Web Services
14:45:00	Alaina Donofrio	Enterprise Database Administration Deployment	No AlwaysOn? HA/DR for Us Mere Mortals

SessionID: 42276

SQL Server R Services in SQL 2016

Back to calendar

Event Date: 02-04-2016 - Session time: 08:30:00 - Track: Advanced Analysis Techniques

Speaker: Chris Hyde

Title: SQL Server R Services in SQL 2016

Abstract:

One of the most exciting new features of SQL Server 2016 is the integration of the R statistical programming language into the platform with the brand-new SQL Server R Services. In this introductory session we'll briefly introduce the R language and then look at how to install and administer SQL Server R Services. We'll start to demonstrate the power of R by showing you how to create and run simple R scripts from within T-SQL. We'll then discuss some of the powerful open source packages that are available to aid your data analyses. Finally, we'll go through some examples of how to use R to integrate data analytical methods in real-world situations, and wow your customers with the power of statistics!

SessionID: 42929

Very Large Databases in your future

Back to calendar

Event Date: 02-04-2016 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Eric Peterson

Title: Very Large Databases in your future

Abstract:

Your databases may not be terabyte-sized yet, but they're probably growing every day. We'll look at lessons learned

from working with multi-terabyte, very large databases (VLDBs) in the real world. Topics include storage layout decisions, unique tuning challenges, HA/DR implications, and database restores, along with shoehorning backups, re- indexing and DBCC checks into itty-bitty maintenance windows. As a bonus, many of the techniques also apply to smaller databases and consolidated servers that run hundreds of databases.

SessionID: 44869

Creating Access Web Apps with SQL Azure and SharePoint

Back to calendar

Event Date: 02-04-2016 - Session time: 08:30:00 - Track: Application Database Development

Speaker: Andy Tabisz

Title: Creating Access Web Apps with SQL Azure and SharePoint

Abstract:

In this session, you'll learn how to quickly build an Access Web App, tour the online development environment and see a real, live working app in action. We'll discuss app distribution and deploying updates and demonstrate add-in features like Power BI Tiles and Bing Maps. And lastly, you'll learn the pros/cons of Access Web Apps and hybrid solutions in a corporate environment as well as how to extend the data to mobile phones tablets. Presented by Andy Tabisz, Microsoft MVP, WorkSmart Database Masters.

SessionID: 45441

Managing Availability Groups (What happens after the build!)

Back to calendar

Event Date: 02-04-2016 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Michael Fal

Title: Managing Availability Groups (What happens after the build!)

Abstract:

Have you built a SQL Server Availability Group only to be suddenly surprised by all the gotchas and hurdles that pop up? Are you struggling with keeping your Availability Group running smoothly without a lot of management on your part? This session will cover what happens after you have created an Availability Group and how to manage it. We will review tips, tricks, and patterns for handling all the considerations that running this popular high availability solution. After this session, you will be prepared for managing your Availability Groups and how you can streamline that management to make your availability strategy more robust.

SessionID: 46110

IoT - The Internet Of Things

Back to calendar

Event Date: 02-04-2016 - Session time: 08:30:00 - Track: Application Database Development

Speaker: Jeff Renz

Title: IoT - The Internet Of Things

Abstract:

The Internet of Things (IoT) is a hot topic, but what is it, how do we use it, and how do we analyze it? This presentation is an overview of IoT that explores IoT industry trends and introduces you to the IoT Azure toolset specifically HBase, Storm and Spark.

SessionID: 41274

Table Partitioning 101

Back to calendar

Event Date: 02-04-2016 - Session time: 09:45:00 - Track: Application Database Development

Speaker: Robert Smith

Title: Table Partitioning 101

Abstract:

Do you have large tables you can’t delete old data from or perform maintenance on? Then this may be for you! Table Partitioning 101 will make an introduction to table partitioning through the GUI and a code based approach. The session will be a discussion about how to make it work and will include: creating partitioned tables, partition schemes, left vs. right facing partition functions and how to do a basic switch operation. A small deep dive about how to find out which partition your data is in and what exactly does it mean for an index to be “aligned” will also be discussed.

SessionID: 41346

Design and Implement BI Like Edison!

Back to calendar

Event Date: 02-04-2016 - Session time: 09:45:00 - Track: Strategy and Architecture

Speaker: William E Pearson III

Title: Design and Implement BI Like Edison!

Abstract:

As the most prolific inventor in American history, Thomas Edison was a master of “Best Practices!” Edison’s creations were not just novel and commercially successful, but many launched entire new industries including electric light and power, sound recording, motion pictures and industrial cement and concrete manufacture. At the heart of Edison’s remarkable record of innovation was his categorization of the innovation process into “competencies,” or bundles of skills supporting the achievement of success in a particular area of endeavor. In this session, we will look at ways that we can use many of these broad success secrets to bring powerful tools and strategies to the recurring implementation of business intelligence.

SessionID: 42485

Hadoop, Hive, JSON, and Data! Oh, my!

Back to calendar

Event Date: 02-04-2016 - Session time: 09:45:00 - Track: Cloud Application Development Deployment

Speaker: TJay Belt

Title: Hadoop, Hive, JSON, and Data! Oh, my!

Abstract:

Tips and Tricks and Painful lessons learned as I have ventured into the world of Hadoop, JSon and Hive. Our data has made the move from a relational database to a JSon structure, and reporting across the entire enterprise of data has changed. We have introduced Hadoop batch processing to our ETL processes to collect and process data from various locations, depositing them in various other locations. Along the way, various brick walls were surmounted. We will discuss some of these brick walls. Some of the oddities encountered in this journey. and hopefully prepare you for a similar trip, without all the pain we suffered.

SessionID: 43078

The New Revolution in Data Science, R Integrated into SQL Server

Back to calendar

Event Date: 02-04-2016 - Session time: 09:45:00 - Track: Advanced Analysis Techniques

Speaker: Reeves Smith

Title: The New Revolution in Data Science, R Integrated into SQL Server

Abstract:

Data Science is an ever increasing topic in the Data Analytics space and the R language is at the center of most conversations. R is an open source statistical language that is rapidly gaining popularity due to a robust set of machine learning functionality and a never-ending set of R packages that are used to increase functionality of the core R language. The R language is run as a desktop application and was not built with performance and scale required to accommodate Big Data. Revolution Analytics, a wholly owned subsidiary of Microsoft, has solved the performance and scaling issues of a desktop application by creating a more robust enterprise architecture. SQL Server 2016 brings the power of R and Revolution Analytics into the industry leading relational database.

This session will demo the functionality and power of using R within SQL Server.

SessionID: 46104

Essential steps to ensure survivability of your SQL Server database

Back to calendar

Event Date: 02-04-2016 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Andre DuBois

Title: Essential steps to ensure survivability of your SQL Server database

Abstract:

Survivability of data should be the #1 priority for any database administrator. Corruption can happen to any database at any time. How soon corruption is detected and a quick response is key to minimize lost data and recovery in a timely manner. Have a plan ready when it happens, as this is one time you don’t want to “learn on the job”. In addition to daily and monthly maintenance that should be performed, other topics discussed will include e-mail notification when data becomes corrupt and Service Level Agreements.

SessionID: 47855

SQL Server Internals and Architecture

Back to calendar

Event Date: 02-04-2016 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Kevin Kline

Title: SQL Server Internals and Architecture

Abstract:

Let’s face it. You can effectively do many IT jobs related to SQL Server without knowing the internals of how SQL Server works. Many great developers, DBAs, and designers get their day-to-day work completed on time and with reasonable quality while never really knowing what’s happening behind the scenes. But if you want to take your skills to the next level, it’s critical to know SQL Server’s internal processes and architecture. This session will answer questions like:

• What are the various areas of memory inside of SQL Server?
• How are queries handled behind the scenes?
• What does SQL Server do with procedural code, like functions, procedures, and triggers?
• What happens during checkpoints? Lazywrites?
• How are IOs handled with regards to transaction logs and database?
• What happens when transaction logs and databases grow or shrinks?

This fast paced session will take you through many aspects of the internal operations of SQL Server and, for those topics we don’t

SessionID: 41717

Analysis Services Tabular Jumpstart

Back to calendar

Event Date: 02-04-2016 - Session time: 11:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Phillip Labry

Title: Analysis Services Tabular Jumpstart

Abstract:

Analysis Services Tabular is an in memory analytics engine introduced in SQL Server 2012. It has shown to be a quick and effective way to transform your organization with modern analytics. Join Phillip and learn how easy it is to create a tabular solution and provide valuable insight into your organization's data. This is a demo heavy session and you should be able walk away knowing how to create your own tabular model.

SessionID: 41939

SQL Server Foreign Keys – De-mystifying the Rest of the Story

Back to calendar

Event Date: 02-04-2016 - Session time: 11:00:00 - Track: Application Database Development

Speaker: Mike Byrd

Title: SQL Server Foreign Keys – De-mystifying the Rest of the Story

Abstract:

Foreign Keys are the ultimate Catch-22; you need them for data integrity, but they just kill insert, update, and delete performance. In this session we will describe the concept of Foreign Keys and how they maintain data integrity. You will learn their syntax for creating, deleting, disabling, and re-enabling. You will also learn the possible effects of disabling and re-enabling Foreign Keys for data modification. We will also examine the two most important Foreign Key attributes: is_not_trusted and is_disabled and their effect on query performance. All of these characteristics will be demo'ed with many script examples.

After attending this session you will

1. Comprehend the pro and cons of Foreign Keys in a real world production environment
2. Understand the consequences of disabling and re-enabling Foreign Keys for data modification
3. Be able to better assess best approach for Foreign Key maintenance

SessionID: 42339

Overlord - tracking changes real-time, in your environment

Back to calendar

Event Date: 02-04-2016 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Michael Bourgon

Title: Overlord - tracking changes real-time, in your environment

Abstract:

Don’t you LOVE it when changes are made to your databases without notice!? Those AWESOME “Object doesn't exist” messages, sudden performance problems, failed audits and other unexpected errors can be soooo much fun! Time to put an end to these unreported changes and get real-time notice as they occur, via emails, reports, or even Source Control. Learn to use Event Notifications, a native SQL Server feature, along with some production-ready code. to become the Overlord your users need.

SessionID: 42642

Infrastructure Tuning for SQL Server Performance

Back to calendar

Event Date: 02-04-2016 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: David Klee

Title: Infrastructure Tuning for SQL Server Performance

Abstract:

Mention SQL Server performance to any DBA, and the impulse is to dive headfirst into the database and queries. However, if the infrastructure underneath the data is your performance bottleneck, the time spent tuning at the database layer is usually in vain. Server hardware, operating system parameters, storage, interconnects, and networking will all be discussed in depth in terms that DBAs can relate to. Practical architecture guidelines and troubleshooting techniques will be presented so you can analyze your environments and see if your performance bottlenecks are where you think they are.

SessionID: 42979

Overcoming Chartaphobia And Moving Toward Enlightening Data Viz

Back to calendar

Event Date: 02-04-2016 - Session time: 11:00:00 - Track: Analytics and Visualization

Speaker: Meagan Longoria

Title: Overcoming Chartaphobia And Moving Toward Enlightening Data Viz

Abstract:

Do your organization's reports consist mostly of giant tables of data? Perhaps you have gotten as far as adding KPI indicators or conditional highlighting to the tables. Although tables of data presented as reports are commonly found in many organizations, they may be doing you and your users a disservice. You should optimize your data viz just as you optimize your databases. Reports are a user interface that must be purposefully designed to help users achieve their goal of making informed decisions. In this session, we'll review requirements gathering and data viz best practices and apply those concepts to the use of Microsoft reporting tools such as Excel, Power View, and Reporting Services. You'll leave with guidance on how to take boring, unreadable tables of data and turn them into useful and visually appealing reports.

SessionID: 44749

Revenge: The SQL! - Director's Cut

Back to calendar

Event Date: 02-04-2016 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Rob Volk

Title: Revenge: The SQL! - Director's Cut

Abstract:

Pop quiz DBA: Your developers are running rampant in production. Logic, reason, and threats have all failed. You're on the edge. What do you do? WHAT DO YOU DO?

Hint: You attend Revenge: The SQL!

This session will show you how to "correct" all those bad practices. Everyone logging in as sa? Running huge cursors? Using SELECT * and ad-hoc SQL? Stop them dead, without actually killing them. Ever dropped a table, or database, or WHERE clause? You can prevent that! And if you’re tired of folks ignoring your naming conventions, make them behave with Unicode…and take your revenge!

Revenge: The SQL! is fun and educational and may even have some practical use, but you’ll want to attend simply to indulge your Dark Side. Revenge: The SQL! assumes no liability and is not available in all 50 states. Do not taunt Revenge: The SQL! or Happy Fun Ball.

SessionID: 41291

Power BI is Awesome!

Back to calendar

Event Date: 02-04-2016 - Session time: 13:30:00 - Track: BI Information Delivery

Speaker: Steve Wake

Title: Power BI is Awesome!

Abstract:

Microsoft has changed its Business Intelligence strategy in the last few years from an IT centric approach with SQL Server Reporting Services and SQL Server Analysis Services to an end-user ad-hoc approach with Power BI. Initially the Power BI tools were all separate add-ons to Excel 2010+ that you had to know where to get them and install/activate them individually. Now with new Power BI product announcements and Power BI Desktop, the full vision of these once separate tools is becoming more clear and cohesive as an end-user ad-hoc analysis and reporting tool. In this demo heavy session you will see how Power BI is now a much more complete solution and how it can change how you deliver analysis and reporting to anyone in your company. Demos will include using Power BI Desktop to pull in data from multiple sources and repeatable transformations to clean usable data and build interactive reports and dashboards.

SessionID: 41473

Dimensional Modeling Design Patterns: Beyond Basics

Back to calendar

Event Date: 02-04-2016 - Session time: 13:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Jason Horner

Title: Dimensional Modeling Design Patterns: Beyond Basics

Abstract:

Dimensional modeling is arguably one of the most important

fundamentals of business intelligence. It is still relevant even as new technologies like PowerPivot and SSAS Tabular Models are becoming more popular. Correctly modeling your organization's data not only protects the most important asset your company has but ensures that your data mart or data warehouse will be responsive and capable of accommodating emerging requirements.

This session provides a deeper dive into the art of dimensional modeling. We will look at the different types of fact tables and dimension tables, how and when to use them. We will also some approaches to creating rich hierarchies that make reporting a snap. Finally we will cover physical design choices.This case study and demo based session promises to be very interactive and engaging, bring your toughest Dimensional Modeling quandaries.

SessionID: 45446

FROM OLD TO NEW; NAVIGATING THE CHOPPY WATERS OF A CRM/ERP PLATFORM MIGRATI

Back to calendar

Event Date: 02-04-2016 - Session time: 13:30:00 - Track: Strategy and Architecture

Speaker: Michelle Poolet

Title: FROM OLD TO NEW; NAVIGATING THE CHOPPY WATERS OF A CRM/ERP PLATFORM MIGRATI

Abstract:

The time has come -- you’ve lived with your legacy Customer Relationship Management/Enterprise Resource Planning systems since you joined the company, but they’re not cutting it anymore. A decision is made to move to a new vendor, a new platform, a new CRM/ERP software package, and you’ve been tapped to be part of the project team. Your job will be to make sure that the data collected in the old systems is successfully and accurately ported to the new systems. Really?

What do you have to look forward to? What’s it going to be like? How are you going to do this? Will you port all of the data from the legacy system to the new one, or just some? How will that work?

Join Michelle Poolet as she walks you through lessons learned from the many platform migrations that she’s been part of. As a data architect, Michelle has special insight into these massively complex projects, which she’d like to share with you.

SessionID: 46153

What's your DQ (Data Quotient) ?

Back to calendar

Event Date: 02-04-2016 - Session time: 13:30:00 - Track: Application Database Development

Speaker: Paul Nielsen

Title: What's your DQ (Data Quotient) ?

Abstract:

You've heard of IQ (and you're is probably high) and EQ (Emotional Quotient), but have you heard of DQ ( Data Quotient). Your DQ is your skill or ability to "smell" good data, excellent data patterns, and great queries. In this session we'll look at several examples of good, bad, and ugly data and you'll grade your DQ. Fun, educational, and potentially full of brag-rights.

SessionID: 46168

Making the Leap from Developer to DBA

Back to calendar

Event Date: 02-04-2016 - Session time: 13:30:00 - Track: Professional Development

Speaker: Amy Herold

Title: Making the Leap from Developer to DBA

Abstract:

You are a Developer (.NET, SQL or otherwise) but you have been doing some DBA work and have now decided that is all you want to do - how do you make the transition? What do you need to know? This session will cover this topic from first-hand experience.

SessionID: 48134

End-to-End Troubleshooting for SQL Server

Back to calendar

Event Date: 02-04-2016 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Kevin Kline

Title: End-to-End Troubleshooting for SQL Server

Abstract:

Learning how to detect, diagnose and resolve performance problems in SQL Server is tough. Often, years are spent learning how to use the tools and techniques that help you detect when a problem is occurring, diagnose the root-cause of the problem, and then resolve the problem.

In this session, attendees will see demonstrations of the tools and techniques which make difficult troubleshooting scenarios much faster and easier, including:

• XEvents, Profiler/Traces, and PerfMon • Using Dynamic Management Views (DMVs) • Advanced Diagnostics Using Wait Stats • Reading SQL Server execution plan

Every DBA needs to know how to keep their SQL Server in tip-top condition, and you’ll need skills the covered in this session to do it.

SessionID: 42297

Protecting your data in the Cloud

Back to calendar

Event Date: 02-04-2016 - Session time: 14:45:00 - Track: Cloud Application Development Deployment

Speaker: Vijayakumar Thurupathan

Title: Protecting your data in the Cloud

Abstract:

Are you concerned about moving to cloud, because of the safety of your data ? Organizations choose to go with the platform services of Azure using SQL Databases or they go with the Infrastructure services of Azure using virtual machines, in both cases security of your data is vital. This demo driven session will give you all the information you need to know about the security implementations available in SQL Databases in Azure and SQL Server.

The session will cover the following topics with demos. Introduction to cloud adaptation of the organizations, - how enterprises adopt to the cloud and how startups are moving to the cloud. SQL relational store options in Azure. Security features of SQL Databases Cloud demanded security features of SQL Servers Using Azure Key Vault to secure data in SQL Server

SessionID: 42604

How Good Is Your Indexing Strategy?

Back to calendar

Event Date: 02-04-2016 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Tim Ford

Title: How Good Is Your Indexing Strategy?

Abstract:

Like Frankenstein's Monster (or our teenagers) things get released into the wild and behave differently than planned - database usage patterns are no different. Join Tim as he reviews what to look for when tweaking your index strategy: poor clustering key decisions, underutilized indexes, covering indexes gone wrong, overlooked heaps and fill factor failures are just a few of the blunders to be identified.

A working knowledge of Dynamic Management Objects, indexing internals, and eagerness to experiment with metadata is a prerequisite!

SessionID: 42643

My Brain Has Blue Screened - Let's Laugh

Back to calendar

Event Date: 02-04-2016 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment

Speaker: David Klee

Title: My Brain Has Blue Screened - Let's Laugh

Abstract:

Is your brain mush from too much technical content, but you just need a break before the next session or the raffle? Come share your IT war stories with the group and laugh for an hour. This open panel session is guaranteed to at least get a chuckle as we all relax and share our experiences.

SessionID: 46534

Predictive Analytics Fundamentals

Back to calendar

Event Date: 02-04-2016 - Session time: 14:45:00 - Track: Advanced Analysis Techniques

Speaker: Carlos Bossy

Title: Predictive Analytics Fundamentals

Abstract:

The practice of Data Science has arrived and as data professionals we're on the forefront of this change. The data we collect can now be used in new and exciting ways, providing more value than ever before. To get started in this field, a number of tools and methodologies must be employed to help you achieve predictive analytics success with your data. In this session the predictive analytics process will be covered from start to finish, providing a practical understanding of what it takes to develop your own predictive models. The session includes an overview of definitions, concepts and terminology, successful applications of predictive analytics, and how predictive analytics fits into a BI environment.

SessionID: 47821

Getting Started with Databases on Amazon Web Services

Back to calendar

Event Date: 02-04-2016 - Session time: 14:45:00 - Track: Cloud Application Development Deployment

Speaker: Gabriel Villa

Title: Getting Started with Databases on Amazon Web Services

Abstract:

Are you looking to understand what IaaS or PaaS really mean? Perhaps you are not sure of virtual, high available relational or NoSQL databases. Get started with the basics of managed services and platforms for running databases on AWS. Hear how to use managed relational databases such as MS SQL Server with minimal administration. Also discover other cloud options such as managed NoSQL or scaling your own instances with resizable elastic compute cloud. Take home an introduction from in-memory cache to petabyte-scale data warehouse databases in the Amazon cloud.

SessionID: 48133

No AlwaysOn? HA/DR for Us Mere Mortals

Back to calendar

Event Date: 02-04-2016 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Alaina Donofrio

Title: No AlwaysOn? HA/DR for Us Mere Mortals

Abstract:

Inherited an older than dirt SQL box? Can't upgrade? Not everyone can have shiny new Enterprise Edition servers, so what high availability or disaster recovery options are available for us mere mortals? In this course I'll go over the HA/DR options that are available for the different versions of SQL, and I'll even give you a real-world example of using a 'listener' before there were Availability Groups!

This site is open source. Improve this page.