SQLSaturday #160 - Kalamazoo 2012
Event Date: 09/22/2012 00:00:00
Event Location:
- Kalamazoo Valley Community College
- 6767 West O Avenue
- Kalamazoo, Michigan
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: Dive into the Query Optimizer-Undocumented Insight
Abstract: This 400 (or maybe 500) level session will focus on using undocumented statements and trace flags to get insight into how the query optimizer works and show you which operations it performs during query optimization. I will use these undocumented features to explain what the query optimizer does from the moment a query is submitted to SQL Server until an execution plan is generated including operations like parsing, binding, simplification, trivial plan, and full optimization. Concepts like transformation rules, the memo structure, how the query optimizer generates possible alternative execution plans, and how the best alternative is chosen based on those costs will be explained as well.
Speaker(s):
- Benjamin Nevarez
Track and Room: Track 1 - N/A
Title: Introduction to SSIS with a Real-World Example
Abstract: SSIS is a powerful and east to use data Extract, Transform, Load (ETL) tool SSIS providing a rich set of components to perform the most common ETL tasks with “drag-and-drop” ease. Packages can be constructed with rigorous error and exception handling as well as verbose logging allowing deployment of robust ETL processes.. This session will demonstrate a process for loading a comma-delimited data file into a staging table for further processing then validating the data and moving specific data into host tables using a a thorough example of a non-trivial ETL project with “real” data. The intended audience includes beginning SSIS developers, DBAs, and anyone with a desire to experience the magic of data management with this remarkable tool.
Speaker(s):
- Ron Johnson
Track and Room: Track 1 - 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 a new structure that just might make Nested Sets obsolete. For stalwarts, it also includes a very high performance method (100,000 nodes in 6 seconds) for converting Adjacency Lists to Nested Sets that even a beginner can understand. You just have to know that a Tally Table is involved somewhere in this. ;-)
Speaker(s):
- Jeff Moden
Track and Room: Track 2 - N/A
Title: Wish you could live the glamorous consulting life?
Abstract: Consulting is a great career choice, from the increased pay, (sometimes less), to the flexible hours, (working nights and weekends), you will work with a wide range of customers, (if you can find them), that will lead you to wonder why you didn’t start earlier? (and walk away from a cushy job).
I would not trade my consulting career for any other choice, I love the rewards and the freedom it provides me, but I’ve learned the hard way. In this session you will lean sales, marketing and management strategies to get your practice off the ground, sand traps to avoid along the way and a honest, down to earth assessment of the consulting life. An essential session for those thinking about this choice and/or those who are just starting out
Speaker(s):
- Juan Soto
Track and Room: Track 2 - N/A
Title: Manage SQL Server 2012 on Server Core w/PowerShell
Abstract: Windows Server 2008 introduced Server Core, the operating system without the Graphical User Interface. SQL Server 2012 is the first version of SQL Server to support Server Core. To gain the maximum efficiency from your servers you want to make use of Server Core and with PowerShell you can effectively manage SQL Server in that environment. This session will demonstrate how to manage SQL Server 2012 on Windows Server Core and provide scripts to help you perform the common tasks you need to perform on that platform.
Speaker(s):
- Allen White
Track and Room: Track 5 - N/A
Title: NoSQL: Know Your Enemy
Abstract: A current trend among application developers to is move data storage away from a traditional relational database model. This presentation will provide an introduction into the technology known as NoSQL. We will discuss who’s who in the NoSQL world and explain the different ways that NoSQL databases store data. We will also cover which types of applications are best suited for the NoSQL approach and when a relational database would be a more appropriate choice.
Speaker(s):
- Shelly Noll
Track and Room: Track 3 - N/A
Title: Introduction to Microsoft StreamInsight
Abstract: Are you buidling systems to monitor and analyze mountains of data, and querying that from the typical relational database just isn’t cutting it? Well, my friend, StreamInsight might just be the ticket for you! StreamInsight is Microsoft’s platform for building high throughput, low-latency complex event processing (CEPs) systems. In this session, we will delve into what StreamInsight is and how to use it along with other entities such as Analysis Services and Integration Services to provide you big data customers the operational intelligence solutions that they deserve!
Speaker(s):
- Arie Jones
Track and Room: Track 1 - N/A
Title: Women in Technology Panel Discussion
Abstract: Join some of the Women in Technology as we share our experiences and field questions from the audience. ALL ATTENDEES ARE WELCOME!
Speaker(s):
- Shelly Noll
Track and Room: Track 4 - N/A
Title: SRS Report Builder for Business Intelligence
Abstract: Learn how easy it is to utilize the free download from Microsoft that allows users to create maps, charts, dashboard objects and reports against any kind of data easily without having to use Visual Studio. See how SQL Report Builder makes creating executive dashboards easy!
Speaker(s):
- David Eichner
Track and Room: Track 3 - N/A
Title: Transactional Replication 101
Abstract: Replication simplified! Learn the basic parts that make up replication, what tools are included to help you along plus a look into monitoring.
We will cover the players in the game: Pubishers, Subscribers and Distributors, then delve into the data delivery process with Publications, Subscriptions and Articles, finishing up with the Log Reader and how to make sure everything is working and running smoothly.
Speaker(s):
- Wendy Pastrick
Track and Room: Track 5 - 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: Track 2 - N/A
Title: BI2 Big Data Analytics - Hadoop and Microsoft BI
Abstract: This session is a deep dive that will show you how to use the Hadoop platform to extend traditional Microsoft BI solutions. The first half of the session covers big data architectures, the MapReduce process and strategies for integration of Hadoop data with traditional BI tools. The second half of the session demonstrates how to combine Hadoop, SQL Server Analysis Services, Power View and SharePoint 2010 into an end-to-end solution.
Speaker(s):
- Rob Kerr
Track and Room: Track 4 - N/A
Title: Anatomy of a Join
Abstract: A lot of database professionals today do not have a Computer-Science Degree so they never attended a “Introduction to Databases” course. In this session we are trying to fix at least one thing and we’ll look in depth at the three types of join operations, visualize how their algorithms work in order to understand how query plans are computed, explain why these join operations have very different performance characteristics and why the optimizer chooses a specific join operator to use in a query plan. Will demonstrate that empirical cost calculations are similar to what Query Optimizer actually outputs. Good understanding of join algorithms is vital in order to diagnose and remedy issues related to bad query plans.
Speaker(s):
- Luke Jian
Track and Room: Track 2 - N/A
Title: 45 min to build your first SSRS Report
Abstract: Does this sound like you? You were just given access to SSRS and you want to make a report. Or, you’re a DBA and could use a daily report. Either way, I’ve got your back! You will learn everything you need to know to get that first report out the door quickly and how to tweak it once it’s deployed. We’ll even look at the differences between building a report in BIDS (Business Intelligence Development Studio) and Report Builder 3.0. We’ll use SSRS (SQL Server Reporting Services) 2008 R2 and go interstellar with some space data!
Speaker(s):
- Tamera Clark
Track and Room: Track 5 - N/A
Title: Performance Enhancing Laziness
Abstract: Walk-up work. New database requests. Users running ad-hoc queries with 18 LEFT OUTER JOINS against heaps.Surprise SQL instances created by vendors without our knowledge crashing around us!It’s enough to drive a lesser DBA crazy-insane. That’s why it’s important to take as many steps as you can to simplify, automate, tweak, and tune the tasks you can manage so you have time to deal with those situations you can’t control. In this session Tim will go over many of performance-enhancing methods he’s developed over the last dozen years as a DBA for a major healthcare concern and show you how you can give yourself some breathing room to make the difficult seem easy.
Speaker(s):
- Tim Ford
Track and Room: Track 4 - N/A
Title: Free SQL Tools for Your Toolbox
Abstract: Every SQL developer or DBA should have a fully stocked toolbox that they can turn to in times of need. SQL Server enjoys a wide variety of support from 3rd party vendors that provide tools to help us peek under the hood and pinpoint issues. Sometimes we either don’t have the budget for everything we would like, or we need something for a one-off project. In this session we will examine some of the free tools published by members of the SQL community and 3rd party vendors.
Speaker(s):
- Kevin Bullen
Track and Room: Track 3 - N/A
Title: PowerShell, the New SQL Hammer
Abstract: You’ve seen all the amazing scripts that use PowerShell, but writing your own is raising more questions. This session will help fill in the gaps by explaining all the moving parts of PowerShell 2.0, the integration with SQL Server and answer the following questions as well as others. Why is Invoke-Sqlcmd necessary? What is and why is there a Minishell for SQL Server? What makes the SQLSERVER: PS Drive so powerful? How does a remote SQL Server get added to the SQLSERVER: PS Drive?
Speaker(s):
- Norman Kelm
Track and Room: Track 3 - 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 common roadblocks, finding topics, building readership, and setting you on the road to blogging stardom.
Speaker(s):
- Colleen Morrow
Track and Room: Track 1 - N/A
Title: Scaling SQL Server to HUNDREDS of Terabytes!
Abstract: Provide an introduction to the Massive Parallel Processing (MPP) Architecture. Describe how Microsoft’s MPP Appliance, Parallel Data Warehouse (PDW), allows SQL Server to scale to hundreds of terabytes. The presentation will also contain real world performance metrics and lessons learned directly from someone who actually developed a Parallel Data Warehouse Solution.
Speaker(s):
- Garrett Edmondson
Track and Room: Track 2 - N/A
Title: DB2: Let’s Talk Internals
Abstract: Performance tuning is both an art and a science. The more science you bring to your efforts, the better your art will be. There are many tools and techniques for finding performance problems, but solving them is usually left to the person using those techniques. This extended session focuses on what’s going on under SQL Server’s hood for a set of tasks normally hidden from users, such as: memory allocation, data manipulation, and on-disk and in-memory data structures. Armed with this knowledge, you will be better prepared to solve a variety of performance problems through deeper insight into the processes working behind the scenes.
Speaker(s):
- Eddie Wuerch
Track and Room: Track 4 - N/A
Title: SQL Azure Federations
Abstract: This session is to introduce to SQL Azure Federations.
Will walk you through the process of setting up federation, managing feredations etc and converting an existing database to Federations.
This topic requires rudimentary SQL Azure understanding
Speaker(s):
- Nitin Salgar
Track and Room: Track 2 - N/A
Title: SQL Server 2012 AlwaysOn Readable Secondaries
Abstract: One of the most talked about new features in SQL Server 2012 is AlwaysOn Availability Groups and the ability to have readable secondary replicas. In this session, we will cover the pros and cons of using AlwaysOn as well as the basics of how to set it up and take advantage of readable secondary replicas. If you want to improve the availability and performance of your applications databases, are currently using Database Mirroring, or if you’re just curious about AlwaysOn, then you won’t want to miss this session.
Speaker(s):
- Adam Belebczuk
Track and Room: Track 1 - N/A
Title: Load Balancing Analysis Services
Abstract: Have you ever wondered how to scale Analysis Services across the globe?
This session will cover a unique approach to load balancing SQL Server Analysis services using a unique approach created by Carl Rabler and Josh Caplan to load balance SQL Server Analysis services using features already built in to SQL Server Analysis Services and some standard Microsoft technologies.
Speaker(s):
- Anthony Mattas
Track and Room: Track 1 - N/A
Title: Effective Data Visualization: The Ideas of Edward
Abstract: We spend much of our time collecting and analyzing data. That data is only useful if it can be displayed in a meaningful, understandable way. Yale professor Edward Tufte presented many ideas on how to effectively present data to an audience or end user. In this session, I will explain some of Tufte’s most important guidelines about data visualization and how you can apply those guidelines to your own data. You will learn what to include, what to remove, and what to avoid in your charts, graphs, maps and other images that represent data.
Speaker(s):
- David Giard
Track and Room: Track 5 - N/A
Title: DB1: Let’s Talk Internals
Abstract: Performance tuning is both an art and a science. The more science you bring to your efforts, the better your art will be. There are many tools and techniques for finding performance problems, but solving them is usually left to the person using those techniques. This extended session focuses on what’s going on under SQL Server’s hood for a set of tasks normally hidden from users, such as: memory allocation, data manipulation, and on-disk and in-memory data structures. Armed with this knowledge, you will be better prepared to solve a variety of performance problems through deeper insight into the processes working behind the scenes.
Speaker(s):
- Eddie Wuerch
Track and Room: Track 4 - N/A
Title: Building Faster SQL Servers
Abstract: SQL Server speed boils down to how fast we can get data in and out of storage. Sooner or later, we’re going to run out of memory to cache. In this session, we take a lesson from Microsoft’s blazing-fast Fast Track Reference Architectures, look at why they work so well for the wildest queries, and explain how to build our own SQL Servers for quick queries. Brent Ozar shows you how to test your own servers and compares them to servers he’s worked with in the field.
Speaker(s):
- Brent Ozar
Track and Room: Track 4 - N/A
Title: DBA Basics: The Four Tasks Every DBA Should Know.
Abstract: There are four basic tasks every DBA should know how to do. They are, in this order: Restore, Backup, Index and Stats maintenance, and Consistency Checking. After this session, beginning and “involuntary” DBAs will know the basic ins and outs of each of these four critical tasks, as well as how to set up recurring maintenance on their servers, and handle some of the common issues these tasks present
Speaker(s):
- David Maxwell
Track and Room: Track 3 - N/A
Title: PowerPivot BISM in SQL Server 2012
Abstract: Want to create snazzy reports to impress the boss but aren’t a BI expert? Don’t climb the clock tower just yet, go get yourself PowerPivot 2012 and come to my session. We’ll go over some very real world issues and ways PowerPivot can help solve it. Demos will be jam packed with many of the new features in 2012 at same time giving you a good base to get you started. And this session wouldn’t be complete without covering BISM. We will definitely will cover how the BI world is all coming together as one to have hold and cherish in the BI Semantic Model.
Speaker(s):
- Hope Foley
Track and Room: Track 5 - N/A
Title: BI1 Big Data Analytics - Hadoop and Microsoft BI
Abstract: This session is a deep dive that will show you how to use the Hadoop platform to extend traditional Microsoft BI solutions. The first half of the session covers big data architectures, the MapReduce process and strategies for integration of Hadoop data with traditional BI tools. The second half of the session demonstrates how to combine Hadoop, SQL Server Analysis Services, Power View and SharePoint 2010 into an end-to-end solution.
Speaker(s):
- Rob Kerr
Track and Room: Track 4 - N/A
Title: Discovering the Plan Cache
Abstract: Execution plans are stored after execution in the plan cache. This metadata about how queries are executed can provide insight into how your SQL Server environment is functioning. By using XQuery to browse and search the plan cache you can find potential performance issues and opportunities to tune your queries. This information can be used to help reduce issues related to parallelism, shift queries from using scans to using seek operations, or discover exactly which queries are using what indexes. All of this and more is readily available through the plan cache. In this session we will explore the plan cache and start you on the road to discovery.
Speaker(s):
- Jason Strate
Track and Room: Track 5 - N/A
Title: Profiler? What is this tool you speak of?
Abstract: Many new DBA’s are unaware of the power of SQL Profiler. Many don’t know it exists. And better yet, it’s FREE. This session will generalize the importance of using Profiler to troubleshoot and tune your SQL queries. By demonstrating Profiler on a running server, attendees will get a look at what SQL is currently executing. This session will show how to discover query duration, reads, writes, locks, deadlocks, stored procedure executions and more.
Speaker(s):
- Jason Spangler
Track and Room: Track 3 - 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.
Arie Jones
Twitter: - @programmersedge
LinkedIn: Arie Jones
Contact: http://www.programmersedge.com
Arie Jones (quot;AJquot;) is one of the owners and Vice President of Emerging Technologies for Indy Data Partners, Inc. in Indianapolis, IN. AJ is a frequent speaker at national conferences and local user groups. With over 15 years of experience in application development and database administration on various platforms, he specializes in developing cross-platform solutions with an emphasis on .NET and SQL Server technologies. He blogs extensively at http://www.programmersedge.com.
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”.
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.
Kevin Bullen
Twitter: - sqlpadawan
LinkedIn: Kevin Bullen
Kevin has been working with SQL Server since 2006, as a application developer, SQL developer, and Database Administrator. He is currently a Premiere Field Engineer at Microsoft. When he’s not working, he’s usually hiding in his garage working on one of his jeeps.
Eddie Wuerch
Twitter: - @EddieW
LinkedIn: Eddie Wuerch
Contact: http://www.indydba.com
Eddie Wuerch has 20 years of experience as a SQL Server specialist in a much-longer IT career. A Microsoft Certified Master, Eddie spends his days in the Salesforce Marketing Cloud, focusing on performance, scale, and uptime for the massive SQL Server backend. These SQL Servers churn billions of transactions daily against trillions of rows of data in a 24x7 continuously-available online system accessed by millions worldwide every day.
Jason Strate
Twitter: - @stratesql
LinkedIn: Jason Strate
Contact: http://www.jasonstrate.com/
Jason Strate is a SQL Server Solutions Architect with Pragmatic Works. He is also a Microsoft SQL Server MVP and MCM. He has over 15 years of experience developing, architecting, and managing data platforms. Jason writes, blogs, and presents on SQL Server.
Tim Ford
Twitter: - @SQLAgentMan
LinkedIn: Tim Ford
Contact: http://thesqlagentman.com
Tim Ford is a Data Professional, Author and Community Leader whose technical passions lie in creative solutions for managing and presenting data. He#39;s been a healthcare DBA since 2000 and leads SQL Agent Man Consultancy and SQL Cruise. He takes 25 students and leaders in the SQL Community and places them on cruise ships for technical and professional development training without the distractions of the office and internet twice a year on SQL Cruises (www.sqlcruise.com). Currently Tim serves on the Board of Directors for PASS and is passionate about taking fellow Data Professionals to the next level in their careers. He enjoys telling stories with data.
Shelly Noll
Shelly Noll is a .NET Developer and recovering DBA with over 15 years of IT experience. Currently serving as a Software Developer with Learning Care Group in Novi, MI, she is involved in the .NET developer community and serves as Vice-President for the Great Lakes Area .NET Users Group. Her education includes a BS in Psychology from Loyola University Chicago and a MS in Information Systems from Lawrence Technological University.
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.
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”.
David Giard
Contact: http://DavidGiard.com
David Giard has been developing solutions using Microsoft technologies since 1993. He is a Microsoft MVP; a INETA Board of Directors member; and a past President of the Great Lakes Area .Net User Group. David has presented at many of the conferences and user groups around the country. He is the host and producer of the mildly popular online TV show Technology and Friends. He is the co-author of the Wrox book Real World .NET C# and Silverlight. You can read his latest thoughts at DavidGiard.com
Nitin Salgar
Nitin C Salgar has over 7 years of DBA experience including planning,design, development and implementation of line of business database applications. Nitin has worked primarily as a consultant holding positions primarily in the Benefit Management, Transportation and Government. He has worked on OLTP and OLAP applications housed on Premise (Co-Lo/Datacenter) as well as Cloud. He also possesses several Microsoft certifications on 2008, gearing toward 2012
I’ll be co-presenting with @andythir
Ron Johnson
Contact: http://rjssqlservernotes.wordpress.com/
A 20 year veteran of the IT industry with over 10 years experience as a software engineer Ron is a seasoned SQL Server performance optimization professional.Ron is currently supporting various clients as a consulting DBA specializing in PTO,Replication,HA/DR,and Security with Xtivia, Inc. a full-service IT company with offices in Dallas,TX, Colorado Springs,CO,and Edison,NJ.Ron earned a M.Sc. in Computer Science and a B.Sc. in Physics.Ron has 10 years of experience as an adjunct faculty member.
Tamera Clark
Twitter: - https://twitter.com/tameraclark
LinkedIn: Tamera Clark
Contact: http://tameraclark.com
Tamera Clark has been involved in the IT industry for greater than ten years, with experiences ranging from systems analysis/engineering to SQL Server and SSRS administration/development. She is an active member of the SQL Server community, participating in the Women in Technology Virtual Chapter, Co-leading the Nashville BI Chapter, assisting the Nashville PASS Chapter and serving as a Regional Mentor. Tamera is also the event chair of SQLSaturday Nashville.
David Eichner
Twitter: - @ICANSoftware
LinkedIn: David Eichner
David Eichner is a licensed CPA and is also CEO of ICAN Software Corporation, a Microsoft Dynamics amp; Acumatica ERP partner firm that sell and implements ERP and CRM software, develops software solutions and provides technology consulting. He is the host of a radio show called Business In The Cloud that airs weekly on KLAY 1180AM. He is skilled in building integrated cloud app solutions. His career spans more than 20 years in various technical/managerial positions within industries as diverse as military service, engineering/construction, municipal government, consulting and certified public accounting. Additionally, he holds various national certificates in technology (MCDBA, MCSE, CNE, CITP, Dynamics CRM and ERP, Acumatica CRM and ERP)
Hope Foley
Contact: http://hopefoley.com/
Hope has over 12 years experience in the IT world, she has worked across many industries from small business enterprises to Fortune 500 companies. She has a vast knowledge of database design, administration and support, data warehousing and data mining, and custom database solutions. Hope joined PTI in 2007 as a SQL Server Database Administrator/Analyst, and took over as Principal Microsoft Consultant, where she now leads a team of expert DBAs and developers. She is also a SQL Server MVP.
Benjamin Nevarez
Contact: http://www.benjaminnevarez.com/
Benjamin Nevarez is a SQL Server MVP and independent consultant based in Los Angeles, California who specializes in SQL Server query tuning and optimization. He is the author of “SQL Server 2014 Query Tuning Optimization”, “Inside the SQL Server Query Optimizer” and has contributed to other SQL Server books including “SQL Server 2012 Internals”. Benjamin has also been a speaker at many SQL Server conferences, including the PASS Summit, SQL Server Connections and SQLBits.
Eddie Wuerch
Twitter: - @EddieW
LinkedIn: Eddie Wuerch
Contact: http://www.indydba.com
Eddie Wuerch has 20 years of experience as a SQL Server specialist in a much-longer IT career. A Microsoft Certified Master, Eddie spends his days in the Salesforce Marketing Cloud, focusing on performance, scale, and uptime for the massive SQL Server backend. These SQL Servers churn billions of transactions daily against trillions of rows of data in a 24x7 continuously-available online system accessed by millions worldwide every day.
Jason Spangler
Jason is a SQL Server DBA by day, and a Firefighter/EMT by night. Since 2001, he has been a full time DBA with additional duties in Altiris, Sharepoint, and software development. For 12 years, he has also been a volunteer Firefighter and EMT helping his community through fire prevention and teaching firefighting and vehicle extrication techniques to new firefighters.
Shelly Noll
Shelly Noll is a .NET Developer and recovering DBA with over 15 years of IT experience. Currently serving as a Software Developer with Learning Care Group in Novi, MI, she is involved in the .NET developer community and serves as Vice-President for the Great Lakes Area .NET Users Group. Her education includes a BS in Psychology from Loyola University Chicago and a MS in Information Systems from Lawrence Technological University.
Rob Kerr
Twitter: - @robkerrbi
LinkedIn: Rob Kerr
Contact: http://www.robkerr.com
Rob is CTO with BlueGranite, is a Microsoft SQL Server MVP and holds top Microsoft certifications in both SQL Server Database Administration and BI Development. Rob has implemented data warehouse and business analytics systems for many Fortune 500 companies, and focuses on large-scale data warehousing, geospatial data analysis and mobile solutions. Rob is the lead contributor to msbiacademy.com, a site providing free on-demand training covering a variety of Microsoft BI topics.
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.
Luke Jian
Twitter: - @sensware
LinkedIn: Luke Jian
Contact: http://blog.sqlpositive.com
Luke Jian is an experienced database architect with a leading healthcare information company. A frequent speaker at conferences and local user groups he has 15+ years of experience in database design, development and optimization on SQL Server and Big Data projects.
Rob Kerr
Twitter: - @robkerrbi
LinkedIn: Rob Kerr
Contact: http://www.robkerr.com
Rob is CTO with BlueGranite, is a Microsoft SQL Server MVP and holds top Microsoft certifications in both SQL Server Database Administration and BI Development. Rob has implemented data warehouse and business analytics systems for many Fortune 500 companies, and focuses on large-scale data warehousing, geospatial data analysis and mobile solutions. Rob is the lead contributor to msbiacademy.com, a site providing free on-demand training covering a variety of Microsoft BI topics.
Norman Kelm
Contact: http://www.gerasus.com/
Norman Kelm is the owner of Gerasus Software, http://www.gerasus.com/, the maker of SSIS-DTS Package Search the only utility that can search SSIS and DTS packages. Norman has been working in IT for over 20 years. He worked as a FORTRAN and C developer for 8 years before making the jump to databases with Sybase. He then moved on to SQL Server working as a production and development DBA on SQL Server since version 6.5. He is also a founding member of the Tampa Bay SQL Server User Group.
Anthony Mattas
Twitter: - amattas
LinkedIn: Anthony Mattas
Contact: http://www.anthonymattas.com
Anthony Mattas is a Sr. Solution Architect on a world wide team at Microsoft focused on helping customers with distributed data systems.
Anthony has a B.S. in Computer Science Theory and Analysis from Western Michigan University, has multiple MCSE certifications, and is a Microsoft Certified Trainer.
Prior to joining Microsoft Anthony worked as a Business Intelligence consultant for the Microsoft Partner BlueGranite, and also formerly Technical Lead and Architect for a large medical device manufacturer’s global business intelligence platform.
Brent Ozar
Twitter: - BrentO
LinkedIn: Brent Ozar
Contact: https://www.BrentOzar.com
Brent Ozar loves to make SQL Server faster. He created sp_Blitz and the SQL Server First Responder Kit. He shares what he’s learned at BrentOzar.com.
Juan Soto
Twitter: - jsoto22
LinkedIn: Juan Soto
Contact: https://accessexperts.com/blog/
I’m the President of IT Impact, a Microsoft Access MVP and a frequent author on the official Microsoft Access blog as well as the first Access developer to be profiled on their site. I’m also a frequent speaker at Access User Groups throughout the USA, covering subjects such as SQL Server with Access as well as providing tools and resources for Access developers on the web. My expertise is optimizing Access with SQL Server and helping SQL Server DBAs understand how to design tables for Access.
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.
Garrett Edmondson
Contact: http://garrettedmondson.wordpress.com/
Garrett Edmondson, MCITP has 10+ years experience working with the full Microsoft BI Stack. He has built several Operational and Financial Data Warehouses for large and small organizations. . During the past year he has been working on Microsoft’s Parallel Data Warehouse (PDW) Appliance, which allows SQL Server to scale to hundreds of terabytes.
Wendy Pastrick
Twitter: - @wendy_dance
Contact: http://wendyverse.blogspot.com
Wendy Pastrick is from Chicago, IL, and for the past 15 years has served as a Database Administrator supporting both development and production environments. Her many years of involvement with PASS include WIT Virtual Chapter and the Chicago Suburban User Group, serving as Regional Mentor, and as a PASS Board member since 2013. Wendy has organized several highly successful SQLSaturday events in Chicago.
Sponsors
The following is a list of sponsors that helped fund the event: