Speaker – Carlos Chacon (view bio)
Session –Disaster Recovery From on Premises to Azure
Everyone says they have a disaster recovery plan; however, has that plan been tested? Planning for recovery by using the cloud is now easier and more convenient than ever. This session describes some common scenarios and reviews the steps needed to prepare for a disaster with a recovery in Azure. We will focus on the IAAS offerings with an eye on SQL Server.
Speaker – Tim Radney (view bio)
Session – Common SQL Server Mistakes and How to Avoid Them
Making mistakes is natural, but learning from them and avoiding them in future takes effort. There’s no substitute for experience or the shared wisdom of others to help you learn what mistakes to avoid. In this session, Tim will share with you a ton of what he’s learned over the years from working and consulting at multiple Fortune-level companies. You’ll hear about real-world environments he has worked on where there was a high impact from administrators making mistakes in how SQL Server was configured and administered. You’ll learn many proven and accepted best practices for installing, configuring and supporting SQL Server to help your environment run as smoothly as possible and you’ll leave with a checklist of items to take home to make sure your SQL Server environment is configured properly.
UPDATE – Tim’s presentation of this session to the DBA Fundamentals virtual chapter can be viewed on line here
Speaker – James Donahoe (view bio)
Session – New Instance, Now What?
Congratulations, you’re now our DBA! For new DBA’s a new SQL instance is like a blank canvas, you stare at it and wonder where to start. As an accidental DBA, this session will help you learn how to survive in your new role.
In this session, you will be supplied with the beginning brush strokes to make your server a master piece. To do so, we will review best practices for standard configurations, backups, maintenance, and disaster recovery.
By the end of this session, you will have developed a pallet of tools to help you create your SQL Server Masterpiece and be able to use it as a print for others.
Speaker – Melissa Coates (view bio)
Session – Building Blocks of Cortana Intelligence Suite in Azure
Join us for a practical look at the components of Cortana Intelligence Suite for information management, data storage, analytics, and visualization. Purpose, capabilities, and use cases for each component of the suite will be discussed. Expertise required for implementation of each component will be covered as well. If you are a technology professional who is involved with delivering business intelligence, analytics, data warehousing, or big data utilizing Azure services, this technical overview will help you gain familiarity with the components of Cortana Intelligence Suite and its potential for delivering value.
Speaker: Wayne Sheffield (view bio)
Topic –Minimally Invasive – Tools to Doctor Up Your Code
This code filled session examines several additions to recent versions of SQL Server. These tools allow you to perform minimally invasive surgery on your code and gain performance! Learn how the APPLY operator works; iterate through incoming data just once with the MERGE statement; “slice and dice” your data with the Windowing (ranking) functions; re-write your multi-statement table-valued functions to inline functions to help the optimizer and speed up your queries; learn how to create a grouped delimited list – without loops!