| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 08:30:00 | Jennifer McCown | Enterprise Database Administration, Deployment Monitoring | Beginning Admin: The Care and Feeding of SQL Server |
| 08:30:00 | Azhagappan Arunachalam | Application Database Development | SQL Graph |
| 08:30:00 | Eugene Meidinger | BI Information Delivery | An (Advanced) Introduction to DAX |
| 08:30:00 | Tracy Boggiano | Enterprise Database Administration, Deployment Monitoring | Intro to Query Store |
| 08:30:00 | Rick Heiges | Azure / Cloud / Big Data | Cloudy with a Chance of Data |
| 08:30:00 | Allen Shepard | Professional Development | Everything's working - now what? DBA growth: Advanced Basics |
| 08:30:00 | Carlos L Chacon | BI Platform Architecture, Development Administration | Power BI Deployed |
| 09:40:00 | Louis Davidson | Application Database Development | Characteristics of a Great Relational Database |
| 09:40:00 | Jamie Wick | Enterprise Database Administration, Deployment Monitoring | Automated SQL Server installation and configuration using PowerShell JSON |
| 09:40:00 | Michael Wharton | Beginners Level | Getting Started with PowerShell Basics for SQL Server Administration |
| 09:40:00 | Andrew Kelly | Internals Performance | The Art of War with Bad Code |
| 09:40:00 | Cameron Snapp | Azure / Cloud / Big Data | Azure Data Engineering |
| 09:40:00 | Rick Lowe | Cloud Application Development Deployment | SQL Server on Amazon Web Services - Elastic Compute Cloud vs Relational Database Service? |
| 09:40:00 | Marsha Pierce | Virtualization | SQL Server with Docker Containers |
| 10:50:00 | Justin Randall | Application Database Development | Improve Performance and Save Space with SQL Server Data Compression |
| 10:50:00 | Jennifer McCown | Application Database Development | Beginning T-SQL |
| 10:50:00 | Tracy Boggiano | Enterprise Database Administration, Deployment Monitoring | Using Open Source Products to Collect Performance Metrics |
| 10:50:00 | Rick Heiges | Professional Development | An Examination of Today's Certifications |
| 10:50:00 | Jason Brimhall | Internals Performance | Monitoring with Extended Events |
| 10:50:00 | Chris Bell | Enterprise Database Administration, Deployment Monitoring | Using Modular Scripts to Perform SQL Compliance Audits in Seconds |
| 10:50:00 | Bill Lund | Professional Development | Professional Networking |
| 12:30:00 | Justin Randall | Beginners Level | Break Through Your Data Performance Barriers with SentryOne |
| 12:30:00 | Carlos L Chacon | Beginners Level | Implementing Power BI |
| 12:30:00 | Greg Samuels | Beginners Level | CIO Panel Discussion |
| 13:20:00 | Louis Davidson | Application Database Development | Database Design Fundamentals |
| 13:20:00 | Jamie Wick | Enterprise Database Administration, Deployment Monitoring | SQL Restore: Optimizing Your Data Recovery |
| 13:20:00 | Thomas Norman | Application Database Development | Encrypting Data within Sql Server |
| 13:20:00 | Eugene Meidinger | Enterprise Database Administration, Deployment Monitoring | What's New with SQL Server 2019? |
| 13:20:00 | Andrew Kelly | Enterprise Database Administration, Deployment Monitoring | Practical Monitoring of TempDB |
| 13:20:00 | Chris Bell | Enterprise Database Administration, Deployment Monitoring | Build a White/Blacklist Bouncer. Who Gets into Your SQL Club? |
| 13:20:00 | Sean McCown | Application Database Development | The Master Stored Procedure Workshop: Part 1 |
| 14:30:00 | George Walkey | Enterprise Database Administration, Deployment Monitoring | Using Powershell to Document SQL Server |
| 14:30:00 | Justin Randall | Beginners Level | SQL Server Performance Fundamentals: Building and Maintaining a Solid Foundation |
| 14:30:00 | Angela Henry | Application Database Development | Profiling Your Data |
| 14:30:00 | Mark Hudson | BI Information Delivery | From R to Machine Learning Services and Beyond |
| 14:30:00 | Jason Brimhall | Application Database Development | The Anatomy of Select |
| 14:30:00 | Monica Rathbun | Internals Performance | Performance Tuning, Getting the Biggest Bang for Your Buck |
| 14:30:00 | Sean McCown | Application Database Development | The Master Stored Procedure Workshop: Part 2 |
Event Date: 30-03-2019 - Session time: 08:30:00 - Track: Enterprise Database Administration, Deployment Monitoring
Being a database administrator is a big job, but we can cover the basics in one session!
Event Date: 30-03-2019 - Session time: 08:30:00 - Track: Application Database Development
Event Date: 30-03-2019 - Session time: 08:30:00 - Track: BI Information Delivery
Event Date: 30-03-2019 - Session time: 08:30:00 - Track: Enterprise Database Administration, Deployment Monitoring
Then in 2017, Microsoft added wait stats per query plan and Automatic Tuning capabilities. Allowing DBAs more tools to troubleshoot fires with and a way to automatically resolve issues.
In this session, we will walk through the features of Query Store, so you can understand how to use them in SQL Server 2016 and 2017.
Event Date: 30-03-2019 - Session time: 08:30:00 - Track: Azure / Cloud / Big Data
Event Date: 30-03-2019 - Session time: 08:30:00 - Track: Professional Development
Event Date: 30-03-2019 - Session time: 08:30:00 - Track: BI Platform Architecture, Development Administration
Event Date: 30-03-2019 - Session time: 09:40:00 - Track: Application Database Development
Event Date: 30-03-2019 - Session time: 09:40:00 - Track: Enterprise Database Administration, Deployment Monitoring
Event Date: 30-03-2019 - Session time: 09:40:00 - Track: Beginners Level
Event Date: 30-03-2019 - Session time: 09:40:00 - Track: Internals Performance
• Learn how to properly capture the data used to identify the poor performers • Learn how to analyze data in order to pinpoint the top offenders • Understand how correlate this data to your environment
Event Date: 30-03-2019 - Session time: 09:40:00 - Track: Azure / Cloud / Big Data
Event Date: 30-03-2019 - Session time: 09:40:00 - Track: Cloud Application Development Deployment
Event Date: 30-03-2019 - Session time: 09:40:00 - Track: Virtualization
Event Date: 30-03-2019 - Session time: 10:50:00 - Track: Application Database Development
In this presentation you will learn how data compression works, how to determine when data compression is the right option, and other planning and implementation considerations.
Event Date: 30-03-2019 - Session time: 10:50:00 - Track: Application Database Development
Event Date: 30-03-2019 - Session time: 10:50:00 - Track: Enterprise Database Administration, Deployment Monitoring
In this session, we will discuss sp_whoisactive and Query Store. Then we will be combining three open source tools – Telegraf, InfluxDB, and Grafana – into an inexpensive system that collects performance metrics you can use to troubleshoot issues and answer important questions about your SQL Server instances, including your Linux SQL Server instances. We will learn what metrics to collect, how to use the tools to collect performance metrics and then we’ll put it all together in an interactive dashboard for easy visualization.
Attendees will see how easy it is to get good performance data and visualize in an interactive way and combine with other tools to troubleshoot issue
Event Date: 30-03-2019 - Session time: 10:50:00 - Track: Professional Development
Event Date: 30-03-2019 - Session time: 10:50:00 - Track: Internals Performance
SQL Server has progressed over time to give better and better information to the DBA. Much of this information can be used in a home grown solution to monitor SQL Server. With the constant increase in surface area from Extended Events, the power to build a home grown solution becomes more and more feasible while being limited only by the imagination of the enterprising DBA (or developer or data professional).
You will be exposed to advanced troubleshooting techniques as we work through complex issues that are made easier through the use of XE. Take advantage of this opportunity to dive into the world of Extended Events and learn how you can make best use of this tool in your SQL 2008+ environment.
Event Date: 30-03-2019 - Session time: 10:50:00 - Track: Enterprise Database Administration, Deployment Monitoring
In this session, we will go over some scripts that are used for compliance audits that make it easy to collect the information required. Even when there are multiple SQL Servers, these scripts and processes can quickly and easily identify where to focus efforts to ensure compliance. Through heavy demonstration and discussion, you will leave with a better equipped to understand and obtain compliance within your SQL Server environment.
Event Date: 30-03-2019 - Session time: 10:50:00 - Track: Professional Development
The session would cover tips and recommendations of how to network effectively, make introductions to new contacts, asking the right questions and proper follow up. It would also cover best practices on networking at user group meetings and SQL Saturdays. Demonstrate how tools such as Twitter and LinkedIn can help increase a personal network and make connections with decision makers.
Event Date: 30-03-2019 - Session time: 12:30:00 - Track: Beginners Level
Event Date: 30-03-2019 - Session time: 12:30:00 - Track: Beginners Level
Event Date: 30-03-2019 - Session time: 12:30:00 - Track: Beginners Level
Event Date: 30-03-2019 - Session time: 13:20:00 - Track: Application Database Development
Event Date: 30-03-2019 - Session time: 13:20:00 - Track: Enterprise Database Administration, Deployment Monitoring
How long will the restoration process take? Can it run faster?
In this session, we’ll answer these questions by looking at the Disaster Recovery process and the options available for performance tuning database restores.
Event Date: 30-03-2019 - Session time: 13:20:00 - Track: Application Database Development
In this session, we will review each option to encrypt data within SQL Server, Transparent Data Encryption, Cell Level Encryption and Always Encrypted. The session will deep dive into setting up Always Encrypted encryption and share my experiences implementing the encryption. In addition, the session will review auditing of sensitive data usage.
You will leave the session with a deeper understanding about SQL Server encryption options and how encryption can affect your performance. In addition, you will gather information on how to fully protect and review your sensitive data usage.
Event Date: 30-03-2019 - Session time: 13:20:00 - Track: Enterprise Database Administration, Deployment Monitoring
Event Date: 30-03-2019 - Session time: 13:20:00 - Track: Enterprise Database Administration, Deployment Monitoring
Event Date: 30-03-2019 - Session time: 13:20:00 - Track: Enterprise Database Administration, Deployment Monitoring
When it comes to this type of problem the consensus is to get with your network and domain admins to adequately configure access options. What happens when you can't wait or don't even have folks in that role to get the configuration right?
A blacklist is a list of what cannot access something you are trying to protect. (Like the TSA no-fly list. If you are on the list, you are not getting anywhere fast.)
A whitelist is just the opposite. It is a list of what is permitted to access something. If whatever is attempting access is not on the list, it isn’t getting in. In this session, we will go through the process to create and test your own SQL based whitelists and blacklists and also take a look at how whitelisting is being used in SQL 2017 to control what CLR objects can be trusted to run in your environment.
Event Date: 30-03-2019 - Session time: 13:20:00 - Track: Application Database Development
Here are a few of the things you’ll learn: When and how to use stored procedures The benefits and basics of contractual programming How to write stored procedures from scratch How to structure and organize stored procedures Key techniques for ideal stored procedure management Troubleshooting and debugging stored procedures The session will be packed with tons of code examples, with plenty of labs to reinforce key concepts. Beginner and experienced T-SQL programmers both will walk away with a greater understanding of how to design, manage, and troubleshoot stored procedures. Join mefor one fun session of SQL Server programming!
Event Date: 30-03-2019 - Session time: 14:30:00 - Track: Enterprise Database Administration, Deployment Monitoring
Event Date: 30-03-2019 - Session time: 14:30:00 - Track: Beginners Level
At the end of this session you will know how to configure core server resources (disk, memory and cpu), which configuration settings are essential to good performance, the all-important role of tempdb, and walk away with a checklist to use in your own SQL Server environment.
Event Date: 30-03-2019 - Session time: 14:30:00 - Track: Application Database Development
Event Date: 30-03-2019 - Session time: 14:30:00 - Track: BI Information Delivery
Join me for a quick R timeline and description followed by some use cases and live demonstrations.
Take with you a better understanding of why analysts, developers, DBAs, PMs, CIOs, and others want to know what is up with R.
Event Date: 30-03-2019 - Session time: 14:30:00 - Track: Application Database Development
When was the last time you sat down to evaluate a SELECT statement? What actually goes into the processing of that teeny little word? There might be a fair bit more to this simple term than just fetching data from the database. This session covers the simplicity of the select. Then we take it a step further to dive into some of the complexities tied directly to this particular statement.
This session will help the attendee better understand the Select statement. With a more solid understanding of this statement, the attendee can return and implement some of this new knowledge to help improve processing and query response times in their own environments.
Event Date: 30-03-2019 - Session time: 14:30:00 - Track: Internals Performance
Event Date: 30-03-2019 - Session time: 14:30:00 - Track: Application Database Development
Here are a few of the things you’ll learn: When and how to use stored procedures The benefits and basics of contractual programming How to write stored procedures from scratch How to structure and organize stored procedures Key techniques for ideal stored procedure management Troubleshooting and debugging stored procedures The session will be packed with tons of code examples, with plenty of labs to reinforce key concepts. Beginner and experienced T-SQL programmers both will walk away with a greater understanding of how to design, manage, and troubleshoot stored procedures. Join mefor one fun session of SQL Server programming!