| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:00:00 | Rick Lowe | Application Database Development | Keeping Your DBA Happy. Why Some Practices Drive Admins Crazy. |
| 09:00:00 | Joshuha Owen | BI Platform Architecture, Development Administration | The Modern Enterprise Data Warehouse in Azure |
| 09:00:00 | Brian Larson | Analytics and Visualization | Powering Up with Power BI (Pre-Con) |
| 09:00:00 | Ed Leighton-Dick | Enterprise Database Administration Deployment | Data Security for the Cloud |
| 09:00:00 | Riley Major | General | Welcome to SQLSaturday #796 (Theather) |
| 09:30:00 | Rick Bielawski | Enterprise Database Administration Deployment | Implementing security inside SQL Server |
| 09:30:00 | Jared Zagelbaum | Cloud Application Development Deployment | Custom Activities in Azure Data Factory |
| 09:30:00 | Andy Galbraith | Enterprise Database Administration Deployment | Getting Started with Extended Events |
| 09:30:00 | Dan English | Analytics and Visualization | Power BI: Dashboard in an Hour Walk-Through |
| 09:30:00 | Ross McNeely | BI Platform Architecture, Development Administration | Power BI Premium Use Cases |
| 09:30:00 | Mark Davis | BI Platform Architecture, Development Administration | Power BI Embedding – Ecolab’s Story |
| 09:30:00 | Eric Zierdt | Application Database Development | I deleted 1 billion records, what happened next will shock you! |
| 09:30:00 | Michael Fal | Enterprise Database Administration Deployment | Database Backup and Restore Best Practices |
| 10:45:00 | Steve Hughes | BI Platform Architecture, Development Administration | Consumption Based Architecture and MSBI |
| 10:45:00 | Peter Kral | Enterprise Database Administration Deployment | SSIS Project Deployment: The T-SQL Way |
| 10:45:00 | Rick Lowe | Enterprise Database Administration Deployment | Why should I care about ... the plan cache? |
| 10:45:00 | Brian Larson | Analytics and Visualization | Hyper-Interactivity in Power BI and SSRS Reports |
| 10:45:00 | Bill Preachuk | BI Platform Architecture, Development Administration | You are more than a DBA: Expanding your career into Big Data |
| 10:45:00 | Fru N | Application Database Development | Agile Data warehouse |
| 10:45:00 | Viktor Gamov | Application Database Development | Processing Streaming Data with KSQL |
| 10:45:00 | Michael Fal | Enterprise Database Administration Deployment | Simplifying SQL Data Protection |
| 13:00:00 | Jake Manske | Application Database Development | Locking and its effects on queries and maintenance tasks |
| 13:00:00 | Phil Ekins | Enterprise Database Administration Deployment | SQL Sprawl - How to get a handle on your Infrastructure |
| 13:00:00 | Ben Thul | Enterprise Database Administration Deployment | Intermediate Security in SQL Server |
| 13:00:00 | John Eisbrener | Professional Development | Got the Consulting Itch? The Ins and Outs of being a Contractor for a Living |
| 13:00:00 | Arthur Daniels III | Enterprise Database Administration Deployment | Plan Cache performance tuning |
| 13:00:00 | Matt Stenzel | Application Database Development | Data Engineering - The Hottest New Job |
| 13:00:00 | George Bryant | BI Platform Architecture, Development Administration | Little and Large - Cubes to Scale |
| 14:15:00 | Marsha Pierce | Enterprise Database Administration Deployment | Virtualizing SQL Server |
| 14:15:00 | John Wells | Application Database Development | Fundamentals That Will Improve Your Query Performance! |
| 14:15:00 | Tim Plas | Cloud Application Development Deployment | DB Options on Azure – Which One Should I Use? |
| 14:15:00 | Nem Schlecht | Application Database Development | Maximizing SQL Server Management Studio for Developers and DBAs |
| 14:15:00 | Alex Barbeau | BI Platform Architecture, Development Administration | Building Better Tabular Models |
| 14:15:00 | Eleanor Stahura | BI Platform Architecture, Development Administration | Designing SSIS Packages for Performance |
| 14:15:00 | Rowland Gosling | Application Database Development | If I Only Had a Brain! |
| 15:25:00 | Doug Bernhardt | General | Dell EMC SQL Server Solutions |
| 15:55:00 | Anton Rozenson | BI Platform Architecture, Development Administration | Understanding your ETL and SQL performance with a Power BI dashboard |
| 15:55:00 | Fabiano Amorim | Enterprise Database Administration Deployment | I'm a DBA. Now what? |
| 15:55:00 | Joe Obbish | Application Database Development | Decoding the Cardinality Estimator to Speed Up Queries |
| 15:55:00 | Joshuha Owen | Cloud Application Development Deployment | Let's build a data app with Azure Functions! |
| 15:55:00 | Joshuha Owen | Cloud Application Development Deployment | Azure Data Factory V2: The cloud SSIS we have been waiting for? |
| 15:55:00 | Drew Skwiers-Koballa | Application Database Development | Azure Data Studio Extension Development |
| 15:55:00 | Ed Leighton-Dick | Enterprise Database Administration Deployment | Three Steps to Lasting Encryption |
| 15:55:00 | Greg Sharrow | BI Platform Architecture, Development Administration | How to navigate through the cornucopia of power BI architecture options |
| 15:55:00 | Chris Kramer | Enterprise Database Administration Deployment | SQL Server 2017 on Containers |
| 17:05:00 | Cecil Spivey | General | Closing Remarks Raffle |
Event Date: 06-10-2018 - Session time: 09:00:00 - Track: Application Database Development
SQL Server supports two table types - heaps and tables with clustered indexes. We almost always create a unique clustered index on tables ... but why? Since heaps are part of the product they must have a use case but what is it? Any what is the secret sauce in clustered indexes that makes them so popular?
There is a substantial body of best practice information in the SQL Server community. Many of these practices are routinely ignored in some organizations, presumably because the consequences of not following aren't always clear. Come join this full day session for in-depth explanations of why we give some of the advice that we do.
Query hints, indexing, LINQ to Entities, common table expressions, looping vs set-based operations and more
Event Date: 06-10-2018 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration
In this pre-con we will be covering architecture patterns from Microsoft and that we are seeing in the industry on how to move to Azure for you data warehousing needs. We'll cover the various offerings of Azure including storage, data ingestion and orchestration, databases , NoSQL, and streaming.
We'll also cover how to analyze all of this data with tools and services like Power BI and Databricks. Finally, we'll cover strategies on how you get there; Lift-and-shift, hybrid, or brand new implementations will all be discussed.
By the end of this pre-con you should have a thorough understanding of the architecting a modern enterprise data warehouse in Azure including getting those services to work together and how to use that data effectively!
Event Date: 06-10-2018 - Session time: 09:00:00 - Track: Analytics and Visualization
• Data collection using the Query Editor and the M language • Data modeling • Measures using basic and intermediate DAX formulas • Visualizations with an emphasis on user interactivity including the latest interactive and drill through features • Deployment and management in a secure, shared environment
Along the way we will look at tips and tricks as well as best practices for each of these facets of Power BI. Participants will leave with an understanding of the full range of capabilities of Power BI along with the confidence to use Power BI to create and securely share meaningful analytics.
Event Date: 06-10-2018 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment
Security becomes paramount when you move your data to the cloud - after all, it is a much more public resource than the corporate network you’re accustomed to using. Depending on the platform you choose, the vendor may take care of part of the security needs, but they don’t handle all of them. So what, exactly, is your responsibility? And where do you start?
Microsoft MVP Ed Leighton-Dick will answer these questions and more in this full-day workshop on how to best secure your data in the cloud. Topics will include the most common vulnerabilities your data will face on a cloud platform; differences between the current offerings on the major cloud platforms; and the implementation of technical necessities like authentication, encryption, connection security, and monitoring.
Event Date: 06-10-2018 - Session time: 09:00:00 - Track: General
Event Date: 06-10-2018 - Session time: 09:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 06-10-2018 - Session time: 09:30:00 - Track: Cloud Application Development Deployment
Event Date: 06-10-2018 - Session time: 09:30:00 - Track: Enterprise Database Administration Deployment
Extended Events started out in SQL Server 2008 with no user interface and only a few voices in the community documenting the features as they found them. Since then, it has blossomed into a full feature of SQL Server and an amazingly low-impact replacement for Profiler and Trace.
Come learn how to get started - the basics of sessions, events, actions, targets, packages, and more. We will look at some base scenarios where Extended Events can be very useful as well as considering a few gotchas along the way. You may never go back to Profiler again!
Event Date: 06-10-2018 - Session time: 09:30:00 - Track: Analytics and Visualization
This session is perfect for anyone that is new to Power BI and is looking for an overview and a demonstration of what the toolset can do and provide for reporting and analytics.
Event Date: 06-10-2018 - Session time: 09:30:00 - Track: BI Platform Architecture, Development Administration
Event Date: 06-10-2018 - Session time: 09:30:00 - Track: BI Platform Architecture, Development Administration
Event Date: 06-10-2018 - Session time: 09:30:00 - Track: Application Database Development
Event Date: 06-10-2018 - Session time: 09:30:00 - Track: Enterprise Database Administration Deployment
[Sponsored by Rubrik]
Event Date: 06-10-2018 - Session time: 10:45:00 - Track: BI Platform Architecture, Development Administration
Event Date: 06-10-2018 - Session time: 10:45:00 - Track: Enterprise Database Administration Deployment
Prerequisites: You should have previous experience with SQL Server Integration Services (SSIS) package deployment and/or development.
Event Date: 06-10-2018 - Session time: 10:45: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 often seem so frazzled. 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: 06-10-2018 - Session time: 10:45:00 - Track: Analytics and Visualization
Event Date: 06-10-2018 - Session time: 10:45:00 - Track: BI Platform Architecture, Development Administration
The IT Landscape continues to advance at a furious pace and shows no signs of stopping. What's a DBA/SQL Developer to do?
In this session we will identify the big picture IT changes going on around us distill them down to their core concepts technologies. We will discuss how these changes affect our current careers job roles. We will present learning plans to address current gaps and branch out into the new. The end goal: to gain an understanding that will allow us to embrace these changes to the advancement of our careers.
Event Date: 06-10-2018 - Session time: 10:45:00 - Track: Application Database Development
We'd cover CDC on SQL server, full load, incremental loads, and more.
Event Date: 06-10-2018 - Session time: 10:45:00 - Track: Application Database Development
Kafka now offers KSQL, a declarative, SQL-like stream processing language that lets you define powerful stream-processing applications easily. What once took some moderately sophisticated Java code can now be done at the command line with a familiar and eminently approachable syntax. Come to this talk for an overview of KSQL with live coding on live streaming data.
Event Date: 06-10-2018 - Session time: 10:45:00 - Track: Enterprise Database Administration Deployment
[Sponsored by Rubrik]
Event Date: 06-10-2018 - Session time: 13:00:00 - Track: Application Database Development
In this session, we will discuss lock modes in SQL Server and how they impact your queries. We will show how different isolation levels change which locks are taken and for how long they are held. We will look at ways to avoid unnecessary blocking for maintenance tasks like index rebuilds. Assertions will be backed up with demo-based evidence.
After this session, you will have the understanding you need to start writing application code and maintenance jobs suitable for concurrent systems by anticipating blocking issues due to locking.
Event Date: 06-10-2018 - Session time: 13:00:00 - Track: Enterprise Database Administration Deployment
Determine what’s being installed without (or without) your knowledge.
How are they being utilized resource wise and how are they licensed.
Then determine what can be combined, right sized or retired and does your existing licensing make sense.
This will provide a road-map to make a case for virtualization (if you’re not there yet) or just to get a handle on your SQL Sprawl.
Event Date: 06-10-2018 - Session time: 13:00:00 - Track: Enterprise Database Administration Deployment
In this session, we'll talk about ways to service requests like these without having to give away the world. We’ll start with authentication and authorization, for context.
We will then go into different methods to augment the "normal" means of obtaining permissions that will allow you to help your customers while at the same time not needing to be overly permissive.
In the course of this presentation, you'll learn about:
* Module signing
* Permission chaining
* Impersonation
and more!
Event Date: 06-10-2018 - Session time: 13:00:00 - Track: Professional Development
Event Date: 06-10-2018 - Session time: 13:00:00 - Track: Enterprise Database Administration Deployment
Just like gardening, keeping a database healthy requires pruning. Techniques to manage, remove, and improve performance in the Plan Cache will be shown. The Query Store gives us power tools for this work, but it's not the entire solution.
Event Date: 06-10-2018 - Session time: 13:00:00 - Track: Application Database Development
Event Date: 06-10-2018 - Session time: 13:00:00 - Track: BI Platform Architecture, Development Administration
Event Date: 06-10-2018 - Session time: 14:15:00 - Track: Enterprise Database Administration Deployment
Event Date: 06-10-2018 - Session time: 14:15:00 - Track: Application Database Development
Event Date: 06-10-2018 - Session time: 14:15:00 - Track: Cloud Application Development Deployment
Event Date: 06-10-2018 - Session time: 14:15:00 - Track: Application Database Development
Event Date: 06-10-2018 - Session time: 14:15:00 - Track: BI Platform Architecture, Development Administration
In this demo heavy session we'll cover how to create a new Tabular model with a solid foundation to support happy users. In addition to step by step instructions and best practices on loading data, formatting your columns and measures, clean model design, and making the DBA's life easier when it's time to deploy, we will cover the two most important properties you can set to save yourself a headache.
Event Date: 06-10-2018 - Session time: 14:15:00 - Track: BI Platform Architecture, Development Administration
Event Date: 06-10-2018 - Session time: 14:15:00 - Track: Application Database Development
Event Date: 06-10-2018 - Session time: 15:25:00 - Track: General
Event Date: 06-10-2018 - Session time: 15:55:00 - Track: BI Platform Architecture, Development Administration
Event Date: 06-10-2018 - Session time: 15:55:00 - Track: Enterprise Database Administration Deployment
Event Date: 06-10-2018 - Session time: 15:55:00 - Track: Application Database Development
Event Date: 06-10-2018 - Session time: 15:55:00 - Track: Cloud Application Development Deployment
In this session, we will walk through the architecture and components of creating an Azure-facing video processing application that can scan videos for text and provide that information in CSV files for analysis. We will cover the architecture, data flow, and Azure technology pieces including Azure Functions, Blob Storage, Storage Queues, Azure Data Lake Storage Analytics, and Power BI.
Event Date: 06-10-2018 - Session time: 15:55:00 - Track: Cloud Application Development Deployment
Event Date: 06-10-2018 - Session time: 15:55:00 - Track: Application Database Development
Event Date: 06-10-2018 - Session time: 15:55:00 - Track: Enterprise Database Administration Deployment
To keep your encryption at full strength, you need to add three practices to your regular maintenance schedule. First, backup your keys frequently and securely to ensure you can always retrieve the data you’ve encrypted. Second, rotate your keys regularly to limit your exposure due to a lost or compromised key. Third, add an encryption key management solution (like Azure Key Vault) to make managing large numbers of keys easier or to enable someone else to manage the keys. In this session, we’ll discuss how you can implement each of these practices in your own environment.
Event Date: 06-10-2018 - Session time: 15:55:00 - Track: BI Platform Architecture, Development Administration
Event Date: 06-10-2018 - Session time: 15:55:00 - Track: Enterprise Database Administration Deployment
In this session, we take a look at the current state of container technology, how it applies to SQL Server 2017, and what changes you can expect to see in the future of managing your SQL Server installations upgrades.
Event Date: 06-10-2018 - Session time: 17:05:00 - Track: General