SQLSaturday #173 - Washington DC 2012

Event Date: 12/08/2012 00:00:00

Event Location:

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

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: The Art of Questions and success as an IT Pro

Abstract: Data professionals spend a lot of time asking questions. You spend countless hours refining your techcial skills but how much time do you spend learning researching and practicing the art of asking questions?

What might happen to your career if you did?

This session presents a bit of theory on the art and science of questions. Here’s a question for you: Did you know that asking “why” questions can make people feel defensive and can color the way they respond to you? Strange but true. We’ll review some of the biggest mistakes you can make when asking questions and I’ll offer a few some tips on how you can turn mediocre questions into great questions.

And oh yeah. I’ll leave time for asking questions at the end.


  • Brian Moran

Track and Room: Professional Development - N/A

Title: “ColumnStore” Indexes for Fast EDW Query

Abstract: This session will introduce the new xVelocity Memory-Optimized Columnstore Index feature of SQL 2012. This presentation will describe what a column store index is, how this feature is used to store data by columns instead of by rows and compare the advantages and disadvantages between the two storage methods. Live demos will explore how to create columnstore indexes, when to create them, best practices for using them and typical data warehouse scenarios that can leverage the columnstore index to drastically speed up data warehouse queries, in many cases by a factor of 10 to 100, so you are equipped to start implementing this feature into your database environment.


  • Derek Dai

Track and Room: BI / SSAS 2 - N/A

Title: (SQL,SSIS,MDS) Adv Fuzzy Matching Roll Your Own

Abstract: Fuzzy Matching, Similarity Matching or Record Linkage is the most critical and least understood process in any Data Warehouse, BI, Integration, Big Data , Data Quality, MDM , Social Network or integrating crap effort. Over at LinkedIn there is Group run by Henrik Liliendahl Sorensen for Data Matching, Bill Winkler, principal researcher at the US Census” has written a series of white papers on record linkage and particular a technique called “Blocking Indexs”. In addition we wil cover William Cohen Research Professor, Machine Learning Department, Carnegie Mellon University white papers an implementations. Presented will be our collection of “real world” examples(Code) and you will leave a master of record linkage and the concepts behind it


  • Ira Warren

Track and Room: DBA 1 - N/A

Title: SQL Server 2012 Columnstore index

Abstract: It might seem far-fetched that a company would upgrade to SQL Server 2012 “just” for a database index. But after you see the performance enhancements gained from the new columnstore index in SQL Server 2012, you’ll see why many are calling this one of the most important features in the history of SQL Server. In this presentation, I’ll talk about the physical aspects of columnstore index in SQL Server 2012, how to create it, and what environments (mainly data warehousing environments) and queries can make use of it. I’ll show performance benchmarks between columnstore indexes in SQL Server 2012, and compare them to index strategies prior to SQL Server 2012. I’ll also show how the new Batch execution mode can improve performance as well


  • Kevin Goff

Track and Room: BI / SSAS 1 - N/A

Title: Using Expressions to Avoid Three SSRS Annoyances

Abstract: As powerful as it is, SQL Server Reporting Services still has frustrating annoyances. Three in particular are: 1) non-queried parameter values must be entered one value at a time, with lots of clicking along with way; 2) the page header and page footer sections cannot contain data regions and therefore cannot display sets of data-driven values; and 3) matrix reports promise the analytical ability of Excel PivotTables but fall short because they are fixed and lack the ability to dynamically slice-and-dice data by values selected by the user. With the expression techniques taught in this session, these annoyances will annoy no longer because you will be able to work around all three.


  • Geoff Johnson

Track and Room: BI / SSAS 1 - N/A

Title: Getting Started with MDX: The (Very) Basics

Abstract: In this session, led by Microsoft BI Architect and SQL Server MVP Bill Pearson, we will concentrate largely upon crafting simple MDX expressions and queries whose purposes, for the most part, are to return a set of data. We will overview the structure of a cube, using as a basis the sample Adventure Works cube that is available to anyone installing SQL Server Analysis Services 2008 R2. We will then outline the components of simple MDX syntax, and get started writing basic expressions and queries. We will expose basic member functions, introduce filters (or “slicers”), and begin exploring core MDX functionality, including calculated members, and named sets.


  • William E Pearson III

Track and Room: BI / SSAS 1 - N/A

Title: PerfTuning: Intro To Execution Plan Analysis

Abstract: Topic will provide a more in depth look into query execution plans and is targeted for junior to senior DBA’s. You will learn how to identify what indexes are being used by the SQL optimizer, different type of index operations that are performed by SQL server and what operations are generally considered as a preferred method of data retrieval. We will discuss how to determine if indexes used by the optimizer are the optimal ones and the exceptions to the rules. Finally we will discuss the relationship between different types of index operation and different types of join types within SQL Server including how the SQL Optimizer determines which join type it will use and pros and cons of each type.


  • Konstatin Melamud

Track and Room: Developer - N/A

Title: Panel discussion - Professional Development

Abstract: An hour of open panel QA to discuss your professional development. Topics may include resumes, interviews other questions. Join Brian Moran and others as they openly discusses and answers any questions you have regarding your professinal development in SQL Server.



Track and Room: Professional Development - N/A

Title: Table Vars Temp Tables - What you NEED to Know!

Abstract: Almost every SQL Developer is familiar with Table Variables and Temporary Tables. While each of these objects represent temporary storage, there are also substantial differences between them. Understanding the differences between Table Variables and Temporary Tables, and the ramifications that those differences cause, is essential to being able to properly select the appropriate object for use in your development tasks. In this code filled session, we’ll discover the differences and similarities of Temporary Tables and Table Variables, dispel some widespread myths about each, and answer the most important questions of them all, “When do I use one or the other and what are the various impacts of doing so?”


  • Wayne Sheffield

Track and Room: DBA 1 - N/A

Title: SQL 2012 – All About HA and DR

Abstract: Have you heard about all of the new Availability Group features in SQL 2012? Thinking about implementing a DR solution, but don’t know where to start. In this presentation you’ll learn all about the new DR features in SQL Server 2012 and see them in practice.


  • Joseph D’Antoni

Track and Room: DBA 2 - N/A

Title: Taking BI to the Next Level: Collaboration

Abstract: Self-service BI is usually an independent activity. But when individuals discover interesting information that they want to share, they need a centralized location to do that. When people work together, new insights are possible, and that’s what collaboration is all about. As more people see the benefits of the solution, they become more likely to use it. As individual products, SQL Server 2008 R2, SharePoint 2010, and Excel 2010 expand your options for enabling BI in your organization, but collectively they create a solid platform for collaborative BI. Knowing which tool to use for which job can be tricky. Come to this session to learn how to use these tools to foster collaboration.


  • Stacia Varga

Track and Room: BI / SSAS 2 - N/A

Title: Shortcuts to Building SSIS in .Net

Abstract: Using an Open Source project API Library this session will show how SSIS Packages can be created as easily in C# .Net as they are in BIDS. During the session real world examples will be used to show how SSIS Code can be created in BULK.


  • Paul Rizza

Track and Room: BI / SSAS 2 - N/A

Title: DBA’s1st Date - Getting to know a new environment

Abstract: With more entry level DBA positions becoming available, and non-DBA’s shifting into DBA roles, you may find yourself in a position where you need to become familiar with a new server environment quickly and efficiently but not know where to begin. To help prevent this for happening, we will review the do’s and don’ts that should be considered when getting to know with a new environment.


  • Ryan Brickey

Track and Room: Professional Development - N/A

Title: Virtualizing SQL 2012: Doing It Right

Abstract: A database is a very resource intensive by its very nature and one of the most resource intensive applications you will ever virtualize. If best practices are not followed, the database will never perform as needed. This presentation will teach the DBA how to virtualize a business critical application like SQL server 2012. It will be based upon experience learned using VMWare as the virtualization platform. But many of the lessons taught will carry over to any virtualized platform.


  • Michael Corey

Track and Room: DBA 2 - N/A

Title: Know Backups and Know Recovery

Abstract: It is easy to schedule full backups to run each night, but is that the right decision for your organization? You say you have a backup strategy, but what is your recovery strategy? Do you have a well-executed recovery plan?

In this session I will cover several methods for performing much needed backups and how to recover those backups. Full, Differential, File Group, Transaction logs and recovery the tail end of a the log. He will discuss industry best practices and hopefully cause you to validate and test your current strategy.


  • Tim Radney

Track and Room: DBA 2 - N/A

Title: Performance Tuning for Pirates

Abstract: If you follow baseball you will notice that the Pittsburgh Pirates (this speaker’s favorite team) has to do more with less to be successful. This trend can also exist within IT shops. If you need to improve the performance of your SQL Server instances and cannot purchase 3rd party tools this session is for you. You will learn how to improve your performance tuning process by using several free tools. This session will cover wait stats, dynamic management objects, perfmon, PAL, SQL Trace, ClearTrace, SQL Nexus and SQLDiag.


  • John Sterrett

Track and Room: BI / SSAS 2 - N/A

Title: Recipe for a happy DBA

Abstract: In a world where separation of responsibilities becomes more and more important, the borders between DBAs and developers have grown wider than ever. For the developer seeking to employ the services of SQL Server, Interaction with one or more DBAs at certain stages of the development life cycle is nearly a given. This session discusses tips and techniques to follow that can ensure these interactions are civil, and maybe even pleasant. This topic includes tips on TSQL scripting, deployment techniques, bad habits to avoid and beginning execution plan analysis.


  • Jason Hall

Track and Room: Professional Development - N/A

Title: Isn’t that Spatial! (BI Edition)

Abstract: In this session, we will walk through the process of building a spatial data warehouse from the ground up. We will first design a basic spatial data warehouse, then identify and import a spatial data source by using Microsoft SQL Server Integration Services (SSIS), and finally write a spatial query to provide data to SQL Server Reporting Services (SSRS). We will also review basic concepts of working with spatial data in SQL Server.


  • Jason Horner

Track and Room: BI / SSAS 1 - N/A

Title: DBA Worst Practices, Disasters and Horror Stories

Abstract: Join Brian Moran, Tim Radney, Mike Walsh and perhaps a few more special guests in a panel discussion on some of the worst practices we often see DBAs do. A little secret - we’ve done them, too. We’ll tell you some of the ways you are hurting your databases, tell you about some of the disasters we’ve been involved in and even share a few horror stories of the ones we’ve caused. We’ll leave plenty of time for QA and give you a chance to share your own or stump us with a “what would you do….” question.


  • Mike Walsh

Track and Room: Developer - N/A

Title: Join Us! Getting Started as a Technical Speaker

Abstract: Have you ever thought about speaking at a user group or SQLSaturday, but weren’t quite sure how to get started? If so, this session is for you! Technical speaking is loads of fun, great for your career, and you get to hang out with some terrific people. This session will provide the tools necessary to get your first session off the ground, and prep you to be a great speaker. Attend this session and you’ll be able to: * Identify your topic and build a killer abstract for it, * Design and build the presentation, and * Prepare and deliver your first session


  • Eddie Wuerch

Track and Room: Professional Development - N/A

Title: Resource Governor for SQL Server

Abstract: In this presentation, Steve will provide an overview of Resource Governor, a feature introduced in SQL Server 2008 that gives DBAs and system administrators much more granular control over how CPU and memory are used by SQL Server. He’ll discuss the components that make up Resource Governor, then walk through examples of how to set it up along with various usage scenarios.


  • Steven Wright

Track and Room: DBA 1 - N/A

Title: Windowing Functions in SQL Server 2012

Abstract: SQL Server 2012 brings with it nearly full ANSI compliance with the windowing functions. Come to this code filled session to learn about all of the windowing functions in SQL Server 2012: Ranking functions, changes for windowing in the Aggregate functions, and the new Analytic and Sequence functions. We’ll examine how this latest implementation of the windowing functions allows us to perform running and sliding aggregations; retrieve data from adjacent rows in the partition, and much more – all without self-joins back to the source table.


  • Wayne Sheffield

Track and Room: Developer - N/A

Title: Revenge: The SQL!

Abstract: Have you been wronged, cheated, lied to, lied about, or deceived by a coworker? Feel like your DBA position offers no opportunity for revenge? WRONG! This session is a light-hearted exploration of some delightfully mischievous SQL design patterns that will annoy, aggravate, and antagonize anyone who has to work with them…even though they deserved it! Learn how to create tables with no names, columns with duplicate names, and write perfectly valid yet utterly nonsensical SQL. You may never get to use these techniques…but you’ll ache for the chance!


  • Rob Volk

Track and Room: Developer - N/A

Title: PowerShell 101 for the SQL Server DBA

Abstract: The more you have to manage, the more likely you’ll want to automate your processes. PowerShell is the scripting language that will make you truly effective at managing lots of servers. This session will introduce you to PowerShell and show you how to use it to manage SQL Server across many instances.


  • Allen White

Track and Room: DBA 1 - N/A

Title: Revenge: The SQL Part 2: The Sequel!

Abstract: In a world…where DBAs are blamed, mistreated, and overworked…one man…WILL. GET. EVEN. In this entertaining and impractical follow-up to the entertaining and impractical Revenge: The SQL, Rob Volk will show you even more impractical but oh-so-tempting ways to get back at those who abuse SQL Server and make you clean it up. Techniques will cover: preventing sa use, preventing ad-hoc SQL, cursors and missing WHERE clauses, and the ever-popular trigger mayhem. And if you stay for the after-credits sequence you may encounter the evil twins, duplicate primary keys!


  • Rob Volk

Track and Room: Developer - N/A

Title: Advanced Charting Techniques in SSRS

Abstract: SSRS 2008 R2 has been a game changer for SQL Server in terms of visualization techniques. With a wide range of available options for charting, BI professionals struggle to get familiar with even the basic functionalities of most charts. This session will talk about the basic functionalities of all the charts as well as some tips and tricks around them. Come to this session and take your charting skills to the next level.


  • Jason Thomas

Track and Room: BI / SSAS 2 - N/A

Title: Loading Data Warehouse Partitions with SSIS 2012

Abstract: Co-presented with Darryll Petrancuri! SQL Server 2012 table partitions offer powerful Big Data solutions to the Data Warehouse ETL Developer. In this presentation, Andy Leonard demonstrates one approach to loading partitioned tables and managing the partitions using SSIS 2012, and reporting partition metrics using SSRS 2012.Objectives1. A practical solution for loading Big Data Fact tables (1B+ rows).2. Learn more about SQL Server 2012 table partitioning.3. Learn more about using SSIS Expression Language to generate dynamic SQL in SSIS 2012.


  • Andy Leonard

Track and Room: BI / SSAS 1 - N/A

Title: Virtualizing Business Critical SQL Servers

Abstract: Everyone knows that SQL Server can be virtualized, but most are only virtualizing development and testing environments. Top-tier production workloads can be virtualized too, and David Klee (@kleegeek) will provide valuable insight into how to properly prepare for and implement a successful virtualization campaign for ALL of your SQL Server environments and prepare your organization for the change. Practical tips, tricks, and gotcha’s will be discussed in this dynamic dialog session.


  • David Klee

Track and Room: DBA 2 - N/A

Title: How PowerShell helps me as a DBA

Abstract: This session will go over what PowerShell is and walk though some example code of ways I use PowerShell to help me as a DBA.


  • Carlton Ramsey

Track and Room: DBA 1 - N/A

Title: SQL Server 2012 TSQL Enhancements and Additions

Abstract: The breadth and depth of improvements in TSQL coming out with SQL Server 2012 represent the most significant changes in, well, probably ever! This fast and furious overview will touch on a large range of these goodies, with plenty of sample code for you to take home and review at your leisure!


  • Kevin Boles

Track and Room: Developer - N/A

Title: Common TSQL Mistakes

Abstract: We are going to examine a variety of oopsies MANY developers fall prey too - some obvious, some pretty subtle and some down right sneaky! Lots of code examples with the bad AND good code presented. I GUARANTEE that you will find things here that will either prevent you from getting bad data, throwing unwanted errors or vastly improving your database application’s performance. I have given this talk over a dozen times now and it is always very highly rated!


  • Kevin Boles

Track and Room: DBA 2 - N/A

Title: Let’s Talk Licensing

Abstract: Being a DBA is not all smiles and sunshine; sometimes you have to deal with the tedious topic of licensing. As a DBA, developer, or consultant, you are responsible for ensuring that your company or client is in compliance and can pass software audits. As with any Microsoft product license, there are complicated nuances of the SQL Server licensing program with many new twists added in 2012. This session will help you understand what you can and cannot do with various license types, and, how you could save your company some serious money.


  • Kevin Goode

Track and Room: Professional Development - N/A


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

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.

Ira Warren

 Over 35 years experiences in Software Sevelopemt, IT Management and BI Architecture.

Rob Volk

Twitter: - sql_r

LinkedIn: Rob Volk

Contact: http://weblogs.sqlteam.com/robv/

Rob Volk is a SQL Server DBA in the Metro Atlanta area since 2001. He also moderates and answers the forums on SQLTeam.com. While an old-time cranky DBA, he no longer considers quot;business intelligencequot; an oxymoron or quot;the cloudquot; as merely atmospheric moisture, and is delightedly dipping his toes into both of these new oceans, and loves to do things in new and and unusual ways.

Allen White

Twitter: - SQLRunr

LinkedIn: Allen White

Contact: http://dataperfpro.com/blog/

Allen White is a Data Platform consultant. He has been both a developer and an administrator, so he understands both perspectives towards database technology. He loves sharing his experiences and helping people learn how to use SQL Server. Allen has spent over 40 years in IT, using SQL Server since 1992, and has been awarded Microsoft’s MVP Award for the last 13 years. Allen was a PASS Director from 2016 - 2018.

Mike Walsh

Twitter: - mike_walsh

LinkedIn: Mike Walsh

Contact: https://www.straightpathsql.com

Mike Walsh is an experienced SQL Server professional and has worked with SQL Server since version 6.5. He has been in the role of DBA, developer, and performance tuner, but always leans on his DBA and tuning experience. He has been awarded the SQL Server (now Data Platform) designation 6 times since 2011 and is a current MVP. He runs a SQL Server consultancy focused on DBA services and cloud enablement. He has spoken several times at PASS and regional events. In his spare time, he runs a small farm with his family in rural New Hampshire and is a call Firefighter in his small town.

Steven Wright

Twitter: - @SQL_Steve

LinkedIn: Steven Wright

Contact: https://blogs.sentryone.com/author/StevenWright/

Steve currently serves as Director of Advanced Analytics at SentryOne. As a member of the SentryOne team for over 13 years, Steve has broad experience working in various environments supporting the Microsoft Data Platform both on-prem and in the cloud. Steve has earned the Microsoft Professional Program Data Science Certification and manages a team of Data Scientists and BI Developers in support of SentryOne’s internal and product facing advanced analytics initiatives.

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

William E Pearson III

Twitter: - @Bill_Pearson

LinkedIn: William E Pearson III

Contact: https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E

Bill Pearson created Island Technologies Inc. in 1997, and has developed a large and diverse customer base since. Bill#39;s background as a CPA, Internal Auditor, Management Accountant, and SQL Server MVP (BI) enables him to provide value to clients as a liaison between Accounting / Finance and Information Services. Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies and focuses his practice upon the integrated Microsoft Business Intelligence

Paul Rizza

Twitter: - @PaulRizzaSQL

LinkedIn: Paul Rizza

Contact: http://blogs.msdn.com/b/paulrizza/

Paul Rizza is a Senior Consultant at Microsoft Consulting Services (MCS), Lead on the MCS SQL Hiring Team, and has over 25 years’ experience consulting, teaching and developing on SQL Server platforms. Paul’s expertise includes ETLs, Dimensional modeling, architecting highly available SQL environments and performance tuning. Paul has an Undergraduate degree from UMBC and a Master’s degree both in Computer Science with a concentration in Database Theory from Johns Hopkins University.

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

Jason Thomas

Twitter: - @SqlJason

LinkedIn: Jason Thomas

Contact: http://www.SqlJason.com

Jason Thomas is a Microsoft Certified SQL Server professional with over 10 years of Microsoft BI experience. He is a BI Consultant for BlueGranite, based in Charlotte, NC. When he#39;s not at work, Jason likes sharing his time between the MSDN forums (for which he was recognized with the Microsoft Community Contributor award), blogging about MSBI (www.SqlJason.com), speaking at SQL Server events, and watching movies with his wife (not necessarily in that order).

Joseph D’Antoni

Twitter: - jdanton

LinkedIn: Joseph D’Antoni

Contact: http://joeydantoni.com

Joseph D’Antoni is a Senior Consultant and Microsoft Data Platform MVP with over 20 years of experience working in both Fortune 500 and smaller firms. He is a Principal Consultant for Denny Cherry Associates and lives in Malvern, PA. He is a frequent speaker at major tech events like Microsoft Ignite, PASS Summit, and Enterprise Data World. He blogs about all topics technology at joeydantoni.com. He believes that no single platform is the answer to all technology problems. Joseph holds a BS in Computer Information Systems from Louisiana Tech University and an MBA from North Carolina State University, and is the co-author of the Microsoft book “Introducing SQL Server 2016”.

Michael Corey

Twitter: - Michael_corey

LinkedIn: Michael Corey

Contact: http://michaelcorey.com/

Michael is a Director Cloud Computing Evangelist for Spectrum Enterprise Navisite. In 2017, was recognized as #42 of the top 100 most influential people in the “cloud industry”. Michael’s a recognized Microsoft Data Platform MVP formerly (Microsoft SQL Server MVP), recognized Oracle ACE, a recognized VMware vExpert and has worked with relational databases for over 30 years starting with Oracle Version 3. Michael is a Past President of the Independent Oracle Users Group (IOUG), A Founder of the Professional Association of SQL Server and current President of the IOUG VMware Special Interest Group. Michael is the original Oracle Press author, frequent blogger http://michaelcorey.com/, a regular columnist for the Big Data Quarterly

Eddie Wuerch

Twitter: - @EddieW

LinkedIn: Eddie Wuerch

Contact: http://www.indydba.com

Eddie Wuerch has 20 years of experience as a SQL Server specialist in a much-longer IT career. A Microsoft Certified Master, Eddie spends his days in the Salesforce Marketing Cloud, focusing on performance, scale, and uptime for the massive SQL Server backend. These SQL Servers churn billions of transactions daily against trillions of rows of data in a 24x7 continuously-available online system accessed by millions worldwide every day.

Konstatin Melamud

Konstantin Melamud is a SQL Server Team Lead for Remote DBA Experts. He works with over 200 customers on solutions within the SQL Server environment and leads code tuning team within Remote DBA experts. He is passionate about educating users on SQL Server by speaking at user groups, conferences, and labs.

Rob Volk

Twitter: - sql_r

LinkedIn: Rob Volk

Contact: http://weblogs.sqlteam.com/robv/

Rob Volk is a SQL Server DBA in the Metro Atlanta area since 2001. He also moderates and answers the forums on SQLTeam.com. While an old-time cranky DBA, he no longer considers quot;business intelligencequot; an oxymoron or quot;the cloudquot; as merely atmospheric moisture, and is delightedly dipping his toes into both of these new oceans, and loves to do things in new and and unusual ways.

Derek Dai

Contact: http://derekdb.wordpress.com/

Over 10 years’ experience in database design, development, and administration using a wide variety of tools and technologies. Having focused on Business Intelligence using the SQL Server BI stack (SSAS, SSRS, SSIS, Power-pivot, Semantic Model and Data Mining) with solid knowledge on SQL Server DB Core engine. And extensive experience with Microsoft development tools. PASS VC Leader; MCT; MSCE BI and Data Platform

Geoff Johnson

Twitter: - @chaunticleer86

Contact: http://selectstatements.blogspot.com

Geoff is the BI Developer for Custom Data Systems, Inc., a software company offering data management for CPA associations and similar non-profit groups. He has been working with SQL Server for over fifteen years, with a focus on BI and SSRS for 6+ years. Since January of 2016 he has been designed and implemented a data warehouse solution for CDS, Inc. He is an active member of the Richmond SQL Server User Group and counts it a privilege to share what he has learned the hard way with others so they don’t have to. He also occasionally blogs about his lessons learned.

Ryan Brickey

Twitter: - SQLBrickey

LinkedIn: Ryan Brickey

Contact: http://mindofadba.blogspot.com/

Ryan is currently a Database Administrator with Wells Fargo where he is responsible for a production SQL Server environment. Before coming to Wells Fargo, he started his career working as a data analyst doing data mining and developing ETL procedures. From there he turned to performance monitoring and tuning as a Software Support Engineer with SQL Sentry. He also holds the certification of MCITP - SQL Server 2008 Database Administration.

Jason Hall

Twitter: - @SQLSaurus

LinkedIn: Jason Hall

Contact: http://blogs.sqlsentry.com/jasonhall

Jason Hall (@SQLSaurus) leads SentryOne’s Product Management team, which is responsible for managing product design, development and delivery.

Jason has worked in varied technology roles for over 20 years and holds industry certifications including MCSE (legacy), MCSD, MCTS, MCPD, and PMC-III.

Tim Radney

Twitter: - @tradney

LinkedIn: Tim Radney

Contact: http://www.timradney.com

Tim is a Data Platform MVP and has a whole collection of Microsoft and other industry certifications. His experience includes HA/DR, virtualization, SSIS, SSRS, and performance tuning, among everything else SQL Server-related. Tim is very active and passionate in the SQL Community. He runs the Columbus GA SQL Users Group, has been a PASS Regional Mentor for a number of years, was named a PASS Outstanding Volunteer in 2012, and is a frequent speaker at user groups, SQLSaturdays and PASS Summits. Tim is one of the top ranked in karma on ask.sqlservercentral.com, answers questions as @tradney on Twitter, and blogs at http://timradney.com and SQLskills blog at http://www.SQLskills.com/blogs/tim.


This panel discussion will bring top SQL people together to hold an open forum to discuss any questions or issues you may have with SQL Server Replication

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.

Kevin Goff

Twitter: - @KevinSGoff

Contact: http://www.KevinSGoff.net

Kevin S. Goff (http://www.kevinsgoff.net) is a Microsoft SQL Server MVP

Database architect/developer/speaker/author

Regular columnist for CoDe Magazine on .NET, SQL Server, and Business Intelligence topics

Frequent speaker at community events in the Mid-Atlantic region.

Host of BDBI Radio (http://www.bdbiradio.com), a weekly webcast on SQL/BI topics

Kevin Boles

Twitter: - @TheSQLGuru

LinkedIn: Kevin Boles

Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.

Kevin Goode

Twitter: - @goodesql

Contact: http://www.goodesql.com

Kevin Goode is an MCSE, MCSD, and MCDBA. Currently, he is the Senior Data Architect for Inmar Inc. Kevin has over 12 years SQL Server experience starting with 6.5 and 15 years of IT experience. He has worked in many industries including manufacturing, distribution and logistics, financial services, IT outsourcing and has worked for several fortune 500 companies. His specialties include SQL Server development, Performance Tuning, Business Intelligence, and ETL.

Brian Moran

Twitter: - @briancmoran

LinkedIn: Brian Moran

Contact: http://www.linchpinpeople.com/author/brian-moran/

Brian Moran is Chief Servant Officer at Linchpin People and has been active in the SQL Server community for more than 20 years. Brian co-founded one of the first SQL Server user groups in the world, was one of the first SQL Server MVPs, was on the SQL Server Magazine launch team, and has served on the PASS Board of Directors in two separate terms. Brian#39;s roles in the SQL Server community include technologist, author, community leader, and entrepreneur.

Stacia Varga

Twitter: - @StaciaV

LinkedIn: Stacia Varga

Contact: http://blog.datainspirations.com

Stacia Varga is a Microsoft Data Platform MVP and SSAS Maestro with a Bachelor’s Degree in Social Sciences. A consultant, educator, author, and principal of Data Inspirations, her career spans more than 30 years, with a focus on improving business practices through technology.

Since 2000, Stacia has provided consulting and education services for Microsoft’s Business Intelligence technologies. As Stacia Misner, she also authored several books covering the Microsoft BI stack.

Jason Horner

Twitter: - jasonhorner

LinkedIn: Jason Horner

Contact: http://blog.jasonhorner.com

Hi, my name is Jason I’m a practice lead at Redapt. I spend most of my day helping clients solve business problems mostly in the Data and Advanced Analytics spaces. Sometimes this involves various and sundry cloud technologies including Azure Data Factory, Azure SQL Data Warehouse, Azure Data Lake Store, Azure Databricks, HDInsight and Azure SQL Database. I’m fluent in several languages including: SQL, C#, Python, and PowerShell.

I’m a Microsoft Certified Master of SQL Server (MCM) and have been recognized for my technical excellence and evangelism efforts by Microsoft by being awarded the Most Valuable Professional (MVP) for the last 5+ years.

In my off hours I like to snowboard, karaoke, ride roller coasters, and play arcade games

Kevin Boles

Twitter: - @TheSQLGuru

LinkedIn: Kevin Boles

Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.

Carlton Ramsey

Twitter: - @eccentricDBA

LinkedIn: Carlton Ramsey

Contact: http://www.eccentricDBA.com

Carlton B Ramsey has worked for Third Federal Savings and Loan in Cleveland Ohio for two decades as an Application Developer and Database Administrator. He is an active member of the North Ohio SQL Server User Group, frequent SQLSaturday Presenter and Past-President of the Akron-Canton Chapter of CompTIA AITP (Association of Information Technology Professionals). In addition, he has a MCSA SQL 2016 Database Development.

John Sterrett

Twitter: - JohnSterrett

LinkedIn: John Sterrett

Contact: https://johnsterrett.com/community/

John Sterrett is a MCSE: Data Platform, Principal Consultant, and the Founder of Procure SQL LLC. John has experience presenting at community events, including Microsoft Ignite, PASS Member Summit, SQLRally, 24 Hours of PASS, SQLSaturdays, PASS Chapters, and Virtual Chapter meetings. John is a leader of the Austin SQL Server User Group and is the founder of the HADR Virtual Chapter. John’s community activities can be found at https://johnsterrett.com/community/


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

Back to the SQLSaturday Event List

Back to the home page