SQLSaturday #233 - Washington DC 2013

Event Date: 12/07/2013 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: Being the Swiss Army Knife of DB Pros

Abstract: Being a specialist means you’re really, really good at one thing. Being a generalist means you’re good at a a lot of different things. The generalist has an advantage over the specialist because he or she can see and solve problems the specialists can’t. In this session I’ll cover why it’s important to diversify your skill set, not only for career protection, but to be better as a database professional. We’ll look at what skill sets to build on to expand your abilities around SQL Server to include the operating system, development, networks, and security. Remember, this saying isn’t complete, “Jack of all trades, master of none.” The full saying is, “Jack of all trades, master of none, though often times better than master of one.”


  • Brian Kelley

Track and Room: Prof. Dev - 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. Time permitting, I’ll also talk about the new enhancements in SQL 2014.


  • Kevin Goff

Track and Room: BI 1 - N/A

Title: Never Have to Say “Mayday!!!” Again

Abstract: December 1978: 10 people die in a commercial airliner. Why? Bad troubleshooting skills and poor maintenance – disaster-causing attitudes. As you’ll learn in this session, the doomed airliner ran out of fuel while the crew of three wasted time troubleshooting a false alarm. We can draw some parallels in the database world. Poor troubleshooting, disaster-causing attitudes, and a lack of disaster preparedness lead to needless downtime and serious user impact across our environments.

In this session, we’ll look at case studies of real-life aviation disasters and production database downtime incidents. We’ll see similarities in attitudes that cause disasters. Come learn about the importance of preparation, troubleshooting, and teamwork. This will be an interactive session where we’ll pick apart disasters, engage in discussion around case studies, and leave prepared to change attitudes in ourselves and our colleagues and avoid disasters at work.


  • Mike Walsh

Track and Room: Prof. Dev - N/A

Title: HealthySQL

Abstract: Are your SQL Servers Healthy? Are all the SQL Servers you manage, healthy running optimally and has the high availability that is expected? How do you know for sure? Have you checked on the health of your SQL Servers lately? Let’s make sure your servers are up to its latest optimizations!

What is a HealthCheck, and how do we perform one? If you are a DBA, then you ought to know! Well Pearl Knows. Robert Pearl talks about the importance of regular health checks of your SQL Server(s). We will talk about the need to create a baseline and provide some time-tested ways to determine if your SQL Servers are healthy and prove it to your managers, clients and heaven forbid, your IT auditors. Using various tools and scripts, you will come out of this session feeling much better :-)


  • Robert Pearl

Track and Room: DBA 2 - N/A

Title: (Way Too Much) Fun with Reporting Services

Abstract: Head starting to explode from all the technical information you’re absorbing? Come spend a session with us while we play games with Reporting Services…literally! Come watch as Stacia Misner and a special guest introduce you to some word play, all wrapped up in SQL Server Reporting Services. She’ll push the limits with what can be built in SSRS and show you how to have fun while doing it. Board games and SQL…who could ask for more?


  • Stacia Varga

Track and Room: BI 1 - N/A

Title: Data Warehouse ETL Rollback with SSIS 2012

Abstract: Loading a data warehouse can be fraught with data quality issues, data type mismatches, and failed loads. To combat these issues and load your data quickly can be a challenge. This session will explain step-by-step how to implement an ETL rollback framework to remove any data that was loaded incorrectly. Based on a real-world implementation, this framework can either automatically or manually load the corrected data, making your life easier.


  • Jessica Moss

Track and Room: BI 2 - N/A

Title: SQL Server Backup and Recovery Fundamentals

Abstract: Backup and Recovery are essential parts of and DBA’s job. After all, if you lose your data you lose your job so you need a great backup strategy. In this session we will cover Recovery Models, Backup Types, Backup Strategy, Restores, RTO, RPO, and understanding how your Transaction Log is maintained through backups.


  • Ayman El-Ghazali

Track and Room: DBA 1 - N/A

Title: Branding Yourself for a Dream Job

Abstract: Everyone wants a dream job that they enjoy going to each week. However finding that job, and getting yourself hired can be hard for most people. Steve Jones will give you practical tips and suggestions in this session that show you how to better market yourself, how to get the attention of employers, and help improve the chances that the job you want will get offered to you. Learn about networking, blogging, and more.


  • Steve Jones

Track and Room: Prof. Dev - N/A

Title: Using Compression to Improve Database Performance

Abstract: Back in the old days, compression and databases was a really bad idea. Now, with powerful CPUs we can use to both improve performance and save disk space. We will cover the basics of how all compression and deduplication works, and then we will learn how SQL Server page and row compression work, and the special compression that is used in SQL 2012 Columnstore Indexes. We will demo performance and space savings in using compression.


  • Joseph D’Antoni

Track and Room: DBA 1 - N/A

Title: Squeezing Performance from VMware-Based SQL Server

Abstract: Sure, your SQL Server is up and running. Anyone can click through a SQL Server install nowadays. But… is it running at its peak potential? Do you have your VMware environment configured properly? Have you measured the performance lately? Your business-critical SQL Server performance does not have to suffer just because it was virtualized. Very specific VMware and SQL Server tuning tips and tricks from David Klee (@kleegeek) will be presented in this session.


  • David Klee

Track and Room: DBA 2 - N/A

Title: Best SQL Server Programming practices

Abstract: This session is mostly for junior SQL Server developers, Project Managers and Team Leads.

We will talk about how to write good SQL code, how to collaborate in a team and produce perfect documentation.


  • Slava Murygin

Track and Room: Dev - N/A

Title: Using BIML as an SSIS Design Patterns Engine

Abstract: Business Intelligence Markup Language provides a powerful solution for creating and managing SSIS Design Patterns. Andy Leonard, one of the authors of SSIS Design Patterns, demonstrates the flexibility of BIML in this session.


  • Andy Leonard

Track and Room: BI 2 - N/A

Title: SQL Server Dos and Don’ts: Keys to DBA Nirvana

Abstract: Bad Windows builds? No HA? No backups? SQL Server considered the non-mission critical platform yet you have hundreds of instances? Over the years I’ve seen most, if not all of, the good, bad, and ugly of being a SQL Server DBA from being both a full time employee as well as a consultant. If you want to skip 20 years of ups and downs, come to this session to hear how you can be a better DBA for your SQL Server deployments, avoid pitfalls, and hopefully laugh at a few of my misadventures over the course of my career.


  • Allan Hirt

Track and Room: DBA 1 - N/A

Title: Performance Tuning - Index Optimization

Abstract: This topic will cover best practices when optimizing index performance in your DBMS. This presentation is targeted for mid to senior level DBA’s. You will learn the optimal strategy for selecting both clustered and non-clustered indexes in your database. Along the way, we will discuss how column and index statistics can affect the performance in your queries. Finally, we will take a look at the benefits and pitfalls of using filtered, full-text search and composite indexes, their best practices, and exceptions to the rules.


  • Konstantin Melamud

Track and Room: DBA 1 - N/A

Title: It is TEMPDB, Why Should You Care?

Abstract: TEMPDB is just for temporary data right? It is installed by default and gets recreated it time SQL is restarted so what does it matter right? WRONG. This session will give you great insight into what uses TEMPDB, why TEMPDB is important, what are some best practices for configuring TEMPDB, and how to determine if you have contention. If you have systems where TEMPDB hasn’t been touched since the install, you need to attend this session.


  • Tim Radney

Track and Room: BI 1 - N/A

Title: A Walk Around the SQL Server 2014 Audit Feature

Abstract: In this demo-heavy session, we will start by covering an overview of server and database auditing capabilities of SQL Server 2014. The session will largely focus on the specifics of using the SQL Server 2014 Audit feature, and we will step through a demonstration on configuring, maintaining and troubleshooting SQL Serve 2014r Audit for server and database events. The demo environment will be run on a Windows Azure Virtual Machine running Windows Server 2012 R2 and SQL Server 2014 (CTP 1 or higher).


  • Timothy McAliley

Track and Room: DBA 1 - N/A

Title: Policy-Based Management and Central Management Server

Abstract: Two of the most highly underutilized features of SQL Server are Policy-Based Management (PBM) and Central Management Server (CMS). PBM allows you to administer and control your SQL Server environment in a way that was very difficult or even impossible beforehand. Simply put PBM lets you define rules or policies to govern your SQL Server enterprise. CMS among other things allows you to organize and manage your instances in groups that you define from a single point. Come see how these two features can add a whole new level of manageability and reduce the time you spend achieving your management goals.


  • Andrew Kelly

Track and Room: DBA 2 - N/A

Title: Dealing With Errors in SSIS 2012

Abstract: This session focuses on error handling in SQL Server Integration Services 2012. Different techniques and strategies will be introduced for error handling in control flow, data flow, and script tasks as well as how to dynamically handle errors.


  • David Dye

Track and Room: BI 2 - N/A

Title: Crazy Things That Developers Do, Part I

Abstract: Throughout my career, I’ve seen developers do some pretty crazy things to databases (and truth be told, I’ve done some of these myself!). Come to this 2 part session to learn what we do, why it’s bad to the database server… and alternatives that can be used instead. Trust me… your DBA will love you for making these changes.


  • Wayne Sheffield

Track and Room: Dev - N/A

Title: Introduction to SQL Server 2012 AlwaysOn Availability Groups

Abstract: One of the most talked about new features in SQL Server 2012 is AlwaysOn Availability Groups. In this session, we will cover the pros and cons of using Availability Groups as well as the basics of how to set them up and take advantage of readable secondary replicas. If you want to improve the availability and performance of your applications databases, are currently using Database Mirroring, or if you’re just curious about Availability Groups, then you won’t want to miss this session.


  • Adam Belebczuk

Track and Room: DBA 2 - N/A

Title: Change Data Capture Change Tracking Deep Dive

Abstract: Change Data Capture (CDC) and Change Tracking (CT) have been standard features in SQL Server for a few years now but there’s not really that much useful information out in the blogosphere about how they work under the hood. Kevin Hazzard will dig deep into the implementations of CDC and CT in SQL Server 2012, showing you all of the parameters you can use to make these great features serve your organization well. This will be a highly-interactive, highly-entertaining session with lots of questions answered and mysteries revealed.


  • Kevin Hazzard

Track and Room: BI 2 - N/A

Title: Merge Dimensions Ahead

Abstract: Using SSIS to load data warehouse dimensions is a common task. There are several methods available, but the best method is the one that performs well and is easy to maintain. More importantly, you should be able to automate the development of this common package.

In this session, Sam will provide:

An overview of slowly changing dimensions, Comparison between different patterns that can be used including T-SQL merge, Solutions for the common errors with merge statement, and Scripts and framework to automatically generate merge statements and SSIS packages you can readily use for loading dimensions


  • Samuel Vanga

Track and Room: BI 1 - N/A

Title: Indexing Deep Dive

Abstract: Another in TheSQLGuru’s very popular “Deep Dive” series, this time covering indexing. You will learn about the internal structures of heaps, clustered indexes and nonclustered indexes. We will examine included columns and covering indexes, filtered indexes, indexed views, indexing DMVs and finding the right indexes. There are some incredibly helpful graphics as well as some nice samples to help you transition theory to practice.


  • Kevin Boles

Track and Room: Dev - N/A

Title: ETL not ELT! Common mistakes and misconceptions about SSIS

Abstract: Explore some of the mistakes and misconceptions DBAs tend to have about SSIS. Also look at the performance and scalability of ETL vs ELT with real world examples and sample code.


  • Paul Rizza

Track and Room: BI 2 - N/A

Title: SQL 2012 Extended Events

Abstract: Extended Events were introduced in SQL Server 2008. With SQL 2012, we have seen a significant upgrade to this feature. Join me for a little adventure into what extended events are. We will discuss how to use extended events to aid in performance tuning and in day to day administration. We will also explore some background and the architecture of extended events.


  • Jason Brimhall

Track and Room: DBA 2 - N/A

Title: Tune Queries By Fixing Bad Parameter Sniffing

Abstract: Parameter sniffing is a misunderstood issue on SQL Server. Most of the time, parameter sniffing is helping performance on your servers. But sometimes, circumstances change, and what was helping you is now hurting you – bad. In this session, we’ll gain an understanding of what exactly parameter sniffing is and why it’s usually so helpful. Then we’ll explore how parameter sniffing can go wrong and look at seven different ways you can deal with it when it does. You’ll take away a wealth of knowledge that will help you identify and resolve bad parameter sniffing in your own environment.


  • Grant Fritchey

Track and Room: Dev - N/A

Title: Data Career Paths and Decision Making Strategies

Abstract: In recent years Data Careers have expanded beyond the conventional role of a DBA. This is due to the ever expanding amount of data, a larger variety of tools and the need for business to use data to drive their own performance goals. This session will provide an overview of Data Careers, a discussion of personal traits and life stages that may align with different Data Careers. The new Career areas such as Data Science, Analytics and Data Journalism will be reviewed. In addition, the attendees will be provided with a template that will enable them to make more strategic career-related decisions.


  • Melissa Demsak

Track and Room: Prof. Dev - N/A

Title: Making Predictions with Microsoft Data Mining Tools

Abstract: Whether predicting customers or All Stars, the process and the tools remain the same. Microsoft’s Analysis Services Data Mining tools enable you to quickly profile your data, identify hidden relationships and predict future outcomes based on those relationships. Join me to see what data mining is, what data mining is not and how Microsoft’s data mining tools can help you analyze your business. During this session, I will walk us through a start-to-finish data mining prediction project. It’s easier than you might have thought.


  • Mark Hudson

Track and Room: BI 1 - N/A

Title: Judge, Jury, and Executioner–A First Look At Execution Plans

Abstract: When a query is run against a database, a plan is formed to do the work. This session will serve as an introduction on how to read and interpret execution plans. We will also take a look at the execution plan that won the ‘Hairy’ Execution Plan contest on SQLCruise Miami in 2013! Take a peek at http://sqlcruise.com/winner-of-the-2013-caribbean-landlubber-sql-sentry-hairy-execution-plan/


  • Carlos L Chacon

Track and Room: Dev - 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.

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.

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.

Robert Pearl

Twitter: - @PearlKnows

LinkedIn: Robert Pearl

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

Robert Pearl is a 5-year SQL Server MVP and creator of the award-winning database and monitoring alert system, SQLCentric. Author of the HealthySQL - Comprehensive Guide to Healthy SQL Server Performance. He’s the founder of Pearl Knowledge Solutions. As a SQL Server community evangelist, he covers local SQL Server events in the New York City area and maintains the Pearl Knows blog. Voted TOP BLOGGER in 2011.

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

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

Andrew Kelly

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

Andrew J. Kelly is a SQL Server MVP with over 20 years’ experience with relational databases and application development but specializes in Performance, Scalability and Maintainability of large scale SQL Servers. He is a regular speaker each year and a contributing editor and writer for SQL Server Magazine.

Brian Kelley

Twitter: - kbriankelley

LinkedIn: Brian Kelley

Contact: https://truthsolutions.wordpress.com/

Brian Kelley is an author, columnist, Certified Information Systems Auditor (CISA), accredited CISA trainer, and former Microsoft Data Platform (SQL Server) MVP (2009-2016) focusing primarily on SQL Server and Windows security. Brian currently serves as a data architect as well as an independent infrastructure/security architect concentrating on Active Directory, SQL Server, and Windows Server. He has served in a myriad of other positions including senior database administrator, data warehouse architect, web developer, incident response team lead, and project manager. Brian has spoken at 24 Hours of PASS, the Marathon of PASS, IT/Dev Connections, SQLConnections, the SSWUG Virtual Conferences, the Techno Security and Forensics Investigation

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

Allan Hirt

Twitter: - SQLHA

LinkedIn: Allan Hirt

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

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

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 Brimhall

Twitter: - sqlrnnr

LinkedIn: Jason Brimhall

Contact: http://jasonbrimhall.info

Jason Brimhall has more than 20 years of experience and has worked with SQL Server 6.5 through SQL Server 2019. He has experience in performance tuning, high transaction environments, and large environments. He is currently a consultant specializing in performance tuning, server analysis, and problem resolution. Jason is a Microsoft Certified Master (MCM) and a Data Platform MVP.

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.

David Dye

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

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.

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

Melissa Demsak

LinkedIn: Melissa Demsak

Melissa Demsak is passionate about Data, Business and People. She’s currently a Manager of SQL Architecture at large real estate holding company. Melissa was the leader of the NJSQL User Group ‘06-‘12, PASS Summit Program Committee ’07-’10 and a PASS Regional Mentor. She’s currently on the Program Committee for the PASS BA Conference in April and leads the PASS Business Analytics Virtual Chapter.

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.

Jessica Moss

Twitter: - @jessicammoss

Contact: http://www.jessicammoss.com

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

Samuel Vanga

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

LinkedIn: Samuel Vanga

Contact: http://SamuelVanga.com

Sam Vanga helps business people solve their data problems and enables them make data-driven-decisions. His specialties include data integration, data warehouse and database development, and BI design. Sam blogs at http://SamuelVanga.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.

Steve Jones

Twitter: - way0utwest

LinkedIn: Steve Jones

Contact: http://www.voiceofthedba.com/

Steve Jones is a Microsoft SQL Server MVP and has been working with SQL Server since version 4.2 on OS/2. After working as a DBA and developer for a variety of companies, Steve co-founded the community website SQLServerCentral.com in 2001. Since 2004, Steve has been the full-time editor of the site, ensuring it continues to be a great resource for SQL Server professionals. Over the last decade, Steve has written hundreds of articles about SQL Server for SQLServerCentral.com, SQL Server Standard magazine, SQL Server Magazine, and Database Journal.

Kevin Hazzard

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

LinkedIn: Kevin Hazzard

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

Kevin Hazzard is a Partner at Linchpin People LLC, leaders in the data integration and database wellness space. He was a long-time Microsoft MVP and the author of a book entitled Metaprogramming in .NET. Kevin also serves as an elected member of his local School Board and dedicates most of his non-professional time promoting public education.

Grant Fritchey

Twitter: - @gfritchey

LinkedIn: Grant Fritchey

Contact: http://scarydba.com

Grant Fritchey is a Data Platform MVP with over 20 years’ experience in IT, including time spent in support and development. He has worked with SQL Server since 6.0 back in 1995. He has also developed in VB, VB.NET, C#, and Java. Grant has written books for Apress and Simple-Talk. Grant presents at conferences and user groups, large and small, all over the world. He joined Redgate Software as a product evangelist in January 2011.

Timothy McAliley

Twitter: - sysframeworks

LinkedIn: Timothy McAliley

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

Adam Belebczuk

Twitter: - @SQLDiablo

LinkedIn: Adam Belebczuk

Contact: http://www.sqldiablo.com/

Adam Belebczuk is the Owner amp; Principal Consultant at Belebczuk Consulting Services, LLC and has more than 10 years of experience in IT, ranging from customer service to server/network administration to software and database development and administration. Adam is the Chapter Leader for the Ohio North SQL Server Users Group, a frequent speaker and volunteer at PASS events, and specializes in SQL Server development, performance tuning, high availability, and disaster recovery.

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

Ayman El-Ghazali

Twitter: - thesqlpro

LinkedIn: Ayman El-Ghazali

Contact: http://www.thesqlpro.com

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


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

Back to the SQLSaturday Event List

Back to the home page