SQLSaturday #57 - Houston 2011

Event Date: 01/29/2011 00:00:00

Event Location:

Bammel Church of Christ
2700 FM 1960 West
Houston, Texas

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: Ask Why My Query So Slow?

Abstract: I will elaborate on the following topics in detail by presenting real-world code examples, why they are inefficient and what is the solution. Configuration:

RAM (Memory)
RAID (IO)
Concurrency – • Dirty Read • Phantom Read • Non-repeatable Read • Blocking Code:
inline function (and expression)
select *
compiled to incorrect plan
recompile plan
union (union all)
missing join
type implicit conversion
unfiltered delete (truncate)
like operator (and execution plan and index)
missing, unused, redundant indexes
query hint
database version compatibility
locking, blocking (isolation level)
not in, in, exists, not exists
schema naming convention

Speaker(s):

Jason Wong

Track and Room: Track 4 - N/A

Title: SSIS: Configuring, Deploying and a Little Tuning

Abstract: Typically, you develop SSIS packages on your laptop, desktop or some client machine and then deploy them to a server. In most cases these environments are completely different. They may have different machine names, folders, connection strings, etc… To assist in easing the pain of deploying your SSIS packages, SSIS includes a range of options that help you when building your data integration solutions. In this session I will attempt to demystify the usage of Configurations file in your SSIS package with a particular focus on Child and Master package solutions. In addition, I will discuss the native deployment methods that are available for SSIS packages. Finally, I will disucss a few methods that can be used to improve the performance.

Speaker(s):

Patrick LeBlanc

Track and Room: Track 5 - N/A

Title: Evaluate your daily checklist using CMS and PBM

Abstract: You will walk away from this session with an understanding of how to use the Policy Based Management and Central Management Server to complete a daily checklist against your whole SQL Server farm. We will cover the basics to evaluate, monitor and apply best practice policies, which are included out of the box with SQL Server 2008. We will also make custom policies to cover additional best practices to evaluate daily checklist items. Finally, we will combine Policy-Based Management and Central Management Server with the Enterprise Policy Management Framework on codeplex to automate the monitoring process and create manager friendly reports to moni

Speaker(s):

John Sterrett

Track and Room: Track 6 - N/A

Title: Putting the Development back in SharePoint Develop

Abstract: The goal of this session is to discuss how to structure and plan a Visual Studio solution for a SharePoint development project. I will discuss some of the coding patterns and practices that we at Envoc have found lead to a high quality product for our clients. We’ll talk about how these patterns and practices allow us to bring a diverse skill set to our project teams due to the minimization of touch points with SharePoint and how automated integration tests help us troubleshoot deployment issues.

Speaker(s):

Jeremy Beckham

Track and Room: Track 4 - N/A

Title: So What Can I Do With PowerShell?

Abstract: Want to automatically store your database schema in a version control system (VCS)? Want to make changes across your database or server with less labor? Want to compress your backups using 7zip and PowerShell. Figure out memory allocation on an active/active cluster? How about download many files in the background? Come learn what is possible with PowerShell.

Speaker(s):

Eric Humphrey

Track and Room: Track 7 - N/A

Title: Transition from DBA to BI Architect

Abstract: Database Normalization and Dimension Modeling are the same but different. Development in today ‘s larger industries require the design and analysis of Online Transaction Processing (OLTP) to take into account Data Warehousing/OLAP (Online Analytical Processing). My transition from Senior DBA to BI Architect at Amedisys has been a process of sanding the rough edges of my passion from fully normalized databases. The Dimensional Modeling started a re-tooling of my mind to look at end result analytics/statistics from smaller and smaller transactions. From previous experience, I know I am not going to get it right the first time. Lessons learned will mold me into a great BI Guy.

Speaker(s):

Thomas LeBlanc

Track and Room: Track 2 - N/A

Title: T-SQL Code Sins: The Worst Things We Do to Code

Abstract: It’s impossible to follow every best practice all the time. “Code sins” are those things we do to our code that are either so horrendous that they can’t be borne, or that have such tremendous consequences that your stored procedures wish they’d never been created. Attendees will hear about the most common code sins that make code difficult to read, support, run and extend, and practical strategies for reversing the trend.

Speaker(s):

Jennifer McCown

Track and Room: Track 1 - N/A

Title: Getting Started with MDX

Abstract: In this session we will concentrate largely upon crafting simple MDX expressions and queries whose purposes, for the most part, are to return a set of data. We will overview the structure of a cube, using as a basis the sample Adventure Works cube that is available to anyone installing SQL Server Analysis Services 2008 R2. We will then outline the components of simple MDX syntax, and get started writing basic expressions and queries. We will expose basic member functions, introduce filters (or “slicers”), and begin exploring core MDX functionality, including calculated members, and named sets.

Speaker(s):

William E Pearson III

Track and Room: Track 2 - N/A

Title: Beginning Powershell for DBAs 1.0

Abstract: The time has come where DBAs can no longer afford to ignore powershell. Not only has it become an integral part of SQL Server, but we’re being asked to do things on a much grander scale than ever before; things that can only be done with powershell. This session will take you from nothing and explain what powershell is all about. I’m going to show you how the more things change the more they stay the same and if you master the basics of powershell in this session, you’ll be able to work with powershell not only in SQL Server, but also at the file system level, in Exchange, IIS, Windows, and anything else. So in this session I’m going to show you the basics you need to get your powershell career started.

Speaker(s):

Sean McCown

Track and Room: Track 7 - N/A

Title: Advanced TSQL Solutions

Abstract: The range of real-world queries that can be performed using set-based TSQL solutions is astounding, but many of these are not well known and if you haven’t been shown the light you might never realize what is possible. Come and join me as we delve into the inner recesses and corners of the TSQL envelope using a wide variety of expressions, clauses and techniques.

Speaker(s):

Kevin Boles

Track and Room: Track 3 - N/A

Title: Documenting Your Integrated Microsoft BI Solution

Abstract: Having implemented BI solutions for years, I have found documentation to be a task too often resisted until late in the project, when it is hastily and incompletely prepared in remaining hours. Because the integrated Microsoft BI solution comprises multiple application layers, it is challenging to generate documentation about the whole solution in a single, unified document. In this presentation I will share approaches I’ve come to use in assembling documentation that “covers all the bases.”

Speaker(s):

William E Pearson III

Track and Room: Track 2 - N/A

Title: Clustering for Mere Mortals.

Abstract: Learn about clustering in current SQL Server and Windows Server releases. Failover Clustering is a fundamental step for any High Availability SQL implementation. Learn how Clustering works, what are the new requirements for Failover Clustering, and how you can make the most of this feature.

Speaker(s):

Geoff Hiten

Track and Room: Track 4 - N/A

Title: Microsoft Entity Framework 4.0 for DBAs

Abstract: While most enterprise applications are object-oriented, the data upon which they depend is not. Binding these platforms together can be costly and time-consuming.

Recently, Microsoft released the Entity Framework and is now recommending development teams implement it in their applications to bridge data and objects.

Come and better understand the Entity Framework, as we …

• Explore Entity Framework 4.0 and show how it works • Demonstrate various ways to build and maintain Entity Data Models and mappings • Walk through examples that interact with the model, including LINQ, Entity SQL and Stored Procedures • Explore its on permissions, connections, transactions, performance, security and concurrency

Speaker(s):

Rob Vettor

Track and Room: Track 4 - N/A

Title: SQL Server 2008 for Developers

Abstract: Are you still on SQL Server 2005 and wonder what you are missing? Did you upgrade to SQL Server 2008 and haven’t had the time to check out the new features? In one hour you will see demos that give an overview of the new features for developers included with SQL Server 2008. This presentation will include Management Studio (SSMS) Enhancements, T-SQL enhancements, Table Value Parameters, Merge and more…

Speaker(s):

John Sterrett

Track and Room: Track 4 - N/A

Title: Zero to cube in 1 hour

Abstract: In this session, we’ll walk through the steps for creating a multidimensional schema (star schema) for a subject area we’re all familiar with, load the tables we create via SSIS, and build an SSAS cube to facilitate analytical analysis. The session is almost completely demo-driven, and will hopefully inspire you to go home and build your first BI solution to facilitate your own analysis.

Speaker(s):

Erin Welker

Track and Room: Track 5 - N/A

Title: Deploying SSIS packages with Powershell

Abstract: Managing SSIS packages in large environments can be a real challenge in large shops. This session will show you how to deploy, transfer, monitor, standardize, and automate your SSIS package environment using Powershell. You’ll learn how to keep many data marts in perfect synch, deploy packages to multiple servers, consolidate packages to a single server, enforce naming and security standards, and much more.

Speaker(s):

Sean McCown

Track and Room: Track 7 - N/A

Title: Execution Plan Basics

Abstract: This will be a Beginner to Intermediate session highlighting the starting point for using the execution plans from SQL Server to assist in query tuning. Briefly, we will look at the history to get an idea of how Microsoft has improved the display through Graphical Plans and Missing Index suggestion. What is the difference between a Table and Clustered Index Scan? What is a Lookup? How do you improve performance of Lookups? What are the different types of Loops? How to get more information from the Plan with the properties window?

Speaker(s):

Thomas LeBlanc

Track and Room: Track 2 - N/A

Title: Beginning Powershell for DBAs 1.5

Abstract: If you were in the 1.0 session you’ll love this one. In this session we’re going to pick up where we left off and really get into some real SQL Server admin tasks. We’ll start with some more advanced basics to enhance your knowledge of powershell, and then apply them directly to SQL Server. By the end of this session you won’t be an expert, but my goal is to make you competent enough to be able to understand blogs and articles about powershell.

Speaker(s):

Sean McCown

Track and Room: Track 7 - N/A

Title: SQL Server DMV Overview

Abstract: An in-depth look at a best-of list of SQL Server Dynamic Management Views to help the DBA with indexing, performance tuning, server administration and more. Lots of samples scripts, realistic usage information, practical examples and puns.

Speaker(s):

William Assaf

Track and Room: Track 3 - N/A

Title: Bad SQL

Abstract: How do you tell good code from bad? Bad SQL code makes the system work harder for the same results. Bad SQL does not scale well with larger data sizes, nor does it scale with increased server activity. Extreme Bad SQL can bring a server to a grinding halt. This presentation shows you how and why certain commonly used SQL constructions are Bad SQL. Bad SQL is not very useful by itself so each example includes its Good SQL counterpart.

Speaker(s):

Geoff Hiten

Track and Room: Track 1 - N/A

Title: Best Practices for SQL Server on VMWare

Abstract: This presentation will explore the fundamentals of running SQL Server in a VMWare environment. You will learn business and technical benefits of virtualization, master new terms and concepts, pick up useful planning tips and tricks and cover best practices for maintaining optimum performance in the VM.

Speaker(s):

Dean Richards

Track and Room: Track 6 - N/A

Title: SQL Server Tools, Tips, and Tricks

Abstract: Learn tips and tricks to make more effective use of SSMS. Use portable applications to get your work done without installing applications on a server. Use free tools to simplify your life.

Speaker(s):

John Cook

Track and Room: Track 1 - N/A

Title: It’s not called Wussyshell

Abstract: Powershell is the enterprise DBAs best friend. It’s the only way to get your environment completely under control with very little effort. You can easily build templates that extend what you’ve already got and you can use them to bring hundreds, or even thousands of servers into compliance with next to no effort. Learn how to manage a very large environment with powershell from a DBA who does it every day. Here you’ll learn how to build a system of templates that you can use to manage all levels of configuration and alerting. You’ll learn how to gather and alert on almost every aspect of your server as well as manage and standardize them.

Speaker(s):

Sean McCown

Track and Room: Track 7 - N/A

Title: Compliance, Auditing and Encryption in Sql Server

Abstract: I have this database which must meet all of these governmental regulations. Just like the government to make life a lot harder but wait, now they say I most also meet International regulations. Can this be true? Why me? Let’s look at what we can do to help us pass audits and comply with the laws around us. We will explore the features in SQL Server 2008 which help us.

Speaker(s):

Thomas Norman

Track and Room: Track 6 - N/A

Title: Power up the Charts – Adding code to SSRS

Abstract: SQL Server Reporting Services provides very robust graphing and charting components. However, there are times when the features are not enough. SSRS exposes the chart and data objects and allows additional manipulation with code. This session starts with the basics, giving hints for coding and debugging, then provides some great examples influenced by production projects.

Speaker(s):

Brian Dudley

Track and Room: Track 1 - N/A

Title: A PowerShell Cookbook for DBAs

Abstract: This introduction to PowerShell is different than most. Instead of starting with a full treatment of the language, you will receive a brief overview then a collection of “recipes,” stand-alone PowerShell scripts that automate various administration tasks for SQL Server 2000, 2005, and 2008/2008R2. You will learn by example, and quickly realize why investing a little time into learning PowerShell will make your job a great deal easier.

Speaker(s):

Trevor Barkhouse

Track and Room: Track 7 - N/A

Title: Visual Studio 2010 Database Projects

Abstract: Managing DDL scripts has always been one of the biggest challenges facing Database Developers. How do you keep your Development, Test, Stage, and Production Environments in sync? Why aren’t databases tightly integrated into source control systems like application code is? Visual Studio 2010 Database projects solve all these problems and more. In this session, we will learn how to use Visual Studio to treat database objects as the first-class citizens they have always been.

Speaker(s):

Randy Knight

Track and Room: Track 4 - N/A

Title: Data Mining in Action: A case study

Abstract: This session will focus on using real world data ( no Adventureworks) taken through the life cycle of a data mining application. Topics will include the details of data mining methodology fine tuyning mining models and validating discoveries

Speaker(s):

Drew Minkin

Track and Room: Track 5 - N/A

Title: Zen Coding

Abstract: Learn the philosophy, mindset, and attitude of a professional, principled, disciplined software developer.

Speaker(s):

Brian Rigsby

Track and Room: Track 2 - N/A

Title: SQL Azure and Me!

Abstract: » How can “I/Me/My” get started with Microsoft Azure offerings.
» Starts with a lap around the various offering of Microsoft Azure – then focuses on SQL Azure, in particular.
» This is meant to be a beginners overview – with links to more info.

Speaker(s):

Anthony {Tex} Moreign

Track and Room: Track 3 - N/A

Title: Tableau: Delivering Self-Serve BI

Abstract: Description: rapid-fire visual analysis. ad hoc query capability. easy interactive dashboard building. No, this insn’t going to be an hour of buzzword bingo. This time we will actually deliver on the promise of self service BI. Using SQL in conjunction with a visual analysis tool like Tableau we can help our users find the questions they didn’t know they wanted to answer. This session will be demo heavy and will highlight best practices in data visualization and dashboard design.

Speaker(s):

Tim Costello

Track and Room: Track 5 - N/A

Title: Keeping up with the JOINes

Abstract: Very few queries can be written without an Inner Join, but Full Outer Joins and few and far between. This session will cover the less common join scenarios through slides and code samples. Learn to use the data model and requirements to recognize the join type. Come away with the confidence to give examples and incorporate the new material in your own queries.

Speaker(s):

Brian Dudley

Track and Room: Track 1 - N/A

Title: Mirroring: The Bear Necessities

Abstract: Mirroring can be an integral part of your high availability and disaster recovery planning. We’ll cover what mirroring is, how it can fit into an HA/DR plan, the rules surrounding its use, configuration via the GUI and T-SQL, as well as how to monitor mirroring. This presentation is designed to not only give you an overview of mirroring, but to also walk you through a basic implementation. At the end you will have learned what mirroring is, how it can fit into your environment, what business requirements it solves, and how to configure it.

Speaker(s):

Ryan Adams

Track and Room: Track 2 - N/A

Title: Women in Tech:Why are we still talking about this?

Abstract: If you find yourself rolling your eyes at another Women in Technology talk, then this panel session is DEFINITELY for you. WIT talks aren’t exclusively for women, aren’t time set aside for complaining about injustices. WIT talks ARE about finding new ways to make the exciting and lucrative IT field more accessible for our friends, and our children.

Speaker(s):

Jennifer McCown

Track and Room: Track 3 - N/A

Title: What’s new in Reporting Services R2

Abstract: In this session Patrick shows you the new features in Reporting Services R2. You will learn how to use the Map control, Sparkline, Indicator, and Data Bars. See the new report builder 3.0. Learn about shared Data sets and report parts.

Speaker(s):

Patrick LeBlanc

Track and Room: Track 5 - N/A

Title: Parallel Query Execution Deep Dive

Abstract: What exactly does it mean to parallelize a query? Why would the optimizer do this and what are the benefits and what are the drawbacks?? Is it always faster? Can it cause problems? Are there reasons we might NOT want parallelization? These are some of the topics we will cover as we dig into this facet of the SQL Server relational engine.

Speaker(s):

Kevin Boles

Track and Room: Track 3 - N/A

Title: Manage Your Shop with CMS and Policy Based Managem

Abstract: In this presentation we talk about Central Management Server and how it can help you manage a disperse environment. We will also cover what Policy Based Management is and how you can leverage its power to better manage your environment. With PBM we’ll see what it can and cannot do to help you enforce standards in your enterprise. We will cover and demonstrate PBM for the beginner from creating and evaluating policies to receiving alerts on policy violations.

Speaker(s):

Ryan Adams

Track and Room: Track 6 - N/A

Title: Deadlock Detection, Troubleshooting, Prevention

Abstract: As an enterprise application grows and load increases, some concurrency issues are bound to surface. Deadlocks are one of the more aggravating of this class of problems. Fortunately, each release of SQL Server includes better tools for troubleshooting deadlocks. Trevor will provide a strong foundation on deadlocks and then demonstrate approaches for handling them in SQL Server 2000, 2005, and 2008/2008R2.

Speaker(s):

Trevor Barkhouse

Track and Room: Track 1 - N/A

Title: DBA Repository Update 2010 Using SSIS and SSRS

Abstract: At its heart, the DBA Repository solution employs SSIS and SSRS and in late 2009 was updated for performance and resiliency. This session will cover the original solution, published in SQL Server Magazine, plus the latest enhancements which will delve into some interesting uses of package variables and MERGE in SSIS along with some new reports.

Speaker(s):

Rodney Landrum

Track and Room: Track 6 - N/A

Title: Stored procedure tracing using the xml datatype

Abstract: When running a stored procedure it is difficult to record what is happening. In this session we will develop logger code in T-SQL to add to your stored procedures. We will use the xml datatype to record parameter values, variable values and debug statements. We will look at the “For xml” statement as well as the xml datatype methods, especially the modify method. Finally we will look at how to read the logs when finished.

Speaker(s):

Russel Loski

Track and Room: Track 3 - N/A

Title: Dynamic SSIS with Expressions and Configurations

Abstract: Never hard-code a connection string or file path again! In this session, we’ll look at several ways to introduce dynamic logic into your packages by way of the SSIS expression language, package configurations, and variables. Learn how to reuse tasks, components, and containers by replacing static settings with dynamic and flexible properties.

Speaker(s):

Tim Mitchell

Track and Room: Track 5 - N/A

Title: Understanding Storage Systems and SQL Server

Abstract: The most important part of your SQL Server is also the slowest, Storage. This talk will take you through the fundamentals of your server’s Disk I/O System. From how hard drives work, through RAID configurations, and how to configure the file system. This session should give you a solid foundation over storage systems and help you understand why they are slow and how to overcome some of their limitations.

Speaker(s):

Wesley Brown

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

Drew Minkin

Contact: http://dataminkin.blogspot.com

Drew Minkin has been a speaker at the MS Business Intelligence Community, North Texas SQL Server User’s Group and SQLSaturday events across the country , for four years, He worked at Microsoft in SQL Support and in Premier Field Engineering for over six years. After leaving Microsoft, Drew has designed and supported cubes for dozens of Fortune 1000 companies. he has designed data mining models on pricing optimization, fraud detection, customer retention and marketing campaigns

Randy Knight

Twitter: - randy_knight

LinkedIn: Randy Knight

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

Randy Knight is a data professional who has worked with Microsoft technology for over 25 years, focusing on SQL Server since 1997. He has worked in a variety of settings, including 6 years as a database architect for match.com. In 2010, he founded SQL Server Solutions Group LLC, a boutique SQL Server consultancy. A Microsoft Certified Master (MCM) in SQL Server, he speaks often at events all over the country including the PASS Summit, SQLIntersections, and numerous SQLSaturday and User Groups.

Eric Humphrey

Twitter: - @lotsahelp

Contact: http://www.erichumphrey.com

Eric Humphrey is a DBA at GameStop in the Dallas area. He earned his B.S. in Computer Science from Louisiana State University – Shreveport in 2004. He has been working in the tech industry since 2003 with companies big and small. His focus is on database development with SQL Server. Eric has a passion for improving his craft while contributing to the development community.

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.

John Cook

Twitter: - johnpaulcook

LinkedIn: John Cook

Contact: https://www.red-gate.com/simple-talk/author/johnpaulcook-2/

John Paul Cook is a psychiatric nurse practitioner and instructor of psychiatric nursing. He is former Data Platform Solutions Architect for Microsoft and before that a 9 time Microsoft MVP. John understands both the clinical aspects of healthcare and the technical aspects. He provides a unique perspective in being able to explain clinical concerns and issues to technical people. John is passionate about improving mental health in the community, including in the technical community.

Rob Vettor

Rob Vettor is a C# MVP, INETA Regional Speaker and senior .NET Technologist for OZ Software, a leading provider of Education Healthcare software. Rob has built systems for a number of corporations, including Avanade, Raytheon, American Express and Jack Henry and Associates. Rob lives in Dallas, TX, with his wife, twin sons and three dogs, and is the founder of Hands-On-Coding (http://www.hands-on-coding.net/). You can contact Rob at robvettor@hotmail.com

John Sterrett

Contact: http://johnsterrett.com

John Sterrett is a database administrator at a international law-firm, and is responsible for over 100 instances of SQL Server. John has been active within the SQL Server community, including hosting the first SQLSaturday in West Virginia. John also presented a lightning talk and chalk-talk at the SQL Server 2010 Member Summit, presented sessions at SQLSaturday’s, and the Pittsburgh SQL Server User Group. John is a syndicated blogger at SQLServerPedia and contributes tips at MSSQLTIPS.

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.

Ryan Adams

Twitter: - @ryanjadams

LinkedIn: Ryan Adams

Contact: http://www.ryanjadams.com

Ryan Adams is a Senior Premier Field Engineer for Microsoft. He works directly with customers to help them realize their business potential and accelerate their digital transformation on premises and in the cloud.

Previously, Ryan was a Microsoft Data Platform MVP and spent 19 years working for a fortune 100 company. His passion is the SQL Server Engine, High Availability, and Disaster Recovery. He also served on the Board of Directors for the North Texas SQL Server User Group, was President of the PASS Performance Virtual Chapter, was a PASS Regional Mentor, and served as a Director for the PASS organization.

William Assaf

Twitter: - william_a_dba

LinkedIn: William Assaf

Contact: http://www.sqltact.com

William Assaf, Data Platform MVP, is a principal consultant in Baton Rouge, LA. Initially a .NET developer, and later into database administration and architecture, William currently works with clients on SQL Server and Azure SQL platform optimization, management, disaster recovery and high availability, and leads a crack multi-city team of consulting SQL DBA’s. William has written for Microsoft SQL certification exams since 2011 and was the lead author of the 2017 and 2019 editions of “SQL Server Administration Inside Out” by Microsoft Press. William is a member of the Baton Rouge User Groups board, a regional mentor for PASS, and past lead of the annual SQLSaturday Baton Rouge Planning Committee, having run one of the largest SQLSaturdays.

Brian Dudley

Brian is a seasoned consultant with experience in several industries. He has worked with SQL Server for more than 25 years, back to the Sybase days. as well as experience with other database platforms. He is also brings experience from the code development and design areas. He is equally comfortable leading a team or rolling up his sleeves and slinging code.

Sean McCown

Twitter: - @KenpoDBA

Contact: http://www.midnightdba.com/dbarant

Sean McCown is a Certified Master with 23 years of experience in databases. He is also founder and co-owner of the MidnightDBA.com website, where he records free SQL Server training videos. He also writes the popular Minion Maintenance suite, the most configurable maintenance solution on the planet.

Patrick LeBlanc

Contact: http://www.patrickdleblanc.com

Rodney Landrum

Twitter: - @SQLBeat

Contact: https://www.simple-talk.com/blogs/author/2133-rodney-landrum/

Rodney Landrum has been architecting solutions for SQL Server for over 12 years. He has worked with and written about many SQL Server technologies, including DTS, Integration Services, Analysis Services, and Reporting Services. He has co-authored 4 books on Reporting Services. He is been a regular contributor to SQL Server magazine, sqlservercentral.com and Simple-talk.com. Rodney is also SQL Server MVP

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.

John Sterrett

Contact: http://johnsterrett.com

Ryan Adams

Twitter: - @ryanjadams

LinkedIn: Ryan Adams

Contact: http://www.ryanjadams.com

Anthony {Tex} Moreign

Twitter: - https://twitter.com/AnthonyTexM

LinkedIn: Anthony {Tex} Moreign

Contact: http://www.hccug.org

{Technologist | Speaker | Writer | Founder} … 25 years counting … – Founder Chief Architect, Hybrid Decisions® Corp (www.HybridDecisions.com | 2005) – Founder President, Houston Cloud Computing User Group (www.HCCUG.org | 2008) – for more info see http://linkedin.com/in/AnthonyTexM «±»

Russel Loski

Twitter: - sqlmovers

LinkedIn: Russel Loski

Contact: http://www.sqlmovers.com

Russ Loski is a SQL Server BI Developer based in Dallas-Fort Worth. He current works as a Data Analytics Engineer for Navisite, a remote managed IT services company. Twenty years ago, he began working with SQL Server 6.5. He has since continued to develop applications connected to all of the versions of SQL Server. He has worked with clients in industries from insurance to healthcare, from movie theaters to American football. Russ is a regular speaker at SQLSaturday events, as well as the SQL Server Users Groups in the North Texas region. Russ likes working with data in various shapes.

Geoff Hiten

Twitter: - SQLCraftsman

LinkedIn: Geoff Hiten

Dean Richards

LinkedIn: Dean Richards

Dean Richards is a Senior DBA for DBMS Insights and has helped hundreds of companies solve database and virtualization performance issues. Dean has over 20 years of experience in both development and database administration and has focused his entire career on performance tuning of Oracle and SQL Server environments. Most recently Dean has focused on the trend to virtualize and move databases to the cloud.

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.

Tim Mitchell

Twitter: - @Tim_Mitchell

LinkedIn: Tim Mitchell

Contact: http://www.TimMitchell.net

Tim Mitchell is a business intelligence architect, author, and trainer. He has worked with SQL Server for over a decade, specializing in data warehousing, ETL/SSIS, and reporting. He holds a Bachelor’s Degree in Computer Science from Texas AM at Commerce, and is recognized as a Microsoft Data Platform MVP. Tim is a business intelligence consultant and principal at Tyleris Data Solutions.

Tim is an active community speaker and volunteer, having spoken at over 100 events including the PASS Summit, SQLBits, Dev Connections, SQL Intersection, and scores of SQLSaturdays. He blogs at TimMitchell.net, and tweets at @Tim_Mitchell.

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.

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

Sean McCown

Twitter: - @KenpoDBA

Contact: http://www.midnightdba.com/dbarant

Thomas LeBlanc

Twitter: - TheSmilingDBA

LinkedIn: Thomas LeBlanc

Contact: http://Thomas-LeBlanc.com

Thomas LeBlanc (Microsoft Data Platform MVP) is a Data Warehouse Architect in Baton Rouge, and uses his 30+ years in IT to develop OLTP systems with normalized databases for high-performing T-SQL and dimensional data marts. Development is done in SSIS, SSAS, SSRS, Power BI, and Excel. As a PASS volunteer, he is past chair of Excel BI and Data Arch VCs and is active in the Baton Rouge Analytics and SQL Server User groups, as well as SQLSaturday in Baton Rouge. You can find his blog at TheSmilingDBA.BlogSpot.com and website at Thomas-LeBlanc.com

Trevor Barkhouse

Trevor Barkhouse is Support Escalation Engineer for Microsoft Corporation, on the team that supports SQL Server. His passions are automation, performance tuning, and troubleshooting. Trevor has spoken at many user group meetings, seven SQLSaturday events, the 2010 Houston TechFest, CodeStock 2011, and two PASS Community Summits (North American).

Kevin Boles

Twitter: - @TheSQLGuru

LinkedIn: Kevin Boles

Tim Costello

Twitter: - timcost

LinkedIn: Tim Costello

Contact: http://www.timcost.com

Tim Costello is an MCITP, MCTS specializing in etl and data analytics for Interworks Inc. Tim is an international speaker that is always looking for opportunities to share his passion for SQL Server, Tableau and data visualization. Tim is active in the SQL community and leads a data visualization focused user group in the Dallas area.

Erin Welker

Twitter: - sqlbigirl

Erin Welker, a consulting professional whose passion is SQL Server, has worked with the product since version 1.11. She has served as the data warehouse architect on projects for several globally recognized companies. She has also presented on SQL Server topics at several conferences and is the author of various whitepapers, articles, and book chapters on SQL Server and data warehousing.

Sean McCown

Twitter: - @KenpoDBA

Contact: http://www.midnightdba.com/dbarant

Trevor Barkhouse

Jeremy Beckham

Twitter: - jbeckh2

LinkedIn: Jeremy Beckham

I am an IT leader that started as in operations, moved into development, then architecture, and finally management. I received my Executive MBA from Southeastern Louisiana University to help me make the jump from individual contributor into management. I’ve led multiple teams of developers utilizing technologies ranging from C# to BizTalk to Informatica. Today, I lead the teams at BCBSLA that are responsible for Reporting, EDI, and Integrations.

William E Pearson III

Twitter: - @Bill_Pearson

LinkedIn: William E Pearson III

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

Brian Rigsby

Contact: http://zendeveloper.blogspot.com

Brian’s formal education is in music, but he is a fourteen year software development veteran. His unorthodox presentation style is both inspirational and entertaining. Brian is currently the Technical Development Manager at Envoc.

Brian Dudley

Jason Wong

Contact: http://usa.redirectme.net

http://usa.redirectme.net

Sean McCown

Twitter: - @KenpoDBA

Contact: http://www.midnightdba.com/dbarant

Thomas LeBlanc

Twitter: - TheSmilingDBA

LinkedIn: Thomas LeBlanc

Contact: http://Thomas-LeBlanc.com

Thomas Norman

Twitter: - ArmorDba

LinkedIn: Thomas Norman

Contact: https://armordba.com/

Tom Norman is a Database Architect at KPA with a strong fervor to protect data. He works daily to review and improve data protection methodologies while reviewing governing laws affecting finance, healthcare, and personal data. His areas of expertise include encryption, auditing, data identification, and database object deployment. He is the current leader of the PASS Virtualization Group and Vice President of the TRIPASS user group. You can read his blog at https://armordba.com/ and reach him on twitter at @armordba. Tom speaks at a number of SQLSaturday events and SQL Server user groups.

Jennifer McCown

Twitter: - http://www.Twitter.com/MidnightDBA

LinkedIn: Jennifer McCown

Contact: http://www.MidnightDBA.com/Jen

SQLSaturday #57 - Houston 2011

Sessions

Title: Ask Why My Query So Slow?

Title: SSIS: Configuring, Deploying and a Little Tuning

Title: Evaluate your daily checklist using CMS and PBM

Title: Putting the Development back in SharePoint Develop

Title: So What Can I Do With PowerShell?

Title: Transition from DBA to BI Architect

Title: T-SQL Code Sins: The Worst Things We Do to Code

Title: Getting Started with MDX

Title: Beginning Powershell for DBAs 1.0

Title: Advanced TSQL Solutions

Title: Documenting Your Integrated Microsoft BI Solution

Title: Clustering for Mere Mortals.

Title: Microsoft Entity Framework 4.0 for DBAs

Title: SQL Server 2008 for Developers

Title: Zero to cube in 1 hour

Title: Deploying SSIS packages with Powershell

Title: Execution Plan Basics

Title: Beginning Powershell for DBAs 1.5

Title: SQL Server DMV Overview

Title: Bad SQL

Title: Best Practices for SQL Server on VMWare

Title: SQL Server Tools, Tips, and Tricks

Title: It’s not called Wussyshell

Title: Compliance, Auditing and Encryption in Sql Server

Title: Power up the Charts – Adding code to SSRS

Title: A PowerShell Cookbook for DBAs

Title: Visual Studio 2010 Database Projects

Title: Data Mining in Action: A case study

Title: Zen Coding

Title: SQL Azure and Me!

Title: Tableau: Delivering Self-Serve BI

Title: Keeping up with the JOINes

Title: Mirroring: The Bear Necessities

Title: Women in Tech:Why are we still talking about this?

Title: What’s new in Reporting Services R2

Title: Parallel Query Execution Deep Dive

Title: Manage Your Shop with CMS and Policy Based Managem

Title: Deadlock Detection, Troubleshooting, Prevention

Title: DBA Repository Update 2010 Using SSIS and SSRS

Title: Stored procedure tracing using the xml datatype

Title: Dynamic SSIS with Expressions and Configurations

Title: Understanding Storage Systems and SQL Server

Speakers

Sponsors