SQLSaturday #111 - Atlanta 2012
Event Date: 04/14/2012 00:00:00
Event Location:
- Georgia State University - Alpharetta location
- 3775 Brookside Pkwy
- 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: Query Tuning Mastery: Manhandling Parallelism
Abstract: In today’s multi-core-driven world, query performance is very much determined by how well you’re taking advantage of the processing power at your disposal. In this session you will learn how to take full advantage of parallelism, from a developer’s point of view. After a quick terminology review and technology refresher the session will go deep, covering T-SQL patterns that allow certain queries to scale almost linearly across your multi-core CPUs. Not all T-SQL queries can go parallel, so you’ll also learn to watch for those things that can restrict the query optimizer’s decisions. Along the way you’ll learn to manipulate costs and row goals, challenge generally accepted tuning practices, and take complete control of your parallel queries.
Speaker(s):
- Adam Machanic
Track and Room: DBA\DEV - N/A
Title: Super-size Your SSIS Breakfast Sandwich: Performan
Abstract: Importing data is as common to SQL Server as bacon is to a savory breakfast sandwich. As most of us love to eat those breakfast sandwiches, SQL Server Integration Services (SSIS) loves to eat data in an Import/Export kind of way. Although a green chain of boxes in SSIS can be the ruling “Happy Dance” of any DBA or SQL Developer, we must still consider the performance of those tasks. In this session, we will go through performance tuning in SSIS 2012 after a successful SSIS package has been developed. When we are finished with this session, not only will you still have the mystic of green colors of successful execution of your SSIS import and export tasks, but the turbo boosters will be turned on as well.
Speaker(s):
- Hope Foley
Track and Room: SSAS\IS\RS - N/A
Title: Table Vars Temp Tables - What you NEED to Know!
Abstract: Almost every SQL Developer is familiar with Table Variables and Temporary Tables. While each of these objects represent temporary storage, there are also substantial differences between them. Understanding the differences between Table Variables and Temporary Tables, and the ramifications that those differences cause, is essential to being able to properly select the appropriate object for use in your development tasks. In this code filled session, we’ll discover the differences and similarities of Temporary Tables and Table Variables, dispel some widespread myths about each, and answer the most important questions of them all, “When do I use one or the other and what are the various impacts of doing so?”
Speaker(s):
- Wayne Sheffield
Track and Room: DBA\DEV - N/A
Title: SQL Server is the Least of My Problems!
Abstract: You’ve finally gotten your first job working with SQL Server (SS) as the junior DBA at company XYZ. All the studying, the classes, the pricey SS certification exams, the User Group attendance has paid off.
Your first day at the job your boss walks you through some new job duties. He wants you to remote out to the server to look at the file directory where the FTP process writes the encrypted files make sure the file share didn’t disappear when the cluster failed over. You slip away to the bathroom, lock yourself in a stall, have a seat and rock side to side muttering -What is he talking about?I thought there would be tables.
If this sounds familiar this session is for you. Learn about the SS ecosystem how to navigate it as a new
Speaker(s):
- Julie Smith
Track and Room: BEG - N/A
Title: Taking the Scary out of Monster Reports
Abstract: So the big wigs have come up with a “master” report that shows everything you could ever want on a single report. It includes grids and charts of varying sizes and complexities. Did I mention they want it pretty as well? In this session we will discuss how to use SQL Reporting Services 2008 R2 to bring it all together while avoiding the pit falls and mistakes. The demonstration will show how to build a multi-page, dashboard style report to manage your report server showing a multitude of grids and charts. We will discuss the challenges with data reuse and formatting while exploring techniques for getting them to work. To get the most out of this session, you should be able to build a report in SSRS.
Speaker(s):
- Pam Shaw
Track and Room: SSAS\IS\RS - N/A
Title: Common Backup Problems and How to Deal With Them
Abstract: SQL Server backups can be burdensome to set up and maintain. All sorts of different problems can occur. This session targets the most common problems encountered while working with SQL Server backup and shows you how to identify these issues in your environment. In fact, I’ll walk you through how to prevent these common issues from ever cropping up within your systems in the first place. Be prepared for information you can take back to the office and put to work right away making your system backups more reliable. With backups running correctly all the time, you’ll be protecting your systems better, and feeling a lot less stress when it times to perform an emergency restore.
Speaker(s):
- Grant Fritchey
Track and Room: BEG - N/A
Title: “Managed Self-Service BI” and “Data As A Service”
Abstract: You know BI. Right? Well kids, traditional Business Intelligence is changing … you heard about the ambitious data analyst down the hall who created a mashup of data from the internal data warehouse + Excel + an Azure feed? Empowering knowledge workers is Microsoft’s vision of delivering “BI for the Masses.” In this session we will dismiss the hype examine how this new world of “Managed Self-Service BI” complements Corporate BI in SQL Server 2012 and SharePoint 2010. Goals: (1) Overview of each Self-Service component. (2) Introduce Codename “Data Explorer” and Data As A Service. (3) Techniques to monitor, manage, secure the Self-Service BI environment.
Speaker(s):
- Melissa Coates
Track and Room: SSAS\IS\RS - N/A
Title: T-SQL Brush-up:The Best Things You Forgot You Knew
Abstract: You’re a good SQL professional – you attend conferences and webinars, you read articles and books, and you know your way around SQL Server. But sometimes – just SOMEtimes – some piece of T-SQL slips by you unnoticed, or falls out of memory. Most of us are working with at least two or three out of the last five versions of SQL Server, so who can blame us for missing a feature or two? Come and revisit old favorites, and brush up on new T-SQL features and enhancements. In this session you will see SELECT turned inside-out. You’ll get really, really excited about OVER and PARTITION BY. This session is chock full of code examples, including before-and-after demos and how-to illustrations.
Speaker(s):
- Jennifer McCown
Track and Room: DBA\DEV - N/A
Title: Benchmarking, Baselines and Monitoring Storage
Abstract: Benchmarking, Baselines and Monitoring Storage There are several steps in the life cycle of your storage systems. We have several tools to help us understand our storage systems from initial deployment through its useful life. We will cover: SQLIO, a specific SQL Server benchmarking tool. Iometer, a general IO benchmarking tool and simulator. SQLIOSim a specific SQL Server base lining tool and simulator. TPC style testing focused on TPC-C, TPC-E and TPC-H. Monitoring your system using WMI and virtual file stats. Finally, what it all really means, how to read these results and compare them with each other. With these tools you can plan, deploy and manage your storage for years to come!
Speaker(s):
- Wesley Brown
Track and Room: DBA\DEV - N/A
Title: PowerScripting Live! (PowerShell podcast / BoF)
Abstract: Do you listen to podcasts? It’s like the radio, but more Internetty. Well, Atlanta just so happens to be the home to the two co-hosts of the PowerScripting Podcast, the first podcast devoted to talking about Windows PowerShell. We have news, interviews, tips and resources that we present every week at powerscripting.net, but this time, the show is coming to you live! We’ll come prepared to hit most any general PowerShell topic you want, and we’ll probably sneak some SQL + PowerShell experts on stage to help out. This won’t be a canned lecture, it will be more of a Birds of a Feather or talk show feel. Audience participation is REQUIRED!
Speaker(s):
- Hal Rottenberg
Track and Room: POW - 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: POW - N/A
Title: Introduction to Common Table Expressions
Abstract: Introduced in SQL 2005, Common Table Expressions, or CTEs, are temporary result sets that offer increased flexibility in your T-SQL coding and provide a simple syntax for recusive queries. In this session for intermediate T-SQL coders, learn how to use CTEs to improve the readability and maintainability of your most complex queries.
Speaker(s):
- Vicky Harp
Track and Room: DBA\DEV - N/A
Title: Being the Swiss Army Knife of DB Pros
Abstract: Being a specialist means you’re really, really good at one thing. Being a generalist means you’re good at a a lot of different things. The generalist has an advantage over the specialist because he or she can see and solve problems the specialists can’t. In this session I’ll cover why it’s important to diversify your skill set, not only for career protection, but to be better as a database professional. We’ll look at what skill sets to build on to expand your abilities around SQL Server to include the operating system, development, networks, and security. Remember, this saying isn’t complete, “Jack of all trades, master of none.” The full saying is, “Jack of all trades, master of none, though often times better than master of one.”
Speaker(s):
- Brian Kelley
Track and Room: BEG - N/A
Title: Working with Server Side Traces
Abstract: You may have heard that it’s a good idea to use a server-side trace to capture SQL profiler data, but do you know how to create one? And, do you know how to process the data you’ve captured? If not, then this session is for you.
First, we’ll examine the anatomy of a server-side trace script and look at the different ways it can be customized. Then, we’ll talk about methods for stopping and starting the trace, how to know what traces are already running, and ways to schedule a trace to start under certain server conditions. Last, we’ll look at different tools available to you for analyzing the data you’ve gathered, including the SQL Server Profiler client application, “home-grown” T-SQL queries, ClearTrace, and the ReadTrace.
Speaker(s):
- Christina Leo
Track and Room: DBA\DEV - N/A
Title: Introduction to SQL Server Column-Level Encryption
Abstract: With the new data security standards and legislation, encryption has become a necessity in today’s business world. This session will introduce SQL Server column-level encryption and show how it can easily be implemented as part of a comprehensive security initiative (even in SQL Server Express Edition!). The session will include slides and discussions to introduce concepts and will also have a live demo of a simple implementation of column-level encryption. This is intended for anyone who is interested in SQL Server encryption, or those who need to implement column-level security in their databases as part of their overall database information security strategy.
Speaker(s):
- Bob Langley
Track and Room: DBA\DEV - N/A
Title: Beginning T-SQL
Abstract: If you work with SQL Server at all, you need to know Transact-SQL, the SQL Server programming language. During this session, we’ll design and create our own table to demonstrate key concepts, query syntax, and more. If you’ve been meaning to learn T-SQL, here’s your chance!
Speaker(s):
- Jennifer McCown
Track and Room: BEG - N/A
Title: Analytical Master Data Management with MDS 2012
Abstract: Recent changes in Business Intelligence have placed greater emphasis on on enabling end-user analytics. While compelling in theory, in practice there are many challenges when creating a foundation that supports end-users analytics. Many of these challenges revolve around making consistent reference (i.e. dimensional) data available to end users. This can be addressed using a Master Data Management solution.
This session session will explore ways that Master Data Services 2012 can be used to support the definition and management of master data used to support analytics (BI) solutions. It will start with a high level overview of MDM and MDS 2012, and finish with a demo of an analytical MDM solution.
Speaker(s):
- Eric Melcher
Track and Room: SSAS\IS\RS - N/A
Title: It is TEMPDB, Why Should You Care?
Abstract: TEMPDB is just for temporary data right? It is installed by default and gets recreated it time SQL is restarted so what does it matter right? WRONG. This session will give you great insight into what uses TEMPDB, why TEMPDB is important, what are some best practices for configuring TEMPDB, and how to determine if you have contention. If you have systems where TEMPDB hasn’t been touched since the install, you need to attend this session.
Speaker(s):
- Tim Radney
Track and Room: DBA\DEV - N/A
Title: Mobile Business Intelligence
Abstract: Get mobilized! Mobile business intelligence and mobile applications are hot in 2012. Learn how to leverage Microsoft Business Intelligence and SQL Server data platform technologies with a variety of mobile devices. The session will cover several options, tips, tricks, best practices and field lessons learned.
Speaker(s):
- Jen Underwood
Track and Room: DBA\DEV - N/A
Title: It’s Spring - Are You Still Compressed?
Abstract: In this session we will review the growing parts of rows and how to keep them as lean as possible.
The following topics will be studied: • Row structure with a concentration on the parts that grow • Row and page compression and their effect on row structure • Prefix and Dictionary compression and their effect on row structure • The CPU cost of running queries against compressed data • Some strategies for compressing various data • Leave the attendees with additional demos and scripts for studying compression and testing it on your own machine
Speaker(s):
- Jeremy Carroll
Track and Room: DBA\DEV - N/A
Title: Report Parts: Increasing Productivity Since 2008R2
Abstract: Using SQL Server 2008 R2 Reporting Services and Report Builder 3.0, report writers can store, re-use, and modify pieces of reports using “report parts”. Report parts are stored on the report server and are provided to others for collaboration in a report part library to increase initial development productivity and decrease maintenance turn-around time. This presentation will describe how to set up a user-friendly and easily maintained report part library by discussing how to create report parts, how to store them on the report server, and how to import them into a new report.
Speaker(s):
- Jessica Moss
Track and Room: SSAS\IS\RS - N/A
Title: Extended Events, Work Smarter Not Harder
Abstract: There are many ways to performance monitor your SQL Server environment. In this session we’ll review Extended Events, which is one of the newer SQL Server monitoring platforms. Learn the ins and outs of how to get detailed information on the errors and events that occur within SQL Server and how to dig into the information. With a few T-SQL statements, issues that could take weeks to research can be investigated in minutes.
Speaker(s):
- Jason Strate
Track and Room: DBA\DEV - N/A
Title: PowerShell Modules You Should Know About
Abstract: You know that problem you’re working on? Chances are someone has already solved it, and has packaged their solution up in a nice pretty PowerShell module for you to use.
Come learn about PowerShell modules - what they are, how you use them, where you can find them. And let’s explore some of these modules and see what problems they can solve for us.
Speaker(s):
- Jim Christopher
Track and Room: POW - 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 * Varchar Minimums *Identity Crisis * Who Calls the Shots and Who Does What? …and others. Bring your votes, your debates, and your opinions.
Speaker(s):
- Karen Lopez
Track and Room: DBA\DEV - N/A
Title: PowerPivot for Excel: For Those Unacquainted …
Abstract: Microsoft BI Architect and SQL Server MVP Bill Pearson overviews PowerPivot for Excel, the client side of Microsoft’s foray into self-service BI. The targeted audience includes BI professionals who are seeking an introduction to what PowerPivot offers their organizations. Among others interested will be Excel power users who are fluent with PivotTables and want to understand the new capabilities.
Speaker(s):
- William E Pearson III
Track and Room: DBA\DEV - N/A
Title: Managing Database Changes with Visual Studio
Abstract: As systems grow and evolve, we need tools to help manage these changes, including tracking changes to the database schemas, producing scripts to synchronize the changes between servers, and refactoring the corresponding application code based on the new structures. You’ll see how you can use tools in Visual Studio to help manage these changes better.
Speaker(s):
- Jim Wooley
Track and Room: DBA\DEV - N/A
Title: Configuring SQL Server 2012 Reporting Services
Abstract: Reporting Services can be one of the easier tools to configure, once you understand how to use the configuration manager. In this session you’ll explore the configuration settings available through the exploration of the Reporting Services Configuration Manager. You’ll learn the different accounts Reporting Services will need in order to run, how to access Reporting Services via URLs, and the importance of encryption keys.
Speaker(s):
- Robert Cain
Track and Room: SSAS\IS\RS - N/A
Title: Windows Operating System Internals for DB Pros
Abstract: In this session, we’ll take a look at Windows operating system internals, including kernel architecture, threads and processes, memory usage, and I/O, and how they affect how SQL Server performs and acts. By having a good understanding of how the operating system works under the covers and how it interacts with the SQL OS, you will gain a deeper knowledge of what’s going on with your SQL Servers and where performance issues may be on your systems.
Speaker(s):
- Brian Kelley
Track and Room: DBA\DEV - N/A
Title: Designing an SSIS Framework
Abstract: In this “demo-tastic” presentation, SSIS trainer, author, and consultant Andy Leonard explains the what, why, and how of an SSIS framework that delivers metadata-driven package execution, connections management, and centralizes logging. Key takeaways: 1) Developers can migrate packages from Development, through their lifecycle, to Production without editing SSIS Connection Managers properties. 2) A metadata-driven approach to SSIS package execution. 3) Demonstration of a centralized logging reporting application.
Speaker(s):
- Andy Leonard
Track and Room: SSAS\IS\RS - N/A
Title: Introduction to FileTables
Abstract: SQL Server 2012 introduces the first significant enhancement to FILESTREAM: FileTables. FileTables use the underlying FILESTREAM storage, but expose the stored data using traditional Windows file I/O APIs. In addition, they also support hierarchical data storage (read “folders”). This session will show how to set up your SQL Server instance to support FileTables, how to create a FileTable and how to access it using standard Windows file APIs. It may be valuable to attend the Introduction to FILESTREAM session also.
Speaker(s):
- Sven Aelterman
Track and Room: DBA\DEV - N/A
Title: Time Saving Tips Tricks for SSMS 2012
Abstract: SQL Server Management Studio can be really annoying sometimes. Over the years a few really nice features have been added that you may have overlooked or just couldn’t find. This session will focus some time saving tips and tricks for SSMS 2008 R2. We’ll also cover a few great new features being introduced in SSMS 2012. Since I can’t provide scripts for this session I guess I better get started working on some screen shots on where they hid all this stuff!
Speaker(s):
- Aaron Nelson
Track and Room: DBA\DEV - N/A
Title: Applied Enterprise Semantic Mining
Abstract: SQL Server 2012 debuts a new Semantic Platform (commonly known as the applied task, Semantic Search). This text mining technology leverages the already established Full Text Index, and builds semantic indexes in a two-phase process. This presentation provides a science description and demo for the Enterprise implementation of Tag Index and Document Similarity Index. At present (RC0), the indexes work for 15 languages. Included are strategy tips for how to best leverage the technology along with already-existing Microsoft text mining and data mining.
Speaker(s):
- Mark Tabladillo
Track and Room: SSAS\IS\RS - N/A
Title: Revenge: The SQL Part 2: The Sequel!
Abstract: In a world…where DBAs are blamed, mistreated, and overworked…one man….WILL. GET. EVEN. In this entertaining and impractical follow-up to the entertaining and impractical Revenge: The SQL, Rob Volk will show you even more impractical but oh-so-tempting ways to get back at those who abuse SQL Server and make you clean it up. Techniques will cover: preventing sa use, preventing ad-hoc SQL, hiding and obfuscating data and code, and the ever-popular trigger mayhem. And if you stay for the after-credits sequence you may encounter the evil twins, duplicate primary keys!
Speaker(s):
- Rob Volk
Track and Room: DBA\DEV - N/A
Title: Working with “Biggish Data”
Abstract: Most database professionals know (from firsthand experience) that there continues to be a “data explosion”, and there’s been a lot of focus lately on “big data”. But what do you do when your data’s just kind of “biggish”? You’re managing Terabytes, not Petabytes, and you’re trying to squeeze out as much performance out of your aging servers as possible. The focus of this session is to identify some key guidelines for the design, management, and ongoing optimization of “larger-than-average” databases. Special attention will be paid to the following areas: * query design * logical and physical data structures * maintenance backup strategies
Speaker(s):
- Stuart Ainsworth
Track and Room: DBA\DEV - N/A
Title: Tuning Analysis Services Processing Performance
Abstract: You’ve got your Analysis Services cube created, and deployed in production. However, you notice that every night, the cube is taking longer and longer to process, and users are starting to complain about their data not being ready when they arrive in the morning. If you’ve found yourself in this situation, or want to avoid being in it in the first place, come to this session. We’ll cover how to benchmark processing performance, track down bottlenecks, and how to tune things to get the best performance for processing your cube.
Speaker(s):
- John Welch
Track and Room: SSAS\IS\RS - N/A
Title: The Personal-Team-Organizational BI Conundrum
Abstract: Confused about the BI alphabetical soup? Not sure which one makes sense for your organization? Join this session to learn you can use the Microsoft BI platform to address various analytical needs. Discover how to implement the Personal-Team-Organizational continuum on a single platform. I’ll also discuss how Tabular and Multidimensional compare.
Speaker(s):
- Teo Lachev
Track and Room: SSAS\IS\RS - N/A
Title: Concurrency in PowerShell
Abstract: Moore’s law is not dead; it lives on as CPU manufacturers add more and more CPU cores to the same chip real estate. In this session, we will look at the ways in which you can leverage concurrent processing in your PowerShell code to dramatically increase the efficiency of your code. Speed up those ETL processes, execute code on multiple servers at the same time, and complete your maintenance tasks much faster using the techniques you will learn.
Speaker(s):
- Jon Boulineau
Track and Room: POW - N/A
Title: The Decoder Ring for Data Warehousing / BI
Abstract: Business Intelligence is one of the hottest job skills in the IT field. DBAs and Database Developers are being asked to implement databases with non-traditional design, and are having a lot of new vocabulary thrown their way. In this talk you will learn the concepts behind building and designing data warehouses, and cut through the buzz words so you will walk away with a clear understanding of what words like dimensions, facts, and measures mean.
Speaker(s):
- Robert Cain
Track and Room: BEG - N/A
Title: Managing data in a Windows Phone application
Abstract: Learn about the various options for managing data in a Windows Phone application, including local storage, accessing data feeds, synchronization, and more.
Speaker(s):
- Glen Gordon
Track and Room: DBA\DEV - N/A
Title: Think Outside the Group! Take MDX to the next leve
Abstract: Reporting Services is a powerful tool that can make designing reports a snap…most of the time. But every once in a while you have to format a report very specifically, and that starts with your data query. In this session, we’ll think outside the group! Learn about how to use named sets, dummy members, and other MDX tricks to craft your queries in a way that allows you to conquer the trickiest report layouts.
Speaker(s):
- Erika Bakse
Track and Room: SSAS\IS\RS - N/A
Title: Index Internals
Abstract: During this session we will be digging into the internals of SQL Server indexes.
Speaker(s):
- Denny Cherry
Track and Room: DBA\DEV - N/A
Title: Execution Plans a Deep Dive
Abstract: It’s one thing to know to look for scans instead of seeks, but if you really want to know what’s going on in an execution plan, you need to dive deep. This session will cover reading execution plans from the basics, but goes way beyond the basics to cover as much of the information available within an execution plan as you might possibly ever need. We’ll go into how to understand how to interpret parameter sniffing and spot when a join operation is not performing the way you would want. We’ll use the graphical plan and the XML behind to thoroughly explore execution plans.
Speaker(s):
- Grant Fritchey
Track and Room: DBA\DEV - N/A
Title: Windows PowerShell Best Practices
Abstract: Learn Windows PowerShell best practices as they apply to each stage of the script development lifecycle. See the differences between working interactively from the Windows PowerShell prompt, writing an inline script, adding basic function, advanced functions and finally the implementation of Windows PowerShell Modules. What is a local best practice for Windows PowerShell development is not the same as a global best practice, and this talk covers those differences
Speaker(s):
- Ed Wilson
Track and Room: POW - N/A
Title: Using NULL the Right Way
Abstract: Over the years, I have seen NULL abused in many ways, often to the detriment of the application. This session will help you gain a deeper appreciation for what seems, on the surface, to be a simple topic. We will dig into how NULLs impact schema semantics, storage internals, and query performance.
Speaker(s):
- Phil Pledger
Track and Room: DBA\DEV - N/A
Title: SSIS 2012: Project Deployment Model and Catalog
Abstract: SSIS in SQL Server 2012 is getting major face lift and comes loaded with a great deal of enhancements and new features. In this session we explore the new the new project deployment model, design and runtime features along with deployment and management considerations using the also brand new SSIS catalog. This session provides you with valuable to get you going in your next SSIS 2012 project.
Speaker(s):
- Rafael Salas
Track and Room: SSAS\IS\RS - N/A
Title: Fundamentals of Physical Join Operations
Abstract: This is a wonderful session for those that don’t yet grok the three types of joins available to the SQL Server engine or the scenarios for which each join type is optimal. All will be explained here with some very slick visual demonstrations of internal data flow as well as TSQL code samples. We will also show how bad performance can get when suboptimal joins are used.
Speaker(s):
- Kevin Boles
Track and Room: DBA\DEV - N/A
Title: EIM - Bringing Together SSIS, DQS, and MDS (300)
Abstract: Enterprise Information Management (EIM) is an industry term for managing your data for data integration, quality, and governance. This session revolves around a demo which brings together the EIM functionality in SQL Server, a key part of our Credible, Consistent Data story for the 2012 release. We will show you how SQL Server Integration Services (SSIS), Data Quality Services (DQS), Master Data Services (MDS) and other Microsoft technologies work together to provide a comprehensive EIM solution.
Speaker(s):
- Matt Masson
Track and Room: SSAS\IS\RS - N/A
Title: Moving Day - Successful SQL Migrations with ShareP
Abstract: Moving day is one of life’s most stressful times. Details drown you, critical items consume time and attention, and there is always someone demanding you get something done now. This is true whether you are moving where you live or your data platform. SQL Server migrations are a core competency for a DBA. This presentation will give you a strong structured process for a successful SQL Server migration using examples focused on SharePoint workloads.
Speaker(s):
- Geoff Hiten
Track and Room: SSAS\IS\RS - N/A
Title: SQL Server Table Partitioning from the ground up
Abstract: In this session we will be looking at the SQL Server table partitioning features which were introduced in SQL Server 2008. We will
look at how to create partitioned tables and indexes as well as the internals of the table. We will also look at how to move data
from one partition to another and from one table to another with minimal to no impact to the users.
Speaker(s):
- Denny Cherry
Track and Room: DBA\DEV - N/A
Title: Power View: A Peek Behind the Curtain
Abstract: Power View is the new data visualization and self-service BI tool that will debut in SQL Server 2012. To successfully roll-out this technology to your user community, you need to understand its architecture and data dependencies. Come to this session to get past the razzle dazzle that most Power View sessions offer, and peek behind the curtain to learn how to properly configure your environment to support Power View and how to prepare data for user consumption within Power View .
Speaker(s):
- Stacia Varga
Track and Room: SSAS\IS\RS - 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.
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.
Sven Aelterman
Twitter: - @svenaelterman
LinkedIn: Sven Aelterman
Contact: https://svenaelterman.wordpress.com
Sven Aelterman is the Director of IT for the Sorrell College of Business at Troy University; a role with a global scope. He is also a lecturer in Information Systems and teaches courses in data warehousing and information security. He continues consulting work through Adduxis, where he assists customers with various Microsoft technology implementations. Co-author of The Art of SQL Server FILESTREAM, published by Red Gate; and SQL Server 2017 Administration Inside Out, published by Microsoft Press. Cloud Software Architect at Sorrell Solutions, L.L.C. developing a Microsoft Azure-hosted Electronic Health Record system.
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!”
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.
Aaron Nelson
Twitter: - SQLvariant
LinkedIn: Aaron Nelson
Contact: http://sqlvariant.com/
Aaron Nelson is an author, public speaker, blogger, and leader in the community. He has over 15 years of experience in architecture, Business Intelligence, development, and performance tuning of SQL Server. Aaron has received many certifications and is a six time winner of the Microsoft MVP Award.
Aaron leads the PowerShell Virtual Group of PASS (SQLPS.io), is a board member of PowerShell.org, and is a volunteer at his PASS Local Group, AtlantaMDF.
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.
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
Erika Bakse
Erika Bakse began her business intelligence career three years ago when she joined the Data Inspirations team. She has helped develop training curricula for use of the various SQL Server business intelligence technologies and is a contributing author of Microsoft SQL Server 2008 Reporting Services Step by Step (Microsoft Press, 2006). Her blog is available at erikasblog.datainspirations.com, and she tweets as @BakseDoesBI
Jennifer McCown
Twitter: - http://www.Twitter.com/MidnightDBA
LinkedIn: Jennifer McCown
Contact: http://www.MidnightDBA.com/Jen
Jen McCown is CEO of MinionWare, LLC; a Microsoft Certified Master for SQL Server; and an independent consultant. She is Senior Editor at MidnightDBA.com, where she creates training videos, the DBAs at Midnight webshow, blogs, reviews, and podcasts. Jen is a member, volunteer, and speaker in PASS, and the PASS Women in Technology Virtual Group.
Wesley Brown
Twitter: - @sqlserverio
LinkedIn: Wesley Brown
Contact: http://www.sqlserverio.com
Wesley Brown is a former SQL Server MVP and PASS Chapter Leader who loves to teach others about SQL Server.He maintains his technical blog at http://www.sqlserverio.com. Wes specializes in high availability, disaster recovery, and large-scale database performance tuning.
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
Jason Strate
Contact: http://www.jasonstrate.com
Jason Strate, Digineer Inc, has been a Database Architect for over ten years. His experiences include designing and implementing both OLAP and OLTP solutions involving clustering servers, database monitoring and tuning, analysis services, DTS/Integration Services, Reporting Services, and Notification Services. Jason is actively involved with the local PASS chapter (SQL Server User Group); he is currently serving on the Executive Board and has presented at monthly meetings. Jason contributed to M
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.
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.
Jennifer McCown
Twitter: - http://www.Twitter.com/MidnightDBA
LinkedIn: Jennifer McCown
Contact: http://www.MidnightDBA.com/Jen
Jen McCown is CEO of MinionWare, LLC; a Microsoft Certified Master for SQL Server; and an independent consultant. She is Senior Editor at MidnightDBA.com, where she creates training videos, the DBAs at Midnight webshow, blogs, reviews, and podcasts. Jen is a member, volunteer, and speaker in PASS, and the PASS Women in Technology Virtual Group.
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.
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
Teo Lachev
Twitter: - https://twitter.com/tlachev
LinkedIn: Teo Lachev
Contact: http://prologika.com/cs/blogs
Teo Lachev is an internationally-recognized authority on Data Analytics. Through his Atlanta-based company Prologika, a Microsoft Gold Partner in Data Analytics, he helps organizations make sense of their most valuable asset: their data. His strategy formulation, trusted advisory and mentoring, design and implementation services empower clients to apply effectively data analytics in order to understand, improve, and transform their business processes.
Teo has authored and co-authored several bestselling books on organizational and self-service data analytics, and he has been leading the Atlanta Microsoft BI and Power BI group since he founded it in 2010. Teo has been a Microsoft Most Valued Professional (MVP) Data Platform since 2010.
Bob Langley
Bob Langley, MCDBA, has been in IT for 24+ years in the financial services industry and local government. Starting out in programming, then moving to Business Systems Analysis, Systems Administration, and finally Database Administration and Development, administering and developing databases for many departments for a local county government, utilizing both SQL Server and Oracle databases.
Pam Shaw
Twitter: - @PamShaw
LinkedIn: Pam Shaw
Contact: http://sqlpam.wordpress.com/
Pam Shaw has been in IT for over 30 years. Since 2001, Pam has been working with SQL Server, first 2000, then 2005, 2008, 2008 R2, 2012 and now 2014. Pam currently works as a BI Developer as an independent contractor. Pam is also the Chapter Leader of the Hillsborough SQL Users Group PASS chapter and organizer of SQLSaturday Tampa.
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.
Julie Smith
Twitter: - @juliechix
LinkedIn: Julie Smith
Contact: http://datachix.com
Julie Smith is a Microsoft Data Platform MVP and a BI consultant for Innovative Architects in Atlanta, GA. She#39;s implemented increasingly complex Business Intelligence solutions for over a decade at various organizations. She#39;s also worn many other database “hats” in her career – production DBA and database developer–but data integration and BI are her true passions. Julie holds a BA from the University of South Carolina. She and Audrey Hammonds co-created The Datachix.com blog.
Stacia Varga
Twitter: - @StaciaV
LinkedIn: Stacia Varga
Contact: http://blog.datainspirations.com
Stacia Varga is a Microsoft Data Platform MVP and SSAS Maestro with a Bachelor’s Degree in Social Sciences. A consultant, educator, author, and principal of Data Inspirations, her career spans more than 30 years, with a focus on improving business practices through technology.
Since 2000, Stacia has provided consulting and education services for Microsoft’s Business Intelligence technologies. As Stacia Misner, she also authored several books covering the Microsoft BI stack.
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.
Ed Wilson
Twitter: - ScriptingGuys
LinkedIn: Ed Wilson
Contact: http://HTTP://WWW.ScriptingGuys.Com/Blog
Ed Wilson is the Microsoft Scripting Guy and a well-known scripting expert. He writes the daily Hey Scripting Guy! blog. He has also spoken at TechEd, Tech Ready, Geek Ready, SQL Rally and various SQLSaturday conferences. A Microsoft-certified trainer he has taught scripting to Microsoft Premier Customers worldwide. He has written 11 books including 9 on Windows scripting that were published by Microsoft Press. His Windows PowerShell 3.0 Step by Step for MSPress is a current best seller.
Jim Christopher
Twitter: - twitter.com/beefarino
LinkedIn: Jim Christopher
Contact: http://www.beefycode.com
Jim gained 18 years of professional experience developing complex software projects in highly regulated industries, including education, gaming, and defense. His professional drive is designing software, systems, and user experiences for automation, a theme that has earned him a Microsoft MVP for PowerShell (2011-2016). Jim is a frequent speaker at technical user groups and conferences. He is currently Curriculum Director at Pluralsight.
Matt Masson
Twitter: - @mattmasson
Contact: http://www.mattmasson.com/
Matt Masson is a Program Manager in the Information Management and Machine Learning (IMML) organization. Matt has worked on multiple data integration products, including Power Query, SSIS, DQS, MDS, and the Data Management Gateway for Power BI. He has authored two books on SSIS (Apress, and MS Press), and is a frequent presenter at Microsoft conferences. You can find his blog at http://www.mattmasson.com/.
Vicky Harp
Twitter: - vickyharp
Contact: http://vickyharp.com
Vicky Harp is the Group PM Manager for the SQL Server Tools Team, which is responsible for the full set of experiences from drivers and scripting libraries, to GUI tools, to the Azure Portal. She has been building tools for SQL Server for 15 years.
Rob Volk
Twitter: - sql_r
LinkedIn: Rob Volk
Contact: http://weblogs.sqlteam.com/robv/
Rob Volk is a SQL Server DBA in the Metro Atlanta area since 2001. He also moderates and answers the forums on SQLTeam.com. While an old-time cranky DBA, he no longer considers quot;business intelligencequot; an oxymoron or quot;the cloudquot; as merely atmospheric moisture, and is delightedly dipping his toes into both of these new oceans, and loves to do things in new and and unusual ways.
Denny Cherry
Twitter: - mrdenny
LinkedIn: Denny Cherry
Contact: https://www.dcac.com
Denny Cherry is the owner and principal consultant for Denny Cherry Associates Consulting and has over a decade of experience working with platforms such as Microsoft Azure, Amazon AWS, Microsoft SQL Server, Hyper-V, vSphere, and Enterprise Storage solutions. Denny’s areas of technical expertise include system architecture, performance tuning, security, replication, and troubleshooting. Denny currently holds several Microsoft Certifications related to SQL Server 2000 through 2019, including being a Microsoft Certified Master, Microsoft MVP and VMware vExpert Award.
Tim Radney
Twitter: - @tradney
LinkedIn: Tim Radney
Contact: http://www.timradney.com
Tim is a Data Platform MVP and has a whole collection of Microsoft and other industry certifications. His experience includes HA/DR, virtualization, SSIS, SSRS, and performance tuning, among everything else SQL Server-related. Tim is very active and passionate in the SQL Community. He runs the Columbus GA SQL Users Group, has been a PASS Regional Mentor for a number of years, was named a PASS Outstanding Volunteer in 2012, and is a frequent speaker at user groups, SQLSaturdays and PASS Summits. Tim is one of the top ranked in karma on ask.sqlservercentral.com, answers questions as @tradney on Twitter, and blogs at http://timradney.com and SQLskills blog at http://www.SQLskills.com/blogs/tim.
Rafael Salas
Twitter: - @RafSalas
Contact: http://www.rafael-salas.com
Rafael Salas is a recognized speaker and published author with more than 17 years of experience in business intelligence and information architecture. He is the recipient of multiple industry recognition, including the Microsoft MVP Award and The Data Warehouse Institute Best Practices Award. Rafael is also an active member of the SQL Server technical community and blogs regularly at www.rafael-salas.com.
Denny Cherry
Twitter: - mrdenny
LinkedIn: Denny Cherry
Contact: https://www.dcac.com
Denny Cherry is the owner and principal consultant for Denny Cherry Associates Consulting and has over a decade of experience working with platforms such as Microsoft Azure, Amazon AWS, Microsoft SQL Server, Hyper-V, vSphere, and Enterprise Storage solutions. Denny’s areas of technical expertise include system architecture, performance tuning, security, replication, and troubleshooting. Denny currently holds several Microsoft Certifications related to SQL Server 2000 through 2019, including being a Microsoft Certified Master, Microsoft MVP and VMware vExpert Award.
Jon Boulineau
Contact: http://www.newsqlblog.com
Jon Boulineau is a 12 year it veteran currently working as a DBA for a Fortune 500 company. In addition to his work as a DBA he has survived phases as a network engineer, systems administrator, and developer in his career. He resides in Columbus, GA with his wife and four children.
Phil Pledger
Contact: http://www.SqlServerAssociates.com
Phil Pledger is a SQL Server consultant in Atlanta, GA and has spent almost 20 years working with SQL Server starting with version 4.2 on NT 3.1 and has worked with every version since. His focus is on schema design and performance tuning. He has a BS and MS in Computer Science from the University of Alabama.
Eric Melcher
Contact: http://www.profisee.com
Eric Melcher brings over 10 years of technology and consulting experience delivering data management and business intelligence solutions across a variety of industry verticals, with focuses on manufacturing, logistics, energy, services, and insurance. At Profisee, Eric leads the Master Data Management practice, guiding Profisee’s customers in the development of Master Data
Jim Wooley
Twitter: - jimwooley
LinkedIn: Jim Wooley
Contact: http://www.ThinqLinq.com
By day, Jim Wooley is a Solution Architect for Slalom Consulting, In his free time, Jim is a frequent speaker, MVP, and author of “LINQ in Action”. He has been active evangelizing LINQ since its announcement in 2005. In addition, he attempts to pass on the insights he has gained by being active in the community, including organizing and speaking at code camps and regional events, including VS Live, SQL Pass, KCDC, That Conference, TechBash, and CodeStock.
Christina Leo
Twitter: - christinaleo
Contact: http://christinaleo.net
Christina Leo is a Cloud Solution Architect at Microsoft specialising in the Data and AI Platform. Prior to joining Microsoft in 2016, she worked as an independent consultant focusing on T-SQL and BI development, as well as database performance tuning in the finance and investment banking sector. When she isn’t sharing her 18 years of technical experience with the data community, you can find her racing around the Solent on a 40’ sailboat or often in the Thames on a little Laser.
Melissa Coates
Contact: http://www.sqlchick.com
Melissa Coates is a Business Intelligence developer based in Charlotte, NC. As a Senior Consultant with Intellinet, she specializes in delivering BI and Data Warehousing solutions. Formerly a CPA, Melissa is ridiculously proud to be an IT geek. Her background gives her a valuable blend of technical, business, and training skills. When Melissa steps away from the laptop, you can probably find her hanging out with her border collie. Melissa blogs at http://www.sqlchick.com.
Adam Machanic
Twitter: - @AdamMachanic
LinkedIn: Adam Machanic
Contact: http://sqlblog.com/blogs/adam_machanic
Adam Machanic is a Boston-based SQL Server developer, writer, and speaker. He focuses on large-scale data warehouse performance and development, and is the author of the award-winning SQL Server monitoring stored procedure, quot;sp_WhoIsActive.quot; He has contributed to several books on SQL Server, including quot;T-SQL Queryingquot; (Microsoft Press, 2015). He is a Microsoft Most Valuable Professional (MVP) for SQL Server.
Grant Fritchey
Twitter: - @gfritchey
LinkedIn: Grant Fritchey
Contact: http://scarydba.com
Grant Fritchey is a Data Platform MVP with over 20 years’ experience in IT, including time spent in support and development. He has worked with SQL Server since 6.0 back in 1995. He has also developed in VB, VB.NET, C#, and Java. Grant has written books for Apress and Simple-Talk. Grant presents at conferences and user groups, large and small, all over the world. He joined Redgate Software as a product evangelist in January 2011.
Glen Gordon
Contact: http://blogs.msdn.com/glengordon
Glen is a Developer Evangelist with Microsoft. He works with communities of developers in the southeast, bringing them the resources they need to be successful using Microsoft technologies. Prior to joining Microsoft in 2003, Glen worked as an enterprise consultant, and prior to that, as a software trainer. Glen’s current passion is helping people build the next big thing in the Windows Phone space.
Grant Fritchey
Twitter: - @gfritchey
LinkedIn: Grant Fritchey
Contact: http://scarydba.com
Grant Fritchey is a Data Platform MVP with over 20 years’ experience in IT, including time spent in support and development. He has worked with SQL Server since 6.0 back in 1995. He has also developed in VB, VB.NET, C#, and Java. Grant has written books for Apress and Simple-Talk. Grant presents at conferences and user groups, large and small, all over the world. He joined Redgate Software as a product evangelist in January 2011.
Jeremy Carroll
Contact: http://thinkinsql.com
Sr. Consultant Intellinet MCITP SQL Dev and SQL DBA 2008
Hal Rottenberg
Contact: http://halr9000.com
Hal Rottenberg is a system engineer, Microsoft PowerShell MVP, and VMware vExpert living in Woodstock, Georgia. He has over thirteen years of experience in IT while working for such large enterprises as Hewlett-Packard, IBM, and The Home Depot. When it comes to IT, Hal’s passions are automation and virtualization. He is well-known in sysadmin circles for co-hosting the PowerScripting Podcast, and authoring a book titled “Managing VMware Infrastructure with PowerShell: TFM ”.
Geoff Hiten
Twitter: - SQLCraftsman
LinkedIn: Geoff Hiten
Geoff Hiten is a Technical Solutions Professional at Microsoft. Geoff began working with SQL Server in 1992 with version 4.2 and has used every version since. He specializes in highly available SQL systems, performance tuning, and systems migration. Geoff is heavily involved in the Microsoft SQL Server Community and was initially awarded MVP status in 2004. Geoff was appointed in 2011 to fill an interim Director position at the National PASS organization.
Wayne Sheffield
Twitter: - @DBAWayne
LinkedIn: Wayne Sheffield
Contact: http://blog.waynesheffield.com/wayne
Wayne Sheffield, a Microsoft Certified Master in SQL Server and Microsoft Most Valuable Professional, started working with xBase databases in the late 80’s. With over 25 years in IT, he has worked with SQL Server (since 6.5 in the late 90’s) in various dev/admin roles, with an emphasis in performance tuning. He is the author of several articles at www.sqlservercentral.com, a co-author of “SQL Server T-SQL Recipes”, and enjoys sharing his knowledge by presenting at SQL events worldwide and blogging at http://blog.waynesheffield.com/wayne
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.
Jessica Moss
Twitter: - @jessicammoss
Contact: http://www.jessicammoss.com
Jessica M. Moss is a well-known architect, speaker, author, and Microsoft MVP of SQL Server Business Intelligence. Jessica#39;s expertise includes data warehouse modeling, Integration Services ETL, Analysis Services semantic modeling, Reporting Services report design, and helping customers across industries successfully implement and enhance their BI solutions. She enjoys sharing her knowledge with the SQL community and has co-authored numerous technical books.
Mark Tabladillo
Contact: http://www.marktab.net
Mark Tabladillo (MVP, SAS Expert) has been an information technology professional since 1998, and has a primary career consulting with companies across the United States and around the world. Mark’s business mission is to empower and inspire executives, architects and developers with insights from data mining, predictive analytics and business intelligence to make actionable decisions. Mark shares his thoughts on his professional blog at http://marktab.net
Sponsors
The following is a list of sponsors that helped fund the event: