SQLSaturday #61 - DC 2010
Event Date: 12/04/2010 00:00:00
Event Location:
- Microsoft Technology Center
- 12012 Sunset Hills Rd
- Reston, Virginia
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: Processing Flat Files with SSIS
Abstract: When doing data integration, a common requirement is to work with flat files, whether for importing data into a system from an external source, or to export it to provide to other systems. SQL Server Integration Services (SSIS) supports flat files, but there can be a number of challenges when working with them. This is particularly true if your flat files have multiple data formats contained in a single file, the data has complex formatting, or the files have inconsistent formatting. This session will help you to be more efficient when working with these types of files. You’ll learn to handle missing delimiters in the files, and parsing files that have multiple data formats.
Speaker(s):
- John Welch
Track and Room: BI - N/A
Title: Table Partitioning: Evaluation, Planning, Options
Abstract: Does SQL Server’s table partitioning feature offer performance improvements, manageability benefits, or both? Table partitioning is a significant investment: it’s important to understand many aspects of the feature to evaluate where it might be useful to applications. This session will cover basic concepts of table partitioning. We’ll discuss where the feature can be applied, its benefits, and changes that partitioning may require to existing database schema. Special considerations for management of partitioned tables will be discussed, as well as potential changes to query optimization and plans. New SQL 2008 R2 features for partitioning will be included in the discussion.
Speaker(s):
- Kendra Little
Track and Room: DBA - N/A
Title: Partitioning in SQL Server 2005/2008
Abstract: Starting with SQL Server 2005, Microsoft has made a significant effort to truly streamline partitioning data to be on par with industry leading databases like Oracle. The potential was not fully harnessed by the SQL Server community primarily due to the lack of any user interface associated with partitioning and due to lack of cohesive documentation. For many, Kimberly Tripp’s white paper on “Partitioned Tables and Indexes in SQL Server 2005” is generally regarded as a primary guiding source that bridges the void in MS documentation. Come and get a quick start on partitioning. It is simple and efficient. Manageability and performance come part and parcel.
Speaker(s):
- Jana Sattainathan
Track and Room: DBA - N/A
Title: SQL and SEO - the FUZION of data and marketing
Abstract: Bringing marketing together with technology is a fine art that involves high tech tools, real life solutions, and most important human buy-in from the marketing and IT departments. This lecture will delve into the use of the latest SQL Server 2005 and SQL Server 2008 technologies including recursive common table expressions (CTE), hierarchical data models, and CLR stored procedures for the IT side of the house while also delving into the use of analytics, webmaster monitoring tools, web marketing tactics and search engine optimization techniques for the more marketing minded. Neither SQL nor SEO are four letter words and they go together perfectly! So too can your IT and marketing departments as you tackle the new age of IT Marketing.
Speaker(s):
- Jared Nielsen
Track and Room: DBA/DEV Advanced - N/A
Title: Design and Implement BI Like Edison!
Abstract: As the most prolific inventor in American history, Thomas Edison was a master of “Best Practices!” Edison’s creations were not just novel and commercially successful, but many launched entire new industries including electric light and power, sound recording, motion pictures and industrial cement and concrete manufacture. At the heart of Edison’s remarkable record of innovation was his categorization of the innovation process into “competencies,” or bundles of skills supporting the achievement of success in a particular area of endeavor. In this session, we will look at ways that we can use many of these broad success secrets to bring powerful tools and strategies to the recurring implementation of business intelligence solutions.
Speaker(s):
- William E Pearson III
Track and Room: BI - N/A
Title: Introduction to Incremental Loads
Abstract: This session if for SSIS developers and DBAs. Attend and learn more about Transact-SQL and SSIS design patterns for loading data incrementally. The session includes two demos: Incremental Loads in Transact-SQL; and Incremental Loads in SSIS.
Speaker(s):
- Andy Leonard
Track and Room: Database Development - N/A
Title: Data Files and Transaction Logs – Beyond the GUIs
Abstract: Performance of SQL Server poor? One cause may have been that starting file size that you didn’t think was important because it will auto-grow. Why is auto-grow bad? Why shouldn’t files be auto-shrunk? Why keep that free space in the files? Explore the physical structure of a database, how table structure effects use of memory and key mistakes to avoid. Additionally, dive into the transaction log process - VLFs, auto-recovery and lock escalation. Solid foundation for Programmers and Administrators!
Speaker(s):
- Sandra Mueller
Track and Room: DBA - N/A
Title: Automate Policy-Based Management using PowerShell
Abstract: The Policy-Based Management feature in SQL Server 2008 provides a great way to ensure your systems are configured consistently and correctly, but it can be tedious to implement on each server in your environment. PowerShell scripts allow you to automate the implementation of your policies so you can focus on more important problems. This session will walk you through how PBM works, how to define your policies in PowerShell, and how to set up Agent jobs to evaluate those policies regularly to let you know when you need to take action.
Speaker(s):
- Allen White
Track and Room: DBA/DEV Advanced - N/A
Title: Performance Tuning Made Easy
Abstract: Performance tuning is hard, everyone knows that. Attend this session and learn how to define, measure, and analyze performance issues as well as implementing changes and also how to make sure those changes continue to have the desired effects. In short, I break down performance tuning into pieces that anyone can understand. Leave this session knowing what actions to take when you get back to work on Monday.
Speaker(s):
- Thomas LaRock
Track and Room: DBA - N/A
Title: Gather SQL Server Performance Data with PowerShell
Abstract: We all know how important it is to keep a baseline of performance metrics that allow us to know when something is wrong and help us to track it down and fix the problem. We don’t always know how to do this easily and consistently. This session will walk you through a series of PowerShell scripts you can schedule which will capture the most important data and a set of reports to show you how to use that data to keep your server running smoothly.
Speaker(s):
- Allen White
Track and Room: DBA/DEV Advanced - N/A
Title: SQL Server Performance Related DMVs
Abstract: There are number of tools available on the market for the SQL Server performance troubleshooting. But do we use the full power of the internal SQL Server Data Management Views (DMVs)? Some very challenging issues can be solved using DMVs. What the Dynamic Management Views are? How diagnostics data is getting populated? Using the examples we are going to talk about diagnostic data analysis using T-SQL queries against SQL Server DMVs.
Speaker(s):
- Sergey Pustovit
Track and Room: DBA - N/A
Title: DBA Disaster Recovery Techniques To Keep Handy
Abstract: Nothing is more frightening to a DBA as getting that wake-up phone call that the system is down, especially when it’s a mission critical one.This session will focus on being prepared for and dealing with a recovery situation for a SQL Server 2005/2008 database, an instance or an entire server. Topics covered will be backup schemes, partial backups and piecemeal restores, and page-level recovery
Speaker(s):
- Edwin Sarmiento
Track and Room: DBA/DEV Advanced - N/A
Title: SSIS for real: A walk through a real world project
Abstract: In this presentation I will walk though a complete real-world SSIS project that pulls data from an AS/400 and converts it to a SQL Server destination. In addition to specific AS/400 conversion issues I will also cover topics like dynamic OLEDB connections, and creating an effective work flow. Along the way we’ll take a look at how I use Derived Columns, Conditional Split, Lookup, and Script components to solve every day conversion issues.
Speaker(s):
- Joel Cochran
Track and Room: Database Development - N/A
Title: Presentation WOW!
Abstract: So you open up PowerPoint, create your slides and get ready to present. Sure, you know exactly how to do this - you’ve done it a lot of times in the past - but there’s more. Leveraging on the experiences learned from presenting at worldwide conferences such as SQL PASS Community Summit, TechEd, DevTeach and the likes, this session will look at what needs to be considered when creating powerful presentations that shine.
Speaker(s):
- Edwin Sarmiento
Track and Room: Professional Development - N/A
Title: Intro to C# for the SSIS Script Component
Abstract: The Script Component is an extremely powerful element in SSIS because it brings in the full capability of the .NET Framework. With first-class development tools and languages like C# you can solve problems that previously required very complex SQL or Expressions. If you’d like to learn enough C# to more effectively use the Script Component for Transformations, then this session is for you.
Speaker(s):
- Joel Cochran
Track and Room: Database Development - N/A
Title: Some Thoughts on Managing Teams
Abstract: Are you a member of a team of database professionals? Are you part of a developer team? Do you manage or lead a team? This presentation is for you. Andy Leonard shares experiences, war stories, and lessons learned from years of managing and leading teams.
Speaker(s):
- Andy Leonard
Track and Room: Professional Development - N/A
Title: Deploying Data Tier Applications with SQL 2k8 R2
Abstract: Data Tier Applications (DAC Packs) are a new feature in SQL 2008 R2, that alllow developers to better simplify environmental management. In this demo, I will define the requirement surrounding DAC packs, then build and deploy a sample.
Speaker(s):
- Joseph D’Antoni
Track and Room: Database Development - N/A
Title: Sell Yourself Into An Interview!
Abstract: In today’s economy job seekers need to take advantage of every opportunity. In this session attendees will learn how to take advantage of unprecedented opportunities to market themselves to potential employers (and the world at large!) We’ll cover topics including fine-tuning your resume, managing your online presence and responding to the toughest interview questions. We’ll also discuss how you can turn simple steps, like asking your interviewer questions and sending a follow-up note, into unparalleled opportunities to close the deal.
Speaker(s):
- Michael Coles
Track and Room: Professional Development - N/A
Title: Fundamentals of SQL Server Internals
Abstract: Want to know what makes SQL Server tick? Ever wonder what SQL Server is doing when you run a query? Ever wonder which parts of SQL Server are responsible for specific functionality? Want to know what a HOBT is? I can’t promise answers to every question, but I can set you on the path to knowledge about the inner workings of SQL Server.
Speaker(s):
- Jeremiah Peschka
Track and Room: DBA - N/A
Title: Database Design Contentious Issues
Abstract: A highly interactive and popular session where attendees evaluate the options and best practices of common and advanced design issues, such as: * Natural vs. Surrogate keys * Classwords and other Naming Standards * SOAs, Ontologies, ESBs, New TLAs and Shoe Strings * What is Logical? What is Physical? Why Do We Care? * Who Calls the Shots and Who Does What? * Implementing Party/party role…and others. Bring your votes, your debates, and your opinions.
Speaker(s):
- Karen Lopez
Track and Room: Database Development - N/A
Title: SSRS Interactive Reports
Abstract: I will show how to take advantage the interactive features of SQL Reporting Services to allow your users to drill down from summaries to the details that drive them. Address some of the simple to implement features that can make your existing reports much more useable to your end users. Topics to be covered include: Graphing, Interactive Sorting, Grouping, and Drilldown Reports.
Speaker(s):
- Matt Van Horn
Track and Room: BI - N/A
Title: Introduction to PowerPivot
Abstract: Are you trying to get a handle on what PowerPivot can do? Are you also interested in knowing PowerPivot’s limitations? Would you like to know how to integrate PowerPivot with Sharepoint 2010? Are you a little confused about where PowerPivot “fits” in the Microsoft BI stack? Are you unsure about how DAX formulas work? This intro session is almost like a “PowerPivot for Mere Mortals”, where I’ll take same data from 2 sources and showcase several of PowerPivot’s capabilities.
Speaker(s):
- Kevin Goff
Track and Room: BI - N/A
Title: Applied MDX in OLAP applications
Abstract:
Learning the basics of MDX is one thing - learning how to incorporate MDX into custom OLAP applications is sometimes more difficult. In this session, I’ll show different examples on using MDX inside SSRS reports, PerformancePoint Services dashboards, and even inside Excel.
Speaker(s):
- Kevin Goff
Track and Room: BI - N/A
Title: Writing faster queries
Abstract: Poor database performance is Achilles’ heel of any system. Better and faster hardware can improve systems to a certain point. However, for truly great performing systems, there is no substitute for properly written queries and designed indexes. In this session we’ll take a look at some common query performance killers, along with some no so obvious things that we can do to our queries to make them as fast as possible.
Speaker(s):
- Tim Chapman
Track and Room: DBA/DEV Advanced - N/A
Title: Business Intelligence: Decaffeinated Please!
Abstract: For many Database Administrators, Data Analysts and other IT and Business Professionals, Business Intelligence (BI) and Data Warehousing (DW) may be a new and uncharted territory with no clear path towards the destination. Others, who have already jumped head-on into the Business Intelligence journey, may be facing challenges that can potentially put their efforts at risk of failure.In this session attendees will learn some of the basic concepts that are key in understanding BI and DW. I will go over my 10 rules of wisdom for a successful BI solution intended as a roadmap to get you started.
Speaker(s):
- Jose Chinchilla
Track and Room: BI - N/A
Title: A better way to store and archive SQL Backups
Abstract: How do you verify your daily backup can be restored? What if you need to restore a backup from several days ago instead of the latest? How many backups should you keep? I’ve adopted a Tower of Hanoi tape rotation schedule to meet our disk-to-disk backup needs, at first that sounds simple but it’s actually MUCH more complex than it sounds - Learn about the strategy I use, the scripts we use to backup (with reports of success/failure and automatic retries for any failure), how we validate backups, and how we decide which backups to keep and which we erase to free up disk space.
Speaker(s):
- Steve Radich
Track and Room: Professional Development - N/A
Title: Get Cert! Get Cred!
Abstract: Obtaining a certification may be a dreaded and stressing process for some people. Most people fail because of their failure to plan a realistic roadmap towards their goals and not necessarily because they lack the skills. This session will focus on establishing a roadmap towards certification success for the MCTS and MCITP programs of SQL Server and Business Intelligence. I will do a quick overview of my recent success obtaining 4 certifications in 30 days and how you can achieve similar goals. But why certify? Join me to find out the opportunities you may be missing on!
Speaker(s):
- Jose Chinchilla
Track and Room: Professional Development - N/A
Title: Introduction to SQL Server Spatial Data
Abstract: SQL Server 2008 introduced support for new spatial data features – providing powerful visualization capabilities to your users. In this course attendees will learn the basics of the Geography and Geometry data types, spatial indexing, and spatial calculations. We will also explore more advanced uses for spatial data: loading spatial data into SQL Server from other formats, the new Map control in SSRS, and using online mapping software like Bing Maps to visualize SQL Server spatial data.
Speaker(s):
- Michael Coles
Track and Room: DBA/DEV Advanced - N/A
Title: Monitor your SQL Server farm with PBM and CMS
Abstract: This talk will give you an introduction into monitoring SQL Server using Policy Based Management and Central Management System which is provided out of the box with SQL Server 2008. I will then show you how you can combine these features with the Enterprise Policy Management Framework on codeplex to provide monitoring for your whole SQL Server farm. This topic assumes you know nothing about PBM and CMS and will include lots of examples with only a few PowerPoint slides.
Speaker(s):
- John Sterrett
Track and Room: Database 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.
Jared Nielsen
Jared Nielsen believes that a “Jack of All Trades Is Master of None… Except Himself”™. His twenty year career has spanned projects in “wires and pliers” networking, database architecting, software design, marketing strategy, sales management, training and documentation, business administration, entrepreneurial investment, public company creation, and strategic analysis and consulting. Billing himself as “an IT guy that actually speaks English”, he has managed to effectively bridge the gap between IT and Sales, IT and Marketing, and IT and Executive Management in a way that multiplies revenue for each project he works on. Always willing to speak his mind and challenge the status quo, he is featured throughout the world including the front page of the Wall Street Journal, Wired Magazine, the German Financial Times, Slash Dot, CNN (television, CNN.com and iReport.com), and thousands of blogs throughout the Internet. His work can be seen with companies such as Interline Brands / Barnett (formerly BNTT:NASDAQ), Hughes Supply/ Home Depot / HD Supply (formerly HUG:NYSE), Yahoo! Sports (YHOO:NASDAQ), CBS Television (CBS:NYSE), SAP Andina del Caribe (Caribbean Division), and automotive sector including Tire Kingdom, Big O Tires, Merchants Tire, and NTB, as well as dozens of other high profile projects that have multiplied in revenue due to his influence.
Tim Chapman
Tim Chapman is a Microsoft Certified Master (MCM) and works as a dedicated field engineer (PFE) at Microsoft specializing in performance tuning and high availability. Tim is from Louisville, KY and has over 12 years of database architecture, programming, and administration experience.
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.
William E Pearson III
Twitter: - @Bill_Pearson
LinkedIn: William E Pearson III
Contact: https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E
Bill Pearson created Island Technologies Inc. in 1997, and has developed a large and diverse customer base since. Bill#39;s background as a CPA, Internal Auditor, Management Accountant, and SQL Server MVP (BI) enables him to provide value to clients as a liaison between Accounting / Finance and Information Services. Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies and focuses his practice upon the integrated Microsoft Business Intelligence
Michael Coles
Michael Coles is a prolific writer on SQL Server topics. He has authored or coauthored several SQL Server developer titles including Expert SQL Server 2008 Encryption, Pro T-SQL 2008 Programmer’s Guide and Pro Full-Text Search in SQL Server 2008. He has also written dozens of technical articles that have been published online and in print magazines. Michael is a Microsoft MVP (SQL) and holds MCST:SQL Server 2008 (database development), MCDBA and MCP+I certifications, with a Bachelors degree in Information Technology. Michael has over 15 years SQL Server experience and he is currently Chief ETL Architect for a BI consulting firm in New York.
Karen Lopez
Twitter: - @datachick
LinkedIn: Karen Lopez
Contact: http://datamodel.com
Karen Lopez is a Sr. Project Manager and Architect for InfoAdvisors. A frequent speaker at conferences and local user groups, she has 20+ years of experience in project and data management on large, multi-project programs. Karen is a chronic volunteer, a Data Platform MVP, and an active advocate for science, technology, engineering, and mathematics (STEM) education and data quality.
Karen’s presentations are known for their lively and interactive approach to learning. Her motto: “Love Your Data!”
Andy Leonard
Twitter: - AndyLeonard
LinkedIn: Andy Leonard
Contact: https://andyleonard.blog
Andy Leonard is founder and Chief Data Engineer at Enterprise Data Analytics, Microsoft Data Platform MVP, creator of the DILM (Data Integration Lifecycle Management) Suite, an SSIS trainer, consultant, developer, Business Intelligence Markup Language (Biml) developer and BimlHero, SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of “The Biml Book and SQL Server Integration Services Design Patterns” and author of “Managing Geeks - A Journey of Leading by Doing”, “Data Integration Lifecycle Management with SSIS”, “Building Custom Tasks for SSIS”, and the “Stairway to Integration Services”. Andy blogs at andyleonard.blog where you can learn more on the About Andy page.
Jose Chinchilla
Twitter: - SQLJoe
LinkedIn: Jose Chinchilla
Contact: http://www.sqljoe.com
Jose Chinchilla is an experienced data analytics professional with multiple certifications including Microsoft Certified Database Administration (MCSE), Microsoft Certified Data Management and Analytics (MCSE), and Microsoft Certified Trainer (MCT). Jose specializes in Data Warehouse and Data Lake Architecture and Development as the Data Analytics Practice Lead at AgileThought, a full-service custom software and analytics consulting firm based in Tampa, FL. Jose is a book author (SQL 2012 Bible, Professional SQL Server 2012 Administration, Exam Ref 70-767 Implementing a SQL Data Warehouse 2016) and leads the Tampa Bay BI Data Analytics PASS Chapter in Tampa, FL.
Michael Coles
Michael Coles is a prolific writer on SQL Server topics. He has authored or coauthored several SQL Server developer titles including Expert SQL Server 2008 Encryption, Pro T-SQL 2008 Programmer’s Guide and Pro Full-Text Search in SQL Server 2008. He has also written dozens of technical articles that have been published online and in print magazines. Michael is a Microsoft MVP (SQL) and holds MCST:SQL Server 2008 (database development), MCDBA and MCP+I certifications, with a Bachelors degree in Information Technology. Michael has over 15 years SQL Server experience and he is currently Chief ETL Architect for a BI consulting firm in New York.
Jana Sattainathan
Twitter: - www.twitter.com/SQLJana
LinkedIn: Jana Sattainathan
Contact: http://www.sqljana.wordpress.com
Jana works as a Senior Oracle and SQL Server DBA at SCOR, a leading Reinsurance company in the world. He has spent most of his professional life around databases. At work, he has automated most aspects of his job using PowerShell.
Most recently, he created PowerPump, a “PowerShell Database Copy Server” for his company to copy 50 billion rows (> 20 TB,) from 4000+ of Oracle/SQL Server tables on a recurring basis to SQL Server targets for migration/testing. He has also fully automated the database deployment which supports all components of SQL Server and Oracle using PowerShell (with about 150 functions) that is tracked extensively.
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.
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”.
Edwin Sarmiento
Contact: http://bassplayerdoc.wordpress.com
Edwin Sarmiento is a SQL Server MVP from Ottawa,Canada specializing in high availability,disaster recovery system infrastructures running on the Microsoft server technology stack.He is very passionate about technology but has interests in music,professional organizational development,leadership management matters when not working with databases.He lives up to his primary mission statement -“To help people and organizations grow and develop their full potential as God has planned for them.”
John Sterrett
Contact: http://johnsterrett.com
John Sterrett is a database administrator at a international law-firm, and is responsible for over 100 instances of SQL Server. John has been active within the SQL Server community, including hosting the first SQLSaturday in West Virginia. John also presented a lightning talk and chalk-talk at the SQL Server 2010 Member Summit, presented sessions at SQLSaturday’s, and the Pittsburgh SQL Server User Group. John is a syndicated blogger at SQLServerPedia and contributes tips at MSSQLTIPS.
Kevin Goff
Twitter: - @KevinSGoff
Contact: http://www.KevinSGoff.net
Kevin S. Goff (http://www.kevinsgoff.net) is a Microsoft SQL Server MVP
Database architect/developer/speaker/author
Regular columnist for CoDe Magazine on .NET, SQL Server, and Business Intelligence topics
Frequent speaker at community events in the Mid-Atlantic region.
Host of BDBI Radio (http://www.bdbiradio.com), a weekly webcast on SQL/BI topics
Edwin Sarmiento
Contact: http://bassplayerdoc.wordpress.com
Edwin Sarmiento is a SQL Server MVP from Ottawa,Canada specializing in high availability,disaster recovery system infrastructures running on the Microsoft server technology stack.He is very passionate about technology but has interests in music,professional organizational development,leadership management matters when not working with databases.He lives up to his primary mission statement -“To help people and organizations grow and develop their full potential as God has planned for them.”
Steve Radich
Contact: http://www.BitShop.com
Steve Radich is founder of BitShop.com, the Business Innovative Technology Shop - I’ve been involved in the design, development, maintainance and performance troubleshooting for web servers with SQL Server backends since SQL 4.3 (1996). I have extensive knowledge of IIS, Classic ASP, ASP.Net, and SQL Server - as well as several Virtualization technologies. I’ve presented on all these technologies at Users Groups and/or Code Camps. Previously IIS and Classic ASP MVP.
Thomas LaRock
Twitter: - @SQLRockstar
LinkedIn: Thomas LaRock
Contact: http://thomaslarock.com
Thomas LaRock is a Head Geek at SolarWinds and a Microsoft Certified Master, Data Platform MVP, VMware vExpert, and a Microsoft Certified Trainer. He has over 15 years’ experience in the IT industry in roles including programmer, developer, analyst, and database administrator.
Sergey Pustovit
As an Architect in Parallel Data Warehouse Center of Excellence Sergey designs complex EDW solutions based on Massively Parallel Processing (MPP) approach. He has 20+ years of industry experience, working with distributed database systems, designing and developing software. Sergey serves on advisory board for the SQL PASS local chapter in Charlotte, NC.
Joel Cochran
Contact: http://www.developingfor.net
Joel Cochran is an Expression Blend MVP and author of “Expression Blend in Action” by Manning publications. He has been developing software for over 14 years using multiple languages, platforms, and databases. In 2010 he discovered the joys (and pains) of SSIS and has never been the same since.
Kendra Little
Twitter: - Kendra_Little
LinkedIn: Kendra Little
Contact: http://littlekendra.com
Kendra Little is a Microsoft Certified Master and a Microsoft MVP. Kendra fell in love with the challenge of deploying software to a complex database environment when she worked in a build operations team at a software startup. She went on to become a database administrator for performance critical databases at Microsoft Corporation. Since then, Kendra has worked internationally as a teacher and consultant, and founded the training site SQL Workbooks. She joined Redgate as a Product Evangelist in 2018.
Jeremiah Peschka
Contact: http://brentozar.com
Jeremiah sees the magic in technology. He knows how to do things now, and he also knows how to think about possibilities. Jeremiah likes to imagine new kinds of indexes, new kinds of teams, new kinds of applications — this means when you need to reinvent something, or get unblocked, you should talk to Jeremiah.
John Welch
Twitter: - @john_welch
LinkedIn: John Welch
Contact: http://agilebi.com/jwelch
John Welch joined SentryOne in spring 2018 as VP of Engineering with the acquisition by SentryOne of the software division of Pragmatic Works. John leads the development of a suite of products that make developing, managing, and documenting data solutions easier. John has been successfully delivering IT solutions to business problems since 1994, and has been focused on business intelligence and data warehousing technologies since 2001. He is a Microsoft Most Valued Professional (MVP), and a frequent presenter on SQL Server and data topics. He also contributes to several open source projects and community initiatives targeted toward making data professionals work more productive.
Joel Cochran
Contact: http://www.developingfor.net
Joel Cochran is an Expression Blend MVP and author of “Expression Blend in Action” by Manning publications. He has been developing software for over 14 years using multiple languages, platforms, and databases. In 2010 he discovered the joys (and pains) of SSIS and has never been the same since.
Sandra Mueller
Sandra A. Mueller started with Administration (via a programming job) in 1997 and moved into Database Design and performance optimization. She has always had a passion for sharing knowledge and trying to help others avoid the hard lessons she learnt. To this end she has been an MCT for 16 years, writing course ware, providing training and follow-on project consultation. In 2004 after an activation with the military her focus turned to SQL Server 2005 and its Business Intelligence (BI) capabilities. She is currently working as a BI Architect with SQL Server 2008R2 OLAP solutions.
Sandra blogs on http://www.SandraAMueller.com. She recently started the Raleigh NC SQL Server BI User Group (http://www.tripassBI.org). She consistency speaks at SQLSaturday events and supports her local community by speaking, volunteering and attending regional chapters.
Matt Van Horn
Contact: http://www.anythingtheycando.com/blog/index.php
Matt, a seasoned developer with proficiencies in a wide-array of programming languages and platforms, focuses on creating flexible and dynamic code tailored to the specific needs of customers. Matt is an experienced presenter, regularly speaking at Usergroup meetings and Code Camps.
Andy Leonard
Twitter: - AndyLeonard
LinkedIn: Andy Leonard
Contact: https://andyleonard.blog
Andy Leonard is founder and Chief Data Engineer at Enterprise Data Analytics, Microsoft Data Platform MVP, creator of the DILM (Data Integration Lifecycle Management) Suite, an SSIS trainer, consultant, developer, Business Intelligence Markup Language (Biml) developer and BimlHero, SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of “The Biml Book and SQL Server Integration Services Design Patterns” and author of “Managing Geeks - A Journey of Leading by Doing”, “Data Integration Lifecycle Management with SSIS”, “Building Custom Tasks for SSIS”, and the “Stairway to Integration Services”. Andy blogs at andyleonard.blog where you can learn more on the About Andy page.
Jose Chinchilla
Twitter: - SQLJoe
LinkedIn: Jose Chinchilla
Contact: http://www.sqljoe.com
Jose Chinchilla is an experienced data analytics professional with multiple certifications including Microsoft Certified Database Administration (MCSE), Microsoft Certified Data Management and Analytics (MCSE), and Microsoft Certified Trainer (MCT). Jose specializes in Data Warehouse and Data Lake Architecture and Development as the Data Analytics Practice Lead at AgileThought, a full-service custom software and analytics consulting firm based in Tampa, FL. Jose is a book author (SQL 2012 Bible, Professional SQL Server 2012 Administration, Exam Ref 70-767 Implementing a SQL Data Warehouse 2016) and leads the Tampa Bay BI Data Analytics PASS Chapter in Tampa, FL.
Kevin Goff
Twitter: - @KevinSGoff
Contact: http://www.KevinSGoff.net
Kevin S. Goff (http://www.kevinsgoff.net) is a Microsoft SQL Server MVP
Database architect/developer/speaker/author
Regular columnist for CoDe Magazine on .NET, SQL Server, and Business Intelligence topics
Frequent speaker at community events in the Mid-Atlantic region.
Host of BDBI Radio (http://www.bdbiradio.com), a weekly webcast on SQL/BI topics
Sponsors
The following is a list of sponsors that helped fund the event: