SQLSaturday #592 - Raleigh 2017

Event Date: 03/11/2017 00:00:00

Event Location:

  • William Peace University
  • 15 E Peace Street
  • Raleigh, North Carolina

PDF of Schedule

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

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


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

Title: Architecting Availability Groups

Abstract: Are you a DBA familiar with some basic Windows clustering and database mirroring concepts, and now you’re considering AlwaysOn Availability Groups? This session is for you! I’ll cover the pros and cons of four typical configurations of AlwaysOn Availability Groups: stand-alone instances, fail-over cluster instances, multi-subnet configurations, and disaster-recovery-on-the-cheap. I’ll also discuss read-only routing, and implications and limitations of the Availability Group Listener. In addition, you’ll learn why you should be using Windows Server 2012 R2 or above for your Windows clusters. Join me to learn which configuration options you should choose for your Availability Group.


  • Derik Hammer

Track and Room: Enterprise Database Administration Deployment - 114

Title: Running SQL Server in AWS

Abstract: Amazon Web Services (AWS) is the world’s largest public cloud hosting provider with many companies successfully running SQL server on AWS infrastructure. In this session, we explore the options available to you for running SQL server in AWS, either as an RDS managed service or using dedicated EC2 instances. We document the different storage options, HA strategies and maintenance caveats to be aware of. We will also detail various approaches to licensing you can take when running SQL server in AWS.


  • Brian Carrig

Track and Room: Enterprise Database Administration Deployment - 220

Title: Using Powershell to Document SQL Server

Abstract: Most DBAs use multiple native and third party tools to fully document SQL Server instances yet still dont get all the objects. Even using Visual Studio and Database Projects, not all objects are exported because they live at the server level, above the database. Using Powershell, we will script out an organized set of files that can be checked into any Source Control system and or used for Disaster Recovery purposes. Objects exported include: SQL Agent Jobs/Alerts/Schedules, NT Service Credentials, SSIS-MSDB, SSIS-Catalog, SSAS Cubes, SSRS Reports, Logins, Server Configs, Linked Servers, DB Mail Operators/Accounts, Server Triggers and much more


  • George Walkey

Track and Room: Enterprise Database Administration Deployment - 116

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.


  • Paco Gonzalez

Track and Room: Advanced Analysis Techniques - 222

Title: The Art and Science of Designing a Mission Critical SQL Server

Abstract: When asked to design a critical database solution, too many people pick an HA feature assuming it will be the right fit for the application. This can result in a costly and disappointing design that does not meet your availability goals. This session will show you the five basic archetypes for mission critical database systems and how to select the right features from SQL Server to implement each design. Along the way, you’ll hear some best practices, tips, and real world advice for choosing between features like Availability Groups and clustered instances of SQL Server, as well as the history of some of the more interesting and less often used availability features. You will also get a glimpse of how some of the largest mission critical systems running on the Microsoft platform are created using a distributed model where redundancy replaces failover. While you may not be able to revisit your current designs right away, what you learn will improve how you approach designing systems.


  • Maxwell Myrick

Track and Room: Strategy and Architecture - 116

Title: SQL Server Clinic

Abstract: Have a tough production issue you just can’t figure out? Setting up a DR plan and need some guidance? Just getting started with SQL Server and looking for advice? Stop by the SQL Server Clinic and speak with one of the friendly SQL Server professionals waiting to answer your questions.


  • Mark Wilkinson

Track and Room: Other - 110

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.


  • Jana Sattainathan

Track and Room: Application Database Development - 114

Title: Making Row Level Security and Dynamic Data Masking work for you!

Abstract: Azure SQL DB has had Row Level Security and Dynamic Data Masking for a while now, SQL Server 2016 brings that on-premises. But just how can you use it, what changes do you need to make to your model to get the most from it?

These new features have the potential to really improve application security, especially in compliance scenarios. Pushing the security restrictions down into the database layer has many benefits, notably only the data needed leaves the database. But there are a number of gotchas that you need to be aware of that can really mess up performance if you get them wrong.

In this session we will look at how you can get the most out of these features and retain the performance of your system.


  • John Martin

Track and Room: Application Database Development - 111

Title: Deeper Into Azure Machine Learning

Abstract: Azure Machine Learning enables far more than supervised 2-class classifications and continuous value predictions. Azure ML clusters unsupervised data. Azure ML analyzes free form text for entity recognition, sentiment analysis, or topic detection. Azure ML even provides Jupyter Notebooks with fully functional R and Python environments. This sessions demonstrates some of these capabilities to help you solve some of your business problem.


  • Mark Hudson

Track and Room: Advanced Analysis Techniques - 222

Title: SQL Audit - Evidence Never Lies

Abstract: We’ve all heard about massive data breaches from big name companies. As a DBA, you should consider your company’s data to be the most valuable assets. So when a data breach happens at your company, will you be able to provide management with the information? If not, then discover how SQL Server Audit can help provide you with an accurate forensic analysis of who did what to your data. In this session, we’ll cover what SQL Audit can capture, how to set it up for both on-premise SQL Servers and Azure SQL Database, and finally produce reports from it.


  • Patrick Keisler

Track and Room: Enterprise Database Administration Deployment - 217

Title: Module Signing or: How I Learned to Stop Using EXECUTE AS and Love Certificates

Abstract: Often enough we need to grant higher-level than ideal permissions to a Login or Role that are necessary to perform a task. For example, someone needs to start a SQL Agent job without being able to edit any jobs. Or, a task needs data from one of the DMVs that requires the “VIEW SERVER STATE” permission, but you don’t want the user to see everything that is made available by that permission. When ownership-chaining doesn’t work, the common solution is to use EXECUTE AS (i.e. Impersonation). Sometimes this works, but cross-DB tasks often require enabling cross-DB ownership chaining and/or TRUSTWORTHY, which are security risks.

Module Signing is more flexible and more secure, but requires a Certificate or Asymmetric Key. Those can be confusing to work with, and the security mechanism isn’t intuitive.

Come learn how to have more secure, granular control over permissions that covers cross-DB tasks and Dynamic SQL. See what signing can do, understand how certificates work, and rejoice.


  • Solomon Rutzky

Track and Room: Application Database Development - 111

Title: From Analyst BI Day to Developer BI Night

Abstract: You are a data analyst by trade. Your SQL skills are likely used to write research queries, do quality control for the query results, and churning out reports. However, you’re now concerned with loading and manipulating data in the database. You’re now asked to write statements that don’t start with SELECT. In short, you’re becoming a SQL developer.

This session will provide you with some high-level essential resources, from additional T-SQL query operators to SQL Server Data Tools and data modeling knowledge to warehousing basics, to help you navigate this uncharted territory…coming from a speaker who has been in the same position. You will come out of the session eager to use these resources to moonlight as or transition to a developer in the SQL Server space, ideally blending this developing skill set with your analyst skill set to create a well-rounded data professional!


  • Chris Voss

Track and Room: Professional Development - 111

Title: Database Project Makes Deployment Consistent

Abstract: The deployment process is frustrating; an object is missing, an object is deployed in the wrong order or an incorrect version. Deploying to multiple environments like Dev, QA, UAT and Prod is a challenge whither on premise or in the cloud. Source controlling database objects is paramount. Team development is required. Database code will only be deployed when changed. Proper security deployment will be repeatable per environment. Together, let us discover how using Database Project will help us with consistent releases. Deployments can cause you trouble but we will share a reliable deployment and version control process. Let’s see how Database Project can help us accomplish this goal.


  • Thomas Norman

Track and Room: Application Database Development - 220

Title: The ABC’s of Database Baselines

Abstract: The numbers on the monitor go up and then they go down. Which numbers are the most important? How do I know if the change I made is helping my environment? This sessions reviews some of the important areas to understand before you start making changes to your environment and how to measure them.


  • Carlos L Chacon

Track and Room: Enterprise Database Administration Deployment - 111

Title: Embedding Power BI In Your Web Application

Abstract: Embed power BI reports in asp .net and JavaScript based apps using Portal and embedded Power BI


  • Pritesh Ostwal

Track and Room: Analytics and Visualization - 217

Title: Data Visualization: How to truly tell a great story!

Abstract: We have more information available to us today than ever before. So much so that we run the risk of not being able to tell concise stories. There’s a lot more to creating that story than just getting the correct information. Come learn not just the do’s and don’ts, but the whys…


  • Jonathan Stewart

Track and Room: Analytics and Visualization - 222

Title: Moving from Change Tracking/Change Data Capture to Temporal Tables

Abstract: With the release of SQL Server 2016, Temporal tables are a new way to track changes within your tables. This session will walk you through moving from Change Tracking/Change Data Capture to Temporal tables and what advantages Temporal Tables has for your database and application.


  • Doug Purnell

Track and Room: Enterprise Database Administration Deployment - 114

Title: SQL Backups: Choosing the right solution for your environment

Abstract: Backing up databases is (arguably) the most important maintenance task for any database administrator. But the question is: Which solution should you choose for creating and managing your backups? In this session we’ll discuss the options available and demonstrate 2 of the solutions in action (Ola Hallengren’s DatabaseBackup and Minionware’s Minion Backup).


  • Jamie Wick

Track and Room: Enterprise Database Administration Deployment - 222

Title: Understanding 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#39;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#39;ll go over step-by-step in getting started with U-SQL, and review some use case scenarios.


  • Azhagappan Arunachalam

Track and Room: Cloud Application Development Deployment - 111

Title: SQL Server on Linux for SQL DBA.

Abstract: For the last 25 years SQL Server DBAs administered SQL databases using only Windows GUI. For majority of them even Windows Core is too hard to accept. In the situation, when Microsoft invaded Linux territory with it’s flagship product, as SQL DBA, you must not outsource SQL Server administration to some Linux geeks. You can do it yourself! Your way! And I show you how to do it.


  • Slava Murygin

Track and Room: Enterprise Database Administration Deployment - 217

Title: SQL Server Transactional Replication: A Deep Dive

Abstract: Ah, SQL Server Transactional Replication. The technology everyone loves to hate. But for all the notoriety, there’s some interesting technology to be had in it that might you might want to leverage. In this session, we’ll explore what happens when you create a new transactional publication: what happens during a snapshot, how data gets delivered to subscribers, and how you can monitor, tweak, and tune your publications. We’ll also see some common trouble spots and how to identify them. There will be plenty of examples and demos and, yes, even some PowerShell!


  • Drew Furgiuele

Track and Room: Enterprise Database Administration Deployment - 116

Title: Interrogating your data sources with Biml

Abstract: You’ve decided to start using Biml to make your integration services packages. Congratulations!

Now, you’re looking at data sources other than SQL Server. How do you automate package development for these flat files, Excel Files, and other databases? In this session, I’ll share some of the techniques I’ve used to deal with these second-class sources. I’ll be walking you through C# code. Don’t worry, I’m not a real programmer, so the code isn’t the most complex, but it does solve the need.


  • Shannon Lowder

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

Title: Using DMVs for Performance Root Cause

Abstract: What are your first steps when you hear one of your SQL Servers is having a performance problem? In this demo-driven session, we will discuss key DMVs that can provide us data quickly. We will examine a number of example queries that can lead us to a quick root cause analysis in a number of different situations. This session will be kept at a very functional level, and should be accessible for anyone interested in SQL Server performance.


  • Jared Poché

Track and Room: Enterprise Database Administration Deployment - 114

Title: Tracking Change is the Backbone of Your Data Platform

Abstract: Features or concepts like Change Tracking, Change Data Capture, Temporal Tables, and other similar delta systems are complex and may carry a stigma or misapprehension in your organization around performance or security or cost. Even if you do not directly implement these features or methods absolutely, most information systems rely on tracking changes especially from legacy line of business applications. I’m here to show you robust techniques for implementing delta systems in SQL Server to increase the trustworthiness of your data warehouse. I will also steer you away from common pitfalls.


  • Doug McClurg

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

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.


  • Andrew Kelly

Track and Room: Enterprise Database Administration Deployment - 222

Title: Finding more space for your tight environment.

Abstract: If you do not have enough harddisk space and do not want buy more space, one way to get more space is compress the tables and also do some house keeping.

I am going use T-SQL script to generate script to compress each tables and release the free space by shrinking the datafiles. And in the final I will defragment the indexes and update the statistics, since shrink datafile is not fragmentation aware task.


  • Thomas Chan

Track and Room: Enterprise Database Administration Deployment - 222

Title: SQL Server Basic Backups For Beginners

Abstract: If you just started using SQL Server and may be unsure of the need for backups or even how to do them, this is for you. It is very basic and will cover recovery models and backup types. In addition, I will demonstrate backups and a restore.


  • Mark Gordon

Track and Room: Enterprise Database Administration Deployment - 217

Title: Best practices for managing SharePoint SQL Server Databases

Abstract: SharePoint Server uses SQL databases but not like a convention relational database. This session looks at some of the differences between SharePoint databases and default settings. What kinds of maintenance jobs to run and why its not a good idea to tweak the indexes.


  • Michael Wharton

Track and Room: Enterprise Database Administration Deployment - 114

Title: SQL on Hadoop, using Hive Spark, to analyze sports data

Abstract: This presentation will focus on the technology techniques that can be used to analyze data within Hadoop. I’ll demonstrate a few SQL examples using Apache Spark and Apache Hive, discuss best practices, when to use one over the other, and additional tricks and tips. ​


  • Dan Zaratsian

Track and Room: Analytics and Visualization - 116

Title: Row Level Security in Power BI

Abstract: Power BI is the latest and greatest BI delivery service from Microsoft. This session will help you understand the concepts and DAX functions needed to create dynamic models for either internal use for your own company, or for a multi-tenant deployment. Power BI Desktop models and Tabular models will be discusses as we look at some common business scenarios for securing you Power BI.


  • Todd Chittenden

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

Title: A Gentle Introduction To Machine Learning

Abstract: Machine Learning is certainly a hot topic these days. For example, Microsoft is all-in in its company transformation from “a PC on every desktop” to “deep learning in every software”. There are tons of product offerings in and out of the Microsoft stack and cloud and it can be a bit daunting to separate all of the noise from the signal. In this session, we are going to look at the fundamentals of machine learning - the building blocks of Deep Learning, Artificial Intelligence, and Cognitive Apps.

Some familiarity of computing programming, statistics, and manipulating tabular data will help you get the most out of this session.


  • Jamie Dixon

Track and Room: Advanced Analysis Techniques - 116

Title: Designing a Modern DW + Data Lake

Abstract: Join us for a discussion of strategies and architecture options for implementing a modern data warehousing environment.  We will explore advantages of augmenting an existing data warehouse investment with a data lake, and ideas for organizing the data lake for optimal data retrieval. We will also look at situations when federated queries are appropriate for employing data virtualization, and how federated queries work with SQL Server, Azure SQL DW, Azure Data Lake, and/or Azure Blob Storage. This is an intermediate session suitable for attendees who are familiar with data warehousing fundamentals.


  • Melissa Coates

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

Title: Monitoring Availability Groups

Abstract: So you have successfully configured Availability Groups, now what? In this session we will look beyond setup and look at how to monitor your Availability Groups. We will discuss what metrics to look at, what they mean, and what you need to alert on. You will walk away from this session with tools you need to monitor your environment and know how to respond to alerts. This session is for anyone that uses, or plans to use Availability Groups. You should come in with a basic understanding of Availability Groups to get the most out of this session.


  • Tracy Boggiano

Track and Room: Enterprise Database Administration Deployment - 114


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

Jonathan Stewart

Twitter: - sqllocks

LinkedIn: Jonathan Stewart

Contact: https://sqllocks.net/

Jonathan Stewart is a Business Intelligence consultant specializing in data visualization, data warehousing, and data management technologies. An advocate for educating others, he is a public speaker, teacher and blogger, continually teaching people about the Microsoft BI Stack. Since 2000, he has been working in the database field with industry leaders in healthcare, manufacturing, financial, insurance and federal, state and local governments.

Jonathan is very active in the community. He has presented on SQL Server, SSIS, Reporting Services, Power BI and Business Intelligence at numerous SQLSaturday events, local user groups, and conferences throughout the United States and around the world. He participates in webcasts, podcasts, and on

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.

Todd Chittenden

Twitter: - @toddchitt

LinkedIn: Todd Chittenden

Contact: http://blog.blumshapiro.com/blog/author/toddc/

Todd started working with Microsoft’s SSRS in 2004. When Microsoft released its rebuild of SQL Server in 2005, he quickly added the full BI Stack to his repertoire. He became a MCTS in SQL Server 2005. Today, Todd works for Blum Shapiro as a Business Intelligence Architect on various BI Projects across a wide range of company sizes and product combinations. He is a Microsoft Certified Solutions Expert in SQL Server Business Intelligence and a frequent speaker at local User Groups and SQLSaturday events. He Started working with Power BI in its early development time before General Availability in July of 2015.

Maxwell Myrick

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

LinkedIn: Maxwell Myrick

Contact: http://sqlha.com/blog

Max Myrick is a SQL Server consultant whose experience includes 15 years at Microsoft with 5 years on the SQL Server development team where he ran the SQL Customer Lab and then the Sustained Engineering team. He was an founding member of Microsoft#39;s Mission Critical team where he worked with the largest SQL Server applications worldwide for almost a decade. Max was a regular speaker for Microsoft and has continued to speak at various PASS and other SQL Conferences since becoming a managing partner of SQLHA LLC.

Doug Purnell

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

LinkedIn: Doug Purnell

Contact: http://sqlnikon.wordpress.com

Doug Purnell is a DBA at Elon University and is a co-leader for the Triad SQL BI PASS User Group. In his spare time you can find Doug taking photos and cooking up some BBQ on his cooker.

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.

Pritesh Ostwal

 Sr. Software Consultant with broader experience on Business Intelligence solutions, Solution Architecture, Architecture Governance, Application Database optimization, Processes Optimization, Technology Selection, Agile Adoption and Niche Technologies Evaluation, Data Modeling, Framework Development, Product Development, Technology Migration and Software Services  Program Management, Project Team leadership, Client Services Maintenance, Pre-Sales Business Engagement, Technical Migration Planning, Process Improvement Governance, Global Software development, Critical thinking, Future solutions / Innovation, Comprehensive problem solver, Stakeholder management, Asset Management, Executing Agile Ceremonies

Jared Poché

Twitter: - sqljared

LinkedIn: Jared Poché

Contact: https://sqljared.com

Jared Poche began working with SQL Server as an instructor for certification classes and has a passion for teaching and performance troubleshooting. Jared spent 10 years providing customer support at Microsoft, most recently as a Sr. Support Escalation Engineer. He is currently working as a Database Engineer for ChannelAdvisor and is blogging about his current experiences at sqljared.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.

Doug McClurg

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

LinkedIn: Doug McClurg

Doug McClurg is the principal and founder of SOSRA Inc., an analytics leadership company. He brings both military and corporate experience to organizations who want to build or accelerate their analytics program. Doug has been building tailored Microsoft SQL Server solutions for many years. He brings deep knowledge of modern information architecture to projects ranging from innovating the traditional data warehouse to capturing WiFi presence and machine data to democratizing corporate analytics. He has served as a leader, mentor, and architect to teams in Government, Oil Gas, Hospitality, and Retail.

Drew Furgiuele

Twitter: - pittfurg

LinkedIn: Drew Furgiuele

Contact: http://www.port1433.com

Drew Furgiuele is a senior DBA that lives in Dublin, Ohio who is passionate about SQL Server and PowerShell. He’s been working with SQL Server since 2002. When he’s not accidentally dropping tables in production, he likes writing automation scripts, blogging about SQL Server Replication, wiring electronics, playing board games, and spending time with his dog. He’s also not embarrassed by his Spotify playlists.

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.

Mark Wilkinson

Twitter: - http://twitter.com/m82labs

Contact: http://www.m82labs.com

I am a father of 4, and live in Raleigh North Carolina. I love fixing problems, and learning new technologies that can help me fix those problems faster and better than I did the time before.

In my spare time I like to read, speak, and learn new things. I currently work as a Database Administrator at ChannelAdvisor where I solve fairly interesting problems on fairly large databases.

You can often find me on Twitter where I talk about SQL, beer, and anything else I find interesting.

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.

Solomon Rutzky

Twitter: - SqlQuantumLeap

LinkedIn: Solomon Rutzky

Contact: http://SqlQuantumLeap.com/

Solomon Rutzky has been working with databases for since 1996, focusing on SQL Server since 2002. He has written several articles for SQL Server Central (including the Stairway to SQLCLR series), and SimpleTalk, and has a blog: https://SqlQuantumLeap.com/ . Solomon is owner / founder of Sql Quantum Lift ( https://SqlQuantumLift.com/ ), and is the creator of the popular SQLCLR library of functions: SQL# ( https://SQLsharp.com/ ). He does what he can to help others by answering questions on a couple of StackExchange sites ( https://stackexchange.com/users/281451/ ), Ask.SqlServerCentral.com/users/20164/SRutzky.html , and SqlServerCentral.com/Forums/ .

Derik Hammer

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

LinkedIn: Derik Hammer

Contact: http://www.sqlhammer.com

I am currently working as a Database Operations Team Lead with Subway World Headquarters. Server configuration, architecture, disaster recovery, high-availability, performance tuning, and maintenance automation form the bulk of my responsibilities. Almost all of my previous experience has resided firmly in the traditional / production DBA realm. I also spend as much time as I can spare attending SQL Server community functions. Currently chapter leader for FairfieldPASS.

Michael Wharton

Twitter: - MyProjectExpert

LinkedIn: Michael Wharton

Contact: http://MyProjectExpert.com

Michael Wharton is a Project MVP. He has been an independent consultant for the past 20 years, with over 30 Project/SharePoint Server deployments. He has an MBA from Wake Forest and has over 44 Microsoft Certifications. Michael’s primary job is helping companies setup a PMO, Project Management Office using Project Server using SQL server on a SharePoint Farm. He has worked extensively with the back end support setting up SQL server, SharePoint Server and Project Server using PowerShell.

Dan Zaratsian

I’m a Solutions Engineer with Hortonworks, specializing in streaming analytics and machine learning. I work with a variety of technologies, integrating open-source and enterprise software, in order to design, program, and implement analytical solutions for clients.

In this role, I support the southeast region, helping clients architect hadoop solutions using the Hortonworks Data Platform (HDP) and real-time analytical applications using the Hortonworks DataFlow (HDF) technology stack.

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.

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.

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

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.

Chris Voss

Twitter: - ceedubvee

LinkedIn: Chris Voss

Contact: http://ceedubvoss.com

Chris is a data professional located in the Raleigh-Durham region of North Carolina. He has been working on data analysis and database development in SQL Server since 2008 R2. His experience includes hacking T-SQL code, using Reporting, Integration, and Analysis Services for solutions, and delivering data models and optimized queries. He has been a member of the TriPASS user group since 2013 and is part of the organizing committee for SQLSaturday Raleigh. In his spare time, you can spot him working within the autism spectrum community or running somewhere (most likely at a local run club).

Patrick Keisler

Twitter: - @PatrickKeisler

LinkedIn: Patrick Keisler

Contact: http://www.patrickkeisler.com

I#39;m a husband, a father, an Atlanta Braves fan, and oh yeah…I know a thing or two about Microsoft SQL Server, because I work for Microsoft supporting it as a Premier Field Engineer. I have over 15 years of DBA experience and have gained considerable knowledge in SQL Server by supporting lots of different type of applications ranging from high-volume trading applications to large data warehouses. I hold several certifications: MCSE: Data Platform, MCITP SQL 2008 Admin and Dev, and Security+.

George Walkey

Twitter: - sqlbytehd

Contact: http://insyncva.com

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

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.

Thomas Chan

LinkedIn: Thomas Chan

I work with SQL Server since 2001 with version 7.

Jamie Dixon

Twitter: - @jamie_dixon

Contact: http://jamessdixon.wordpress.com

Jamie Dixon writes code. That is what he does for his job and that is what he does for fun. He has worked in a series of positions and in a variety of industries. He is the former chair of his town’s Information Services Advisory Board and is on the board of his local .NET User Group (TRINUG). He has written articles for Make magazine, is a frequent blogger, and has been a Microsoft MVP since 2015 (F#/Visual Studio and Data Platform). He is the author of Mastering .NET Machine Learning (Packt 2016) and is authoring a series of upcoming videos on supervised machine learning techniques from Manning Press.

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.

Mark Gordon

Mark has been working in IT for 30 years. Currently is a senior MS SQL DBA/Database developer who also performs SQL performance tuning and data warehousing. Works with SSIS and develops ETL/ELT packages for data warehousing. Also is involved with reporting solutions with SQL Server Reporting Services (SSRS). Enjoyes sharing SQL techniques with newcomers.

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.

Shannon Lowder

Twitter: - @shannonlowder

LinkedIn: Shannon Lowder

Contact: http://shannonlowder.com

For over 15 years Shannon Lowder has been spotting patterns and learning ways to work smarter instead of harder. He started with development and moved into database administration. Using TSQL, Database Jobs and PowerShell, he automated himself out of contracts quickly. As Business Intelligence became a greater demand, he moved into SSIS, SSRS, and SSAS development. Early on, he tried using PowerShell and .Net to automate BI Development. Later those efforts turned to Biml. After founding a startup six years ago, he finds himself a data platform consultant, designing and guiding other professionals to build highly automated enterprise solutions. Today, he is a Biml Hero candidate and is awaiting the final approval for the award.

John Martin

Twitter: - SQLDiplomat

LinkedIn: John Martin

Contact: https://www.mssqltips.com/sqlserverauthor/291/john-martin/

John Martin is a Data Platform Engineer working in the financial sector, as well as Vice President Marketing for the PASS organization and currently a Microsoft Data Platform MVP. Previously John has worked as a product manager for SentryOne and a Premier Field Engineer with Microsoft UK.

John has over a decade of experience working with SQL Server and the Microsoft Data Platform. Working as a DBA, developer and consultant for Microsoft, he has been lucky enough to see how best, and how not, to use SQL Server and the Data Platform effectively.


The following is a list of sponsors that helped fund the event:

Back to the SQLSaturday Event List

Back to the home page