These are the sessions submitted so far for SQLBits 16.

This *hands-on* two days teaches you the modern, sensible R that so many of us now use. Bring a laptop and learn data manipulation, visualisation, and presentation the way it should be done! Two days of pure R, aimed at anyone looking to use R heavily and effectively.

We'll cover throughout the two days:
- ingesting data from various sources
- working with tabular data in-depth
- visualising data in static and interactive methods
- performing basic statistics
- producing reports and other outputs
- writing data to various destinations
We can write hacky R code but "works on my machine", especially "when I do this, this, and this" is ok for play, but not for sharing. This *hands-on* day teaches you development best practices for R including defensive programming techniques, testing, and package development. Laptops and basic R skills required!

Throughout this one day of training, we'll be covering:
- function writing
- defensive programming techniques
- package development
- unit testing
- code coverage
- continuous integration
The package data.table is super-fast and super-powerful but the acceleration curve is fast. This one day takes you through that process so you come out of it with all your parts and the ability to manipulate data with almost as much ease as you use SQL.

We'll be spending a whole day learning how to work with tabular data in R using data.table. From ingestion of millions of rows of data FAST, to being able to do all the things you know and love in SQL FAST, to doing things SQL can't FAST, to writing data FAST, data.table has it all and it's all FAST. (you may not have noticed that I think it's FAST)

So come spend the day learning how to use data.table!
Agile BI promises to deliver value much quicker to its end users. But how do you keep track of versions and prioritize all the demands users have?
With Visual Studio Online (cloud version of Team Foundation Server) it is possible to start for free with 5 users, with Version Control, Work Item management and much more.
In my session you will get the directions to a quick start with Visual Studio Online. You will learn the possibilities of Version Control and in which way to implement Scrum work item management with all available tools.
Your tabular model is done, approved and ready to be used by the user. By means of using Excel the user gets very excited about the use of tabular Models. For a while the user uses Excel as a self-service business intelligence tool. Then all of a sudden the user starts asking if they can use the program to extract more and other information from the tabular model by the use of Excel. Now it is up to you to familiarize the user with all the possibilities of working with the tabular model by means of Excel.
Given the small amount of documented knowledge about the use of tabular models by means of Excel, I will show you how to get the best of your tabular models by using Excel as a self-service business intelligence tool. Filters, named sets, and calculations in the pivot table: I will explain it all!
Where to start when your SQLServer is under pressure? If your server is
misconfigured or strange things are happening, there are a lot of free tools
and scripts available online.These tools will help you decide whether you have
a problem you can fix yourself or you really need a specialized DBA to solve it.  Those scripts and tools are written by renouwned SQLServer specialists. Those tools provide you with insights of what
might be wrong on your SQLServer in an quick and easy manner. You don’t need extensive knowledge of
SQLServer nor do you need expensive tools to do your primary analysis of what
is going wrong
And in a lot of instances these tools will tell you that you yourself can fix the problem. 
Whether you've dabbled in PowerShell or wondered what all the fuss is about, make no mistake: PowerShell is something worth learning to make your life as a SQL Server professional easier. Whether you're a DBA, a SSIS developer, or security professional, In this session you'll see practical, real world examples of how you can blend SQL Server and PowerShell together, and not just a bunch of regular T-SQL tasks that have been wrapped in PowerShell code.

In this session, you'll first get a brief introduction to the SQL Server PowerShell module. From there, it's nothing but code and examples to show you what's possible and why learning PowerShell is such a fundamentally awesome skill to make part of your portfolio or CV. You don't need to know anything about the language before stopping in, but by the time you leave you'll be excited to learn more!
save

...as well as some you may not even be aware of yet!
We will kick off with a small history on how Columnstore indexes evolved since SQL Server 2012 and the internals of Columnstore indexes, because this is how Operational analytics became possible. Then we will build up the session showing tips and tricks into how to make Operational analytics fit in your environment by lessons learned in the field. In the end we will show you how to make it fit with various techniques and heavy loads to a system.
After this session you will be able to know how to make this fit for your environment, there will be no more mystery in what is your hot and cold data & you will know the different uses of columnstore to make this work.
If your regular SQL Server becomes too slow
for running your data warehouse queries, or uploading the new data takes too
long, you might benefit from the Azure Data Warehouse. Via its “divide and
conquer” approach it provides significant performance improvements, yet most
client applications can connect to it as if it is a regular SQL Server.

But to benefit from these performance
improvements we need to implement our Azure Data Warehouse in the right way. In
this session - through a lot of demos - you will learn how to setup your Azure
Data Warehouse (ADW), review indexing in the context of ADW and see that
monitoring is done slightly different from what you’re used to.
Digital Transformation is much more than just sticking a few Virtual Machines in the cloud; it is real, transformative, long-term change that benefits and impacts the whole organisation.
Digital Transformation is a hot topic with CEOs and the C-level suite, renewing their interest in data and what it can do to empower the organisation.
With the right metrics and data visualisation, Power BI can help to bring clarity and predictability to the CEO to make strategic decisions, understand how their customers behave, and measure what really matters to the organization. This session is aimed at helping you to please your CEO with insightful dashboards in Power BI that are relevant to the CxO in your organisation, or your customers’ organisations.
Using data visualisation principles in Power BI, we will demonstrate how you can help the CEO by giving her the metrics she needs to develop a guiding philosophy based on data-driven leadership. Join this session to get practical advice on how you can help drive your organisation’s short and long term future, using data and Power BI.
As an MBA student and external consultant who delivers solutions worldwide, Jen has experience in advising CEO and C-level executives in terms of strategic and technical direction.
Join this session to learn how to speak their language in order to meet their needs, and impress your CEO with proving it, using Power BI.
We all know about the "Vs" of Big Data: velocity, volume and variety. What about the missing "V?" That would be visualization? What does "big data" look like? It has to be more than beautiful. It must convey information and insights in a way that people understand. Furthermore, people expect to make actionable insights from their data. How can we make big data friendly to users? This session will look at a mix of technologies for visualizing big data sources and ways of achieving BigViz harmony in your Big Data.You will learn:
About Big Data—from machine scale size down to human scale understanding
Technologies for visualizing Big Data, both Microsoft and Open Source
Data Visualization principles
So Azure SQL DataWarehouse is now available and starting to be use, but what does that mean to you and why should you care?

Reflecting on a large-scale Azure DW project, this session gathers together learnings, successes, failures and general opinions into a crash course in using Azure DataWarehouse “properly”.

We'll start by quickly putting the technology in context, so you know WHEN to use it, WHERE it’s appropriate and WHY it works the way it does.
  • Introducing the ADW technology
  • Explaining distributions & performance
  • Explaining polybase
Then we'll dive into HOW to use it, looking at some real-life design patterns, best practice and some “tales from the trenches” from a recent large Azure DW project.
  • Performance tips & tricks (designing for minimal data movement, managing distribution skew, CTAS, Resource classes and more)
  • ETL Patterns (Surrogate keys & Orchestration)
  • Common Mistakes & Pitfalls
  • Conclusions & Recommendations
You’ve probably already seen that R icon in
the Power BI GUI. It shows up when creating sources, transformations and
reports. But the ugly textbox you got when you clicked upon those icons didn’t
encourage you to proceed? In this session you will learn just a few basic
things about R that will greatly extend your Power BI data loading,
transformation and reporting skills in Power BI Desktop and PowerBI.com
In this session, we will look at data visualisation using:

Apache Spark
R
Python
Power BI

We will look at how we can enhance the suite of offerings to your data consumers by opening your toolbox of Open Source data visualisation tools, as well as Microsoft's Power BI.

Using Microsoft SQL Server and Big Data as a source, we will look at these open source and proprietary tools as an accompaniment to Power BI - not a replacement. 

Join us for this demo-heavy session, and be sure to download the code from Jen's blog right before the session in order to try it out as we proceed through the session. The emphasis is on practical takeaways that you can apply when you go back to your office after SQLBits, and try it out for yourself.
So you have made first contact with Biml and are excited? Good!















You're wondering, if Biml can do more than just transfer data from SQL table to another? Great!















Because Biml does so much more than just simple SSIS packages. We'll explore the potential on how to improve your existing packages using BimlScript and LINQ.







Topics covered, amongst others, are derived columns, incremental changes and how to handle flat files.















You'll leave with sample code and hopefully a couple of ideas on how to bring your Biml development to the next level.
In this demo-heavy session, you will learn about the basic concepts of increasing productivity by creating your SSIS packages using Biml.



We will look into manual Biml code to understand the general idea of Biml, then take it from there and generate a whole staging area from scratch and end with a complete manageable solution to completely maintain your staging process using SQL tables.



Have you ever spent hours fixing your SSIS due to a schema change on the source? Ever wanted to add a "load timestamp" to 370 tables in your staging area but refrained because it would have taken you weeks to do so? If so, this is the session for you!
Most of the time pilots are learning to fly, they're actually learning how to recover from emergency conditions. While we as Database Administrators focus on taking backups, how much time do we actually spend practicing recovering with those backups? This session will focus on the kinds of situations that can dramatically affect a data center, and how to use checklists to practice recovery processes to assure business continuity.
Every business needs to guess. From core business (Will this customer default on its loan?) to IT management (How much disk space will this new database need?) they are making lots of decisions daily using some sort of ‘model’: from gut-feeling over averages up to linear regression. Machine learning offers more advanced techniques to build a model on historical data and apply this to new observations. In this one day precon we walk through the full process of building these models on AzureML, the cloud-based machine learning framework Microsoft released in summer 2014.
We start from scratch, so no machine learning nor statistical knowledge is required. First we need to figure out what we try to cook: not all business problems can be solved with AzureML. After discussing which problems can be tackled by AzureML, we start looking for the main ingredients: data. Also we investigate how to clean these ingredients: data preparation is a crucial step! Then it’s time to do the actual cooking: There are many machine learning algorithms available in AzureML: we’ll browse through them and give some intuition on what they do, such that we can configure them properly. Once we’re done cooking it’s time to serve the result. AzureML allows us to convert our process into a web service. We’ll see both how to create and consume such a web service.

 
Most of the time you’ll see ETL being done with a tool such as SSIS, but what if you need near-realtime reporting? This session will demonstrate how to keep your data warehouse updated using Service Broker messages from your OLTP database.
Did you know, you can use Biml for much more than just SSIS? No? This session will probably surprise you - even with some DBA related topics! We will look into deployment, sample data creation, test cases and other ideas, that will show you, how powerful and flexible Biml really is - and that it does way more than you may have thought!
Maintaining a solid set of information about our servers and their performance is critical when issues arise, and often help us see a problem before it occurs.  Building a baseline of performance metrics allows us to know when something is wrong and help us to track it down and fix the problem.  This session will walk you through a series of PowerShell scripts you can schedule which will capture the most important data and a set of reports to show you how to use that data to keep your server running smoothly.

Containers are a new and exciting technology but what does it mean for DBAs?

This session will give an introduction into SQL Server running in containers and what options are available.

Attendees will be taken through the following: -

Defining what containers are (benefits and limitations)
Configuring Windows Server 2016 to run containers
Installing the docker engine
Pulling SQL images from the docker respository
Running SQL Server containers
Committing new SQL Server images
Exploring 3rd party options to run containers on previous versions of Windows Server (real world example)

This sessions assumes that attendees have a good background in SQL Server administration and a basic knowledge of Windows Server administration
SQL Server 2016: Data quality and data cleansing have always been major challenges to any enterprise that deals with data. For those of us who have dealt with Data Profiler Tasks in SQL Server 2008, we were shocked yet pleasantly surprised with the great advances that Microsoft has made with the advent of Data Quality Services, in the SQL Server 2012 release. In this hands-on presentation we shall be looking at how to set up a new knowledge base, based upon an existing one, set up rules, do knowledge discovery within the new knowledge base and finally cleanse the data through a data quality project. The end results being more effective data, guaranteed to keep end users and management happy.
Master Data Services can be readily be employed for Rapid Application Development. We shall be looking at important development, data security and data maintenance aspects, all based upon a recent client implementation.
Ah, SQL Server Transactional Replication. The technology everyone loves to hate. But for all the notoriety, there's some interesting technology to be had in it that might you might want to leverage. In this session, we'll explore what happens when you create a new transactional publication: what happens during a snapshot, how data gets delivered to subscribers, and how you can monitor, tweak, and tune your publications. We'll also look at a couple "gotcha" scenarios regarding replication and high availability, and even how replication can put you out of compliance if you're not careful. There will be plenty of examples and demos and, yes, even some PowerShell!
Tired of Bar Charts? We'll build out a custom PowerBI Visual and show the power of PowerBI whilst going into a deep dive on how this is achieved. We will be exploring web technologies along with data technologies, and seeing how some very powerful constructs are used to produce PowerBI reports. 

We will be covering a variety of content; including: Typescript, Javascript, HTML5, Gulp, Visual Studio Code, the MVVM pattern, D3.js, and without giving the game away too much, Google Maps.
Database maintenance isn’t a single event; it’s a lifecycle. Aside from the maintenance event itself, there’s also reporting, error management, specialized configs, HA/DR and more. In this full day session, we'll explore the many issues surrounding maintenance and how to solve them in a way that is cohesive and comprehensive. If you’re managing more than one server, come to this session.
Learn how to:
  • Deploy maintenance routines to hundreds of servers, effortlessly
  • Standardize configuration throughout the enterprise
  • Set up custom alerts and reports.
  • Manage HA/DR failover scenarios and keep your maintenance intact.
  • Minimize the number of jobs
  • Tune backups and database integrity checks

For maintenance, you'll learn how to:
  • Order index operations to maintain the most important tables first
  • Maximize your maintenance window by fine-tuning your routine.
  • Easily deal with special circumstances like indexes with settings that conflict with maintenance.
  • Make reindex operations fully dynamic to meet your changing environment.
  • Handle the most difficult CheckDB scenarios with dynamic custom snapshots, multi-threading and CheckDB offloading using auto-restore and remote CheckDB operations.
And for backups specifically, you'll learn to:
  • Automate management of failed backups
  • Ensure that certificates and encrypted passwords are securely backed up
  • Automate configuration changes between HA/DR sites, in case of failover.
  • Turn trace flags on or off automatically.
  • Dynamically archive end of month or end of year backups.
  • Tune the backups for your entire enterprise and keep them tuned as the environment changes.
This will be the most complete class on enterprise maintenance you'll ever have.  
Sign-up now.
In this session we will look at how you can use Power BI to analyse you company’s online presence.  

We will look at how you can source data from Google Analytics, Facebook, Twitter, LinkedIn and Instagram.

We will discuss different ways to get the data and what the difficulties/hindrances are when working with API's in Power BI.

We will then show how you can work with the data to get some meaningful analysis from it and ask the question: Can you get a holistic view of your online presence? 

This is a demo rich session where we will go through getting the data in and looking through how we can extend the model before visualizing the results.  

The participants will leave the session with ideas on how they can use Power BI (or indeed some other BI tool) to start analyzing their company's online presence.
Have you ever wondered if there are scored more goals when it rains or if Stoke wins more games on cold weekday evening at bet265 stadium? This session shows how you can use open data sources and web pages to gather data.

How you can then manipulate and extend it and finally report on it. We will look into how you can use data from Azure data market or other open source and combine it with data from web pages to create the dataset you need.

When we have our dataset we will manipulate and extend it using M and DAX so that we can get meaningful insights from it. We will then dive into the data to see if there is anything to report. 

In this end to end Power BI Desktop demo we will use fun data that many can relate to as the English Premier League is one of the most popular football leagues in the world. The audience will take away many nuggets of information as they see how a real world example could look like. I will share with them all the obstacles and learning I got when creating this report so they will see both the limitation of Power BI Desktop and open data as well as its strength. First of all the audience will learn how to use Power BI Desktop to create something real with fun data.

Both the data acquisition and manipulation as well as the reporting is covered in this demo rich session. The audience will learn about Power BI desktops strength and weaknesses as well as the benefits and potential problems with using open data and web pages as source.

In the end the Power BI Desktop file will be available to download for the audience. 
The cloud is here, and you want to start working with it. When starting to work with SQL Server in the cloud, there are many things that need to be taken into account.

Through extensive demos on both Amazon Web Services and Microsoft Azure, and using lessons learnt from the field, this full day seminar will take you through the steps of moving SQL Server to the cloud the right way: from choosing the right cloud
model, to architecture and performance considerations, and finally to performing the actual deployment.

By the end of the day, you will have a firm understanding of the options for running SQL Server in the cloud, when and how to use which, how to do it the right way, and how to leverage the benefits of the cloud.

The seminar will cover:

·        How to choose a cloud vendor

·        How to choose between SQL Server as a service and SQL Server on a virtual machine

·        How to choose the right hardware for your workload

·        Performance considerations and best practices

·        How to work in a hybrid environment where your data is both on-premise and in the cloud

·        Backup, restore, high availability and disaster recovery options

·        Security considerations

·        Scaling options

·        What to watch out for

·        How SQL Server fits in the cloud ecosystem

·        How to automate your work

·        How to cut your expenses

 
The seminar will include a deep dive into both the PaaS options (Azure SQL Database and Amazon RDS) and IaaS options (Azure Virtual Machines and Amazon EC2).

Whether you plan to migrate a current project to the cloud or
start a new one, this seminar is for you.
Understanding how SQL Server stores your data can seem like a daunting task. In this session we'll learn how objects such as tables and indexes are stored in a data file. We’ll also look at how these concepts tie in to your work. We’ll see these concepts in action using demos and see how we can use this knowledge to better design solutions.

We’ll start off by looking at the structure of a row and then move onto the concept of a data page. From there we’ll cover a few special page types like the index allocation map and GAM and SGAM pages. Then we’ll look at index structures and talk about the differences between heaps and clustered indexes.
With partitioning, we can break a table or index into smaller more manageable chunks. We can then perform maintenance on just part of a table or index. We can even move data in and out of tables with quick and easy metadata only operations. We’ll go over basic partitioning concepts and techniques like partitioned views and full blown table partitioning. We’ll look at how partitioning affects things under the hood. Finally you'll see some cool demos/tricks around index maintenance and data movement. At the end of this session you’ll have a firm understanding of how partitioning works and know how and when to implement it.

You'll learn…

• The components of table partitioning and how they fit together

• How to make your index maintenance partition aware

• How Partition elimination can help your queries

• How to split different parts of tables over different storage tiers

• How to manage partitions. We'll demo this by implementing the sliding window technique. 
Microsoft have been positioned as a Leader in the Gartner Magic Quadrant for Business Intelligence and Analytics Platforms. Th "new" Microsoft shows in the "new" Business Intelligence, and SQL Server 2016 provides a plethora of new tools for the Business Intelligence including R, Datazen and Power BI. There is a new emphasis on mobile, too.

In this session, we will have an overview of these tools and learn "what to use, when" so that you have a blueprint for your mobile, cloud, hybrid and on-premise Business Intelligence strategy, using SQL Server 2016 as the supporting technology.

Takeaways: SQL Server Reporting Services (SSRS) has been given the love it deserves; learn about Datazen and how if fits with SSRS and Power BI; see the new capabilities for SQL Server Analysis Services; see Microsoft R Server in SQL Server, explained; mobile business intelligence for everyone!

Join this session to get the inside scoop on SQL Server 2016 from the Business Intelligence perspective.
Digital transformation leverages the changes and opportunities of digital technologies to transform business activities, processes, competencies and models to converge for the benefit of the organisation.

How do you go from building Business Intelligence solutions as a technical team member, to shifting your focus to building businesses as who rely on your data to become data-driven organisations? How do you become part of the Digital Transformation story? 

Today’s hype about the possibilities and opportunities in Data, and particularly Big Data, mean that organisations can find it difficult to know where to start, or even how to start. Very often, businesses simply store all of their data, rather than think proactively about the data that they have, and how they could use it. In order to survive, businesses will have to move forward.

As businesses continue to get excited about the opportunities of Big Data, they will also need Data-Driven Leadership within their organisations in order to guide them effectively towards success. Now is the time
for businesses to bring their data and their strategy together, using the latest technologies.

Join this session to see how you can transition from being a business intelligence technical expert, to a data-driven leader in your organisation that is going through a process of Digital Transformation. This is a rare and valuable skill, and talking the language of the boardroom means that you can have a real impact on transforming your organisation through data.
We will look at the definitions, models and metrics that are essential for a successful Data Transformation strategy using Power BI as a way of articulating useful metrics.
The biggest barrier facing new ML practitioners is the assumption that to become a serious data science practitioner, you need deep knowledge of machine learning theory, deep mathematics, formulation or training methods. In this session, Nabeel will argue that the essential skills needed are: a love for working with data, hard work, and the devotion of a good deal of time to play with lots of data and apply various ML tools on them.

You will learn by an actual R experiment how ML works, and how to transition from a beginner to an expert through a clear roadmap.
Database Professional is always challenged with monitoring and maintenance across the environment. Be it 10 server or a 1000 servers, would it be easier to have a centralized solution? In this session I will walk you through the simple steps of building a centralized database maintenance and monitoring solution. 


This solution will help a database professional to query all the monitored instances, collect performance metrics, run customized scripts and any maintenance task a database professional needs to perform across the database environment. Talk about a easy DBA life, this is a definite simple solution you should build.
Have you ever struggled to get a HA and DR solution for a single instance with more than 50 applications, 100 databases and 4 TB of data? Over the years, HA and DR has been a challenge with SQL Server. As the product evolved so did the options simplified for achieving a feasible HADR solution. 


In this session I will walk you through various projects I have worked on in past 8 years. I will start with the basic DR solution built using Log shipping, an alternate to AGs in SQL 2008 using Powershell/.NET and SAN Replication and the latest 4 node, two site cluster built with Availability Groups.
During the acrimonious US election, both sides used a combination of cherry-picked polls and misleading data visualization to paint different pictures with data.
In this session, we will use a range of Microsoft Power BI and SSRS technologies in order to examine how people can mislead with data and how to fix it. We will also look at best practices with data visualisation.
We will examine the data with Microsoft SSRS and Power BI so that you can see the differences and similarities in these reporting tools when selecting your own Data Visualisation toolkit.
Whether you are a Trump supporter, a Clinton supporter or you don't really care, join this session to spot data lies better in order to make up your own mind.
The biggest barrier facing new ML practitioners is the assumption that to become a serious data science practitioner, you need deep knowledge of machine learning theory, deep mathematics, formulation or training methods. In this session, Nabeel will argue that the essential skills needed are: a love for working with data, hard work, and the devotion of a good deal of time to play with lots of data and apply various ML tools on them.

You will learn by an actual R experiment how ML works, and how to transition from a beginner to an expert through a clear roadmap.
Based on the popular blog series, join me in taking a deep drive and a behind the scenes look at how SQL Server 2016 "Just Runs Faster",focused on scalability and performance enhancements. This talk will discuss specific engine improvements, not only for awareness, but to expose design and internal change details. The beauty behind "It Just Runs Faster" is your ability to just upgrade and gain performance with out lengthy and costly application or infrastructure changes. If you are looking at why SQL Server 2016 makes sense from a technical perspective for your business you won't want to miss this session.
We will explore the details of how In-Memory OLTP ("Hekaton") is integrated into the SQL Server 2016 Engine. This includes internals of threads, data and index design, row formats, transactions and concurrency, logging, storage, and natively compiled procedures. This talk has plenty of demos including a rich use of the Windows Debugger to learn how In-Memory OLTP works. Even though this is a deep session, you will come away with a fundamental knowledge of why In-Memory OLTP can give you a 30x performance boost for OLTP applications.
Storage can be one of the biggest bottlenecks when it comes to database performance. It’s also one of the hardest places to troubleshoot performance issues because storage engineers and database administrators often do not speak the same language. In this session, we’ll be looking at storage from both the database and storage perspectives. We’ll be digging into LUNs, HBAs, the fabric, as well as the storage configuration. After going over the components we'll dig into some advanced storage configurations. This includes RAID groups, multi-pathing software, and proper redundant storage network design. We will also be digging into some advanced storage array backup techniques including taking storage level clones and snapshots. After going over these advanced techniques we will dig into how these can best be used to backup the SQL Server environment to provide maximum redundancy with no recurring tape costs.
In this all day session on Microsoft SQL Server we will be learning about how Microsoft SQL Server works and what needs to be done to keep it up and running smoothly when you don't have a full time database administrator on staff to help you keep it running. In this session we will cover a variety of topics including backups, upgrade paths, indexing, database maintenance, database corruption, patching, virtualization, disk configurations, high availability, database security, database mail, anti-viruses, scheduled jobs, and much, much more. After taking this full day session on SQL Server you'll be prepared to take the information that we go over and get back to the office, get the SQL Server's patched and properly configured so that they run without giving you problems for years to come.

In this day long pre-con session we will explore the various high availability options within SQL Server including how to configure these various options.  We will be looking into Windows and SQL Server Clustering (including what is needed for a geographically dispersed cluster), Database Mirroring, The AlwaysOn features, and SQL Server Log Shipping. In addition to working through these high availability options, we will be discussing the most important part of high availability configuration, making sure that you know how to select the correct high availability solution.  After completing this high availability pre-con session you'll be able to make the correct decision about which high availability decision to deploy, as well as how to correctly deploy the selected solution.