SQLSaturday #912 - New York City 2019

Event Date: 10/05/2019 00:00:00

Event Location:

Microsoft New York Metro District Office
11 Times Square
New York City, New York

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: T-SQL Window Function Deep Dive

Abstract: Join this session and learn everything you need to know about T-SQL windowing functions!

SQL Server 2005 and later versions introduced several T-SQL features that are like power tools in the hands of T-SQL developers. If you aren’t using these features, you’re probably writing code that doesn’t perform as well as it could. This session will teach you how to avoid cursor solutions and create simpler code by using the windowing functions that have been introduced between 2005 and 2012. You’ll learn how to use the new functions and how to apply them to several design patterns that are commonly found in the real world.

You will also learn what you need to know to take full advantage of these features to get great performance. We’ll also discuss which features perform worse or better than older techniques, what to watch out for in the execution plan, and more.

Speaker(s):

Kathi Kellenberger

Track and Room: Application Database Development - C

Title: SQL DevOps Simplified with Production Databases

Abstract: DevOps is based on building an application binary (immutable artifact) that supports a highly reliable, repeatable engineering process. In the case of SQL Server, however, a database is already in production, and isn’t simply replaced (as an app binary), but is upgraded. Current SQL Server DevOps methods use source control to build a “development” database, with schema and objects and static data needed for functional testing. “Near production data” is used in Staging, and finally production is upgraded. This approach involves complexity, and breaks the principle of working with immutable artifacts throughout the process. Our session introduces a new approach to SQL Server DevOps, with production databases used in all stages. Production database clones are delivered more quickly than “built” databases, are more easily integrated with source control, and produces higher fidelity outcomes. Learn how leading enterprises are simplifying SQL DevOps.

Speaker(s):

Paul Stanton

Track and Room: Application Database Development - B

Title: Persistent Memory and Hybrid Buffer Pool - The good, bad and ugly

Abstract: SQL Server 2019 will introduce us to a new feature called Hybrid Buffer Pool. The ability of placing database files into “Memory” that does not lose its content in case of a power outage. This session will explore when it makes sense to use this feature and when not to use it.

Speaker(s):

Thomas Grohser

Track and Room: Database Administration / Infrastructure - D

Title: Predictive Analytics with R in Power BI

Abstract: Power BI reports are typically used for descriptive analysis: a historical look of what has happened. But what if your report could visualize what is likely to happen and recommend what you can do about it now? This session will cover how to shift from descriptive to predictive analysis and leverage the power of machine learning to enhance your business intelligence solutions. The basics and best practices of predictive modeling will be introduced, and these concepts will be applied to create three predictive models in R using three different techniques. We will then walk through the three different ways to integrate the predictive power of these models into a Power BI report.

Speaker(s):

Joseph Yeates

Track and Room: Data Visualization/BI/Reporting/Analytics - H

Title: How to build your career

Abstract: In three years I went from a complete unknown to a popular blogger, speaker at PASS Summit, a SQL Server MVP, and then joined Microsoft. Along the way I saw my yearly income triple. Is it because I know some secret? Is it because I am a genius? No! It is just about laying out your career path, setting goals, and doing the work.

I’ll cover tips I learned over my career on everything from interviewing to building your personal brand. I’ll discuss perm positions, consulting, contracting, working for Microsoft or partners, hot fields, in-demand skills, social media, networking, presenting, blogging, salary negotiating, dealing with recruiters, certifications, speaking at major conferences, resume tips, and keys to a high-paying career.

Your first step to enhancing your career will be to attend this session! Let me be your career coach!

Speaker(s):

James Serra

Track and Room: Personal / Professional Development - L

Title: Whacha just say? Talking technology to non-technical people

Abstract: Many tech professionals are faced with the challenge of explaining technical concepts to people who don’t understand technology. And only a few are able to do it well. This session provides some strategies and suggestions to go about bridging the technological knowledge gap. With time and practice, a technical person can serve as an effective interpreter of technical concepts. This is an interactive session; audience participation is expected and encouraged!

Speaker(s):

Ray Kim

Track and Room: Personal / Professional Development - J

Title: SQL Server Reporting Services 2017 on Steroids!!

Abstract: Reporting requests that are required ‘yesterday or sooner’, oft times necessitate working more efficiently and effectively. We have all been through this at one time or another. In this hands on presentation we shall be looking some of the more challenging techniques of extracting our data from our Multidimensional and Tabular Models, in addition to our Data Mining Models. We shall be utilizing concepts of ‘Openquery()’ and ‘linked servers’ as a means to extract data, in addition to looking at the way that these two concepts can help us extract our data utilizing MDX, DMX and DAX expressions; AND YET maintain the flexibility and the ability to utilize all those wonderful techniques that may be done with T-SQL.

Speaker(s):

Steve Simon

Track and Room: Data Visualization/BI/Reporting/Analytics - C

Title: Back to the Future: Accelerating the Cloud Migration of Legacy SSIS with Azure Data Factory

Abstract: This session focuses on the new features to unblock/accelerate cloud migration of legacy SSIS, such as 2008 or earlier versions, with Azure Data Factory (ADF). We will first show you how to provision Azure-SSIS Integration Runtime (IR) – dedicated ADF servers for running SSIS – and extend it with custom/Open Source/3rd party components. We will next show you how to enable the following scenarios: running SSIS packages stored in file shares as first-class activities in ADF pipelines, accessing Azure SQL DB/Managed Instance with OLEDB/ADO.NET connectors configured for Azure Active Directory authentication with ADF managed identity, configuring SSIS IR to access data on premises using Windows authentication and Virtual Network injection/Self-Hosted IR as a proxy, running/debugging SSIS packages in ADF from SSDT, scheduling SSIS jobs in ADF from SQL Server Agent/3rd party orchestrators that invoke Azure-enabled dtexec.exe command line utility, etc.

Speaker(s):

Sandy Winarko

Track and Room: Data Ware House Development / ETL / SSIS - F

Title: “Schadenfreude” - Let’s enjoy the mistakes other people made…

Abstract: This session will show a lot of things in the world of data that went very, very wrong… And yes you are welcome to have a laugh at the misfortune of other people (or as the german speaking population would call it: Let’s have some “Schadenfreude”! After a log day, come in and have some fun before the evening event starts

Speaker(s):

Thomas Grohser

Track and Room: Other - A

Title: Networking 102: 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: Personal / Professional Development - E

Title: The DBA Quit and Now You’re It: Action Plan

Abstract: The only DBA at your company just quit and your boss storms into your office and says “You do data stuff, right? You’re our new DBA!” Congratulations, I guess? You may have been a report developer or data developer but you’re a DBA now too - what should you do? Join me as we walk through a checklist for your first few days as a DBA. We’ll make sure the security basics are handled, we’ll make sure backups and maintenance are squared away, we’ll make sure you know and understand how your server is performing, and we’ll make sure this accidental promotion becomes a path to learning and growth and not sleepless nights and panic attacks.

Speaker(s):

Matt Gordon

Track and Room: Database Administration / Infrastructure - H

Title: Distributed Availability Groups - How to

Abstract: Would you like to increase your AG functionality and make it work cross-domains? Would you like your AG to receive data from other AG? In this section lets dive into the basics of the Distributed AGs, what they can do for you and what kind of scenarios we can apply them to.

Speaker(s):

Marcelo Adade

Track and Room: Database Administration / Infrastructure - F

Title: Azure-d Availability: SQL Server HA In and To the Cloud

Abstract: Has your manager come to you and said “I expect the SQL Server machines to have zero downtime?” Have you been told to make your environment “Always On” without any guidance (or budget) as to how to do that or what that means? Are you facing pressure to have data in Azure as well? Help is here! This session will walk you through the high availability options in on-premises SQL Server, the high availability options in Azure SQL Database and Managed Instances, and how some or all of those can be combined to enable you to achieve the ambitious goals of your management. Beyond the academic knowledge, we’ll discuss frequently seen scenarios from the field covering exactly how your on-premises environments and Azure services can work together to keep your phone quiet at night.

Speaker(s):

Matt Gordon

Track and Room: Database Administration / Infrastructure - E

Title: Exploring SQL Server containers on Docker Kubernetes

Abstract: In this session, we will explore the options we have when working with SQL Server running on Docker containers or Kubernetes. Also, will take a look at some real-world scenarios of backing up \ restoring databases in containers, high availability, version upgrades, and the most important portability. Join me to discuss further about this interesting topic that is called by some experts as “The Future of Database Infrastructure”.

Speaker(s):

Carlos Robles

Track and Room: Strategy and Architecture - E

Title: Implementing Security Standard Regulations in SQL Server Azure

Abstract: PCI-DSS, SOX, ISO, GDPR, HIPAA… What are the Cyber Standard regulation and how do we implement them in SQL Server? In this session I will cover the main security regulations and will discuss the security configuration required to comply with each one of them, in Windows and SQL Server.

Speaker(s):

Michelle Gutzait

Track and Room: Data Governance/Privacy/Auditing/Documentation - I

Title: Networking 101: Building professional relationships

Abstract: Networking. You keep hearing that word throughout your career development, but you don’t know much about it, much less, how to do it. You want to connect with technical and data professionals, so you attend events such as SQLSaturday and your local user group. But what about your book club, your gym, your church group, or your kid’s soccer game? Those are prime — and overlooked — opportunities to network!

In this interactive session, we will discuss networking — what it is, why it’s important, and where opportunities exist. You will even have an opportunity to practice networking within the confines of our room. You might even leave this session with new networking contacts that you didn’t previously have!

Speaker(s):

Ray Kim

Track and Room: Personal / Professional Development - E

Title: Easing the pain of database migrations, a closer look at the new cloud citizen - DMS

Abstract: An essential part of migrating your application workload to the cloud is how to transfer your data securely to its new home. If you in addition want to change the underlying database system, for instance Oracle to SQL Server, it can quickly escalate to an overwhelming task. What if your application have a very high uptime requirement and your database is so large that you don’t have a downtime window long enough to do a traditional backup/restore operation? In order to overcome these pain points we have now available, both in Azure and AWS, services and tools that alleviate these pains and brings your valuable data safely across with near-zero downtime.

In this talk we will:

Guide you through how to set up a migration process with checks and balances
Compare the schema analysis and conversion tools provided by AWS and Microsoft
Compare the migration services provided by AWS and Azure
Demonstrate near-zero-downtime migration for a live database on AWS and Azure

Speaker(s):

Rune Ovlien Rakeie

Track and Room: Data and the Cloud - K

Title: New features in Management Studio – Performance Troubleshooting made easier!

Abstract: SQL Server Management Studio (SSMS) is now updated each month with the latest version of the SQL Client Tools. Which enabled rapid enhancement to Execution Plan.

Do you know that you can now see how many pages are spilled to disk for a sort, as well as the memory statistics for the operator? Are you aware that you can see the top 10 waits for an execution and what trace flags were active during compilation and which ones influenced compilation? Have you ever analyzed a big plan and wish you could search for table name, index name or column name without opening XML plan? When you see a clustered index was used do you know for sure which statistics were used by the Query Optimizer to estimate the number of rows?

In this demo intensive session, I will show you how to find and use new features introduced into SSMS and Showplan. You will walk out of this session equipped to make Query Performance Troubleshooting easier and ready to tackle those nasty, hard to solve query plans.

Speaker(s):

Taiob Ali

Track and Room: Tools Utilities - A

Title: SQL Server Availability Groups for dummies

Abstract: Availability Groups have become Microsoft’s default high availability and scalability go-to solution for SQL Server, but due to their relative complexity is often misunderstood, or worse, feared.

In this session, we will explain how to plan for, deploy, and manage Availability Groups from the ground up in easy to understand examples and demos.

We will cover both Basic Availability Groups (BAGs) and full deployments, and also cover their use in Windows and Linux environments as well as look at the new SQL Server 2019 availability group support on containers in a Kubernetes cluster.

If you want to finally get to grips with SQL Server Always On Availability Groups, then this is the session for you!

Speaker(s):

Mark Broadbent

Track and Room: Database Administration / Infrastructure - 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: Database Administration / Infrastructure - F

Title: PaaSport to Paradise: Lifting Shifting with Azure SQL Database + SSIS in Azure Data Factory

Abstract: This session focuses on the all PaaS solution of Azure SQL DB/Managed Instance (MI) + SSIS in Azure Data Factory (ADF) to lift shift, modernize, and extend ETL workflows. We will first show you how to provision Azure-SSIS Integration Runtime (IR) – dedicated ADF servers for running SSIS – with SSIS catalog (SSISDB) hosted by Azure SQL DB/MI, configure it to access data on premises using Windows authentication and Virtual Network injection/Self-Hosted IR as a proxy, and extend it with custom/Open Source/3rd party components. We will also show you how to migrate SSIS packages + jobs using Data Migration Service and use the familiar SSDT/SSMS tools to manage them in the cloud just like you do on premises. We will next show you how to modernize your ETL workflows by invoking/scheduling SSIS package executions as first-class activities in ADF pipelines and combining/chaining them with other activities, allowing you to automatically (de)provision SSIS IR just in time, etc.

Speaker(s):

Sandy Winarko

Track and Room: Data Ware House Development / ETL / SSIS - C

Title: Version control with GIT for the DBA

Abstract: In 2005, Linus Torvalds developed the version control system (VCS) git. Since then, it has become as platform agnostic and ubiquitous as the internet. Microsoft has fully embraced Git. It powers modern on premise and cloud versions of TFS (now know as Azure Devops) as well GitHub, which Microsoft recently acquired.

What does this mean to a DBA? Whether or not you use SSDT, you should be storing your database schema in version control. In addition, your utility scripts certainly belong in VCS.

In my session. We’ll cover:

Why should I store my schema in SSDT to help prevent developers from using code first ORMs. What is version control? How does a distributed version control system differ from traditional version control like Visual Sourcesafe, TFS, and SVN? How do I setup git for internal use in my company? How do I host public and private repositories on github. How do pull requests work? We will be covering using git from both the command line and Visual Studio.

Speaker(s):

Justin Dearing

Track and Room: Application Database Development - J

Title: Creating efficient and effective SSRS BI Solutions

Abstract: SQL Server 2017: With the vast amounts of data in today’s business warehouses, there has been increased demand on the Business Intelligence solution developer to produce more complex and all inclusive reporting facilities. More complexity, coupled with being all inclusive tends to yield more points of failure.In this hands on presentation we shall be examining new and innovative ways of rendering the required data in some unusual ways.

Speaker(s):

Steve Simon

Track and Room: Data Ware House Development / ETL / SSIS - C

Title: SQL Server in the Cloud: Microsoft Azure vs Amazon Web Services (AWS)

Abstract: Migrating SQL Server to the Cloud or already there? Trying to decide which of the two leading Cloud Providers is best for your SQL Server solution? Using one, but always wondered about the other? What about using both for HA/DR? On the surface, the differences aren’t immediately obvious, and several offerings parallel one another. We will review the various options for deploying SQL Server in both Azure and AWS, then dig under the covers on storage and performance to ensure the solution fits your needs. This session will benefit everyone from the beginner to the advanced professional.

Speaker(s):

Darius Liktorius

Track and Room: Data and the Cloud - B

Title: Power BI for absolute beginners

Abstract: Power BI is an environment consisting of several reporting tools and platforms each utilizing different languages and capabilities for data modeling, data insights and report sharing. If you are new to the world of Power BI, this can all get a little overwhelming and leave you feeling confused and frustrated.

This session is designed to get you started writing beautiful reports and dashboards as quickly as possible. We will first lay the groundwork explaining how the whole Power BI stack hangs together, for both on-premises and cloud services and tools, and how you can use them to share your reports.

Next, we will focus specifically on how you utilize those reporting tools to create beautiful reports, dashboards, and paginated reports.

By the end of this session, you will be comfortable connecting to remote data sources, creating your data model, and designing and publishing your first Power BI reports and dashboards.

Speaker(s):

Mark Broadbent

Track and Room: Data Visualization/BI/Reporting/Analytics - B

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: Personal / Professional Development - J

Title: Unexplored Features of SQL Server

Abstract: Every new version of SQL Server adds new features, some of these features are rarely talked about. Join me in this practical session to learn about some of the uncommon but useful features and data types of SQL Server. We will start with exploring hierarchid, geometry and geography data types of SQL Server. We will look at the Temp tables and find a way to cache Temp tables for a better performance. We will cover sparse, rowversion columns and finish the session by showing a way to remove ORM from web applications by using JSON functions of SQL Server.

Speaker(s):

Hasan Savran

Track and Room: Application Database Development - I

Title: Building a modern data warehouse

Abstract: Embarking on building a modern data warehouse in the cloud can be an overwhelming experience due to the sheer number of products that can be used, especially when the use cases for many products overlap others. In this talk I will cover the use cases of many of the Microsoft products that you can use when building a modern data warehouse, broken down into four areas: ingest, store, prep, and model serve. It’s a complicated story that I will try to simplify, giving blunt opinions of when to use what products and the pros/cons of each.

Speaker(s):

James Serra

Track and Room: Data Ware House Development / ETL / SSIS - L

Title: Top FREE performance troubleshooting tools for SQL Server

Abstract: Many DBAs and IT professionals are not aware of the greatness and strength of some of the FREE performance tools that are out there! Those tools, used individually or combined, can help us improve performance significantly by assisting in identifying bottlenecks. In this session I will discuss the top FREE Performance Troubleshooting tools for Windows and SQL Server and will show how to use them, also providing real-world examples.

Speaker(s):

Michelle Gutzait

Track and Room: Database Administration / Infrastructure - I

Title: What is kusto query language?

Abstract: As data professionals makes progress in their migration to cloud, we are learning new ways to monitor and alert on resources and services. Microsoft has consolidated many services under the umbrella ‘Azure Monitor’. One of the primary sources of monitoring is ‘Azure Monitor logs’ (which is also knows as Log Analytics). Azure Monitor logs are built on Azure Data Explorer which uses the Kusto query language. Going forward, the Kusto language should be your primary resource for querying the Azure Monitor log. In this demo intensive session, I will show you some ‘getting started’ tips and a few sophisticated queries using Kusto.

I have invested a lot of effort and received expert advice from Microsoft Engineers in learning how to work with Azure Monitor Log. Sharing what I have learned is going to save time and effort for anyone that will be responsible for managing resources in Azure.

Speaker(s):

Taiob Ali

Track and Room: Data and the Cloud - J

Title: Top Tips for Deploying AGs and FCIs On Premises or In the Cloud

Abstract: There are three main ways to deploy Always On Availability Groups (AGs) and Always On Failover Cluster Instances (FCIs) - physical hardware, virtualized, and IaaS in the public cloud. Starting with SQL Server 2017, we now also have the ability to use Windows Server or Linux. While some things are the same, each of the possible permutations and combinations affect how you plan, deploy, and administer AGs and FCIs. This session cuts right to the chase and will give you top tips and tricks for successfully deploying and administering AGs and FCIs so you can be an availaility hero no matter where you are deploying or what operating system you are using.

Speaker(s):

Allan Hirt

Track and Room: Database Administration / Infrastructure - B

Title: Data Virtualization with PolyBase

Abstract: PolyBase is Microsoft’s data virtualization technology, allowing you to integrate SQL Server with external systems such as Hadoop and Azure Blob Storage. As of SQL Server 2019, PolyBase also allows you to connect to diverse systems such as Oracle, MongoDB, Cosmos DB, Teradata, Apache Spark, and even other SQL Server instances. In this talk, we will walk through the mechanics of PolyBase, showing how we can write T-SQL queries to access data from heterogeneous sources. We will investigate the Dynamic Management Views (DMVs) and other resources needed to tease out what the PolyBase engine is doing behind the scenes and where to go when things break down. Finally, we will look at several interesting use cases for PolyBase in the modern data environment.

Speaker(s):

Kevin Feasel

Track and Room: Application Database Development - B

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 - J

Title: Power BI Live Data sets, Monitoring your key metrics

Abstract: In this session we will explore options in PowerBI to stream real-time data to the service. Differences between pushing, streaming and PubNub streaming will be explained and we will dive deep into each of the three methods. Join this session so learn how to get live data into your PowerBI service. The session will be covering basic entry to best practices.

Speaker(s):

Jens Vestergaard

Track and Room: Data Visualization/BI/Reporting/Analytics - K

Abstract: Abstract:

Many corporations are composed of small divisions located in countries throughout the world. While you might be the lead DBA for your corporation, there are several other employees who have the keys to the kingdom. This presentation will review techniques on how to prevent and/or audit data and schema changes.

Coverage:

1 – Granting correct user access is vital. 2 – DML triggers to keep a DATA audit trail. 3 – DDL triggers to keep a SCHEMA audit trail. 4 – Preventing unwanted DATA modifications. 5 – Preventing unwanted SCHEMA changes. 6 – Preventing table TRUNCATIONS. 7 – LOGIN triggers to control who, what, and when. 8 – Change data capture (CDC) an alternative to triggers. 9 - Which of these techniques apply to an Azure SQL database?

Speaker(s):

John Miner

Track and Room: Application Database Development - J

Title: PowerBI and PowerApps Married at First Sight

Abstract: PowerBI is Microsoft’s self service reporting tool that give businesses a robust visualization of their data. As Microsoft’s Power Platform has evolved, PowerApps is taking a similar approach by providing businesses with a self service application tier. In this session we will see the power of bringing the two together. Let’s explore how the visualization tier of PowerBI can enhance the development and capabilities of PowerApps. We will go from a blank canvas app and import visualizations while pointing out some of the pros and cons of marrying the two together. We will use the capabilities of PowerApps to write and update our SQL Server tables. Bringing the two together can provide businesses with a robust solution under one umbrella. Join me in learning how these two services came together and said “I DO”.

Speaker(s):

Dan King

Track and Room: Data Visualization/BI/Reporting/Analytics - G

Title: Approaching Zero: Minimizing Downtime During Deployments

Abstract: Negotiating a downtime for a release can be difficult in this modern, 24x7 world. When downtime means lost revenue, the price of taking a downtime to deploy code can run up quickly. This talk will show you a way to reduce the cost of deployment by reducing or even eliminating required downtime for database code deployment. We will show how to release new database code, update existing stored procedures, refactor and restructure tables, and even perform systemic re-architecture with no downtime and minimal blocking. We will use as a case study one release in which we modified the primary key column on 180 tables and updated over 550 stored procedures without end users noticing a thing. If you want to hit that three nines (or better) service-level agreement, this talk will help get you on the road to reduced downtime.

Speaker(s):

Kevin Feasel

Track and Room: Application Database Development - D

Title: I have indexes, but do I have the right indexes?

Abstract: Do you have all the right indexes on your SQL Server databases? Have you implemented any indexes other than traditional clustered and non-clustered indexes? If the answer to either question is a “no” or an “I don’t know”, then this session is for you.

This session will help introduce less commonly used index types and settings along with indexing methodologies. Follow along while we learn which indexes your SQL Server is begging you to make and others it wishes you would drop. Learn use cases for filtered, full-text, and columnstore indexes. There will be plenty of demos and shareable scripts to showcase the benefits too!

Are you using a version and edition of SQL Server is able to use these features? We’ll cover that too and you’ll leave this class with a repeatable indexing methodology you can use to improve your database performance.

Speaker(s):

Eric Blinn

Track and Room: Application Database Development - C

Title: Database DevOps with Visual Studio and Jenkins

Abstract: Are your database releases time-consuming, complicated, and exception-driven? Do you wish you could deploy just a few of the changes from database 1 to database 2? Does your boss say “we should do more of this DevOps stuff”? Time to think about automation.

Keeping your “desired state” database in version control is the first step toward easy, repeatable deployments. When your database contains exactly what it’s supposed to, there’s no such thing as “but it worked in Dev.” And that’s just the beginning.

Join Larry Blake and Shantan Kallu from Teach for America to learn how they created custom Jenkins pipelines to automate deployments, run unit tests, introduce code review approval steps, manage logins, and more. No Jenkins knowledge is assumed.

Speaker(s):

Larry Blake

Track and Room: Application Database Development - G

Title: How to automate row level security in Power BI using DAX and SSAS

Abstract: Power BI is a business analytics solution that lets you visualize your data and share insights across your organization or embed them in your app or website. This session is for users are who want to automate Power BI row-level security by replicating the security of another data source such as corporate ERP. Many organizations maintain tight data security within their organization. Row-level security needs to be defined within Power BI. This can be difficult if you have many users and security changes happen quite often. If you are using a corporate ERP system that has security built into it, you would end up doing redundant work of managing security at two places, in ERP as well as in Power BI. DAX query can be used to filter out rows based on user ID/user name. We will go over the demo of the entire process starting from bringing data into SSAS, creating data model, applying row level security publish the report. Never again you will have to manually manage roles within Power BI.

Speaker(s):

Ashwini Jain

Track and Room: Data Visualization/BI/Reporting/Analytics - I

Abstract: Learn how to leverage Tableau Server to access interactive insights from anywhere. This session will help to familiarize you with the main features of Tableau Server, enabling you to publish, share and administrate content.

As a Tableau Desktop user, you will be able to create workbooks and views, dashboards, and data sources in Tableau Desktop, and then publish this content to your Server.

As a Tableau Server user, you will be able to access up-to-date content and gain quick insights without relying on static distributed content.

As a Tableau Server administrator you will control who has access to server content to help protect sensitive data. Administrators can set user permissions on projects, workbooks, views, and data sources.

Schedule: Navigating the Tableau Server Web Authoring Managing subscriptions Publishing Leveraging the Data Server Embedding Views Web Authoring Managing subscriptions Publishing Leveraging the Data Server Embedding Views

Speaker(s):

Nilton Kazuyuki Ueda

Track and Room: Data Visualization/BI/Reporting/Analytics - I

Title: Organizational Security Compliance with SQL 2012 through 2016/2017

Abstract: You need to deal with more security requirements in your role. How can SQL Server features help you comply? We will delve into Audit, Compliance, and Encryption. SQL 2016/2017 features like Always Encrypted will be detailed at the end.

Speaker(s):

George Walters

Track and Room: Data Governance/Privacy/Auditing/Documentation - L

Title: DataOps - Deploy SQL Server Databases Using Azure Pipelines

Abstract: The database is sometimes one of the last areas considered when planning DevOps for new and existing projects. If you are new to Azure Pipelines or Database Projects in Visual Studio this presentation will show you how to combine these technologies to create a consistent database deployment across all your development environments. If you are already using Azure Pipelines and Visual Studio for your applications, you will learn how to include your database. We will go over creating a database project and deploying a Dacpac manually to multiple environments. I will point out things to consider and how to add custom deployment scripts and build validation. Then we will setup an Azure DevOps account and step through creating a pipeline to automatically deploy a data project stored in a git repository. We’ll also use Key Vault to store the deployment credentials to avoid sharing around that password everyone uses to deploy manually.

Speaker(s):

MIKE DONNELLY

Track and Room: Strategy and Architecture - E

Title: Introduction to Financial Data Analysis using Azure Machine Learning

Abstract: Financial sector is highly depending on data analysis, data cleaning and different machine learning models for prediction, anomaly detection, classification etc. Azure ML is providing all the services from data hosting to, data pre-processing, data cleaning, training on classic machine learning algorithms, testing and validating designed models and launching them as a web service. In this session we will show a demo about financial data analysis from scratch using Azure ML services.

Speaker(s):

Rahat Yasir

Track and Room: Machine Learning / AI - K

Title: Level-up your Power BI Reports

Abstract: You’ve been working with Power BI, building fantastic reports and dashboards. Let’s take a look at some of the cool features that will help you make your reports more appealing and add more functionalities. This session is 100% demos: Shortcuts, visuals interactions, drilling down/up/through data , custom tooltips, bookmarks.

Speaker(s):

Cecilia Brusatori

Track and Room: Data Visualization/BI/Reporting/Analytics - F

Title: Azure SQL Managed Instances - A mostly full-featured SQL Server in the Cloud

Abstract: In this session we will compare the offerings of Azure SQL Databases, then dig in and show what separates SQL Managed Instances from the rest. We’ll take a look at challenges that previously prevented migrations to Azure, the current features available, some common architectures, and backup and restore options.

Speaker(s):

Chris Seferlis

Track and Room: Data and the Cloud - A

Title: Code Like a Snake Charmer - Intro to Python!

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: Machine Learning / AI - K

Title: PoC to Enterprise AI Application Designing using Cognitive Services

Abstract: The field of Artificial Intelligence is evolving very fast and considered as a very complex discipline of computer science. Microsoft has launched cognitive services to promote the concept of AI democratization. Using cognitive services, it is very easy to convert an AI idea into a proof of concept. Later we can use the proof of concept to launch enterprise level scale able AI application. In this session we will talk about all the aspects of AI idea generation to, PoC development. Later how can we launch the PoC as a production graded product using Azure AI services.

Speaker(s):

Rahat Yasir

Track and Room: Machine Learning / AI - H

Title: Code Like a Pirate … Intro to R and Data Science Tools in MS

Abstract: R is the most popular statistics language used today. It is one of the most useful tools in the data scientist’s tool belt. It is also integrated into the MS stack in tools like Azure ML, SQL Server and Power BI and can be used to take your data analytics to the next level.

Come to this session to get an introduction to the R language including:

installing and Configuring R and RStudio
RStudio Overview and Debugging
how to Access and Manipulate Data
install and Manage Packages
create and Use Variables
control Flows
functions
basic Graphing and Statistical Analysis.

We will finish with a brief introductions of how R integrates in Azure ML, Power BI, and SQL Server 2016 using real demos.

The focus of the session will be primarily on the introduction to the R language and getting attendees comfortable with using R to start the journey into Data Science!

Speaker(s):

Jamey Johnston

Track and Room: Machine Learning / AI - K

Title: Intro to indexing for SQL writers

Abstract: Are you just starting out writing SQL for applications or reports? Did you back into a DBA role by accident? Do you know nothing about indexes and think you should? If you answered yes to any of those questions then this class is for you.
This class presents indexes from the ground up and lays the foundation for solid index usage. We’ll cover what indexes are, different types of indexes, when to use them, and when not to use them. We’ll also briefly cover index maintenance.
This class is designed for beginners and is designed to be very practical. It won’t dive deep on any one subject and won’t bog down with technical minutiae.

Speaker(s):

Eric Blinn

Track and Room: Application Database Development - A

Title: Protecting Distributed and Legacy SQL-based Applications

Abstract: Encryptionizer for SQL Server is a cost-effective alternative to upgrading to SQL Enterprise for TDE. Encryptionizer works with all versions and editions of SQL Server from Express to Enterprise. It is deployed by a simple point-and-click interface. However, what if you are, say, a commercial developer or device manufacturer with hundreds or even thousands of customers who need to come into compliance? You obviously don’t want to do a point-and-click deployment on each one. This session will show how you can use Encryptionizer’s script-based deployment to install on one or ten thousand machines (even Legacy machines) with no programming and no user interaction.

Speaker(s):

Neil Weicher

Track and Room: Database Administration / Infrastructure - B

Title: Keeping Your Data Secure In Azure While Automatically Refreshing Power BI Datasets

Abstract: Your company has completed its data migration to Azure and now various teams are wanting to build, share and view Power BI reports and dashboards using the data. Additionally, the access to the data has been limited to a specific list of applications and users but not to Power BI.

So how do you support the automatic data refresh of the data within Power BI and still ensure that the security of your company’s data is not compromised?

This advanced Power BI session presents several techniques that can be used to maintain (and sometimes enhance) the security of your company’s data while ensuring that Power BI datasets are regularly refreshed.

Speaker(s):

Cornell Emile

Track and Room: Data and the Cloud - D

Title: Implementing ETL solution for incremental data load

Abstract: ETL (Extract, Transform, and Load) is an essential task of a Business Intelligence Professional, especially if someone is working in Data Warehouse environment. Are you excited to learn different techniques of loading incremental data in SQL environment? In this session, we will cover the Business scenarios and demos of Incremental data load using T-SQL join, SSIS Merge Join Transformation, SSIS look up Transformation, SQL Merge Slowly Changing Transformation, and Change Data Capture.

Speaker(s):

Ganesh Lohani

Track and Room: Data Visualization/BI/Reporting/Analytics - K

Title: Running Windows and SQL Workloads on Google Cloud Platform

Abstract: Google Cloud Platform enables you to exit non-differentiating, capital intensive activities like hardware procurement and maintenance. Retire hardware, improve server utilization and deploy your Windows and SQL Workloads in an open cloud environment. Google enables extending your SQL database with advanced Server-less Analytics and AI/ML offerings. Deliver a complete platform without the burden of provisioning, scaling and upgrading infrastructure. This session will provide a walk-through of Google’s approach to running Windows/SQL workloads in the Cloud and architectural patterns to address your needs.

Speaker(s):

Jay Rajendran

Track and Room: Data and the Cloud - I

Title: An Introduction to Always Encrypted

Abstract: This will be an introduction to the Always Encryption feature introduced in SQL Server 2016 . Unlike Transparent Data Encryption Always Encrypted provides encryption in transit as well as encryption at rest. There will be a survey overview of both the operations and development side of Always Encrypted. However, the main focuses will be porting considerations, certificate management, integrating Always Encrypted into a Continuous Integration and Continuous Deployment (CI/CD chain) and using Azure Keyvault for increased certificate security.

Speaker(s):

Justin Dearing

Track and Room: Application Database Development - G

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 - H

Abstract: Using Extended Events, Powershell, TSQL, MDX and Excel we will build a SSAS MD Cube that allows you to track SQL Server Logins that can be slices and diced per Hour, Server, User, Host, Connection String and Database.

This session touches on multiple advanced topics that you can use individually, but together, make for a powerful SQL Security Auditing Tool not found anywhere else. Includes downloadable source code.

Speaker(s):

George Walkey

Track and Room: Data Ware House Development / ETL / SSIS - H

Title: CONVERT_IMPLICIT is a hidden danger

Abstract: Abstract: The CONVERT_IMPLICIT operator is part of an execution plan. When an execution plan has a CONVERT_IMPLICIT operator, this is a signal that “your statement has a problem”. This presentation will show you how to detect the Execution Plans with CONVERT_IMPLICIT operator; how to find the statement that causes conversion, and what DMVs can help to solve the problem. It will also show you the solution to collect the Execution Plans with CONVERT_IMPLICIT operator across the servers.

Speaker(s):

Alex Grinberg

Track and Room: Application Database Development - I

Title: Table Partitioning 101

Abstract: As of SQL 2016/SP1, Table Partitioning is available in all editions of SQL Server!

In this entry-level session, we’ll discuss the advantages and disadvantages of deploying this often misunderstood feature. Is it designed to improve performance, or to ease administration?

Only one way to find out!

Speaker(s):

Ned Otter

Track and Room: Database Administration / Infrastructure - D

Title: HOW TO TROUBLESHOOT DATABASE PERFORMANCE ISSUES

Abstract: In this session, I will be talking about performance turning, index design, statistics, query optimizer, parameter sniffing, data types, analyzing and understanding execution plans, wait stats, activity monitor, DMV(s). After this session you should be able to quickly identify the top performance issues of your databases.

Speaker(s):

Jean Joseph

Track and Room: Database Administration / Infrastructure - A

Title: Why You Should Consider Implementing Indexed Views

Abstract: This session will include an explanation of what indexed views are, the types of problems that they solve, and their limitations. Additionally, I will provide a methodology for determining whether or not you should consider using indexed views to solve problems in your environment - including how to test and compare them to some alternatives. I will then go through some demonstrations in order to clarify my points further and provide more opportunities for the audience to ask questions.

Speaker(s):

Alexander Fleming

Track and Room: Application Database Development - G

Title: Centralized Alert Dashboarding

Abstract: Its easy to build a Centralized Dashboard for all your Server’s Agent Alerts that can monitor all your Servers. In 60 minutes we will create a Dashboard using SQL Agent, Powershell and SSRS that is easy-to-maintain and deploy.

Speaker(s):

George Walkey

Track and Room: Database Administration / Infrastructure - H

Title: An Animated Look at Query Plans

Abstract: You’ve looked at query plans and done some tuning, but you’re not sure what’s going on underneath. Hash Match? Merge Join? Watch both come to life in animations, and more! See (not just hear) the inner workings of a plan, and learn about the details that matter for performance. When plans make sense, tuning will become easier, and maybe even fun!

Speaker(s):

Forrest McDaniel

Track and Room: Application Database Development - H

Title: Will my workload run faster with In-Memory OLTP?

Abstract: There are compelling reasons to consider deploying In-Memory OLTP, vastly improved in SQL 2016 and SQL 2017, and now running on all editions.

What are the use cases?

What are the tradeoffs?

We will lift the veil of confusion that surrounds this blazingly fast feature. By the end of the session, you will understand how In-Memory OLTP works and whether your workload is likely to see an increase in performance.

Speaker(s):

Ned Otter

Track and Room: Application Database Development - D

Title: Introduction to GitHub

Abstract: Getting started with GitHub can at times be overwhelming. Especially when you’ve been working with other source control and project management systems your whole career. In this session, we will overview the below tasks to ensure your success with GitHub.

Initial setup of a Repository in GitHub.
Build Issue templates for new features, bugs, or custom tasks.
Securing the check-in/merge process to your root branch.
Integrating GitHub with other productivity tools to keep on top of changes.

Speaker(s):

Joshua Higginbotham

Track and Room: Application Database Development - L

Title: Building a proper indexing strategy

Abstract: Indexes play a crucial role in database performance. Proper indexes will significantly reduce query run times and reduce resource consumption. However if we do not take care when creating indexes we can actually hurt performance. To that end it is important to understand what makes for a good index as well as how to properly maintain indexes. In other words we need an indexing strategy.

In this session we will cover the following:

Heaps Clustered vs non clustered indexes How the optimizer determines what indexes to use – Statistics! How to determine good indexes How to implement proper index maintenance / Common strategies

Speaker(s):

Brandon Leach

Track and Room: Application Database Development - B

Title: Linux Administration for SQL SERVER DBAs

Abstract: You, as a SQL SERVER DBA are used to troubleshooting Windows as a Master. Now we have a different OS flavor. Are you ready to add a few more tools to your DBA skill set? In this section let´s see how to perform the most common troubleshooting tasks, that we are already used to performing on Windows, now on Linux.

Speaker(s):

Marcelo Adade

Track and Room: Database Administration / Infrastructure - D

Title: Running SQL Server on AWS

Abstract: Learn how Amazon Relational Database Services (RDS) helps SQL Server DBAs focus their time where it matters most. We will cover Amazon RDS for SQL Server features and the key differences between running deployments on Amazon Elastic Cloud Compute (EC2) and Amazon RDS. This will include HA/DR and performance monitoring.

Speaker(s):

Richard Waymire

Track and Room: Data and the Cloud - F

Title: Power BI Performance Improvement

Abstract: It is frustrating that a Power BI report is running very slow even if the actual Power BI dataset is small. Or some visuals run too long and just time out. It is important to be able to do performance tuning against your Power BI data model and your DAX query. This is a level 300 presentation which we will look at: 1). The analytical engine behind Power BI (called Vertipaq Engine), 2). An overview of the query architecture of each DAX query, 3). How to optimize the query performance. This presentation is best for audience who has basic understanding Power BI, data modeling, and DAX.

Speaker(s):

Dan (Annie) Xu

Track and Room: Data Visualization/BI/Reporting/Analytics - L

Title: Improving Columnstore Load Scalability on Large Servers

Abstract: Clustered Columnstore indexes can be a great solution for data warehousing workloads, but loading lots of data as quickly as possible is still an arcane art. We will walk through how to improve scalability of two common loading patterns using lessons learned from production workloads involving billions of rows. Come to this session to improve your Columnstore load times, to learn about scalability on large servers, or simply to be challenged.

Speaker(s):

Joe Obbish

Track and Room: Application Database Development - G

Title: Data Governance Implications of the California Consumer Protectio

Abstract: The California Consumer Protection Act (CCPA) has substantial implications on the data governance and data management practices of all companies that have customers in California. The CCPA will come into effect in 2020 and has substantial potentially large monetary penalties for non-compliance. Are you ready? We will discuss what the CCPA is and who is required to comply with the law. A presentation of MetaCenter, an enterprise metadata management and data governance solution, will be given to show how a tool can be used to help you comply with the data inventory and data lineage requirements of the CCPA.

Speaker(s):

Geoffrey Rayner

Track and Room: Data Governance/Privacy/Auditing/Documentation - C

Title: Is Physical Still An Option for SQL Server Deployments?

Abstract: With the push towards virtualization and the public cloud, are there people still deploying physical SQL Server architectures? The answer is yes. However, the answer should not always be yes. As we move towards an increasingly cloudy world, when does it make sense to deploy physical hardware? What do those solutions look like in 2019 since things have evolved quite a bit in the past few years with options like hyperconverged? This session will cover when you may want to consider - and when you probably don’t want - physical solutions.

Speaker(s):

Allan Hirt

Track and Room: Database Administration / Infrastructure - F

Title: Myth Busters: the truth of what it’s like to be a woman in tech.

Abstract: .

Speaker(s):

Kathi Kellenberger

Track and Room: Application Database Development - A

Title: Leadership 101: Guiding principals to success

Abstract: Let me share with you the some of the secrets to successful Leadership. We will cover Team Building, Employee Retention, Motivation, How to discover toxic situations and Success for the short and long term. Each one of these topics is derived from my own experiences in leading teams and organizations. Hint: I didn’t get it all right the first time so stop on by for some horror stories too.

Speaker(s):

James Phillips

Track and Room: Personal / Professional Development - B

Speakers

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

Paul Stanton

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

LinkedIn: Paul Stanton

Contact: https://www.windocks.com/blog-2

Co-founder of Windocks, Paul is a former Microsoft engineer who is focused on delivering solutions for SQL Server development and test, including SQL Server containers and database cloning.

Taiob Ali

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

LinkedIn: Taiob Ali

Contact: http://www.sqlworldwide.com

Taiob Ali, MVP Data Platform, is an accomplished technical leader with a proven record of success. For 14 years, he has worked with the Microsoft Data Platform and MongoDB both on-premise and cloud. His experience includes all three major business sectors: finance, e-commerce, and healthcare. Taiob has hands-on experience in managing large database projects, massive data migration, intricate process design, testing and deployment, performance tuning, long term capacity planning. Taiob is currently working at “GMO LLC” as a Database Solution Manager, focusing on cloud migration, automation, improving, and streamlining operational workflow. He is a regular speaker at local and virtual PASS chapters, SQLSaturdays, and Azure conferences.

Eric Blinn

Twitter: - @SQL2TheSequel

LinkedIn: Eric Blinn

Contact: https://ericblinn.com/

Eric has been a SQL Server DBA in the legal, software, transportation, and insurance industries for over 10 years. Currently he is the Sr Data Architect for Squire Patton Boggs, a leading provider of legal services with 47 offices in 20 countries.

Eric is a 2018-2019 Idera Ace and has co-authored 2 Idera Whitepapers.

He has been a presenter at PASS Summit, SQLSaturdays, the in.sight transportation conference, and the Ohio North SQL Server User’s Group.

Cornell Emile

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

For nearly two decades, Cornell A. Emile has designed, developed, and maintained data-centric solutions within multiple industries such as Finance, Digital Marketing, Non-Profit, Retail, Manufacturing State and Federal Government using Microsoft#39;s business and data products. His main interests include architecting data solutions, Business Intelligence and NoSQL databases.

Sandy Winarko

LinkedIn: Sandy Winarko

Contact: https://techcommunity.microsoft.com/t5/SQL-Server-Integration-Services/bg-p/SSIS

Sandy is a seasoned Product Manager with extensive experience in the US, Europe, and Asia, combining commercial/technical responsibilities in principal/senior roles at various TMT (Technology, Media, and Telecommunications) companies, such as Microsoft/Skype/Nokia, BSkyB (British Sky Broadcasting), and CW (Cable Wireless). At Microsoft, he is currently driving the efforts to modernize SSIS (SQL Server Integration Services) on premises and in the cloud as part of ADF (Azure Data Factory).

Allan Hirt

Twitter: - SQLHA

LinkedIn: Allan Hirt

Contact: http://www.sqlha.com/blog

SQLHA, LLC founder, consultant, trainer, author, and business continuity, infrastructure, and virtualization expert Allan Hirt has been working with SQL Server since 1992 when it was still a Sybase product. He has also been clustering in Windows Server since the late 1990s when it was known as Wolfpack. Currently a dual Microsoft MVP (Data Platform; Cloud and Datacenter Management) as well as a VMware vExpert, Allan works with all sizes of customers, no matter if they are on premises or in the public cloud. He also delivers training and speaks at events over the world.

Rahat Yasir

Twitter: - Anind0

LinkedIn: Rahat Yasir

Contact: https://learnwithbddevs.wordpress.com/

Rahat Yasir is selected as Canada’s top 30 software developer under 30 in 2018. He is five times Microsoft Most Valuable Professional Award holder in Artificial Intelligence category. He is the author of the first eBook on Windows Phone 8.1 app development “Windows Phone 8.1 Complete Solution” and “Universal Windows Platform - Complete Solution”. He was the lead AI developer at Immersive Design Studios and developed world’s first AI video upscalling tool. He worked as AI Engineer at Intact Financial Corp and designed production graded AI applications that are serving millions of requests everyday. He is currently working as the Lead AI Developer at OSEDEA and designing the next generation AI solutions for manufacturing industry.

Joe Obbish

Contact: https://orderbyselectnull.com

Joe Obbish has nearly a decade of experience with SQL Server and other database platforms. He works as a query tuning, columnstore, and scalability expert within Epic, a large EHR and analytics vendor in Madison, WI. In less than two years, he became one of the top contributors for SQL Server on the DBA StackExchange community. Joe blogs about advanced columnstore and query tuning topics on his blog, http://www.orderbyselectnull.com. In his spare time, Joe enjoys baking and sharing these treats with his coworkers.

Rahat Yasir

Twitter: - Anind0

LinkedIn: Rahat Yasir

Contact: https://learnwithbddevs.wordpress.com/

Jay Rajendran

Focused on solving customer challenges through innovative technology solutions on Google Cloud Platform.

Mark Broadbent

Twitter: - @retracement

LinkedIn: Mark Broadbent

Contact: http://tenbulls.co.uk

Mark Broadbent is a Data Platform MVP and SQL Server MCM with more than 20 years of experience working with SQL Server and principal of SQLCloud, a consultancy specializing in concurrency control and highly available solutions. He is the founder of the UK’s SQLSaturday Cambridge (its first and largest), SharePoint Saturday Cambridge, the Hybrid Virtual Chapter and the East Anglia SQL User Group.

Justin Dearing

Twitter: - zippy1981

LinkedIn: Justin Dearing

Contact: http://www.justaprogrammer.net

Justin Dearing has been working in IT in 2002. He started as a night shift AS/400 operator and rose through the ranks at a series of companies. He currently works as a developer in the capital markets industry.

Justin has served in both the development and production side of the house on Windows, Unix and Midrange Platforms. His database experience includes MongoDB, MySQL, Postgres and Microsoft SQL server. These days he programs in C#, PowerShell and PHP.

Ned Otter

Twitter: - @NedOtter

LinkedIn: Ned Otter

Contact: http://www.nedotter.com

DBA with vast experience administering Microsoft SQL Server since version 4.21 to the present.

Certifications:
MCSE SQL Server 2012 Data Platform MCTS SQL Server 2008 Overall computer experience: 25 years SQL Server experience: 23 years

Currently obsessed with In-Memory technology.

Please see LinkedIn profile for more details.

Dan King

Contact: http://www.rdx.com/Blog/dba_tips/2014/04/the-merge-join-transformation-and-an-ssis-sorting-tip/

My name is Dan King. Believe it or not I am a huge computer geek. I have worked in the System Admin role and for the past 9 years I have worked with RDX holding many positions. My current role is Sr. Manager of Data Analytics. I am a father of one. I love sports and I am a huge outdoors man. I have a few blogs published by my company that can be found on there website.

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

Jens Vestergaard

Twitter: - @vestergaardj

LinkedIn: Jens Vestergaard

Contact: http://www.t-sql.dk

Jens performs the traditional BI disciplines from imports in Integration Services through data consolidation in Analysis Services, to report in Power BI or Reporting Services. Jens has worked with The Stack since SQL 2000 and has a core competence in Integration Services and Analysis Services. Along with the certified skills in Microsoft SQL Server, Jens has also worked with Microsoft .Net platform for more than 15 years and currently manages a BI Platform in Azure for the CatMan Solution application(s).

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.

MIKE DONNELLY

Twitter: - SQLMD

LinkedIn: MIKE DONNELLY

Contact: http://sqlmd.wordpress.com

Michael Donnelly has been working with SQL Server for 15+ years and holds the MCSE: Data Platform certification. He is an avid runner, blogger, and a wannabe gourmet chef. Currently living the SQL Life on the Jersey Shore.

Chris Seferlis

Twitter: - bizdataviz

LinkedIn: Chris Seferlis

Contact: http://blog.bizdataviz.com

Chris Seferlis is a Sr Cloud Solution Architect at Microsoft. He has 20+ years’ experience working in IT and solving technical challenges from a business perspective. Chris is a former CIO with an MBA from UMass, bringing a mix of business acumen and practical technology solutions, primarily focusing on Data and AI within the Microsoft Data Platform, including MCSA and MCT designations.

Forrest McDaniel

Twitter: - tsqladdict

Contact: https://www.forrestmcdaniel.com

Simply put, Forrest is a nerd. For over a decade he’s applied his math skills in various industries, and has become specialized in SQL Server performance. His current goal is to animate all the operator algorithms in query plans.

Taiob Ali

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

LinkedIn: Taiob Ali

Contact: http://www.sqlworldwide.com

Sandy Winarko

LinkedIn: Sandy Winarko

Contact: https://techcommunity.microsoft.com/t5/SQL-Server-Integration-Services/bg-p/SSIS

Mark Broadbent

Twitter: - @retracement

LinkedIn: Mark Broadbent

Contact: http://tenbulls.co.uk

Allan Hirt

Twitter: - SQLHA

LinkedIn: Allan Hirt

Contact: http://www.sqlha.com/blog

Justin Dearing

Twitter: - zippy1981

LinkedIn: Justin Dearing

Contact: http://www.justaprogrammer.net

Ned Otter

Twitter: - @NedOtter

LinkedIn: Ned Otter

Contact: http://www.nedotter.com

DBA with vast experience administering Microsoft SQL Server since version 4.21 to the present.

Certifications:
MCSE SQL Server 2012 Data Platform MCTS SQL Server 2008 Overall computer experience: 25 years SQL Server experience: 23 years

Currently obsessed with In-Memory technology.

Please see LinkedIn profile for more details.

Kevin Feasel

Twitter: - feaselkl

LinkedIn: Kevin Feasel

Contact: http://www.catallaxyservices.com

Kevin Feasel is a Microsoft Data Platform MVP and CTO at Envizage, where he specializes in data analytics with T-SQL and R, forcing Spark clusters to do his bidding, fighting with Kafka, and pulling rabbits out of hats on demand. He is the lead contributor to Curated SQL (https://curatedsql.com), president of the Triangle Area SQL Server Users Group (https://www.meetup.com/tripass), and author of PolyBase Revealed (https://www.apress.com/us/book/9781484254608). A resident of Durham, North Carolina, he can be found cycling the trails along the triangle whenever the weather’s nice enough.

Neil Weicher

Twitter: - @netlibsecurity

LinkedIn: Neil Weicher

Contact: https://netlibsecurity.com/articles/

Neil Weicher is the Founder and CTO of NetLib Security Inc, an early pioneer driving data encryption since 1990. Mr. Weicher was working in computer engineering in the late 1980s when he noticed companies compiling massive amounts of sensitive information on their databases but leaving it all unprotected. This spurred him to create what is now NetLib Security’s flagship data security platform, Encryptionizer; encryption for Windows and SQL across the enterprise.

Mr. Weicher holds a patent for a system for encrypting data files of application programs. He received a Master of Science in Computer Science from Columbia University.

Kevin Feasel

Twitter: - feaselkl

LinkedIn: Kevin Feasel

Contact: http://www.catallaxyservices.com

Carlos Robles

Twitter: - dbamastery

LinkedIn: Carlos Robles

Contact: http://www.dbamastery.com

Carlos Robles is a Microsoft Data Platform MVP, a Friend of Redgate, and a technology lover. He has worked in the database management field on multiple platforms for over ten years in various industries.

He has diverse experience as a Primary Consultant and DBA Manager. He is currently working as a Solution Architect, helping customers to solve software/infrastructure problems in their on-premise or cloud environments.

Speaker, author, blogger, mentor, Guatemala SQL User group leader. If you don’t find him chatting with friends about geek stuff, he will be enjoying life with his family or exploring the beautiful outdoors of Colorado.

Michelle Gutzait

Twitter: - mgutzait

LinkedIn: Michelle Gutzait

Contact: http://Google me!

Involved in IT for more than 30 years as a developer, business analyst and database consultant. Worked exclusively with Microsoft SQL Server for the past 20+ years, consulting for many and diverse clients. Skills include everything related to SQL Server: infrastructure and database design, Performance tuning, security, High Availability, consolidation, Disaster Recovery, Cloud migrations and much more! Also active in the community as a speaker and a Blogger. One of the Organizers of the PASS Chapter in Montreal.

Eric Blinn

Twitter: - @SQL2TheSequel

LinkedIn: Eric Blinn

Contact: https://ericblinn.com/

Eric is a 2018-2019 Idera Ace and has co-authored 2 Idera Whitepapers.

He has been a presenter at PASS Summit, SQLSaturdays, the in.sight transportation conference, and the Ohio North SQL Server User’s Group.

Joshua Higginbotham

Twitter: - codenamesql

LinkedIn: Joshua Higginbotham

Contact: https://codenamesql.blog/

Joshua Higginbotham is a Data Services Manager at Republic Bank based out of Louisville, KY. He’s worked in various roles including Software Development, Database Administration, and Business Intelligence. He’s an active speaker within the SQL community and the Co-Chapter leader of the Louisville SQL Server and Power BI User Group.

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.

Ashwini Jain

My interests span (but not limited to) application of analytics and technology in the construction industry, supply chain management and optimization, data science, analytics, data visualization, GIS and location analytics.

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.

Steve Simon

Twitter: - SQLServerBoffin

LinkedIn: Steve Simon

Contact: http://www.sqlservercentral.com/blogs/simon_says/

Steve Simon is a Database Solutions Architect with Business Knowledge Services Inc. He has been involved with database design and analysis for over 35 years. Steve has presented papers at numerous PASS Summits and PASS SQL Rallies. He is also regular presenter on the SQLSaturday circuit and he is a contributor on SQLShack.com

Richard Waymire

Twitter: - rwaymi

LinkedIn: Richard Waymire

Richard Waymire is a technical expert on Microsoft SQL Server. He has been involved in numerous Microsoft early adaptor projects and new technologies. Richard has broad ranging experience from the relational data modeling phase through the production implementation of database solutions built with SQL Server, including data loading, monitoring, and performance tuning. Richard has worked on SQL Server for more than 26 years, including 12 years as part of the SQL Server team at Microsoft. In his role with Amazon Web Services, Richard is the Americas specialist for SQL Server, as well as for Amazon Aurora.

Dan (Annie) Xu

Twitter: - anniexu1990

LinkedIn: Dan (Annie) Xu

Contact: https://anniexu1990.com

Annie Xu is a Microsoft cloud solution architect focusing on Data and AI. She has comprehensive educational and working experience in business intelligence, database development and data engineering. In addition, she is building up her skills around AI and Machine Learning. Annie speaks at DMV area Power BI, SQL and Azure user groups. You are welcome to read her blog: https://xuanalytics.com or connect her through LinkedIn @anniexu1990

Joseph Yeates

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

LinkedIn: Joseph Yeates

Contact: https://www.feathersanalytics.com

Joseph is a data enthusiast and blogs about all things Power BI on Feathers Analytics. He has a passion for crafting compelling data narratives and making insights accessible to a wider range of users through visualization. He holds the Certified Analytics Professional designation as well as a DBA certification with a focus on SQL Server Analysis Reporting Services. He uses R Studio, Power Query and Power BI to model, manipulate, analyze, and visualize data. He integrates R into Power BI to bring the power of predictive analytics into reports and dashboards. He is a member of the Vancouver Power BI User Group and has presented on Power BI Tips Tricks and Predictive Analytics with R in Power BI.

Larry Blake

Larry has more than 30 years of experience in application and data development, and strong opinions. He enjoys talking about software, DevOps, and development trends.

George Walkey

Twitter: - sqlbytehd

Contact: http://insyncva.com

SQL Server DBA, Developer, IT Manager, Business Owner from the Richmond, VA USA Area Interested in pushing the limits of both hardware software and my own brain

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.

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.

Kathi Kellenberger

Twitter: - auntkathi

LinkedIn: Kathi Kellenberger

Contact: http://auntkathisql.com

Marcelo Adade

Twitter: - @marceloadade

LinkedIn: Marcelo Adade

Contact: http://www.dbbits.com.br

Marcelo is a Database Consultant at The Pythian Group. He has more than 10 years of experience in several Companies from different branches and sizes. Like financial companies, consultant shops, datacenters and e-commerce sites. Currently holds the MCSE, MCT and MCSA Microsoft Certifications and also the Oracle OCP. Loves technology and enjoys sharing his Database knowledge delivering presentations and official Microsoft Training Courses. Currently he is also the co-leader of the SQLMANIACS PASS User Group, based in Sao Paulo, Brazil

Ray Kim

Twitter: - PianoRayK

LinkedIn: Ray Kim

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

Steve Simon

Twitter: - SQLServerBoffin

LinkedIn: Steve Simon

Contact: http://www.sqlservercentral.com/blogs/simon_says/

Darius Liktorius

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

LinkedIn: Darius Liktorius

Contact: http://www.liktorius.com

Darius has over twenty years of hands-on technical and managerial experience in Solutions Architecture, Performance Optimization, Database Administration Optimization, Infrastructure Engineering, Software Development and Cloud Solutions (both Azure and AWS). He has advanced numerous organizations from startups to non-profits and Fortune 100 enterprises through the use of technology, and mentored hundreds of developers, DBAs and engineers.

Thomas Grohser

LinkedIn: Thomas Grohser

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 ;).

James Serra

Twitter: - www.twitter.com/JamesSerra

LinkedIn: James Serra

Contact: http://www.JamesSerra.com

James Serra is a big data and data warehousing solution architect at Microsoft. He is a thought leader in the use and application of Big Data and advanced analytics. Previously, James was an independent consultant working as a Data Warehouse/Business Intelligence architect and developer. He is a prior SQL Server MVP with over 35 years of IT experience. James is a popular blogger (JamesSerra.com) and speaker. He is the author of the book “Reporting with Microsoft SQL Server 2012”.

George Walters

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

LinkedIn: George Walters

Contact: https://georgewalters.wordpress.com/

Currently a partner technical strategist, George has been solving customer needs and issues. He can translate customer pain into potential solutions.

A seasoned Microsoft SQL and Azure expert, with over 20 years of experience with Microsoft SQL Server, Sybase, Oracle, and other relational databases.

Specialties: Partner strategy, PreSales Engineering, Cloud Architecture, Enterprise Scalability, SQL Server performance, Business Intelligence, High Availability, Scale. I volunteer and present relevant topics at SQLSaturday and internal Microsoft events

Nilton Kazuyuki Ueda

LinkedIn: Nilton Kazuyuki Ueda

Nilton Ueda trabalha como Analista de BI Sênior ajudando as empresas a melhorar o processo de decisão através de melhores práticas de visualização de dados, construindo painéis de analise de dados e dashboards eficientes. Tem experiência em empresas multi nacionais conhecidas. É conhecido nacionalmente por disseminar e evangelizar a pratica de BI com a plataforma Tableau e é Alteryx Designer Core Certified.

Rune Ovlien Rakeie

Twitter: - runeo34

Rune Rakeie has been working with databases for over 20 years, primarily with Microsoft SQL Server. Throughout the years, Rune has had many roles, including developer, database designer, solution architect, and all the way to production DBA. Today Rune works for EVRY as a Principal Consultant “focusing” on the different cloud vendor’s Data Platform Services. Rune is very active in the Microsoft Data Platform community and has held a position on the board for the Norwegian user group. For the last 3 years he has been running the largest Microsoft Data Platform conference on Norwegian soil, SQLSaturday Oslo. In his spare time you can find Rune in the woods of his hometown, Arendal, enjoying his new found hobby, single track bicycling.

James Phillips

Twitter: - @JPhillips_Data

James Phillips is the VP Technology for Mizuho Americas and has over 20 years of experience with SQL technologies with the last 10 years focused on Business Intelligence. He is a past Leader of the Northern NJ SQL Server User group and current Leader for SQLSaturday NYC. He has worked in a wide array of industries including finance and insurance. Regularly speaks about Database Performance Tuning, SSIS and Power BI topics. Also an avid softball player and father to 5 beautiful children.

Geoffrey Rayner

Geoff Rayner is the CEO of Data Advantage Group. He has been involved in the design and implementation of metadata management and data governance solutions for 17 years. Geoff has a BS in Engineering from Brown University.

Matt Gordon

Twitter: - sqlatspeed

LinkedIn: Matt Gordon

Contact: http://www.sqlatspeed.com

Matt is a Microsoft Data Platform MVP and has worked with SQL Server since 2000. He is the leader of the Lexington, KY PASS local group and a frequent domestic and international community speaker. He’s an IDERA ACE alumnus and 2020 Friend of Redgate. His original data professional role was as a database developer, which quickly evolved into query tuning work that further evolved into being a full-fledged DBA in the healthcare realm. He has supported several critical systems utilizing SQL Server and managed dozens of 24/7/365 SQL Server implementations. He currently utilizes that real world experience as a data platform consultant helping clients design solutions that meet their ever-changing business needs.

Marcelo Adade

Twitter: - @marceloadade

LinkedIn: Marcelo Adade

Contact: http://www.dbbits.com.br

George Walkey

Twitter: - sqlbytehd

Contact: http://insyncva.com

SQL Server DBA, Developer, IT Manager, Business Owner from the Richmond, VA USA Area Interested in pushing the limits of both hardware software and my own brain

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.

Ganesh Lohani

LinkedIn: Ganesh Lohani

Ganesh Lohani has 10 years of experience working with Business Intelligence platform and Data Analytics, with over 8 years of experience with MS BI tools and Business Intelligence processes. He is currently working for Stericycle as a senior Business Intelligence Developer. He also enjoy his evening and weekend time in providing online training, coaching and mentoring individuals who want to learn MSBI (T – SQL, SSIS, SSRS, SSAS, and Power BI ) products. He holds MSIS degree from University of Texas at Arlington.

Cecilia Brusatori

Twitter: - CeBrusa

LinkedIn: Cecilia Brusatori

Contact: https://www.magnadatasolutions.com

Cecilia is a Consultant at Magna Data, with over 15 years as Business Intelligence and Data Analytics Professional, experienced in LawEnforcement, Finance, Retail, Events Marketing, Medicine, Accounting, Forensics, Fraud, Corporate Investigations.

Microsoft Certified Professional in SQL Server and Power BI. Passionate and curious, uses Data to solve simple to complex business scenarios and deliver high-value solutions.

She is very active and engaged with the community, leveraging activities and content to provide free forums of education, networking and professional growth. Leader of PASS South Florida SQL Server User Group (SFSSUG), Leader Organizer SQLSaturday South Florida, Leader Microsoft Data and AI (Official)

James Serra

Twitter: - www.twitter.com/JamesSerra

LinkedIn: James Serra

Contact: http://www.JamesSerra.com

Michelle Gutzait

Twitter: - mgutzait

LinkedIn: Michelle Gutzait

Contact: http://Google me!

Brandon Leach

Twitter: - SQLServerNerd

LinkedIn: Brandon Leach

A Microsoft Data Platform MVP, Brandon manages the DB Operations team for financial company x. With a data estate of several petabytes, he puts a high focus on performance tuning and automation. He is a frequent speaker at events like conferences and user groups.

Matt Gordon

Twitter: - sqlatspeed

LinkedIn: Matt Gordon

Contact: http://www.sqlatspeed.com

Alexander Fleming

I think T-SQL is the best thing since sliced bread and I thoroughly enjoy reading and writing T-SQL whenever I can. I’m also doing increasingly advanced PowerShell scripting and ETL development with SSIS, PowerShell, and TSQL.

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.

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.

Jamey Johnston

Twitter: - STATCowboy

LinkedIn: Jamey Johnston

Contact: http://STATCowboy.com

Ray Kim

Twitter: - PianoRayK

LinkedIn: Ray Kim

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

Hasan Savran

Twitter: - Savranweb

LinkedIn: Hasan Savran

Contact: http://h-savran.blogspot.com/

Hasan Savran is a BI Architect at Progressive Insurance Company. He spends his days architecting cutting edge business solutions by using the latest Web and Database technologies. He is a Microsoft Data Platform MVP, Microsoft Certified Solutions Developer. Hasan has spoken at many SQLSaturdays, Code Camps and User groups. He is an active member of the HTML5 and WebAssembly W3C groups. He likes to write about SQL, CosmosDB, C#, and Front End development on his blog.

Jean Joseph

Twitter: - garella79

LinkedIn: Jean Joseph

Contact: http://tsqlhelp.wordpress.com/

Highly experienced in Big Data and traditional data technologies with a history of successes in designing, implementing complex technical projects for diverse businesses in various stages of their development. Acknowledged as a leader capable of mentoring teams of different backgrounds and talents and inspiring individual efforts to deliver. Organized and detail-oriented, with a positive pro-active and hardworking attitude. Performance history reflects a highly analytical strategic thinker with strengths in defining solutions and executing programs that have been invaluable to an all-encompassing range of projects and positions.

SQLSaturday #912 - New York City 2019

Sessions

Title: T-SQL Window Function Deep Dive

Title: SQL DevOps Simplified with Production Databases

Title: Persistent Memory and Hybrid Buffer Pool - The good, bad and ugly

Title: Predictive Analytics with R in Power BI

Title: How to build your career

Title: Whacha just say? Talking technology to non-technical people

Title: SQL Server Reporting Services 2017 on Steroids!!

Title: Back to the Future: Accelerating the Cloud Migration of Legacy SSIS with Azure Data Factory

Title: “Schadenfreude” - Let’s enjoy the mistakes other people made…

Title: Networking 102: Getting Ready for a SQL Event

Title: The DBA Quit and Now You’re It: Action Plan

Title: Distributed Availability Groups - How to

Title: Azure-d Availability: SQL Server HA In and To the Cloud

Title: Exploring SQL Server containers on Docker Kubernetes

Title: Implementing Security Standard Regulations in SQL Server Azure

Title: Networking 101: Building professional relationships

Title: Easing the pain of database migrations, a closer look at the new cloud citizen - DMS

Title: New features in Management Studio – Performance Troubleshooting made easier!

Title: SQL Server Availability Groups for dummies

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

Title: PaaSport to Paradise: Lifting Shifting with Azure SQL Database + SSIS in Azure Data Factory

Title: Version control with GIT for the DBA

Title: Creating efficient and effective SSRS BI Solutions

Title: SQL Server in the Cloud: Microsoft Azure vs Amazon Web Services (AWS)

Title: Power BI for absolute beginners

Title: Tech Writing for Techies: A Primer

Title: Unexplored Features of SQL Server

Title: Building a modern data warehouse

Title: Top FREE performance troubleshooting tools for SQL Server

Title: What is kusto query language?

Title: Top Tips for Deploying AGs and FCIs On Premises or In the Cloud

Title: Data Virtualization with PolyBase

Title: Effective Data Warehouse Storage Patterns

Title: Power BI Live Data sets, Monitoring your key metrics

Title: How to audit and prevent unwanted user actions.

Title: PowerBI and PowerApps Married at First Sight

Title: Approaching Zero: Minimizing Downtime During Deployments

Title: I have indexes, but do I have the right indexes?

Title: Database DevOps with Visual Studio and Jenkins

Title: How to automate row level security in Power BI using DAX and SSAS

Title: Sharing and collaborating with your company through Tableau Server

Title: Organizational Security Compliance with SQL 2012 through 2016/2017

Title: DataOps - Deploy SQL Server Databases Using Azure Pipelines

Title: Introduction to Financial Data Analysis using Azure Machine Learning

Title: Level-up your Power BI Reports

Title: Azure SQL Managed Instances - A mostly full-featured SQL Server in the Cloud

Title: Code Like a Snake Charmer - Intro to Python!

Title: PoC to Enterprise AI Application Designing using Cognitive Services

Title: Code Like a Pirate … Intro to R and Data Science Tools in MS

Title: Intro to indexing for SQL writers

Title: Protecting Distributed and Legacy SQL-based Applications

Title: Keeping Your Data Secure In Azure While Automatically Refreshing Power BI Datasets

Title: Implementing ETL solution for incremental data load

Title: Running Windows and SQL Workloads on Google Cloud Platform

Title: An Introduction to Always Encrypted

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

Title: Using Extended Events to Build a Login Cube

Title: CONVERT_IMPLICIT is a hidden danger

Title: Table Partitioning 101

Title: HOW TO TROUBLESHOOT DATABASE PERFORMANCE ISSUES

Title: Why You Should Consider Implementing Indexed Views

Title: Centralized Alert Dashboarding

Title: An Animated Look at Query Plans

Title: Will my workload run faster with In-Memory OLTP?

Title: Introduction to GitHub

Title: Building a proper indexing strategy

Title: Linux Administration for SQL SERVER DBAs

Title: Running SQL Server on AWS

Title: Power BI Performance Improvement

Title: Improving Columnstore Load Scalability on Large Servers

Title: Data Governance Implications of the California Consumer Protectio

Title: Is Physical Still An Option for SQL Server Deployments?

Title: Myth Busters: the truth of what it’s like to be a woman in tech.

Title: Leadership 101: Guiding principals to success

Speakers

Sponsors