SQLSaturday #560 - Charlotte 2016

Event Date: 09/17/2016 00:00:00

Event Location:

Central Piedmont Community College (CPCC)
2800 Campus Ridge Road
Charlotte, North Carolina

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: SSIS-Lightning fast processing using Parallel processing-Result in Power BI

Abstract: SSIS package can be run in Parallel and Optimized .In this session we will learn how to improve SSIS Package performance using parallel processing and Optimization. This knowledge will encourage development of better performing packages and optimize package performance.When creating an efficient and robust solution for Extract, Transform and Load Process, Lot of things do matter especially when you are working with huge size of databases. Challenge is not only to meet functional requirements Also to look at the performance requirements. This session will also cover best practices to enhance and boost performance of a SSIS package. You will see all result of session in Power BI real time - Time and all Batch run details

Speaker(s):

Vishal Pawar

Track and Room: Database Development - 1233

Title: Service Broker - Put Me In Coach

Abstract: This session is an introduction to Service Broker basics and how you can use it to for an alternative to ETL, batch processing and other asynchronous operations. Service Broker allows you to process your data asynchronously in a single instance. It makes for a near real time ETL process.

We will start off with the basic components of Service Broker. Then use what we have learned to configure it to process some real life data using American Football Plays on a single database deployment. In addition, we will then use Service Broker as a replication alternative to show the ETL capabilities using databases on two separate instances.

At the end of this session, you will have the knowledge to use Service Broker for batch processing, ETL or even an alternative to replication.

Speaker(s):

William Wolf

Track and Room: Database Development - 1236

Title: IO Tuning 101

Abstract: One of the most common problems I have encountered as a DBA is the complaints from users that a particular query is slow, just one query. Many times one that used to run in acceptable time, but now has slowed down substantially.

In this session we will show some of the causes for this, with emphasis on I/O requests being too high for the query.

First part of the session will explain how to find these numbers, looking at a few queries with some major performance issues, including explaining why they have a problem.

The second part will focus on how to reduce I/O requests.

All of t his can be done without the need for any 3rd party tools, all within the scope of what is available to SQL Server, all versions, all editions, including Azure.

Speaker(s):

Anders Pedersen

Track and Room: Enterprise DBA - 1236

Title: Performance Tuning - Analyzing Execution Plans

Abstract: Did you ever get woken up at night from a call from a user screaming about poor query performance, but didn’t really know how to begin attack the problem? In this session, we will explore the basics of execution plan analysis and how to single out issues that pertain to base table operations. In this presentation, we will identify what indexes are being used by the SQL Optimizer, the different type of index operations that are performed by SQL Server and which operations are generally considered the preferred method of data retrieval. We will discuss how to determine if the indexes used by the Optimizer are optimal, according to best practices, and the exceptions to those cases. Finally, we will cover the relationships between different types of index operations and joins within SQL Server, including how the SQL Optimizer determines which join type it will use, along with the pros and cons of each join operation

Speaker(s):

Konstantin Melamud

Track and Room: Enterprise DBA - 1225

Title: 20 Minute Tabular Model

Abstract: Are you familiar w/ SSAS Multidimensional and curious about Tabular? Having trouble deciding between cubes and tabular models? Then this is your session!

Analysis Services Tabular was introduced back in 2012, and yet it has only just started to emerge from the Proof-Of-Concept phase to a legitimate production alternative in most IT departments. Based on xVelocity, a highly compressed in-memory technology, Tabular models provide considerable performance improvements over Multidimensional models in many scenarios. And with major advancements in 2016, Tabular has never been a more appealing solution. But, as is the case with any new technology, there are certain limitations of which to be aware.

Join me in this session and learn what a Tabular model is, how it fits into the Microsoft BI stack, the major factors to consider when choosing between Tabular and Multidimensional technologies, and finally a live step-by-step demo where we’ll build and deploy a Tabular model.

Speaker(s):

Bill Anton

Track and Room: BI DW - 1237

Title: SQL Server 2016 “Hidden Gems”

Abstract: By far the most important SQL Server release since the heady days of 2005, SQL Server 2016 represents a huge leap forward in a number of key areas. You’ve no doubt heard plenty about such features as Query Store, JSON support, Polybase, and the other big-ticket items. But there are also a number of very cool features that don’t usually make the top 10 lists. In this talk you’ll learn about enhancements to indexing (including both Columnstore and traditional b-tree indexes), DMVs, compression, string handling, encryption, configuration, and even timezone support. These smaller features may not be highlighted in the latest glossy ads from Microsoft’s marketing department, but they’re the kinds of things that add up to make your life easier. Attend this session to learn all sorts of new and different reasons to upgrade as quickly as possible.

Speaker(s):

Adam Machanic

Track and Room: Database Development - 2218

Title: Analysis Services: Show Me Where It Hurts

Abstract: “It’s Slow!” are probably the two most dreaded words for any database professional (right behind “You’re fired!”)

What’s slow? Since when? Compared to what?

Join me in this “something-everyone-should-be-doing-but-isn’t” session, where we will discuss baselines and performance monitoring for your SQL Server Analysis Services (SSAS) environment. We’ll cover what a baseline is, what information it needs to include, and how it can help you troubleshoot immediate problems and proactively avoid them in the future. Walk away from the session with a plan that you can implemented next week to help avoid being caught off guard by SSAS performance issues and to make troubleshooting a breeze.

Speaker(s):

Bill Anton

Track and Room: BI DW - 1223

Title: Maximizing Microsoft SQL Server Storage Investments

Abstract: 2016 is the year of All-Flash for primary storage and Dell EMC’s industry leading portfolio of All-Flash arrays unlock the speed, efficiency, and agility that your business stakeholders have been demanding. Whether supporting 1,000 or 10,000,000 IOPS, EMC has a broad portfolio to ensure consistent sub-millisecond response time regardless of workload type.

Beyond just production database performance, EMC provides robust database repurposing via our iCDM or Integrated Copy Data Management capabilities. Creating and maintaining test/dev, near real-time analytic, or sandbox environments has never been simpler. Join us and hear how we can address the needs of all of your Microsoft SQL Server instances.

Speaker(s):

John Holtz

Track and Room: Vendor Sessions - 1225

Title: Enterprise Machine Learning with R and SQL Server

Abstract: R is a pure data science and statistics scripting language. It is considered the best fit for Machine Learning. With more than 5000 packages all machine learning algorithms are covered and improving. R packages help you prepare the data, e.g.: packages for cross validation with N folds, build machine learning models, validation, create plots and to generate predictions. SQL Server 2016 and R Server are a perfect match for building enterprise grade solutions that support deployments for real time predictions and continuous model updates. Join this session for an overview based on sample cases about how to build enterprise grade machine learning solutions with SQL Server and R.

Speaker(s):

Paco Gonzalez

Track and Room: Advanced Analytics - 2215

Title: Using PowerBI and SQL Server to Create Management Cadence Dashboards

Abstract: Learn how to create dashboards that surface key performance metrics in real time using the power of SQL Server and PowerBI. You will learn how to collect information for various data sources to publish data related to revenue, expenses, sales forecasts and human resources, all from one easy to use dashboard.

Speaker(s):

Patrick Thompson

Track and Room: Strategy and Architecture - 1223

Title: Stop Doing That! 5 Common T-SQL Anti-Patterns

Abstract: There are several programming design patterns that work great in object oriented code but do not scale inside SQL Server. Things like Scalar-Value functions, Unions, CTEs, and row by row processing can make for more work then you would expect.

In this session, we will focus on several anti-patterns like these and show how to rework them to improve scale in the database engine.

By the end of the session, you will be able to quickly identify these common anti-patterns and analyze their sometimes unclear cost to the engine. Heading back to the office, you’ll be able to identify pain points in your longest running queries from a T-SQL perspective and become a code tuning rockstar!

Speaker(s):

William Wolf

Track and Room: Database Development - 2215

Title: Sparkhound Jeopardy

Abstract: Join us for a fun game of Sparkhound-themed Jeopardy, where we will choose three contestants from the audience for high-stakes game where your answers must be in the form of a query. The audience can win prizes too if our brave contestants can’t. Learn some PowerShell, SQL, and trivia while you’re at it!

Speaker(s):

William Assaf

Track and Room: Vendor Sessions - 1223

Title: Practical PowerShell for the SQL Developers and DBA’s - 0 to 60 in 60 mins

Abstract: PowerShell is always something you heard about and wanted to use but never did! Starting with the resources available for a PowerShell newbie, we will advance to what pro’s use to automate their database activities and beyond, for both DBA’s and developers. The goal of this session is to get you immersed in PowerShell. Ask questions and learn how PowerShell can enable you and more importantly do your job for you (the way, future is heading). We will also look at free libraries and tools to help you advance your automation abilities. Common automation scenarios is the theme! Anything done with with clicks can be automated.

Speaker(s):

Jana Sattainathan

Track and Room: Database Development - 2214

Title: Getting to know U-SQL

Abstract: With so many languages around to extract, transform, analyze, and visualize data, Microsoft introduced yet another language : U-SQL. In this session, we’ll take a look at what U-SQL is, what it brings to the table, and how it differs from (or overlaps with) the existing constructs (T-SQL, SQL CLR, DAX/MDX, PowerQuery/M, R etc.,). We’ll go over step-by-step in getting started with U-SQL, and review some use case scenarios.

Speaker(s):

Azhagappan Arunachalam

Track and Room: Cloud Data Platform - 1225

Title: Efficient table design

Abstract: The importance of proper table design cannot be underestimated. Misconceptions could lead into serious problems not only in terms of database performance, but also it can effect disk space management and interactivity of user interface as well. In this session the audience will have a sensible walk-through of database and table design in detail, encompassing a number of key areas of focus ranging from Data Types to FILESTREAM implementation. Discuss most common a table design mistakes. Find out efficiency of one type over another, IDENTITY vs. SEQUENCE vs. GUID to support PK uniqueness, pros and cons of using composite Primary Key and SPARSE column, and more.

Speaker(s):

Alex Grinberg

Track and Room: Enterprise DBA - 1233

Title: Replication v. AlwaysOn, the great debate

Abstract: Join Microsoft bloggers Chris Skorlinski, ReplTalk and Curt Mathews, SQLAlwaysOn in great debate, Replication v. AlwaysOn. They’ll go head to head on topics such as High Availability, Disaster Recovery, Performance, and Customization. Bring your own questions and join the discussion to help learn how these technologies can best be used in your company or organization.

Speaker(s):

Chris Skorlinski

Track and Room: Strategy and Architecture - 1237

Title: APPLY Yourself

Abstract: Microsoft introduced the APPLY operator in SQL Server 2005. This under-used, non-standard operator can help us solve a number of common (and not-so-common) problems with elegant code which performs well. We will look several problem spaces in which the APPLY operator shines, such as joining to table-valued functions, getting the top N child records for each parent record, string splitting, and word matching. With the use of these examples, we will gain a deeper understanding of when to use the APPLY operator.

Speaker(s):

Kevin Feasel

Track and Room: Database Development - 1225

Title: SQL Server Permissions and Security Principals

Abstract: A ground-floor introduction to SQL Server permissions starting with the basics and moving into the security implications behinds stored procedures, views, database ownership, application connections, consolidated databases, application roles and more. This class is perfect for DBA’s, developers and system admins.

Speaker(s):

William Assaf

Track and Room: Database Development - 1223

Title: Mastering and Enhancing Company Data

Abstract: Getting a good 360 degree view of organizations (customers or vendors) or doing customer centric analysis is often complicated as a result of bad data/ duplicate data / inconsistent data coming from multiple systems. In addition, there are external factors like mergers and acquisitions, inter-company relationships and other nuances that may not be captured in source systems. Getting a clear picture of customer and vendor data can not only provide a clear picture for analysis of information, but also aid in critical risk management functions. In this session, you will learn about some techniques and data services from DB that you can use to clean and enhance your data.

Speaker(s):

Rushabh Mehta

Track and Room: Strategy and Architecture - 1237

Title: Inside of Indexes

Abstract: We will go through Clustered and Non Clustered index internals. How Indexes are allocated and how SQL Server uses indexes in Select operations.

In that session we will use DBCC IND and DBCC PAGE and dig into pages’ binary code to understand how SQL Server uses different kinds of Indexes.

Speaker(s):

Slava Murygin

Track and Room: Enterprise DBA - 2214

Title: Administring SSIS 2012, 2014 and 2016 for DBAs

Abstract: Make your SSIS Life easy by learning SSIS administration. There is lots of new stuff to learn in SSIS 2012 and 2014, to name a few: SSIS Catalog, Environmental Parameters, Encrypting passwords. We will cover new upcoming features in 2016.

Speaker(s):

Ravi Kumar

Track and Room: Enterprise DBA - 1236

Title: Building Blocks of Cortana Intelligence Suite in Azure

Abstract: Join us for a practical look at the components of Cortana Intelligence Suite for information management, data storage, analytics, and visualization. Purpose, capabilities, and use cases for each component of the suite will be discussed. Expertise required for implementation of each component will be covered as well. If you are a technology professional who is involved with delivering business intelligence, analytics, data warehousing, or big data utilizing Azure services, this technical overview will help you gain familiarity with the components of Cortana Intelligence Suite and its potential for delivering value.

Speaker(s):

Melissa Coates

Track and Room: Cloud Data Platform - 1225

Title: Managing Database Projects in Visual Studio 2013

Abstract: Microsoft’s Visual Studio 2013 provides a great way for database project teams to manage databases within the Software Development Lifecycle. Learn how it enables you to create, manage, source control, schema compare, and deploy database objects. In this presentation, I will break down the feature set of database development in Visual Studio 2013 then walk through a demo and offer some tips for SQL database developers to effectively manage their databases.

Speaker(s):

Luke Donley

Track and Room: Database Development - 1223

Title: Encrypting Data within Sql Server

Abstract: Data breaches abound! Sql Server has several options to encrypt the data, Transparent Data Encryption, Cell Level Encryption and Sql Server 2016 Always Encrypted. Let’s review each option to hide the encrypt the data. Let’s also look at new options to hide data with Always Encrypted.

Speaker(s):

Thomas Norman

Track and Room: Enterprise DBA - 1233

Title: SQL Azure Database - No CDC, no problem!

Abstract:

Azure SQL Database, No CDC No Problem! Come see how I solved that lack of CDC in SQL Azure Database by leveraging a new feature in SQL Azure database and SQL Server 2016- Temporal tables. In this in depth 300/400 level session I will demonstrate the techniques that I created to simulate CDC in SQL Azure Database. We will examine the code that implements the solution, the code that automatically writes code for you and a wizard that makes it simple to consume.

Speaker(s):

boB Taylor

Track and Room: Database Development - 2218

Title: Managing Very Large Databases with SQL Server

Abstract: If some of your databases have grown to over 1TB and it has become a challenge to maintain them - or if you are anticipating what to do in the future when they do - then this talk is for you! In this session, I will provide some practical advice on managing VLDBs with SQL server, focusing on common problem areas for new and experienced DBAs alike, including index maintenance, integrity checks, archival, backups and restores.

Speaker(s):

Brian Carrig

Track and Room: Enterprise DBA - 1233

Title: Biml and SSIS Frameworks

Abstract: You’ve probably heard that it’s a data integration best practice to build small, unit-of-work SSIS packages. You’ve heard that with Biml you can create a lot of SSIS packages in very little time. You follow this advice and end up with dozens of SSIS packages. Now what? A metadata-driven SSIS Execution Framework will simplify the execution of several SSIS packages down to a simple, one-line stored procedure call. But then, how does one manage all the metadata required to populate the SSIS Execution Framework? Biml to the rescue!

Speaker(s):

Andy Leonard

Track and Room: BI DW - 2218

Title: Winning with Columnstore - A Customer Story

Abstract: This session will feature a real story of a customer who was running into performance and scaling issues on a big iron Oracle RAC system and why they decided to consider the magic of the Column Store for this situation. Discussion will focus on the existing environments for testing both SQL 2016 and Oracle as well as the methodologies used for testing. We will examine the decisions made for choosing indexes (both traditional and column store) for the main tables in the data warehouse as well as the partitioning strategies employed. We will wrap up the discussion with the results of the testing and where they are now.

Speaker(s):

Rick Heiges

Track and Room: Enterprise DBA - 2214

Title: What’s your Imperative doing in my Declarative?

Abstract: T-SQL is one of a minority of computer languages where you describe the results rather than code an algorithm. Unfortunately, many people use habits and constructions learned in imperative languages such as C# or Java when writing T-SQL Code. In this all-demo session we will explore several such commonly used constructions that are detrimental to SQL Server performance and scalability.

Speaker(s):

Geoff Hiten

Track and Room: Database Development - 2215

Title: Disaster Recovery From On Premises to Azure

Abstract: Recovery in the cloud is now easier and more convenient than ever. This session describes some common scenarios and reviews the steps needed to prepare for a disaster with a recovery in Azure. We will focus on the IAAS offerings.

Speaker(s):

Carlos L Chacon

Track and Room: Enterprise DBA - 1223

Title: Analytics Industry Trends + Your Career

Abstract: This presentation covers massive waves of change throughout the analytics industry. We discuss how to keep track of key changes, planning or adapting your analytics career, and then we explore many “blue ocean” career opportunities in a new world of data. Cool topics such as Virtual Reality, Robotics, Automation, Predictive and Prescriptive Analytics, Internet of Things, Big Data, Cloud and Hybrid are explored.

Speaker(s):

Jen Underwood

Track and Room: Professional Development - 2215

Title: Big Data, Small Data, and Everything In Between

Abstract: The breadth of options available to data professionals today is staggering: between relational, object, graph, and document databases, we have a wide array of storage options, as well as a huge number of access and analysis tools. This talk will walk you through data platform, data analysis, and data processing options. We’ll discuss when to use (and when not to use) Spark, R, Storm, and SSAS, as well as a range of other tools and technologies. By the end of this talk, you may not have MongoDB or Neo4J, but you will know where they might fit.

Speaker(s):

Kevin Feasel

Track and Room: Strategy and Architecture - 1236

Title: Query Store Primer

Abstract: This session will take a look at the new Query Store feature in SQL Server 2016. Query Store tracks changes in execution plans, allowing you to easily view performance differences and revert to older plans with a few clicks of the mouse. We will take a hands on look at how to use Query Store to troubleshoot problems as well as some of the new DMVs you can use to find issues as they arise.

Speaker(s):

Tracy Boggiano

Track and Room: Enterprise DBA - 2215

Title: Achieve More in Less Time by Using the New SQL PowerShell

Abstract: Let’s face it, using SQLPS prior to SQL Server 2016 was like installing training wheels on a Ducati. Then, some community feedback was incorporated before SQL 2016 shipped and presto, SQLPS is actually useful all of a sudden.

There is a faster way to manage and even SQL Servers using PowerShell. I will show you what the new features in SQLPS and why you will probably find it useful, even if you aren’t a “DBA”.

Speaker(s):

Aaron Nelson

Track and Room: Database Development - 1237

Title: Tips and Tricks for the SSIS Catalog

Abstract: With the introduction of the SSIS Catalog in SQL Server 2012, we can now manage our SSIS package execution and monitor performance and logs in a much easier manner than executing packages from the file system. In this session, we’ll walk through setting permissions for SSIS read-only access, executing packages from T-SQL or stored procedures, viewing the logs generated during a package execution, writing custom messages to the logs, and many other tips to make your use of the catalog easier!

Speaker(s):

Jonathan Buller

Track and Room: BI DW - 2214

Title: Interviewing-Be So Good They Can’t Ignore You

Abstract: From the basics to the advanced, we will explore techniques that will ensure you leave a positive impression and help you land that role!

Speaker(s):

Leveat Ruse

Track and Room: Professional Development - 1237

Title: SQL Backup 102 - From basic to more

Abstract: We will start with the importance of backup for a database administrator. The second part will cover backup/recovery strategy and the three backup types including a demo. The last part will cover the other techniques not considered as a normal backup process but can be used for it like attach/detach, import/export, replication and disaster recovery (log shipping).

Speaker(s):

Thomas Chan

Track and Room: Enterprise DBA - 1233

Title: SQL Server 2016 and PolyBase

Abstract: This session will focus on the brand new SQL Server 2016 feature called PolyBase. PolyBase#160;is a technology that accesses and combines both non-relational and relational data, all from within SQL Server. It allows you to run queries on external data in Hadoop or Azure blob storage. The queries are optimized to push computation to Hadoop.

In this session, you will learn how to install and set up PolyBase, and how to use it once you’ve got it configured.

Speaker(s):

Sean Werick

Track and Room: BI DW - 1236

Title: Lightning Talks

Abstract: This session will consist of two 15 minute quot;Lightning Talksquot; from two different presenters: Geoff Hiten amp; William Assaf.

Speaker(s):

Angela Henry

Track and Room: Enterprise DBA - 2218

Speakers

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

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.

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.

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.

Aaron Nelson

Twitter: - SQLvariant

LinkedIn: Aaron Nelson

Contact: http://sqlvariant.com/

Aaron Nelson is an author, public speaker, blogger, and leader in the community. He has over 15 years of experience in architecture, Business Intelligence, development, and performance tuning of SQL Server. Aaron has received many certifications and is a six time winner of the Microsoft MVP Award.

Aaron leads the PowerShell Virtual Group of PASS (SQLPS.io), is a board member of PowerShell.org, and is a volunteer at his PASS Local Group, AtlantaMDF.

Carlos L Chacon

Twitter: - @CarlosLChacon

LinkedIn: Carlos L Chacon

Contact: http://sqldatapartners.com/blog

Carlos Chacon is the managing partner of SQL Data Partners LLC and co-host of the popular SQL Data Partners Podcast. While getting his start as a typical accidental DBA, Carlos has sat on Microsoft exam review panels, served as regional mentor and chapter leader. He enjoys traveling and has been to four continents, speaks Spanish and can eat his weight in raspberries (not yet proven). He and his family live in Richmond, Virginia.

Melissa Coates

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

LinkedIn: Melissa Coates

Contact: https://www.CoatesDataStrategies/blog

Melissa Coates is a data architect with a background in data warehousing and business intelligence. Her current professional focus is enterprise-level Power BI governance, deployment, security, and administration. As the owner of Coates Data Strategies, Melissa produces training and consults to help companies strengthen and sustain their data-driven initiatives. Melissa is big supporter of the technical community, and has been a Microsoft Data Platform MVP since 2013. You can visit Melissa’s website at CoatesDataStrategies.com, which includes community resources like diagrams, blogs, and videos.

William Wolf

Twitter: - sqlwarewolf

LinkedIn: William Wolf

Contact: http://www.sqlwarewolf.com

Jonathan Buller

I got my start with SQL Server almost 15 years ago when I was tasked with converting Access databases to SQL Server based applications. I have been working with SQL Server and SSIS ever since! I am now focused on designing and implementing Data Warehouse solutions with multiple complex data sources. I lead a team of 4 other ETL developers, serving as the architect and Senior ETL developer, and work closely with the business to develop warehouse and analytic solutions.

Angela Henry

Twitter: - SQLSwimmer

LinkedIn: Angela Henry

Contact: http://SQLSwimmer.com

Angela is a Solution Architect, living in High Point, NC and loves what she does. She’s worked with all versions of SQL Server worn all the hats that come with dealing with SQL Server throughout the years: developer, administrator, data architect and BI developer. She has her MSCE in Data and Analytics (f.k.a., Business Intelligence), is a Data Platform MVP, and a Microsoft Certified Trainer (MCT). She is the former chapter leader for the PASS Triad SQL User Group in Greensboro, NC. In her spare time you can probably find her in or at the pool, she’s an avid US Masters Swimmer, Coach and Instructor.

Chris Skorlinski

Chris Skorlinski has been with Microsoft for 17 years. He is a Support Escalation Engineer at the Microsoft Charlotte NC office specializing in performance tuning and troubleshooting Replication. His is a contributor to SQLShare.com training as well as his own BLOGs on Replication Performance at http://blogs.msdn.com/ReplTalk/. #160;

Bill Anton

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

LinkedIn: Bill Anton

Contact: http://byobi.com/blog/

Bill Anton is an expert in Analysis Services and an experienced data warehouse practitioner. In 2013, he founded Opifex Solutions, a consulting firm with deep expertise in enterprise-scale architecture, design, and performance optimization of Analysis Services and Power BI solutions. He loves eating and spends most of his free time convincing his beloved wife to adopt more golden retrievers.

Luke Donley

LinkedIn: Luke Donley

Luke Donley is a senior data and analytics consultant at CapTech with over 10 years of data management experience. He has spent much of his career working in Microsoft SQL Server environments designing, building, and delivering SQL Server data warehouses and analytical applications. Luke specializes in data strategy, data architecture, data integration, and business intelligence.

Rushabh Mehta

Twitter: - @rushabhmehta

LinkedIn: Rushabh Mehta

Contact: http://blogs.solidq.com/RushabhMehta

Rushabh Mehta is a Business Intelligence Mentor with SolidQ and the Managing Director for Solid Quality India Pvt. Ltd. He served as PASS President for 2010/2011 term.

Rushabh has worked with MS Data Platform since 1998 and has designed and developed BI systems since 2001. He has been the lead architect for many large-scale and complex BI solutions for clients such as Publix, Raymond James, Jackson Hewitt, US Dept. of Defense, and Microsoft. He is an MVP with Microsoft, Damp;B amp; Melissa Data

Bill Anton

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

LinkedIn: Bill Anton

Contact: http://byobi.com/blog/

Ravi Kumar

Twitter: - @sqlravi

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

boB Taylor

Twitter: - sqlbobt

LinkedIn: boB Taylor

Contact: http://aka.ms\sqlbobt

In his 45-year IT career, boB Taylor has pretty much done it all – Fortran 66 on Hollerith Cards, assembly language programming on drum-based computers, and LOB application development. He served as a VP of Software Development and was Director of Database Technologies for Avanade West Region. Then he joined Microsoft’s Partner Advantage practice, advising ISVs on effectively using SQL Server. After becoming a Microsoft Certified Architect, boB moved to PFE and is now with the Oracle Compete Team. Besides passing 40+ certification exams on the first attempt, boB helped develop both SQL Server 2000 certification exams, SQL Server 2005 developer exams, and all MCSD.NET exams. Ask him about the spelling of his name!

Azhagappan Arunachalam

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

William Assaf

Twitter: - william_a_dba

LinkedIn: William Assaf

Contact: http://www.sqltact.com

William Assaf, Data Platform MVP, is a principal consultant in Baton Rouge, LA. Initially a .NET developer, and later into database administration and architecture, William currently works with clients on SQL Server and Azure SQL platform optimization, management, disaster recovery and high availability, and leads a crack multi-city team of consulting SQL DBA’s. William has written for Microsoft SQL certification exams since 2011 and was the lead author of the 2017 and 2019 editions of “SQL Server Administration Inside Out” by Microsoft Press. William is a member of the Baton Rouge User Groups board, a regional mentor for PASS, and past lead of the annual SQLSaturday Baton Rouge Planning Committee, having run one of the largest SQLSaturdays.

William Assaf

Twitter: - william_a_dba

LinkedIn: William Assaf

Contact: http://www.sqltact.com

Konstantin Melamud

Twitter: - @kmelamud

Konstantin has over 15 years of SQL Server experience and demonstrates his expertise and commitment to helping SQL Server DBAs succeed through his position as Director of Service Delivery at RDX. In his role, Konstantin is responsible for designing and implementing RDX’s service delivery strategies, including those for SQL Server. Since joining RDX in 2009, Konstantin has proven to be a strong leader and expert in SQL Server database administration, architecture, performance tuning, and business intelligence. He is also a very active member of the SQL Server community and frequently presents at SQLSaturdays and user groups throughout the year. In addition, Konstantin presented during 24 Hours of PASS and at the PASS Summits.

Geoff Hiten

Twitter: - SQLCraftsman

LinkedIn: Geoff Hiten

Geoff Hiten is a Technical Solutions Professional at Microsoft. Geoff began working with SQL Server in 1992 with version 4.2 and has used every version since. He specializes in highly available SQL systems, performance tuning, and systems migration. Geoff is heavily involved in the Microsoft SQL Server Community and was initially awarded MVP status in 2004. Geoff was appointed in 2011 to fill an interim Director position at the National PASS organization.

Paco Gonzalez

Twitter: - @pacosql

LinkedIn: Paco Gonzalez

Paco Gonzalez is the CEO of SolidQ North America, and a Microsoft Data Platform MVP. Focused on Business Analytics and Artificial Intelligence, he specializes in helping organizations become data driven from a strategic and technical perspective. Paco is a speaker at small and large conferences such as PASS Summit, Ignite, and Business Applications Summit, and he has published several books and whitepapers. He is based in Atlanta, GA.

William Assaf

Twitter: - william_a_dba

LinkedIn: William Assaf

Contact: http://www.sqltact.com

Leveat Ruse

Twitter: - www.twitter.com/ncsctechrecruit

LinkedIn: Leveat Ruse

As an Executive Technical Recruiter with Ctrl+f, I currently develop effective recruitment strategies to attract top talent at all levels of an organization. I am an IBM certified trainer and began my career performing general human resources duties. I quickly worked my way up through the ranks of technical recruiting from Lead Recruiter to Senior Recruiter to Business Development.

Rick Heiges

Twitter: - heigesr2

LinkedIn: Rick Heiges

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

Rick is a Former Data Platfrom MVP and Sr. Consultant for Microsoft where he focuses on working with customers on their data estate. His career includes work as a DBA, University full-time faculty member, Systems Analyst, Project Leader, and Developer. He has found his passion in working with data and the community. Rick served nine years on the PASS Board of Directors and spearheaded the popular 24 Hours of PASS event. He also started his local User Group in 2002. Today, he spends much of his time with his head in the clouds.

Andy Leonard

Twitter: - AndyLeonard

LinkedIn: Andy Leonard

Contact: https://andyleonard.blog

Andy Leonard is founder and Chief Data Engineer at Enterprise Data Analytics, Microsoft Data Platform MVP, creator of the DILM (Data Integration Lifecycle Management) Suite, an SSIS trainer, consultant, developer, Business Intelligence Markup Language (Biml) developer and BimlHero, SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of “The Biml Book and SQL Server Integration Services Design Patterns” and author of “Managing Geeks - A Journey of Leading by Doing”, “Data Integration Lifecycle Management with SSIS”, “Building Custom Tasks for SSIS”, and the “Stairway to Integration Services”. Andy blogs at andyleonard.blog where you can learn more on the About Andy page.

Geoff Hiten

Twitter: - SQLCraftsman

LinkedIn: Geoff Hiten

Jen Underwood

Twitter: - @idigdata

LinkedIn: Jen Underwood

Contact: http://www.jenunderwood.com

Jen Underwood is a Senior Director at DataRobot. Over the past 20 years, Jen has held worldwide product management roles at Microsoft and served as a technical lead for system implementation firms. She has a unique blend of product management and “hands-on” experience in data warehousing, reporting, visualization, and advanced analytics. In addition to keeping a constant pulse on industry trends, she enjoys digging into oceans of data to solve complex problems with machine learning.

Jen has a Bachelor of Business Administration – Marketing, Cum Laude from the University of Wisconsin, Milwaukee and a post-graduate certificate in Computer Science – Data Mining from the University of California, San Diego.

Thomas Norman

Twitter: - ArmorDba

LinkedIn: Thomas Norman

Contact: https://armordba.com/

Tom Norman is a Database Architect at KPA with a strong fervor to protect data. He works daily to review and improve data protection methodologies while reviewing governing laws affecting finance, healthcare, and personal data. His areas of expertise include encryption, auditing, data identification, and database object deployment. He is the current leader of the PASS Virtualization Group and Vice President of the TRIPASS user group. You can read his blog at https://armordba.com/ and reach him on twitter at @armordba. Tom speaks at a number of SQLSaturday events and SQL Server user groups.

John Holtz

LinkedIn: John Holtz

For the past 17 years John has served as a technology advocate for his clients, helping guide them on their journey to the modern data center. John is currently a Senior Account Manager for Dell EMC’s “All Flash” Primary Storage Platforms which includes XtremIO, VMAX All Flash and Unity All Flash.

Prior, John spent ten years in the storage virtualization space with IBM and another four years as a Mid-Market Account Manager at EMC.

In 2014 John left the world of data storage to develop his skills in visual data analytics at Tableau Software. Ultimately, his fondness for the data center led him back to his current role with EMC.

Brian Carrig

Twitter: - @briancarrig

Brian Carrig is a Microsoft Certified Master of SQL Server and is currently a Senior Program Manager on the SQL Server Tiger Team at Microsoft focusing primarily on persistent memory technology and replication. In a previous life, Brian spent some time as an academic and holds a PhD in Computer Science. He is a native of Dublin, Ireland but now lives with his wife and two daughters in Redmond, Washington. If he is not talking about, thinking about or working with technology you will usually find him watching Chelsea FC.

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

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.

Vishal Pawar

Twitter: - Vishal_BI

LinkedIn: Vishal Pawar

Contact: http://bimentalist.com/

Vishal Pawar is a Microsoft Data Platform MVP, Microsoft Certified Trainer (MCT), founder of the Global Power BI User Group and co-leader of the PASS Business Analytics Virtual Group. He is a Principal BI Architect in Green House Data, with decades of experience in BI solution architecture and best practices. He has published more than 1000 articles since 2011 in SQL and BI. Vishal teaches a free Power BI course through Udemy, which has more than 65K students from the glob. Vishal is an exceptional technology community of leaders worldwide who actively share their high quality, real-world expertise with the technical communities.

Kevin Feasel

Twitter: - feaselkl

LinkedIn: Kevin Feasel

Contact: http://www.catallaxyservices.com

Patrick Thompson

LinkedIn: Patrick Thompson

Patrick Thompson is a Partner and General Manager of Sparkhound, overseeing operations and business development and growing Sparkhound’s footprint in Louisiana, Arkansas, Alabama, Mississippi and Florida. With more than 27 years of experience, he has held senior leadership positions at Fortune 500 and 1000 companies, including Accenture, Turner Industries, CBamp;I (formerly the Shaw Group) and Amedisys. In his spare time, he enjoys movie time and hanging on the beach with his family.

Anders Pedersen

Twitter: - @arrowdrive

LinkedIn: Anders Pedersen

Contact: http://blog.AndersOnSQL.com

20+ years of experience with SQL Server, from version 6.0 to 2017. Funnily enough, the only certification I have is on SQL 2012, the one version I have never used. Mostly worked at medium sized companies, by choice. Was a consultant for 6+ years, working on anything from facility security systems, background checks, retail PoS systems, to major financial systems. Passion for performance, and teaching people easy ways to better SQL performance.

Thomas Chan

LinkedIn: Thomas Chan

I work with SQL Server since 2001 with version 7.

Jana Sattainathan

Twitter: - www.twitter.com/SQLJana

LinkedIn: Jana Sattainathan

Contact: http://www.sqljana.wordpress.com

Jana works as a Senior Oracle and SQL Server DBA at SCOR, a leading Reinsurance company in the world. He has spent most of his professional life around databases. At work, he has automated most aspects of his job using PowerShell.

Most recently, he created PowerPump, a “PowerShell Database Copy Server” for his company to copy 50 billion rows (> 20 TB,) from 4000+ of Oracle/SQL Server tables on a recurring basis to SQL Server targets for migration/testing. He has also fully automated the database deployment which supports all components of SQL Server and Oracle using PowerShell (with about 150 functions) that is tracked extensively.

Sean Werick

LinkedIn: Sean Werick

Contact: http://www.seanwerick.com

I have been in the data industry for 15 years, specializing in Microsoft business intelligence for the last decade. I have architected, developed and integrated end to end solutions for customers in various sectors including finance, government, health care and retail. I am extremely passionate about data and the endless possibilities for companies utilizing it in the best ways. I enjoy data science and business intelligence because the possibilities and magnitudes of impact are immeasurable.

Tracy Boggiano

Twitter: - TracyBoggiano

LinkedIn: Tracy Boggiano

Contact: http://databasesuperhero.com

Tracy Boggiano is a Senior Database Administrator for DocuSIgn. She has spent over 20 years in IT, using SQL Server since 1999, and is currently certified as an MCSE Data Platform. Tracy has worked on SQL Server since 6.5. She has spoken at local user groups and numerous SQLSaturdays. She is currently a co-leader of a TriPASS Local Group in Raleigh, NC.

Tracy also tinkered with databases in middle school to keep her sports card collection organized. She blogs at databasesuperhero.com.

Her passion outside of SQL Server is volunteering with foster children as their advocate in court through volunteerforgal.org and being a mental health advocate as part of the PAIMI NC Advisory Council.

SQLSaturday #560 - Charlotte 2016

Sessions

Title: SSIS-Lightning fast processing using Parallel processing-Result in Power BI

Title: Service Broker - Put Me In Coach

Title: IO Tuning 101

Title: Performance Tuning - Analyzing Execution Plans

Title: 20 Minute Tabular Model

Title: SQL Server 2016 “Hidden Gems”

Title: Analysis Services: Show Me Where It Hurts

Title: Maximizing Microsoft SQL Server Storage Investments

Title: Enterprise Machine Learning with R and SQL Server

Title: Using PowerBI and SQL Server to Create Management Cadence Dashboards

Title: Stop Doing That! 5 Common T-SQL Anti-Patterns

Title: Sparkhound Jeopardy

Title: Practical PowerShell for the SQL Developers and DBA’s - 0 to 60 in 60 mins

Title: Getting to know U-SQL

Title: Efficient table design

Title: Replication v. AlwaysOn, the great debate

Title: APPLY Yourself

Title: SQL Server Permissions and Security Principals

Title: Mastering and Enhancing Company Data

Title: Inside of Indexes

Title: Administring SSIS 2012, 2014 and 2016 for DBAs

Title: Building Blocks of Cortana Intelligence Suite in Azure

Title: Managing Database Projects in Visual Studio 2013

Title: Encrypting Data within Sql Server

Title: SQL Azure Database - No CDC, no problem!

Title: Managing Very Large Databases with SQL Server

Title: Biml and SSIS Frameworks

Title: Winning with Columnstore - A Customer Story

Title: What’s your Imperative doing in my Declarative?

Title: Disaster Recovery From On Premises to Azure

Title: Analytics Industry Trends + Your Career

Title: Big Data, Small Data, and Everything In Between

Title: Query Store Primer

Title: Achieve More in Less Time by Using the New SQL PowerShell

Title: Tips and Tricks for the SSIS Catalog

Title: Interviewing-Be So Good They Can’t Ignore You

Title: SQL Backup 102 - From basic to more

Title: SQL Server 2016 and PolyBase

Title: Lightning Talks

Speakers

Sponsors