| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:15:00 | Andy Leonard | BI Platform Architecture, Development Administration | Faster SSIS |
| 09:15:00 | Janis Griffin | Performance Tuning | What’s New in the 2017 Query Store |
| 09:15:00 | Randy Knight | Enterprise Database Administration Deployment | Locks, Blocks, and Deadlocks, Oh My! |
| 09:15:00 | Grant Fritchey | Cloud Application Development Deployment | Using Powershell to Manage Your Azure Databases |
| 09:15:00 | Ned Otter | Strategy and Architecture | Will my workload run faster with In-Memory OLTP? |
| 09:15:00 | Bob Rubocki | Cloud Application Development Deployment | Introducing SSIS in the Cloud! |
| 09:15:00 | Jim Miller | BI Platform Architecture, Development Administration | Populating a Data Warehouse with SSIS and Biml Patterns |
| 09:15:00 | Andy Mallon | Professional Development | How to get your Dream Job: Resume job hunting tips |
| 09:15:00 | Jerod Johnson | Cloud Infrastructure | SQL Integration Hubs - Bridge Cloud and On-Premise Data Connectivity |
| 10:35:00 | Ray Kim | Professional Development | I lost my job! Now what?!? A survival guide for the unemployed |
| 10:35:00 | George Walters | BI Platform Architecture, Development Administration | Power BI: Architecture and demo |
| 10:35:00 | Erik Darling | Performance Tuning | Query Optimization Explained in 15 Demos |
| 10:35:00 | Matt Gordon | Cloud Application Development Deployment | Data To Impress Those That Sign The Checks - Azure Logic Apps, Social Media, and Sentiment Analysis |
| 10:35:00 | Derik Hammer | Cloud Infrastructure | Introduction to Azure SQL Data Warehouse |
| 10:35:00 | Chris Seferlis | BI Platform Architecture, Development Administration | Destination Azure... building ETL workloads in the cloud! |
| 10:35:00 | John Miner | Strategy and Architecture | Standard and Custom Auditing of Azure SQL Database |
| 10:35:00 | Charles Hyman | SQL Server on Linux | SQL 2017 on LINUX |
| 10:35:00 | Martin Schoombee | BI Information Delivery | Power BI Development Best Practices |
| 10:35:00 | Kevin Goff | BI Platform Architecture, Development Administration | Implementing Data Warehouse Patterns with the Microsoft Data Plat |
| 10:35:00 | Marcelo Adade | Enterprise Database Administration Deployment | SQL Server and Oracle. Differences and Similarities for the DBA |
| 12:10:00 | Chris Lumnah | Enterprise Database Administration Deployment | Simplifying SQL Data Protection |
| 12:10:00 | Bryan Walsh | Cloud Infrastructure | #GetModern With Dell EMC |
| 13:10:00 | Steve Simon | Information Delivery | SQL Server Reporting Services 2017 on Steroids!! |
| 13:10:00 | Sepand Gojgini | Cloud Infrastructure | Data Landscape on Azure |
| 13:10:00 | Kevin Feasel | Application Database Development | Using Kafka for Real-Time Data Ingestion with .NET |
| 13:10:00 | Dan Clark | BI Information Delivery | Power Query Deep Dive |
| 13:10:00 | Hasan Savran | Strategy and Architecture | What's new in SQL Server 2017 |
| 13:10:00 | Grant Fritchey | Application Database Development | Extending DevOps To SQL Server |
| 13:10:00 | Marcelo Adade | SQL Server on Linux | Linux Administration for SQL SERVER DBAs |
| 13:10:00 | Jens Vestergaard | Analytics and Visualization | Power BI Basics - On Coke |
| 13:10:00 | Linda Zhang | Cloud Application Development Deployment | Azure Data Factory V2-ELT, ETL on Cloud |
| 13:10:00 | Simon Facer | Performance Tuning | Azure Data Warehouse Performance Tuning |
| 14:30:00 | Jim Donahoe | Cloud Application Development Deployment | Getting started with SQL Azure Database: What you need to know |
| 14:30:00 | Todd Chittenden | BI Platform Architecture, Development Administration | Row Level Security in Power BI |
| 14:30:00 | George Walters | Enterprise Database Administration Deployment | Organizational Security Compliance with SQL 2012 through 2016/2017 |
| 14:30:00 | Tim Gorman | Enterprise Database Administration Deployment | Accelerating Development and Testing Using Data Virtualization |
| 14:30:00 | Kevin Mackey | Application Database Development | Don't just code it—Generate It |
| 14:30:00 | Randy Knight | Professional Development | Soft skills for Geeks: Don't be a flat boxer |
| 14:30:00 | David Klee | SQL Server on Linux | Linux for the SQL Server DBA |
| 14:30:00 | Allan Hirt | Enterprise Database Administration Deployment | New Storage Paradigms for SQL Server Deployments |
| 14:30:00 | Russell Etts | Information Delivery | Statistics - How they're created and how to maintain them |
| 14:30:00 | Kevin Goff | Application Database Development | SSRS for Developers - attendees choose topics |
| 14:30:00 | Thomas Grohser | Cloud Infrastructure | Shaving off Microseconds |
| 15:50:00 | Ray Kim | Professional Development | So you want to be a SQL Saturday speaker? |
| 15:50:00 | Stephen Mokszycki | Enterprise Database Administration Deployment | DevOps Database administration. |
| 15:50:00 | Erik Darling | Performance Tuning | SQL Server 2017: This One Doesn't Suck |
| 15:50:00 | Brett Powell | BI Platform Architecture, Development Administration | DAX Query Use Cases |
| 15:50:00 | Kevin Feasel | Strategy and Architecture | Much Ado About Hadoop |
| 15:50:00 | Bhakthi Liyanage | Analytics and Visualization | Developing AI applications using CNTK Deep Learning |
| 15:50:00 | Zhen Zhang | Cloud Application Development Deployment | Deploy AlwaysOn on Google Cloud in Real Life |
| 15:50:00 | John Miner | Application Database Development | Using Azure blob storage for staging data |
| 15:50:00 | Warren Estes | Application Database Development | Making Life Easy With PowerShell |
| 15:50:00 | Ned Otter | Enterprise Database Administration Deployment | Table Partitioning 101 |
Event Date: 19-05-2018 - Session time: 09:15:00 - Track: BI Platform Architecture, Development Administration
We'll start by experimenting with SSIS design patterns to improve performance loading AdventureWorks data. We will implement different change detection patterns and compare execution performance for each. Then, we'll explain a Data Flow Task's bottleneck when loading binary large objects - or Blobs.
Finally, we'll demonstrate a design pattern that uses a Script Component in a Data Flow to boost load performance to MySql, whether on-premises or in the cloud.
Event Date: 19-05-2018 - Session time: 09:15:00 - Track: Performance Tuning
Event Date: 19-05-2018 - Session time: 09:15:00 - Track: Enterprise Database Administration Deployment
In this session targeted at the accidental or new DBA, we will walk through each of these items, what they are, what their causes are, which of them are normal behavior and which are not, and some common causes of deadlocks and excessive blocking.
Event Date: 19-05-2018 - Session time: 09:15:00 - Track: Cloud Application Development Deployment
Event Date: 19-05-2018 - Session time: 09:15:00 - Track: Strategy and Architecture
What are the use cases?
What are the tradeoffs?
We will lift the veil of confusion that surrounds this blazingly fast feature. By the end of the session, you will understand how In-Memory OLTP works and whether your workload is likely to see an increase in performance.
Event Date: 19-05-2018 - Session time: 09:15:00 - Track: Cloud Application Development Deployment
Come to this session to learn how to set up SSIS in Azure, migrate your existing SSIS packages, and execute packages from the cloud.
Event Date: 19-05-2018 - Session time: 09:15:00 - Track: BI Platform Architecture, Development Administration
The components used during this session:
Attend to see how Biml can revolutionize your SSIS development!
Event Date: 19-05-2018 - Session time: 09:15:00 - Track: Professional Development
In this session, we'll talk about how I got where I am, and how you can get to where you want to be. In addition to sharing my journey, I'll give some helpful tricks to getting your next job. You'll learn how to write a resume that gets you noticed, how to navigate interviews, and learn how to decide if a potential job and employer is right for you.
Bring your own resume to this session, and I'll provide you some personal (and private) feedback on what I would do to help improve your resume so you can land your Dream Job.
Event Date: 19-05-2018 - Session time: 09:15:00 - Track: Cloud Infrastructure
A Linked Server is a feature of Microsoft SQL Server that allows users to execute federated queries that combine data stored in SQL Server with other linked data sources, whether that is remote SQL Server instances or other databases with ODBC connectivity. Such connections are typically configured using the OLE DB Provider. With the CData SQL Broker, users can create a Linked Server based on any of the 100+ CData ODBC Drivers and see improved performance, smarter complex query management, and more flexible installation options as compared to using the OLE DB Provider. In this talk, we will discuss the use of Linked Servers, compare the capabilities of Linked Servers created using the OLE DB Provider and CData SQL Broker, and demonstrate creati
Event Date: 19-05-2018 - Session time: 10:35: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: 19-05-2018 - Session time: 10:35:00 - Track: BI Platform Architecture, Development Administration
Event Date: 19-05-2018 - Session time: 10:35:00 - Track: Performance Tuning
In this session, we'll look a little deeper into query optimization, and why SQL Server makes the choices it does.
This will be fast-paced, demo-heavy and slide-light.
Event Date: 19-05-2018 - Session time: 10:35:00 - Track: Cloud Application Development Deployment
Event Date: 19-05-2018 - Session time: 10:35:00 - Track: Cloud Infrastructure
Event Date: 19-05-2018 - Session time: 10:35:00 - Track: BI Platform Architecture, Development Administration
Event Date: 19-05-2018 - Session time: 10:35:00 - Track: Strategy and Architecture
The process of classifying a company into an industry segment has been around since the 1950’s. Wikipedia has listed several popular taxonomies that are in current use. Some industries are more regulated and have stricter compliance regulations than others. As a database administrator, how can we provide an audit trail to a compliance officer when a security issue has occurred?
Coverage:
1 – Azure Auditing using Blob Storage 2 - Table auditing using after triggers 3 - Using database triggers for object auditing 4 - Using custom stored procedures for fine grain audits
Event Date: 19-05-2018 - Session time: 10:35:00 - Track: SQL Server on Linux
Co-Existence between the Windows and Linux environments will be shown and explored.
Event Date: 19-05-2018 - Session time: 10:35:00 - Track: BI Information Delivery
In this session we will take a brief look at all of the considerations and best practices when developing Power BI models, reports and dashboards.
Event Date: 19-05-2018 - Session time: 10:35:00 - Track: BI Platform Architecture, Development Administration
Event Date: 19-05-2018 - Session time: 10:35:00 - Track: Enterprise Database Administration Deployment
Event Date: 19-05-2018 - Session time: 12:10:00 - Track: Enterprise Database Administration Deployment
Event Date: 19-05-2018 - Session time: 12:10:00 - Track: Cloud Infrastructure
Event Date: 19-05-2018 - Session time: 13:10:00 - Track: Information Delivery
In this hands on presentation we shall be looking some of the more challenging techniques of extracting our data from our Multidimensional and Tabular Models, in addition to our Data Mining Models. We shall be utilizing concepts of ‘Openquery()’ and ‘linked servers’ as a means to extract data, in addition to looking at the way that these two concepts can help us extract our data utilizing MDX, DMX and DAX expressions; AND YET maintain the flexibility and the ability to utilize all those wonderful techniques that may be done with T-SQL.
Event Date: 19-05-2018 - Session time: 13:10:00 - Track: Cloud Infrastructure
Event Date: 19-05-2018 - Session time: 13:10:00 - Track: Application Database Development
Event Date: 19-05-2018 - Session time: 13:10:00 - Track: BI Information Delivery
Event Date: 19-05-2018 - Session time: 13:10:00 - Track: Strategy and Architecture
Event Date: 19-05-2018 - Session time: 13:10:00 - Track: Application Database Development
Event Date: 19-05-2018 - Session time: 13:10:00 - Track: SQL Server on Linux
In this section let´s see how to perform the most common troubleshooting tasks, that we are already used to performing on Windows, now on Linux.
Event Date: 19-05-2018 - Session time: 13:10:00 - Track: Analytics and Visualization
In detail we will be looking at these topics: Straight up file (csv, xlsx) Scraping Web Page Data (html) Header/Footer issues Variable number of columns Multiple File Formats (think historical changes) Binding Multiple Imports into a single table Crude Error handling
Attending this session you'll learn the basics of Power BI Desktop, as well as some neat tricks to get through the more complex scenarios.
Additionally I will demonstrate how to deploy your home grown model into Azure Analysis Services
Event Date: 19-05-2018 - Session time: 13:10:00 - Track: Cloud Application Development Deployment
Event Date: 19-05-2018 - Session time: 13:10:00 - Track: Performance Tuning
How do you identify the queries that can be optimized? Can you identify how to optimize those queries? What are the base performance considerations for your MPP environments?
Event Date: 19-05-2018 - Session time: 14:30:00 - Track: Cloud Application Development Deployment
In this session, we will cover all the basic steps of getting your first Azure SQL Database instance spun up. We’ll cover common gotchas, like firewall settings and resource locks. We’ll also dive into some more advanced options with templates, allowing you to make your processes reproducible. By the end of this presentation, you’ll understand if Azure SQL Database is the right choice for you and your needs. You’ll understand how it can simplify management and allow you to scale easily. Finally, you’ll have the confidence to go and create your own instance with ease.
Event Date: 19-05-2018 - Session time: 14:30:00 - Track: BI Platform Architecture, Development Administration
Event Date: 19-05-2018 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 19-05-2018 - Session time: 14: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: 19-05-2018 - Session time: 14:30:00 - Track: Application Database Development
Table-driven applications allow one set of code to handle changing business needs. Metadata-driven code generation takes this a giant step further. If you can describe your code with an algorithm operating against a set of data, you can get a computer to produce the code.
Event Date: 19-05-2018 - Session time: 14:30:00 - Track: Professional Development
Event Date: 19-05-2018 - Session time: 14:30:00 - Track: SQL Server on Linux
This introductory session will help seasoned SQL Server DBAs understand the basics of Linux and how it differs from Windows, all the way from basic management to performance monitoring. By the end of the session, you will be able to launch your own Linux-based SQL Server instance on a production ready VM.
Event Date: 19-05-2018 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 19-05-2018 - Session time: 14:30:00 - Track: Information Delivery
Event Date: 19-05-2018 - Session time: 14:30:00 - Track: Application Database Development
Event Date: 19-05-2018 - Session time: 14:30:00 - Track: Cloud Infrastructure
Event Date: 19-05-2018 - Session time: 15:50:00 - Track: Professional Development
Event Date: 19-05-2018 - Session time: 15:50:00 - Track: Enterprise Database Administration Deployment
There will be a demo!
Event Date: 19-05-2018 - Session time: 15:50:00 - Track: Performance Tuning
Should you play it safe and move to 2016, or face the brave new world of 2017?
In this session, we'll look at some of the key new optimizer features in 2017 that will make your life as a performance tuner, or someone who wants to do a whole lot less performance tuning, much better.
Event Date: 19-05-2018 - Session time: 15:50:00 - Track: BI Platform Architecture, Development Administration
This session includes three 20 minute segments as follows: A) DAX Query Structure and Functions B) Embedding DAX Queries into DAX Measures and C) Leveraging DAX Queries in SSRS Reports. Attendees will learn the essential concepts and functions of DAX as a query language, powerful DAX features including variables and set-based functions, and how to utilize DAX Studio to develop and test DAX queries.
Each segment of this session will be supported by multiple example DAX queries and all queries will be made available for download following the event.
Event Date: 19-05-2018 - Session time: 15:50:00 - Track: Strategy and Architecture
Event Date: 19-05-2018 - Session time: 15:50:00 - Track: Analytics and Visualization
The Microsoft Cognitive Toolkit (CNTK) is a free, easy-to-use, open-source, commercial-grade toolkit that trains deep learning algorithms to learn like the human brain. This session is meant to explain high level concepts of AI, deep learning, and neural networks using CNTK at a level that can be understood by most non-practitioners.
Event Date: 19-05-2018 - Session time: 15:50:00 - Track: Cloud Application Development Deployment
Event Date: 19-05-2018 - Session time: 15:50:00 - Track: Application Database Development
Most companies are faced with the ever-growing big data problem. How can IT professionals help business lines gather and process data from various sources?
There have been two schools of thought when dealing with big data.
Schema on write is represented by the traditional relational database. Raw data is ingested by an extract, transform and load (ETL) process. The data is stored in tables that enforce integrity and allow for quick retrieval. Only a small portion of the total data owned by the company resides in the database.
Schema on read is represented by technologies such as Hadoop or PolyBase that assumed that data integrity was applied during the generation of the text files. The actual definition of the table is applied during the read operation. All the data owned by the company can reside in simple storage.
Coverage:
1 - Saving files to blob storage. 2 - How to bulk insert data into Azure DB 3 - Using PolyBase to load an Azure DW 4 - Azure Automation
Event Date: 19-05-2018 - Session time: 15:50: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: 19-05-2018 - Session time: 15:50:00 - Track: Enterprise Database Administration Deployment
In this entry-level session, we'll discuss the advantages and disadvantages of deploying this often misunderstood feature. Is it designed to improve performance, or to ease administration?
Only one way to find out!