| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:00:00 | Steve Simon | BI Platform Architecture, Development Administration | Efficient and Effective coding of Stored Procedures |
| 09:00:00 | Todd Chittenden | BI Platform Architecture, Development Administration | Row Level Security in Power BI |
| 09:00:00 | George Walters | Enterprise Database Administration Deployment | Organizational Security Compliance with SQL 2012 through 2016 |
| 09:00:00 | Andy Galbraith | Enterprise Database Administration Deployment | Does it Hurt When I Do This? Performing a SQL Server Health Check |
| 09:00:00 | Taiob Ali | Cloud Application Development Deployment | How to migrate a SQL database to Microsoft Azure SQL V12 |
| 09:00:00 | Geraldine Caszo | Application Database Development | Optimizing Queries |
| 10:15:00 | James Serra | BI Platform Architecture, Development Administration | Choosing technologies for a big data solution in the cloud |
| 10:15:00 | Edward Pollack | Enterprise Database Administration Deployment | Tracking Index Usage Like a Pro! |
| 10:15:00 | Sunil Kadimdiwan | Analytics and Visualization | Power up SSRS 2017 with Power BI and other new enhancements |
| 10:15:00 | Mike Walsh | Cloud Application Development Deployment | Azure SQL Databases: A Guided Tour |
| 10:15:00 | Kevin Goff | Application Database Development | In-Memory Capabilities in SQL Server 2016 |
| 10:15:00 | Andy Roberts | Analytics and Visualization | SQL Server 2017 R and Python Integration - how do I do it and why would I want to?? |
| 11:30:00 | Ray Kim | Professional Development | Whacha just say? Talking technology to non-technical people |
| 11:30:00 | Beth Wolfset | Enterprise Database Administration Deployment | Inventory your data with Azure Data Catalog |
| 11:30:00 | Taiob Ali | Enterprise Database Administration Deployment | Think like the Cardinality Estimator |
| 11:30:00 | Mike Walsh | Application Database Development | You Can Tune Your Own Code - Back to Basics Tips for Developers |
| 11:30:00 | Andy Roberts | Analytics and Visualization | Add Power BI to any application! |
| 11:30:00 | John Miner | Application Database Development | Effective Data Warehouse Storage Patterns |
| 13:30:00 | James Serra | Cloud Application Development Deployment | Should I move my database to the cloud? |
| 13:30:00 | Deborah Melkin | Application Database Development | Back to the Basics: T-SQL 101 |
| 13:30:00 | Paresh Motiwala | Professional Development | Getting to and Nailing Your Interviews |
| 13:30:00 | Edward Pollack | Application Database Development | Mapping Schema and Recursively Managing Data |
| 13:30:00 | George Walters | BI Platform Architecture, Development Administration | Power BI: Architecture and demo |
| 13:30:00 | Warren Estes | Application Database Development | Making Life Easy With PowerShell |
| 14:45:00 | Ray Kim | Professional Development | I lost my job! Now what?!? A survival guide for the unemployed |
| 14:45:00 | Matthew Anderson | BI Platform Architecture, Development Administration | PowerShell Cubed: Backing up and Restoring Analysis Services Cubes with PowerShell |
| 14:45:00 | Beth Wolfset | Enterprise Database Administration Deployment | Master Your Data using MDS |
| 14:45:00 | Jack Corbett | BI Platform Architecture, Development Administration | Dealing with Data Quality Issues in an SSIS Data Flow |
| 14:45:00 | Bill Wilder | Cloud Application Development Deployment | Azure SQL Database – not just a cloud version of SQL Server |
Event Date: 09-12-2017 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration
In this hands-on presentation, we shall be looking at best practices with regards to creating and tuning stored procedures. We shall also be discussing parameter sniffing and other gotcha’s that affect us in our daily lives.
Event Date: 09-12-2017 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration
Event Date: 09-12-2017 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 09-12-2017 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment
Come learn how to use freely available tools from multiple layers of the SQL Server stack to check your servers for basic issues like missing backups and CheckDB as well as for more advanced issues like page life expectancy problems and improper indexing. If you are responsible in any way for a Microsoft SQL Server (DBA, Windows Admin, even a Developer) you will see value in this session!
Event Date: 09-12-2017 - Session time: 09:00:00 - Track: Cloud Application Development Deployment
Event Date: 09-12-2017 - Session time: 09:00:00 - Track: Application Database Development
Event Date: 09-12-2017 - Session time: 10:15:00 - Track: BI Platform Architecture, Development Administration
Event Date: 09-12-2017 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment
Knowing which indexes are used most (or least) often can help us determine which are no longer needed, or which could use some tweaking. Keeping track of indexes that are missing and could greatly help performance allows us to solve related performance problems before they become disasters.
In this session, we will discuss how SQL Server tracks index utilization and the ways that we can persist this data for future use. Once we have a collection process in place, we can easily report on it and make smart decisions using months of collected data.
Event Date: 09-12-2017 - Session time: 10:15:00 - Track: Analytics and Visualization
Will review and demonstrate the new Mobile Reports, KPIs and Paginated reports. The new Mobile Report publisher produces stunning dashboards that can be viewed on any device (iOS, Android and Windows). Other enhancements include, show/hide download menu, report comments, custom placement of parameters, custom branding your SSRS portal's with your choice of colors and logo.
Will top off by demonstrating recent technical releases that support hosting Power BI reports (.PBIX) in Power BI Report Server, which include custom visuals.
Event Date: 09-12-2017 - Session time: 10:15:00 - Track: Cloud Application Development Deployment
The goal is to take the mystery out, to show the capabilities and get you thinking about what going to the cloud could look like and what it can do for you and your company. I believe the future belongs to those who have this knowledge and know where to apply it.
This will be nearly PowerPoint free and we’ll log into my Azure Portal and build out an environment from scratch and learn as we go. We’ll migrate data from an “on-premises” database into our SQL DB and we’ll query it. You’ll leave with an understanding of the capabilities, some resource links outlining what we did and hopefully some curiosity to see what else is up there in the cloud as you start exploring.
Event Date: 09-12-2017 - Session time: 10:15:00 - Track: Application Database Development
Event Date: 09-12-2017 - Session time: 10:15:00 - Track: Analytics and Visualization
Event Date: 09-12-2017 - Session time: 11:30:00 - Track: Professional Development
Event Date: 09-12-2017 - Session time: 11:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 09-12-2017 - Session time: 11:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 09-12-2017 - Session time: 11:30:00 - Track: Application Database Development
Plus as a DBA, Mike can give a few pointers in working with your organization's own "Dr. No" along the way. Rough Agenda: • Review of Best Practices • Indexing/Table Structure High Level Overview • Will your queries use the index? • Query Plans don’t have to be scary • IO Statistics, Profiler • Put Them Together (Use the tools before you say, "Done!" • Interaction with the DBA (How to be a partner in performance with the DB).
This is a gentle introduction of the basics that will help you write better code.
Event Date: 09-12-2017 - Session time: 11:30:00 - Track: Analytics and Visualization
The Power BI Embedded services allows you to host interactive visualizations inside of your website or application. This session will walk through the process of embedding a Power BI Report into an application!
Event Date: 09-12-2017 - Session time: 11:30:00 - Track: Application Database Development
Many companies start off with a simple data mart for reporting. As the company grows, users become dependent on the data mart for monitoring and making decisions on Key Performance Indicators (KPI).
Unexpected information growth in your data mart may lead to a performance impacted reporting system. In short, your users will be lining up at your cube for their daily reports.
How do you reduce the size of your data mart and speed up data retrieval?
This presentation will review the following techniques to fix your woes.
Coverage:
1 – What is horizontal partitioning? 2 – Database sharding for daily information. 3 – Working with files and file groups. 3 – Partitioned views for performance. 4 – Table and Index partitions. 5 – Row Data Compression. 6 – Page Data Compression. 7 – Programming a sliding window. 8 – What is different in Azure SQL database?
Event Date: 09-12-2017 - Session time: 13:30:00 - Track: Cloud Application Development Deployment
Event Date: 09-12-2017 - Session time: 13:30:00 - Track: Application Database Development
This session is designed for the junior DBA or developer who is looking for a better foundation of the basics. The goal is to feel more confident with how to write queries and understand how to build on that knowledge.
Event Date: 09-12-2017 - Session time: 13:30:00 - Track: Professional Development
In this session I'll share my and other people's real stories and the techniques about keeping abreast the job market and finding new opportunities.
We'll also talk about normal mistakes that people make when they are cozy in a job. But, what do we do once we get that rare opportunity to interview.
We must take care of :
Keep going at it. Never stop looking!!!
Event Date: 09-12-2017 - Session time: 13:30:00 - Track: Application Database Development
We will build from the ground up a script that will allow you to gain complete insight into the structure of a relational database. Not only will this provide a complete map of relationships given a specific SELECT statement, but the TSQL can then be used to generate DELETE and UPDATE statements given that information. Optimization techniques will be applied to this script to ensure that it executes efficiently, even on a large database.
Can gaining insight into relational structure and design be educational and fun? YES!!!
Event Date: 09-12-2017 - Session time: 13:30:00 - Track: BI Platform Architecture, Development Administration
Event Date: 09-12-2017 - Session time: 13:30:00 - Track: Application Database Development
In this demo heavy session I will go over how a DBA can use PowerShell to make life easier when dealing with common, and not so common, issues and tasks. I will show you real world examples of how PowerShell and SQL Server work together, like peanut butter and jelly, to help you solve problems. We'll go on a magical journey from brief overview and simple scripts to advanced functions and modules. Leveraging the power of PowerShell we'll iterate over instances, audit servers, migrate instances, manipulate SSRS subscriptions and much more.
Event Date: 09-12-2017 - Session time: 14:45:00 - Track: Professional Development
Unemployment is a scary situation. You're dealing with emotions and uncertainty. You don't know if you'll be out of work for days, weeks, or months.
Fortunately, unemployment is survivable. In this session, I'll share my own experiences (and perhaps we'll talk about some of yours) with unemployment, and how I managed to get through the tough times. We'll discuss emotional impact, the job hunt, and things you can do to get yourself through this tough time. Hopefully, you'll land on your feet once again before long!
Event Date: 09-12-2017 - Session time: 14:45:00 - Track: BI Platform Architecture, Development Administration
Far too often sessions cover using PowerShell to backup and restore SQL Server databases, but not backup and restores of AS cubes. This is NOT a talk about what AS is or how to build a new cube. This is a talk about AS management from the perspective of a DBA. We’ll talk about different ways to perform a backup and ways to perform a restore with PowerShell.
Event Date: 09-12-2017 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment
Event Date: 09-12-2017 - Session time: 14:45:00 - Track: BI Platform Architecture, Development Administration
Event Date: 09-12-2017 - Session time: 14:45:00 - Track: Cloud Application Development Deployment
By the end of this session you should have a feel for how your SQL Server skills transfer to Azure SQL Database, which aspects of management control Microsoft takes on, and how to use the toolbox of goodies for encryption, threat detection, DR, and global scale.