| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 08:30:00 | Thane Schaffer | Application Database Development | Introduction to SQL |
| 08:30:00 | Susantha Bathige | Enterprise Database Administration Deployment | Statistics and New Cardinality Estimator Model |
| 08:30:00 | Meagan Longoria | BI Platform Architecture, Development Administration | Up Close and Personal with the Tabular SSAS DMVs |
| 08:30:00 | Warren Sifre | Advanced Analysis Techniques | Introduction to Azure Machine Learning |
| 08:30:00 | Steve Jones | Professional Development | Branding Yourself for a Dream Job |
| 08:30:00 | Rick Lowe | Application Database Development | Weird Stuff I Saw While ... Working With Heaps |
| 09:45:00 | William E Pearson III | BI Platform Architecture, Development Administration | Seeking the Perfect Hybrid: On-Prem Data with Reports and Dashboards in Power BI |
| 09:45:00 | Tracy Boggiano | Strategy and Architecture | Disaster Recovery Where to Begin |
| 09:45:00 | Kellyn Pot'Vin-Gorman | Enterprise Database Administration Deployment | The Next Frontier- Opportunities When Migrating to the Cloud with Virtualization |
| 09:45:00 | Trayce Jordan | Enterprise Database Administration Deployment | Finding root cause for unexplained Availability Group failover |
| 09:45:00 | Brian Hansen | Enterprise Database Administration Deployment | Visualize Your Transaction Log |
| 09:45:00 | Scot Reagin | Information Delivery | Data Integration: the neglected hero of your information environment |
| 11:00:00 | Marcus Hopfinger | Enterprise Database Administration Deployment | My Top 10 Favorite Replication Tricks |
| 11:00:00 | Steve Jones | Strategy and Architecture | Bringing DevOps to the Database |
| 11:00:00 | Christopher Wolff | Enterprise Database Administration Deployment | Continuous Deployments using SSDT |
| 11:00:00 | Reeves Smith | Analytics and Visualization | Introduction to Data Science with R |
| 11:00:00 | Julia Renz | Analytics and Visualization | Even I Can Power BI! |
| 11:00:00 | Gabriel Villa | Cloud Application Development Deployment | Getting Started with Databases on Amazon Web Services |
| 12:15:00 | Craig Allen | Enterprise Database Administration Deployment | SQL Performance Best Practices |
| 13:30:00 | Cher Fox | Other | Test Automation: Agile Enablement for DW and BI Teams |
| 13:30:00 | Tim Gorman | Enterprise Database Administration Deployment | Accelerating DevOps and TDM Using Data Virtualization |
| 13:30:00 | Patrick Geselbracht | BI Information Delivery | Power BI on Azure Analysis Services |
| 13:30:00 | Jeff Renz | Application Database Development | Introduction To Azure DocumentDB |
| 13:30:00 | Paul Nielsen | Professional Development | So you want to launch a software company |
| 13:30:00 | Carlos Bossy | BI Platform Architecture, Development Administration | Business Intelligence in the Cloud |
| 14:45:00 | Steve Wake | BI Information Delivery | Mobile, Paginated, KPIs, and Power BI, Oh My! SSRS 2016 Reporting |
| 14:45:00 | Adam Koehler | Enterprise Database Administration Deployment | Isolation Levels – Understanding Transaction Temper Tantrums |
| 14:45:00 | David Brown | Advanced Analysis Techniques | How to Use Analytics (and Data Science) to Get a Promotion |
| 14:45:00 | Michelle Haarhues | Professional Development | On the Doorsteps - Women in Technology |
| 14:45:00 | Michelle Poolet | Strategy and Architecture | Get Into the Goldilocks Zone: Managing SQL Transaction Log VLF Growth |
| 14:45:00 | Michael Fal | Cloud Application Development Deployment | Intro to Azure SQL Databases |
Event Date: 25-03-2017 - Session time: 08:30:00 - Track: Application Database Development
Event Date: 25-03-2017 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 25-03-2017 - Session time: 08:30:00 - Track: BI Platform Architecture, Development Administration
Event Date: 25-03-2017 - Session time: 08:30:00 - Track: Advanced Analysis Techniques
Event Date: 25-03-2017 - Session time: 08:30:00 - Track: Professional Development
Event Date: 25-03-2017 - Session time: 08:30:00 - Track: Application Database Development
Event Date: 25-03-2017 - Session time: 09:45:00 - Track: BI Platform Architecture, Development Administration
In this session, Data Platform (SQL Server / BI) MVP and SSAS Maestro Bill Pearson explores the construction of organizational BI solutions, wedding the "traditional" solutions with the reporting and analysis power of Power BI. We'll focus upon the components of a "traditional" solution, up to the semantic model (with SQL Server Analysis Services as an example), and then explore paths to the implementation of an end-to-end enterprise solution that uses Power BI as the presentation layer. This session applies, in most respects, to Analysis Services 2012 and above.
Event Date: 25-03-2017 - Session time: 09:45:00 - Track: Strategy and Architecture
Event Date: 25-03-2017 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment
Event Date: 25-03-2017 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment
Event Date: 25-03-2017 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment
Event Date: 25-03-2017 - Session time: 09:45:00 - Track: Information Delivery
Enterprise Data Warehouses and Marts are often the only stores that provide single point access to data sourced from multiple systems - but these stores can be expensive and complicated to build and maintain and tend to lag behind business need.
Data Lakes offer the promise of fast inexpensive data acquisition but without specialized tools lack the structure that makes their data accessible and useful to the business.
A managed Data Integration platform can provide both efficient data management across systems and a shared, single point, store of data sourced from all participating systems. A Data Integration platform solution is not technology or tool specific and can provide immediate and continuing value.
Event Date: 25-03-2017 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 25-03-2017 - Session time: 11:00:00 - Track: Strategy and Architecture
Event Date: 25-03-2017 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 25-03-2017 - Session time: 11:00:00 - Track: Analytics and Visualization
Discovering useful patterns and insight in the enterprise has become more challenging without a new set of tools. Big data has taken center stage in the data warehouse community and with data sets so large and complex that traditional data processing applications are becoming inadequate. Learn about the R language that is at the center of most advanced analytics conversations. R is an open source statistical language that is rapidly gaining popularity due to a robust set of machine learning functionality and a never-ending set of R packages that are used to increase functionality of the core R language. In this session, we will introduce the R language and review some of the features of the highly interactive environment that are available with just the base install. We will also review some of the upcoming features in the SQL Server 2016.
Event Date: 25-03-2017 - Session time: 11:00:00 - Track: Analytics and Visualization
Event Date: 25-03-2017 - Session time: 11:00:00 - Track: Cloud Application Development Deployment
Event Date: 25-03-2017 - Session time: 12:15:00 - Track: Enterprise Database Administration Deployment
Event Date: 25-03-2017 - Session time: 13:30:00 - Track: Other
Event Date: 25-03-2017 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment
Test Data Management (TDM) is the optimization of the process of software quality, ensuring that applications properly work according to their specifications.
Constraining both DevOps and TDM is data, which has grown enormous and complex. "Storage is cheap" is not merely a lie, but beside the point. It takes a lot of time to push terabytes around from place to place, and time is expensive.
Provisioning a full environment for each developer or tester on each task of each project seems unrealistic, when each might require terabytes of storage. So, everyone is limited to working in a small shared dev/test environments that are refreshed only every few months, and code quality suffers, and the pace of delivery fails to live up to requirements.
Data virtualization is the solution. Come learn.
Event Date: 25-03-2017 - Session time: 13:30:00 - Track: BI Information Delivery
We will discuss modeling security patterns in Analysis Services in conjunction with Power BI. We will also demonstrate a direct query connection of On Premise and Azure Analysis Services cubes to Power BI. Additionally, we will highlight leveraging Power BI functionality including reports, dashboards, and QA of an Analysis Services data set.
Event Date: 25-03-2017 - Session time: 13:30:00 - Track: Application Database Development
In this session I will demonstrate how to create a DocumentDB instance in Azure, how to work with JSON documents, create Ad hoc queries with familiar SQL syntax, create application logic as stored procedures, triggers and user defined functions (UDFs) using standard JavaScript. Finally, I will compare performance and feature difference between SQL Server 2016 and Azure DocumentDB.
Event Date: 25-03-2017 - Session time: 13:30:00 - Track: Professional Development
Event Date: 25-03-2017 - Session time: 13:30:00 - Track: BI Platform Architecture, Development Administration
Event Date: 25-03-2017 - Session time: 14:45:00 - Track: BI Information Delivery
We will also look at the new SSRS Web Portal (replacement for Report Manager) and how the development environment will change as well. Sometime will also be spent on how to support all of these report types and the impact it will have on IT. If you have been curious about what has changed with SSRS in SQL Server 2016 and you want to be ahead of the curve, this is the session for you!
Event Date: 25-03-2017 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment
Event Date: 25-03-2017 - Session time: 14:45:00 - Track: Advanced Analysis Techniques
Welcome to my world. I've worked for years as a consultant, and I started in this situation, but I began making a living helping folks crawl their way out. Along the way, I got my Microsoft MVP, and I've helped many organizations make millions of more dollars through my consulting efforts. I'd like to help you, too.
Event Date: 25-03-2017 - Session time: 14:45:00 - Track: Professional Development
In this session, we will discuss the effects of trends in industry such as college graduation of women in technology fields, and women currently in tech or in positions of leadership. And, even important to us, how the contributions of women in PASS affect our community. This will be an open discussion with input from the audience encouraged.
Event Date: 25-03-2017 - Session time: 14:45:00 - Track: Strategy and Architecture
Let's start with "what's a VLF and why do I care?" and move forward into learning how to shrink VLFs (a temporary solution) and how to resize SQL Server transaction log files (a more permanent solution) for greater server stability, better performance during server startup, backups, and restores, and to minimize storage space requirements.
The SQL Server transaction log is a critical piece of SQL Server's ability to ensure that data is maintained exactly as the user input or modified the data. The transaction log must, at times, grow in size in order to do its job. When a transaction log’s growth gets out of control (too large, too many segments), then SQL Server’s ability to perform as it should is negatively impacted. Too-large transaction log files cause longer database start up, backup and restore times, and will require more storage space on disk. Learn how to control VLF gro
Event Date: 25-03-2017 - Session time: 14:45:00 - Track: Cloud Application Development Deployment