sqlsathistory

Nr: 526

Back to Main list

SQLSaturday #526 - Rochester 2016

Start Time (24h) Speaker Track Title
08:30:00 William E Pearson III Analysis Techniques and Visualization Pragmatic Power BI: Working with Data Sources
08:30:00 Kevin Feasel BI Platform Architecture, Development Administration Data Migration Using BIML
08:30:00 Chris Sommer Enterprise Database Administration Deployment SQL Server Automation with PowerShell
08:30:00 Mike Hays Professional Development Tackling Technical Blogging
08:30:00 Colleen Morrow Enterprise Database Administration Deployment Inside the Black Box - Making Sense of Service Broker
09:45:00 Edward Pollack Enterprise Database Administration Deployment Dynamic SQL: Writing Efficient Queries on the Fly
09:45:00 Kevin Feasel Application Database Development Peanut Butter Chocolate: Integrating Hadoop with SQL Server
09:45:00 Chris Bell Enterprise Database Administration Deployment Hacking Expos#233; - Using SSL to Secure SQL Server Connections
09:45:00 George Walters Application Database Development In-Memory tables with SQL Server 2014 and 2016
09:45:00 Regis Baccaro BI Platform Architecture, Development Administration Advanced BIML - for the advanced ETL developer
11:00:00 Thomas Grohser Enterprise Database Administration Deployment SQL Server Storage Engine under the hood
11:00:00 Robert Davis BI Platform Architecture, Development Administration 10 Things Administrators of BI Systems Should Know
11:00:00 Jeffry Schwartz Enterprise Database Administration Deployment Rx for Demystifying Index Tuning Decisions
11:00:00 Justin Dearing Application Database Development Version control with GIT for the DBA
11:00:00 Kevin Kline Application Database Development Learning and Optimizing the SQL Server Plan Cache
13:30:00 Thomas Grohser Enterprise Database Administration Deployment Designing SQL Server HA/DR Infrastructure to meet the SLA
13:30:00 William E Pearson III BI Platform Architecture, Development Administration Getting Started with MDX
13:30:00 James Serra Strategy and Architecture Should I move my database to the cloud?
13:30:00 Kevin Kline Application Database Development Ten Query Tuning Techniques Every SQL Programmer Should Know
13:30:00 Regis Baccaro Application Database Development Continuous Integration with SSDT and Team Foundation Server
14:45:00 Ray Kim Professional Development Whacha just say? Talking technology to non-technical people
14:45:00 Robert Davis Enterprise Database Administration Deployment New Paradigm for Performance Tuning in SQL Server 2016
14:45:00 Derik Hammer Enterprise Database Administration Deployment Architecting Availability Groups
14:45:00 Chris Bell Enterprise Database Administration Deployment Statistics Cardinality – How they work to find data efficiently
14:45:00 George Walters Application Database Development Tier 1 Application Migration to Azure!
16:00:00 Edward Pollack Enterprise Database Administration Deployment Diving Into Query Execution Plans
16:00:00 James Serra Strategy and Architecture Relational databases vs Non-relational databases
16:00:00 Gigi Bell Professional Development Dealing With Difficult Coworkers
16:00:00 Mike Hays Enterprise Database Administration Deployment Taming the Transaction Log
16:00:00 Ray Kim Strategy and Architecture Disaster Documents: The role of documentation in disaster recovery

SessionID: 45881

Pragmatic Power BI: Working with Data Sources

Back to calendar

Event Date: 14-05-2016 - Session time: 08:30:00 - Track: Analysis Techniques and Visualization

Speaker: William E Pearson III

Title: Pragmatic Power BI: Working with Data Sources

Abstract:

Power BI (either Desktop or the service) supports a wide (and growing) range of data sources. From the sources with which most IT pros and data analysts are regularly involved (relational and OLAP databases, text and similar files, etc.) to sources that are a little more out of the ordinary for some of us (OData, MS Exchange, Active Directory, and a growing list of others), these reservoirs and suppliers of data grow increasingly more valuable in self-service BI.

In this session, BI Architect, SQL Server MVP and Analysis Services Maestro Bill Pearson focuses upon the first step in working with data sources in Power BI: connecting to, and extracting data from, a diverse range of data sources. Throughout the session, we explore various sources and witness how to employ Power BI with each.

SessionID: 46083

Data Migration Using BIML

Back to calendar

Event Date: 14-05-2016 - Session time: 08:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Kevin Feasel

Title: Data Migration Using BIML

Abstract:

Many companies scale out their databases horizontally, partitioning data by customer (or some other identifier) into separate databases or instances. Sometimes, it becomes important to move that data from one database to another. SQL Server Integration Services is a fantastic tool for ETL, but creating and maintaining dozens or hundreds of data flows by hand is exhaustingly tedious. Instead of doing it the hard way, use the BI Markup Language (BIML) to automate package development. This talk will show how we can use metadata tables and BIML to auto-create SSIS packages to migrate data from one database to another, handling foreign key constraints along the way.

SessionID: 46184

SQL Server Automation with PowerShell

Back to calendar

Event Date: 14-05-2016 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Chris Sommer

Title: SQL Server Automation with PowerShell

Abstract:

DBA’s are constantly faced with challenges in maintaining a healthy SQL Server environment. Monitoring our database servers, deploying database code changes and performing database restores are just a few examples of a day in the life of a DBA. As workloads increase, performing these tasks manually introduces more opportunity for human error and time starts to become our bottleneck. The only option if you want to stay above water is to become more efficient at what you do. Enter automation. Enter PowerShell.

Initially released in 2006, PowerShell has grown to become Microsoft's premier scripting language on the Windows platform. This presentation will begin with a brief overview of the PowerShell language itself, but the primary focus will be on how to interface with SQL Server to help automate your database environment.

SessionID: 48154

Tackling Technical Blogging

Back to calendar

Event Date: 14-05-2016 - Session time: 08:30:00 - Track: Professional Development

Speaker: Mike Hays

Title: Tackling Technical Blogging

Abstract:

Ever thought of writing a technical blog? This session will cover the Ws (who, what, when, where, why, how) of getting a technical blog started. Answer the question of how it can be done for free. Discuss why pay for your own domain name. Explain how to be on the first page of a search engine. Learn how to determine the time commitment. And finally determine topics to write about.

SessionID: 48507

Inside the Black Box - Making Sense of Service Broker

Back to calendar

Event Date: 14-05-2016 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Colleen Morrow

Title: Inside the Black Box - Making Sense of Service Broker

Abstract:

SQL Server Service Broker is often seen as a black box. Messages go in, and hopefully they come out on the other side. But when they don't, DBAs typically don’t know where to look. Trying to figure out what’s wrong quickly turns into a guessing game.

It’s not that complicated once you understand how it all works. Service Broker is an asynchronous messaging technology built into SQL Server that allows you to scale out your application, replicate data or perform ETL, all while guaranteeing messages are delivered and processed in the right order. In this session, we'll discuss the basics of the Service Broker architecture, its components, and deployment options. We will discuss troubleshooting tips and performance best practices to help you deploy a Service Broker solution in your own environment.

SessionID: 45905

Dynamic SQL: Writing Efficient Queries on the Fly

Back to calendar

Event Date: 14-05-2016 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Edward Pollack

Title: Dynamic SQL: Writing Efficient Queries on the Fly

Abstract:

Dynamic SQL can be a powerful tool that allows you to write fast efficient queries when the specifics may not be known until run-time. It can also be complex, difficult to read and debug, and the source of some of the most confusing TSQL you'll ever see.

Explore the many uses for dynamic SQL as well as best practices for writing, testing, debugging, and maintaining it, with the bonus of helping to improve the sanity of your coworkers (and your own) in the process!

SessionID: 46084

Peanut Butter Chocolate: Integrating Hadoop with SQL Server

Back to calendar

Event Date: 14-05-2016 - Session time: 09:45:00 - Track: Application Database Development

Speaker: Kevin Feasel

Title: Peanut Butter Chocolate: Integrating Hadoop with SQL Server

Abstract:

So you jumped on the bandwagon and set up a Hadoop cluster…but now what? Your database developers and app developers know how to integrate with and develop against SQL Server, but the Hadoop world is a completely different experience. This talk will help bridge the gap between SQL Server and Hadoop, using tools such as SQL Server Integration Services and Sqoop to migrate data between a Hadoop cluster and a SQL Server instance, as well as PolyBase to integrate the two like never before.

SessionID: 46610

Hacking Expos#233; - Using SSL to Secure SQL Server Connections

Back to calendar

Event Date: 14-05-2016 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Chris Bell

Title: Hacking Expos#233; - Using SSL to Secure SQL Server Connections

Abstract:

You know all the ways to protect your database when it is at rest, but what about when someone connects and starts running some queries? What if they connect and don't do anything? Just how exposed is that data?

We will assume the role of a hacker and, by using a simple technique, we will sniff packets on a network to reveal what data is being sent. You may be shocked! We will then secure our database connections with a simple self-signed SSL certificate. Once secured, we will resume the role of the hacker and look inside the packets to see what has changed. *Warning - Do not try these demos at work without proper permissions as actual hacking techniques are used.

SessionID: 48769

In-Memory tables with SQL Server 2014 and 2016

Back to calendar

Event Date: 14-05-2016 - Session time: 09:45:00 - Track: Application Database Development

Speaker: George Walters

Title: In-Memory tables with SQL Server 2014 and 2016

Abstract:

SQL 2014 and 2016 have the new In-Memory table aka Hekaton. This session will talk about "why in-memory" as well as the options available with new development scenarios around this in-memory table structure with SQL 2014, 2016, and Azure.

SessionID: 48872

Advanced BIML - for the advanced ETL developer

Back to calendar

Event Date: 14-05-2016 - Session time: 09:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Regis Baccaro

Title: Advanced BIML - for the advanced ETL developer

Abstract:

This is not your regular Agile BIML session. By now you already know that BIML is a great productivity enhancement to SSIS. You also know that you can build metadata driven solution and include C# code in your BIML scripts or snippets. If you don't know what I'm talking about this session is not for you. If you - on the other hand - want to know how to build a modular BIML framework, do real C# development and include it in your BIML code so that you can pass custom objects around for optimized performance and code reuse then this session is for you. We will see how to build a reusable C# framework that can be obfuscated and deployed to customers without worrying about Intellectual property. I promise you no more than a few slides but a lot of demos and real life experience acquired from major BIML projects. We will also have a look at how to harness integration and unit tests in the setup with a twist of Continuous Integration with Team Foundation Server.

SessionID: 45864

SQL Server Storage Engine under the hood

Back to calendar

Event Date: 14-05-2016 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Thomas Grohser

Title: SQL Server Storage Engine under the hood

Abstract:

How SQL Server performs I/O

How is SQL Server really accessing the data and log files on the disk? What's done asynchronous and what's synchronous and what impact does that have on our queries and DML statements. Which impact have features like database mirroring and replication, what's different when SQL Server is starting up. #160; Which I/O Subsystems (including SSD) are best for which type of data and what's the impact if you choose a different one. Which files can be placed on the same volume and which should not.

SessionID: 46341

10 Things Administrators of BI Systems Should Know

Back to calendar

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

Speaker: Robert Davis

Title: 10 Things Administrators of BI Systems Should Know

Abstract:

Conversations about SQL Server administration tends to be all about administering OLTP systems. If you administrer BI systems, you can't apply everything you know about administering OLTP systems to BI systems. BI systems usually end up being administered by OLTP DBAs or by BI developers and architects. Where does one even find a BI Administrator?

Fortunately, I've been administering BI systems for several years, and I have learned the hard way the difference between administering OLTP and BI systems. This session will cover the top 10 things that I think an administrator of BI systems need to know.

SessionID: 46585

Rx for Demystifying Index Tuning Decisions

Back to calendar

Event Date: 14-05-2016 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Jeffry Schwartz

Title: Rx for Demystifying Index Tuning Decisions

Abstract:

Indexes are one of the most troubling and mysterious areas for DBAs and developers. Adding, deleting, or modifying them can yield dramatically positive or negative changes in query performance. The mystery is knowing how indexes need to be adjusted and what outcomes will result. This uncertainty often leads to great reluctance to eliminate indexes that are used sparingly or only because the optimal ones are missing. This leads to index proliferation, which ultimately produces inconsistent and poor query performance. Some believe that the SQL Server Database Tuning Advisor will solve all these issues, but it frequently does not. In fact, it often compounds the proliferation problem significantly. This presentation will enable a DBA to make informed decisions regarding what query and index metrics to monitor, determine how indexes are used, and devise appropriate index strategies to improve query performance through index addition, deletion, or modification.

SessionID: 46829

Version control with GIT for the DBA

Back to calendar

Event Date: 14-05-2016 - Session time: 11:00:00 - Track: Application Database Development

Speaker: Justin Dearing

Title: Version control with GIT for the DBA

Abstract:

What does this mean to a DBA? Whether or not you use SSDT, you should be storing your database schema in version control. In addition, your utility scripts certainly belong in VCS.

In my session. We'll cover:

What is version control? How does a distributed version control system differ from traditional version control like Visual Sourcesafe, TFS, and SVN? How do I setup git for internal use in my company? How do I host public and private repositories on github. How do pull requests work? How do I fork a SVN repo to github?

We will be covering using git from both the command line and Visual Studio.

SessionID: 47310

Learning and Optimizing the SQL Server Plan Cache

Back to calendar

Event Date: 14-05-2016 - Session time: 11:00:00 - Track: Application Database Development

Speaker: Kevin Kline

Title: Learning and Optimizing the SQL Server Plan Cache

Abstract:

SQL Server memory management is one of the most important aspects of a writing T-SQL code. And yet many of us don’t know the fundamentals beyond “SQL Server will take care of that”. In this session, we’ll go deep into the internal behavior of the plan cache. We’ll cover four main problem scenarios within the plan cache, what causes them, and how to fix them, including:

  1. Bloating – scenarios that cause SQL Server to needlessly waste space in the plan cache.
  2. Suboptimal plans – scenarios where SQL Server can’t help but choose a bad execution plan, usually self-inflicted.
  3. Parameter sniffing – situations in which SQL Server specifically chooses a bad execution plan do to the type of parameters pass into T-SQL code.
  4. Recompiles – situations where SQL Server is unable to completely process a block of T-SQL code without having to recompile it.

If you don’t know much about SQL Server memory management, especially if you write T-SQL code, then this session is for you! You’ll learn

SessionID: 45862

Designing SQL Server HA/DR Infrastructure to meet the SLA

Back to calendar

Event Date: 14-05-2016 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Thomas Grohser

Title: Designing SQL Server HA/DR Infrastructure to meet the SLA

Abstract:

Once you agreed to an SLA for the databases you manage its time to deliver on this promise

This session will show how to select from the many HA/DR features you have in SQL Server to pick the ones that will help you meet the SLA and most important will tell you how you must combine them to be successful. For each one of the solutions we discuss we will define a series of failure modes and then check if the solution actually can fulfill the SLA as promised or if it needs more

SessionID: 45883

Getting Started with MDX

Back to calendar

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

Speaker: William E Pearson III

Title: Getting Started with MDX

Abstract:

In this session, led by Microsoft BI Architect, SQL Server MVP AND SSAS Maestro Bill Pearson, we will concentrate largely upon crafting simple MDX expressions and queries whose purposes, for the most part, are to return a set of data. We will overview the structure of a cube, using as a basis the sample Adventure Works cube that is available to anyone installing SQL Server Analysis Services 2008 R2 and above . We will then outline the components of simple MDX syntax, and get started writing basic expressions and queries. We will expose basic member functions, introduce filters (or “slicers”), and begin exploring core MDX functionality, including calculated members, and named sets.

SessionID: 46140

Should I move my database to the cloud?

Back to calendar

Event Date: 14-05-2016 - Session time: 13:30:00 - Track: Strategy and Architecture

Speaker: James Serra

Title: Should I move my database to the cloud?

Abstract:

So you have been running on-prem SQL Server for a while now. Maybe you have taken the step to move it from bare metal to a VM, and have seen some nice benefits. Ready to see a TON more benefits? If you said "YES!", then this is the session for you as I will go over the many benefits gained by moving your on-prem SQL Server to an Azure VM (IaaS). Then I will really blow your mind by showing you even more benefits by moving to Azure SQL Database (PaaS/DBaaS). And for those of you with a large data warehouse, I also got you covered with Azure SQL Data Warehouse. Along the way I will talk about the many hybrid approaches so you can take a gradual approve to moving to the cloud. If you are interested in cost savings, additional features, ease of use, and ending the days of upgrading hardware, this is the session for you!

SessionID: 47311

Ten Query Tuning Techniques Every SQL Programmer Should Know

Back to calendar

Event Date: 14-05-2016 - Session time: 13:30:00 - Track: Application Database Development

Speaker: Kevin Kline

Title: Ten Query Tuning Techniques Every SQL Programmer Should Know

Abstract:

SELECT statements have a reputation for being very easy to write, but hard to write very well. This session will take you through ten of the most problematic patterns and anti-patterns when writing queries and how to deal with them all. Loaded with live demonstrations and useful techniques, this session will teach you how to take your SQL Server queries mundane to masterful.

Goal 1: Implement a reusable Transact-SQL test harness for reliable query results. Goal 2: Learn ten patterns that kill the performance of SELECT statements and how to avoid them. Goal 3: Discover the high-impact metadata that shows how a SELECT statement behaves … or misbehaves.

SessionID: 48874

Continuous Integration with SSDT and Team Foundation Server

Back to calendar

Event Date: 14-05-2016 - Session time: 13:30:00 - Track: Application Database Development

Speaker: Regis Baccaro

Title: Continuous Integration with SSDT and Team Foundation Server

Abstract:

SQL Server Data Tools (SSDT) is Microsoft developer tools for working with SQL Server databases on premises and in the cloud. It supersedes Management Studio in development functionality. Team Foundation Server (TFS) is the collaboration platform at the core of Microsoft’s application lifecycle management (ALM) solution. TFS gives you the tools you need to effectively manage software development projects throughout the IT lifecycle. In this session, we are going to focus on the interaction between SSDT and TFS. Developing locally and publishing the changes to an on-premises instance of SQL Server. We will look at how we can do continuous integration between development and other environments pushing the schema changes and upgrading the version numbers in a seamless manner upon successful build of the solution. Furthermore we'll look at how to lift the integration to an even greater level by using Microsoft Release Management thus automating the deployment and testing of your software.

SessionID: 45875

Whacha just say? Talking technology to non-technical people

Back to calendar

Event Date: 14-05-2016 - Session time: 14:45:00 - Track: Professional Development

Speaker: Ray Kim

Title: Whacha just say? Talking technology to non-technical people

Abstract:

Many tech professionals are faced with the challenge of explaining technical concepts to people who don't understand technology. And only a few are able to do it well. This session provides some strategies and suggestions to go about bridging the technological knowledge gap. With time and practice, a technical person can serve as an effective interpreter of technical concepts. This is an interactive session; audience participation is expected and encouraged!

SessionID: 46342

New Paradigm for Performance Tuning in SQL Server 2016

Back to calendar

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

Speaker: Robert Davis

Title: New Paradigm for Performance Tuning in SQL Server 2016

Abstract:

SQL Server 2016 is introducing some new tools for analyzing and troubleshooting queries that is going to change the way we do performance tuning. It's not just new tools, it's a whole new paradigm.

SQL Server 2016 will introduce the Query Store and the Plan Compare Tool which will help you to quickly analyze and troubleshoot problem queries, diagnose the root-cause of query slow-downs, force execution plans and prevent future plan regressions, and track actual execution plan run-time statistics.

Have you ever had a job run unusually slow at 2 AM? If you are using Query Store, diagnosing the problem is as easy as looking at the execution data and plan for the 2 AM execution.

Does a query run fast with one plan but slow with another? With the plan compare tool, you can compare 2 plans in the same window to identify what is the same and what is different.

SessionID: 46487

Architecting Availability Groups

Back to calendar

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

Speaker: Derik Hammer

Title: Architecting Availability Groups

Abstract:

You are a DBA familiar with some basic Windows clustering and database mirroring concepts, and now you are considering AlwaysOn Availability Groups. This session will cover the pros and cons of four typical configurations of AlwaysOn Availability Groups; stand-alone instances, fail-over cluster instances, multi-subnet, and a hybrid approach that I call disaster-recovery-on-the-cheap. It will also include their exclusive features such as read-only routing and backup off-loading. In addition, you'll learn how to use the Availability Group Listener correctly and why you should be using Windows Server 2012 R2 or above, along with some of my own personal lessons learned.

SessionID: 47347

Statistics Cardinality – How they work to find data efficiently

Back to calendar

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

Speaker: Chris Bell

Title: Statistics Cardinality – How they work to find data efficiently

Abstract:

Are your statistics up to date?

Yes, it’s that dreaded phrase you hear all the time when it comes to performance tuning your SQL Server. What does it matter? Why should I care about statistics? Aren’t they automatic or something like that? In this session we will go over why statistics matter, how they are generated, how they impact performance, and even how to maintain them. Once we have that all settled, we will take a quick look at how the cardinality estimator uses statistics to determine a ‘good enough’ plan to use. We will close out the session by taking a look at the performance impact from a simple upgrade of your SQL Server to 2014 and using the new cardinality estimator.

SessionID: 48131

Tier 1 Application Migration to Azure!

Back to calendar

Event Date: 14-05-2016 - Session time: 14:45:00 - Track: Application Database Development

Speaker: George Walters

Title: Tier 1 Application Migration to Azure!

Abstract:

Considering a cloud architecture instead of on-premises? Come and walk through a Tier 1 Application with a heavy SQL on-prem footprint that was migrated to Azure. Considerations such as development changes, architecture, features required, reduced labor required, and people process to get this deployed.

SessionID: 45906

Diving Into Query Execution Plans

Back to calendar

Event Date: 14-05-2016 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Edward Pollack

Title: Diving Into Query Execution Plans

Abstract:

There is no better way to understand how TSQL is executing than through the execution plan. We will go into detail about the more complex parts of execution plans, relating them to other query statistics, and use this information to improve overall query performance. Be sure to bring your safety helmet!

SessionID: 45974

Relational databases vs Non-relational databases

Back to calendar

Event Date: 14-05-2016 - Session time: 16:00:00 - Track: Strategy and Architecture

Speaker: James Serra

Title: Relational databases vs Non-relational databases

Abstract:

There is a lot of confusion about the place and purpose of the many recent non-relational database solutions (“NoSQL databases”) compared to the relational database solutions that have been around for so many years. In this presentation I will first clarify what exactly these database solutions are, compare them, and discuss the best use cases for each. I’ll discuss topics involving OLTP, scaling, data warehousing, polyglot persistence, and the CAP theorem. We will even touch on a new type of database solution called NewSQL. If you are building a new solution it is important to understand all your options so you take the right path to success.

SessionID: 46614

Dealing With Difficult Coworkers

Back to calendar

Event Date: 14-05-2016 - Session time: 16:00:00 - Track: Professional Development

Speaker: Gigi Bell

Title: Dealing With Difficult Coworkers

Abstract:

John knows everything and goes out of his way to correct you at every turn. Mary is agreeable to a fault and just placates everyone. Mike is full of doom and gloom and whines constantly. Are these your co-workers? Relatives? Frenemies? You? Learn two golden rules to reduce the stress produced by the difficult people in your life.

SessionID: 48153

Taming the Transaction Log

Back to calendar

Event Date: 14-05-2016 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Mike Hays

Title: Taming the Transaction Log

Abstract:

Wonder why the transaction log keep filling up the hard-drive? Wonder why a full backup does not backup the transaction log? Wonder how often to back up the transaction log? Wonder if the transaction log can be backed up in parallel? This interactive session will help to you to find answers to those questions and more.

SessionID: 48593

Disaster Documents: The role of documentation in disaster recovery

Back to calendar

Event Date: 14-05-2016 - Session time: 16:00:00 - Track: Strategy and Architecture

Speaker: Ray Kim

Title: Disaster Documents: The role of documentation in disaster recovery

Abstract:

I was an employee of a company that had an office in the World Trade Center on Sept. 11, 2001. Prior to that infamous date, I had written several departmental documents that ended up being critical to our recovery. In this presentation, I provide a narrative of what happened in the weeks following 9/11, and how documentation played a role in getting the organization back on its feet.

While other disaster recovery presentations talk about strategies, plans, and techniques, this presentation focuses on the documentation itself. We will discuss the documents we had and how they were used in our recovery. We will also discuss what documents we didn't have, and how they could have made the process better.