SQLSaturday #171 - Pittsburgh 2012
Event Date: 10/06/2012 00:00:00
Event Location:
- La Roche College, Zappala Center
- 9000 Babcock Boulevard
- 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: Seven SQL Agent Jobs You Should be Running
Abstract: See those things around your ankles? You hope they’re your socks because no DBA wants to be caught with their pants down.
Whether you’re an accidental DBA, a DBA who has just inherited a bunch of servers, or someone who works in a shop that won’t buy monitoring tools, this session will help you get basic monitoring in place to make sure you know what’s going on in your environment.
You’ll learn how to implement seven simple scripts that perk their ears up and start barking like a dog after a stranger walks in the house. They are the canary in your coal mine. You’ll know when backups fail, when they run longer than usual, when data files are getting full, when transaction logs have excessive VLFs, and more.
Speaker(s):
- Mike Hillwig
Track and Room: Room AB314 - N/A
Title: Introduction to SQL Server Service Broker
Abstract: In this session, we’ll cover the basics of setting up SQL Server Service Broker from the ground up with lots of demos. We’ll discuss some pros and cons to using Service Broker, some common problems encountered when using it, and some example use cases. If you’ve ever been curious about Service Broker, need to send data between databases or instances, or are wondering if Service Broker is right for your organization, then you won’t want to miss this session.
Speaker(s):
- Adam Belebczuk
Track and Room: Room AB308 - N/A
Title: How Not to Be a Cranky DBA
Abstract: Mike Hillwig is known as the Cranky DBA. You probably have pain points in your environment that make you cranky, too. Mike has lots of horror stories to tell about bad SQL Server implementations and practices. More importantly, he has developed a list of 12 key tips for managing your SQL Server environment. By following these tips, you’ll make your DBAs, developers, and system administrators a little less cranky.
Speaker(s):
- Mike Hillwig
Track and Room: Room AB316 - N/A
Title: Data center migration, data centric point of view
Abstract: Data center migrations are all the rage these days and the SQL Server DBA is one of the most important accessories. When an organization decides to change data centers, of all the very important servers that will be migrated, the ones with the company data will be the most watched. Like other projects, a good plan followed by good execution is required. In this session you’ll learn about the research, design, planning, process, and execution to migrate SQL Servers from one DC to another. I’ll go over lessons learned, whether to go it alone or brings in help, discuss pros and cons of migration techniques, big decisions like keeping the same server names, when to and not to virtualize, downtime considerations, data sync, and more.
Speaker(s):
- Tony Scotto di Carlo
Track and Room: Room AB310 - N/A
Title: Code Tuning- Introduction to Execution Plans
Abstract: Topic will provide a more in depth look into query execution plans and is targeted for junior to senior DBA’s. You will learn how to identify what indexes are being used by the SQL optimizer, different type of index operations are performed by SQL server and what operations are generally considered as a preferred method of data retrieval. We will discuss how to determine if indexes used by the optimizer are the optimal ones and the exceptions to the rules. Finally we will discuss the relationship between different types of index operation and different types of join types within SQL Server including how the SQL Optimizer determines which join type it will use and pros and cons of each type.
Speaker(s):
- Konstatin Melamud
Track and Room: Room AB309 - N/A
Title: Getting Started with Report Services: The Setup
Abstract: In the SQL Server tool box there is a great tool called SQL Server Report Services. With five different interfaces, Report Services can be a bit challenging to setup and configure. Our focus will include setup, configuration, and deployment. When you walk away from this session, you will understand terms like BIDS, SSRS, Report Builder, and Crescent. Also, as part of this session we will cover the differences between SQL 2008 R2 and SQL 2012. If you are looking for steps to start developing your repertoire of SQL Server Report Services, this is definitely a session to attend!
Speaker(s):
- Cory Stevenson
Track and Room: Room AB316 - N/A
Title: Creating a Metadata Mart w/ SSIS - Data Governance
Abstract: This is an expanded and updated version of the session I presented at the SQL Rally in Orlando. We will cover Tactical Data Governance and in detail specific code examples, using Stock and Custom SSIS Transforms ,Data Models, SSAS Cubes used to create and populate a Metadata Mart as defined by Michael Belcher(Gartner). We will demonstrate incorporating complete custom Data Profiling capabilities (SSIS Transform Scripting, TSQL) capable of Profiling any Source and Targeting any destination. In addition we will implement Data Quality(Address Correction, Fuzzy Matching) and Visualization via PowerPivot , Excel and QlikView. Last will will demonstrate code generation.
Speaker(s):
- Ira Warren
Track and Room: Room AB308 - N/A
Title: Performance Tuning for Pirates
Abstract: If you follow baseball you will notice that the Pittsburgh Pirates (this speaker’s favorite team) has to do more with less to be successful. This trend can also exist within IT shops. If you need to improve the performance of your SQL Server instances and cannot purchase 3rd party tools this session is for you. Learn to improve your performance tuning process by using several free tools. This session will cover wait stats, dynamic management objects, perfmon, PAL, SQL Trace, ClearTrace, SQL Nexus and SQLDiag.
Speaker(s):
- John Sterrett
Track and Room: Room AB314 - N/A
Title: Building Your First Tabular Model
Abstract: With the release of SSAS 2012 Microsoft has introduced a new BI storage engine. In addition to the traditional OLAP engine you now have the option to build your BI models on top of the new Vertipaq engine (This is the same engine used by PowerPivot.) To use the new xVelocity engine you build a Tabular data model. A new query language DAX (Data Analysis Expressions) is used to create calculations, measures, and KPI’s. DAX is similar to the expression language used in excel and it should be easier to use than MDX and appeal to a broader audience. This session is designed to introduce you to the process of building a tabular model in SQL Server Data Tools (BIDS rebranded).
Speaker(s):
- Dan Clark
Track and Room: Room AB308 - N/A
Title: Searching for the Holy Grail of DDL Auditing
Abstract: Who altered this view and how? When was that index created? What happened to my stored procedure? From SQL Trace to SQL Audit and everything in between, we’ll explore various methods of auditing events in SQL Server, how they work, and the inherent strengths and shortcomings of each in an epic quest to find the perfect DDL audit solution.
Speaker(s):
- Colleen Morrow
Track and Room: Room AB314 - N/A
Title: Upgrade Roadmap: Let’s delve into SQL Server 2012
Abstract: We will review the upgrade process to SQL Server 2012. An upgrade is 75% project planning and 25% execution. Everyone knows that, right? Actually, no. A checklist of considerations a company would likely encounter coming from SQL Server 2005/2008 or R2. The pros and cons of in place upgrade vs. the build out new approach. There will be many real world lessons learned sprinkled in as the presenter has led many upgrades and migrations of SQL Server. Key takeaways include: when to upgrade in place compared to build new, usage of and how to gauge the usefulness of Upgrade Advisor, deprecated features and how to test for them
Speaker(s):
- Craig Purnell
Track and Room: Room AB310 - N/A
Title: SharePoint COOP Using 2008R2 Log Shipping
Abstract: Many organizations never plan for disaster. Ken and Don will present a solution that can assist any shop to ensure mission critical SharePoint farms continue to operate throughout the course of an unplanned production downtime. The speakers will speak about topics that are pertinent to ensuring continuity of operations, how to plan for disaster, and how to use Log Shipping to ensure content is copied to a secondary farm to ensure accessibility and uptime.
Speaker(s):
- Donald Scott
Track and Room: Room AB310 - N/A
Title: Defy the Defaults!
Abstract: Installing SQL Server is easy, right? You just insert the install media, click Next a bunch of times, and you’ll have a working database server in just a few minutes. At least that’s what many of our non-DBA colleagues think. Not so fast, says veteran DBA Mike Hillwig. SQL Server has lots of default settings that can be potential performance killers, and we’ll look at a bunch of them. These include things like where data files live, data file growth, basic security settings, and the services being installed. And while we’re at it, we’ll look at a bunch of the good defaults and talk about why they shouldn’t be touched.
Speaker(s):
- Mike Hillwig
Track and Room: Room AB314 - 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: Room AB316 - N/A
Title: Introduction to Data Quality Services
Abstract: Data Quality Services (DQS) has been introduced as part of the Microsoft SQL Server 2012 stack. In this session, we will take a first look at DQS and how it can transform the way we enable and set data quality standards to ensure clean data.
Speaker(s):
- Rushabh Mehta
Track and Room: Room AB316 - N/A
Title: Don’t Panic DBAs! Databases on VMware Made Easy
Abstract: Many of our customers are either virtualizing databases or planning to do so soon. We hear from many groups that attempted running their database on VMware but went back to physical hardware because of performance issues. There are many reasons this may have happened, but quite often the decision to go back to physical was not based on hard facts. This presentation will explore the fundamentals of monitoring databases running in a VMware environment. If you are using classic O/S monitoring tools, you may be getting misleading data. Understand what metrics are important and how to get to that data.
Speaker(s):
- Dean Richards
Track and Room: Room AB308 - N/A
Title: MongoDB for the Relational DBA
Abstract: NoSQL is the buzzword of the moment, and MongoDB is the leader of the pack. Its probably running in your enterprise in production, and eventually its going to break. As a DBA its your job to fix it when it breaks, and back it up before it does.After all, there’s not RELATIONAL in DBA.
On the technical side, this talk will focus on what a DBA needs to know about running MongoDB on windows. This includes setting it up as a service, importing and querying data, and of course backing up and restoring the database.
On the non-technical side, this talk will focus on when you would want to use MongoDB, and when you would not want to.
Speaker(s):
- Justin Dearing
Track and Room: Room AB309 - N/A
Title: 14 New T-SQL Functions
Abstract: The 2012 release of SQL Server introduces 14 new functions for developers. This list includes functions for conversion, date/time calculation, enhanced logic, and string manipulation. In this session we’ll cover the ins and outs of these new functions, making you a better T-SQL developer.
Speaker(s):
- Sam Nasr
Track and Room: Room AB310 - N/A
Title: Before You Optimize: Understanding Execution Plans
Abstract: You know what your query does, but do you know how it does it? Do you know what type of resources your query uses? Come to this session to find the answers to these questions and more as we walk through reading execution plans. We will see how SQL breaks down the execution of your query and what each step tells us about the overall query. If you are newer to Microsoft SQL or you just don’t feel totally comfortable with reading execution plans, this session is for you.
Speaker(s):
- Tim Corey
Track and Room: Room AB309 - N/A
Title: SQL 2012 – All About HA and DR
Abstract: Have you heard about all of the new Availability Group features in SQL 2012? Thinking about implementing a DR solution, but don’t know where to start. In this presentation you’ll learn all about the new DR features in SQL Server 2012 and see them in practice.
Speaker(s):
- Joseph D’Antoni
Track and Room: Room AB314 - N/A
Title: Top Development and Design Mistakes
Abstract: There are many mistakes made repeadedly that are never caught in the database design and subsequent development efforts that affect performance, logic, and casue pain for the DBA. This session will point these issues out, and help you prevent and identify these issues.
Speaker(s):
- Michael John
Track and Room: Room AB316 - N/A
Title: Spatial Data in SQL Server Reporting Services
Abstract: This presentation will offer a tutorial for using maps in SQL Server 2012 Reporting Services reports. Sample applications and use of ESRI shapefiles will be included in the demonstration.
Speaker(s):
- Nate Locklin
Track and Room: Room AB308 - N/A
Title: Full-Text Search, it’s not just for documents
Abstract: Full-text search is an often overlooked feature of SQL Server that can be used for more than searching documents. This session will cover setting up and using full-text search to handle some of those dirty data situations we’ve all inherited without using the dreaded “LIKE ‘%text%’”. As an example, we will demonstrate how full-text search can be used to find names in poorly formatted data like ‘mailing address’ or ‘billing address’ fields. It will also cover how to handle noise words that may match some names and synonyms for first names to create a really robust solution that goes beyond what could be done with plain old SQL.
Speaker(s):
- Jay Holliday
Track and Room: Room AB309 - N/A
Title: SQL Server 2012’s Net-New BI Capabilities
Abstract: Much like other recent installments of SQL Server, SQL 2012 provides a wealth of new capabilities in the arena of Business Intelligence. Come join A.J. Mee, a veteran Microsoft BI specialist, to review the key advances that SQL Server 2012 brings to enterprise BI scenarios, including: · Power View · BI Semantic Model (BISM) · Data Quality Services · Master Data Management · Columnstore Index
Speaker(s):
- A.J. Mee
Track and Room: Room AB316 - N/A
Title: So I started this blog… now what?
Abstract: Ever thought about trying your hand at blogging? Or maybe you’ve started a blog but struggle with what to write about. We’ll take a beginner’s look at blogging and examine what makes a great blog, overcoming obstacles common to new (and even experienced) bloggers, building authority and credibility, and setting you on the road to blogging stardom.
Speaker(s):
- Colleen Morrow
Track and Room: Room AB310 - N/A
Title: Communicate for Great Good!
Abstract: “No one knows what I do.” That’s a chief complaint of data professionals everywhere, and it’s a dangerous position to be in as well. Reviews may not be favorable, promotions more uncommon, and training dollars more rare. But by practicing written and verbal communication, new opportunities may present themselves. Blogging can land a book deal. In-house team lunch-and-learns can lead to community presentations. Most of all, good communication can be the skill that saves your job or opens the door to new horizons.
Speaker(s):
- Matt Velic
Track and Room: Room AB309 - N/A
Title: How PowerShell helps me as a DBA
Abstract: I will share some stories, discuss the Power of PowerShell and provide some example scipts.
Speaker(s):
- Carlton Ramsey
Track and Room: Room AB314 - N/A
Title: MicroORMs – Keeping Your DBA Happy
Abstract: Developers like the reduced complexity and increased productivity that an ORM can bring while DBAs don’t care for the data models that often result. Using an ORM with an existing data model is often a nightmare. But writing all of that data mapping code is such a pain! What if we could have a solution that gave us the best of both worlds and made the developers AND the DBAs happy? MicroORMs might be the answer. In this session, we’ll explore PetaPOCO, a MicroORM.
Speaker(s):
- Eric Kepes
Track and Room: Room AB310 - N/A
Title: An Introduction to Master Data
Abstract: This session will provide an introduction to Master Data. We will discuss what Master Data is and discuss Master Data Management. Master Data Management is the process of migrating data into a single source so that the information to be shared by multiple systems and applications in the organization. Merging data into this single source we can remove duplicates and improve data quality.
Speaker(s):
- Carlton Ramsey
Track and Room: Room AB308 - N/A
Title: Using Filetables
Abstract: The FileStream feature was introduced with SQL Server 2008 allowing BLOBs to be managed by the DB. In 2012, FileTable expands on this feature by using specific tables for storing these BLOBs. This allows Windows apps to access these items as if there were stored on the file system.
Speaker(s):
- Sam Nasr
Track and Room: Room AB309 - 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.
Konstatin Melamud
Konstantin Melamud is a SQL Server Team Lead for Remote DBA Experts. He works with over 200 customers on solutions within the SQL Server environment and leads code tuning team within Remote DBA experts. He is passionate about educating users on SQL Server by speaking at user groups, conferences, and labs.
Sam Nasr
Twitter: - SamNasr
LinkedIn: Sam Nasr
Contact: http://samnasr.blogspot.com/
Sam Nasr has been a software developer since 1995, focusing mostly on Microsoft technologies. He’s a Sr. Software Engineer with NIS Technologies where he consults and teaches clients about the latest .Net technologies. Sam has achieved multiple certifications from Microsoft (MCSA, MCAD, MCTS, MCT), and is the leader of the Cleveland C#/VB.Net User Group since 2003. In addition, he’s the leader of the .Net Study Group, an author for Visual Studio Magazine, and a Microsoft MVP since 2013. When not coding, Sam loves spending time with his family and friends or volunteering at his local church.
Colleen Morrow
Twitter: - @ClevelandDBA
LinkedIn: Colleen Morrow
Contact: http://colleenmorrow.com
Colleen Morrow is a database professional living in Cleveland, OH who has been working with database systems since 1996. For more than 12 years, she was a Database Administrator at a large law firm where she developed an appreciation for auditing, automation, and performance tuning. Since that time she has worked with clients in the healthcare, manufacturing, software, and distribution/freight delivery industries. Colleen is currently a Senior Consultant at Fortified Data. She is an active member of the Ohio North SQL Server User Group and has presented at many SQLSaturday events as well as PASS Summit 2014 and 2015.
Ira Warren
Over 35 years experiences in Software Sevelopemt, IT Management and BI Architecture.
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”.
Tony Scotto di Carlo
LinkedIn: Tony Scotto di Carlo
Tony Scotto di Carlo has been in the IT biz for over 20 yrs with a bend towards the entrepreneurial.Over his tenure, Tony’s career has taken him from consulting, cofounding 3 software companies, IT Mangager amp; Director of business systems, with several years working in Europe and the Middle East.Tony has been working with SQL Server since the mid 90’s with version 6.5ish /7. Today Tony is a Sr Consultant with Dell Services, architecting, planning and managing SQL Server data center migrations.
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.
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.
Justin Dearing
Twitter: - zippy1981
LinkedIn: Justin Dearing
Contact: http://www.justaprogrammer.net
Justin Dearing has been working in IT in 2002. He started as a night shift AS/400 operator and rose through the ranks at a series of companies. He currently works as a developer in the capital markets industry.
Justin has served in both the development and production side of the house on Windows, Unix and Midrange Platforms. His database experience includes MongoDB, MySQL, Postgres and Microsoft SQL server. These days he programs in C#, PowerShell and PHP.
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.
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
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.
Donald Scott
Contact: http://www.itkegger.com
Team of Speakers: Donald Scott (donscott@microsoft.com), Kenneth Hausman (kennha@microsoft.com), Jon Tupitza (jtupitza@microsoft.com). We are all Microsoft employees. We support SQL and other Microsoft products for customers around the DC area. Together we bring over a decade of MS experience. Ken Hausman and Jon Tupitza are Microsoft Consultants and Donald Scott is a Microsoft Premier Field Engineer.
Sam Nasr
Twitter: - SamNasr
LinkedIn: Sam Nasr
Contact: http://samnasr.blogspot.com/
Sam Nasr has been a software developer since 1995, focusing mostly on Microsoft technologies. He’s a Sr. Software Engineer with NIS Technologies where he consults and teaches clients about the latest .Net technologies. Sam has achieved multiple certifications from Microsoft (MCSA, MCAD, MCTS, MCT), and is the leader of the Cleveland C#/VB.Net User Group since 2003. In addition, he’s the leader of the .Net Study Group, an author for Visual Studio Magazine, and a Microsoft MVP since 2013. When not coding, Sam loves spending time with his family and friends or volunteering at his local church.
Colleen Morrow
Twitter: - @ClevelandDBA
LinkedIn: Colleen Morrow
Contact: http://colleenmorrow.com
Colleen Morrow is a database professional living in Cleveland, OH who has been working with database systems since 1996. For more than 12 years, she was a Database Administrator at a large law firm where she developed an appreciation for auditing, automation, and performance tuning. Since that time she has worked with clients in the healthcare, manufacturing, software, and distribution/freight delivery industries. Colleen is currently a Senior Consultant at Fortified Data. She is an active member of the Ohio North SQL Server User Group and has presented at many SQLSaturday events as well as PASS Summit 2014 and 2015.
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.
Jay Holliday
?I’ve worked with many systems over the years from Geographic Information Systems to Document Imaging to Web Public Access Systems to Phone System Integrations and many things in between. The one thing they’ve all had in common is a relational database back-end allowing me to easily move around and up throughout my career.
Rushabh Mehta
Twitter: - @rushabhmehta
LinkedIn: Rushabh Mehta
Contact: http://blogs.solidq.com/RushabhMehta
Rushabh Mehta is a Business Intelligence Mentor with SolidQ and the Managing Director for Solid Quality India Pvt. Ltd. He served as PASS President for 2010/2011 term.
Rushabh has worked with MS Data Platform since 1998 and has designed and developed BI systems since 2001. He has been the lead architect for many large-scale and complex BI solutions for clients such as Publix, Raymond James, Jackson Hewitt, US Dept. of Defense, and Microsoft. He is an MVP with Microsoft, Damp;B amp; Melissa Data
Carlton Ramsey
Twitter: - @eccentricDBA
LinkedIn: Carlton Ramsey
Contact: http://www.eccentricDBA.com
Carlton B Ramsey has worked for Third Federal Savings and Loan in Cleveland Ohio for two decades as an Application Developer and Database Administrator. He is an active member of the North Ohio SQL Server User Group, frequent SQLSaturday Presenter and Past-President of the Akron-Canton Chapter of CompTIA AITP (Association of Information Technology Professionals). In addition, he has a MCSA SQL 2016 Database Development.
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!
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.
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.
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.
Tim Corey
Twitter: - @IAmTimCorey
LinkedIn: Tim Corey
Contact: http://www.epicross.com
Tim is a Microsoft MVP whose goal is to make learning software development easier. If you are struggling with learning C#, SQL, or the related technologies, he wants to help.
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/
Dean Richards
LinkedIn: Dean Richards
Dean Richards is a Senior DBA for DBMS Insights and has helped hundreds of companies solve database and virtualization performance issues. Dean has over 20 years of experience in both development and database administration and has focused his entire career on performance tuning of Oracle and SQL Server environments. Most recently Dean has focused on the trend to virtualize and move databases to the cloud.
Carlton Ramsey
Twitter: - @eccentricDBA
LinkedIn: Carlton Ramsey
Contact: http://www.eccentricDBA.com
Carlton B Ramsey has worked for Third Federal Savings and Loan in Cleveland Ohio for two decades as an Application Developer and Database Administrator. He is an active member of the North Ohio SQL Server User Group, frequent SQLSaturday Presenter and Past-President of the Akron-Canton Chapter of CompTIA AITP (Association of Information Technology Professionals). In addition, he has a MCSA SQL 2016 Database Development.
Eric Kepes
Contact: http://erickepes.com
Eric Kepes is an in-the-trenches software architect specializing in developing distributed systems using agile methods. He enjoys sharing his experiences using technology with the developer community at user group meetings and Code Camps. He is Communications Director for PghDotNet and Speaker Coordinator for PghTechFest. Having spent 18 years in software development wearing many different hats, he currently works for McKesson Automation as a software architect.
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.
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.
Sponsors
The following is a list of sponsors that helped fund the event: