SQLSaturday #835 - Philadelphia 2019

Event Date: 05/04/2019 00:00:00

Event Location:

Montgomery County Community College
340 Dekalb Pike
Blue Bell, PA

This event has completed. All data shown below is from the historical XML public data available.

Sessions
Speakers
Sponsors

If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).

Sessions

This is a list of sessions from the event, based on the schedule in the XML files.

Title: Make Your Maintenance Plans Better and Faster

Abstract: Maintenance plans are never easy. They get worse as the databases get bigger and the maintenance windows shrink upon pressure from the customers. So, stop struggling with your nightly/weekly database maintenance plans. 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%.

Speaker(s):

Paresh Motiwala

Track and Room: Enterprise Database Administration Deployment - L

Title: An Introduction to Data Science with Python for Data Professional

Abstract: Data Science is currently the hottest topic among data analysts and technologists, but getting started can sometimes be daunting or confusing to many data professionals. We aim to change that with this full-day, hands-on course in which you will be introduced to data science and its basic methodologies using the Python programming language!

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

Speaker(s):

Chris Hyde

Track and Room: PreCon (Friday) - Q

Title: BI Infrastructure in Azure: Points to Consider

Abstract: Success of a good BI infrastructure is measured by two most important factors: 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.

Speaker(s):

Paresh Motiwala

Track and Room: BI Platform Architecture, Development Administration - L

Title: High Availability and Disaster Recovery for SQL Server in Azure IaaS

Abstract: The CEO just tasked you with moving all the SQL Server instances to Azure, or maybe you are deploying a brand new application and want to leverage Azure IaaS to host SQL Server. Beyond security and performance, your most pressing concern might be ensuring SQL Server running in Azure is highly available.

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.

Speaker(s):

David Bermingham

Track and Room: Enterprise Database Administration Deployment - H

Title: Power BI In a day Hands-On

Abstract: Attend this Power BI Hands-on comprehensive class with Ravi Kumar to learn how to model your data and how to create beautiful visuals using your data. Full day introductory course will give you a great working knowledge on how Power BI works in general. We will be covering Power BI Desktop and Power BI Service for the following topics:

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

Speaker(s):

Ravi Kumar

Track and Room: PreCon (Friday) - S

Title: Python in SQL Server 2017

Abstract: SQL Server 2017 has finally arrived, bringing with it a host of exciting new features. Of particular interest to BI practitioners and data scientists is the integration of the Python programming language into the SQL ecosystem. This integration opens up a number of possibilities for in-database analytics and intelligent database applications, so let’s get started!

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!

Speaker(s):

Chris Hyde

Track and Room: Analytics and Visualization - A

Title: Self-Service ETL with Power Query

Abstract: Before any significant data analysis can take place the data often needs to be transformed, aggregated, and combined. This is often referred to as the ETL (Extraction, Transform, and Load) process. Power Query is an excellent tool in the Microsoft self-service BI stack that allows business users to discover, combine, and refine data before loading it into a Power Pivot model for further analysis. In addition, Microsoft has made connecting to a wide variety of sources including relational, structured, and semi structured data a consistent intuitive experience. This session guides you through using Power Query to extract, transform, and load data from various sources into a Power Pivot model. In addition, we will look at the M language created by the tool and look at some advanced queries you can create using M.

Speaker(s):

Dan Clark

Track and Room: BI Platform Architecture, Development Administration - M

Title: Effective Data Warehouse Storage Patterns

Abstract: Many companies start off with a simple data mart for reporting. As the company grows, users become dependent on the data mart for monitoring and making decisions on Key Performance Indicators (KPI).

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?

Speaker(s):

John Miner

Track and Room: Application Database Development - D

Title: Data Profiling or Statistics 201

Abstract: Any new database design, normalization process or just simple research starts from data profiling. At first you determine number of rows in the data set. After that you run multiple similar queries against each column to determine Max and Min values, maximum length for text columns, number of nulls, distribution of data, and more. 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.

Speaker(s):

Slava Murygin

Track and Room: Application Database Development - K

Title: Introduction to Azure Cosmos DB

Abstract: This session presents an overview of Azure Cosmos DB, a globally distributed, massively scalable, low (single-digit millisecond) latency, fully managed NoSQL database service that is designed specifically for modern web and mobile applications. Like other NoSQL platforms, Cosmos DB supports a schema-free data model, built-in partitioning for sustained heavy-write ingestion, and replication for high availability. But only Cosmos DB offers turnkey global distribution, automatic indexing, and SLAs for guarantees on 99.99% availability, throughput, latency, and consistency.

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

Speaker(s):

Leonard Lobel

Track and Room: Cloud Application Development Deployment - B

Title: Entrepreneurship - Are you ready to make it on your own?

Abstract: There’s no doubt about it, being an entrepreneur can be very rewarding. However, it is far from easy. So, before you embark on that journey, you have to ask yourself if this is the right thing for you to do. But, how do you know?

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

how to strategize and create a business plan
how to secure financing
what to look out for before hiring (hiring mistakes are very costly)

And the less obvious, including

knowing when and how to get out (retirement, anybody?)
the not so subtle difference between a consultant and an entrepreneur (this is an eye-opener)
how to legally extend the reach of your cash (ever heard of multitasking your money?)

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

Speaker(s):

Joe Wehr

Track and Room: Professional Development - H

Title: Staging data for Azure SQL services

Abstract: Most companies are faced with the ever-growing big data problem. There have been two schools of thought on how to solve this problem.

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.

Speaker(s):

John Miner

Track and Room: Application Database Development - D

Title: Introduction to the R Programming Language for BI Professionals

Abstract: The modern BI professional is taking on the challenge of operationalizing data science. Most BI developers are very strong in TSQL but their exposer to advanced statistics and visualizations were limited by what is available in the TSQL language. The R programming language allows us to clean, visualize, and apply advanced statistical methods to data.

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.

Speaker(s):

Jeff Renz

Track and Room: Analytics and Visualization - C

Title: Advanced T-SQL Development with latest features.

Abstract: In the last releases, SQL Server development was enriched with new T-SQL features, such as STRING_AGG, STRING_SPLIT, TRANSLATE array of Ranking and Windowing functions (ROW_NUMBER, RANK, DENSE_RANK, TILE), MERGE statement, OUTPUT clause, EXCEPT and INTERSECT just to name a few. For various reasons some DBA/Developers do not utilize these new features. In this session, the audience will see demonstrations of the different practical use cases where these features can make T-SQL coding more efficient. This 100% code-based demo session highlights efficiency to utilize the latest T-SQL functions over conventional methods with the same functionality. The session will cover in depth live scenarios where these features have proven performance efficiency, code re

Speaker(s):

Alex Grinberg

Track and Room: Application Database Development - M

Title: Build a White/Blacklist Bouncer. Who Gets into Your SQL Club?

Abstract: Are too many systems hitting your SQL Servers? Do you know who they all are? Are you under attack? 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.

Speaker(s):

Chris Bell

Track and Room: Enterprise Database Administration Deployment - K

Title: Black Belt for DBA with Advanced Technologies.

Abstract: In the modern world of information technology, SQL Server DBA tasks exceed typical Administration and T-SQL development. Each new SQL Server version brings additional technologies that help streamline and improve its functionalities. Within the last decade, SQL Server has evolved into a sophisticated Enterprise RDBMS tool, and it continues to grow by providing more functionalities to store and manipulate data reliably.

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

Speaker(s):

Alex Grinberg

Track and Room: PreCon (Friday) - P

Title: Practical Monitoring of TempDB

Abstract: While TempDB make look like any other database it’s usage patterns are typically unique and require a special type of monitoring to stay ahead of any potential performance or space issues. This session is packed with demo’s that will outline what aspects of TempDB you need to pay attention to and exactly how to monitor for them. We will discuss what you can do to tune this database to match your workload and allow for proper scaling over time and different work patterns you may encounter. If you want peak performance from your SQL Serve Instance you need to ensure TempDB is up to the challenge. Come see exactly what those challenges are and what you can do to be ready for them.

Speaker(s):

Andrew Kelly

Track and Room: Enterprise Database Administration Deployment - K

Title: Code Like a Snake Charmer - Intro to Python and Data Science Tools in MS

Abstract: Python is the one of the most popular programming languages used today and one of the most useful tools in the data scientist’s tool belt especially for machine learning. Python is integrated into the Microsoft stack in tools like Azure ML and now SQL Server 2017.

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.

Speaker(s):

Jamey Johnston

Track and Room: Analytics and Visualization - F

Title: Constructive Conversations Getting Unstuck by Being Supportively Outspoken

Abstract: In this fun, interactive presentation, Je’Anna Abbott gives tips for handling those conversations you know you need to have, but you’ve been avoiding because it seems too difficult or dangerous. By the end of the presentation, participants will be able to: • Recognize where you are stuck because you are unwilling or unable to have a difficult conversation, and become comfortable with initiating and conducting those conversations effectively. • Develop a strategy to ask for what you want and need without alienating other people or damaging your brand. • Reframe and recognize the motivations of others to create the most effective responses in yourself. • Acknowledge and mitigate the effect of the conversations that are left unspoken. • Practice dialogue techniques designed to make others receptive to your constructive conversation, and practice listening techniques designed to build true understanding and support. • Create a strategy to conduct a constructive conversations in your person

Speaker(s):

Je’Anna Lanza-Abbott

Track and Room: Professional Development - G

Title: Making Peace with SQL Server Integration Services - Part II Useful Sophistication A Reluctant User’s

Abstract: SSIS can be frustrating even for experienced users. There are a multitude of choices that appear to do the same thing and options that should be there aren’t. This class focuses on techniques for getting useful work done. The goal is to help you make better choices as a developer by exploring the multiple ways the same tasks can be accomplished within SSIS and in contrast to TSQL. This is a practical class for getting things done by using SSIS for what it is good at doing. If you already use and or love SSIS you still might pick up a few tips or learn another structured approach. Come, let’s find a way to make SSIS useful for you, after all, you already paid for it if you own SQL server.

Speaker(s):

Joshua Lynn

Track and Room: Application Database Development - E

Title: Advanced Indexing for Accidental DBAs

Abstract: Somehow you managed to get yourself voluntold to take care of the company’s SQL Server installation. Over time, you picked up the basic knowledge of how to use indexes to make queries perform better. 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:

What index selectivity is and how it impacts index selection
The ominous “tipping point” and how it can lead to surprising index choices by the optimizer
How to improve Aggregate Performance with indexes
How to improve Join Performance with indexes
Indexes on heaps and the Forwarded Records trap
Filtered Indexes After attending, you’ll have a set of new tools and techniques in your SQL Server toolbox that you can take home and use to increase performance in your database right away.

Speaker(s):

Sebastian Meine

Track and Room: Application Database Development - C

Title: Dive into Amazon Web Services Databases

Abstract: Are you considering to move your databases to Amazon Web Services but unsure of your options? Understand the possibilities to leverage Infrastructure as a Service and Platform as a Service and what is the best for cloud solution your situation. Gain insights from years of lessons learned to minimize your maintenance and costs. Discover scaling possibilities for relational and NoSQL databases to petabyte size demands. I will demonstrate how to get started with the basics of managed services and platforms for running databases on AWS. DBAs, hear how to use managed relational databases such as MS SQL Server with minimal administration. Architects, Developers, DBAs, Managers or IT Professionals, discover other cloud options such as managed NoSQL or scaling your own instances with resizable elastic compute cloud. Take a dive from RDBMS to petabyte-scale data warehouse databases in the Amazon cloud.

Speaker(s):

Gabriel Villa

Track and Room: Cloud Application Development Deployment - E

Title: Innovative Data Modeling: Make Data Warehousing Cool Again Part 1

Abstract: There is much more to life than 3rd normal form and dimensional modeling. Come explore how you can build a data warehouse solution or hybrid solution that is agile in nature with Data Vault. Discover this highly audit-able modeling technique used in international banking, manufacturing, insurance and many more industries. Made a mistake? No worries, own your model. Design changes happen and it can be addressed quickly avoiding pain and project delays and ultimately keeping your business happy. Let us bust the myth that data warehouses take too long to build and are too hard to modify by adding value to your environment and decreasing delivery time.

Speaker(s):

Leslie Weed

Track and Room: BI Platform Architecture, Development Administration - B

Title: The Anatomy of Select

Abstract: TSQL is one of the most valuable tools any SQL Server professional can add to their tool-set. More aptly, TSQL is a whole chest of tools for the SQL Server professional. One of the most important tools in that TSQL chest is a good understanding of the SELECT statement.

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.

Speaker(s):

Jason Brimhall

Track and Room: Application Database Development - B

Title: Intelligent Query Processing

Abstract: SQL Server has evolved many times over the years. SQL Server 2019 introduces “Intelligent Query Processing”, greatly enhancing the “Adaptive Query Processing” which was introduced in SQL Server 2017.

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!

Speaker(s):

Wayne Sheffield

Track and Room: Application Database Development - M

Title: Murder They Wrote

Abstract: A Review of database design and coding implementations and how they can be murder on SQL Server in terms of performance, security, storage and even accuracy. 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

Speaker(s):

Wayne Sheffield

Track and Room: PreCon (Friday) - T

Abstract: TBD

Speaker(s):

Philadelphia SQL Server Users Group

Track and Room: Other - K

Title: Supercharge your ETL Development with Advanced SSIS Components

Abstract: Want to get more out of your SSIS development efforts? The SSIS Productivity Pack is a collection of premium SSIS components which enable an improved SSIS ETL development experience with greater potentials. These SSIS components for connectivity and productivity offer more features and bring new enhancements to SSIS to enable integration scenarios not once possible without custom scripting.

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.

Speaker(s):

Daniel Cai

Track and Room: Vendor Lunch Session - G

Abstract: Using Advanced Analytics to Measure Customer Experience by Brian Atkiss

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.

Speaker(s):

Philadelphia SQL Server Users Group

Track and Room: Other - B

Title: T-SQL Tips Tricks to Make Your Life Easier!

Abstract: Do you spend your days slinging T-SQL code? Want to improve your T-SQL game? If you answered yes, then this session is for you. This demo-intensive session will showcase a collection of my favorite beginner and intermediate level tips and tricks. We will explore how to identify and fix some common T-SQL anti-patterns, my favorite SSMS productivity tricks, and clever solutions to some common but not easily-coded challenges. This session targets both developers and DBAs; the only prerequisites are the desire to write better T-SQL code and aim of living an easier life!

Prerequisites: Basic T-SQL development knowledge.

Speaker(s):

Andy Yun

Track and Room: Application Database Development - C

Title: Different Azure SQL PaaS options

Abstract: Azure SQL PaaS offers different options? Which one should you choose when you move your SQL Server to Azure Cloud? This session will help you understand the difference between SQL Database Single DB, SQL managed instance and SQL Elastic Pool.

Speaker(s):

Linda Zhang

Track and Room: Enterprise Database Administration Deployment - F

Abstract: TBD

Speaker(s):

Philadelphia SQL Server Users Group

Track and Room: Other - L

Title: Going Beyond Monitoring With SentryOne

Abstract: Hopefully, you are monitoring your SQL Servers using DIY scripts or a 3rd party tool. Active monitoring is invaluable to enable the operational DBA to identify and address issues quickly. But did you know that SentryOne offers capabilities beyond just monitoring?

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.

Speaker(s):

Andy Yun

Track and Room: Vendor Lunch Session - C

Title: In-Memory Capabilities in SQL Server

Abstract: The Enterprise Edition of SQL Server 2016 contains 2 powerful features for database and data warehouse developers to improve performance and scalability. One is columnstore indexes and the other is in-memory optimized tables. In this presentation I’ll show several examples with large databases on how you can get the most out of these 2 great features. I’ll cover the scenarios and contexts where columnstore indexes and in-memory optimizes tables work best.

Speaker(s):

Kevin Goff

Track and Room: Application Database Development - A

Title: Intro to CosmosDB

Abstract: Azure CosmosDB is Microsoft’s NoSQL database and much more. Come explore how data is stored, queried, and managed.

Speaker(s):

Bill Wolff

Track and Room: Enterprise Database Administration Deployment - F

Title: Beginner’s Guide for Creating Maintenance Plans

Abstract: We will cover the benefit of using maintenance plans, tasks that can be created, how we create tasks, how to create sub-plans, and configuration notes and gotchas!

Speaker(s):

Tracey Nelson

Track and Room: Enterprise Database Administration Deployment - D

Title: Making Peace with SQL Server Integration Services - Part I Getting Started A Reluctant User’s Guide

Abstract: Curious about SSIS? Frustrated trying to use, develop, and deploy packages? Haven’t a clue what SSIS really is and why you should care? Then the Making Peace with SQL Server Integration Services - Part I Getting Started - A Reluctant User’s Guide class is for you. We’ll take a look at the good, the bad and the ugly of SSIS to demonstrate how it can be of benefit to you while minimizing the pain and frustration in making it work. Special focus will be directed towards using the platform in conjunction with TSQL. This is a practical class for developers looking to get started using SSIS.

Speaker(s):

Joshua Lynn

Track and Room: Application Database Development - E

Title: Possiblities and Limitations of System-Versioned Temporal Tables beyond the Basics

Abstract: This technical presentation shows how to manipulate data with versioning switched off, what to consider when building queries referencing multiple temporal tables and building views.

Speaker(s):

Reinhard Flügel

Track and Room: Application Database Development - A

Title: SQL Development, Source Control, and Deployment with SSDT

Abstract: Building and maintaining a SQL Server database in a multi-developer environment can be difficult. Why is it that software development gets all the cool tools around source control, multi-user teams, deployment, and more? SQL Server Development Tools is the answer you have been looking for. See how to manage a new or existing database, create upgrade scripts, commit changes to source control, deploy to various environments, and more in this session.

Speaker(s):

Tim Corey

Track and Room: Application Database Development - D

Title: Securing and Managing access to your DW data

Abstract: Managing who is able to access and retrieve data in your database is paramount to an organization. How do we protect data from prying eyes, or individuals whose roles simply do not and should not have access to certain data? We will look at techniques to secure and restrict access, and release of data to those who should receive it. Taking real life scenarios, we will apply row level security, dynamic data masking, database roles, schemas, security groups, and other considerations to manage secure and manage access to your data.

Speaker(s):

Vince Napoli

Track and Room: BI Platform Architecture, Development Administration - H

Title: Extended Events - Better than Profiler

Abstract: Extended Events was introduced in SQL Server 2008. Every release since then, we have seen a significant upgrade to this feature. Join me for a little adventure into the realm of extended events. We will discuss how to use extended events to aid in performance tuning and in day to day administration. We will also explore some background and the architecture of extended events. This is a fast paced session and will be a lot of fun. Attendees will be able to take back several sample XE sessions to help troubleshoot different issues and get to more intimately know their data/environment.

Speaker(s):

Jason Brimhall

Track and Room: Enterprise Database Administration Deployment - L

Title: Networking 101: Getting Ready for a SQL Event

Abstract: Looking to get the most out of your SQLSaturday, PASS Summit, or local user group meeting? Plan ahead! Events aren’t just about learning new things, they’re about meeting new people, networking with peers, and learning different approaches to common issues.

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.

Speaker(s):

Matt Cushing

Track and Room: Professional Development - G

Title: SSMS Tips and Tricks

Abstract: Almost everyone uses SSMS to write queries and to browse around on the server - but do you use all of the features that SSMS offers to increase your productivity? Most people use few of these, and probably don’t even know that many of these features even exist. Come to this session, consisting almost entirely of demos in SSMS, to see features built in to SSMS that will improve your experience and productivity. Time permitting; we’ll also go into some 3rd party products that also increase your productivity in SSMS.

Speaker(s):

Wayne Sheffield

Track and Room: Application Database Development - M

Title: Case Study: How I used SharePoint, Flow, PowerApps, and Forms to build a Speaker Database

Abstract: In this case study, I detail how I went about designing and implementing a Speaker Database for the Project Management Institute using SharePoint, Flow, Power Apps, and Microsoft Forms. We will do a brief intro of what each technology is and it’s pros and cons, and then dive into what I learned about each, each strengths and weaknesses, and how I was able to build a functional Speaker Database.

Speaker(s):

Sarah Patrick

Track and Room: Application Database Development - G

Title: 42 TSQL Functions

Abstract: SQL Server has many build in T-SQL functions. This session will introduce you to 42 of them and explain how they can make your life easier. To name just a few TRANSLATE(REVERSE(DIFFERENCE(STATS_TIME(STRING_SPLIT(…))))

Speaker(s):

Thomas Grohser

Track and Room: Application Database Development - K

Title: MC3 TechDay Escape Room for All!

Abstract: Try to beat the clock and escape. During this session, you will have access to the materials and clues necessary to recover “top secret” data. To beat the clock, you will need curiosity, intuition, and persistence. This session is designed to engage individuals of all backgrounds (no technical expertise required) to have fun solving challenges while being exposed to security best practices.

What a great way to start your day in a fun way and pick up some IT security insights on the way.

Speaker(s):

Bill Rosenbaum

Track and Room: Strategy and Architecture - E

Title: Dynamic SQL at Design-time

Abstract: Dynamic SQL at Design-time is a different beast than at Runtime, though it uses similar techniques. We’ll talk about the differences between the two, go over techniques for code generation, and discuss the problems that we can more easily solve.

Speaker(s):

Dominic Falso

Track and Room: Strategy and Architecture - M

Abstract: TBD

Speaker(s):

Philadelphia SQL Server Users Group

Track and Room: Other - D

Title: Why Clustering for SQL Server High Availability?

Abstract: When it comes to SQL Server high availability (HA), SQL Server Failover Cluster Instance (FCI) has been the standard since 1998 with the release of SQL Server 7. Dave Bermingham, Microsoft Cloud, and Datacenter MVP and former Cluster MVP, reviews what clusters are, why you should use them for high availability, discusses SQL Server FCI concepts and why it is an important part of your Mission Critical SQL Server deployment whether you run on-premises, in the cloud or in a hybrid cloud configuration.

Speaker(s):

David Bermingham

Track and Room: Enterprise Database Administration Deployment - H

Title: Building your First SQL Server Container Lab in Docker

Abstract: It wasn’t that long ago when virtualization changed the way we work with SQL and infrastructure. Now it’s all about containers. Containers can make the DBA’s job of creating and deploying servers much easier, freeing them up for other tasks such as performance tuning and security. In this session, we will go over the concepts of containers and their general capabilities. Then we will build, connect and configure a SQL Server in a container for use as a private lab.

Speaker(s):

Chris Bell

Track and Room: Enterprise Database Administration Deployment - C

Title: Master Data Management: BI and Data Science’s Best Friend

Abstract: No matter the complexity of your BI application, Master Data Management can provide your organization the tools needed to conform, manage and simplify your dimensions. Attend this session and learn how Analytical MDM can forge quicker and more valuable insights.

Speaker(s):

Tyler Graham

Track and Room: Enterprise Database Administration Deployment - E

Title: SQL Graph

Abstract: Graphs are everywhere! Microsoft has added a lot of new features to SQL Server 2017 (and 2019), and among them SQL Graph has been one - one that holds a lot of promises, though it’s still in its early stages (at least with Microsoft’s offering). Microsoft added SQL Graph features to their 2017 release, and has added support for MERGE (UPSERT) scenarios to ease insertions into edge tables, and Edge Constraints to apply restrictions on relationships between nodes in 2019 release (in CTP 2.0). In this session, we’ll take a look at what this feature brings to the table, and how it compares with other Graph databases.

Speaker(s):

Azhagappan Arunachalam

Track and Room: Application Database Development - B

Title: What is DevOps and Why Should DBAs Care?

Abstract: You may have heard the term “DevOps” a lot lately, but is this just one of those buzzwords that gets thrown around and means something different depending on who’s talking? While traditional software methodologies pit developers and operations folks like DBAs against each other, DevOps requires that they work together for a common goal. And, ultimately, shouldn’t the software project’s success be everyone’s goal? Attend this session to learn how DevOps is changing the DBAs world for the better.

Speaker(s):

Kathi Kellenberger

Track and Room: Enterprise Database Administration Deployment - F

Title: Power BI for Developers

Abstract: Learn how to integrate Power BI visuals and interactive reports into your own custom applications. This can create rich dashboards or client facing analytic solutions. We will look at API automation through the Azure PaaS embedded service and the development of custom visuals in TypeScript.

Speaker(s):

Bill Wolff

Track and Room: Analytics and Visualization - A

Title: Cool Data Warehousing – PART 2

Abstract: This is the advanced part 2 of Innovative Data Modeling. Learn how to leverage Master Data Management and Azure Technologies to extend your model for performance, history and reference unstructured data. We will explore how you can use continuous integration and delivery to further maximize value. Let’s look at platform specific techniques and also explore design options for Azure SQL Data Warehouse.

Speaker(s):

Leslie Weed

Track and Room: BI Platform Architecture, Development Administration - B

Abstract: TBD

Speaker(s):

Philadelphia SQL Server Users Group

Track and Room: Other - E

Title: In-Memory Capabilities – PART 2

Abstract: See the previous time slot for the description.

Speaker(s):

Kevin Goff

Track and Room: Application Database Development - A

Title: Intro to Azure for SQL Geeks

Abstract: Interested in using the Cloud for SQL Server? Wondering what is the cloud? Come find out what Cloud Computing is all about and why you might want to use it. We’ll introduce Microsoft’s Cloud, Azure, and talk about how it can be used for FREE! We’ll demonstrate creating Virtual Machines in the cloud that can run SQL Server (just like on premises) and we’ll also demonstrate creating SQL Servers in the Cloud using SQL Azure (no virtual machines required).

Speaker(s):

David Patrick

Track and Room: Cloud Application Development Deployment - G

Title: Tech Writing for Techies: A Primer

Abstract: Documentation is one of the most critical, yet most blatantly ignored and disrespected tasks when it comes to technology. Businesses and technical professionals ignore documentation at their own risk. This session discusses what tech writing and documentation is about and why it’s critical for business. It also explores possible reasons for why it’s ignored, how documentation can be improved, and how “non-writers” can contribute to the process.

Speaker(s):

Ray Kim

Track and Room: Professional Development - L

Abstract: TBD

Speaker(s):

Philadelphia SQL Server Users Group

Track and Room: Other - F

Title: Design like an ETL Master - SSIS Patterns and Advanced Techniques

Abstract: Ever wonder about becoming an ETL master using SSIS platform? Come to this session to learn some advanced techniques and design patterns that can be used in solving some day-to-day integration development challenges.

Speaker(s):

Daniel Cai

Track and Room: BI Platform Architecture, Development Administration - G

Title: to be announced

Abstract: Check the online schedule for updated details.

Speaker(s):

Philadelphia SQL Server Users Group

Track and Room: Other - D

Abstract: TBD

Speaker(s):

Philadelphia SQL Server Users Group

Track and Room: Other - H

Title: 42 TSQL Functions – PART 2

Abstract: See the previous time slot for the description.

Speaker(s):

Thomas Grohser

Track and Room: Application Database Development - K

Title: T-SQL Window Function Performance

Abstract: Window functions were first introduced with SQL Server 2005 and enhanced with SQL Server 2012. They enable easy development and great performance…well, sometimes. Learn what you need to know to take full advantage of these features. What you don’t know can hurt you when you are using window functions.

Speaker(s):

Kathi Kellenberger

Track and Room: Application Database Development - F

Speakers

This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

Chris Bell

Twitter: - @cbelldba

LinkedIn: Chris Bell

Contact: https://www.wateroxconsulting.com/

Chris Bell offers a unique view of how we live and work with data, both now and as we head into the future. Having braved many roles, lifecycles, and battles in the IT world, he has honed his DBA (Database Administration or Do ‘Bout Anything) skills in Information Systems and development, focusing on SQL Server. Currently, he serves as the lead DBA at The Motley Fool. You can keep up with Chris’ thoughts and technical community activities at WaterOxConsulting.com.

Vince Napoli

Twitter: - @Napoli_V

LinkedIn: Vince Napoli

Vince is a Data Warehouse and Business Intelligence Architect and has been his area of focus from 1996 to present. From the start of his career in 1987, he has been in Mainframe development and MVS technical support, System Testing, Data Warehousing / Business Intelligence architecture and development, and a SQL Server DBA / ETL developer / and database developer. He is a member of Professional Association of SQL Server(PASS), former president of the Philadelphia SQL Server User group (PSSUG), part of the PSSUG leadership since 2003 to the present, and was a member of the PASS program committee for the DW/BI track from 2003 to 2006. Vince has been a frequent presenter at local user group meetings, and SQLSaturday events.

Andrew Kelly

Twitter: - gunneyk

Contact: http://sqlblog.com/blogs/andrew_kelly/default.aspx

Andrew J. Kelly is a Senior Technical Subject Matter Expert with B3 Group Inc. and lives in Clarkdale, AZ. He has over 20 years experience with relational databases and application development, but his main focus now is SQL Server. In addition to general SQL Server training and mentoring, he specializes in performance, scalability, and maintainability of large-scale SQL Servers. He is a regular speaker at conferences and user groups and was a SQL Server / Data Platform MVP for 18 years.

Wayne Sheffield

Twitter: - @DBAWayne

LinkedIn: Wayne Sheffield

Contact: http://blog.waynesheffield.com/wayne

Wayne Sheffield, a Microsoft Certified Master in SQL Server and Microsoft Most Valuable Professional, started working with xBase databases in the late 80’s. With over 25 years in IT, he has worked with SQL Server (since 6.5 in the late 90’s) in various dev/admin roles, with an emphasis in performance tuning. He is the author of several articles at www.sqlservercentral.com, a co-author of “SQL Server T-SQL Recipes”, and enjoys sharing his knowledge by presenting at SQL events worldwide and blogging at http://blog.waynesheffield.com/wayne

Dominic Falso

Dominic is the Data Architect with The Reinvestment Fund in Center City Philadelphia. He has studied OO programming since 1995 and database software since 1999 (SQL Server since 2001). He currently works with SQL Server 2017 and .NET C#, doing data analysis and manipulation, as well as writing code management software.

David Bermingham

Twitter: - https://twitter.com/daveberm

LinkedIn: David Bermingham

Contact: http://clusteringformeremortals.com/

David Bermingham is recognized within the community as a high availability expert and has been honored by his peers by being elected to be a MVP in Clustering since 2010 and most recently has been recognized as a Cloud and Datacenter MVP. David’s work as technical evangelist at SIOS has him focused on evangelizing Microsoft high availability and disaster recovery solutions for both on premise and cloud deployments. He lives in New Jersey with his wife and three kids where he a school board member, scout leader and musical director of an 8-piece jazz band, M-Town.

Jason Brimhall

Twitter: - sqlrnnr

LinkedIn: Jason Brimhall

Contact: http://jasonbrimhall.info

Jason Brimhall has more than 20 years of experience and has worked with SQL Server 6.5 through SQL Server 2019. He has experience in performance tuning, high transaction environments, and large environments. He is currently a consultant specializing in performance tuning, server analysis, and problem resolution. Jason is a Microsoft Certified Master (MCM) and a Data Platform MVP.

Chris Hyde

Twitter: - ChrisHyde325

LinkedIn: Chris Hyde

Chris Hyde is a Microsoft Data Platform MVP and Microsoft Certified Trainer based in Albuquerque, New Mexico. He works as an independent SQL Server BI and DBA consultant, and is the leader of the Albuquerque PASS local user group. He is also part of the Friends of Redgate program and was a member of the Idera ACE class of 2018. He loves loud music and cricket, but usually not at the same time.

Matt Cushing

Twitter: - Sqlkohai

LinkedIn: Matt Cushing

Contact: http://sqlkohai.com

Matt started out his career in Accounting and quickly realized he liked data a whole lot more! Starting as a help desk associate, he’s moved through support, development, data, and management positions before settling back to his passion for data.

Currently working for Applegate Farms in NJ, he loves the people he works with and for, and the company as a whole. Thanks to the input and help from the SQL community, he was able to be ready for the right opportunity in his current position as a BI developer. He also teaches a Database Management class at Rutgers University.

Ask him about the Red Sox sometime if you want your ear talked off ;).

Jason Brimhall

Twitter: - sqlrnnr

LinkedIn: Jason Brimhall

Contact: http://jasonbrimhall.info

Thomas Grohser

LinkedIn: Thomas Grohser

Thomas Grohser has spent most of the past 26+ years exploring the deeper inner workings of SQL Server and its features while working for entertainment, pharmaceutical, and financial services industries. His primary focus is to architect, plan, build, and operate reliable, highly available, secure, and scalable infrastructures for SQL Server. Over the years he has managed thousands of SQL Server instances, processing trillions of rows, taking up petabytes of storage. Thomas has been a Microsoft Data Platform MVP for 9 years and has spoken regularly at conferences, SQLSaturdays, and user groups for 12 years.

Reinhard Flügel

Started as an application developer in the early 90’s using C++, Access and SQL-Server. Since around 2010 focusing on Database Development mainly SQL-Server. Holding several Microsoft certifications such as: MCSE Data Platform, Business Intelligence and Data Management and Analytics (Charter).

Chris Hyde

Twitter: - ChrisHyde325

LinkedIn: Chris Hyde

Jamey Johnston

Twitter: - STATCowboy

LinkedIn: Jamey Johnston

Contact: http://STATCowboy.com

Jamey Johnston is a Senior Data Scientist/Engineer for a large independent OG company. For over 25 years, he has worked for Fortune 500 companies architecting successful platforms in the cloud, on the edge, and on-premises for BI reporting, statistical analysis, ML, and AI. Lately, he spends his time in Azure, Python, R, Power BI, MS SQL, and SAS JMP. He holds a BS in Spatial Analysis from LSU and a Masters of Science in Analytics from Texas AM. He is a professor at the Mays Business School at Texas AM in the MS Analytics program. He is active in his PASS Local Group in Houston, co-leader of the local Power BI users group and data analytics group. He regularly speaks and volunteers at PASS events. He is also a Microsoft Data Platform MVP.

Tyler Graham

Twitter: - @codeswim

LinkedIn: Tyler Graham

With over 20 years experience in Data Management 6 Years at Microsoft One of the Original Designers of SQL Server Master Data Services Author - Master Data Services -SQL Server 2008R2 and 2012 6 Years at Profisee developing Industry Solutions

Wayne Sheffield

Twitter: - @DBAWayne

LinkedIn: Wayne Sheffield

Contact: http://blog.waynesheffield.com/wayne

Joe Wehr

Joe Wehr is a financial professional and educator with 40 years of experience. He is currently a Financial Educator at Clarifi and Instructor of Business and Entrepreneurial Initiatives at Montgomery County Community College. Previously Joe served as Director of Finance and Administration for Nike, Controller for Memorex Telex, and Sales Operations Manager for Western Digital.

Alex Grinberg

LinkedIn: Alex Grinberg

I have more than 20 years of IT experience. My primary focus is with the latest Microsoft technologies including .NET (VB and C#), SSRS and SSIS. I provide services in tuning, optimization, analysis and development for the creation of new applications, converting legacy technologies (SQL Server, VB.NET and C# ) and site training. I have worked for CSC, VerticalNet, IDP, LSAC , and TMNAS (to name a few) and I am currently employed with Cox Automotive. I am Apress author book “XML and JSON Recipes for SQL Server”, also wrote number of articles for Simple-Talk and SQLServerCentral.com

Linda Zhang

Linda Zhang-Cloud Solution Architect at Microsoft. Founder of Central New Jersey SQL User Group. Over 10 years experiences in data platform management, architecture, engineering On-Premises and Cloud.

Paresh Motiwala

Twitter: - pareshmotiwala

LinkedIn: Paresh Motiwala

Contact: https://pareshmotiwala.wordpress.com/wp-admin/post.php?post=2amp;action=editamp;message=6amp;postpost=v2

Paresh Motiwala a Azure/Big Data enthusiast, Manager of Database Platform teams has led several large SQL implementations, migrations and upgrades. He has managed multi terabyte OLTP databases. He has also been a Sr. SQL DBA and a Solutions Architect in Fortune 100 companies. He helps/organizes and speaks at many SQLSaturdays, Azure Bootcamp, Azure Datafests and User Groups(Boston BI UG, NESQL, PASS PD VG and PASS DBA VG).

He is certified in Big Data Analytics, FinTech, PMP, Public Speaking, Business Communications. He is a avid singer, cook, open networker, and stand-up comedian. He teaches public speaking, debating, interviewing and group discussion skills and mentors children around the globe via www.circlesofgrowth.com

Sebastian Meine

Twitter: - @sqlity

LinkedIn: Sebastian Meine

Contact: http://sqlity.net/en/blog/

Sebastian Meine, Ph.D. is the SQL Stylist behind sqlity.net llc. In 2010 he founded sqlity.net to fully engage in his passion for SQL Server. Armed with a Ph.D. in Computer Science and years of experience in architecting DBs for a global Fortune 50 company, Sebastian now provides training and consulting services for his clients, specializing in SQL Server Security, Test Driven Development and Performance. Sebastian is an experienced public speaker, published author, president of the Philly PASS Chapter, PASS Regional Mentor and coauthor lead developer of tSQLt.

Bill Wolff

Twitter: - https://twitter.com/billjwolff

LinkedIn: Bill Wolff

Contact: https://mvp.microsoft.com/en-us/PublicProfile/10864?fullName=Bill%20Wolff

Bill Wolff is an independent consultant, trainer, and architect specializing in Microsoft development technologies under the name Agility Systems. He ran the consulting firm Wolff Data Systems for 15 years and directed armies of consultants in the dot com world. Bill is founder and President of the philly.NET user group and involved in several other user communities. Bill is a 15 year Microsoft MVP in .NET and SQL.

Tracey Nelson

I’ve been a database administrator and developer since 1990. I’ve worked with Oracle, Sybase, and Sql Server databases. I’ve been with Aspect Consulting, Inc for a little over 6 months and I love the work! I enjoy meeting new people and working with different clients to help them solve their Sql server issues.

We can perform various audits on Sql Sever to help you find performance issue, security gaps, capacity issues, and backup and recoverability problems. Please visit our table in the vendor area.

Je’Anna Lanza-Abbott

Twitter: - @STATWonderWoman

LinkedIn: Je’Anna Lanza-Abbott

Dr. Je’Anna Lanza-Abbott holds the Spec’s Charitable Foundation Endowed Professorship in Social Responsibility at the University of Houston. She has a joint appointment with the Conrad N. Hilton College and the C.T. Bauer College of Business. She teaches primarily in the areas of hospitality business law, organizational behavior/conflict management, and negotiations. She has written multiple refereed articles in these areas, as well as two textbooks.

She has multiple advanced degrees including: JD and LLM from University of Houston (UH), MBA from University of Chicago, MS in Analytics from Texas AM and PhD in Management Science from UH Bauer College of Business.

Ravi Kumar

Twitter: - @sqlravi

I have over 12 years of experience working with SQL Server and Business Intelligence Technology. My current focus is cloud technologies: Power BI, Azure Analysis Services, Azure SQL Data Warehouse, Azure Data Factory. As a PFE at Microsoft, I regularly deliver 2 - 4 day training workshops.

Philadelphia SQL Server Users Group

Placeholder account for tbd sessions

Daniel Cai

Twitter: - danielcai

LinkedIn: Daniel Cai

Daniel Cai is a software developer specialized in SQL Server-based ETL integration development with various APIs and methodologies such as Microsoft Dynamics 365, data warehouse, etc. Daniel was a Dynamics 365 MVP for consecutive 8 years.

Kevin Goff

Contact: http://www.kevinsgoff.net

SQL Server/Data Platform MVP Microsoft MVP since 2005 Database Developer/Consultant/Writer/Speaker Regular columnist, CODE Magazine

Bill Wolff

Twitter: - https://twitter.com/billjwolff

LinkedIn: Bill Wolff

Contact: https://mvp.microsoft.com/en-us/PublicProfile/10864?fullName=Bill%20Wolff

Philadelphia SQL Server Users Group

Placeholder account for tbd sessions

David Bermingham

Twitter: - https://twitter.com/daveberm

LinkedIn: David Bermingham

Contact: http://clusteringformeremortals.com/

Wayne Sheffield

Twitter: - @DBAWayne

LinkedIn: Wayne Sheffield

Contact: http://blog.waynesheffield.com/wayne

John Miner

Twitter: - https://twitter.com/JohnMiner3

LinkedIn: John Miner

Contact: https://www.mssqltips.com/sqlserverauthor/154/john-miner/

John Miner is currently a Data Architect at BlueMetal advising corporations on how to solve their business needs with data platform solutions.

He has over twenty five years of data processing experience, and his architecture expertise encompasses all phases of the software project life cycle, including design, development, implementation, and maintenance of systems.

He has an undergraduate and graduate degrees in Computer Science from the University of Rhode Island. Other credentials include an up to date MCSE certificate and currently taking the Data Science program from EDX.

Before joining BlueMetal, John won the Data Platform MVP award in 2014 and 2015 for his outstanding contributions to the SQL Server community.

Ray Kim

Twitter: - PianoRayK

LinkedIn: Ray Kim

Contact: https://pianorayk.wordpress.com/

Ray Kim is an advocate for documentation and technical communication. He is a co-founder of the Albany, NY SQL group (CASSUG), a member of the AlbanyUX user group, and has spoken at numerous SQLSaturdays and at PASS Summit. He has worked various positions in technology, including as a developer, webmaster, analyst, technical writer, and instructor. He holds an MS in technical communication from Rensselaer Polytechnic Institute and a BS in computer science from Syracuse University.

A musician in his spare time, Ray plays four different instruments. He also enjoys going to ball games and doing CrossFit, and is a two-time SQLServerCentral.com fantasy football champion. He lives in Troy, NY with his wife, Lianne, and their two cats.

Philadelphia SQL Server Users Group

Placeholder account for tbd sessions

Daniel Cai

Twitter: - danielcai

LinkedIn: Daniel Cai

Bill Rosenbaum

Dedicated father, husband, friend, coach and information security professional. Passionate about the organization I work for and thankful for the opportunity it provides. I have worked in various roles in network infrastructure and information security. Currently act as principal IT security expert within MCCC, guiding executive decisions and planning across the institution.

David Patrick

Twitter: - DavidEPatrick

LinkedIn: David Patrick

Contact: http://www.madsharepoint.com

Dave has been developing database applications for over 25 years. An MCT since 2001, he has taught many classes from Intro to Visual Interdev to Advanced SharePoint Development. Dave runs two user groups, the Maryland and Pennsylvania Microsoft Developers User Group, www.mapamdug.com, and MAD SharePoint, www.madsharepoint.com. Dave does SharePoint training and development for DSA, Inc., a DoD contractor that does great work for the Army over at Aberdeen Proving Ground. Dave is also an MVP.

Philadelphia SQL Server Users Group

Placeholder account for tbd sessions

Andy Yun

Twitter: - SQLBek

LinkedIn: Andy Yun

Contact: http://sqlbek.wordpress.com

Andy Yun is a SentryOne Principal Solutions Engineer and a former Microsoft MVP. He has been working with SQL Server for nearly 20 years as both a Database Developer and Administrator. Leveraging knowledge of SQL Server Internals and extensive experience in highly transactional environments, he strives to make T-SQL leaner and meaner. Andy is extremely passionate about passing knowledge onto others, regularly speaking at User Groups, SQLSaturdays, and PASS Summit. Andy is a co-founder of the Chicago SQL Association, co-Chapter Leader of the Chicago Suburban User Group, and part of the Chicago SQLSaturday Organizing Committee.

Joshua Lynn

Contact: http://www.pocketjoshua.com/sql

Joshua Lynn started programming databases when he was 14. Professionally, he has been in the IT industry since 1991 specializing in database design, ETL, and change detection. His experience with SQL server goes back to version 6.5 where he thought triggers were neat. Currently, he is still working on doing useful things with SQL server and believes CTEs have enhanced his professional life. In his spare time, he mentors high school students in building robots. He is also an advocate for Deadlock victims’ rights.

Joshua Lynn

Contact: http://www.pocketjoshua.com/sql

Kathi Kellenberger

Twitter: - auntkathi

LinkedIn: Kathi Kellenberger

Contact: http://auntkathisql.com

Kathi Kellenberger is the editor of Simple Talk at Redgate and a Data Platform MVP. She has worked with SQL Server for over 20 years and has authored, co-authored, or tech edited over a dozen technical books. Kathi is the co-leader of the PASS Women in Technology Virtual Group and a volunteer at LaunchCode. When Kathi isn’t working, she enjoys spending time with family and friends, cycling, singing, and climbing the stairs of tall buildings. Be sure to check out her courses on Pluralsight.

Philadelphia SQL Server Users Group

Placeholder account for tbd sessions

Gabriel Villa

Twitter: - @extofer

LinkedIn: Gabriel Villa

Contact: https://extofer.wordpress.com/

Gabriel is a skilled leader, architect, and technical expert focusing primarily on Microsoft technologies and is passionate about open-source technologies for integration, automation, and development. Gabriel’s versatility extends from systems, data and development and leverages hybrid/SaaS/Cloud integration, proven software engineering platforms, and best-of-breed data management and business intelligence solutions.

Originally from El Paso, Texas, Gabriel lives in Colorado Springs with his wife and kids, where he is an Architect for RevGen Partners, volunteers in the tech community and enjoys the Colorado outdoors.

John Miner

Twitter: - https://twitter.com/JohnMiner3

LinkedIn: John Miner

Contact: https://www.mssqltips.com/sqlserverauthor/154/john-miner/

John Miner is currently a Data Architect at BlueMetal advising corporations on how to solve their business needs with data platform solutions.

Before joining BlueMetal, John won the Data Platform MVP award in 2014 and 2015 for his outstanding contributions to the SQL Server community.

Philadelphia SQL Server Users Group

Placeholder account for tbd sessions

Kevin Goff

Contact: http://www.kevinsgoff.net

SQL Server/Data Platform MVP Microsoft MVP since 2005 Database Developer/Consultant/Writer/Speaker Regular columnist, CODE Magazine

Azhagappan Arunachalam

Az Arunachalam has been working with SQL server since v4.21/SQLNT. He started his career with troubleshooting at chip level, worked as a network engineer managing Novell NetWare networks, graduated into managing Windows NT, moved onto development, administered databases, and is currently working as a database architect. He#39;s excited about all the cloud offerings that Microsoft and others have made possible, and in sharing his findings with aspiring data enthusiasts.

Dan Clark

LinkedIn: Dan Clark

Contact: http://drclarkblog.wordpress.com/

Dan Clark is a senior data analytics consultant. He is focused on all things data analytics and training others how to get value from their data. Dan has published several books and numerous articles on .NET programming and data analytics. He is a regular speaker at various developer and database conferences and user group meetings and enjoys interacting with the Microsoft developer and database communities. His latest book Beginning Power BI published by Apress is a will get you up and running with self-service data analytics on the Power BI platform in no time.

Philadelphia SQL Server Users Group

Placeholder account for tbd sessions

Andy Yun

Twitter: - SQLBek

LinkedIn: Andy Yun

Contact: http://sqlbek.wordpress.com

Tim Corey

Twitter: - @IAmTimCorey

LinkedIn: Tim Corey

Contact: http://www.epicross.com

Tim is a Microsoft MVP whose goal is to make learning software development easier. If you are struggling with learning C#, SQL, or the related technologies, he wants to help.

Leslie Weed

Twitter: - @weederbug

Leslie Weed is currently a Data and BI Architect with RevGen Partners in Denver, CO. She has been a SQL Professional specializing in Business Intelligence, data analytics, systems implementation, integration, and solutions delivery for the last 20ish years, including a variety of Enterprise Data Warehouses in various industries.

Leonard Lobel

Twitter: - @lennilobel

LinkedIn: Leonard Lobel

Contact: http://lennilobel.wordpress.com

Leonard Lobel (Microsoft MVP, Data Platform) is CTO and co-founder of Sleek Technologies, Inc., a New York-based development shop with an early adopter philosophy toward new technologies. He is also a principal consultant at Tallan, Inc., a Microsoft National Systems Integrator and Gold Competency Partner.

Programming since 1979, Lenni specializes in Microsoft-based solutions, with experience that spans a variety of business domains, including publishing, financial, wholesale/retail, health care, and e-commerce. Lenni has served as chief architect and lead developer for various organizations, ranging from small shops to high-profile clients. He is also a consultant, trainer, and frequent speaker at local usergroup meetings, VSLive, SQL PASS, and other industry conferences.

Lenni has also authored several MS Press books and Pluralsight courses on SQL Server programming.

Leslie Weed

Twitter: - @weederbug

Sarah Patrick

Twitter: - sarahepatrick

LinkedIn: Sarah Patrick

Sarah has presented at several TechGirlz workshops for the Boys and Girls Club of Harford County, as an advocate for women in STEM. Sarah graduated from the Science and Mathematics Academy in Aberdeen, MD in May 2018, where she presented her senior capstone project “Engineering peer credibility via mastery of roles,” where she designed roles for an ad hoc team. She worked with an army professional from CERDEC. She is currently attending the University of Maryland - College Park to major in Information Science. Sarah completed an internship with the Project Management Institute, helping them with their Professional Development Event, and worked as at the SharePoint Intern at Smithsonian Institution’s Office of the Chief Information Officer.

Alex Grinberg

LinkedIn: Alex Grinberg

Chris Bell

Twitter: - @cbelldba

LinkedIn: Chris Bell

Contact: https://www.wateroxconsulting.com/

Jeff Renz

Twitter: - jeff_renz

LinkedIn: Jeff Renz

Contact: http://www.revgen.com

Jeff Renz is a Senior Architect at RevGen Partners, currently working as the design architect and implementation lead on several projects for a Fortune Top 50 company. Jeff has worked with SQL Server and BI for 15+ years and has 10 years’ experience with data warehouse design and implementation. In addition to consulting, he is joining the University of Denver adjunct faculty and is expected to begin teaching in the ICT program starting in June. He received his bachelor’s degree in Computer Science, his master’s degree in Operations Research from Colorado School of Mines, and will be graduating from the Harvard Business Analytics Program in December.

Paresh Motiwala

Twitter: - pareshmotiwala

LinkedIn: Paresh Motiwala

Contact: https://pareshmotiwala.wordpress.com/wp-admin/post.php?post=2amp;action=editamp;message=6amp;postpost=v2

Slava Murygin

Twitter: - SlavaSQL

LinkedIn: Slava Murygin

Contact: http://slavasql.blogspot.com/

Started working with SQL Server 7.0 as DBA and Developer. Since then went through all SQL Server versions, migrations and multiple companies of different sizes and industries. Currently working as a contractor with all aspects of SQL Server, including, but not limited to: troubleshooting performance, designing/developing: databases, systems, processes, data warehouses, cubes, reports, ETLs; Refactoring old code; Migrating data from other systems to SQL Server; Securing the data on enterprise level.

Philadelphia SQL Server Users Group

Placeholder account for tbd sessions

Thomas Grohser

LinkedIn: Thomas Grohser

Kathi Kellenberger

Twitter: - auntkathi

LinkedIn: Kathi Kellenberger

Contact: http://auntkathisql.com

SQLSaturday #835 - Philadelphia 2019

Sessions

Title: Make Your Maintenance Plans Better and Faster

Title: An Introduction to Data Science with Python for Data Professional

Title: BI Infrastructure in Azure: Points to Consider

Title: High Availability and Disaster Recovery for SQL Server in Azure IaaS

Title: Power BI In a day Hands-On

Title: Python in SQL Server 2017

Title: Self-Service ETL with Power Query

Title: Effective Data Warehouse Storage Patterns

Title: Data Profiling or Statistics 201

Title: Introduction to Azure Cosmos DB

Title: Entrepreneurship - Are you ready to make it on your own?

Title: Staging data for Azure SQL services

Title: Introduction to the R Programming Language for BI Professionals

Title: Advanced T-SQL Development with latest features.

Title: Build a White/Blacklist Bouncer. Who Gets into Your SQL Club?

Title: Black Belt for DBA with Advanced Technologies.

Title: Practical Monitoring of TempDB

Title: Code Like a Snake Charmer - Intro to Python and Data Science Tools in MS

Title: Constructive Conversations Getting Unstuck by Being Supportively Outspoken

Title: Making Peace with SQL Server Integration Services - Part II Useful Sophistication A Reluctant User’s

Title: Advanced Indexing for Accidental DBAs

Title: Dive into Amazon Web Services Databases

Title: Innovative Data Modeling: Make Data Warehousing Cool Again Part 1

Title: The Anatomy of Select

Title: Intelligent Query Processing

Title: Murder They Wrote

Title: DELL - Sponsor Session

Title: Supercharge your ETL Development with Advanced SSIS Components

Title: Anexinet - Sponsor Session

Title: T-SQL Tips Tricks to Make Your Life Easier!

Title: Different Azure SQL PaaS options

Title: Varigence - Sponsor Session

Title: Going Beyond Monitoring With SentryOne

Title: In-Memory Capabilities in SQL Server

Title: Intro to CosmosDB

Title: Beginner’s Guide for Creating Maintenance Plans

Title: Making Peace with SQL Server Integration Services - Part I Getting Started A Reluctant User’s Guide

Title: Possiblities and Limitations of System-Versioned Temporal Tables beyond the Basics

Title: SQL Development, Source Control, and Deployment with SSDT

Title: Securing and Managing access to your DW data

Title: Extended Events - Better than Profiler

Title: Networking 101: Getting Ready for a SQL Event

Title: SSMS Tips and Tricks

Title: Case Study: How I used SharePoint, Flow, PowerApps, and Forms to build a Speaker Database

Title: 42 TSQL Functions

Title: MC3 TechDay Escape Room for All!

Title: Dynamic SQL at Design-time

Title: Aspect Consulting - Sponsor Session

Title: Why Clustering for SQL Server High Availability?

Title: Building your First SQL Server Container Lab in Docker

Title: Master Data Management: BI and Data Science’s Best Friend

Title: SQL Graph

Title: What is DevOps and Why Should DBAs Care?

Title: Power BI for Developers

Title: Cool Data Warehousing – PART 2

Title: RevGen Partners - Sponsor Session

Title: In-Memory Capabilities – PART 2

Title: Intro to Azure for SQL Geeks

Title: Tech Writing for Techies: A Primer

Title: Profisee - Sponsor Session

Title: Design like an ETL Master - SSIS Patterns and Advanced Techniques

Title: to be announced

Title: Sios - Sponsor Session

Title: 42 TSQL Functions – PART 2

Title: T-SQL Window Function Performance

Speakers

Sponsors