Thursday, June 23rd, 2016
All Times Eastern
||Event Lobby and Exhibit Hall Open
|11:00 a.m. – 12:00 p.m.
||SQL Server 2016 New Features
Speaker: Michael Otey
SQL Server 2016 is the newest release of Microsoft’s enterprise data platform. SQL Server has grown far beyond its roots as a simple relational database platform into a true enterprise level data platform. SQL Server 2016 continues to provide core relational database services as well as analysis service for BI, integration services for ETL and reporting Services for creating and distributing reports and more. With the SQL Server 2016 release, Microsoft has heightened SQL Server’s performance, security and availability technologies as well as embraced big data, analytics and mobility.
In this presentation, you’ll learn about the most important enhancements in SQL Server 2016. Some of the topics covered will include:
- The new Always Encrypted feature
- Row-level security
- The new Query Store
- Integration with the R data analysis language
- Polybase integration with big data
- Enhancements to In-Memory OLTP
- Enhancements to the Columnstore Index
- Enhancements to AlwaysOn Availability Groups
- Support for mobile reports with Reporting Services
- Improvements to tempdb
- SQL Server on Linux
- Stretch databases and hybrid cloud improvements
|12:00 p.m. - 12:15 p.m.
|12:15 p.m. - 1:15 p.m.
Advanced SQL and Oracle availability for the non-DBA
Speaker: Rick Vanover
Do you have a lot of SQL Server and Oracle databases? But what if you aren’t a DBA? This data is likely critical to your Always-On Enterprise; and you can’t tolerate data loss or downtime. Join Rick Vanover from Veeam to share expert tips on how you can keep these databases available with ease and in many cases for free! Topics covered in this webinar include:
- How you can easily get point-in-time recovery of Oracle and SQL Server databases
- Tips for managing Oracle and SQL logs
- A long list of free solutions to give you the best availability for Oracle and SQL Server
|12:15 p.m. - 1:15 p.m.
SQL Server DBA’s guide to Flash Storage Systems
Speakers: David Klee and Rasheed Abdul
Microsoft SQL Server has become a strong platform to run mission critical applications using high-performance, in-memory technology across OLTP, data warehousing, business intelligence and analytics. Unfortunately, the pain points for SQL Server DBAs continue to be in infrastructure provisioning, availability, performance and reliability. Flash storage is transforming the information infrastructure and eliminates the operational complexities DBAs had been tolerating for years. Join us for an interactive educational session on all things flash tailored for DBAs.
- Introduction to flash
- Key considerations in choosing flash architectures for OLTP, OLAP and Test/Dev workloads
|1:15 p.m. - 1:30 p.m.
|1:30 p.m. - 2:30 p.m.
Windows Server 2016 for the SQL Architect and Administrator
Speaker: John Savill
This session will dive into new features of Windows Server 2016 that database architects and administrators care about. This will include focus around huge changes to Failover Clustering related to domain requirements, new resiliency capabilities and ways to leverage the cloud for multi-site deployments. Changes to Hyper-V around resource management, security and more will be explored. Windows Server 2016 introduces enhancements to ReFS and also two huge new storage technologies enabling better use of direct-attached storage in clusters and also replicating data. Windows Server editions will be explored and their differences (yes, there are differences now) and also the shift in licensing.
|2:30 p.m. - 2:45 p.m.
|2:45 p.m. - 3:45 p.m.
SQL Server 2016 Upgrade Planning
Speaker: Jen Underwood
SQL Server 2016 is one of the largest SQL Server releases ever. In the latest offering, Microsoft has delivered many exciting new features across the relational database engine, integration and business intelligence solutions. Since SQL Server implementations and used features vary widely, no upgrade is the same. In this session, we will walk through the steps to assess your SQL Server environment and plan for a successful upgrade.
Session topics include:
- Upgrade Planning Assessment
- Unsupported Scenarios
- Pre-upgrade Tasks and Tools
- Upgrade Methods
- Post-upgrade Tasks