SQLSaturday #33 - Charlotte 2010

Event Date: 03/06/2010 00:00:00

Event Location:

Microsoft Charlotte Office
8050 Microsoft Way
Charlotte, North Carolina

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: PowerShell Awesomesauce

Abstract: In this session we will begin exploring the amazing world of the PowerShell language. We will compare cmdlets/operations to similar syntax/patterns in the T-SQL language. We’ll also step through one of the most talked about topics (the foreach-object command). PowerShell has been bragged about since the beginning because of how much you can accomplish in just one line of code. When you leave this session YOU will be bragging about what YOU can do in just ONE line of code!

Speaker(s):

Aaron Nelson

Track and Room: Track 8 - N/A

Title: Top 10 Mistakes on SQL Server

Abstract: SQL Server encompasses a wide variety of domains – administrative, development, and design. But despite years of experience with relational databases, SQL Server practitioners frequently make the same mistakes over and over again. Wouldn’t you like to learn about those mistakes before they ever happen? This session will answer questions like:

What’s the most common Transact-SQL programming mistake and how do I fix it?
How do database designers cause problems for future generations of application developers and database administrators?
Why do inexperienced database administrators make their own job more difficult and less efficient?

Speaker(s):

Kevin Kline

Track and Room: Track 1 - N/A

Title: Partitioning in SQL Server 2005/2008

Abstract: • What is partitioning? • Why and when to partition your data? • History of Partitioning in SQL Server • How does partitioning in SQL Server compare to partitioning in Oracle? • Understanding partitioning in SQL Server and types of partitioning • Benefits of partitioning • Organizing partitions: File groups, files, partitions, indexes and constraints • Partition operations - merge/split partitions, exchange partitions to tables and vice versa (switch in and switch out) • Partitioning and archiving • System tables related to partitioning • Demoes • How to build a generic framework to manage partitioning? • How to convert non-partitioned tables into patitioned tables and vice versa? • Best practices • Downloads/References

Speaker(s):

Jana Sattainathan

Track and Room: Track 2 - N/A

Title: Delivering BI Solutions Rapidly using Vulcan

Abstract: SQL Server, Integration Services, and Analysis Services are used together to deliver BI solutions but development efforts are carried out separately, without sharing of metadata between the products. This creates duplicate effort and compromises the ability to develop agile, iterative solutions. Vulcan is an open source project from Microsoft (http://vulcan.codeplex.code) that helps bridge this gap, while also providing many of the benefits of code focused approaches used in application development. It allows you to define the relational data marts, ETL, and OLAP cube portions of your BI solution in a common language, and seamlessly uses that information to generate the appropriate database schemas, SSIS packages, and SSAS cubes.

Speaker(s):

John Welch

Track and Room: Track 9 - N/A

Title: Know Your IO: Gain Better Performance with Ease

Abstract: Understanding a SQL application’s data and storage needs is often overlooked - yet it can yield GREAT RETURNS when performance tuning. I will discuss and demonstrate how to plan for better performance with IO tuning.

Speaker(s):

Amy Styers

Track and Room: Track 5 - N/A

Title: As a DBA, Where do I start?

Abstract: Whether you are new to the role of DBA, being “forced” to take on the responsibility of one or are starting at a new role as a DBA, knowing where to start can often mean the difference between success or failure. In this chat, Mike will help us wade through the noise that attacks a DBA and figure out just what our priorities should be. By focusing on the “itties” of Database Administration (Recoverability, Availability - Health Performance - , Security and Reliability) we can see a natural priority build. Throughout this interactive discussion we will also have a look at some of the available tools and scripts to help us see where our environments rate with the “itties” of Database Administration.

Speaker(s):

Mike Walsh

Track and Room: Track 4 - N/A

Title: Build Your First SSIS Package

Abstract: This highly-interactive, demo-intense presentation is for beginners and developers just getting started with SSIS. Attend and learn how to build SSIS packages from the ground up.

Speaker(s):

Andy Leonard

Track and Room: Track 8 - N/A

Title: You Can Improve Your Own SQL Code

Abstract: In this talk, Mike will show us some of the tools that come with SQL Server and how they can be used to analyze the performance of our database code. We will take a quick walk through indexing, best practices, some quick tips and then have a more in depth look at Execution Plans, IO Statistics and Profiler. Plus as a DBA, Mike can give a few pointers in working with your organization’s own “Dr. No” along the way. Rough Agenda: • Review of Best Practices • Indexing/Table Structure High Level Overview • Will your queries use the index? • Query Plans don’t have to be scary • IO Statistics, Profiler • Put Them Together (Use the tools before you say, “Done!” • Interaction with the DBA (How to be a partner in performance with the DB

Speaker(s):

Mike Walsh

Track and Room: Track 2 - N/A

Title: SSIS, You, and ETL Architecture

Abstract: BOS30-200: SSIS, You , and Better ETLDid you already learned SSIS, and now want to get serious about ETL? Did you become an SSIS developer by accident, but wonder what makes a good ETL solution? Is your current SSIS solution falling apart and you need to revamp it? The Complexity and importance of Extract, Transform and Load (ETL) projects are often underestimated, and the consequences of a poor crafted solution would inevitable lead to maintenance nightmares, or worse yet to the failure of the whole project. In this session we will try to bridge SSIS and a ETL architecture based on good practices while looking to some lessons learned from real world implementations.

Speaker(s):

Rafael Salas

Track and Room: Track 9 - N/A

Title: PowerShell for Data Professionals

Abstract: In this session we will learn to perform several everyday DBA tasks like backing up user databases, scripting table objects and evaluating disk space usage with PowerShell. For each tasks we will explore the benefits is using PowerShell over the standard method. Only a basic understanding of PowerShell or DOS is needed. This session should serve as a good introduction to PowerShell for database users. The goal is to get data professionals feet wet about PowerShell.

Speaker(s):

Aaron Nelson

Track and Room: Track 8 - N/A

Title: SQL Server Internals Architecture

Abstract: Let’s face it. You can effectively do many IT jobs related to SQL Server without knowing the internals of how SQL Server works. Many great developers, DBAs, and designers get their day-to-day work completed on time and with reasonable quality while never really knowing what’s happening behind the scenes. But if you want to take your skills to the next level, it’s critical to know SQL Server’s internal processes and architecture. This session will answer questions like:

What’s different about 32- and 64-bit systems?
What are the various areas of memory inside of SQL Server?
How are queries handled behind the scenes?
What does SQL Server do with procedural code, like functions, procedures, and triggers?
…and much more.

Speaker(s):

Kevin Kline

Track and Room: Track 6 - N/A

Title: Growing Pains - A Cautionary Tale

Abstract: It happens to everyone. One day your database is humming along quietly serving up choice nuggets of information quickly and efficiently while growing at a slow, steady rate. Then next day, your database has quadrupled in size and performance has ground to a halt as the system strains under the load. Management is screaming for answers and you’re coworkers are running in circles screaming for their lives. In this session, we will examine best practices to apply to reporting databases that grow to become much larger than expected. We will examine a real-world scenario and discuss the strategies and techniques implemented in order to get the database back on track.

Speaker(s):

Brett Tomson

Track and Room: Track 5 - N/A

Title: Troubleshooting Transactional Replication

Abstract: This presentation will provide an overview of the techniques used by Microsoft SQL Server Replication Support team for troubleshoot Transactional Replication performance. Topics covered include: Overview of Agent Reader/Writer threads, Monitoring Replication Performance, Common causes of Latency, tools for identifying Replication latency, and best practices for improving Transactional Replication Performance.

Speaker(s):

Chris Skorlinski

Track and Room: Track 3 - N/A

Title: Clustering for Mere Mortals.

Abstract: Learn about the major changes in clustering in recent SQL and Windows releases and how clustering is something you can implement that will actually make your work life easier.

Speaker(s):

Geoff Hiten

Track and Room: Track 7 - N/A

Title: Applied SSIS Design Patterns

Abstract: This session is for experienced SSIS developers. Attend and learn the Parent-Child SSIS design pattern, how to leverage less-than-well-documented characteristics of SSIS to centralize logging, and how to pass variable values between parent and child packages by value and by reference.

Speaker(s):

Andy Leonard

Track and Room: Track 9 - N/A

Title: SSRS In the Enterprise - Surviving With a Smile!

Abstract: If you plan to use SSRS in a large enterprise there are many things you should do be successful - things that do not seem to have much prescriptive guidance for. The purpose of this session is to provide you with guidance around those administrative things you should do to have a successful, maintainable SSRS Site in a large Enterprise. We wll discuss

How should folder structure and security be set up? Are there best practices around data sources? Are SSRS 2008 Report Models Models ready for the enterprise? How should projects be organized?
Is Report Builder 2.0 good enough yet? What works well and what will cause you pain?

We will spend our time in a very practical discussion to help you get SSRS deployed and working.

Speaker(s):

Wayne Snyder

Track and Room: Track 3 - N/A

Title: Compression in SQL 2008

Abstract: This session will cover the different forms of compression in SQL 2008, Backup and Data compression. The session will also explore best practices and how to overcome some of the limitations within the different compression technologies.

Speaker(s):

Ashton Hobbs

Track and Room: Track 4 - N/A

Title: KEYNOTE: SQLSaturday Past, Present and Future

Abstract: SQLSaturday founders Andy Warren and Steve Jones, and current PASS President Rushabh Mehta, will conduct an open forum discussion on SQLSaturday – where it has been, and where it will be heading under PASS management. Microsoft’s Bill Walker will also be covering venue logistics, and CSSUG’s Peter Shire will be going over prize drawings and after-party details. PLEASE DO NOT MISS!

Speaker(s):

Andy Warren, Steve Jones, Rushahb Mehta

Track and Room: Track 1 - N/A

Title: SQL Server Service Broker in the Real World

Abstract: Microsoft SQL Server 2005 and 2008 include a fantastic feature that few people understand or use. That feature is the Microsoft SQL Server Service Broker. The SQL Service Broker is one of the least used features within the database engine, and that lack of use is simply from last of knowledge about the feature.

In this session we’ll dig into how to configure the service broker for not only intra-database message queuing, but database to database queuing as well as server to server database queuing. We will also dig into a real life scenario where the SQL Server Service Broker was used to do ETL from an OLTP database to an OLAP database in near real time for near real time reporting.

Speaker(s):

Denny Cherry

Track and Room: Track 7 - N/A

Title: SQL Server Performance Outside the Box

Abstract: This session will delve into a variety of unique and not-so-obvious correlation and analysis techniques using Windows performance metrics and SQL Server DMV’s to uncover previously hidden performance bottlenecks in your SQL Server systems.

Speaker(s):

Jeffry Schwartz

Track and Room: Track 6 - N/A

Title: Maximizing Plan Re-use in SQL 2008

Abstract: Lack of plan reuse is one of the biggest performance killers in SQL Server and almost everyone has experienced problems in this area before. We will explore exactly how to determine if this is an issue for you and more importantly, how to address it. See what factors determine if a plan gets reused or not and why. We will cover how to issue calls to the database that guarantee reuse and peak performance. Understanding this aspect of SQL Server is something every good DBA should be fully aware of and attending this session will get you the insight to get started immediately.

Speaker(s):

Andrew Kelly

Track and Room: Track 6 - N/A

Title: Storage for the DBA

Abstract: One of the biggest issues in database performance centers around storage. It’s also one of the hardest places to troubleshoot performance issues because storage engineers and database administrators often do not speak the same language. In this session, we’ll be looking at storage from both the database and storage perspectives. We’ll be digging into LUNs, HBAs, the fabric, as well as RAID Groups. In addition to theory, we’ll be looking at an actual EMC SAN so that we can translate what we see in the Storage Array with what we see on the actual server.

Speaker(s):

Denny Cherry

Track and Room: Track 1 - N/A

Title: Practical Performance Monitoring in SQL Server

Abstract: Do you know what counters, statistics, events and other information you should be collecting on a regular basis to properly monitor your SQL Server instances? Do you know where your current bottlenecks really are or how to even look for them. In this session we will cover the basics when it comes to monitoring the database, server and hardware that give us the biggest bang for the buck. See how a little bit of effort upfront can lead to a much better understanding of your database environment and put you in a position to spot potential issues before they become real trouble.

Speaker(s):

Andrew Kelly

Track and Room: Track 5 - N/A

Title: What’s New In SSRS 2008

Abstract: Microsoft SQL Server 2008 was released to much fanfare, excitement and anticipation in the IT community. The bevy of enhancements made to the various components coupled with sweeping performance gains made SQL Server 2008 one of the most competitive and feature-rich database platforms on the market. In this session, we will examine the enhancements made to Reporting Services in SQL Server 2008 as well as what changes to expect in R2 slated for release in early 2010.

Speaker(s):

Brett Tomson

Track and Room: Track 9 - N/A

Title: Tuna Helper for SQL Server DBA’s

Abstract: Many DBAs and developers are faced with tuning poorly performing SQL statements. There is no way to learn everything you need to know about SQL tuning in an hour, but you can learn a process to employ when badly written SQLs are ruining database performance. However, many tuning projects fail because the process being used is inefficient. This presentation will walk through a process Confio Software uses with great success and will include topics such as: SQL diagramming, wait type data, column selectivity, and several more that will help you succeed on future tuning projects.

Speaker(s):

Janis Griffin

Track and Room: Track 5 - N/A

Title: Incorporating Reporting Services into SharePoint

Abstract: Do you already have a SharePoint implementation and now you need reporting capabilities? Attend this session to learn about incorporating SQL Server Reporting Services into your existing SharePoint installation. We will discuss the reasons why you would want to do this, and how to install, use, and access SSRS reports from SharePoint.

Speaker(s):

Jessica Moss

Track and Room: Track 9 - N/A

Title: Diagnosing Connectivity Issues with SQL Server

Abstract: Evan will show you how to diagnose and solve common connectivity issues. This will include covering GNEs, Kerberos, and completely inaccessible SQL Servers. He will demonstrate how to use UDLs and network traces to easily identify the problem, plus provide tips that often solve the problem in seconds.

Speaker(s):

Evan Basalik

Track and Room: Track 3 - N/A

Title: Creating Custom Components for SSIS

Abstract: SSIS data flows are great tools for moving data. But what if you need to go beyond the out-of-the-box components provided with SSIS? Custom components are a great way to encapsulate and reuse functionality for the data flow in SSIS. We will discuss what it takes to create and deploy custom components in SSIS, review the pros and cons of using custom components instead of scripts, and discuss some of the common challenges and issues with creating them.

Speaker(s):

John Welch

Track and Room: Track 8 - N/A

Title: Adding SSRS Report Bells and Whistles

Abstract: Producing a good looking report will wow your business users even if your data isn’t all that impressive. If you’ve ever had trouble finding the best way to display that data or how to show trends appropriately, this is the session for you. We will review grouping logic, graphs, gauges, and more in Reporting Services 2008. With the knowledge in this session, you won’t ever need to show a plain, boring report again!

Speaker(s):

Jessica Moss

Track and Room: Track 9 - N/A

Title: Management Studio Tips Tricks

Abstract: A collection of tips, tricks and gotchas revolving around the use of Management Studio for database development, administration and maintenance. Will also outline a few alternative tools.

Speaker(s):

Aaron Bertrand

Track and Room: Track 2 - N/A

Title: Getting started in blogging and technical speaking

Abstract: Are you thinking of starting a blog? Or are you interested in presenting at events like SQLSaturday but not sure what to do to get started? This panel style session with established SQL bloggers will give you tips on blogging platforms, choosing topics, techniques for giving presentations, and sage advice from years of experience.

Speaker(s):

Kendal Van Dyke

Track and Room: Track 4 - N/A

Title: Collecting and Analyzing File Wait Statistics

Abstract: Since SQL Server 2000 we have had the ability to collect statistics on two key areas in terms of performance directly from within SQL Server. More specifically these are the File Wait statistics and the information that can be gleaned from these has increased dramatically with each new release. SQL 2008 currently has over 480 events so far. This session will show you how to efficiently capture and analyze the information provided by a set of DMV’s in SQL Server 2005 SQL Server 2008. This knowledge will dramatically decrease the amount of time spent looking for bottlenecks in your system.

Speaker(s):

Andrew Kelly

Track and Room: Track 6 - N/A

Title: Memory Management in SQL Server Analysis Services

Abstract: In this presentation Steve Wright will discuss methods used to manage memory in SQL Server Analysis Services, focusing primarily on memory limits and preallocation. He will also present some examples from the field of performance issues due to mis-configuration, how they were identified, and ultimately resolved.

Speaker(s):

Steven Wright

Track and Room: Track 3 - N/A

Title: Virtualize This!

Abstract: With the list of features of SQL Server growing constantly the need to sandbox and test drive features in a separate environment that can communicate with but not interfere with your existing environment has become vital. With virtualization, setting up consistent test, dev, and even sandbox environments can happen minutes instead of hours AND be consistent with previous/ existing environments. In this session we will focus on Microsoft Virtualization solutions that you can leverage starting with your desktop/laptop and extending to your server environments. Even if you aren’t going to be doing the virtualization yourself it’s good to know what your options are.

Speaker(s):

Aaron Nelson

Track and Room: Track 7 - N/A

Title: Introduction to SQL Server Statistics

Abstract: This beginner to intermediate level session will introduce you to statistics, including how to create, manage, troubleshoot, and more! Statistics are a key part of getting solid and repeatable performance and is easily just as important as having indexes. Whether you’re a DBA or trying to get by without one, this session will give you the information you need to know.

Speaker(s):

Andy Warren

Track and Room: Track 5 - N/A

Title: SQL Server Support Team QA

Abstract: Here’s your chance to speak directly with members of the SQL Server Support Team based in Charlotte.

Speaker(s):

Andy Warren, Steve Jones, Rushahb Mehta

Track and Room: Track 1 - N/A

Title: Comparison of Replication Technologies

Abstract: This sessions provides a high level overview and comparison of various Microsoft SQL Server Replication technologies including 1) Snapshot, 2) Change Tracking, 3) Change Data Capture, 4) Transactional, 5) Peer-2-Peer, 6) Merge Replication, 7) Web Sync, 8) Sync Services.

Speaker(s):

Chris Skorlinski

Track and Room: Track 3 - N/A

Title: The (Solid) State Of Drive Technology

Abstract: Solid State Drives are being heralded as game changers in the world of SQL IO. What was once was a costly technology only available to those with deep pockets is now becoming affordable for mainstream use. This session look into the how SSDs work, how they perform compared to traditional hard drives, and highlight the things you need to consider when implementing SSDs on your SQL Servers. Be sure not to miss a live demonstration of solid state technology in action!

Speaker(s):

Kendal Van Dyke

Track and Room: Track 7 - N/A

Title: Is Virtualization is a good choice for SQL Server?

Abstract: We’ll be looking into the pros and cons of moving SQL Servers into a virtual server environment. Specifically we’ll be looking into when it’s a good idea and when it’s probably not a good idea. Like all problems in the database world there are no hard set answers as to if virtualization is a good idea, but there are some times when virtualizing a SQL Server is a good idea, and can save you some money. There are some other times when you will be shooting yourself in the foot and shouldn’t. We’ll be focusing on when how to make this decision, and how to gather the metrics that you need in order to come to this decision.

Speaker(s):

Denny Cherry

Track and Room: Track 7 - N/A

Title: Parameter Sniffing

Abstract: In this session we will learn about:- What is parameter sniffing?- What can we do when it doesn’t help?- Statistics used by Sql Server- The OPTION clause- Plan Guides

Speaker(s):

Alejandro Mesa

Track and Room: Track 5 - N/A

Title: The Modern Resume: Building Your Brand

Abstract: Learn how to better set yourself apart from the pack in this presentation on building a modern resume and brand using social networking, volunteerism, blogging, and more. Presented by Steve Jones, founder of SQLServerCentral.

Speaker(s):

Steve Jones

Track and Room: Track 4 - N/A

Title: Building PowerPivot Models and Reports

Abstract: In this session, we will use the features of the PowerPivot add-in for Excel to import data from various sources, cleanse and prepare the data for analysis and finally use the data to build complex reports and publish. We will also take a look at Data Analysis Expressions (DAX) and how to use them to extend the functionality of the model and the reports.

Speaker(s):

Rushabh Mehta

Track and Room: Track 1 - N/A

Title: Insight Into Your Indexes With DMVs

Abstract: Use the right tool from your SQL toolbox to maintain those indexes, determine which indexes are being used (and more importantly which ones are NOT being used), and get recommendations on indexes to create all from Dynamic Management Views. Walk away with scripts you can use in your environment IMMEDIATELY.

Speaker(s):

Tim Ford

Track and Room: Track 6 - N/A

Title: SQL Azure: Data in the Cloud is a Good Thing

Abstract: Evan will talk about how SQL Azure works behind the scenes, plus demonstrate how to use the cloud-based sibling of SQL Server. He will also discuss how to best design your applications to take advantage of the power of SQL Azure.

Speaker(s):

Evan Basalik

Track and Room: Track 1 - N/A

Title: Things Your Mom Never Told You About SSMS

Abstract: This is a beginning to intermediate level presentation that aims to enlighten users of some of the more useful yet underutilized features of SQL Server Management Studio 2008. There will be explanations of the features and techniques as well as simple demonstrations throughout. This session provides something for both DBAs and developers of TSQL alike.

Speaker(s):

Jason Hall

Track and Room: Track 2 - N/A

Title: SQL Server Data Compression 101

Abstract: In this session I will explain SQL Server Data compression (Page and Row), provide scripts and tips that will help you identity the compression state that should be configured in your Warehouse environment and also provide demo scripts showing you how to configure compression at the Table and Index level.

Speaker(s):

Patrick LeBlanc

Track and Room: Track 4 - N/A

Title: Harnessing PowerPivot

Abstract: PowerPivot (project Gemini) introduces an innovative platform for self-service analysis. In this session, we will very briefly look at the user-facing features and functionality of PowerPivot before we dive deep into a behind-the-scenes look at PowerPivot, understand limitations and finally drill into some best practices and lessons learnt from actual customer implementations.

Speaker(s):

Rushabh Mehta

Track and Room: Track 7 - N/A

Title: Tips For The Lazy But Driven DBA

Abstract: Having had to support a large number of SQL Server instances as a solo DBA for many years I’ve developed a toolbox of scripts and arsenal of processes that I rely upon to give insight into disk space, file growth, backup status, Agent job outcomes, and login management. Some of these I’ve shared on various websites and blogs; others see the light of day for the first time in this session. Attendees leave the session with processes and code they can begin to use immediately.

Speaker(s):

Tim Ford

Track and Room: Track 2 - N/A

Title: Bad SQL.

Abstract: Learn to write (or at least recognize) T-SQL code that consumes hundreds of times more I/O and CPU Resources than optimal code. More importantly, see what the optimal counterpart looks like.

Speaker(s):

Geoff Hiten

Track and Room: Track 2 - N/A

Title: De-mystifying Query Plan Analysis

Abstract: If you never click on the estimated/actual query plan icons because it looks like a foreign language to you AND you want your queries to really run fast… This session is for you. Starting from the beginning, we’ll go through the key things to look for when reviewing your queries’ estimated and actual plans.

Speaker(s):

Dave Turpin

Track and Room: Track 4 - N/A

Title: Automate SQL Server Administration with PowerShell

Abstract: Most administrative functions consist of repetitive sequences of tasks which just take time. PowerShell is a powerful scripting environment which allows an administrator to automate those repetitive tasks, providing better results to the organization while saving the administrator time, and ensuring that the tasks get done properly every time. This session will give an introduction to PowerShell and demonstrate a number of scripts which help SQL Server administrators effectively manage their environments.

Speaker(s):

Allen White

Track and Room: Track 8 - N/A

Title: LUNCH!

Abstract: Meet for lunch in the Microsoft cafeteria!

Speaker(s):

Andy Warren, Steve Jones, Rushahb Mehta

Track and Room: Track 2 - N/A

Abstract: There are number of tools available on the market for the SQL Server performance troubleshooting. But do we use the full power of the internal SQL Server Data Management Views (DMVs)? Some very challenging issues can be solved using DMVs. What the Dynamic Management Views are? How diagnostics data is getting populated? Using the examples we are going to talk about diagnostic data analysis using T-SQL queries against SQL Server DMVs.

Speaker(s):

Sergey Pustovit

Track and Room: Track 6 - N/A

Title: Gather SQL Server Performance Data with PowerShell

Abstract: We all know how important it is to keep a baseline of performance metrics that allow us to know when something is wrong and help us to track it down and fix the problem. We don’t always know how to do this easily and consistently. This session will walk you through a series of PowerShell scripts you can schedule which will capture the most important data and a set of reports to show you how to use that data to keep your server running smoothly.

Speaker(s):

Allen White

Track and Room: Track 8 - N/A

Title: SQL Server 2008/R2 Overview

Abstract: During this session we will go over the features been introduced in SQL Server 2008 and upcoming SQL Server 2008 R2.

Speaker(s):

Sergey Pustovit

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

Aaron Bertrand

Contact: http://sqlblog.com/blogs/aaron_bertrand/

Aaron is a senior consultant for SQL Sentry, makers of performance monitoring and event management software for SQL Server, Analysis Services, and Windows. He has been blogging at sqlblog.com since 2006, focusing on manageability, performance, and new features; has been an MVP since 1997-98; and speaks frequently at user group meetings and SQLSaturday events.

Mike Walsh

Twitter: - mike_walsh

LinkedIn: Mike Walsh

Contact: https://www.straightpathsql.com

Mike Walsh is an experienced SQL Server professional and has worked with SQL Server since version 6.5. He has been in the role of DBA, developer, and performance tuner, but always leans on his DBA and tuning experience. He has been awarded the SQL Server (now Data Platform) designation 6 times since 2011 and is a current MVP. He runs a SQL Server consultancy focused on DBA services and cloud enablement. He has spoken several times at PASS and regional events. In his spare time, he runs a small farm with his family in rural New Hampshire and is a call Firefighter in his small town.

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.

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.

Mike Walsh

Twitter: - mike_walsh

LinkedIn: Mike Walsh

Contact: https://www.straightpathsql.com

John Welch

Twitter: - @john_welch

LinkedIn: John Welch

Contact: http://agilebi.com/jwelch

Jeffry Schwartz

Contact: http://www.sqlrx.com

Jeffry Schwartz is the Senior Systems Architect for ISI’s SQL Rx team, a group of professional consultants specializing in performance, optimization, tuning, and capacity planning for Windows Server and Microsoft SQL Server systems. Over a 37-year span, he has won numerous awards for the development and delivery of state-of-the-art consulting services, including more than 930 performance and capacity planning studies. Customers include Microsoft, who awarded SQLRx Data Management Solutions Partner of the Year in 2008 for his WinPerf Windows and SQL Server performance analysis software suite.

Andrew Kelly

Contact: http://sqlblog.com/blogs/andrew_kelly/default.aspx

Andrew J. Kelly is a SQL Server MVP with over 20 years’ experience with relational databases and application development but specializes in Performance, Scalability and Maintainability of large scale SQL Servers. He is a regular speaker each year and a contributing editor and writer for SQL Server Magazine.

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.

Aaron Nelson

Twitter: - SQLvariant

LinkedIn: Aaron Nelson

Contact: http://sqlvariant.com/

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.

Andy Warren, Steve Jones, Rushahb Mehta

Contact: http://www.sqlsaturday.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.

Jana Sattainathan

Twitter: - www.twitter.com/SQLJana

LinkedIn: Jana Sattainathan

Contact: http://www.sqljana.wordpress.com

Jana works as a Senior Oracle and SQL Server DBA at SCOR, a leading Reinsurance company in the world. He has spent most of his professional life around databases. At work, he has automated most aspects of his job using PowerShell.

Most recently, he created PowerPump, a “PowerShell Database Copy Server” for his company to copy 50 billion rows (> 20 TB,) from 4000+ of Oracle/SQL Server tables on a recurring basis to SQL Server targets for migration/testing. He has also fully automated the database deployment which supports all components of SQL Server and Oracle using PowerShell (with about 150 functions) that is tracked extensively.

Andrew Kelly

Contact: http://sqlblog.com/blogs/andrew_kelly/default.aspx

Kendal Van Dyke

Twitter: - SQLDBA

LinkedIn: Kendal Van Dyke

Contact: http://www.kendalvandyke.com

Kendal is a database strategist, community advocate, public speaker, and blogger. A practiced IT professional with over 15 years of SQL Server experience, Kendal excels at disaster recovery, high availability planning/implementation, amp; debugging/troubleshooting mission critical SQL Server environments. Kendal is a Senior Consultant on the Microsoft Premier Developer Support team and President of MagicPASS (http://magicpass.sqlpass.org), the Orlando, FL based chapter of PASS. Before joining Microsoft, Kendal was a SQL Server/Data Platform MVP from 2011-2016.

Alejandro Mesa

Over 10 years of development and experience with Microsoft SQL Server. Member of CSSUG and PASS. SQL Server MVP since 2007.

Jason Hall

Twitter: - @SQLSaurus

LinkedIn: Jason Hall

Contact: http://blogs.sqlsentry.com/jasonhall

Jason Hall (@SQLSaurus) leads SentryOne’s Product Management team, which is responsible for managing product design, development and delivery.

Jason has worked in varied technology roles for over 20 years and holds industry certifications including MCSE (legacy), MCSD, MCTS, MCPD, and PMC-III.

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;

Wayne Snyder

Contact: http://www.mariner-usa.com

Wayne Snyder is a SQL Server managing consultant for Mariner, a Microsoft Gold Certified Partner specializing in business intelligence and collaboration solutions. Wayne is a PASS Board of Directors member, former PASS President, a SQL Server MVP, an MCT, and an MCDBA.

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.

Chris Skorlinski

Kevin Kline

Contact: http://KevinEKline.com

Kevin Kline is the Director of Engineering Services at SQL Sentry. A Microsoft SQL Server MVP, Kevin is a founding board member of PASS, editor-in-chief of SQLServerPedia.com and the author of popular IT books like “SQL in a Nutshell” (O’Reilly Associates). His twitter handle is @kekline and he blogs at http://KevinEKline.com. Kevin is a top-rated speaker at industry trade shows and has been active in the IT industry for over 20 years.

Allen White

Twitter: - SQLRunr

LinkedIn: Allen White

Contact: http://dataperfpro.com/blog/

Aaron Nelson

Twitter: - SQLvariant

LinkedIn: Aaron Nelson

Contact: http://sqlvariant.com/

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.

Kendal Van Dyke

Twitter: - SQLDBA

LinkedIn: Kendal Van Dyke

Contact: http://www.kendalvandyke.com

Andy Leonard

Twitter: - AndyLeonard

LinkedIn: Andy Leonard

Contact: https://andyleonard.blog

Andy Warren

Twitter: - @sqlandy

Contact: https://sqlandy.com

Andy Warren is a SQL Server consultant and trainer based in Orlando, FL. Focusing on administration, performance tuning, and SQL Server patterns and practices, he’s been a SQL Server MVP since 2008. Andy served two terms on the PASS Board of Directors, was a founding principal in SQLServerCentral, and created both the SQLSaturday and SQLRally event models.

Sergey Pustovit

As an Architect in Parallel Data Warehouse Center of Excellence Sergey designs complex EDW solutions based on Massively Parallel Processing (MPP) approach. He has 20+ years of industry experience, working with distributed database systems, designing and developing software. Sergey serves on advisory board for the SQL PASS local chapter in Charlotte, NC.

Steven Wright

Twitter: - @SQL_Steve

LinkedIn: Steven Wright

Contact: https://blogs.sentryone.com/author/StevenWright/

Steve currently serves as Director of Advanced Analytics at SentryOne. As a member of the SentryOne team for over 13 years, Steve has broad experience working in various environments supporting the Microsoft Data Platform both on-prem and in the cloud. Steve has earned the Microsoft Professional Program Data Science Certification and manages a team of Data Scientists and BI Developers in support of SentryOne’s internal and product facing advanced analytics initiatives.

Andy Warren, Steve Jones, Rushahb Mehta

Contact: http://www.sqlsaturday.com

Amy Styers

Contact: http://www.jediprincess.net

Amy Styers is a Microsoft Infrastructure Architect in the EMC Commercial Solutions Advisory Group where she has been engaged for the last three years discussing with customers their options for highly available, highly scalable, high performing Microsoft applications. She regularly addresses customers with regards to their virtualization initiatives and helps customers make decisions regarding architecting their Microsoft infrastructures both in physical and virtual environments.

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.

Dave Turpin

Contact: http://www.daveturpin.com

Dave is the resident SQL Server (and Netezza) DBA for Quaero, a marketing automation firm and subsidiary of CSG International. He has been working as an information professional for so long that his numerous degrees have no bearing on his work days. He has been working with SQL Server since the glory days of 6.5 circa 1996.

When not DBAing, he can be found cruising Charlotte greenways and bike trails on one wheel.

Andy Warren, Steve Jones, Rushahb Mehta

Contact: http://www.sqlsaturday.com

Denny Cherry

Twitter: - mrdenny

LinkedIn: Denny Cherry

Contact: https://www.dcac.com

Tim Ford

Contact: http://thesqlagentman.com

Tim Ford is a Microsoft SQL Server MVP and co-founder of SQL Cruise (sqlcruise.com). He is currently a Senior DBA and the SQL Server SME with Spectrum Health, a major healthcare system located in West Michigan. He is the leader of the West Michigan SQL Server Users Group (westmisql.org) and is a community speaker and author. His book with Louis Davidson: Performance Tuning With SQL Server Dynamic Management Views is now widely available.

Patrick LeBlanc

Contact: http://www.patrickdleblanc.com

Patrick LeBlanc, SQL Server MVP and author, is currently a Business Intelligence Architect for Pragmatic Works. He has worked as a SQL Server DBA for the past 9 years. His experience includes working in the Educational, Advertising, Mortgage, Medical and Financial Industries. He is also the founder of TSQLScripts.com, SQLLunch.com and the President of the Baton Rouge Area SQL Server User Group. Patrick is a regular speaker at various SQL Server community events.

Evan Basalik

Contact: http://blogs.msdn.com/psssql

Evan spent 10 years doing RD for a major textile manufacturer. He joined Microsoft 4.5 years ago and is currently a Support Escalation Engineer on the SQL Server team. He specializes in connectivity, database client code, and Reporting Services. He has been working on SQL Azure since before it was even called SQL Azure.

Rushabh Mehta

Twitter: - @rushabhmehta

LinkedIn: Rushabh Mehta

Contact: http://blogs.solidq.com/RushabhMehta

Rushabh Mehta is a Business Intelligence Mentor with SolidQ and the Managing Director for Solid Quality India Pvt. Ltd. He served as PASS President for 2010/2011 term.

Rushabh has worked with MS Data Platform since 1998 and has designed and developed BI systems since 2001. He has been the lead architect for many large-scale and complex BI solutions for clients such as Publix, Raymond James, Jackson Hewitt, US Dept. of Defense, and Microsoft. He is an MVP with Microsoft, Damp;B amp; Melissa Data

Brett Tomson

Brett Tomson is an independent consultant specializing in delivering solutions using the Microsoft Business Intelligence stack and related .NET technologies. He is an accomplished architect and developer of large-scale enterprise systems as well as an author and mentor to others. Brett has been using SQL Server actively for the past 12 years and is the Chapter Leader of the Triangle SQL Server User Group (http://www.tripass.org).

Geoff Hiten

Twitter: - SQLCraftsman

LinkedIn: Geoff Hiten

Microsoft MVP Geoff Hiten is a Principal SQL Server consultant for Intellinet.#160; Geoff began working with SQL Server in 1992 with version 4.2 and has used every version since.#160; He specializes in high-availability and high-performance SQL systems.#160; Recent projects include: system upgrades, SQL Server platform migrations, performance tuning, custom reporting solutions, and database strategy implementations.#160;#160; Geoff is currently on the leadership team of the Atlanta area Microsoft Database Forum Use

Rafael Salas

Contact: http://rafael-salas.blogspot.com

Rafael Salas is a Senior Consultant at Mariner, a BI focus consultant firm, where he helps organizations improve performance through Business Intelligence and Data Warehousing solutions. He has been a SQL Server evangelist since he started using the 2005 since CTP days. He is a SQL Server MVP, MCTS and an active member of the user’s communities, where he provides guidance on the use of the SQL Server tools. You can find Rafael’s blog at http://rafael-salas.blogspot.com/

Steve Jones

Twitter: - way0utwest

LinkedIn: Steve Jones

Contact: http://www.voiceofthedba.com/

Steve Jones is a Microsoft SQL Server MVP and has been working with SQL Server since version 4.2 on OS/2. After working as a DBA and developer for a variety of companies, Steve co-founded the community website SQLServerCentral.com in 2001. Since 2004, Steve has been the full-time editor of the site, ensuring it continues to be a great resource for SQL Server professionals. Over the last decade, Steve has written hundreds of articles about SQL Server for SQLServerCentral.com, SQL Server Standard magazine, SQL Server Magazine, and Database Journal.

Brett Tomson

Tim Ford

Contact: http://thesqlagentman.com

Denny Cherry

Twitter: - mrdenny

LinkedIn: Denny Cherry

Contact: https://www.dcac.com

Evan Basalik

Contact: http://blogs.msdn.com/psssql

Geoff Hiten

Twitter: - SQLCraftsman

LinkedIn: Geoff Hiten

Rushabh Mehta

Twitter: - @rushabhmehta

LinkedIn: Rushabh Mehta

Contact: http://blogs.solidq.com/RushabhMehta

Rushabh Mehta is a Business Intelligence Mentor with SolidQ and the Managing Director for Solid Quality India Pvt. Ltd. He served as PASS President for 2010/2011 term.

Janis Griffin

Twitter: - DoBoutAnything

LinkedIn: Janis Griffin

Janis Griffin has over 30 years of DBA/database experience including design, development and implementation of many critical database applications. Before coming to Quest Software, Janis primarily worked in the Telecom/Network Industry, working with both real-time network routing databases and OLTP business to business applications. Janis also held positions as a Principal Architect and Senior Manager, mentoring other DBAs on best practices in database performance tuning.

Andrew Kelly

Contact: http://sqlblog.com/blogs/andrew_kelly/default.aspx

Jessica Moss

Twitter: - @jessicammoss

Contact: http://www.jessicammoss.com

Kevin Kline

Contact: http://KevinEKline.com

Ashton Hobbs

Twitter: - @achobbs

Ashton has been working with SQL Server since SQL Server 6.5 and earlier versions of Sybase. Ashton is also the original creator and developer of ApexSQL Edit, a Gold Award winner from SQL Magazine. Ashton is currently consulting and speaking in addition to working on new SQL Server based products and tools.

Sergey Pustovit

SQLSaturday #33 - Charlotte 2010

Sessions

Title: PowerShell Awesomesauce

Title: Top 10 Mistakes on SQL Server

Title: Partitioning in SQL Server 2005/2008

Title: Delivering BI Solutions Rapidly using Vulcan

Title: Know Your IO: Gain Better Performance with Ease

Title: As a DBA, Where do I start?

Title: Build Your First SSIS Package

Title: You Can Improve Your Own SQL Code

Title: SSIS, You, and ETL Architecture

Title: PowerShell for Data Professionals

Title: SQL Server Internals Architecture

Title: Growing Pains - A Cautionary Tale

Title: Troubleshooting Transactional Replication

Title: Clustering for Mere Mortals.

Title: Applied SSIS Design Patterns

Title: SSRS In the Enterprise - Surviving With a Smile!

Title: Compression in SQL 2008

Title: KEYNOTE: SQLSaturday Past, Present and Future

Title: SQL Server Service Broker in the Real World

Title: SQL Server Performance Outside the Box

Title: Maximizing Plan Re-use in SQL 2008

Title: Storage for the DBA

Title: Practical Performance Monitoring in SQL Server

Title: What’s New In SSRS 2008

Title: Tuna Helper for SQL Server DBA’s

Title: Incorporating Reporting Services into SharePoint

Title: Diagnosing Connectivity Issues with SQL Server

Title: Creating Custom Components for SSIS

Title: Adding SSRS Report Bells and Whistles

Title: Management Studio Tips Tricks

Title: Getting started in blogging and technical speaking

Title: Collecting and Analyzing File Wait Statistics

Title: Memory Management in SQL Server Analysis Services

Title: Virtualize This!

Title: Introduction to SQL Server Statistics

Title: SQL Server Support Team QA

Title: Comparison of Replication Technologies

Title: The (Solid) State Of Drive Technology

Title: Is Virtualization is a good choice for SQL Server?

Title: Parameter Sniffing

Title: The Modern Resume: Building Your Brand

Title: Building PowerPivot Models and Reports

Title: Insight Into Your Indexes With DMVs

Title: SQL Azure: Data in the Cloud is a Good Thing

Title: Things Your Mom Never Told You About SSMS

Title: SQL Server Data Compression 101

Title: Harnessing PowerPivot

Title: Tips For The Lazy But Driven DBA

Title: Bad SQL.

Title: De-mystifying Query Plan Analysis

Title: Automate SQL Server Administration with PowerShell

Title: LUNCH!

Title: SQL Server Performance Related DMVs

Title: Gather SQL Server Performance Data with PowerShell

Title: SQL Server 2008/R2 Overview

Speakers

Sponsors