SQLSaturday #315 - Pittsburgh 2014
Event Date: 10/04/2014 00:00:00
Event Location:
- Pittsburgh Technical Institute
- 1111 McKee Road
- Oakdale, Pennsylvania
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).
Sessions
This is a list of sessions from the event, based on the schedule in the XML files.
Title: SQL Server 2012/2014 Columnstore index
Abstract: It might seem far-feched that a company would upgrade to SQL Server 2012/2014 “just” for a database index. But after you see the performance enhancements gained from the new columnstore index in SQL Server 2012/2014, 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/2014, 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/2014, 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. Finally, I’ll cover some of the 2014 specific enhancements to the columnstore index.
Speaker(s):
- Kevin Goff
Track and Room: Room 507 - N/A
Title: The Tally Table and Pseudo-Cursors - High Performance Replacements for Loops
Abstract: Don’t let the “Intermediate” rating scare you “Beginners” away. This “Black Arts” session is for anyone that uses T-SQL. There are dozens of things we do in SQL that require some type of iteration. “Iteration” means “counters” and “loops” to most people and recursion to others. To those well versed in the techniques of “Set-based” programming, it means some form of a “Numbers” or “Tally” Table, instead. This session takes the mystery out of how these wonderfully compact tools works and they easily replaces many types of loops. This session has been updated to include additional information about what “Pseudo-Cursors” are and how they work as well discovering why “Recursive CTE’s” can be your worst enemy. If you’ve never heard of a Tally or Numbers Table before, this session will change your life for the better in the competitive world of SQL Server.
Speaker(s):
- Jeff Moden
Track and Room: Room 501 - N/A
Title: Hierarchies on Steroids… the No RBAR Way
Abstract: Hierarchical data sets are everywhere. If you haven’t worked with one yet, you will. If you’re already working with them, you know they can be horribly complex, slow performing, difficult to maintain resource hogs that can really take the steam out of any GUI or batch process. This simple but code intensive “black arts” session shows you how to quickly and easily get around all of that using all 3 common hierarchical structures and includes a very high performance method (100,000 nodes in less than 4 seconds and 1 Million nodes in less than a minute) for converting Adjacency Lists to Nested Sets that even a beginner can understand. As a finale`, we’ll cover a new “pre-aggregated” Hierarchical table structure that answers most of the questions you’d ask of a Hierarchy. You just have to know that a Tally Table is involved somewhere in this. ;-)
Speaker(s):
- Jeff Moden
Track and Room: Room 508 - N/A
Title: Permission Management: 12 Pitfalls Misconceptions
Abstract: SQL Server comes with a powerful built-in permission management system. However, as most powerful tools, this one too can be difficult to use and get right. This is a two-part session. During the first part, we will go through a review of SQL Server security terms and concepts, particularly the GRANT, REVOKE and DENY statements. For the second part, the audience selects topics that we will cover in detail. You will be able to choose from 12 different security pitfalls and misconceptions. All these pitfalls/misconceptions have one thing in common: If you are not aware of them, you might GRANT or DENY more permissions than you intended.
Speaker(s):
- Sebastian Meine
Track and Room: Room 508 - N/A
Title: Inside of Indexes
Abstract: We will navigate through the internal differences between Clustered and non-Clustered indexes. Will take a look how indexes are built, what page splits are and how SQL Server uses indexes to retrieve a data. In that session we will use DBCC IND and DBCC PAGE and dig into pages’ binary code. That is Intermediate session for everybody who already knows about indexes, but doesn’t really know how they work.
Speaker(s):
- Slava Murygin
Track and Room: Room 512 - N/A
Title: Extending SQL Server with Advanced Analytics and R
Abstract: The Microsoft SQL Server stack provides an excellent set of tools for storing, visualizing, and analyzing data, but sometimes we want to do more. In this session, we’ll take a look at the open-source statistical software R and how we can use it to connect to SQL Server, analyze data, and put the results of our analysis back into SQL Server for later use. We’ll look at examples of analyses performed by a fictional company as they segment their customers, forecast their sales, and examine interesting relationships among their product offerings. Along the way, we’ll see what some of these analyses would take if done in SQL Server itself and why R is so effective when paired with SQL Server.
Speaker(s):
- Michael Schulte
Track and Room: Room 507 - N/A
Title: Introduction to Windows Azure HDInsight
Abstract: This session will provide a general introduction to HDInsight; Microsoft’s new online Hadoop service that enables you to harness the power of Big Data analytics and machine learning. You will learn how to provision and manage an HDInsight cluster using the Windows Azure Management Portal and PowerShell. The discussion will include the roles played by open source projects such as Pig, Hive, Mahout and HCatalog.
Speaker(s):
- Jon Tupitza
Track and Room: Room 508 - N/A
Title: 101 Stupid Things Your Colleagues Do When Setting Up A SQL Server
Abstract: There are some things that you just wish your colleagues had known before they set up and installed SQL Server. A successful installation of SQL Server requires more than someone accepting all the default options or clicking Next a bunch of times; proper choices need to be made. In this session you’ll learn from the mistakes of others as well as best-practice configurations across the entire infrastructure stack (Physical server, storage, virtualization, OS, and SQL Server layers) in order to ensure stable performance. This session is for the accidental DBA or anyone who needs to install SQL Server occasionally (or for their colleagues who need to mop up afterwards).
Speaker(s):
- Matt Slocum
Track and Room: Room 512 - N/A
Title: Database code is application code, so test it!
Abstract: Database code is application code, and deserves to be treated as such. There, I’ve said it, now it’s time to start living it. A longtime staple in application development is unit testing, but this practice has made little headway in SQL Server development. Some better tools will hopefully help change that. In this session we’ll cover some of the basics of unit tests, write a simple unit testing procedure which can be used in nearly any SQL-compliant database, and learn about tSQLt, an open-source unit testing framework for SQL Server.
Speaker(s):
- Rich Dudley
Track and Room: Room 508 - N/A
Title: Basics of SQL querying
Abstract: We will query the database that we just designed covering basic selects, joins, functions, aggregates etc.
Speaker(s):
- Brandi Dollar
Track and Room: Wanna Be A DBA? - N/A
Title: Getting Started with Hekaton (In-Memory OLTP)
Abstract: So you’ve heard of Hekaton (In-Memory OLTP) but you aren’t sure where to start or if it’s for you or not. Maybe you’ve heard or read some information and not sure what’s true or not. There’s a number of misconceptions out there about Hekaton. By the end of this session you’ll have a better understanding of what Hekaton is and how it may be able to help you. We’ll discuss the basics of Hekaton and more as well as walking through some demos to show you how to use Hekaton and what it can do as well as help you get started diving into Hekaton on your own.
Speaker(s):
- Brian Davis
Track and Room: Room 501 - N/A
Title: DBA Monitoring and Maintenance Fundamentals
Abstract: The key to becoming a great DBA is time. The best way to regain some time is by spending less time doing the daily mundane work. Let this mundane effort work autonomously. We will introduce the basics in monitoring and maintenance. The how and why certain things should be done at a minimum and what things can be done to help improve the quality of life in larger dynamic environments.
Speaker(s):
- Warren Sifre
Track and Room: Room 508 - N/A
Title: Transaction Log Internals: Virtual Log Files
Abstract: Experienced DBAs know that SQL Server stores data in data files and transaction log files. What is less commonly known is that the transaction log file is broken up into smaller segments known as Virtual Log Files, or VLFs.
Having too many VLFs will cause performance to suffer. And having too few will cause backup performance to suffer. How do you strike the right balance?
In this more advanced session, veteran DBA Mike Hillwig will show you what VLFs are, how they’re created, how to identify them, and how to strike the right balance between too few and too many.
Speaker(s):
- Mike Hillwig
Track and Room: Room 506 - N/A
Title: Using Non-Traditional Data Stores in Your Applications
Abstract: The general thinking is that when you create a new application, your data will be persisted into an RDBMS like SQL Server. But with the advent of solutions like document databases, key-value stores and other options, there are some alternatives available for your applications. In this session we’ll look at some alternatives to your persistence solution by looking at utilizing document databases like Mongo, search services like Solr, key-value stores and other approaches to data persistence. By the end of this session, you’ll rethink how your applications will store data in the future.
Speaker(s):
- David Hoerster
Track and Room: Room 501 - N/A
Title: SQL Server XML 101
Abstract: XML processing become more and more a part of our daily life. Today anyone, DBA or Developer, interferes one way or another with XML-based processes. In the SQL Server XML 101 session I’ll go over XML data type from “ground zero” to advanced tricks and tips. Using real life examples I’ll show most efficient ways to work with an XML of any complexity and size. I’ll cover the problems that you can anticipate to deal with with XML. How to: load the files using T-SQL code, dynamically retrieve and element or attribute, use different XML data types’ methods and functions.
Speaker(s):
- Alex Grinberg
Track and Room: Room 512 - N/A
Title: Understanding Transaction Isolation Levels
Abstract: SQL Server offers several isolation levels beyond the default “READ COMMITTED”. But understanding when to use each one can be daunting. Whether you are a developer who needs to understand how isolation works and and why NOLOCK is not an appropriate hint in most cases, or a seasoned DBA who needs to understand the less commonly used isolation methods, this session is for you. We will look at each level, how it impacts the engine, and examine appropriate (and inapproriate) use cases for each.
Speaker(s):
- Randy Knight
Track and Room: Room 506 - N/A
Title: Floating on a Hybrid Cloud: SQL Server 2014 Windows Azure
Abstract: In this session we will discuss and demonstrate the cloud integration capabilities of SQL Server 2014, the Windows Azure Platform, and scenarios for leveraging hybrid cloud infrastructure. We will discuss and demonstrate deploying SQL Server 2014 running on a Windows Azure Virtual Machine and also discuss and demonstrate the Windows Azure SQL Database. We will also discuss best practices and demonstrate techniques for managing both on-premises and cloud-based resources.
Speaker(s):
- Timothy McAliley
Track and Room: Room 501 - N/A
Title: Recovery and Backup for Beginners
Abstract: We all know that backups are important. But are we building a backup strategy that can recover in a manner that meets business needs? All too often, we plan a backup strategy without a recovery strategy.
In this session, veteran DBA Mike Hillwig will start with understanding the recovery strategy and work toward implementing the right backups to meet that recovery strategy. He’ll also set the record straight around some very common myths around database recovery and backups.
Speaker(s):
- Mike Hillwig
Track and Room: Room 506 - N/A
Title: Optimizing Protected Indexes
Abstract: As a SQL Server DBA I see my role having 2 main focuses. First is to protect the data and second is to ensure performance is maximized. More often than not companies forget about data security when they focus on performance tuning. In this presentation I will mention a few cases where encryption could have saved a lot of hassle. I will then demo a method that can be used to “index” commonly searched on encrypted values (ex: SSNs, Credit Card, etc) helping reduce the impact on the performance of a query.
Speaker(s):
- Chris Bell
Track and Room: Room 512 - N/A
Title: Surviving a Technical SQL Interview
Abstract: At some point every SQL interview is going to get technical. This session will go through my favorite questions as an interviewer and talk about their overall relevance and answers. We’ll talk about how to handle the situations where you aren’t sure of the answer - or when you know that you don’t know the answer The questions will cover database design, DBA, SSIS and SSRS aspects of SQL server. Pointers to resources will also be given.
Speaker(s):
- Reed Powell
Track and Room: Room 506 - N/A
Title: “I Know What You Did Last Query” –SQL Server
Abstract: Starting with the 2005 release, SQL Server captures information about the workload on an instance, which you can use to monitor the system, gather performance metrics, and validate system settings. This information is available via Dynamic Management View and functions and officially they “return internal, implementation-specific state data.” This session gives an introduction to these concepts, how they make DBA life much sweeter and we discuss many of the different community queries available to help you get jump started in your environment. We also open up the floor for ideas of how you are using these views/functions.
Speaker(s):
- Carlos L Chacon
Track and Room: Room 508 - N/A
Title: Manage SQLServer Efficiently w/PowerShell Remoting
Abstract: You have more and more servers to manage and less time to accomplish everything. You’re writing scripts to automate those tasks but they still take time to run. PowerShell remoting allows you to manage servers without the overhead of Remote Desktop, and allows you to run processes on all your servers simultaneously. In this session we’ll walk through how PowerShell remoting works, how to set it up, and how you can save time getting things done more quickly.
Speaker(s):
- Allen White
Track and Room: Room 501 - N/A
Title: Resources, careers, and training
Abstract: What are the resources required to become a DBA -Training, certifications, self study, shadowing, mentoring. How to transition from knowledge to practice and learning on the job. The job market for a DBA- trends, salaries, shortage etc.
Speaker(s):
- Madhu Kudaravalli
Track and Room: Wanna Be A DBA? - N/A
Title: Basics of Administrating SQL Server
Abstract: The session will cover basic database administration tasks - backups, recovery, user permissions, security, performance
Speaker(s):
- Jeremy Christy
Track and Room: Wanna Be A DBA? - N/A
Title: Common Coding Mistakes and how to Mitigate them
Abstract: There are several programming design patterns that work great in object orientated code that doesn’t scale well inside of SQL Server. In this session we will focus some of these patterns and show you how to make them scale in the database engine. We will touch on Scalar-Value functions, Union, CTE, RBAR and more.
Speaker(s):
- William Wolf
Track and Room: Room 512 - N/A
Title: The Quest for the Golden Record: MDM Best Practices
Abstract: In this session, we will focus on how to formulate a Master Data Management (MDM) strategy and build a solution to find the single version of the truth, aka the Golden Record. While these techniques can apply to any domain, we will demonstrate building a sample customer domain in this session, showing how to leverage SQL Server Master Data Services(MDS) and other tools for data quality, matching, and de-duplication across multiple data sources.
Speaker(s):
- Pam Matthews
Track and Room: Room 507 - N/A
Title: Fixing Page Life Expectancy
Abstract: Starting with what Page Life Expectancy really means to query, server, and disk performance, we’ll get a firm understanding of what this counter means to you. After that we can start talking about if and how you want to raise it. It’s important to know that this is just a counter and there are situations where you don’t care about it nearly as much as you’d expect. It’s also important to know what effect a drop in PLE mid-day really means beyond query performance, including a possible impact on other, unrelated servers.
Speaker(s):
- Steve Hood
Track and Room: Room 506 - 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.
Speaker(s):
- Paul Rizza
Track and Room: Room 507 - N/A
Title: Locks, Blocks, and Deadlocks Oh My!
Abstract: Managing concurrency is one of the most challenging aspects of working with any enterprise DBMS. There is much confusion out there about locking, blocking, and deadlocks. In this demo heavy session we will clear up the confusion.
Speaker(s):
- Randy Knight
Track and Room: Room 506 - N/A
Title: Reporting Services 101
Abstract: Reporting Services- Creating a sample report in SSRS
Speaker(s):
- Katie Vetter
Track and Room: Wanna Be A DBA? - N/A
Title: DBA Prerequisites
Abstract: This session will cover the prerequisites for becoming a database professional. It will cover the various areas that a database professional can choose from- SQL Server developer, SQL Server Administrator, SQL report writer, ETL developer, Business Intelligence .
Speaker(s):
- Madhu Kudaravalli
Track and Room: Wanna Be A DBA? - N/A
Title: Implementing Data Warehouse Patterns with the Microsoft BI Tools
Abstract: You’ve read some of the content of well-known Data Warehousing books – now what? How do you take the structures and disciplines inside such books as the Ralph Kimball series and implement them? This session will take several of the key concepts in Data Warehousing and demonstrate some implementations using SQL Server Integration Services and Analysis Services. We’ll look at items such as Type 2 Changing Dimensions, Confirmed Dimensions, Dimension Outriggers, Role-Playing Relationships, Many-to-Many Bridge table relationships, Factless Fact tables, Handling of NULL foreign key values, and more.
Speaker(s):
- Kevin Goff
Track and Room: Room 507 - N/A
Title: Relational Database Design 101
Abstract: We will cover the fundamentals of an RDBMS and go over a basic database design session.
Speaker(s):
- Madhu Kudaravalli
Track and Room: Wanna Be A DBA? - N/A
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Randy Knight
Twitter: - randy_knight
LinkedIn: Randy Knight
Contact: http://www.sqlsolutionsgroup.com/blog
Randy Knight is a data professional who has worked with Microsoft technology for over 25 years, focusing on SQL Server since 1997. He has worked in a variety of settings, including 6 years as a database architect for match.com. In 2010, he founded SQL Server Solutions Group LLC, a boutique SQL Server consultancy. A Microsoft Certified Master (MCM) in SQL Server, he speaks often at events all over the country including the PASS Summit, SQLIntersections, and numerous SQLSaturday and User Groups.
Mike Hillwig
Twitter: - @mikehillwig
LinkedIn: Mike Hillwig
Contact: http://www.mikehillwig.com
Veteran DBA Mike Hillwig is a native Pittsburgher and resident of the Boston Suburbs. He’s a DBA Manager for a financial software company that’s owned by one of the world’s largest bank. Mike has been working with SQL Server since version 7 and has a background in infrastructure and network. Today, he manages a team of DBAs around the globe.
Chris Bell
Twitter: - @cbelldba
LinkedIn: Chris Bell
Contact: https://www.wateroxconsulting.com/
Chris Bell offers a unique view of how we live and work with data, both now and as we head into the future. Having braved many roles, lifecycles, and battles in the IT world, he has honed his DBA (Database Administration or Do ‘Bout Anything) skills in Information Systems and development, focusing on SQL Server. Currently, he serves as the lead DBA at The Motley Fool. You can keep up with Chris’ thoughts and technical community activities at WaterOxConsulting.com.
Randy Knight
Twitter: - randy_knight
LinkedIn: Randy Knight
Contact: http://www.sqlsolutionsgroup.com/blog
Randy Knight is a data professional who has worked with Microsoft technology for over 25 years, focusing on SQL Server since 1997. He has worked in a variety of settings, including 6 years as a database architect for match.com. In 2010, he founded SQL Server Solutions Group LLC, a boutique SQL Server consultancy. A Microsoft Certified Master (MCM) in SQL Server, he speaks often at events all over the country including the PASS Summit, SQLIntersections, and numerous SQLSaturday and User Groups.
Mike Hillwig
Twitter: - @mikehillwig
LinkedIn: Mike Hillwig
Contact: http://www.mikehillwig.com
Veteran DBA Mike Hillwig is a native Pittsburgher and resident of the Boston Suburbs. He’s a DBA Manager for a financial software company that’s owned by one of the world’s largest bank. Mike has been working with SQL Server since version 7 and has a background in infrastructure and network. Today, he manages a team of DBAs around the globe.
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.
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.
Katie Vetter
LinkedIn: Katie Vetter
Business Intelligence Developer / SQL Server DBA with a background in software development. Speaker at Pittsburgh SQLSaturday 2013 amp; 2014.
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.
David Hoerster
Twitter: - @DavidHoerster
LinkedIn: David Hoerster
Contact: http://blog.agileways.com
David Hoerster, a 5-time C# MVP, is a recovering corporate financial analyst and has been working with the Microsoft.NET Framework since the early 1.0 betas. David is the leader of the Pittsburgh Reactive Systems user group (http://meetup.com/reactive), the former president of the Pittsburgh .NET User’s Group (PGHDOTNET), and original organizer of Pittsburgh TechFest (www.pghtechfest.com), and is also a regular speaker at Pittsburgh and regional user group and community conference events. David can be found rarely blogging at http://blog.agileways.com and tweets occasionally at @DavidHoerster.
Jeremy Christy
.
Pam Matthews
Contact: http://www.profisee.com
Pam Matthews is Director of Customer Solutions with Profisee. Profisee is the successor to the company Stratature that built the SQL Server Master Data Services (MDS) product which Microsoft acquired in 2007. Profisee focuses on Master Data Management (MDM) solutions. Pam has spent the last 10 years providing training, support and implementation assistance to customers implementing master data management projects utilizing MDS.
Matt Slocum
Twitter: - SQLMatt
LinkedIn: Matt Slocum
Contact: http://www.sqlmatt.com
Husband, Father, and certifiable…I mean certified MCSE: SQL Data Platform. I manage lots of DBs on SQL 7-2017. I specialize in database hardware, SQL replication, and performance troubleshooting.
I also love space, technology Japanese culture.
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.
Madhu Kudaravalli
Michael Schulte
Mike Schulte is a decision support analyst at Gateway Health Plan. He works with tools such as SQL, Tableau, R, SAS, Azure Machine Learning, and Spark to use data to support decisions. These days he is trying to change the world by supporting value-based healthcare initiatives, whereby healthcare costs are lowered while quality of care is improved! In his spare time, he teaches economics and philosophy courses, plays chess and directs chess tournaments, and rings bells in church bell towers.
Sebastian Meine
Twitter: - @sqlity
LinkedIn: Sebastian Meine
Contact: http://sqlity.net/en/blog/
Sebastian Meine, Ph.D. is the SQL Stylist behind sqlity.net llc. In 2010 he founded sqlity.net to fully engage in his passion for SQL Server. Armed with a Ph.D. in Computer Science and years of experience in architecting DBs for a global Fortune 50 company, Sebastian now provides training and consulting services for his clients, specializing in SQL Server Security, Test Driven Development and Performance. Sebastian is an experienced public speaker, published author, president of the Philly PASS Chapter, PASS Regional Mentor and coauthor lead developer of tSQLt.
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.
Brandi Dollar
.Brandi Dollar is a Database Administrator at Remote DBA Experts (RDX). She works with over 200 customers on general database administration needs including recoverability, high availability, and performance tuning. You can read her blog posts at http://www.rdx.com/Blog/
Madhu Kudaravalli
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
Reed Powell
LinkedIn: Reed Powell
Reed is a database application developer and DBA with 40+ years experience in the IT industry. He has been working with Microsoft SQL Server since being certified on version 6.5, and is also the manager of the Pittsburgh Adobe ColdFusion User Group. He is a speaker on topics related to technology and genealogy.
Jeff Moden
With more than 51,000 posts and 39 mostly 5 star articles, Jeff Moden is a strong contributor on SQLServerCentral.com where he coined the term “RBAR” (Row By Agonizing Row) and helped make the “Tally Table” a household name. Jeff has more than 2 decades of experience with SQL Server and is mostly self-trained in what he calls the “Black Arts” of T-SQL. He’s known worldwide for his informative articles, high performance T-SQL coding methods, and methods of mentoring. His dedication to helping others earned him the MS SQL Server MVP award for nine years and the RedGate Exceptional DBA Award in 2011. His mantra is “Performance is in the code”.
Alex Grinberg
LinkedIn: Alex Grinberg
I have more than 20 years of IT experience. My primary focus is with the latest Microsoft technologies including .NET (VB and C#), SSRS and SSIS. I provide services in tuning, optimization, analysis and development for the creation of new applications, converting legacy technologies (SQL Server, VB.NET and C# ) and site training. I have worked for CSC, VerticalNet, IDP, LSAC , and TMNAS (to name a few) and I am currently employed with Cox Automotive. I am Apress author book “XML and JSON Recipes for SQL Server”, also wrote number of articles for Simple-Talk and SQLServerCentral.com
Rich Dudley
Contact: http://rjdudley.com/
I’m a Senior Software Engineer for Quicken Loans, serving as the technical lead of the client master data management hub. I’ve been using MS technologies to build data driven and e-commerce websites since 2001, and I’ve also worked in manufacturing and logistics. I have an MS in molecular biology, and my previous life included surviving cholera and purifying radioactive neurotoxins. I’m the co-organizer of the PGH.NET User Group, an ASP Insider, a Pluralsight author and a Friend of RedGate.
Brian Davis
Twitter: - @Brian78
LinkedIn: Brian Davis
Contact: http://blogs.sqlsentry.com
Brian Davis is a Product Integration Engineer at SentryOne and has over 15 years in the IT field in multiple areas including software development, support, user training, and as a DBA. He has been working with SQL Server since 2003 and has hands-on experience with SQL Server 2000 through 2016. Brian is also a PASS Regional Mentor and an active member and leader of the Ohio North SQL Server User Group.
Steve Hood
Twitter: - @SteveHoodSQL
LinkedIn: Steve Hood
Contact: http://simplesqlserver.com
I#39;m a DBA who has gone through most of my career with few people to learn and unsure of where to find great help until I found a real mentor. When I started at a company with a great, knowledgeable manager and learned to find others speaking about SQL Server online my skills boomed. This is especially true in my most passionate area, SQL Server performance.
Knowing that my knowledge came from others, I now have a second passion of sharing my knowledge with others.
Jeff Moden
With more than 51,000 posts and 39 mostly 5 star articles, Jeff Moden is a strong contributor on SQLServerCentral.com where he coined the term “RBAR” (Row By Agonizing Row) and helped make the “Tally Table” a household name. Jeff has more than 2 decades of experience with SQL Server and is mostly self-trained in what he calls the “Black Arts” of T-SQL. He’s known worldwide for his informative articles, high performance T-SQL coding methods, and methods of mentoring. His dedication to helping others earned him the MS SQL Server MVP award for nine years and the RedGate Exceptional DBA Award in 2011. His mantra is “Performance is in the code”.
Jon Tupitza
Twitter: - JTupitza
LinkedIn: Jon Tupitza
Contact: http://www.jon-tupitza.com
Jon Tupitza has two decades of experience in providing data platform, business intelligence and data science solutions to Public Sector customers. Tupitza served as a Senior Business Intelligence SQL Server consultant for Microsoft’s U.S. Public-Sector Consulting Services where he supported clients including Civilian, DoD and Intelligence Community agencies. His other prior experience includes serving as a Managing Consultant at SolidQ, a global provider of BI, analytics and data management consulting services, and as a Principal Solution Developer at Avanade, a global Microsoft-focused IT consulting services company
Warren Sifre
Twitter: - WAS_SQL
LinkedIn: Warren Sifre
Contact: http://www.broadstrokeconsulting.com/blog/, http://www.allegient.com
Warren Sifre has been in the IT community since 1998 and has worked in a variety of industries deploying solutions utilizing MS SQL Server in one capacity or another. In 2003, he decided to make SQL Server his mastery and has since developed skills in most defined disciplines of MS SQL. Currently he is a Principal Consultant and Technology Leader with Moser Consulting. He is responsible for BI Solution Architecture and the mentorship of team members. He has been a SQLSaturday Speaker since 2012, Azure Global Bootcamp, and many user groups in 2015 alone. He has a passion for knowledge transfer and solutions architecture, with a keen interested in Info Security.
Madhu Kudaravalli
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
William Wolf
Twitter: - sqlwarewolf
LinkedIn: William Wolf
Contact: http://www.sqlwarewolf.com
Bill is the Manager of SQL Server Performance Tuning for RDX. He works with over 400 customers on solutions within the SQL Server environment and specialized in code tuning and mentoring the team within RDX. He has become a SQLSaturday veteran speaking at nearly 40 SQLSaturdays in the last 3 years. He has also spoken at Summit and is an Idera Ace class of 2018. Bill is active in the Pittsburgh SQL Server User Group. He is also the chapter lead for the DevOps Virtual User Group. He is passionate about educating users on SQL Server and mentoring others.
Sponsors
The following is a list of sponsors that helped fund the event: