SQLSaturday #250 - Pittsburgh 2013
Event Date: 09/14/2013 00:00:00
Event Location:
- ITT Technical Institute
- 5460 Campbells Run Road
- Pittsburgh, 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: Analysis Services - Multidimensional vs. PowerPivot vs. Tabular/BISM
Abstract: Remember the days when Analysis Services solely represented an OLAP engine? Are you unclear about when to still build cubes vs. invoke the new Tabular engine in SSAS? Do you feel confused about where the self-service capabilities of PowerPivot end and where enterprise BI begins? If you answered YES to any of those questions, please join A.J. Mee (Principal BI Specialist at Microsoft) for some practical, real-world guidance around the three modes of SQL Server Analysis Services. As with most of A.J.’s presentations, the vast majority of the time will be spent providing demonstrations of the technology. Both traditional (i.e. relational) and non-traditional (i.e. unstructured/semi-structured) data sources may be incorporated into the demonstrations.
Speaker(s):
- A.J. Mee
Track and Room: Track 1 - N/A
Title: Do Some SOLR Searching with .NET
Abstract: You’ve designed your application, built it up, and it’s working great. One of the last features to implement is searching and reporting. You think you can get away with just implementing some SQL LIKE statements for an initial search, but you need to search across many fields or perform faceted searches. You’ve put it off because you really don’t want to deal with SQL Server Full-Text Indexing - maybe it’s not your cup of tea or maybe it’s just intimidating or maybe you’re not using SQL Server. But there are alternatives to Full-Text Indexing that can be just as powerful and fairly simple. SOLR is one such open source tool to help you with your application’s searching needs. We’ll take a look at the SOLR project, how you can get it up and running very easily, how you can install it as a Windows Service (as opposed to a command window), and how you can use SOLR.net to program against it. We’ll look at basic searches along with some cool features like faceting.
Speaker(s):
- David Hoerster
Track and Room: Track 2 - N/A
Title: Building Your First AlwaysOn Failover Cluster Instance
Abstract: Are you starting to plan for high availability and curious to see how clustering can keep your databases online and mitigate downtime during patching? Have you heard about clustering but have no idea what is required to build a successful cluster? If so, this session is for you. During this session we will compare the pros and cons of Failover Cluster Instances to ensure you implement the best solution to handle you’re HA requirements. We will build a windows cluster from scratch and go over all the requirements including failover cluster manager, nodes, shared storage, active directory, client access points, quorums and installing a SQL Server clustered instance. Finally, we will go over a basic framework to help you quickly perform a root cause analysis to determine why your SQL services went down.
Speaker(s):
- John Sterrett
Track and Room: Track 4 - N/A
Title: Table Partitioning: the Secret Weapon for your Big Data Problems.
Abstract: Is big data starting to slow you down? Is data growth putting your maintenance tasks in danger of not meeting your service level agreements? Do you wish you could archive old data with minimal impact to your tables during the archive process? Do you wish you could eliminate the majority of the data in your tables when you query them? If so, its time you consider implementing table partitioning to help with your general performance and to reduce your maintenance window for completing your maintenance tasks. In this session you will learn how table partitioning works and when it should be implemented. You will be able to understand how to initially configure partition functions and partition schemes to have a rock solid partitioned table. Finally, you will learn how to implement an automated sliding window to maintain your partitioned tables for ensuring optimal performance.
Speaker(s):
- John Sterrett
Track and Room: Track 5 - N/A
Title: Faster, Better Decisions with Self Service Business Analytics
Abstract: This session focuses on Microsoft’s BI technologies and its abilities to make advanced easy to use, accessible, insightful, and actionable, all while helping clients increase organizational performance. With the recent release of SQL 2012, Microsoft dramatically enhanced the Microsoft BI platform. During this session Plus Consulting, one of Microsoft’s top global BI partners, will explore the improvements to SQL 2012 self-service reporting and talk about creating blended value from your BI platform. We’ll show you why the combination of Microsoft Office 2013, SharePoint Server 2013 and SQL Server 2012 are an excellent solution for creating self-service dashboards, scorecards, KPIs, pivots, data exploration and discovery, collaborative.
Speaker(s):
- Sayed Saeed
Track and Room: Track 3 - N/A
Title: Handling catch all or sometimes queries
Abstract: We have all had requirements for a procedure based upon many parameters that may or may not contain a value. These are typically seen as the code behind a search screen. The end users need to do this regularly, and they can be real performance killers.
This session will provide a number of different ways to handle “sometimes” queries, and provide techniques to make these perform faster.
Michael John is a Senior DBA with almost 20 years experience working and solving problems for both Fortune 100 companies and smaller firms. As a frequent contributor to many of the community newsgroups, and expert at answering the 2:00 AM problem phone calls, Michael has seen nearly every issue as a DBA in his career.
Speaker(s):
- Michael John
Track and Room: Track 4 - N/A
Title: Agile Database Development
Abstract: In this talk Aaron will introduce users to some techniques and tools for developing and maintaining SQL code inside an Agile SDLC. Aaron will use test driven development techniques and commit his code changes to Team Foundation Services and schedule a build. He’ll also demonstrate some custom solutions and go over all of the different databases that a DBA might support in an on-premise TFS install.
Speaker(s):
- Aaron King
Track and Room: Track 2 - N/A
Title: Monitoring and Baselines
Abstract: During an incident you can look at every stat in SQL Server, but if you don’t know what normal is for that specific server then they won’t be very useful to you. Also, outside of incidents, it’s very beneficial to know what your most expensive queries are for the month instead of since the last recompile, or seeing when your page life expectancy drops instead of just noticing it’s low. Without proactively monitoring SQL Server you’re making your job more difficult and less productive at the same time.
This will cover OS Perf Counters, Wait Stats, Traces, Blocking, Query Stats, Index Stats, Database Sizes and Table Sizes, all presented in a format of what you should be watching and how it will help you.
Speaker(s):
- Steve Hood
Track and Room: Track 5 - N/A
Title: Goodbye Next Next Next, Hello Automated Installs
Abstract: Tired of clicking through all those setup screens and entering the same information over and over again? I know I am, so I’m doing something about it…I’m automating my installs! From base SQL Server installs to Service Packs, Cumulative Updates and even Client Tools for DBA’s and Developers, I’ll show you ways to automate your installs using SQL Server FineBuild (CodePlex Project). We’ll cover many of the scenarios you may encounter and you’ll walk away with some pre-built install scripts to help get you started.
Speaker(s):
- Brian Davis
Track and Room: Track 3 - 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.
Speaker(s):
- Tim Radney
Track and Room: Track 1 - N/A
Title: Fundamentals of reporting
Abstract: Although this session is part of the “Wanna be a DBA?” track, it also serves those who “Wanna be a Business Intelligence Developer.” We’ll discuss the life cycle of data, how it relates to reporting, and learn how to create a simple SSRS (SQL Server Reporting Services) report.
Speaker(s):
- Katie Vetter
Track and Room: Track 0 - Wanna be a DBA? - N/A
Title: SSIS Templates Can Make Your Life Easier
Abstract: How many times have you started a new SSIS project and added the same components that you’ve added to almost every other package you’ve created? Components to handle logging and errors or even a standard workflow for loading data files. In this session I’ll show you how you can create standard templates that already contain any and all of the common components you desire. We’ll also look at how to implement and use these templates so that the next time you create a SSIS package you can spend your time on the work you actually need to do instead of implementing common components over and over again.
Speaker(s):
- Brian Davis
Track and Room: Track 1 - N/A
Title: Fundamentals of querying
Abstract: We will query the database that we just designed covering basic selects, joins, functions, aggregates etc.
Speaker(s):
- William Wolf
Track and Room: Track 0 - Wanna be a DBA? - N/A
Title: Powershell for the beginner
Abstract: PowerShell is everywhere. This session will go over the basics and getting more comfortable using the PowerShell console, ISE, and running scripts. We will start from the very basics and get on track to have you wanting to use PowerShell all the time to see what else can be done. The session is not directed to just DBAs but any IT pro that wants to learn PowerShell.
Speaker(s):
- Ken McFerron
Track and Room: Track 4 - N/A
Title: DBA 911 - Database Corruption
Abstract: Database corruption is simply a fact of a DBA’s life - if you haven’t seen it yet, you will. Success or failure depends on having a solid plan to deal with different types of corruption. In this session, we will discuss usage of related DBCC commands, monitoring for corruption with SQL Agent Alerts and Jobs, and when to restore versus repair. After attending this session, you will be able to check for corruption, identify different types of corruption, and take the appropriate measures for dealing with it.
Speaker(s):
- David Maxwell
Track and Room: Track 5 - N/A
Title: Basic Best Practices for SSIS Development
Abstract: This session will cover several basic best practices that can be used when developing SSIS packages, including logging, checkpoints, and package configurations. These best practices will provide re-usability, assist with troubleshooting, and dramatically improve your ETL work.
Speaker(s):
- Nate Locklin
Track and Room: Track 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.
Speaker(s):
- Tim Radney
Track and Room: Track 5 - N/A
Title: Becoming a 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: Track 0 - Wanna be a DBA? - N/A
Title: Methods of Implementing Performance Tools for SQL Server
Abstract: Monitoring Tools are not just nice to have but a means of understanding what is going on “Under the Hood”.Success is a result of proper planning ,setting up the necessary processes to maintain continuity and most importantly participation is a key ingredient in achieving any level of success.Let’s take a look at the 3 P process that I have employed over the past 15 years of implimenting Monitoring Tools in the IT industry.
Speaker(s):
- Kevin Selinger
Track and Room: Track 4 - N/A
Title: Mastering Date-Time Based Analysis in DAX
Abstract: A large volume of analysis that a business typically performs on its data involves dates and/or times. For example, you may need to compare sales from one year to the next or aggregate transactions over time. DAX incorporates many built in time intelligence functions to help make date-time based calculations easier. Although the time intelligence functions are very beneficial, they can be misused and give erroneous results.This session is guides you through the various time intelligence functions available in DAX and provide practical examples of how to use them.
Speaker(s):
- Dan Clark
Track and Room: Track 1 - N/A
Title: Troubleshooting your TCP/IP connections
Abstract: Database professionals are often challenged to troubleshoot why a user cannot connect to a SQL Server instance. Attend this session to learn the basics of how SQL Server listens for connections and how it uses its browser service. Also learn what utilities the Windows operating system offers to help you in troubleshooting those connection issues.
Speaker(s):
- Mike Hays
Track and Room: Track 5 - N/A
Title: Flash 101 – An Introduction to Flash Storage for SQL Server and Data Centers
Abstract: “’More CPU/More Memory/More Spindles” has been the mantra for increasing performance for SQL Server environments that are resource bound. This often leads to complicated file placements, complicated LUN/disk striping, complex partitioning schemes and creative resource handling. Storage has been the last area of hardware technology that has improved performance for enterprise systems, but now the next generation of storage is here… Flash and it’s available and practical for database systems!
Speaker(s):
- Stephen LeRoy
Track and Room: Track 2 - N/A
Title: Database Design fundamentals
Abstract: We will cover the fundamentals of an RDBMS and go over a basic database design session
Speaker(s):
- Madhu Kudaravalli
Track and Room: Track 0 - Wanna be a DBA? - N/A
Title: SSAS Tabular 2012 vs SSAS Multidimensional OLAP
Abstract: In this presentation, I’ll compare the new Tabular Model in SSAS 2012 with the more “traditional” multidimensional OLAP in SSAS. I’ll show which of the 2 approaches works better in specific scenarios, and why you’d want to use one method over the other for certain applications. If you are trying to decide which approach to use, or if you are an experienced OLAP developer who wants to know the pros and cons of moving to the Tabular Model, this presenation is for you!
Speaker(s):
- Kevin Goff
Track and Room: Track 3 - 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.
Speaker(s):
- Konstantin Melamud
Track and Room: Track 4 - N/A
Title: Virtualization for SQL DBAs
Abstract: Want to know about VMWare, Hyper-V and what they mean for your databases? This session will go through the hardware and terminology around this technology. Learn how to optimize your SQL Servers for VMs and what to tell your storage engineers.
Speaker(s):
- Joseph D’Antoni
Track and Room: Track 2 - 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: Track 2 - N/A
Title: T-SQL for Application Developers - Attendees chose
Abstract: That’s right, attendees choose! I’ll show 20 possible topics on the screen, and the attendees vote on which topics I’ll cover. Everything from isolation levels to ranking…everything from GUIDs to table-valued functions….everything from querying temporal data to instances where subqueries are necessary….everything from update triggers to reading execution plans. The good news is that you’ll walk away with 20 code samples, even though we’ll only cover a portion of them in the presentation. This has always been a very popular session.
Speaker(s):
- Kevin Goff
Track and Room: Track 4 - N/A
Title: SQL Injection
Abstract: Well, we have all heard about the horror stories of data loss due to SQL Injection and how costly (in many ways) they can be. This in-depth discussion covers various forms of SQL Injection attacks and offers some guidelines on how to avoid them. Lots of code examples in both .NET and TSQL. Watch me hack a website and retrieve user data in just 3 hits on an unprotected html page!
Speaker(s):
- Kevin Boles
Track and Room: Track 3 - N/A
Title: Basic Monitoring with Perfmon
Abstract: Perfmon is a standard windows monitoring tool available on every windows deployment. It can provide a wealth of information about the activities within your system. We will cover the basics in this session which include how to setup/schedule perfmon to capture data as well as some basics around initial analysis. This session will have a strong component of demos.
Speaker(s):
- Rick Heiges
Track and Room: Track 3 - N/A
Title: SQL Server for the accidental DBA
Abstract: So the DBA quit and now you’re stuck running the database server. We will review the SQL Server stack for non-database professionals. Also, a discussion of some of the most critical things that developers will need to know when managing a SQL Server where there is no professional DBA to be found. Some tips on how and where to reach out for help with problems and questions, and common gotchas and problems you may see in the field.
Speaker(s):
- Craig Purnell
Track and Room: Track 5 - N/A
Title: Automating in the Cloud
Abstract: We’ve heard all the awesome Cloud deployment stories, but DBAs can use the Cloud too! Looking for a way to test your backups? Need to find an offsite location as a part of a DR plan? What about defining your backup retention scheme? You can handle these common administration problems by utilizing Cloud services in combination with PowerShell automation. In this session, we’ll review the basic Cloud architecture of both Azure and Amazon, as well as some specifics as to the components of the solution.
Speaker(s):
- Matt Velic
Track and Room: Track 3 - N/A
Title: Closing Remarks by Gina Walters and Raffle
Abstract: Closing Remarks and Raffle
Speaker(s):
- Matt Nelson
Track and Room: Track 5 - N/A
Title: SSIS Olympics
Abstract: Did you know that 38 hundredths of a second separated gold and silver in the 4-man bobsledding race at the Vancouver Winter Olympics? What did the right setup mean for the US bobsled team in Vancouver? Everything!!! Choosing the right components and settings can make all the difference in the world. The same holds true for the setup and performance of packages in SSIS. In this demo heavy session, we will glide through parts of SSIS that, when used correctly, will make your packages gold medal contenders.
Speaker(s):
- Cory Stevenson
Track and Room: Track 1 - N/A
Title: Basic Administration
Abstract: This session is for the Wanna be a DBA track. It is geared toward anyone interested in starting a career as a DBA. The session will cover basic database adminstration tasks including backups, recovery, user permissions, security, and performance.
Speaker(s):
- Matt Nelson
Track and Room: Track 0 - Wanna be a DBA? - N/A
Title: Putting it all together
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: Track 0 - Wanna be a DBA? - N/A
Title: Opening Remarks - Gina Walters Keynote - Rick Heiges presents Community and Cool Stuff!
Abstract: Rick will discuss what resources are available in the SQL Community. In addition, Rick will focus on what is new in SQL 2014 - especially Hekaton and Buffer Pool Extension of SSDs.
Speaker(s):
- Opening Remarks Keynote
Track and Room: Track 5 - 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.
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.
Opening Remarks Keynote
Gina Walters is a Systems Integration Advisor at Dell. Rick Heiges is a Sr. Solutions Consultant with Scalability Experts working with customers on solutions and educating users on SQL Server by speaking at user groups, conferences, labs, and road shows across the USA, Europe, and Africa. He holds an MBA and a M.S. in MIS as well as a B.S. in Computer Science. In addition, he also has attained MCTS:SQL2005 and MCITP:DBA certifications. Rick is very active with the SQL community thru PASS and se
Rick Heiges
Twitter: - heigesr2
LinkedIn: Rick Heiges
Contact: http://sqlblog.com/blogs/rick_heiges/default.aspx
Rick is a Former Data Platfrom MVP and Sr. Consultant for Microsoft where he focuses on working with customers on their data estate. His career includes work as a DBA, University full-time faculty member, Systems Analyst, Project Leader, and Developer. He has found his passion in working with data and the community. Rick served nine years on the PASS Board of Directors and spearheaded the popular 24 Hours of PASS event. He also started his local User Group in 2002. Today, he spends much of his time with his head in the clouds.
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.
Kevin Selinger
Kevin Selinger has been working in the IT field in various positions since 1981. Over the past seven years he has been working with the Dell Software Group focusing on performance tools for the SQL Server Platform. Engaging with clients in discussions, implementations and trainings on how best to benefit from the software they have just licensed or are about to license in their environment.
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.
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”.
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.
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
Stephen LeRoy
Steve has been a DBA since the mid 80s, starting as a Sybase DBA them MS SQL Server. Steve was based out of the Washington D.C. working for most of the 3 letter government Agencies as a contractor doing development, architect and production DBA jobs on small to large scale applications. Recently, Steve has been based out of Altanta, GA doing similar work until working for Violin Memory since 2011.
Dan Clark
LinkedIn: Dan Clark
Contact: http://drclarkblog.wordpress.com/
Dan Clark is a senior data analytics consultant. He is focused on all things data analytics and training others how to get value from their data. Dan has published several books and numerous articles on .NET programming and data analytics. He is a regular speaker at various developer and database conferences and user group meetings and enjoys interacting with the Microsoft developer and database communities. His latest book Beginning Power BI published by Apress is a will get you up and running with self-service data analytics on the Power BI platform in no time.
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.
Mike Hays
LinkedIn: Mike Hays
Contact: http://www.thesqlreport.com/
Mike has been working with Microsoft SQL Server for the last twenty years. Currently working as a Database Administrator for a diversified energy company, he has also worked in the retail, manufacturing, banking sectors. He holds a Master’s degree in Computer Information Science from Cleveland State University. He currently resides in Ohio with his girlfriend Alexia, her two children and their dog Lanna.
David Maxwell
Twitter: - https://twitter.com/dmmaxwell
LinkedIn: David Maxwell
Contact: https://dmmaxwell.wordpress.com/
David Maxwell has almost 20 years of experience with SQL Server, with a keen interest in performance tuning, monitoring, and troubleshooting. He has experience in environments as diverse as health care institutions, auto manufacturers, and insurance companies. David has been a frequent presenter at SQLSaturday events around the United States since 2012, as well as a presenter for the DBA Fundamentals Virtual Group, the Performance Virtual Group, 24 Hours of PASS, and the annual PASS Summit. David participates in his local Columbus Ohio PASS Local Group, where he serves on the board of directors as SQLSaturday coordinator.
Michael John
Twitter: - #Progeek11
LinkedIn: Michael John
With 20 years experience in all aspects of development and administration of SQL Server, from version 6.5 to 2016, I have seen, broken, and fixed just about everything in SQL Server!
Matt Nelson
Twitter: - http://twitter.com/mattpgh
LinkedIn: Matt Nelson
Contact: http://wwww.nelsonsweb.net
Matt Nelson is a Database Administrator and Business Intelligence developer for RDX (Remote DBA Experts) in Pittsburgh, PA. With over 10 years of experience, He works with more than 200 clients on general database administration needs and BI projects. Matt is also the Chapter Leader of the Pittsburgh SQL Server Users Group, and an organizer of Pittsburgh SQLSaturday. He occasionally blogs at www.nelsonsweb.net and http://www.rdx.com/Blog/
Sayed Saeed
Contact: http://www.plusconsulting.com/
Sayed Saeed is the Business Intelligence Practice Director at Plus Consulting. He is highly proficient in developing targeted BI solutions for clients and offers solid knowledge and experience in BI products that help organizations better leverage information to effectively manage business. He is a Microsoft Certified Solutions Expert in Business Intelligence as well as Oracle Certified Professional.
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.
Aaron King
Twitter: - https://twitter.com/trendoid
LinkedIn: Aaron King
Contact: http://www.aaronstanleyking.com
Aaron King is an application architect specializing in enterprise web applications and very large databases. He has helped several successful startups move to the software plus services model. He is currently working as an independent consultant on several long term engagements. Aaron is also a community leader and active in Indy PASS.
Craig Purnell
Twitter: - @CraigPurnell
LinkedIn: Craig Purnell
Contact: http://www.craigpurnell.com/
Craig Purnell is a career database professional, trainer, and community activist. He has spent over 10 years as the Database Administrator at a large Midwestern law firm. He has been in IT for 15 years and has spent his entire career working with enterprise databases and ERP systems. Craig is an active member of the Ohio North SQL Server User Group and has presented at many user groups, SQLSaturdays, and the PASS Summit in 2012 and 2013
Madhu Kudaravalli
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.
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.
Madhu Kudaravalli
Matt Nelson
Twitter: - http://twitter.com/mattpgh
LinkedIn: Matt Nelson
Contact: http://wwww.nelsonsweb.net
Matt Nelson is a Database Administrator and Business Intelligence developer for RDX (Remote DBA Experts) in Pittsburgh, PA. With over 10 years of experience, He works with more than 200 clients on general database administration needs and BI projects. Matt is also the Chapter Leader of the Pittsburgh SQL Server Users Group, and an organizer of Pittsburgh SQLSaturday. He occasionally blogs at www.nelsonsweb.net and http://www.rdx.com/Blog/
Katie Vetter
LinkedIn: Katie Vetter
Business Intelligence Developer / SQL Server DBA with a background in software development. Speaker at Pittsburgh SQLSaturday 2013 amp; 2014.
Nate Locklin
LinkedIn: Nate Locklin
Contact: http://www.locklin.org
Nate Locklin is IT Manager at PPG Industries, leading the Business Intelligence and SQL Server Database Administration teams. He has been employed as a SQL Server DBA since 2000 and holds MCDBA and MCTS certifications. He has been a member of the Pittsburgh SQL Server User Group for almost 20 years, and has previously presented on SSIS best practices and using geospatial data in SSRS.
Steve Hood
Contact: http://SimpleSQLServer.com
I have been working with SQL Server since 2000, but never in an environment that threw me deep into the internals of SQL Server until 2010. Now I’m starting to get obsessed with taking what I learned in the last couple of years and throwing that information out there. It should be noted that I’m presenting to specific person in everything I do… the 2008 or earlier version of me. If I knew what I know now 10 years ago, my career would have been very different.
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/
Ken McFerron
I have been in the IT field for over 10 years. I am currently a Senior System Admin working on the Microsoft Services team. My main area of focus for the last few years has been Active Directory. I use PowerShell on a daily basis. I am always amazed at the power of PowerShell and how it makes automation so make easier than using VBScript or Batch files. I am also the founder of the Pittsburgh Powershell users group.
Cory Stevenson
Twitter: - @CoryGStevenson
LinkedIn: Cory Stevenson
Cory Stevenson, a Business Intelligence Consultant for BlueGranite, Inc., has worked with technology for over 10 years. He has specifically worked with SQL Server 2000 on up; in addition, his interests include SSIS, SSAS, SSRS, DQS, and MDS. Cory is an active member of the Ohio North SQL Server User Group. You can find him on Twitter at @CoryGStevenson.
Madhu Kudaravalli
Matt Velic
Twitter: - mvelic
LinkedIn: Matt Velic
Contact: http://mattvelic.com
Matt Velic is a database developer for Sanametrix in Washington, DC. When not jet setting between projects at work, you can find him at a board game, a video game, or playing a guitar.
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.
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
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/
A.J. Mee
Contact: http://blogs.msdn.com/b/ajmee/
A.J. Mee is a Principal for Microsoft. He has dedicated his entire 20-year career to the field of BI and Database. He has served in varied roles from development to project management to people leadership to sales. He is a popular speaker who frequently presents on a wide variety of BI-related topics at numerous conferences and events. He came to Microsoft as part of its acquisition of ProClarity in 2006. A.J. holds a B.A. in Computer Science from LaSalle University.
Sponsors
The following is a list of sponsors that helped fund the event: