SQLSaturday #97 - Austin 2011
Event Date: 10/01/2011 00:00:00
Event Location:
- Thompson Conference Center
- 2405 East Campus Drive
- Austin, Texas
This event has completed. All data shown below is from the historical XML public data available.
If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).
Sessions
This is a list of sessions from the event, based on the schedule in the XML files.
Title: T-SQL Brush-up:The Best Things You Forgot You Knew
Abstract: You’re a good SQL professional – you attend conferences and webinars, you read articles and books, and you know your way around SQL Server. But sometimes – just SOMEtimes – some piece of T-SQL slips by you unnoticed, or falls out of memory. Most of us are working with at least two or three out of the last five versions of SQL Server, so who can blame us for missing a feature or two? Come and revisit old favorites, and brush up on new T-SQL features and enhancements. In this session you will see SELECT turned inside-out. You’ll get really, really excited about OVER and PARTITION BY. You’ll learn that Common Table Expressions are, in fact, very cool, and that FOR XML isn’t as scary as it looks. This session is chock full of code examples.
Speaker(s):
- Jennifer McCown
Track and Room: Bonus - N/A
Title: SQL Server Performance Analysis
Abstract: Performance tuning is something that every DBA and developer will have to do at some point. You’ll find all kinds of recipes, cookbook, and processes to do performance tuning. The hardest part isn’t tuning something, it is figuring out what to tune and what is worth tuning in the first place. Many people don’t have the time to do performance tuning, because so much time is spent figuring out what to tune that no time is left to actually tune the code. This session will take you through all of the tools necessary to gather the data necessary to do the analysis as well as how to quickly cut through all of the background noise to zero in on the most important things that need to be tuned.
Speaker(s):
- Mike Hotek
Track and Room: Bonus - N/A
Title: Mirroring: The Bare Necessities
Abstract: Remember Baloo the bear from the Jungle Book? Well we are going to get down to the “bear” necessities of mirroring and more. 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: DBA 2 - N/A
Title: Virtualization and Consolidation best practices
Abstract: In this session you will learn from one of the largest deployments of Microsoft SQL Server with over 5000 servers. Join the experts from Dell Services to learn how, when, and what to do when faced with the question “what is the best virtualization solution to save money on database infrastructure?” Virtualization is knocking on every ones door, including DBAs. Recent economic challenges have forced us all to do more with less. You will learn how we managed our internal consolidation efforts. We will cover the best practices for configuring the database engine, Analysis Services and Reporting Services. We also touch on the best practices on virtualization, consolidation and achieving up to 100 to 1 reduction in SQL Servers.
Speaker(s):
- Reinaldo Kibel
Track and Room: Bonus - N/A
Title: Analysis Services Performance Monitoring Deepdive
Abstract: Analysis Services performance troubleshooting can appear more art than science - there are no query plans to view for optimization, server configuration documentation can be sparse and getting consistent results with specific query tests does not always yield the results you desire. How can you know you can meet the SLAs for the user experience? What is the performance elbow on the number of concurrent users? Did my new aggregation or partition actually make a difference?
This session will go into details on how to configure a performance monitoring environment, how to gather data and then interpret results into actionable steps, allowing attendees to answer these questions. Assumes some experience with Analysis Services and MDX
Speaker(s):
- Sid Atkinson
Track and Room: BI - N/A
Title: The Backup Tune-up
Abstract: Have you ever gotten tired of your 1TB database taking 4+ hrs to backup? Are you sick of having your users breathe down your neck for 2hrs because it’s taking too long to restore a DB? Well now you don’t have to worry about that anymore. I’m going to show you some little known tricks, methods, and trace flags you can use to tune your backups just like you would a query. Backups actually have kind of an execution plan that you can access if you know how, and knowing how to get the individual portions of your backup process down will allow you to knock 80% and even more off of your backup and restore time. I’m not holding anything back in this session. This is a method I’ve used for 15yrs to tune my backups.
Speaker(s):
- Sean McCown
Track and Room: DBA 2 - N/A
Title: Nested Sets model for Trees in SQL
Abstract: Start with the basic method for modeling a hierarchy with sets instead of mimicking pointer chains. Then we will get to some fancier tricks with the model. Finally, spend some time on data integrity.
Speaker(s):
- Joe Celko
Track and Room: Developer - N/A
Title: Data File Sizes – How much is enough, if you don’t
Abstract: We often run a fine line between how much space we need, and how much space we have for our databases. Having too much drive space can be a waste of resources; however, running out of space is an obvious issue. Let’s find a way to straddle the line and determine just how much space we really need, give ourselves a bit more than that, and make it a regular process to baseline, then continue to monitor, make adjustments along the way if needed, and ultimately plan for just enough space to get us through the year on budget. We’ll talk about a stand-alone tool that I used to determine space use for baseline, continued monitoring of the space used, and ensuring we have enough but not too much space.
Speaker(s):
- TJay Belt
Track and Room: DBA 2 - N/A
Title: SSIS Done Right With Package Configurations
Abstract: Everyone starts creating SSIS Packages the same way. We hard code connection strings, file locations, etc. Package Configurations are a powerful way to control your packages at run time. This allows you to seamlessly move packages between servers, dynamically assign data sources and destinations, cycle through data sources, and create reusable code.
In this presentation, I’ll demonstrate an easy to understand three step process which you can use with all of your packages to increase your productivity in SSIS.
Speaker(s):
- David Stein
Track and Room: Bonus - N/A
Title: Data Warehouse Mistakes You Can’t Afford to Make
Abstract: Many data professionals understand the basics of Data Warehouse design, including Dimension and Fact Tables, slowly changing Dimensions, and the use of meaningless surrogate keys. However, it isn’t until you’ve created a dimensional model and put it into production, that you realize just how much of an impact seemingly trivial mistakes can make. They can hobble performance, allow inaccuracy, and perhaps worst of all, inhibit adoption and usage of the new system.
Learn how to avoid many common mistakes, from someone who’s made them and then found ways to correct them.
Speaker(s):
- David Stein
Track and Room: BI - N/A
Title: An Introduction to Profiler and SQL Trace
Abstract: Profiler (and its underlying subsystem, SQL Trace) is a tool for recording a SQL Server instance’s activity. This diagnostic and performance data is valuable for troubleshooting and characterizing a system’s workload. Like any powerful tool, misuse can be quite harmful, so great care must be exercised. This session will teach you how to efficiently configure, run, and analyze the data from traces, while minimizing the overhead of the data collection and avoiding common pitfalls.
Speaker(s):
- Trevor Barkhouse
Track and Room: DBA 1 - N/A
Title: It is TEMPDB, Why Should You Care?
Abstract: TEMPDB is just for temporary data right? It is installed by default and gets recreated it time SQL is restarted so what does it matter right? WRONG. This session will give you great insight into what uses TEMPDB, why TEMPDB is important, what are some best practices for configuring TEMPDB, and how to determine if you have contention. If you have systems where TEMPDB hasn’t been touched since the install, you need to attend this session.
Speaker(s):
- Tim Radney
Track and Room: DBA 1 - N/A
Title: Data Orchestration with System Center + SQL
Abstract: This session will explore various options for data and process management leveraging System Center Orchestrator, System Center Service Manager, PowerShell, SQL 2008 R2, SSRS, as well as other Microsoft offerings. One of the demonstrations will highlight an existing production infrastructure where managed data is remotely collected from various sources (Hyper-V, Windows Host OS, Storage, Network, and Security, even Guest Virtual Machine SQL databases), stored in SQL 2008 R2, reported via SSRS, and presented via an intranet SharePoint portal.
Speaker(s):
- Charles Joy
Track and Room: DBA 1 - N/A
Title: New Features in Denali: Apollo Columnar Data Store
Abstract: One of the most talked about features slated for the next release of SQL Server, a whole new way of storing data, speeding up some queries ten fold. Come listen to Conor Cunningham talk about this new feature.
Speaker(s):
- Conor Cunningham
Track and Room: BI - N/A
Title: Pro Tips: Tuning the data flow in ssis
Abstract: Synchronous and asynchronous components, memory buffers, data type choices, Oh My! Tuning the data flow is all about choices. In this session we’ll walk through some of the choices that can give you the biggest performance boosts in your ssis data flow. Together we’ll work through the differences between synchronous and asynchronous components. We’ll highlight components that should be avoided and explore alternates that can help us create the fastest data flow possible.
Speaker(s):
- Tim Costello
Track and Room: BI - N/A
Title: Managing SQL Server in the Enterprise with TLAs
Abstract: Technologists are overwhelmed with TLAs (Three-Letter Acronyms) in their everyday life. This session will introduce several SQL Server 2008 and 2008 R2 features designed to make a DBA’s life easier. If you aren’t using CMS, PBM, EPM, MDW, UCP or DAC – come learn what they are and the potential benefits for managing your environment.
Speaker(s):
- Nancy Hidy Wilson
Track and Room: DBA 2 - N/A
Title: Denali AlwaysOn - Finally, A usable ‘mirror’!
Abstract: In the past, High Availability and Disaster Recovery (HADR) had many limitations. Clustering and Mirroring are great, but the mirror/secondary database is not very usable since it is not online. Finally, AlwaysOn solves this limitation by merging both multi-node Clustering and mirroring. Denali AlwaysOn also allows the secondary database to remain ONLINE, so we can use it for reporting purposes without resorting to a Snapshot! Come see this lively session with extensive demos of setting up, configuring and testing AlwaysOn. We’ll also test automatic ConnectionString fail-over using a real web app to see how well that feature works.
Speaker(s):
- Jim Murphy
Track and Room: DBA 1 - N/A
Title: Nuts and Bolts of Table Compression
Abstract: Objective of session is to show with examples when and what and how and if to implement table compression. Session will review table compression as implemented for SQL Server and then dive into many examples including benchmarking. Come to the session to see the results – they were surprising to me!
Speaker(s):
- Mike Byrd
Track and Room: Developer - N/A
Title: SSRS data driven subscription using SSIS
Abstract: SQL Server Reporting Services provides a powerful tool to render report based on information in a database table. But in order to use this feature, you are required to purchase an Enterprise license of SQL Server. In this session, we will create an SSIS package that renders reports to the file system based on values stored in the database.
Speaker(s):
- Russel Loski
Track and Room: BI - N/A
Title: Visual Studio 2010 SQL 2008 Database Projects
Abstract: How many change scripts does it take to upgrade your database? How do you keep those scripts in-synch from version to version?
I will be covering the new approach Microsoft has provided through the Visual Studio Database Project and how this can simplify development and deployment for the multiple environments in an enterprise. I’ll show you how to set up a database project and create a TFS build that automates the deployment to any target environment.
Speaker(s):
- Justin Mason
Track and Room: DBA 1 - N/A
Title: Expand your TSQL: Intersect, Except, and Apply
Abstract: We all know and love inner join, outer join, in and exists. But, there are a several other TSQL operators that do not get as much press as the rest. Expand your TSQL tool belt with Intersect, Except, Cross Apply, and Outer Apply. You’ll get practical examples that you can use on Monday morning!
Speaker(s):
- Roudy Rodarte
Track and Room: Developer - N/A
Title: SQL Server Amnesia
Abstract: Losing your memory is never fun. Well, I can’t help you with that, but I can help show you how SQL Server is using its memory and some things to look at with regards to performance problems.
When I started as a DBA I didn’t know much about SQL Server internals. I inheirited quite a few servers and they were experiencing performance problems. Over time I learned more about the internals and how to troubleshoot systems. I’ll share some stories with you and talk about some of the methods I use to look at how SQL Server is using its memory. Then we’ll look at some examples and demo code.
Speaker(s):
- Steven Ormrod
Track and Room: DBA 2 - N/A
Title: Introduction to Common Table Expressions
Abstract: Introduced in SQL 2005, Common Table Expressions, or CTEs, are temporary result sets that offer increased flexibility in your T-SQL coding and provide a simple syntax for recusive queries. In this session for intermediate T-SQL coders, learn how to use CTEs to improve the readability and maintainability of your most complex queries.
Speaker(s):
- Vicky Harp
Track and Room: Developer - N/A
Title: Adventures in Project Management
Abstract: Join Jonathan Gardner in a discussion about the project management process and how understanding the process can help increase the chances of delivering a top quality work product. Learn the questions to ask to prevent scope creep and manage stakeholders from a DBA and highly experience project manager.
Speaker(s):
- Jonathan Gardner
Track and Room: Bonus - N/A
Title: Central Management Server - Fundamentals
Abstract: We’ll cover the basics of setting up your CMS, including: “What you need to consider when planning your CMS”, “How to find SQL Servers in your environment”, “How to get the servers you find into CMS” and “How CMS can help you proactively manage your environment”.
Speaker(s):
- AJ Mendo
Track and Room: DBA 1 - N/A
Title: Architecting no downtime databases.
Abstract: Do you have a highly visible online application where you cannot sustain a database outage? How do you handle the planned outages needed for basic maintenance such as patching? In this session I will share some methods utilizing SQL Server features to provide 100% up-time. We will also discuss issues with using clusters as part of an uptime strategy. Finally we will spend some time discussing how Denali can help improve this up-time by utilizing “Always On” features.
Speaker(s):
- Russell Johnson
Track and Room: Developer - N/A
Title: Advanced Table Constraints
Abstract: The goal of Good SQL is to avoid procedural. The more taht can be put into declarative code, the better the optimizer can do its job. This will cover the use of CASE expressions, overlapping UNIQUE constraints, state transition constraints, and Kusnetsov’s temporal constraints.
Speaker(s):
- Joe Celko
Track and Room: Bonus - N/A
Title: SQL Server Memory Management
Abstract: Are you suffering from memory issues? Is your SQL Server configured for proper memory management? Attend this session and learn how to best determine if you are suffering from memory pressure, how to resolve issues that result from memory pressure, and how to properly configure your SQL Server to minimize the chance of having memory issues.
Speaker(s):
- Thomas LaRock
Track and Room: DBA 2 - N/A
Title: Code Sins
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: Developer - 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: BI - N/A
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
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.
TJay Belt
Twitter: - @tjaybelt
LinkedIn: TJay Belt
Contact: http://tjaybelt.blogspot.com
TJay Belt is an outdoorsman at heart who enjoys riding dirtbikes, waterskiing, boating, playing racquetball and spending time with his family. When he can’t be out playing, TJay loves to tinker with databases. TJay has been an IT professional for over a decade and a half. Currently serving as a Senior Database Administrator with Imagine Learning. TJay has progressed through several roles in his database career including developer, data guy, database developer, database analyst and DBA.
Russell Johnson
Contact: http://www.johnsonville.net/russ
Russell Johnson is Development DBA for a Fortune 500 company in Austin, Texas. He assists in the architecture and performance tuning of large scale online e-commerce systems. Russell has been working with SQL Server and Oracle RDBMS systems for over 7 years. He holds database related certifications: MCDBA, MCTS SQL Server 2008, MCITP SQL Server 2008. In his free time he enjoys time with his family, woodworking and geocaching.
Joe Celko
Joe Celko served 10 years on ANSI/ISO SQL Standards Committee and contributed to the SQL-89 and SQL-92 Standards.
He has written over 1200 columns in the computer trade and academic press, mostly dealing with data and databases.
He is author of eight books on SQL for Morgan-Kaufmann: SQL FOR SMARTIES (1995, 1999, 2005, 2010), SQL PUZZLES ANSWERS (1997, 2006), DATA DATABASES (1999) and TREES HIERARCHIES IN SQL (2004), SQL PROGRAMMING STYLE (2005) and ANALYTICS OLAP IN SQL (2005) and THINKING IN SETS (2008).
Mr. Celko’s past columns include: Columns for Simple-Talk (Redgate Software); “CELKO” in INTELLIGENT ENTERPRISE magazine (CMP); BMC’s DBAzine.com e-magazine; “SQL Explorer” in DBMS (Miller-Freeman); “Celko on SQL” in DATABASE PROGRAMMING DESIGN (Miller-Freeman); “WATCOM SQL Corner” in POWERBUILDER DEVELOPERS’ JOURNAL (SysCon); “SQL Puzzle” in BOXES ARROWS (Frank Sweet Publishing); “DBMS/Report” in SYSTEMS INTEGRATION (Cahner-Ziff); “Data Desk” in TECH SPECIALIST (RD); “Data Points” in PC TECHNIQUES (Coriolis Group); “Celko on Software” in COMPUTING (VNC Publications, UK), “SELECT * FROM Austin” (Array Publications, The Netherlands), and he was editor for the “Puzzles Problems” section of ABACUS (Springer-Verlag) and he ran the CASEFORUM section 18, “Celko on SQL”, on CompuServe.
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.
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.
Mike Hotek
Contact: http://www.ChampionValleyPress.com
Michael is the Senior BI Architect at CBRE in Dallas, TX. He has been building SQL Server systems and database management best practices for over 20 years having worked with thousands of companies and on the largest, most complicated platforms in the world. Michael has delivered hundreds of sessions and training events around the world and has published numerous articles along with 9 books. He is currently working on a multi-book series on SQL Server 2012.
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.
Joe Celko
Joe Celko served 10 years on ANSI/ISO SQL Standards Committee and contributed to the SQL-89 and SQL-92 Standards.
He has written over 1200 columns in the computer trade and academic press, mostly dealing with data and databases.
He is author of eight books on SQL for Morgan-Kaufmann: SQL FOR SMARTIES (1995, 1999, 2005, 2010), SQL PUZZLES ANSWERS (1997, 2006), DATA DATABASES (1999) and TREES HIERARCHIES IN SQL (2004), SQL PROGRAMMING STYLE (2005) and ANALYTICS OLAP IN SQL (2005) and THINKING IN SETS (2008).
Mr. Celko’s past columns include: Columns for Simple-Talk (Redgate Software); “CELKO” in INTELLIGENT ENTERPRISE magazine (CMP); BMC’s DBAzine.com e-magazine; “SQL Explorer” in DBMS (Miller-Freeman); “Celko on SQL” in DATABASE PROGRAMMING DESIGN (Miller-Freeman); “WATCOM SQL Corner” in POWERBUILDER DEVELOPERS’ JOURNAL (SysCon); “SQL Puzzle” in BOXES ARROWS (Frank Sweet Publishing); “DBMS/Report” in SYSTEMS INTEGRATION (Cahner-Ziff); “Data Desk” in TECH SPECIALIST (RD); “Data Points” in PC TECHNIQUES (Coriolis Group); “Celko on Software” in COMPUTING (VNC Publications, UK), “SELECT * FROM Austin” (Array Publications, The Netherlands), and he was editor for the “Puzzles Problems” section of ABACUS (Springer-Verlag) and he ran the CASEFORUM section 18, “Celko on SQL”, on CompuServe.
Tim Radney
Twitter: - @tradney
LinkedIn: Tim Radney
Contact: http://www.timradney.com
Tim is a Data Platform MVP and has a whole collection of Microsoft and other industry certifications. His experience includes HA/DR, virtualization, SSIS, SSRS, and performance tuning, among everything else SQL Server-related. Tim is very active and passionate in the SQL Community. He runs the Columbus GA SQL Users Group, has been a PASS Regional Mentor for a number of years, was named a PASS Outstanding Volunteer in 2012, and is a frequent speaker at user groups, SQLSaturdays and PASS Summits. Tim is one of the top ranked in karma on ask.sqlservercentral.com, answers questions as @tradney on Twitter, and blogs at http://timradney.com and SQLskills blog at http://www.SQLskills.com/blogs/tim.
Mike Byrd
Twitter: - ByrdNest_TX
LinkedIn: Mike Byrd
Contact: http://logicalread.solarwinds.com/?s=byrd, www.TSQLMentoring.com and SQLServerCentral.com
Former rocket scientist and USAF Fighter Pilot – now a SQL Server geek (24 years)! Past opportunities include free-lance technical writer for PC Magazine, Senior Software Manager for government sponsored munitions effectiveness committee, and insurance company CTO. Currently senior database engineer consultant for several Austin companies.
Presenter at many SQLSaturdays over last 6 years in United States, Europe, and Australia.
Specialize in SQL Server performance tuning; database (OLTP OLAP) architecture; trouble-shooting; teaching TSQL (Basic through Advanced).
Video presentations (for local SQL Server user groups or SQLSaturdays) can be found at http://usergroup.tv/videos/category/speaker/mike-byrd
Reinaldo Kibel
Twitter: - @sqlmii
LinkedIn: Reinaldo Kibel
With over 20 years of experience in Microsoft SQL Server technology, working in one of the largest MS SQL installation in the world at Dell and having worked at Microsoft, Reinaldo is a consultant, an architect and leader in the database technology area. Reinaldo is an advisory and provides direct feedback to Microsoft SQL Server Product team part of Technology Adoption Program with MS on versions 2005, 2008, 2008R2, 2012, 2014, 2016 and 2017 leader at Dell. Reinaldo has written case studies, white papers and videos on Data technology available at Microsoft and Dell web sites. Reinaldo has presented at Ignite, SQL Summit, SQLSaturdays, and 24HOP as well as local users group in TX.
Sid Atkinson
Contact: http://blogs.catapultsystems.com/satkinson/default.aspx
Sid Atkinson is a Managing Consultant with Catapult Systems, Inc., a Gold Certified NSI Partner with Microsoft. Sid has been in the I/T industry for 10 years, building data warehouse systems and applications to consume the data. Over the years, he has worked on a large variety of client analytical needs, with data warehouses in the multi-terabyte space. Sid currently heads up Catapult’s business intelligence practice and is the founder and of the Central Texas Business Intelligence User group.
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.
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).
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.
Nancy Hidy Wilson
Twitter: - @NancyHidyWilson
LinkedIn: Nancy Hidy Wilson
Contact: http://nancyhidywilson.wordpress.com
Nancy Hidy Wilson has been working with Microsoft SQL Server since 1994. She originally volunteered for PASS at the first Community Summit held in Chicago in 1999 and has served on various PASS Committees since that time. Nancy was a PASS Community Summit speaker from 2000-2007. Nancy led the Houston Area SQL Server User Group (HASSUG) from 2001-15 and presents there and at SQLSaturday events. She also currently volunteers as an editor for the SQL Server Benchmarks with CIS.
AJ Mendo
Twitter: - @SQLAJ
Contact: http://sqlaj.wordpress.com/
AJ has over 14 years of experience working with a variety of databases. He has worked for military, civilian, and federal government organizations supporting a wide variety of applications.
AJ is a frequent speaker at user groups, SQLSaturday#39;s, and PASS Virtual Chapters, and is a board member POSSE and CACTUSS. He is a PASS Programs Committee volunteer, and he loves being a part of the SQL Community.
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.
David Stein
Twitter: - @Made2Mentor
LinkedIn: David Stein
Contact: http://www.Made2Mentor.com
David Stein - Agile Data Warehouse Architect and Independent Consultant - has more than a decade of experience working in SQL Server Business Intelligence. He’s designed multi-terabyte, multi-tenant Data Warehouses from scratch as well as saved projects in serious jeopardy.
Conor Cunningham
Conor Cunningham is a principal software architect at Microsoft on the SQL Server Query Processor Team. He’s worked on database technologies for Microsoft for over 10 years and holds numerous patents related to query optimization and query processing. Conor is the author of a number of peer-reviewed articles on query optimization techniques. Recently, he wrote a chapter for the book “Microsoft SQL Server 2008 Internals” on how the query optimizer works. He publishes a blog called “Conor vs. SQL” (http://blogs.msdn.com/conor_cunningham_msft/default.aspx), where he answers questions about databases.
David Stein
Twitter: - @Made2Mentor
LinkedIn: David Stein
Contact: http://www.Made2Mentor.com
David Stein - Agile Data Warehouse Architect and Independent Consultant - has more than a decade of experience working in SQL Server Business Intelligence. He’s designed multi-terabyte, multi-tenant Data Warehouses from scratch as well as saved projects in serious jeopardy.
Vicky Harp
Twitter: - vickyharp
Contact: http://vickyharp.com
Vicky Harp is the Group PM Manager for the SQL Server Tools Team, which is responsible for the full set of experiences from drivers and scripting libraries, to GUI tools, to the Azure Portal. She has been building tools for SQL Server for 15 years.
Jim Murphy
Twitter: - http://www.twitter.com/sqlmurph
LinkedIn: Jim Murphy
Contact: http://sqlwatchmen.com/blogs/jim/
Jim Murphy has been using Microsoft SQL Server since version 6.0 back in the 90#39;s. He is the CEO of SQLWatchmen, LLC., a managed DBA service provider. He runs the Austin SQL Server User Group: CACTUSS Central. He has been a professional DBA and developer for over 25 years and has run a consulting company full time since 2001.
Steven Ormrod
Twitter: - @DBOrmrod
Contact: http://stevenormrod.com
Steven Ormrod is a Database Administrator. He focuses on high-availability and clustering, with a dash of performance tuning thrown in for fun. His environments consist of hundreds of servers spread across multiple countries. He is on the board of directors for the Austin, Texas PASS Chapter and speaks at user groups and SQLSaturdays. Steven holds a BS in Computer Science and a Masters of Education. He is a SQL Server MCM.
Charles Joy
Contact: http://blogs.technet.com/b/charlesjoy/
Charles landed at Microsoft in 2010 through the Opalis acquisition and now works as a Sr. Business Development Manager supporting System Center. Since the acquisition, he has evangelized System Center and its place in the datacenter to thousands of people across the world. In his “spare time”, he keeps the System Center community informed with his TechNet blog and YouTube channel. Charles is also co-author of the “System Center Opalis Integration Server 6.3 Unleashed” book, available July 2011.
Justin Mason
Contact: http://www.CatapultSystems.com
Justin Mason is a Senior Lead Consultant with over 13 years of experience designing and developing software applications. He has designed large web sites, Oil Drilling client server WinForm applications, manufacturing floor automation systems, and many other applications that support the clients has has worked with over the years.
Roudy Rodarte
Contact: http://www.rodolforodarte.com
Rudy Rodarte works at HotSchedules.com as a DBA, designing SSRS reports and optimizing existing TSQL code. Previously, Rudy spent 9 years at Dell Inc, in Americas Services Parts creating and maintaining logistics databases that managed inventory in North, Central and South America. When away from the Keyboard, you’ll find Rudy playing Halo on XBox 360 or at a Baylor Bear football game.
Thomas LaRock
Twitter: - @SQLRockstar
LinkedIn: Thomas LaRock
Contact: http://thomaslarock.com
Thomas LaRock is a Head Geek at SolarWinds and a Microsoft Certified Master, Data Platform MVP, VMware vExpert, and a Microsoft Certified Trainer. He has over 15 years’ experience in the IT industry in roles including programmer, developer, analyst, and database administrator.
Jonathan Gardner
Contact: http://jonathanagardner.com
Jonathan is a Technical Manager, PMP, and MCITP working with Insource Technology in Houston, TX. He has over 10 years of experience with a wide range of IT solutions including Database Administration, Virtualization, SAN Administration, and Windows Server environments.
Sponsors
The following is a list of sponsors that helped fund the event: