| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 08:30:00 | Armando Lacerda | Enterprise Database Administration Deployment | Unleashing Stretched Databases |
| 08:30:00 | Christian Wade | BI Platform Architecture, Development Administration | Modeling and Analytics Features Coming in Azure Analysis Services |
| 08:30:00 | Amit Banerjee | Application Database Development | Running applications on Azure Database for PostgreSQL/MySQL |
| 08:30:00 | Tim Gorman | Enterprise Database Administration Deployment | Accelerating Development and Testing Using Data Virtualization |
| 08:30:00 | Greg Larsen | Enterprise Database Administration Deployment | Blurring your Data with Dynamic Data Masking |
| 08:30:00 | Vern Rabe | Application Database Development | It's Time for a Change: Temporal Table Support in SQL Server 2016 |
| 08:30:00 | Rick Lowe | Enterprise Database Administration Deployment | Why should I care about ... the plan cache? |
| 09:45:00 | Christopher Sims | BI Platform Architecture, Development Administration | Getting graphy with CosmosDB Graph API with Gremlin |
| 09:45:00 | Armando Lacerda | Enterprise Database Administration Deployment | SQL Server Tricks for Storage and I/O Performance in the cloud |
| 09:45:00 | Kellyn Pot'Vin-Gorman | Enterprise Database Administration Deployment | DevOps for the DBA |
| 09:45:00 | John Sterrett | Cloud Application Development Deployment | An Introduction to Azure SQL Database for DBA's |
| 09:45:00 | Maxwell Myrick | Enterprise Database Administration Deployment | SQL Server Then and Now: Changing the State of Long-held Beliefs |
| 09:45:00 | Tim Gorman | Information Delivery | Reducing The Surface Area Of Risk in Data Security |
| 09:45:00 | Ben Miller | Application Database Development | Gathering Trending Data with PowerShell |
| 09:45:00 | Davide Mauri | Strategy and Architecture | Serverless Computing: Azure Functions, Logic Apps and Azure SQL and CosmosDB |
| 09:45:00 | Arnie Rowland | Information Delivery | Prevent Presentation Paralysis |
| 11:00:00 | Janis Griffin | Enterprise Database Administration Deployment | HiHo! HiHo! SQL Server on Linux, We Go! |
| 11:00:00 | Maxwell Myrick | Professional Development | The Consulting Dilemma: Is Inside or Outside of the Corporation the Right Fit for You? |
| 11:00:00 | Sourabh Agarwal | Enterprise Database Administration Deployment | Troubleshooting Always On Availability Group Failovers |
| 11:00:00 | Vern Rabe | Application Database Development | Proper DataType Usage=Guaranteed Better Performance and Accuracy |
| 11:00:00 | Ben Miller | Enterprise Database Administration Deployment | SQL Server Encryption |
| 11:00:00 | Russel Loski | Cloud Application Development Deployment | Querying Semistructured Data in Azure Data Lake with USQL |
| 11:00:00 | Scott Stauffer | Analytics and Visualization | Power BI for the Faint of Heart - Building an Interactive Report |
| 13:30:00 | Simon Cho | BI Platform Architecture, Development Administration | Build ETL efficiently (10x) with Minimal Logging |
| 13:30:00 | Kevin Feasel | Application Database Development | APPLY Yourself |
| 13:30:00 | Kalen Delaney | Application Database Development | A Look Inside SQL Server Distribution Statistics |
| 13:30:00 | Joe Chang | Enterprise Database Administration Deployment | Rethink Server Sizing |
| 13:30:00 | Russel Loski | BI Platform Architecture, Development Administration | Managing SSRS Reports using PowerShell and SSRS Web Services (60 minutes) |
| 13:30:00 | Davide Mauri | Application Database Development | Back to the Roots: When indexes are not enough |
| 13:30:00 | SQLSaturday Redmond | Other | Five Lighting sessions (click here to see them) |
| 13:30:00 | Paul Turley | BI Platform Architecture, Development Administration | The Nine Realms of Power BI |
| 15:15:00 | Andrew Cook | Cloud Application Development Deployment | Xamarin Data Syncing |
| 15:15:00 | Kevin Feasel | Enterprise Database Administration Deployment | Securing SQL Server |
| 15:15:00 | Kellyn Pot'Vin-Gorman | Application Database Development | Oracle vs. SQL Server- The War of the Indices |
| 15:15:00 | Arvind Shyamsundar | Enterprise Database Administration Deployment | Advanced SQL Server troubleshooting with SQLCallStackResolver |
| 15:15:00 | Kun Cheng | Enterprise Database Administration Deployment | SQLCAT: A customer story of Distributed AG strategy for Hybrid Architecture (Cloud agnostic) |
| 15:15:00 | Yana Berkovich | BI Platform Architecture, Development Administration | Enjoy Your Power Responsibly; Governance for PowerBI O365 |
| 15:15:00 | Michael Wall | Advanced Analysis Techniques | Introduction to Log Parser: Log What? |
| 15:15:00 | Sumit Kumar | Analytics and Visualization | Machine Learning Services in SQL Server 2017 |
Event Date: 10-02-2018 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 10-02-2018 - Session time: 08:30:00 - Track: BI Platform Architecture, Development Administration
Event Date: 10-02-2018 - Session time: 08:30:00 - Track: Application Database Development
In this session, we will show you how you can develop on Azure and deploy solutions without having to worry about high availability, disaster recovery, monitoring and other common operational and administration tasks!
Event Date: 10-02-2018 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment
Providing full databases for each developer or tester on each task of each project seems unrealistic, when each copy might require terabytes of storage, so for decades everyone has limited themselves to working in shared dev/test environments that are refreshed only every few months, where conflicts occur, quality suffers, and things move slowly.
Come learn why data virtualization is the solution to a problem everyone knows.
Good, fast, and cheap -- have all three with data virtualization. Be able to clone data quickly, and remove the biggest constraint to development and testing.
Event Date: 10-02-2018 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment
• Why you should mask your data • The 4 different masking functions • Security around Dynamic Data Masking • Benefits, drawbacks and programming considerations around Dynamic Data Masking • How to crack Dynamic Data Masking Greg’s talk will also contain a number Dynamic Data Masking demos. After attending this session, Attendee will gain a solid understanding of Dynamic Data Masking and the considerations they should take into account when rolling out this new feature.
Event Date: 10-02-2018 - Session time: 08:30:00 - Track: Application Database Development
In this session we’ll discuss how you can benefit from temporal support in your tables, how to implement temporal tables in SQL Server 2016, and how to write “time travel queries” using the new FOR SYSTEM_TIME clause in a SELECT statement to easily query historical information.
Event Date: 10-02-2018 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment
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-02-2018 - Session time: 09:45:00 - Track: BI Platform Architecture, Development Administration
Event Date: 10-02-2018 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment
Event Date: 10-02-2018 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment
This session discusses common database challenges and how they can be minimized or solved with newer DevOps practices without impacting the DBAs “safe zone”. We’ll discuss how to use these vital skills and motivate everyone towards solutions for more success in agile development environments. Development, testing, provisioning, patching, upgrading and managing will become easier with agile tools, virtualization and collaboration.
The take-aways from this session are to embrace DevOps basics with a “DBA twist” such as:
• Develop, Rinse, Repeat
• Test Until Your Five Year Old Can Do It
• Human Intervention Creates Human Error- Automate EVERYTHING.
Event Date: 10-02-2018 - Session time: 09:45:00 - Track: Cloud Application Development Deployment
Event Date: 10-02-2018 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment
Event Date: 10-02-2018 - Session time: 09:45:00 - Track: Information Delivery
When done properly, masked data is not noticeable unless you look closely. Masking data well might still be usable for analytic reporting and aggregation, yet utterly useless for revealing confidential data. Masking is important enough that sophisticated software packages have become available.
Come learn about the right way to mask non-production data in order to allow the organization to limit possible exposure only to production. Learn what techniques can be used, why, and what factors should be considered when deciding to secure confidential data.
Event Date: 10-02-2018 - Session time: 09:45:00 - Track: Application Database Development
Event Date: 10-02-2018 - Session time: 09:45:00 - Track: Strategy and Architecture
Azure offers many options in that space and two of them are particulary interesting: Azure Function and Azure Logic Apps. What are you needs? Hanlding data coming from a form? Invalidating cached data when a file changes? Responding to an external event like new customer added to your CRM? Everything can be done very easily and with the language of your choice, or even via an easier workflow-like approach, that doesn't even require you to write code. No matter which approach you decide to take, you'll need to store data somewhere. Depending on the scenario you may want to use the new multi-API CosmosDB or the well established Azure SQL. In this session we'll see how all the mentioned technologies can help us to have architectural choices to be more efficient and effective in our job.
Event Date: 10-02-2018 - Session time: 09:45:00 - Track: Information Delivery
Arnie will guide you with techniques to better understand and match the audience's expectations to your presentation goals. You will gain a better understanding of how to prepare your presentation, as well as how to get, and hold the audience's attention. And even how to be more relaxed with the inevitable critique from colleagues. Ramp up your career. Don't miss this session!
Event Date: 10-02-2018 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment
The participant will learn:
Event Date: 10-02-2018 - Session time: 11:00:00 - Track: Professional Development
Event Date: 10-02-2018 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 10-02-2018 - Session time: 11:00:00 - Track: Application Database Development
In this demo-heavy presentation I will show you the importance of choosing the proper data type; show you some guidelines in determining what an appropriate data type would be; and once chosen, give you some tools for its usage and management. I will demonstrate several performance and accuracy issues, along with their possible solutions, caused by either the assignment of inappropriate data types or improper usage of them. In addition I will cover several data type related functions, and point out caveats in their usage. I expect even advanced T-SQL developers and DBAs to walk away with a useful nugget or two.
Event Date: 10-02-2018 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 10-02-2018 - Session time: 11:00:00 - Track: Cloud Application Development Deployment
Event Date: 10-02-2018 - Session time: 11:00:00 - Track: Analytics and Visualization
Event Date: 10-02-2018 - Session time: 13:30:00 - Track: BI Platform Architecture, Development Administration
We will first analyze how data gets accessed from the source and how data gets updated or inserted to the target server: index access patterns in read operation and minimal logging in wring operation. I will introduce TF610 and cover its benefit for minimal logging even in full recovery mode.
Event Date: 10-02-2018 - Session time: 13:30:00 - Track: Application Database Development
Event Date: 10-02-2018 - Session time: 13:30:00 - Track: Application Database Development
Goals: • Explore the output of DBCC SHOW_STATISTICS • Describe when the density information is useful • Look at some problem scenarios for which the statistics can’t give good estimates • Understand why cardinality estimation involves more than just the statistics
Event Date: 10-02-2018 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 10-02-2018 - Session time: 13:30:00 - Track: BI Platform Architecture, Development Administration
Event Date: 10-02-2018 - Session time: 13:30:00 - Track: Application Database Development
Event Date: 10-02-2018 - Session time: 13:30:00 - Track: Other
This talk will explain how to select between temp tables and table variables.
Why is my DBA So Grumpy ... When I Use NOLOCK and Other Query Hints by Rick Lowe Ever hear NOLOCK is bad? Ever use one (or a hundred) anyway? Come see some of the bad things that can happen when NOLOCK hints are abused.
Change Data Capture in SQL Server, SSIS, Master Data Services by Swagatika Sarangi. In This session, you will see a demonstration of implementing Change Data Capture in SQL Server 2017 and Master Data Services web UI 2017.
A look at what is required to get an Alexa application up and running on Azure Functions where voice is the UI By Andrew Cook
15 speaking tips in 15 minutes by Arne Rowland.
Event Date: 10-02-2018 - Session time: 13:30:00 - Track: BI Platform Architecture, Development Administration
From simple desktop published reports, to enterprise-scale and highly-secured solutions; we will demystify all these options provide a roadmap to conquer the Nine Realms; from Midgard to Asgard, and from Desktop to Power BI Avenger.
Event Date: 10-02-2018 - Session time: 15:15:00 - Track: Cloud Application Development Deployment
Offline sync allows users to interact with a mobile application, viewing, adding, or modifying data, even where there isn't a network connection. Changes are stored in a local database, and once the device is online, the changes can be synced with the web service.
Event Date: 10-02-2018 - Session time: 15:15:00 - Track: Enterprise Database Administration Deployment
Event Date: 10-02-2018 - Session time: 15:15:00 - Track: Application Database Development
Based off this use case, enhanced builds of more advanced index features and discussions of the advantages, reasons for the introduction and how it's effected the direction of each product, the DBAs who are responsible for them and resources.
Takeaways are:
Event Date: 10-02-2018 - Session time: 15:15:00 - Track: Enterprise Database Administration Deployment
Event Date: 10-02-2018 - Session time: 15:15:00 - Track: Enterprise Database Administration Deployment
Event Date: 10-02-2018 - Session time: 15:15:00 - Track: BI Platform Architecture, Development Administration
I will be talking about why do we need governance in Power BI? Groups and PowerB, permission management, limitations and how it correlates with other O365 applications.
Event Date: 10-02-2018 - Session time: 15:15:00 - Track: Advanced Analysis Techniques
This presentation will start with some basic uses of Log Parser, explain some of the core features, demonstrate some of the challenges, and finally focus on using Log Parser to decrypt SSRS logs. These decrypted logs can then be used as a monitoring system.
As with most things, there are multiple ways to accomplish a task. Log Parser will be a welcome addition to your tool belt!
Event Date: 10-02-2018 - Session time: 15:15:00 - Track: Analytics and Visualization