SQLSaturday #13 - Atlanta 2009
Event Date: 04/25/2009 00:00:00
Event Location:
- Microsoft
- 1125 Sanctuary Parkway
- Alpharetta, Georgia
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: SSIS Internals and Optimization
Abstract: This session dives deep into the underlying structure of the SSIS data flow pipeline in order understand how the SSIS engine is handling your data and how to monitor and optimize your data flow design. This review includes a drill-down into the data buffer architecture, execution trees, engine threads, column lineage, synchronous and asynchronous transformation outputs, data flow buffer tuning, pipeline monitoring, pipeline optimization, error identification and troubleshooting. Understanding the pipeline internals will lead to better package designs with more efficient and scalable data flow architectures for your SSIS environment.
Speaker(s):
- Erik Veerman
Track and Room: BI 2 - N/A
Title: End-to-End Troubleshooting
Abstract: Learning how to detect, diagnose and resolve performance problems in SQL Server can be very difficult. It often takes years of on-the-job experience to learn how to use the tools and techniques that help you detect when a problem is occurring, diagnose the root-cause of the problem, and then resolve the problem. This hands-on session will take you from the very start of a problem situation on SQL Server, showing you how to use the native tools that help you keep SQL Server at top performance. This session will detail and demonstrate:
- Performance Monitor (PerfMon)
- SQL Profiler/Server-side Trace
- Correlating PerfMon and Profiler results
- Graphic Explain Plan and Transact-SQL Showplan
- SQL Server 2005 and 2008 DMVs
- When to
Speaker(s):
- Kevin Kline
Track and Room: DBA - N/A
Title: Wait-Time SQL Server Performance Management
Abstract: There are many ways to use SQL Server Wait types for performance tuning of a Microsoft database, but often there is confusion on exactly what the data means. The issue typically centers around the fact the wait event data is analyzed at the wrong level or the collected wait event data is not detailed enough. This presentation will focus on these problems and review several real-life case studies of using wait type data coupled with Wait-Time based performance analysis to solve the most difficult performance related issues.
Speaker(s):
- Janis Griffin
Track and Room: DBA 2 - N/A
Title: Surviving the Data Avalanche
Abstract: The SQL Server database platform is hosting larger and larger databases. But the industry term “Very Large Database” (VLDB) is more difficult to define than ever with multi-terabyte database becoming very common. This session will answer questions like:
- How do I configure my SQL Server instances to support multi-terabyte databases?
- What risks and problems do VLDBs pose?
- How do I overcome issues presented by VLDBs?
Administrating and protecting very large databases is extremely difficult and very hard to learn except through direct experience. This session helps you learn from the experiences of others so that you can apply their lessons learned and mitigate your risks before you ever experience them.
Speaker(s):
- Kevin Kline
Track and Room: BI - N/A
Title: How to Build Analysis Services Cubes (2005/2008)
Abstract: This session will walk through building an Analysis Services Cube in SQL Server 2005 and 2008. It will also cover real world project roadmaps, common mistakes and basic dimensional modeling concepts.
Speaker(s):
- Jen Underwood
Track and Room: BI - N/A
Title: SQL Server Auditing Using the CLR
Abstract: Database auditing is something everyone would like their databases to do, but implementing it without slowing data access down can be difficult. In this session I will show you how to use the CLR to create triggers that do not have a big performance hit and do not have to be rewritten if the tables change.
Speaker(s):
- Lee Johnson
Track and Room: BI 2 - N/A
Title: SQL Clustering Essentials
Abstract: Come learn how to take some of the mystique out of SQL Clustering. Learn how to build, migrate, and operate SQL Server Clustering using the newest Windows Server 2008 Operating system.
Speaker(s):
- Geoff Hiten
Track and Room: DBA 2 - N/A
Title: Why Normalization Matters
Abstract: In this session I will give an overview of the common normal forms and show why they should matter to you if you are creating or modifying SQL Server databases. Data should be easy to work with in SQL Server if the database has been organized as close as possible to the standards of normalization that have proven for many years. Many common T-SQL programming “difficulties” are the result of struggling against the way data should be structured and can be avoided by applying the basic normalization techniques and are obvious things that you find yourself struggling with time and again (i.e. using the SUBSTRING function in a WHERE clause meaning you can’t use an index efficiently). Properly structured data structures make it easier to work wit
Speaker(s):
- Louis Davidson
Track and Room: Development - N/A
Title: SSRS Working with Images and Subreports
Abstract: Session will cover working with images and subreports. I will cover real world examples of issues encountered when working with images and subreports. Examples will include “conditional subreports”.
Speaker(s):
- Curtis Smith
Track and Room: BI 2 - N/A
Title: XML Features in SQL 2005
Abstract: XML in SQL 2000 wasn’t very exciting and it was easy to dismiss it altogether by just relying on developers to handle any XML needed within the application. SQL 2005 changes the game and this session will show you how to use the new XML data type, do basic XML operations on XML data, and showcase the changes to FOR XML that make it so much more useful. This isn’t a session to convince you to use XML, but to show you what you can do with XML if you do need to use it!
Speaker(s):
- Kendal Van Dyke
Track and Room: Development - N/A
Title: Building Reporting Services and Excel Reports
Abstract: This session will walk through building reports in Reporting Services 2008 and Excel 2007 that query data from Analysis Services Cubes. It will also explain a variety of reporting solution architecture options using Microsoft’s Business Intelligence technologies.
Speaker(s):
- Jen Underwood
Track and Room: BI - N/A
Title: Smokin’ Mirrors - SQL Mirroring Technology
Abstract: In this session I will demonstrate how to configure Mirroring for both high availability and offloading reporting stress via database snapshots. I will also cover the different modes of mirroring and how they may affect performance.
Speaker(s):
- Michael Mollenhour
Track and Room: DBA - N/A
Title: SQLSaturday Super Short Session I
Abstract: This session is actually 4 sessions in one. Speakers will each take 15 minutes to demonstrate something in SQL Server; it could be shortcuts in Management Studio, setting up and using a particular 3rd-party tool, or a code snippet. Slide decks are discouraged; the focus is on demonstrating “how-to” do something.
Speaker(s):
- Stuart Ainsworth
Track and Room: Development 2 - N/A
Title: Fortress SQL Server
Abstract: We’ll look at best practices for securing SQL Server and the data contained within from both a DBA and developer perspective. Starting with the basics of how to relate security to business personnel, we’ll then dive in to the technical aspects of locking down SQL Server. SQL Server 2000 through 2008 will be covered.
Speaker(s):
- Brian Kelley
Track and Room: BI - N/A
Title: Mining for Data the SQL 2008 way
Abstract: In this session I will demonstrate datamining with SQL Analysis Services. This session will demonstrate the analytic powers incorporated into the SQL AS Engine, and show how these can be integrated with Reporting Services and Excel.
Speaker(s):
- Michael Mollenhour
Track and Room: BI 2 - N/A
Title: SQLSaturday Super Short Session II
Abstract: This session is actually 4 sessions in one. Speakers will each take 15 minutes to demonstrate something in SQL Server; it could be shortcuts in Management Studio, setting up and using a particular 3rd-party tool, or a code snippet. Slide decks are discouraged; the focus is on demonstrating “how-to” do something.
Speaker(s):
- Stuart Ainsworth
Track and Room: Development 2 - N/A
Title: Disk Performance Hands On
Abstract: Would you buy a million dollar race car then show up to the track on a clear day with rain tires that aren’t properly inflated and wonder why you’re only doing 180 when the manufacturer says it can do 220?
Your answer was probably close to something like “Of course not!”. Now let’s suppose that your “million dollar race car” is really your DB server and your “tires” are your hard drives. Do you know the right configuration to use to get the best performance out of them? Sure, there’s RAID 1, RAID 10, and RAID 5…but do you know which combination of partition offset, RAID stripe size, and allocation unit size to use?
Speaker(s):
- Kendal Van Dyke
Track and Room: DBA - N/A
Title: CLR integration
Abstract: Integrating CLR assemblies to support custom image creation and encompassing complex business logic in SQL server/SSRS.
Speaker(s):
- Sergey Barskiy
Track and Room: Development - N/A
Title: Nested Sets Model - Trees Hierarchies in SQL
Abstract: A look at the programing techniques for Trees Hierarchies using the nested sets model. The stress will be on avoidance of recursive CTE and cursor programming.
Speaker(s):
- Joe Celko
Track and Room: Development - N/A
Title: Data Mining Beyond Adventure Works
Abstract: Microsoft provides excellent tutorials and information about data mining through the fictional Adventure Works demos. However, what happens when you stray off that neat-and-tidy path? Data miners should be concerned about data preparation, proper algorithm selection, and correct interpretation. This interactive experience will consist of succinct audience participation demos to introduce some practical issues in real-world data mining.
Speaker(s):
- Mark Tabladillo
Track and Room: BI 2 - N/A
Title: An Introduction to SQL Server 2008 Features
Abstract: Both developers and Administrators will learn new features of SQL 2008 designed to improve productivity and manageability. Focusing on breadth rather than depth, this session will give data professionals just enough information to decide whether a specific feature is worth their time to investigate more fully.
Speaker(s):
- Geoff Hiten
Track and Room: DBA - N/A
Title: Consolidating Your Database Infrastructure
Abstract: Suffering from server sprawl? Licensing fees killing your budget? Too many databases, not enough DBAs? These are all issues driving organizations to start consolidating their SQL Server infrastructure to reduce costs, improve administrative efficiencies, and increase performance. This session will present a methodology that can be applied to your database environment to consolidate and save big! Whether you are a database architect, DBA or manager, you’ll be able to apply what you learn in this session to get results.
Speaker(s):
- Tom Mills
Track and Room: DBA 2 - N/A
Title: Introduction to SQL Server Full Text Searching
Abstract: Users have become familiar with the simple search capabilities of tools like Microsoft Live Search and Google. Did you know you can give your users the same ability to search their data with SQL Server? And it’s as easy as 1-2-3! Come and learn the how to setup and use full text searching with SQL Server.
Speaker(s):
- Robert Cain
Track and Room: Development 2 - N/A
Title: Introduction to Data Warehouse Concepts
Abstract: Business Intelligence is one of the top five skillsets for 2009. In this introductory course you can learn the basics of data warehousing, including design, population, analysis and reporting with a focus on the SQL Server toolset.
Speaker(s):
- Robert Cain
Track and Room: Development - N/A
Title: ADO.NET Data Services for DBAs
Abstract: The idea of exposing data across the Internet is a scary thought for most DBAs, but ADO.NET Data Services provides the security to allow you to feel better about how its handled. Since so many applications now require the Internet, ADO.NET Data Services represents a sensible way to provide that data. Come to this talk to be talked down from the ledge of fear about the technology.
Speaker(s):
- Shawn Wildermuth
Track and Room: DBA 2 - N/A
Title: SANs and SQL Server
Abstract: Lets dig into both the fundamentals and details of how SANs work and how we can best utilize them to improve SQL Server’s IO performance and reliability.
Speaker(s):
- Kevin Boles
Track and Room: DBA 2 - N/A
Title: Introduction to SQL Server Statistics
Abstract: This beginner to intermediate level session will introduce you to statistics, including how to create, manage, troubleshoot, and more! Statistics are a key part of getting solid and repeatable performance and is easily just as important as having indexes. Whether you’re a DBA or trying to get by without one, this session will give you the information you need to know.
Speaker(s):
- Andy Warren
Track and Room: DBA - N/A
Title: Using MSchema in Project Lifecycles
Abstract: While tools like Visual Studio’s Database projects can help build and version databases, Oslo’s new MSchema language can provide a powerful abstraction from the minutea of data models. In this talk I will show you how to use MSchema for build/deployment scenarios and using it to version your schemas.
Speaker(s):
- Shawn Wildermuth
Track and Room: Development 2 - N/A
Title: Effective T-SQL Solutions
Abstract: This session will present five short examples of solutions to real business world problems based on T-SQL or Visual Studio.
Speaker(s):
- Noah Subrin
Track and Room: Development - N/A
Title: SQL Server 2008 Date / Time Data Types
Abstract: This session provides an overview of date / time data types, comparing capabilities and benefits of the new types in SQL Server 2008 with those from prior versions. A process will be presented on how to profile date / time data content in current tables, to better understand the implications (data preservation or loss) in migrating existing date / time data types to the newer types. Tools to simplify the data profiling process will be demonstrated.
Speaker(s):
- Scott Russell
Track and Room: Development 2 - N/A
Title: A Lap Around Partitioning
Abstract: Data volumes continue to grow and it is extremely important to know the features available to manage that growth. Whitney Weaver will discuss the partitioning functionality implemented in SQL 2005 and 2008 that will help you take your data applications to the next level.
Speaker(s):
- Whitney Weaver
Track and Room: DBA 2 - N/A
Title: Disk Partition Alignment
Abstract: EVERYONE can benefit from this presentation!! Improper disk alignment will rob the server of 15-50% IO throughput capability. We will cover what disk partition alignment really is, how it affects performance and how you can get it done correctly.
Speaker(s):
- Kevin Boles
Track and Room: DBA - N/A
Title: Data Mining ASP.Net Controls Library
Abstract: Intent of this session is to demonstrate use of Data Mining Web Controls Library with web applications. Data Mining Web Controls Library is a library intended to extend the data mining user experience in Microsoft SQL Server Analysis Services to the Web. This library provides a lightweight version of the data mining model viewers. Using Data Mining Web Controls, you can browse complex mining models from any computer that has Microsoft Internet Explorer installed.
Speaker(s):
- Tejas Patel
Track and Room: BI - N/A
Title: Introduction to SQL Server Integration Services
Abstract: SQL Server Integration Services is Microsoft’s powerful tool for doing ETL (Extract, Transform, and Load) in the Business Intelligence arena. In this introductory course you can get up to speed on the basic tools of ETL and learn how to leverage SSIS not just for BI but for data conversion as well.
Speaker(s):
- Robert Cain
Track and Room: BI - N/A
Title: Solving real world problems with meta data
Abstract: SQL Server makes available a tremendous amount of meta data about the internal workings of the product. Join Whitney Weaver to see how many common DBA and developer tasks can be accomplished via the meta data in system views and DMVS.
Speaker(s):
- Whitney Weaver
Track and Room: Development - 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.
Robert Cain
Twitter: - https://twitter.com/arcanecode
LinkedIn: Robert Cain
Contact: http://arcanecode.com
Robert C. Cain (http://arcanecode.com) is a Microsoft MVP, MCTS Certified in BI, and is the owner of Arcane Training and Consulting, LLC. He is also a course author for Plurasight, author for Red Gate’s SImple Talk website, and co-author of 4 books. A popular speaker, Robert has presented at events such as the SQL PASS Summit, TechEd, CodeStock, and numerous SQLSaturdays. Robert has over 25 years experience in the IT industry, working in a variety of fields ranging from manufacturing to telecommunications to nuclear power.
Joe Celko
Joe Celko served 10 years on ANSI/ISO SQL Standards Committee and contributed to the SQL-89 and SQL-92 Standards.
He has written over 1200 columns in the computer trade and academic press, mostly dealing with data and databases.
He is author of eight books on SQL for Morgan-Kaufmann: SQL FOR SMARTIES (1995, 1999, 2005, 2010), SQL PUZZLES ANSWERS (1997, 2006), DATA DATABASES (1999) and TREES HIERARCHIES IN SQL (2004), SQL PROGRAMMING STYLE (2005) and ANALYTICS OLAP IN SQL (2005) and THINKING IN SETS (2008).
Mr. Celko’s past columns include: Columns for Simple-Talk (Redgate Software); “CELKO” in INTELLIGENT ENTERPRISE magazine (CMP); BMC’s DBAzine.com e-magazine; “SQL Explorer” in DBMS (Miller-Freeman); “Celko on SQL” in DATABASE PROGRAMMING DESIGN (Miller-Freeman); “WATCOM SQL Corner” in POWERBUILDER DEVELOPERS’ JOURNAL (SysCon); “SQL Puzzle” in BOXES ARROWS (Frank Sweet Publishing); “DBMS/Report” in SYSTEMS INTEGRATION (Cahner-Ziff); “Data Desk” in TECH SPECIALIST (RD); “Data Points” in PC TECHNIQUES (Coriolis Group); “Celko on Software” in COMPUTING (VNC Publications, UK), “SELECT * FROM Austin” (Array Publications, The Netherlands), and he was editor for the “Puzzles Problems” section of ABACUS (Springer-Verlag) and he ran the CASEFORUM section 18, “Celko on SQL”, on CompuServe.
Jen Underwood
Twitter: - @idigdata
LinkedIn: Jen Underwood
Contact: http://www.impactanalytix.com/
Jen Underwood, a Senior Director at DataRobot, has held worldwide analytics product management roles at Microsoft and served as a technical lead for system implementation firms. She has over 20 years of experience launching new products and turning around failed projects in enterprise data warehousing, reporting, and advanced analytics. Today she designs product and helps analytics professionals learn how to solve complex problems with machine learning in the emerging citizen data science segment.
Jen has a Bachelor of Business Administration – Marketing, Cum Laude from the University of Wisconsin, Milwaukee and a post-graduate certificate in Computer Science – Data Mining from the University of California, San Diego.
Michael Mollenhour
Mike has worked with Database performance and troubleshooting for over 20 years. His experience has been gained from both Large Corporations (Citi-Group) to smaller organizations. Mike currently works as an Independent Contractor.
Stuart Ainsworth
Twitter: - @codegumbo
LinkedIn: Stuart Ainsworth
Contact: http://codegumbo.com
Stuart Ainsworth (MA, MEd) manages a team of Service Reliability Engineers for the Gladiator Enterprise Information Security Services section of Profitstars, a division of Jack Henry and Associates. He’s a former DBA, developer, consultant, and public speaking professor. He’s one of the chapter leaders for AtlantaMDF, and a long-time organizer of SQLSaturday’s. He tweets infrequently (@codegumbo) and blogs even less often at http://codegumbo.com.
Mark Tabladillo
Contact: http://www.marktab.com
Mark Tabladillo provides consulting and training for data mining with Solid Quality Mentors. He has a PhD in applied statistics from Georgia Tech. He has taught statistics at Georgia Tech and for the graduate business school of the University of Phoenix. In addition to his Microsoft certifications, Mark has years of deep experience with the SAS System, and has presented at many local, regional, and national technical conferences.
Geoff Hiten
Twitter: - SQLCraftsman
LinkedIn: Geoff Hiten
Microsoft MVP Geoff Hiten is a Principal SQL Server consultant for Intellinet.#160; Geoff began working with SQL Server in 1992 with version 4.2 and has used every version since.#160; He specializes in high-availability and high-performance SQL systems.#160; Recent projects include: system upgrades, SQL Server platform migrations, performance tuning, custom reporting solutions, and database strategy implementations.#160;#160; Geoff is currently on the leadership team of the Atlanta area Microsoft Database Forum Use
Tom Mills
Contact: http://blogs.msdn.com/tommills
Tom Mills is a consultant with Microsoft Consulting Services specializing in the areas of database and business intelligence. His 14 years of experience cover a wide range of Microsoft technologies including database, application development and system engineering. Tom is a certified MCITP, MCSD.NET and MCSE. He also has a wide range of business and industry experience including vertical markets such as travel and transportation, automotive, manufacturing, government and public sector, a
Robert Cain
Twitter: - https://twitter.com/arcanecode
LinkedIn: Robert Cain
Contact: http://arcanecode.com
Robert C. Cain (http://arcanecode.com) is a Microsoft MVP, MCTS Certified in BI, and is the owner of Arcane Training and Consulting, LLC. He is also a course author for Plurasight, author for Red Gate’s SImple Talk website, and co-author of 4 books. A popular speaker, Robert has presented at events such as the SQL PASS Summit, TechEd, CodeStock, and numerous SQLSaturdays. Robert has over 25 years experience in the IT industry, working in a variety of fields ranging from manufacturing to telecommunications to nuclear power.
Erik Veerman
Erik Veerman is the Director of Business Intelligence for SolidQ focusing on the SQL Server BI platform. His industry recognition includes Microsoft’s Worldwide BI Solution of the Year and SQL Server Magazine’s Innovator Cup winner. Erik is the lead author for the Microsoft Press BI Training Kits and a co-author of several WROX Integration Services titles.
Erik has designed dozens of BI solutions across a broad business spectrum-telecommunications, marketing, retail, commercial real estate, finance, supply chain, and information technology. His experience with high volume multi-terabyte environments has enabled clients to scale their Microsoft-based BI solutions for optimal potential. As an expert in OLAP design, ETL processing, and dimensional modeling, Erik is a presenter, author and instructor. He led the ETL architecture and design for the first production implementation of Integration Services (SSIS) and helped drive the ETL standards and best practices for SSIS on Microsoft’s SQL Server reference initiative, Project REAL.
As a resident of Atlanta, Erik often speaks at the Atlanta PASS Chapter user group. Furthermore, he has presented at the PASS summit for the last several years as well as the SQL Connections conference, and is often a speaker for the SQL Server Magazine road-shows and for Microsoft launch events.
Robert Cain
Twitter: - https://twitter.com/arcanecode
LinkedIn: Robert Cain
Contact: http://arcanecode.com
Robert C. Cain (http://arcanecode.com) is a Microsoft MVP, MCTS Certified in BI, and is the owner of Arcane Training and Consulting, LLC. He is also a course author for Plurasight, author for Red Gate’s SImple Talk website, and co-author of 4 books. A popular speaker, Robert has presented at events such as the SQL PASS Summit, TechEd, CodeStock, and numerous SQLSaturdays. Robert has over 25 years experience in the IT industry, working in a variety of fields ranging from manufacturing to telecommunications to nuclear power.
Janis Griffin
Twitter: - DoBoutAnything
LinkedIn: Janis Griffin
Janis Griffin has over 30 years of DBA/database experience including design, development and implementation of many critical database applications. Before coming to Quest Software, Janis primarily worked in the Telecom/Network Industry, working with both real-time network routing databases and OLTP business to business applications. Janis also held positions as a Principal Architect and Senior Manager, mentoring other DBAs on best practices in database performance tuning.
Kevin Kline
Contact: http://KevinEKline.com
Kevin Kline is the Director of Engineering Services at SQL Sentry. A Microsoft SQL Server MVP, Kevin is a founding board member of PASS, editor-in-chief of SQLServerPedia.com and the author of popular IT books like “SQL in a Nutshell” (O’Reilly Associates). His twitter handle is @kekline and he blogs at http://KevinEKline.com. Kevin is a top-rated speaker at industry trade shows and has been active in the IT industry for over 20 years.
Andy Warren
Twitter: - @sqlandy
Contact: https://sqlandy.com
Andy Warren is a SQL Server consultant and trainer based in Orlando, FL. Focusing on administration, performance tuning, and SQL Server patterns and practices, he’s been a SQL Server MVP since 2008. Andy served two terms on the PASS Board of Directors, was a founding principal in SQLServerCentral, and created both the SQLSaturday and SQLRally event models.
Louis Davidson
Twitter: - drsql
LinkedIn: Louis Davidson
Contact: https://www.red-gate.com/simple-talk/author/louis-davidson/
Louis Davidson has worked in the IT industry for over 25 years as a corporate database developer and architect. He has been a Microsoft SQL Server MVP for 15 years and has written five books on database design, and contributed to many other SQL Server books as an author and tech editor. He has a bachelor’s degree in Computer Science from the University of Tennessee at Chattanooga. You can read more about Louis at http://drsql.org.
Kendal Van Dyke
Twitter: - SQLDBA
LinkedIn: Kendal Van Dyke
Contact: http://www.kendalvandyke.com
Kendal is a database strategist, community advocate, public speaker, and blogger. A practiced IT professional with over 15 years of SQL Server experience, Kendal excels at disaster recovery, high availability planning/implementation, amp; debugging/troubleshooting mission critical SQL Server environments. Kendal is a Senior Consultant on the Microsoft Premier Developer Support team and President of MagicPASS (http://magicpass.sqlpass.org), the Orlando, FL based chapter of PASS. Before joining Microsoft, Kendal was a SQL Server/Data Platform MVP from 2011-2016.
Whitney Weaver
Contact: http://whitneyweaver.com
Whitney Weaver is a Principal Consultant with Magenic Technologies. He focuses on data technologies within the Microsoft product line. Over the past 10 years he has implemented SQL Server solutions for a number of industries including Energy Management, Financial Services, Health Insurance, Manufacturing, and State Government. Whitney regularly speaks at user groups and other developer events.
Brian Kelley
Twitter: - kbriankelley
LinkedIn: Brian Kelley
Contact: https://truthsolutions.wordpress.com/
Brian Kelley is an author, columnist, Certified Information Systems Auditor (CISA), accredited CISA trainer, and former Microsoft Data Platform (SQL Server) MVP (2009-2016) focusing primarily on SQL Server and Windows security. Brian currently serves as a data architect as well as an independent infrastructure/security architect concentrating on Active Directory, SQL Server, and Windows Server. He has served in a myriad of other positions including senior database administrator, data warehouse architect, web developer, incident response team lead, and project manager. Brian has spoken at 24 Hours of PASS, the Marathon of PASS, IT/Dev Connections, SQLConnections, the SSWUG Virtual Conferences, the Techno Security and Forensics Investigation
Michael Mollenhour
Mike has worked with Database performance and troubleshooting for over 20 years. His experience has been gained from both Large Corporations (Citi-Group) to smaller organizations. Mike currently works as an Independent Contractor.
Stuart Ainsworth
Twitter: - @codegumbo
LinkedIn: Stuart Ainsworth
Contact: http://codegumbo.com
Stuart Ainsworth (MA, MEd) manages a team of Service Reliability Engineers for the Gladiator Enterprise Information Security Services section of Profitstars, a division of Jack Henry and Associates. He’s a former DBA, developer, consultant, and public speaking professor. He’s one of the chapter leaders for AtlantaMDF, and a long-time organizer of SQLSaturday’s. He tweets infrequently (@codegumbo) and blogs even less often at http://codegumbo.com.
Kevin Kline
Contact: http://KevinEKline.com
Kevin Kline is the Director of Engineering Services at SQL Sentry. A Microsoft SQL Server MVP, Kevin is a founding board member of PASS, editor-in-chief of SQLServerPedia.com and the author of popular IT books like “SQL in a Nutshell” (O’Reilly Associates). His twitter handle is @kekline and he blogs at http://KevinEKline.com. Kevin is a top-rated speaker at industry trade shows and has been active in the IT industry for over 20 years.
Shawn Wildermuth
Contact: http://wildermuth.com
Shawn Wildermuth is a Microsoft MVP (C#), member of the INETA Speaker’s Bureau and an author of six books on .NET. Shawn is involved with Microsoft as a Silverlight Insider, Data Insider and Connected Technology Advisors (WCF/Oslo/WF). He has been seen speaking at a variety of international conferences including SDC Netherlands, VSLive, WinDev and DevReach. Shawn has written dozens of articles for a variety of magazines and websites including MSDN, DevSource, InformIT, CoDe Magazine, ServerSide.
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.
Shawn Wildermuth
Contact: http://wildermuth.com
Shawn Wildermuth is a Microsoft MVP (C#), member of the INETA Speaker’s Bureau and an author of six books on .NET. Shawn is involved with Microsoft as a Silverlight Insider, Data Insider and Connected Technology Advisors (WCF/Oslo/WF). He has been seen speaking at a variety of international conferences including SDC Netherlands, VSLive, WinDev and DevReach. Shawn has written dozens of articles for a variety of magazines and websites including MSDN, DevSource, InformIT, CoDe Magazine, ServerSide.
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.
Sergey Barskiy
Contact: http://sergeybarskiy.spaces.live.com/default.aspx
Sergey Barskiy is a principal consultant with Magenic Technologies. He has been developing applications solely based on Microsoft technologies since mid 90s and working exclusively with .NET since 2003. He has been working with SQL Server since 2001. He presented on various topics at Atlanta CodeCamp, GGMUG and Atlanta .NET users group.
Tejas Patel
Contact: http://intenseanalytics.com/default.aspx
Tejas Patel is a Business Intelligence Architect with EyeWonder, LLC. He has 8+ years of experience working in Business Intelligence field. He is a frequent presenter on local and regional technical conferences and events. He has designed and developed enterprise level Business Intelligence Solutions for many fortune 500 companies.
Curtis Smith
Curtis is a senior consultant with Magenic Technologies. He has over 10 years experience working with SQL Server and designing business reports. As a former VP of Software development for a pediatric home healthcare company, he has been involved in application development from conception thru development and implementation.
Kendal Van Dyke
Twitter: - SQLDBA
LinkedIn: Kendal Van Dyke
Contact: http://www.kendalvandyke.com
Kendal is a database strategist, community advocate, public speaker, and blogger. A practiced IT professional with over 15 years of SQL Server experience, Kendal excels at disaster recovery, high availability planning/implementation, amp; debugging/troubleshooting mission critical SQL Server environments. Kendal is a Senior Consultant on the Microsoft Premier Developer Support team and President of MagicPASS (http://magicpass.sqlpass.org), the Orlando, FL based chapter of PASS. Before joining Microsoft, Kendal was a SQL Server/Data Platform MVP from 2011-2016.
Noah Subrin
Contact: http://blogs.federalsystems.net
Noah is a Technical Lead for SRA International and supports a large government customer in Chamblee, GA. In this role, he leads a team of software developers who support critical customer functions including e-Workforce Management and data warehousing. Noah has extensive experience as a software developer, consultant, and architect. He is a Microsoft Certified Solution Developer for .Net (MCSD .Net) and has worked for several Microsoft partners. Prior to joining SRA, Noah worked with IBM for ele
Jen Underwood
Twitter: - @idigdata
LinkedIn: Jen Underwood
Contact: http://www.impactanalytix.com/
Jen Underwood, a Senior Director at DataRobot, has held worldwide analytics product management roles at Microsoft and served as a technical lead for system implementation firms. She has over 20 years of experience launching new products and turning around failed projects in enterprise data warehousing, reporting, and advanced analytics. Today she designs product and helps analytics professionals learn how to solve complex problems with machine learning in the emerging citizen data science segment.
Jen has a Bachelor of Business Administration – Marketing, Cum Laude from the University of Wisconsin, Milwaukee and a post-graduate certificate in Computer Science – Data Mining from the University of California, San Diego.
Lee Johnson
I have been a professional programmer since 1995. I have worked in such fields as point of sale, internet communications, gage management, warehouse inventory, and accounting. Early in my career I was specialized in communications, anything from RS232 to Winsock to low level protocols. The past few years I have been with CSI and specialized in data conversion and database development. I have tutored all the programming and database classes at Greenville Tech for 4 years.
Scott Russell
Scott Russell started working with SQL Server using pre-release version 4.2 on pre-release Windows NT 3.1. He currently works as a senior DBA at RPC in Atlanta. Scott has extensive experience in IT, including roles in database architecture and administration, technology planning, development, and operations. He received BS and MS degrees from Georgia Tech in Information and Computer Science.
Geoff Hiten
Twitter: - SQLCraftsman
LinkedIn: Geoff Hiten
Microsoft MVP Geoff Hiten is a Principal SQL Server consultant for Intellinet.#160; Geoff began working with SQL Server in 1992 with version 4.2 and has used every version since.#160; He specializes in high-availability and high-performance SQL systems.#160; Recent projects include: system upgrades, SQL Server platform migrations, performance tuning, custom reporting solutions, and database strategy implementations.#160;#160; Geoff is currently on the leadership team of the Atlanta area Microsoft Database Forum Use
Whitney Weaver
Contact: http://whitneyweaver.com
Whitney Weaver is a Principal Consultant with Magenic Technologies. He focuses on data technologies within the Microsoft product line. Over the past 10 years he has implemented SQL Server solutions for a number of industries including Energy Management, Financial Services, Health Insurance, Manufacturing, and State Government. Whitney regularly speaks at user groups and other developer events.
Sponsors
The following is a list of sponsors that helped fund the event: