SQLSaturday #96 - Washington, DC 2011

Event Date: 11/05/2011 00:00:00

Event Location:

The Microsoft Technology Center
5404 Wisconsin Ave, Suite 700
Chevy Chase, Maryland

This event has completed. All data shown below is from the historical XML public data available.

Sessions
Speakers
Sponsors

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: Developing Date and Role-Playing Dimensions

Abstract: Let’s go from Cradle to Grave with the one dimension in 99.99999% of cubes, the dreaded Date dimension. Without this dimension users wouldn’t know if it is worth staying open on a holiday or which day of the week the most fresh produce ships or even what their bonus will be. What should be included in the dimension? Should you use the wizard to generate? In this session, we will explore a generic date dimension load script and configuring SSAS to use the table as the time dimension. We will explore performance considerations of attribute hierarchies compared with usability benefits of user hierarchies. Finally, we will address the advantages of role-playing dimensions to make Order Date, Ship Date and Received Date dimensions.

Speaker(s):

Sandra Mueller

Track and Room: BI - N/A

Title: How to get Hired in the first 10 minutes

Abstract: Are you looking for a career change? Good News! Technology is back on the move and companies are again hiring. We’ll cover key strategies you can use during the interviews first 10 minutes to increase chances for a new job and new adventure.

Speaker(s):

Chris Skorlinski

Track and Room: Prof. Dev. - N/A

Title: Monitoring Databases in a Virtual Environment

Abstract: When moving databases to a virtual environment the performance metrics DBAs typically use to troubleshoot performance issues such as O/S metrics, storage configurations, CPU allocation and more become unreliable. DBAs no longer have a clear, reliable view of the factors impacting database performance. Understanding the difference between the physical and virtual server environment adds a new dimension to the DBA tasks. This presentation describes the changes that DBAs need to make in their performance and monitoring practices.

Speaker(s):

Thomas LaRock

Track and Room: SAN/Virtualization/Denali - 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: (SSIS, TSQL and MDS) - Record Linkage Fuzzy Match

Abstract: We will implement several code samples based on a series of articles amd posts identifying similar records between two different sources or grouping of records from a single source, based on existing column string of values. We will define an approach, review actual implementations with various SQL tools(TSQL, VB,SSIS and MDS). There are many facets to review. I would like to start by drawing concepts from several articles from experienced practitioners, either from academia or the commercial market. They will be footnoted at the end of the session. Although we are discussing matching, we need to address several steps prior to getting to the actual use of matching algorithms

Speaker(s):

Ira Warren

Track and Room: BI - N/A

Title: Making Predictions with Microsoft Data Mining Tool

Abstract: Whether predicting customers, All Stars or concert set lists, the process and the tools remain the same. Microsoft’s Analysis Services Data Mining tools enable you to quickly profile your data, identify hidden relationships and predict future outcomes based on those relationships. Join me to see what data mining is, what data mining is not and how Microsoft’s data mining tools can help you analyze your business. During this session, I will walk us through a start-to-finish data mining prediction project. It’s easier than you might have thought.

Speaker(s):

Mark Hudson

Track and Room: Dev - N/A

Title: Banish RBAR!

Abstract: SQL Server is primarily designed for set-based operations, so code that performs Row-By-Agonizing-Row (RBAR) operations is going against the design, rather than working with it. Come to this code filled session, where we will examine several recent additions to SQL Server, and learn how the vast majority of RBAR code can be replaced with efficient, set-based code. Learn how the APPLY operator works; iterate through incoming data just once with the MERGE statement; “slice and dice” your data with the Windowing (ranking) functions; re-write your multi-statement table-valued functions to inline functions to help the optimizer and speed up your queries; learn how to create a grouped delimited list – without loops!

Speaker(s):

Wayne Sheffield

Track and Room: Dev - N/A

Title: PowerShell for SQL and New Denali Features

Abstract: This session will cover the new features of PowerShell in SQL Denali. The new module for SQL Server, the new module for SSAS, and the new Replica cmdlets for High Availability databases.

Speaker(s):

Aaron Nelson

Track and Room: SAN/Virtualization/Denali - N/A

Title: Introduction to Analysis Services

Abstract: Microsoft’s SQL Server Analysis Services is best known for its ability to build and manage OLAP data cubes. In addition to that core functionality, SSAS enables users to define key performance indicators (KPIs), profile data, mine data and predict future activities using the results of that mining. Perhaps best of all, SSAS is included as part of SQL Server 2008 Standard and Enterprise Editions. This session introduces the audience to the capabilities of SSAS, businesses uses for those tools and ways to integrate SSAS with Integration Services and Reporting Services.

Speaker(s):

Mark Hudson

Track and Room: BI - N/A

Title: Automating Database Source Control

Abstract: Track source code changes and manage the synchronization between the source control system and your database. Using SQL Source Control and your favorite source control system, this task can be automated, and you can catch those sneaky developers making changes they forgot to tell you to source.

Speaker(s):

James Gaines

Track and Room: DBA/Dev - N/A

Title: Virtualization for SQL DBAs

Abstract: Want to know about VMWare and what it means for your databases? This session will go through the hardware and terminology around this technology. Learn how to optimize your SQL Servers for VMs and what to tell your storage engineers.

Speaker(s):

Joseph D’Antoni

Track and Room: SAN/Virtualization/Denali - N/A

Title: Change Data Capture in SQL Server 2008

Abstract: In this session, I’ll talk about Change Data Capture (CDC) terminology and configuring a database for Change Data Capture. I’ll show how to read CDC log tables, and show CDC code samples. I’ll discuss CDC and SQL Server Agent jobs, and the use of CDC versus database triggers (and where triggers are still needed). Also, the impact of CDC on the transaction log and system performance will be explored. Finally, I’ll talk about how to deal with schema changes, performance tuning, and using CDC in an ETL (Extract-Transform-Load) environment with SQL Server Integration Services.

Speaker(s):

Kevin Goff

Track and Room: DBA/Dev - N/A

Title: What’s new in Denali - a whirlwind tour

Abstract: Have you ever gotten whiplash as you twist your head in fifty directions, trying to research all the new features in a product? In this session, I’ll go through all the new features in SQL Server Denali. I won’t focus excessively on any one feature - instead, I’ll go through as many new features in SQL Server Denali as time permits.

Speaker(s):

Kevin Goff

Track and Room: SAN/Virtualization/Denali - N/A

Title: Join operations - Explaining Merge,Hash and Loop

Abstract: In this session we’ll look in depth at the three main types of join operations (Nested Loops, Hash and Merge) in order to understand how query plans are computed. We will look at the performance of Hash and Merge joins in different scenarios and explain why they are sometimes associated with poor performing queries.

Speaker(s):

Luke Jian

Track and Room: Dev - N/A

Title: Entity Strategies: Structuring Your Consultancy

Abstract: Independent BI consultant, MSSQL Server MVP, and practicing CPA Bill Pearson examines the various options available for organizing and protecting your consulting business. In this section, he covers C Corp, S Corp, LLC, Partnership, and Sole Proprietorship (“Schedule C”) options, as well as other practical advice (trademarks, etc.) useful in forming your business entity.

Speaker(s):

William E Pearson III

Track and Room: Prof. Dev. - 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: Windows Failover Clustering Basics for the DBA

Abstract: While you can see how to run through Wizards deploy a failover cluster in 60 minutes in other places, what a DBA really needs is a solid foundation of Windows to truly be able to understand that implementation and its subsequent administration. This session will demystify the Windows layer of clustering and present it from a DBA focus. Using Windows Server 2008 R2, some of the topics that will be shown are: failover cluster validation and its impact on installing SQL Server, a tour of the new Failover Cluster Manager and how it can be used for administration, using the new cluster logs for troubleshooting, and more.

Speaker(s):

Allan Hirt

Track and Room: DBA - N/A

Title: Intro to Common Table Expressions

Abstract: Common Table Expressions (CTEs) serve two main functions: first they remove the clutter of subqueries out of the FROM clause while simultaneously making them easy to reference multiple times by alias if need be, and second they make it possible to do recursive queries. Learn the basics of using CTEs to streamline T-SQL code and to query self-referential tables.

Speaker(s):

Geoff Johnson

Track and Room: Dev - N/A

Title: Leadership Coaching: A repeatable methodology…

Abstract: Leadership coaching is the practice of using relational influence, the people kind, not the database kind, to develop and empower adult leaders. Coaching embraces a set of structured techniques designed to help you make other people more effective in reaching their goals and developing as leaders and can be a powerful tool for developing and managing teams in a technical environment.

Speaker(s):

Brian Moran

Track and Room: Prof. Dev. - N/A

Title: An intro to Oracle Databases for SQL Server DBAs

Abstract: An overview of basic database architecture and operations such as startup, shutdown, backup, redo log, alert log, tablespaces, etc. for SQL Server database professionals. This will provide a broad look at Oracle 11g from a DBA perspective. This session will give you a basic understanding of the terminology and command structure used in daily operations. It is not that complicated, come and see for yourself.

Speaker(s):

James Gaines

Track and Room: Prof. Dev. - N/A

Title: Build Your SQL Server Career

Abstract: Do you have the needed skills for your SQL Server career? Whether you are looking to land your first job or advance into a managerial position, this session will offer recommendations to you. From interview tips to skills all employers are looking for in SQL Server professionals, this session will benefit you.

Speaker(s):

Jeremy Kadlec

Track and Room: Prof. Dev. - N/A

Title: Getting Spatial with SQL Server 2008

Abstract: One of the great features of SQL Server 2008 is its native support for spatial data types. Spatial data represents information about the physical location and shape of geometric objects. These objects can be point locations or more complex objects such as countries, roads, or lakes. This session looks at how you can take advantage of this support for spatial data to enhance your location based applications in new and interesting ways. You will learn how to load and query spatial data in SQL Server as well as how to present the data in a Bing map.

Speaker(s):

Dan Clark

Track and Room: DBA/Dev - N/A

Title: Transactional Replication – Follow the Data

Abstract: Okay, you’ve run the Wizard and have Replication up and running; but how does it really work? Learn the behind the scenes for Transactional Replication as we follow the data from Publisher to Subscriber. We’ll look at both design and troubleshooting techniques to ensure your data is moving at near-real-time through your topology.

Speaker(s):

Chris Skorlinski

Track and Room: DBA - N/A

Title: Mining XML Query Plans

Abstract: Execution plans contain a lot of information that can guide you in your performance tuning process. Since SQL 2005 it is possible to retrieve the execution plans stored in the cache using DMVs and DMFs. However, as they are stored in XML format it can be cumbersome and difficult to extract the information you need. In this session, you will learn how the XML query plan is structured and how to use SQL Server’s built-in XQuery language to extract information. Examples include indexes that the optimizer indicates would increase performance if implemented and queries that use table scans or nested loop joins.

Speaker(s):

Sebastian Meine

Track and Room: DBA - N/A

Title: PowerShell: A Tale of Two Checklists

Abstract: It was the worst of times. It was the age of foolishness. I had a long-winded, manual, GUI-intensive checklist for configuring new SQL Server installations. Automating that checklist with PowerShell and SMO ushered in the best of times and an age of wisdom. In this session, we will walk through my new automated checklist, make the case for using PowerShell for such tasks, and point those still mired in the winter of despair and manual drudgery towards the spring of hope that is scripting and automation.

Speaker(s):

Brian Garraty

Track and Room: SAN/Virtualization/Denali - N/A

Title: Understanding Indexes

Abstract: This session will focus on the internals of index and how they are structured at a physical level. Understanding how indexes are structured can then help understand how they can help improve query performance by reducing lookups, serving as a covering index, etc. The session will use DBCC Page/Ind to look at how different types of indexes are structured and make some suggestions on the best way to structure tables, keys, and indexes to get the best performance from them. Will also cover index options that can affect how indexes are structured and how Index Rebuild/Reorg work at the physical level.

Speaker(s):

Ashton Hobbs

Track and Room: DBA/Dev - N/A

Title: How to Increase Development Productivity in SSRS

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: BI - N/A

Title: Thwarting Database Defects

Abstract: It’s bad enough to spend hours finding and fixing database defects, explaining to the rest of the team what went wrong and trying to clean up the mess. It’s even worse when a defect causes the end-user to make a bad decision. Database defects are far too costly and most testing practices do not adequately detect or prevent them. This presentation introduces tSQLt, a framework for automated database unit testing. You’ll learn techniques to write SQL code that is resilient to defects and is easier to change and maintain.

Speaker(s):

Dennis Lloyd Jr

Track and Room: Prof. 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: BI - N/A

Title: SAN Basics for DBAs

Abstract: Curious as to what a LUN is? Or what RAID level you should use for you database files? This session will cover the basics of what a SAN is, how it works, and how to talk to your SAN Admins. We will also discuss various ways to configure SQL Server for optimal I/O.

Speaker(s):

Joseph D’Antoni

Track and Room: SAN/Virtualization/Denali - N/A

Title: Model-Driven Database Design

Abstract: Model-Driven Database Development: Myths, Magic and Methods. In this presentation, Karen discusses data model-driven database development from the point of view of the Data Architect, the DBA, and the Developer. She will cover topics such as “Who does what?”, “Why are we doing this?”, “Do I have to Use a GUI?” and “Just who do you think you are?”. Finally, 10 tips for making model-driven database development successful in your organization’s culture and environment.

Speaker(s):

Karen Lopez

Track and Room: Dev - N/A

Title: SQL Server XML 101

Abstract: XML processing become more and more a part of our daily life. Today anyone, DBA or Developer, interferes one way or another with XML-based processes. In the SQL Server XML 101 session I’ll go over all XML data types from “ground zero” to advanced tricks and tips. Using real life examples I’ll show most efficient ways to work with an XML of any complexity and size. I’ll cover the problems that you can anticipate to deal with with XML. How to: load the files using T-SQL code, dynamically retrieve and element or attribute, use different XML data types’ methods and functions.

Speaker(s):

Alex Grinberg

Track and Room: DBA - N/A

Title: Intro to Ranking and Aggregate Window Functions

Abstract: Window functions greatly simplify the syntax and efficiency of queries that mix scalar with aggregate values. Learn how to add aggregate values to a query result without a GROUP BY clause, how to add row numbers and ranking values to query results, and how to subdivide a set of results evenly into a given number of parts.

Speaker(s):

Geoff Johnson

Track and Room: Dev - N/A

Title: Optimizing SQL Server I/O with Solid State Drives

Abstract: Optimal configuration and maintenance of the I/O subsystem is critical and can ultimately be responsible for higher response times of your applications. The HDDs are by design about 1 million times slower than the memory or CPU. In this session we analyze the different options that exist for durable storage, what are their pros and cons . Solid state drives are a viable option and we are going under the covers to see how you can best use them as an alternative to a large and expensive SAN in your infrastructure

Speaker(s):

Luke Jian

Track and Room: DBA - N/A

Title: Understanding (B)locking

Abstract: This session will cover how SQL server uses locking in queries and how that can lead to blocking issues. The session will provide a detailed view into what happens for each of the different isolation levels available within SQL Server and discuss how each one can affect locking/blocking within the system. The session will then discuss how to use SQL Server tools such as SQL Profiler, DMVs, and Extended Events to detect and resolve locking/blocking issues within SQL Server.

Speaker(s):

Ashton Hobbs

Track and Room: DBA/Dev - N/A

Title: An Overview of PowerPivot

Abstract: In this presentation, Microsoft BI Architect and SQL Server MVP Bill Pearson explores “self-service BI” as a concept. We then provide a walkthrough of the primary features of PowerPivot, focusing on how we can exploit its capabilities to offer the benefits of BI to decision makers and analysts throughout our organizations. “There’s no service like self-service …”

Speaker(s):

William E Pearson III

Track and Room: BI - 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.

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!”

James Gaines

Contact: http://allkindsofdatabasestuff.blogspot.com/

James Gaines currently works as a Custom Software Developer in the area of Database Development for Mylan, Inc. utilizing SQL Server and .Net technologies. In the past he has worked with a variety of databases and operating systems, as a Database Administrator / System Administrator. He specializes in OLTP database implementations, support and tuning.

Mark Hudson

Twitter: - HMarkHudson

Mark Hudson is an MCITP with many years of experience in business intelligence and data analysis. He has developed data solutions using numerous platform tools including multiple SQL Server versions. He is a data architect and developer with CapTech (www.captechconsulting.com) and served as a leader of the Richmond SQL Server User Group (www.richmondsql.org).

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

Mark Hudson

Twitter: - HMarkHudson

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”.

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

Joseph D’Antoni

Twitter: - jdanton

LinkedIn: Joseph D’Antoni

Contact: http://joeydantoni.com

Jeremy Kadlec

Contact: http://www.edgewoodsolutions.com

Jeremy Kadlec is the CTO @ Edgewood Solutions, co-founder of MSSQLTips.com, co-leader of the Baltimore SQL Server Users Group and a SQL Server MVP.

James Gaines

Contact: http://allkindsofdatabasestuff.blogspot.com/

Allan Hirt

Twitter: - SQLHA

LinkedIn: Allan Hirt

Contact: http://www.sqlha.com/blog

SQLHA, LLC founder, consultant, trainer, author, and business continuity, infrastructure, and virtualization expert Allan Hirt has been working with SQL Server since 1992 when it was still a Sybase product. He has also been clustering in Windows Server since the late 1990s when it was known as Wolfpack. Currently a dual Microsoft MVP (Data Platform; Cloud and Datacenter Management) as well as a VMware vExpert, Allan works with all sizes of customers, no matter if they are on premises or in the public cloud. He also delivers training and speaks at events over the world.

Dennis Lloyd Jr

Twitter: - @dennislloydjr

Contact: http://www.testdrivendatabases.com

Dennis Lloyd is a software development coach at Curiously Correct. He has broad experience in the software development life-cycle with specialized focus on Agile practices and database technologies. He is co-founder of the tSQLt unit testing framework for SQL Server and is active in the SQL Server open source community.

Ira Warren

Over 35 years experiences in Software Sevelopemt, IT Management and BI Architecture.

Alex Grinberg

LinkedIn: Alex Grinberg

I have more than 20 years of IT experience. My primary focus is with the latest Microsoft technologies including .NET (VB and C#), SSRS and SSIS. I provide services in tuning, optimization, analysis and development for the creation of new applications, converting legacy technologies (SQL Server, VB.NET and C# ) and site training. I have worked for CSC, VerticalNet, IDP, LSAC , and TMNAS (to name a few) and I am currently employed with Cox Automotive. I am Apress author book “XML and JSON Recipes for SQL Server”, also wrote number of articles for Simple-Talk and SQLServerCentral.com

Dan Clark

LinkedIn: Dan Clark

Contact: http://drclarkblog.wordpress.com/

Dan Clark is a senior data analytics consultant. He is focused on all things data analytics and training others how to get value from their data. Dan has published several books and numerous articles on .NET programming and data analytics. He is a regular speaker at various developer and database conferences and user group meetings and enjoys interacting with the Microsoft developer and database communities. His latest book Beginning Power BI published by Apress is a will get you up and running with self-service data analytics on the Power BI platform in no time.

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

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

Chris Skorlinski

Chris Skorlinski has been with Microsoft for 17 years. He is a Support Escalation Engineer at the Microsoft Charlotte NC office specializing in performance tuning and troubleshooting Replication. His is a contributor to SQLShare.com training as well as his own BLOGs on Replication Performance at http://blogs.msdn.com/ReplTalk/. #160;

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.

William E Pearson III

Twitter: - @Bill_Pearson

LinkedIn: William E Pearson III

Contact: https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E

Chris Skorlinski

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.

Sebastian Meine

Twitter: - @sqlity

LinkedIn: Sebastian Meine

Contact: http://sqlity.net/en/blog/

Sebastian Meine, Ph.D. is the SQL Stylist behind sqlity.net llc. In 2010 he founded sqlity.net to fully engage in his passion for SQL Server. Armed with a Ph.D. in Computer Science and years of experience in architecting DBs for a global Fortune 50 company, Sebastian now provides training and consulting services for his clients, specializing in SQL Server Security, Test Driven Development and Performance. Sebastian is an experienced public speaker, published author, president of the Philly PASS Chapter, PASS Regional Mentor and coauthor lead developer of tSQLt.

Geoff Johnson

Twitter: - @chaunticleer86

Contact: http://selectstatements.blogspot.com

Geoff is the BI Developer for Custom Data Systems, Inc., a software company offering data management for CPA associations and similar non-profit groups. He has been working with SQL Server for over fifteen years, with a focus on BI and SSRS for 6+ years. Since January of 2016 he has been designed and implemented a data warehouse solution for CDS, Inc. He is an active member of the Richmond SQL Server User Group and counts it a privilege to share what he has learned the hard way with others so they don’t have to. He also occasionally blogs about his lessons learned.

Brian Garraty

Contact: http://NULLgarity.wordpress.com

Brian Garraty is a DBA for Virginia Beach City Public Schools. Brian has over a decade of experience working with SQL Server including spending the past 7 as a full-time DBA. Prior to switching to the DBA role, Brian worked primarily as a Windows and web developer. Brian is an MCITP: Database Administrator.

Luke Jian

Twitter: - @sensware

LinkedIn: Luke Jian

Contact: http://blog.sqlpositive.com

Luke Jian is an experienced database architect with a leading healthcare information company. A frequent speaker at conferences and local user groups he has 15+ years of experience in database design, development and optimization on SQL Server and Big Data projects.

Ashton Hobbs

Ashton Hobbs has been using SQL Server for over 16 years going all the way back to SQL Server 6.5 and even a stint on Sybase/Watcom. Ashton has created tools to use with SQL Server including creating ApexSQL Edit/Debugger and currently working on MySSMS and other addins for SQL Server. Ashton also is a parter at High Order Function, providing development, SQL, and consultant services to government and private industry.

Sandra Mueller

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.

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.

Luke Jian

Twitter: - @sensware

LinkedIn: Luke Jian

Contact: http://blog.sqlpositive.com

Brian Moran

Twitter: - @briancmoran

LinkedIn: Brian Moran

Contact: http://www.linchpinpeople.com/author/brian-moran/

Brian Moran is Chief Servant Officer at Linchpin People and has been active in the SQL Server community for more than 20 years. Brian co-founded one of the first SQL Server user groups in the world, was one of the first SQL Server MVPs, was on the SQL Server Magazine launch team, and has served on the PASS Board of Directors in two separate terms. Brian#39;s roles in the SQL Server community include technologist, author, community leader, and entrepreneur.

Wayne Sheffield

Twitter: - @DBAWayne

LinkedIn: Wayne Sheffield

Contact: http://blog.waynesheffield.com/wayne

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.

Geoff Johnson

Twitter: - @chaunticleer86

Contact: http://selectstatements.blogspot.com

Ashton Hobbs

SQLSaturday #96 - Washington, DC 2011

Sessions

Title: Developing Date and Role-Playing Dimensions

Title: How to get Hired in the first 10 minutes

Title: Monitoring Databases in a Virtual Environment

Title: Table Vars Temp Tables - What you NEED to Know!

Title: (SSIS, TSQL and MDS) - Record Linkage Fuzzy Match

Title: Making Predictions with Microsoft Data Mining Tool

Title: Banish RBAR!

Title: PowerShell for SQL and New Denali Features

Title: Introduction to Analysis Services

Title: Automating Database Source Control

Title: Virtualization for SQL DBAs

Title: Change Data Capture in SQL Server 2008

Title: What’s new in Denali - a whirlwind tour

Title: Join operations - Explaining Merge,Hash and Loop

Title: Entity Strategies: Structuring Your Consultancy

Title: Data Files and Transaction Logs – Beyond the GUIs

Title: Windows Failover Clustering Basics for the DBA

Title: Intro to Common Table Expressions

Title: Leadership Coaching: A repeatable methodology…

Title: An intro to Oracle Databases for SQL Server DBAs

Title: Build Your SQL Server Career

Title: Getting Spatial with SQL Server 2008

Title: Transactional Replication – Follow the Data

Title: Mining XML Query Plans

Title: PowerShell: A Tale of Two Checklists

Title: Understanding Indexes

Title: How to Increase Development Productivity in SSRS

Title: Thwarting Database Defects

Title: Designing an SSIS Framework

Title: SAN Basics for DBAs

Title: Model-Driven Database Design

Title: SQL Server XML 101

Title: Intro to Ranking and Aggregate Window Functions

Title: Optimizing SQL Server I/O with Solid State Drives

Title: Understanding (B)locking

Title: An Overview of PowerPivot

Speakers

Sponsors