| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 08:30:00 | Mohan Kumar | Application Database Development | What, When and Why, a particular database technology (relational or non-relational) to use |
| 08:30:00 | Ike Ellis | BI Information Delivery | Application Life Cycle Management with SQL Server |
| 08:30:00 | Steve Jones | Application Database Development | Continuous Integration for Databases |
| 08:30:00 | Kirby Repko | Enterprise Database Administration Deployment | Azure SQL Database Overview |
| 08:30:00 | Rick Lowe | Application Database Development | Weird Stuff I Saw While ... Working With Heaps |
| 08:30:00 | Rushabh Mehta | Cloud Application Development Deployment | Database code management with VS 2017 and RedGate |
| 08:30:00 | Harriet Farmer | Professional Development | It's Not Magic-Make It Happen. Professional Development: Resume Writing and Interviewing Skills |
| 09:45:00 | Julie Koesmarno | Analytics and Visualization | Boost your Analytics with Machine Learning for SQL Nerds |
| 09:45:00 | Brodie Brickey | BI Information Delivery | Data Driven Subscription Reports with SSRS Standard Edition |
| 09:45:00 | Peter Kral | Application Database Development | JSON and the Astronauts |
| 09:45:00 | Andrew Nakamura | Enterprise Database Administration Deployment | From Zero to Hero: The New Powershell DBA |
| 09:45:00 | Rick Lowe | Application Database Development | Why should I care about ... the plan cache? |
| 09:45:00 | Kim Schmidt | Application Database Development | Amazon Aurora - A New Dawn in the World of Relational Database Engines |
| 09:45:00 | Oula Maijala | Other | SQL Governor - New Era in SQL Server Capacity Optimization |
| 11:00:00 | Jose Manuel Jurado Diaz | Enterprise Database Administration Deployment | SQL SERVER - Next station Azure |
| 11:00:00 | Jeff Prom | BI Platform Architecture, Development Administration | Mastering Master Data Services |
| 11:00:00 | David Taylor | Analytics and Visualization | Pimp my Spreadsheet; Power BI brings numbers to life |
| 11:00:00 | Steve Jones | Enterprise Database Administration Deployment | Bringing DevOps to the Database |
| 11:00:00 | Ali Razeghi | Strategy and Architecture | Upgrades Rollbacks for SQL Server |
| 11:00:00 | Kalen Delaney | Application Database Development | Are You Optimistic About Concurrency? |
| 11:00:00 | James McGillivray | BI Information Delivery | Who needs numbers? Enhance your data models and dashboards with Non-Numeric measures |
| 12:00:00 | James McGillivray | Information Delivery | Windowing Functions: Shedding some light |
| 12:00:00 | Steve Rezhener | Professional Development | What does it take to run both SQL Malibu Local User Group and SQL Saturday in LA (30 minutes) |
| 13:00:00 | Niran Even-Chen | Enterprise Database Administration Deployment | Architecting virtual SQL server for performance |
| 13:00:00 | Rob Girard | Enterprise Database Administration Deployment | Deep Dive on pNUMA vNUMA – Save Your Virtual SQL from Certain DoomA! |
| 13:00:00 | Neil Weicher | Other | Transparent Data Encryption (TDE) – NetLib Security Encryptionizer vs. SQL Server |
| 13:00:00 | Michael Patterson | Analytics and Visualization | Enterprise Analytics on the Microsoft BI Platform - Pyramid BI Office |
| 13:00:00 | Susan Poer | Other | The Profisee MDM Advantage, going beyond MDS |
| 13:00:00 | Marsha Pierce | Strategy and Architecture | How To Talk To Your Storage Admin |
| 13:00:00 | Matt Henderson | Strategy and Architecture | Proving hardware bottlenecks architecting for performance |
| 14:15:00 | Benjamin Nevarez | Application Database Development | Query Processing in In-Memory OLTP (Hekaton) |
| 14:15:00 | Virginia Mushkatblat | Other | Security Warriors: Always Encrypted and Dynamic Data Masking |
| 14:15:00 | Kevin Ngo | Enterprise Database Administration Deployment | Azure SQL Data Warehouse - The next generation of data warehousing |
| 14:15:00 | Anantharamakrishnan Jayaram | Enterprise Database Administration Deployment | SQL Server Transactional Replication and how to recover from failure |
| 14:15:00 | Ali Razeghi | Cloud Application Development Deployment | SQL Server AGs and Clustering In The Cloud |
| 14:15:00 | Ted Stathakis | BI Information Delivery | Introduction to SQL Server Reporting Services |
| 14:15:00 | Steve Rezhener | Professional Development | Women in Technology |
| 15:30:00 | Armando Lacerda | Enterprise Database Administration Deployment | Why are you still taking backups? |
| 15:30:00 | Vazi Okhandiar | Analytics and Visualization | Building a Power BI Dashboard in an Hour |
| 15:30:00 | Brodie Brickey | Application Database Development | Basic Work-Flow with SQL Server Standard |
| 15:30:00 | Peter Kral | Enterprise Database Administration Deployment | SSIS Project Deployment: The T-SQL Way |
| 15:30:00 | Konstantin Melamud | BI Platform Architecture, Development Administration | Optimizing your data warehouse for OLAP Processing |
| 15:30:00 | Paul Stanton | Enterprise Database Administration Deployment | SQL Server Containers and Clones |
| 15:30:00 | Vlad Vlasceanu | Enterprise Database Administration Deployment | Using SQL Server on Amazon Web Services |
| 16:45:00 | Armando Lacerda | Enterprise Database Administration Deployment | Unleashing Stretched Databases |
| 16:45:00 | Benjamin Nevarez | Application Database Development | Understanding Parameter Sniffing |
| 16:45:00 | Phil Robinson | BI Information Delivery | Data Wrangling for Reporting Analytics |
| 16:45:00 | James McGillivray | Professional Development | Why you should be BI curious |
| 16:45:00 | Kevin Kline | Application Database Development | The Optimizer Secrets of 860X |
| 16:45:00 | Allan Hirt | Enterprise Database Administration Deployment | The SQL Server v.Next Availability Story on Linux |
| 16:45:00 | Mickey Stuewe | Application Database Development | Changing Your Habits to Improve the Performance of Your T-SQL |
Event Date: 10-06-2017 - Session time: 08:30:00 - Track: Application Database Development
Event Date: 10-06-2017 - Session time: 08:30:00 - Track: BI Information Delivery
Event Date: 10-06-2017 - Session time: 08:30:00 - Track: Application Database Development
Event Date: 10-06-2017 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 10-06-2017 - Session time: 08:30:00 - Track: Application Database Development
Event Date: 10-06-2017 - Session time: 08:30:00 - Track: Cloud Application Development Deployment
This session will cover my experiences, tips and tricks with managing a Cloud SaaS solution and we will look at how Visual Studio 2017 and the RedGate family of tools provide tremendous value and higher confidence with our product releases.
Event Date: 10-06-2017 - Session time: 08:30:00 - Track: Professional Development
Your career is like a game of chess. It requires using multiple skills, simultaneously, while continually improving in all areas.
All with one goal - to 'win' the current challenge and move on to the next milestone. This session will look at where you are in your Career Path and focus on three key areas that keep you moving toward the next milestone. Bring your resume with you (thumb drive or hard copy) for review and edit. We will: - Take a look at your resume, revising content and format - Work on interviewing technique - Chart your current Career Path
Event Date: 10-06-2017 - Session time: 09:45:00 - Track: Analytics and Visualization
This session will provide a gentle and fun introduction to SQL Server R Services for SQL Nerds. We will walk through pragmatic examples of using R through demos, to illustrate Machine Learning in boosting your Data Analysis capabilities. The goal of this session is to provide quick tips and tricks for attendees to get started on SQL Server R Services, either for fun or for work.
Event Date: 10-06-2017 - Session time: 09:45:00 - Track: BI Information Delivery
Event Date: 10-06-2017 - Session time: 09:45:00 - Track: Application Database Development
Prerequisites: You should have experience writing queries in T-SQL. No previous knowledge of JSON is needed.
Goals: Learn about JSON, and its basic data types Discover how SQL Server 2016 can handle JSON data Be amazed at the cool people NASA sends into space!
Event Date: 10-06-2017 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment
In this session, you'll learn about the Powershell community that is creating awesome solutions to ease your life as a DBA. This session is aimed at DBAs from zero to heroes who want to see the new Powershell DBA in action. Come see brand new techniques and demos and become the hero that others will envy.
Come and join me for a momentous session of PowerShell and SQL, full of demos and useful solutions that you will be able to take back to your workplace. This will improve your knowledge and skills, show you how the modern DBA will work and future proof your career by becoming a new Powershell DBA.
Event Date: 10-06-2017 - Session time: 09:45:00 - Track: Application Database Development
Perfect for those who are relatively new to performance tuning concerns, or advanced DBAs trying to figure out how to have a similar conversation with their less experienced peers, or developers who are curious as to why their DBAs drink in the morning (allegedly). This is not a deep dive into the cache, it really is primarily a session exploring why these DMOs are worth slogging through.
Event Date: 10-06-2017 - Session time: 09:45:00 - Track: Application Database Development
Aurora has 5x the throughput comparable to enterprise commercial databases at 1/10th the cost. It’s built on AWS for the cloud, it's self-managing self-healing. You can perform 6M inserts 30M selects per minute, scaling out further via Read Replicas. Storage automatically grows storage up to 64 TB, and more.
Come hear about the hottest new AWS RDS database, its unique architecture and features, and learn why it's known as an "RDS Game Changer"!
Event Date: 10-06-2017 - Session time: 09:45:00 - Track: Other
Event Date: 10-06-2017 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment
We will cover:
Event Date: 10-06-2017 - Session time: 11:00:00 - Track: BI Platform Architecture, Development Administration
In this presentation we will cover MDS from start to finish including installation, creating models/entities, working with data, using the Excel add-in, security, hierarchies, views, versions, and business rules. After this presentation, you will have a good understanding of what master data management is, what MDS does, how to use it, and how to get started with your own MDS project.
Event Date: 10-06-2017 - Session time: 11:00:00 - Track: Analytics and Visualization
Each of the 3 key steps are introduced and demonstrated.
Event Date: 10-06-2017 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 10-06-2017 - Session time: 11:00:00 - Track: Strategy and Architecture
We will utilize setting up and testing mirroring to move the data from 2008 to 2014. We will migrate the IP of the old 2008 cluster to the new 2014 cluster. This way no clients change their connection strings as DNS is not an option in this environment. Trans Replication will be set for rollback to the 2008 cluster in case we need to after going live. We will use the 'no init' option as we do not have time to create a snapshot and will protect the data during the upgrade to ensure no writes are conducted.
Scripts and a background on transaction replication will be provided to show the end user how to start testing this process in their environment. Pre-cutover and Post-cutover tasks will also be discussed.
Event Date: 10-06-2017 - Session time: 11:00:00 - Track: Application Database Development
Event Date: 10-06-2017 - Session time: 11:00:00 - Track: BI Information Delivery
Enhance the functionality of your SSAS Tabular and PowerBI output, by understanding HOW-, WHY- and WHEN to leverage the power of DAX to create non-numeric measures, and see how you can quickly help business answer a number of different questions, by thinking differently about where measures start and end.
Event Date: 10-06-2017 - Session time: 12:00:00 - Track: Information Delivery
Quickly learn how Windowing functions can help you spice up your queries, and solve complex problems quickly and with consummate ease. From running totals, to lag- and lead type queries, Windowing functions will help you deliver high quality information in the quickest time possible.
As an added bonus, all the examples in the talk are on Beatles chart hits. So Come Together, as you Twist and Shout your way to the Windowing Functions Revolution!
Event Date: 10-06-2017 - Session time: 12:00:00 - Track: Professional Development
Event Date: 10-06-2017 - Session time: 13:00:00 - Track: Enterprise Database Administration Deployment
Still, many IT architects and DBA's are hesitant of virtualizing their SQL workloads, they are worried about performance, scale, availability and support for what is usually considered their most critical applications. In this session we will review the guidance for successfully virtualizing critical SQL databases, we will cover the best practices, real world customer experience and what to watch out for when virtualizing the most critical SQL databases. The session is delivered by the author of the official SQL server on VMware best practices guide.
Event Date: 10-06-2017 - Session time: 13:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 10-06-2017 - Session time: 13:00:00 - Track: Other
Enterprise Manager (EEM) takes Encryptionizer for SQL Server to the next level, allowing you to easily administer from one central location while providing powerful centralized key management. An easy to deploy solution to protect, manage and defend your data while enabling the growing areas of compliance, EEM enables organizations of all sizes to configure and control their encryption needs across the enterprise – no matter where they reside geographically across physical, virtual or clouD. The administrator will be able to easily control key management to meet the new PCI compliance standards. From EEM you can encrypt databases and secure SQL Server instances.
Event Date: 10-06-2017 - Session time: 13:00:00 - Track: Analytics and Visualization
Event Date: 10-06-2017 - Session time: 13:00:00 - Track: Other
Profisee is a gold Microsoft partner that specializes in helping clients achieve one view of their business by ensuring the accuracy of customer, product, and reference data.
Come learn how achieving a single consistent set of master and reference data leads to more revenue, campaign accuracy, and a competitive advantage.
Event Date: 10-06-2017 - Session time: 13:00:00 - Track: Strategy and Architecture
Event Date: 10-06-2017 - Session time: 13:00:00 - Track: Strategy and Architecture
Event Date: 10-06-2017 - Session time: 14:15:00 - Track: Application Database Development
Event Date: 10-06-2017 - Session time: 14:15:00 - Track: Other
Event Date: 10-06-2017 - Session time: 14:15:00 - Track: Enterprise Database Administration Deployment
Event Date: 10-06-2017 - Session time: 14:15:00 - Track: Enterprise Database Administration Deployment
Advantages and disadvantages Replication Architecture How to recover from replication failure/disaster Best Pratices
Event Date: 10-06-2017 - Session time: 14:15:00 - Track: Cloud Application Development Deployment
iSCSI will be created using a 'Storage Gateway' on AWS and another solution such as DataKeeper for Microsoft Azure.
Ultimately these environments will allow you to quickly spin up machines and begin to look at State Configuration solutions such as 'Microsoft DSC' or for example, utilizing the SALT stack.
Event Date: 10-06-2017 - Session time: 14:15:00 - Track: BI Information Delivery
Event Date: 10-06-2017 - Session time: 14:15:00 - Track: Professional Development
Event Date: 10-06-2017 - Session time: 15:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 10-06-2017 - Session time: 15:30:00 - Track: Analytics and Visualization
Event Date: 10-06-2017 - Session time: 15:30:00 - Track: Application Database Development
This session will be demo intensive, focusing on how to use SSIS, SSRS, and SQL Server standard edition to stitch together a process that emulates a proper workflow.
Event Date: 10-06-2017 - Session time: 15:30:00 - Track: Enterprise Database Administration Deployment
Prerequisites: You should have previous experience with SQL Server Integration Services (SSIS) package deployment and/or development.
Goals: Learn about the SSISDB database and catalog objects See how to use T-SQL to deploy SSIS projects and packages Discover the new features of SSIS delivered with SQL Server 2016
Event Date: 10-06-2017 - Session time: 15:30:00 - Track: BI Platform Architecture, Development Administration
Event Date: 10-06-2017 - Session time: 15:30:00 - Track: Enterprise Database Administration Deployment
Microsoft is emphasizing the use of containers for development and test on SQL Server 2017, and new solutions from Red Gate and Windocks add support for containers and SQL Server database fast cloning, for the full range of the SQL Server family. We’ll explore use of Docker based tooling for delivery of container environments, and their pros and cons. We’ll also look at SQL Server cloning, and how clones enable Dev and Test teams to work on large database environments for containers as well as existing SQL Server instances.
Event Date: 10-06-2017 - Session time: 15:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 10-06-2017 - Session time: 16:45:00 - Track: Enterprise Database Administration Deployment
Event Date: 10-06-2017 - Session time: 16:45:00 - Track: Application Database Development
Event Date: 10-06-2017 - Session time: 16:45:00 - Track: BI Information Delivery
Event Date: 10-06-2017 - Session time: 16:45:00 - Track: Professional Development
In this beginner level session, learn the basics of Business Intelligence, the stages of BI maturity and get introduced to the Microsoft BI Stack, starting from the humble roots of Reporting Services, through to the incredible power of Interactive Dashboards in Power BI.
Whether you're looking for a different career option, or you're just interested in broadening your knowledge base, come and experience the wonders of being (in) BI!
Note: This session comes packaged with a series of double entendres and other innuendos.
Event Date: 10-06-2017 - Session time: 16:45:00 - Track: Application Database Development
Event Date: 10-06-2017 - Session time: 16:45:00 - Track: Enterprise Database Administration Deployment
Event Date: 10-06-2017 - Session time: 16:45:00 - Track: Application Database Development