SQLSaturday #574 - Washington DC 2016

Event Date: 12/03/2016 00:00:00

Event Location:

The Microsoft Technology Center
5404 Wisconsin Ave, Suite 700
Chevy Chase, Maryland

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: The Art of War with Bad Code

Abstract: Let’s face it, many of us are at war with poorly written or poorly tuned queries and processes. There is usually just one of you who has been tasked with managing one or more SQL Server instances while there are hundreds or even thousands of users of which a certain percentage will inevitably write poor code. So you must battle it out to identify the culprits before they wreak too much havoc on your systems. We will see several fairly straightforward techniques to positively identify the culprits and allow you to prioritize your efforts in tuning them to give you the biggest ROI for your time. TSQL and Extended Events code examples will be provided that you can use immediately in your environment to become more productive.

Speaker(s):

Andrew Kelly

Track and Room: Intermediate DBA - 7-2 (Mixed)

Title: Creating Dynamic Packages

Abstract: In a perfect world an ETL solution would only have to import data from a single file that always had the same name deliver it to a single already existing table. Unfortunately this case is the exception rather than the rule. How can you use SSIS to:

Iterate through all files in a folder and import their content into SQL
Dynamically create and name table based on a data source
Dynamically create a T-SQL statement at runtime based on run time conditions This session focuses on how to create SSIS packages that can change to meet runtime events dynamically based on the environment. Each attendee will leave with the knowledge and toolset necessary to:
Use expressions within SSIS packages
Use variables to dynamically create SQL statements
Configure custom dynamic logging
Use package configurations and parameters and environments to make packages more portable at execution
Replace dynamic SQL using expressions in SSIS

Speaker(s):

David Dye

Track and Room: BI Platform Architecture, Development Administration - 7-5 (BI 2)

Title: The Many Paths of Consulting

Abstract: People often dream of becoming a consultant, but what does that actually mean? Is consulting really the right path for you? Many choices are available when deciding to become a consultant, but these options can be overlooked. Contracting, consulting for an established team, going out on your own, or looking to build a larger business are all great options, depending on your vision and future goals.

This session will help you ask the right questions to better chose and prepare for your path. We then explore the various realities and strategies of each path. Real-life experiences will be shared to help you make the most informed decision on which path is best for you, and how to accelerate your career as a consultant.

Speaker(s):

David Klee

Track and Room: Professional Development - 7-3 (Prof Dev)

Title: Enhancing your career: Building your personal brand

Abstract: In three years I went from a complete unknown to a popular blogger, speaker at PASS Summit, and a SQL Server MVP. 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. It’s about building your personal brand and stepping out of your comfort zone. It’s about overcoming your fear of taking risks. If you can do those things, you will be rewarded. I will discuss how you too can go from unknown to well-known. I will talk about building your community presence by blogging, presenting, writing articles and books, twitter, LinkedIn, certifications, interviewing, networking, and consulting and contracting. Your first step to enhancing your career will be to attend this session!

Speaker(s):

James Serra

Track and Room: Professional Development - 7-3 (Prof Dev)

Title: Top 10 Dos and Don’ts for Clustered SQL Server Implementations

Abstract: Whether you are a new DBA or a seasoned veteran, clustered implementations of SQL Server can still vex many in one way or another. Physical, virtual, and cloud-based architectures all have different subtle complexities when it comes to deploying either clustered instances of SQL Server (FCIs) or availability groups (AGs) regardless if you are using an older version or SQL Server 2016. Storage, networking, Active Directory, quorum, the overall underlying Windows Server failover cluster, and more are topics that come up quite often. This session will cut to the chase and concentrate nearly 20 years of experience down into the most relevant aspects of planning, deployment, and administration of clustered implementations that every DBA should know. The ten dos and don’ts presented could not only mean the difference between success and failure, but whether your systems are up or down.

Speaker(s):

Allan Hirt

Track and Room: Enterprise Database Administration Deployment - 5-2 (DBA 2)

Title: Imposter Syndrome: Are You Faking It Will they Find Out?

Abstract: Have you ever thought to yourself “All these people think I’m smarter than I really am” or “I really don’t know what I’m doing, they’re going to figure out I’m a fraud!” If yes, then you suffer from the Impostor Syndrome. And despite all the accomplishments, awards and accolades, you still doubt yourself. It’s rampant in the modern day tech workplace, and the fear will make you shrink back from opportunities. You dismiss praise. You overcompensate by working harder, being charming and demanding perfection from yourself. What would happen if you were released from this bondage, and kicked your impostor to the curb? In this session, learn 3 powerful techniques that can help to improve your confidence and silent that annoying voice in your head!

Speaker(s):

Mindy Curnutt

Track and Room: Professional Development - 7-3 (Prof Dev)

Title: Location Location Location Preparing and Presenting Geographic Data

Abstract: This session will begin with the tasks necessary to model a dimensional data structure to maintain and present geographic data. We will discuss various requirements that can affect a data model such as granularity, surrogate keys, slowly changing dimensions. Real life examples and solutions will provided to give better context to each step in the process. After the data structure has been created we will focus on how to best “clean” and validate the geographic data. We will focus on using SSIS to obtain latitude and longitude and then how this can be converted SQL Server spatial types. Finally we will cover presenting this data using SSRS and Power Map and how to create dynamic and aesthetically pleasing graphical reports. This portion of the session concentrates on presenting reports using the geographic data type that answer specific questions such as: Events that occurred at a specific address, zip code, and even block range and events within a mile radius.

Speaker(s):

David Dye

Track and Room: BI Information Delivery - 7-4 (BI 1)

Title: A Discussion on Azure SQL Database Security Features for the Cloud Objectionist

Abstract: This session is for the those who have security objections related to moving to the cloud or are interested in the security features of the of the Azure SQL Database, a relational database Platform as a Service offering in Microsoft Azure. There certainly are Azure SQL Database features which have parity with SQL Server engine features (Always Encrypted, TDE, RLS, etc.). But this session will take a look at security features focused on the Azure SQL Database; server firewall settings, Auditing Threat detection, Alert Rules, Role-based Access Control and configuring Azure AD Authentication. If time permits, we will step through Dynamic Data Making via the Azure portal. Hopefully the main take away will be a warm and fuzzy (and more secure) feeling about planning for cloud workloads.

Speaker(s):

Timothy McAliley

Track and Room: Enterprise Database Administration Deployment - 5-2 (DBA 2)

Title: Getting to 99.99% Uptime Delivering Operational Excellence

Abstract: How does one take advice from the top leadership experts and translate into action? As one’s responsibilities grow many more factors come into play to achieving both the realities and perception of high availability. The building of professional relationships, managing expectations, helping with setting standards and procedures are all critical components to success. While some will argue this is out of my scope of responsibilities why should I care about the building of professional relationships, managing expectations, helping with setting standards and procedures? The answer is simple because the perception is that no matter where the process breaks down it’s always a database problem. Managing customer expectations what do you really mean by 99.99% up time, translating business requirements to operational realities, commonly overlooked items that impact your 4 nines Avoiding human errors the realities and perception of high availability.

Speaker(s):

George Govantes

Track and Room: Professional Development - 7-2 (Mixed)

Title: Rewriting Your Checklist for SQL 2016

Abstract: How big should the page file be for Windows Server 2016? How many data files should SQL Server 2016’s TempDB contain? What trace flags should we use by default now?

These are questions you addressed long ago in your setup checklist. You’ve spent a lot of time with that checklist, and you’re sure it’s perfect. Or is it? When was the last time you visited that checklist? Does it make sense for SQL 2014? What about SQL 2016? Change is hard, and DBAs need to constantly challenge yesterday’s best practices to ensure they meet today’s business needs.

Join veteran DBA Mike Hillwig and his list of server administration best practices that need to be revisited for modern versions of SQL Server, especially SQL 2016.

Speaker(s):

Mike Hillwig

Track and Room: Enterprise Database Administration Deployment - 5-1 (DBA 1)

Title: SQL and VMware - more than just virtualization demos

Abstract: The demos in this session have been developed to illustrate a few key capabilities of VMware vSphere and VMware NSX that can be used to enhance the overall SQL Server implementation. As a true platform of virtualized hardware, vSphere should be considered the premier platform on which to implement SQL Server. Features such as vSphere vMotion, vSphere HA, Distributed Resource Scheduler and Fault Tolerance are complimentary to all the features and capabilities of SQL Server and create an unparalleled combination of the world’s top RDBMS and the world’s most complete and effective virtualization proposition. With network virtualization NSX can provide security enhancements unachievable with any other technology and can streamline SQL server deployment automation processes. Please join us for this demonstration of advanced vSphere and NSX feature functionality and an explanation as to how this enhances your SQL Server environment.”

Speaker(s):

Niran Even-Chen

Track and Room: Enterprise Database Administration Deployment - 7-2 (Mixed)

Title: The Phenomenal IT Consultant

Abstract: Whether you are just starting out or have been in business as an IT consultant for a while, if you desire more clients or wonder how to finally achieve success online, you are not alone. In this session we’ll cover how to identify your target market and your niche. You will learn why a strong brand is vital to your success. You will discover how to make your ideal client want to work with you and pay you what you are worth, even if you hate the selling part. This session is for you…

if you are struggling to find enough new clients,
if you feel like you are the best-kept secret in your field or if prospects love you but don’t buy from you,
if you feel like you are treading water when it comes to marketing. Join this session and get started on your way to becoming a Phenomenal IT Consultant.

Speaker(s):

Sebastian Meine

Track and Room: Professional Development - 7-3 (Prof Dev)

Title: Unit-Testing in SQL Server - An Introduction

Abstract: It’s bad enough to spend hours finding and fixing database defects, explaining to the rest of the team what went wrong and trying to clean up the mess. It’s even worse when a defect causes the end-user to make a bad decision. Database defects are far too costly and most testing practices do not adequately detect or prevent them.

In this session you’ll learn techniques to write SQL code that is resilient to defects and is easier to change and maintain. We will cover writing simple unit tests and look into more advanced topics such as faking tables and spying procedures. We will also look at how unit testing improves code quality and maintainability.

You will leave this session ready to write unit tests for your own environment to get started on the way to a defect-free and maintainable SQL Server code base.

Speaker(s):

Sebastian Meine

Track and Room: Application Database Development - 7-1 (Dev 1)

Title: Why should I care about … the plan cache?

Abstract: SQL Server is a huge product, with many different places a DBA can go to look for information on how the server is performing. So many in fact that they can often overlap, which sometimes makes it hard to understand why tackling a new tool is worth the effort. In this installment of Rick’s “Why should I care” series, he lays out a case for why working knowledge of the plan cache is critical for performance tuning efforts in real world environments. A review of relevant views and functions is included for the (newly?) motivated audience.

Perfect for those who are relatively new to performance tuning concerns, or advanced DBAs trying to figure out how to have a similar conversation with their less experienced peers, or developers who are curious as to why their DBAs drink in the morning (allegedly). This is not a deep dive into the cache, it really is primarily a session exploring why these DMOs are worth slogging through.

Speaker(s):

Rick Lowe

Track and Room: Enterprise Database Administration Deployment - 5-3 (Dev 2)

Title: Introduction to PostgreSQL

Abstract: PostgreSQL is a powerful, open source object-relational database system with decades of continuous active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows, is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages).

This talk will provide an introduction to PostgreSQL by one of the project’s committers, including the overall architecture, major features, data types, and capabilities.

Speaker(s):

Stephen Frost

Track and Room: Application Database Development - 7-1 (Dev 1)

Title: Blue Collar SQL Tricks - Make Standard Edition Work for you.

Abstract: You want Enterprise Edition of SQL Server? Not gonna happen! When we are limited by having just the Standard version we have to dig into our “Blue Collar” roots, we need to become more creative and squeeze every penny it has to offer out of it.

In this session, we will review some of the limitations that Standard has. Then review items such as basic normalization and High Availability options available to Standard. You will also learn Blue Collar techniques to implement partitioning using techniques like as indexed views and partitioned views.

Let’s dig in and learn to make use of all we have until we beg our bosses enough to get Enterprise Edition!

Speaker(s):

William Wolf

Track and Room: Application Database Development - 7-1 (Dev 1)

Title: SQL Server Databaseology: A Deep Dive Into Database Internals

Abstract: Have you ever taken apart a toaster or an alarm clock just to see how it worked? Ever wondered how that database actually functions at the record level, behind the scenes? SQL Server Databaseology is the study of SQL Server databases and their structures down to the very core of the records themselves. In this session, we will explore some of the deep inner workings of a SQL Server database at the record and page level. You will walk away with a better understanding of how SQL Server stores data and that knowledge will allow you to build better, faster databases.

Speaker(s):

John Morehouse

Track and Room: Enterprise Database Administration Deployment - 5-2 (DBA 2)

Title: Extending the SSIS Framework to be region aware

Abstract: In this demo-heavy session, we will extend the EntDNA SSIS Framework Community Edition to become region aware, tackling the problem of running groups of packages around the world on multiple servers, and get the results back to the calling server, all using a centralized, coordinated schedule.

Speaker(s):

Brad McKuhen

Track and Room: Intermediate BI - 7-4 (BI 1)

Title: Don’t Let History Be a Mystery! Temporal Data in SQL Server 2016

Abstract: It’s been said that the only constant is change, and no truism better defines the average database workload. With data constantly shifting in form and focus, DBAs and developers find themselves fielding myriad questions about whens and whys: When did this fact get updated? Why is data quality lower than it was last week? And where did my sales figures go?!? Solutions such as Change Tracking, Change Data Capture, and hand-rolled triggers can each be leveraged to help in this scenario, but with various ugly tradeoffs. SQL Server 2016 introduces Temporal Tables, a new technology that finally gets us what we’ve needed all along. In this session you’ll learn how to enable seamless and automatic history collection, take control of a great query experience, and build on a solid platform to help your users understand data history. By taking advantage of this fantastic feature, you’ll approach your next project ready to answer all of the questions that constant change brings to the table.

Speaker(s):

Adam Machanic

Track and Room: Intermediate Dev - 5-3 (Dev 2)

Title: Query Store – What is it all about?

Abstract: SQL 2016 brings us many new features but one of the most anticipated is surely the Query Store. The Query Store now allows us to track query plans as they change over time giving us a whole slew of new possibilities when it comes to tuning our queries. Even just the ability to compare a previous plan to a new plan is a huge step towards understanding what may be happening in our instance. We can even tell the optimizer which plan we want it to use. These were all either extremely difficult to do before and in some cases impossible to do. This session will give you the insight to get started using this new and wonderful feature set.

Speaker(s):

Andrew Kelly

Track and Room: Intermediate DBA - 5-2 (DBA 2)

Title: PolyBase: I now pronounce you SQL and Hadoop

Abstract: If you thought the Royal wedding of 2011 was a big deal, then you#39;re about to be blown away! This is a match made in Data Heaven. You#39;re all invited, no need to RSVP, there is plenty of food for thought in this session. There will be some background talk and a demo for querying and creating data on HDFS (using Azure Blobs). As a special gift to the happy couple, we will also have a special demo with JSON documents. This will be the greatest coming together of 2016! See you there!

Speaker(s):

Ayman El-Ghazali

Track and Room: Other - 7-5 (BI 2)

Title: Introduction to SQL Server Reporting Services 2016

Abstract: Reports, dashboards, and indicators are an essential part of your job as a report analyst. SQL Server Reporting Services (SSRS) 2016 gives you the ability to create these items to share with coworkers and management. This session will walk you through how to design, develop, deploy, and maintain reports within your environment. As a bonus, we will cover mobile reports, introduced in SSRS 2016!

Speaker(s):

Jessica Moss

Track and Room: BI Information Delivery - 7-4 (BI 1)

Title: Why Should I Care About … Partitioned Views?

Abstract: Partitioned tables are awesome and partitioned views are dead, right? Well, sure partitioned views are not sexy but there are still plenty of applications where they are critical. And not necessarily just for standard edition. If your data is time stamped, do you see different queries run against older data than new data? Do you with you could segment your data across multiple columns? Do you have data you need to partition horizontally? It’s possible partitioned views may still be for you. Come hear why this is still an important topic long after cargo pants and trucker hats went away.

Speaker(s):

Rick Lowe

Track and Room: Enterprise Database Administration Deployment - 7-1 (Dev 1)

Title: Demystifying Data Compression

Abstract: High-end storage is expensive, and SQL Server data compression can make your database smaller. So compress all the tables!

No–unfortunately, it’s not that easy. We’ll talk about how data compression actually works, and the differences between ROW and PAGE compression. As part of this, we’ll look at the costs and benefits associated with each type of compression. By the end of this session, you’ll have a better idea of how the different compression algorithms work, when compression is the right solution, as well as what type of compression to use.

Speaker(s):

Andy Mallon

Track and Room: Enterprise Database Administration Deployment - 7-2 (Mixed)

Title: Introducing Azure Machine Learning

Abstract: Not satisfied with Multidimensional Analysis Services’ data mining or maybe you are using Tabular Analysis Services? Looking for a flexible and robust predictive analytics tool? Consider Azure Machine Learning … a cloud service for advanced analytics. In this session, I quickly describe concepts and terms before jumping straight into a start-to-finish AML experiment. Join me to see how AML might meet your advanced data analysis needs.

Speaker(s):

Mark Hudson

Track and Room: Intermediate BI - 7-5 (BI 2)

Title: Security 101

Abstract: Integrating security into your database design. Learn how to use roles, schemas and encryption to secure the data. A very demo rich session that will introduce you to security on the database level. We start with understanding GRANT, REVOKE and DENY while working our way through the object hierarchy till we end up at the column level when we have a lock at encryption. This session will also cover new SQL 2016 security features and how to use them correctly.

Speaker(s):

Thomas Grohser

Track and Room: Application Database Development - 5-1 (DBA 1)

Title: SQL Server 2016: Temporal Tables and Dynamic Data Masking

Abstract: SQL Server 2016 introduces many new features and enhancements. This session will look into two of those: Temporal Tables and Dynamic Data Masking. Temporal Tables simplifies the task of building a history table to track all data changes so that you can see how the data looked at a specific point in time, while Dynamic Data Masking is used to obfuscate data from users (for example, show just the last 4 characters of your SSN). This session is >90% demos!

Speaker(s):

Wayne Sheffield

Track and Room: Enterprise Database Administration Deployment - 5-2 (DBA 2)

Title: I’m It – Survival Techniques for the Lone DBA

Abstract: Are you the only database person at your company? Are you both the DBA and the Developer? Being the only data professional in an environment can seem overwhelming, daunting, and darn near impossible sometimes. However, it can also be extremely rewarding and empowering. This session will cover how you can keep your sanity, get stuff done, and still love your job. We’ll cover how I have survived and thrived being a Lone DBA for 15 years and how you can too. When you finish this session, you’ll know what you can do to make your job easier, where to find help, and how to still be able to advance and enrich your career.

Speaker(s):

Monica Rathbun

Track and Room: Professional Development - 5-1 (DBA 1)

Title: PowerBI Internals

Abstract: This session takes a deeper dive into PowerBI. We won’t be explaining the individual components, instead we will take time to go through the technology behind the scenes. We will dig into the Vertipaq engine and how it affects performance. We will look into how customer visuals are made. Finally, we will quickly cover the architecture of the Power BI Service.

Speaker(s):

Eugene Meidinger

Track and Room: BI Information Delivery - 7-5 (BI 2)

Title: Fun with SQL Server Spatial Data

Abstract: This session is an introduction to the spatial features in SQL Server. In this session, you will learn how to create, procure and leverage spatial data. You will be made aware of tools you can use to integrate your own spatial data with a variety of public data sources such as the Census Bureau, National Weather Service, etc. Functions and T-SQL commands related to spatial data analysis will be demonstrated. We will end the session by using the geometry data type to actually mimic a bitmapped picture using SQL (that’s the fun part!).

Speaker(s):

Mindy Curnutt

Track and Room: Application Database Development - 5-3 (Dev 2)

Title: SQL Server on Windows Core. Installation and Configuration.

Abstract: Would you consider building your next SQL Server in Windows Core Environment? Do you have enough knowledge? In this session we will go step by step through an installation, remote configuration and administration of SQL Server using PowerShell scripts.

Speaker(s):

Slava Murygin

Track and Room: Intermediate DBA - 5-3 (Dev 2)

Title: Hi, my name is Powershell, let’s be friends! An Intro to PoSH

Abstract: Powershell wants to be your friend - your very powerful friend. In this session we will go over some Powershell basics that will help get you started as well as some known “gotchas” when working in Powershell. This is a beginner session - no Powershell experience necessary. WARNING: You may get warm-fuzzies about Powershell by attending this session.

Speaker(s):

Amy Herold

Track and Room: Enterprise Database Administration Deployment - 7-2 (Mixed)

Title: Automated SQL Server installation and configuration using PowerShell

Abstract: Using the SQL setup wizard and management studio (SSMS) to install and configure a new SQL server is a time-intensive process. PowerShell scripts can greatly reduce the time required to complete the process. They can also ensure build standardization throughout your SQL environment. In this session we will look at PowerShell scripting, including the basic syntax and commandlets needed to automate the installation and post-install configuration of a SQL Server.

Speaker(s):

Jamie Wick

Track and Room: Enterprise Database Administration Deployment - 5-1 (DBA 1)

Title: Troubleshooting Blocking for Beginners

Abstract: Your SQL Server is slow, and you suspect blocking. You need to set up simple, lightweight monitoring using free tools to document who’s holding locks, who’s stuck waiting, and which queries are causing deadlocks. In this session we will work through three common scenarios where blocking problems steal your performance – and sometimes even kill your queries! You’ll learn how to cut through the confusion with free scripts that reveal why queries are slowing down your SQL Server.

Speaker(s):

Kendra Little

Track and Room: Intro DBA - 5-1 (DBA 1)

Title: WIT: Identifying, Understanding and Combating Gender Bias

Abstract: Gender Bias is something we’re all guilty of. It’s typically unconscious and often stems from long held misperceptions about women and job responsibilities. We’ll learn about the origins of some of these biases and how to identify gender bias when we see it. We’ll discuss some strategies for how both men and women can combat this at work and in our every day lives. This session is about developing positive solutions to a problem that often goes undiscussed.

Speaker(s):

Rie Irish

Track and Room: Professional Development - 7-3 (Prof Dev)

Title: Understanding SQL Server 2016 Always Encrypted

Abstract: Always Encrypted is a highly-touted new feature of SQL Server 2016 that promises to make encryption simple to use and transparent to applications while still protecting the data both at rest and in motion, even from high-privilege users such as developers and DBAs. Does that sound too good to be true? It isn’t - Always Encrypted is an incredible feature - but like any new technology, it does have some limitations. In this session, you’ll see how to configure Always Encrypted, and we’ll talk about when you should and shouldn’t use it in your environment.

Speaker(s):

Ed Leighton-Dick

Track and Room: Application Database Development - 7-1 (Dev 1)

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: Intermediate DBA - 5-3 (Dev 2)

Title: Using Excel Web Services to Create Dashboards in SharePoint

Abstract: In this session, we’ll do a deep dive into Excel Web Services, a feature of SharePoint, that allows us to use Excel to create custom dashboards. Dashboards are pages served up by SharePoint and we’ll look at how to create these pages, add Excel Web Services web parts to these pages, and arrange these web parts and “connect” these parts to communicate with each other, to create interactive, updating dashboards for our users.

Speaker(s):

David Patrick

Track and Room: Analytics and Visualization - 7-4 (BI 1)

Title: Introduction to SQL Server Integration Services 2016

Abstract: SQL Server Integration Services (SSIS) provides database administrators, business intelligence developers, and application programmers the ability to quickly and easily move and transform data. Whether your data in on-premises or in the cloud, within SQL Server or stored in text files, clean or dirty, SSIS can help you extract, transform, and load (ETL) the information. Join this session to learn more about SSIS, specifically how to develop, deploy, and maintain SSIS packages.

Speaker(s):

Jessica Moss

Track and Room: BI Platform Architecture, Development Administration - 7-4 (BI 1)

Title: R For the SQL Server Developer

Abstract: R is the premiere language for data analysis. If the world of data science sounds fun and exciting, now is the time to get into R. We will walk through the core constructs of R, learn how to retrieve data from flat files and databases, and get a peek at the power behind R. This session will also give resources on where to go in order to become more familiar with statistics, R the language, and the R package ecosystem.

Speaker(s):

Kevin Feasel

Track and Room: Analytics and Visualization - 7-5 (BI 2)

Speakers

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

Adam Machanic

Twitter: - @AdamMachanic

LinkedIn: Adam Machanic

Contact: http://sqlblog.com/blogs/adam_machanic

Adam Machanic is a Boston-based SQL Server developer, writer, and speaker. He focuses on large-scale data warehouse performance and development, and is the author of the award-winning SQL Server monitoring stored procedure, quot;sp_WhoIsActive.quot; He has contributed to several books on SQL Server, including quot;T-SQL Queryingquot; (Microsoft Press, 2015). He is a Microsoft Most Valuable Professional (MVP) for SQL Server.

Amy Herold

Twitter: - @texasamy

LinkedIn: Amy Herold

Contact: http://www.sqlkitten.com/

Amy Herold is currently a Premier Field Engineer with Microsoft, specializing in APS. Prior to this, she was a Sr. Database Administrator, focusing on PowerShell and automation. She is also currently the Director of Programs for the North Texas SQL Server User Group (NTSSUG). She frequently speaks at SQLSaturday and user group events across the United States and has also participated in numerous Women in Technology sessions as a panelist. Amy currently blogs at sqlkitten.com.

David Klee

Twitter: - kleegeek

LinkedIn: David Klee

Contact: http://davidklee.net

David Klee is a Microsoft Data Platform MVP and VMware vExpert with a lifelong passion for technology. David spends his days focusing on the convergence of data and infrastructure as the Founder of Heraflux Technologies. His areas of expertise include cloud, virtualization, performance, and business continuity. David speaks at a number of national and regional technology related events, including PASS Summit, VMware VMworld, SQLBits, SQLSaturday events, and many SQL Server User Groups.

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.

Andy Mallon

Twitter: - AMtwo

LinkedIn: Andy Mallon

Contact: http://www.AM2.co

Andy is a Data Platform MVP and SQL Server DBA that has managed databases in the healthcare, finance, e-commerce, and non-profit sectors. He has been supporting high-volume, highly-available OLTP environments with demanding performance needs since 2003.

Andy is the founder of the BostonSQL User Group, and previous co-organizer of SQLSaturday events in Boston. He blogs at am2.co.

Andy lives just outside Boston, Massachusetts, USA with his husband and their two dogs.

David Klee

Twitter: - kleegeek

LinkedIn: David Klee

Contact: http://davidklee.net

Jamie Wick

Twitter: - Jamie_Wick

LinkedIn: Jamie Wick

Contact: http://blog.wicktech.net

Jamie Wick is the Systems Database Engineer for The College of William Mary and has been working with SQL databases for the past 10+ years. His background includes working for several years as a SQL SysAdmin for the University of Queensland (Australia), a Masters degree in Computer Information Systems from Boston University, and assorted Microsoft SQL certifications. He is the Chapter Leader of the Richmond SQL Server Users Group, a volunteer and speaker at regional SQL events (User Groups/SQLSaturdays), helps run the SQLSaturday RVA events, and is an avid photographer.

Adam Machanic

Twitter: - @AdamMachanic

LinkedIn: Adam Machanic

Contact: http://sqlblog.com/blogs/adam_machanic

Rie Irish

Twitter: - IrishSQL

LinkedIn: Rie Irish

Rie lives with her family just north of Atlanta, Georgia. She worked as a SQL Server DBA, manager director for over 20 years. She’s worked in many industries including the non-profit sector, education, big pharma, and e-commerce. She was awarded the MVP in the Data Platform 3 times beginning in 2017 and gave that up to accept her role as a Senior Program Manager with Microsoft in 2019. She is very involved with the Atlanta MDF User Group, SQLSaturday Atlanta and is co-leader of the PASS Women in Tech virtual group.

Ayman El-Ghazali

Twitter: - thesqlpro

LinkedIn: Ayman El-Ghazali

Contact: http://www.thesqlpro.com

Ayman is a passionate SQL Server DBA, Developer, and BI Developer. His passion for technology started when he was a young boy playing DOS games on his father’s computer. He can be reached via his blog or twitter handle and is looking forward to connecting with other SQL Geeks.

David Patrick

Twitter: - DavidEPatrick

LinkedIn: David Patrick

Contact: http://www.madsharepoint.com

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

Mark Hudson

Twitter: - HMarkHudson

Mark Hudson is an MCITP with many years of experience in business intelligence and data analysis. He has developed data solutions using numerous platform tools including multiple SQL Server versions. He is a data architect and developer with CapTech (www.captechconsulting.com) and served as a leader of the Richmond SQL Server User Group (www.richmondsql.org).

Mindy Curnutt

Twitter: - @sqlgirl

LinkedIn: Mindy Curnutt

Contact: http://www.mindycurnutt.com

Mindy Curnutt is a 5X Microsoft Data Platform MVP, Business Owner and Entrepreneur. Her specialties include SQL Server hardware, configuration, migrations, scalability, performance tuning. She has been actively involved in the SQL Server Community for over two decades and has become a well known speaker within the SQL and Transportation Management communities. She is a two-time PASS Volunteer of the Month, has presented at 6 SQLPASS Summits, Live360, DevConnections, MVPMix and too many SQLSaturdays to count. She is currently the President of the North Texas SQL Server User Group out of Dallas/Fort Worth, TX.

Rick Lowe

Twitter: - DataFLowe

LinkedIn: Rick Lowe

Contact: http://dataflowe.wordpress.com/

Rick is a Microsoft Certified Master with more than 20 years of SQL Server experience in a variety of roles. He currently lives in Washington state and works as an independent consultant providing remote performance DBA and performance tuning services for clients in the USA and Canada. His first exposure to SQL Server was as a database developer, but over time he became more and more interested in how the database engine operated… eventually specializing more on performance issues than code.

Rick will work with all things relational, but most enjoys helping smaller companies get better performance from MSSQL, as well as smoothing over relationships between DBA and development teams.

Monica Rathbun

Twitter: - SQLEspresso

LinkedIn: Monica Rathbun

Contact: http://www.sqlespresso.com

Monica Rathbun lives in Virginia, is a Microsoft MVP for Data Platform and Microsoft Certified Solutions Expert. She has nearly two decades of experience working with a wide variety of database platforms with a focus on SQL Server and the Microsoft Data Platform. She is a frequent speaker at IT industry conferences on topics including performance tuning and configuration management. She is the Leader of the Hampton Roads SQL Server User Group and a Mid‐Atlantic PASS Regional Mentor. She is passionate about SQL Server and the SQL Server community, doing anything she can to give back. Monica can always be found on Twitter (@sqlespresso) handing out helpful tips. You can find Monica blogging at sqlespresso.com

Stephen Frost

Twitter: - @net_snow

LinkedIn: Stephen Frost

Contact: http://info.crunchydata.com/blog

As a PostgreSQL major contributor and committer, Stephen has brought a number of features to PostgreSQL, including the role system, column-level privileges, and row-level security. He has spoken previously at numerous conferences, including pgConf.EU conferences in Amsterdam, Dublin and Madrid, PostgresOpen in Chicago and Dallas, PGCon in Ottawa, PGConf.US in NYC, and SCALE in Pasadena.

Jessica Moss

Twitter: - @jessicammoss

Contact: http://www.jessicammoss.com

Jessica M. Moss is a well-known architect, speaker, author, and Microsoft MVP of SQL Server Business Intelligence. Jessica#39;s expertise includes data warehouse modeling, Integration Services ETL, Analysis Services semantic modeling, Reporting Services report design, and helping customers across industries successfully implement and enhance their BI solutions. She enjoys sharing her knowledge with the SQL community and has co-authored numerous technical books.

David Dye

David is a Sergeant with the Cape Coral Police Department and currently works as a database administrator and developer in the Administrative Services Division. He began his career with the police department in 1990 in the patrol division and worked various assignments until being promoted to Sergeant in 1998. Based on his education and experience David was assigned to his current position in 2002 and is responsible for database administration, software integration, and development for public sa

Wayne Sheffield

Twitter: - @DBAWayne

LinkedIn: Wayne Sheffield

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

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

Jessica Moss

Twitter: - @jessicammoss

Contact: http://www.jessicammoss.com

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”.

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.

Slava Murygin

Twitter: - SlavaSQL

LinkedIn: Slava Murygin

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

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

Kendra Little

Twitter: - Kendra_Little

LinkedIn: Kendra Little

Contact: http://littlekendra.com

Kendra Little is a Microsoft Certified Master and a Microsoft MVP. Kendra fell in love with the challenge of deploying software to a complex database environment when she worked in a build operations team at a software startup. She went on to become a database administrator for performance critical databases at Microsoft Corporation. Since then, Kendra has worked internationally as a teacher and consultant, and founded the training site SQL Workbooks. She joined Redgate as a Product Evangelist in 2018.

William Wolf

Twitter: - sqlwarewolf

LinkedIn: William Wolf

Contact: http://www.sqlwarewolf.com

Bill is the Manager of SQL Server Performance Tuning for RDX. He works with over 400 customers on solutions within the SQL Server environment and specialized in code tuning and mentoring the team within RDX. He has become a SQLSaturday veteran speaking at nearly 40 SQLSaturdays in the last 3 years. He has also spoken at Summit and is an Idera Ace class of 2018. Bill is active in the Pittsburgh SQL Server User Group. He is also the chapter lead for the DevOps Virtual User Group. He is passionate about educating users on SQL Server and mentoring others.

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

Andrew Kelly

Twitter: - gunneyk

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

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

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.

Rick Lowe

Twitter: - DataFLowe

LinkedIn: Rick Lowe

Contact: http://dataflowe.wordpress.com/

Rick will work with all things relational, but most enjoys helping smaller companies get better performance from MSSQL, as well as smoothing over relationships between DBA and development teams.

Timothy McAliley

Twitter: - sysframeworks

LinkedIn: Timothy McAliley

I am currently a Microsoft Cloud Solutions Architect in the Washington, DC area. Previously, I was a Microsoft Technology Solutions Professional (TSP), a Microsoft Account Technology Strategist and a SQL Server Premier Field Engineer. Prior to Microsoft, I was a Technical Trainer and DBA in the Enterprise Security Group at Symantec . I have been in IT for over 20 years. My particular interests are IT operations, IT auditing, IT audit frameworks, IT service management (ITSM), ITIL, information security, project management, and database/application tier high availability solutions. I also co-run the Northern Virginia SQL Server User Group ( @novasl) and also co-run the Azure Datafest events.

Sebastian Meine

Twitter: - @sqlity

LinkedIn: Sebastian Meine

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

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

Niran Even-Chen

Twitter: - @niranec

Contact: http://cloud-abstract.com

Niran Even-Chen (@niranec) is a Staff Solution architect at VMware Inc. In his role as a Microsoft enterprise applications architecture specialist Niran is responsible for developing solutions for SQL Server with VMware solutions, writing white papers and is also a frequent speaker in different venues such as VMUG conferences, SQLSaturday user groups, VMworld conferences and more. Niran is certified as VMware certified design expert (VCDX) #142 for datacenter virtualization and Cloud with 15 years of experience in the industry designing and architecting enterprise level solutions.

Ed Leighton-Dick

Twitter: - eleightondick

LinkedIn: Ed Leighton-Dick

Contact: http://www.edleightondick.com

Ed Leighton-Dick is a Microsoft MVP, SQL Server performance and architecture specialist, and Founder/Principal Consultant of Kingfisher Technologies. He is a frequent volunteer with PASS, including current roles as a Regional Mentor, co-leader of I-380 PASS local group, and co-leader of the HA/DR virtual group. He can often be found teaching sessions at local, regional, and national events, including user groups, SQLSaturday, and PASS Summit.

Eugene Meidinger

Twitter: - @sqlgene

Contact: http://www.sqlgene.com

Eugene Meidinger works as a BI consultant and full time Pluralsight author. He currently focuses on content on Power BI and related products. He also leads the Pittsburgh Power BI User Group. He is certified in querying and administering SQL Server.

David Dye

Mike Hillwig

Twitter: - @mikehillwig

LinkedIn: Mike Hillwig

Contact: http://www.mikehillwig.com

Veteran DBA Mike Hillwig is a native Pittsburgher and resident of the Boston Suburbs. He’s a DBA Manager for a financial software company that’s owned by one of the world’s largest bank. Mike has been working with SQL Server since version 7 and has a background in infrastructure and network. Today, he manages a team of DBAs around the globe.

George Govantes

LinkedIn: George Govantes

SQL Architect and Senior SQL Database Administrator with over 20 years of experience turned Chief Information Security Officer, Certified Information Security Manager, and Governance Risk and Compliance Certified Professional that helps organizations develop cloud and on-prem Identity and Information Security programs. He also trains and consults in the area of IT leadership and the development of high-performance teams.

Mindy Curnutt

Twitter: - @sqlgirl

LinkedIn: Mindy Curnutt

Contact: http://www.mindycurnutt.com

John Morehouse

Twitter: - SQLrUs

LinkedIn: John Morehouse

Contact: http://www.sqlrus.com

John Morehouse is currently a Consultant with Denny Cherry Associates living in Louisville, Kentucky. With over 2 decades of technical experience in various industries, John now focuses on the Microsoft Data platform and specializes in Microsoft SQL Server. He is honored to be a Microsoft Data Platform MVP, VMWare vExpert, Friend of Red Gate, Sentry One PAC member Community Ambassador, and 2016 Idera Ace. John has a passion around speaking, teaching technical topics, and giving back to the technical community as much as possible. He is a user group leader, SQLSaturday organizer, and former PASS regional mentor. He is also a blogger, avid tweeter, and a frequent speaker at SQLSaturday’s as well as other conferences.

Andrew Kelly

Twitter: - gunneyk

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

Sebastian Meine

Twitter: - @sqlity

LinkedIn: Sebastian Meine

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

Brad McKuhen

Contact: http://www.bradmckuhen.com

Brad McKuhen is a SQL Server Architect for Microtech Technologies, in the Washington, DC area. He has been working with SQL Server in some form or another since SQL Server 2000, and has been in IT for over 20 years. In his spare time, you#39;ll find him devoted to his family#39;s activities, and studying for the next certification.

SQLSaturday #574 - Washington DC 2016

Sessions

Title: The Art of War with Bad Code

Title: Creating Dynamic Packages

Title: The Many Paths of Consulting

Title: Enhancing your career: Building your personal brand

Title: Top 10 Dos and Don’ts for Clustered SQL Server Implementations

Title: Imposter Syndrome: Are You Faking It Will they Find Out?

Title: Location Location Location Preparing and Presenting Geographic Data

Title: A Discussion on Azure SQL Database Security Features for the Cloud Objectionist

Title: Getting to 99.99% Uptime Delivering Operational Excellence

Title: Rewriting Your Checklist for SQL 2016

Title: SQL and VMware - more than just virtualization demos

Title: The Phenomenal IT Consultant

Title: Unit-Testing in SQL Server - An Introduction

Title: Why should I care about … the plan cache?

Title: Introduction to PostgreSQL

Title: Blue Collar SQL Tricks - Make Standard Edition Work for you.

Title: SQL Server Databaseology: A Deep Dive Into Database Internals

Title: Extending the SSIS Framework to be region aware

Title: Don’t Let History Be a Mystery! Temporal Data in SQL Server 2016

Title: Query Store – What is it all about?

Title: PolyBase: I now pronounce you SQL and Hadoop

Title: Introduction to SQL Server Reporting Services 2016

Title: Why Should I Care About … Partitioned Views?

Title: Demystifying Data Compression

Title: Introducing Azure Machine Learning

Title: Security 101

Title: SQL Server 2016: Temporal Tables and Dynamic Data Masking

Title: I’m It – Survival Techniques for the Lone DBA

Title: PowerBI Internals

Title: Fun with SQL Server Spatial Data

Title: SQL Server on Windows Core. Installation and Configuration.

Title: Hi, my name is Powershell, let’s be friends! An Intro to PoSH

Title: Automated SQL Server installation and configuration using PowerShell

Title: Troubleshooting Blocking for Beginners

Title: WIT: Identifying, Understanding and Combating Gender Bias

Title: Understanding SQL Server 2016 Always Encrypted

Title: CONVERT_IMPLICIT is a hidden danger

Title: Using Excel Web Services to Create Dashboards in SharePoint

Title: Introduction to SQL Server Integration Services 2016

Title: R For the SQL Server Developer

Speakers

Sponsors