| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:00:00 | Ravi Kumar | PreCon (Friday) | Power BI In a day Hands-On |
| 09:00:00 | Chris Hyde | PreCon (Friday) | An Introduction to Data Science with Python for Data Professional |
| 09:00:00 | Alex Grinberg | PreCon (Friday) | Black Belt for DBA with Advanced Technologies. |
| 09:00:00 | Wayne Sheffield | PreCon (Friday) | Murder They Wrote |
| 08:30:00 | Chris Hyde | Analytics and Visualization | Python in SQL Server 2017 |
| 08:30:00 | John Miner | Application Database Development | Effective Data Warehouse Storage Patterns |
| 08:30:00 | Jason Brimhall | Application Database Development | The Anatomy of Select |
| 08:40:00 | Matt Cushing | Professional Development | Networking 101: Getting Ready for a SQL Event |
| 08:40:00 | Kathi Kellenberger | Enterprise Database Administration Deployment | What is DevOps and Why Should DBAs Care? |
| 08:40:00 | Bill Rosenbaum | Strategy and Architecture | MC3 TechDay Escape Room for All! |
| 08:50:00 | Paresh Motiwala | Enterprise Database Administration Deployment | Make Your Maintenance Plans Better and Faster |
| 08:50:00 | Slava Murygin | Application Database Development | Data Profiling or Statistics 201 |
| 08:50:00 | Joe Wehr | Professional Development | Entrepreneurship - Are you ready to make it on your own? |
| 08:50:00 | Wayne Sheffield | Application Database Development | Intelligent Query Processing |
| 10:00:00 | Bill Wolff | Analytics and Visualization | Power BI for Developers |
| 10:00:00 | Tim Corey | Application Database Development | SQL Development, Source Control, and Deployment with SSDT |
| 10:00:00 | Azhagappan Arunachalam | Application Database Development | SQL Graph |
| 10:00:00 | Jeff Renz | Analytics and Visualization | Introduction to the R Programming Language for BI Professionals |
| 10:10:00 | Kathi Kellenberger | Application Database Development | T-SQL Window Function Performance |
| 10:10:00 | Je'Anna Lanza-Abbott | Professional Development | Constructive Conversations Getting Unstuck by Being Supportively Outspoken |
| 10:10:00 | Joshua Lynn | Application Database Development | Making Peace with SQL Server Integration Services - Part I Getting Started A Reluctant User's Guide |
| 10:20:00 | Paresh Motiwala | BI Platform Architecture, Development Administration | BI Infrastructure in Azure: Points to Consider |
| 10:20:00 | Dan Clark | BI Platform Architecture, Development Administration | Self-Service ETL with Power Query |
| 10:20:00 | Andrew Kelly | Enterprise Database Administration Deployment | Practical Monitoring of TempDB |
| 11:30:00 | Leonard Lobel | Cloud Application Development Deployment | Introduction to Azure Cosmos DB |
| 11:30:00 | John Miner | Application Database Development | Staging data for Azure SQL services |
| 11:30:00 | Reinhard Flügel | Application Database Development | Possiblities and Limitations of System-Versioned Temporal Tables beyond the Basics |
| 11:30:00 | Andy Yun | Application Database Development | T-SQL Tips Tricks to Make Your Life Easier! |
| 11:40:00 | Joshua Lynn | Application Database Development | Making Peace with SQL Server Integration Services - Part II Useful Sophistication A Reluctant User's |
| 11:40:00 | Bill Wolff | Enterprise Database Administration Deployment | Intro to CosmosDB |
| 11:40:00 | Daniel Cai | BI Platform Architecture, Development Administration | Design like an ETL Master - SSIS Patterns and Advanced Techniques |
| 11:50:00 | Vince Napoli | BI Platform Architecture, Development Administration | Securing and Managing access to your DW data |
| 11:50:00 | Chris Bell | Enterprise Database Administration Deployment | Build a White/Blacklist Bouncer. Who Gets into Your SQL Club? |
| 11:50:00 | Jason Brimhall | Enterprise Database Administration Deployment | Extended Events - Better than Profiler |
| 11:50:00 | Wayne Sheffield | Application Database Development | SSMS Tips and Tricks |
| 13:00:00 | Philadelphia SQL Server Users Group | Other | DELL - Sponsor Session |
| 13:00:00 | Philadelphia SQL Server Users Group | Other | Profisee - Sponsor Session |
| 13:00:00 | Philadelphia SQL Server Users Group | Other | Aspect Consulting - Sponsor Session |
| 13:00:00 | Philadelphia SQL Server Users Group | Other | Anexinet - Sponsor Session |
| 13:00:00 | Philadelphia SQL Server Users Group | Other | Varigence - Sponsor Session |
| 13:00:00 | Philadelphia SQL Server Users Group | Other | RevGen Partners - Sponsor Session |
| 13:00:00 | Philadelphia SQL Server Users Group | Other | Sios - Sponsor Session |
| 13:00:00 | Daniel Cai | Vendor Lunch Session | Supercharge your ETL Development with Advanced SSIS Components |
| 13:00:00 | Andy Yun | Vendor Lunch Session | Going Beyond Monitoring With SentryOne |
| 14:10:00 | Kevin Goff | Application Database Development | In-Memory Capabilities in SQL Server |
| 14:10:00 | Leslie Weed | BI Platform Architecture, Development Administration | Innovative Data Modeling: Make Data Warehousing Cool Again Part 1 |
| 14:10:00 | Sebastian Meine | Application Database Development | Advanced Indexing for Accidental DBAs |
| 14:10:00 | Tracey Nelson | Enterprise Database Administration Deployment | Beginner's Guide for Creating Maintenance Plans |
| 14:15:00 | David Patrick | Cloud Application Development Deployment | Intro to Azure for SQL Geeks |
| 14:15:00 | Jamey Johnston | Analytics and Visualization | Code Like a Snake Charmer - Intro to Python and Data Science Tools in MS |
| 14:15:00 | Gabriel Villa | Cloud Application Development Deployment | Dive into Amazon Web Services Databases |
| 14:20:00 | Thomas Grohser | Application Database Development | 42 TSQL Functions |
| 14:20:00 | Dominic Falso | Strategy and Architecture | Dynamic SQL at Design-time |
| 14:20:00 | David Bermingham | Enterprise Database Administration Deployment | Why Clustering for SQL Server High Availability? |
| 15:30:00 | Chris Bell | Enterprise Database Administration Deployment | Building your First SQL Server Container Lab in Docker |
| 15:30:00 | Leslie Weed | BI Platform Architecture, Development Administration | Cool Data Warehousing -- PART 2 |
| 15:30:00 | Kevin Goff | Application Database Development | In-Memory Capabilities -- PART 2 |
| 15:30:00 | Philadelphia SQL Server Users Group | Other | to be announced |
| 15:35:00 | Sarah Patrick | Application Database Development | Case Study: How I used SharePoint, Flow, PowerApps, and Forms to build a Speaker Database |
| 15:35:00 | Tyler Graham | Enterprise Database Administration Deployment | Master Data Management: BI and Data Science’s Best Friend |
| 15:35:00 | Linda Zhang | Enterprise Database Administration Deployment | Different Azure SQL PaaS options |
| 15:40:00 | Ray Kim | Professional Development | Tech Writing for Techies: A Primer |
| 15:40:00 | David Bermingham | Enterprise Database Administration Deployment | High Availability and Disaster Recovery for SQL Server in Azure IaaS |
| 15:40:00 | Alex Grinberg | Application Database Development | Advanced T-SQL Development with latest features. |
| 15:40:00 | Thomas Grohser | Application Database Development | 42 TSQL Functions -- PART 2 |
Event Date: 04-05-2019 - Session time: 09:00:00 - Track: PreCon (Friday)
Power BI Desktop: What is Power BI and what it is not Introduction Connecting to the data Shaping data at query time Modeling Data Dax Calculations Building Reports
Power BI Service: What is Power BI Service Publishing Power BI Desktop file to the Service (Instructor will provide logins to a test Power BI Service tenant) Get the online data Sharing reports and desktops Refreshing the data Mobile Reports
Power BI On Premises Server: How is Power BI On Premises server different from Power BI Service When should you use Power BI Server
SSAS Tabular: What it is and how it integrates with Power BI
Pre-requisite: Please have Pow
Event Date: 04-05-2019 - Session time: 09:00:00 - Track: PreCon (Friday)
Together we will work through some real-world data analyses using several of the most popular Python libraries, such as NumPy, pandas, Matplotlib, and SciPy. We'll cover collecting and importing data, and introduce basic statistics around our data. We'll then move on to create some simple visualizations of our data to help us identify trends and patterns.
Note that as this is a hands-on pre-con, participants will be required to bring a laptop with a working Python installation. Full details on this will be provided prior to the session.
More Details and Sign-Up: https://sqlsat835precon2.eventbrite.com
Event Date: 04-05-2019 - Session time: 09:00:00 - Track: PreCon (Friday)
PowerShell, .NET, XML and JSON skills often appear in SQL Server DBA job requirements because the ability to work with those allow the DBA to adapt faster and more efficiently when solving different types of problems. This session designed to bring you up to speed with several of these technologies.
More Details and Sign-Up: https://sqlsat835precon1.eventbrite.com
Event Date: 04-05-2019 - Session time: 09:00:00 - Track: PreCon (Friday)
Join Microsoft Certified Masters, Wayne Sheffield and Jason Brimhall, as they examine numerous database design and coding implementations that they have seen over the years. They will explore these implementations and show how they can be murder on SQL Server in terms of performance, security, storage and even accuracy. You will learn how you can identify these “killers” and how you can implement alternatives that will keep data professionals, management, and end-users happy. All while keeping your databases happy, secure, turbo-charged and healthy.
More Information and Sign-Up: https://sqlsat835precon3.eventbrite.com
Event Date: 04-05-2019 - Session time: 08:30:00 - Track: Analytics and Visualization
In this introductory session we'll briefly introduce the Python language and then look at how to install and administer Machine Learning Services. We'll start to demonstrate the power of Python by showing you how to create and run simple scripts from within T-SQL. We'll then discuss some of the powerful open source packages that are available to aid your data analyses. Finally, we'll go through some examples of how to use Python to integrate data analytical methods in real-world situations, and wow your customers with the power of analytics!
Event Date: 04-05-2019 - Session time: 08:30:00 - Track: Application Database Development
Unexpected information growth in your data mart may lead to a performance impacted reporting system. In short, your users will be lining up at your cube for their daily reports.
How do you reduce the size of your data mart and speed up data retrieval? This presentation will review the following techniques to fix your woes.
Techniques: 1 – What is horizontal partitioning? 2 – Database sharding for daily information. 3 – Working with files and file groups. 3 – Partitioned views for performance. 4 – Table and Index partitions. 5 – Row Data Compression. 6 – Page Data Compression. 7 – Programming a sliding window. 8 – What is different in Azure SQL database?
Event Date: 04-05-2019 - Session time: 08: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: 04-05-2019 - Session time: 08:40:00 - Track: Professional Development
In this session, we'll go over steps you can take before, during and after the event to maximize the amount of great stuff you'll take away at the end (besides cool vendor swag). Not just keeping up on new technologies, but meeting new people, getting leads on solutions/opportunities, and an appreciation for the community you're in and what it has to offer.
Event Date: 04-05-2019 - Session time: 08:40:00 - Track: Enterprise Database Administration Deployment
Attend this session to learn how DevOps is changing the DBAs world for the better.
Event Date: 04-05-2019 - Session time: 08:40:00 - Track: Strategy and Architecture
What a great way to start your day in a fun way and pick up some IT security insights on the way.
Event Date: 04-05-2019 - Session time: 08:50:00 - Track: Enterprise Database Administration Deployment
I am going share a case study of a three-terabyte database and how I tweaked my Indexing, backup and restore jobs to help cut down my maintenance window from over eight hours to under 30 minutes. By the end of my session you will be able to shrink the duration of your maintenance plans by as much as 75%. You will learn to use parameters like BLOCKSIZE, BUFFERCOUNT and MAXTRANSFERSIZE appropriately with the BACKUP command. You will also see the advantages of native database compression, striped, parallel and staggered backups in combination with a mix of Full/Differential and Log backups. I will also show you how third party tools like Copy Data Virtualization or Snapshot Mirroring help us cut down our backup and restore times by as much as 95%.
Event Date: 04-05-2019 - Session time: 08:50:00 - Track: Application Database Development
When all these queries are already pre-set or dynamic or you are doing profiling via SQL Server Data Tools, it is not a problem on relatively small data set, but what if your table contains billions of records, and stretches for multiple gigabytes? All queries against that large data set will do a full table scan, which will produce very heavy I/O, and take forever. In order to make the process faster, we will use a hidden gem of SQL Server: Statistics. Only one table scan will be needed to generate them, and then we can use the science behind them to do research over our data.
Event Date: 04-05-2019 - Session time: 08:50:00 - Track: Professional Development
Attend this inspiring session by Prof Joe Wehr of the MCCC and discover the good and the bad of becoming an entrepreneur.
This includes the things everyone needs to know, like
And the less obvious, including
If you have been thinking about “it” but aren't sure if you're ready, you need to attend this session. You might be surprised by what you learn about yourself
Event Date: 04-05-2019 - Session time: 08:50:00 - Track: Application Database Development
Intelligent Query Processing allows your queries to operate more efficiently (resulting in better query performance) - without needing to make changes to the code or the application.
In this session we will explore all of the Intelligent Query Processing features in SQL Server 2019.
Time permitting, we will go into other changes in recent versions of SQL Server (such as execution plan changes and new Dynamic Management Objects) that will help improve your efficiency at troubleshooting and tuning SQL Server.
Coming away from this session, you will have plenty of reasons to want to upgrade to SQL Server 2019 immediately!
Event Date: 04-05-2019 - Session time: 10:00:00 - Track: Analytics and Visualization
Event Date: 04-05-2019 - Session time: 10:00:00 - Track: Application Database Development
Event Date: 04-05-2019 - Session time: 10:00:00 - Track: Application Database Development
Event Date: 04-05-2019 - Session time: 10:00:00 - Track: Analytics and Visualization
In this session I will demonstrate how to use R Studio to generate and test R scripts; generate R visuals in PowerBI; call R code in machine learning workflows; and execute R code in SQL Server. Additionally, I will cover these R programming fundamentals: creating and assigning variables; performing simple calculations; understanding R data types; vectors; matrices; factors; lists; data frames; and ggplot2 graphics.
Event Date: 04-05-2019 - Session time: 10:10:00 - Track: Application Database Development
Event Date: 04-05-2019 - Session time: 10:10:00 - Track: Professional Development
Event Date: 04-05-2019 - Session time: 10:10:00 - Track: Application Database Development
Event Date: 04-05-2019 - Session time: 10:20:00 - Track: BI Platform Architecture, Development Administration
a) Better access to data and b) Increased operational efficiency How can you set up your own BI infrastructure in the cloud to address these? What components do we consider? We can do that by proper selection of technology and vendors from Azure Market Place. How do we keep an eye on possible use of Big Data for your BI. We will also look at the best practices for doing so. We will take a fleeting look at some of the storage options for us in Azure and some Big Data concepts as well. We will learn about Copy Data Virtualization in Azure Market Place that can help you provision terabytes worth of information in matter of minutes. We will also learn about setting up teams and ways to train them(and yourself) in this fast evolving world of Azure.
Event Date: 04-05-2019 - Session time: 10:20:00 - Track: BI Platform Architecture, Development Administration
Event Date: 04-05-2019 - Session time: 10:20:00 - Track: Enterprise Database Administration Deployment
Event Date: 04-05-2019 - Session time: 11:30:00 - Track: Cloud Application Development Deployment
We tour many features of Cosmos DB, including its multi-model capabilities which allow you to store and query schema-free JSON, graph, key/value, and columnar data models. You’ll learn about global distribution, scale-out partitioning, tunable consistency, custom indexing, and more. We’ll also explore client development using the many available SDKs and APIs. Attend this session, and get up to speed on Cosmos DB toda
Event Date: 04-05-2019 - Session time: 11:30:00 - Track: Application Database Development
Schema on write is represented by the traditional relational database table. 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. All data owned by the company can reside in simple storage.
Today, we will learn how to stage data using Azure blob storage which can be ingested by both techniques.
1 – Grab some big data. 2 – Create blob storage account. 3 – Copy data to container. 4 – Azure SQL database plumbing. 5 – Loading data with BULK INSERT. 6 – Azure SQL data warehouse plumbing. 7 – Loading data with POLYBASE. 8 – Azure automation with RUNBOOKS.
Event Date: 04-05-2019 - Session time: 11:30:00 - Track: Application Database Development
Event Date: 04-05-2019 - Session time: 11:30:00 - Track: Application Database Development
Prerequisites: Basic T-SQL development knowledge.
Event Date: 04-05-2019 - Session time: 11:40:00 - Track: Application Database Development
Event Date: 04-05-2019 - Session time: 11:40:00 - Track: Enterprise Database Administration Deployment
Event Date: 04-05-2019 - Session time: 11:40:00 - Track: BI Platform Architecture, Development Administration
Event Date: 04-05-2019 - Session time: 11:50:00 - Track: BI Platform Architecture, Development Administration
Event Date: 04-05-2019 - Session time: 11:50:00 - Track: Enterprise Database Administration Deployment
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: 04-05-2019 - Session time: 11:50:00 - Track: Enterprise Database Administration Deployment
Event Date: 04-05-2019 - Session time: 11:50:00 - Track: Application Database Development
Event Date: 04-05-2019 - Session time: 13:00:00 - Track: Other
Event Date: 04-05-2019 - Session time: 13:00:00 - Track: Other
Event Date: 04-05-2019 - Session time: 13:00:00 - Track: Other
Event Date: 04-05-2019 - Session time: 13:00:00 - Track: Other
Learn the best ways to use advanced analytics techniques like machine learning and natural language processing to measure customer experience. This session will highlight the datasets that are available across most businesses that can be used to measure customer experience, the methods to analyze those datasets, and the common use cases that can be solved with this type of analysis. It will include an overview of how supervised learning is used for sentiment classification and predictive modeling.
Event Date: 04-05-2019 - Session time: 13:00:00 - Track: Other
Event Date: 04-05-2019 - Session time: 13:00:00 - Track: Other
Event Date: 04-05-2019 - Session time: 13:00:00 - Track: Other
Event Date: 04-05-2019 - Session time: 13:00:00 - Track: Vendor Lunch Session
In this session, we will introduce you to our collection of 150 advanced SSIS components. We will demonstrate some of our most popular offerings including our JSON XML components for integrating with REST APIs, Premium Derived Column with over 225 functions, and unique components such as Duplicate Detector and Diff Detector.
In additional to performing advanced transformations you will also find codeless and feature-rich solutions for integrating with virtually any application or database system including leading enterprise applications such as Microsoft SharePoint, Dynamics 365 and more.
Event Date: 04-05-2019 - Session time: 13:00:00 - Track: Vendor Lunch Session
Join me and I'll show you how SentryOne provides environment-wide visibility and aids in managing cross-server activities. I'll showcase how alerting can be tuned to be effective and not noise. And you'll discover how SentryOne can give you both operational and business value to address your application challenges.
Event Date: 04-05-2019 - Session time: 14:10:00 - Track: Application Database Development
Event Date: 04-05-2019 - Session time: 14:10:00 - Track: BI Platform Architecture, Development Administration
Event Date: 04-05-2019 - Session time: 14:10:00 - Track: Application Database Development
But there are still cases where things just don’t appear to work as expected. Cases where SQL Server seems to ignore existing indexes. Situations where you just can’t figure out how to create a fitting index in the first place. If that describes you, this session is for you. In it you’ll discover:
Event Date: 04-05-2019 - Session time: 14:10:00 - Track: Enterprise Database Administration Deployment
Event Date: 04-05-2019 - Session time: 14:15:00 - Track: Cloud Application Development Deployment
Event Date: 04-05-2019 - Session time: 14:15:00 - Track: Analytics and Visualization
The session will be an introduction to the Python language including:
1.) Installing and Configuring Python 2.) Access and Manipulate Data 3.) Install and Manage Packages 4.) Create and Use Objects/Variables 5.) Control Flows and Functions 6.) Managing the Python installation in MSSQL
Attend this session to learn how to use Python to take your data analytics to the next level. We will use Python, SQL Server and the Anaconda distribution of Python to learn the basics of Python and how it is integrated in the Microsoft stack! We will walk through a simple deployment of a machine learning model to see how it all works together and learns some basic data science fundamentals.
No prior statistics knowledge needed.
Event Date: 04-05-2019 - Session time: 14:15:00 - Track: Cloud Application Development Deployment
Event Date: 04-05-2019 - Session time: 14:20:00 - Track: Application Database Development
Event Date: 04-05-2019 - Session time: 14:20:00 - Track: Strategy and Architecture
Event Date: 04-05-2019 - Session time: 14:20:00 - Track: Enterprise Database Administration Deployment
Event Date: 04-05-2019 - Session time: 15:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 04-05-2019 - Session time: 15:30:00 - Track: BI Platform Architecture, Development Administration
Event Date: 04-05-2019 - Session time: 15:30:00 - Track: Application Database Development
Event Date: 04-05-2019 - Session time: 15:30:00 - Track: Other
Event Date: 04-05-2019 - Session time: 15:35:00 - Track: Application Database Development
Event Date: 04-05-2019 - Session time: 15:35:00 - Track: Enterprise Database Administration Deployment
Event Date: 04-05-2019 - Session time: 15:35:00 - Track: Enterprise Database Administration Deployment
Event Date: 04-05-2019 - Session time: 15:40:00 - Track: Professional Development
Event Date: 04-05-2019 - Session time: 15:40:00 - Track: Enterprise Database Administration Deployment
While on-prem high availability and disaster recovery options for SQL Server are well defined, moving those instances to Azure immediately presents some questions and challenges. Can I simply lift and shift my SQL Server Failover Cluster Instance to the cloud? Do I need to upgrade to SQL Server Enterprise Edition and us Always On Availability Groups? What about shared storage and failover clustering? What about disaster recovery, what are my options there? Load Balancers, Fault Domains, Availability Zones, Azure Site Recovery and Region Pairs, what are these things and why do they matter to me?
Cloud Datacenter MVP David Bermingham takes explains all this and more in the session.
Event Date: 04-05-2019 - Session time: 15:40:00 - Track: Application Database Development
Event Date: 04-05-2019 - Session time: 15:40:00 - Track: Application Database Development