SQL PASS Detroit

February 2009

Double Feature!  Using RSS for system Administration + Replacing Loops with Tally Tables

The first session provides an overview using simple tools that generate standard RSS feeds containing information regarding SQL Server jobs; ad-hoc queries and database size and space allocation information. This session will demonstrate using RSS to automate a daily DBA morning checklist by aggregating error logs, backup and additional information across multiple servers/databases.

In the second session, explore what a Tally table is and how it works to replace loops. We'll start out simple and build to the classic example of "splitting" a parameter. We'll throw in the added bonus of how to normalize an entire table worth of a CSV Column... all with no cursors, no loops, no functions and no performance problems.

Speaker Bio
Chad Miller is a SQL Server DBA and Manager of Database Administration at Raymond James Financial. He has 9 years experience as DBA, working with SQL Server 6.5 through SQL Server 2008. He is the author of various technical articles published in SQL Server Central and SQL Server Magazine and has presented at the Tampa Bay SQL Server User Group and SQL Saturday. In his spare time Chad is the Project Coordinator/Developer of Codeplex projects SQL Server Powershell Extensions (SQLPSX) and PoshRSS and blogs at http://chadwickmiller.spaces.live.com

Jeff Moden is a SQLServerCentral.com author and coiner of the term "RBAR" (pronounced ree-bar) for statements that process data "Row By Agonizing Row".

Windows Media File (.wmv 24 MB)
RSS for Admin Powerpoint Presentation (.ppt 1 MB)
Tally Table Powerpoint Presentation (.wmv 171 KB)
Tally Table Code (.zip 104 KB)

March 2009

What happens in SQL Server Plan Cache?

What DMVs are used to examine the plan cache?
What information can we learn about our system from the plan cache?
How to implement a monitoring system that captures plan cache information real-time.

Speaker Bio
Jerry Foster is one of the founders and Chief Scientist of Plex Systems, where he has been the development and technical lead for over 18 years. Plex's premier product, Plex Online, is the first and only fully integrated, on-demand manufacturing software hosted completely over the internet. Plex Online is accessed via a simple web browser.

Due to technical difficulties, the Livemeeting recording was lost.

April 2009

Table Partitioning

During this presentation we will explore the performance benefits of partitioning, how to identify a table as a potential candidate for partitioning, identifying the ideal fields for partitioning, and maintaining the partition once it is created.

Speaker Bio
Tommy Brickle is a Database Administrator with Plex Systems.

Windows Media File (.zip 12 MB)

May 2009

Improve SQL Database Storage Efficiency with NetApp

What SQL Server performance counters to use to monitor when reviewing disk throughput and utilization.
How to reduce storage costs significantly with space-efficient backup capabilities.
How to eliminate storage overhead for SQL testing and development.
Streamline data management and automate routine tasks to increase DBA productivity.
Increase backup frequency to protect more data automatically without impacting performance.
Streamline management of SQL Server data across multiple storage resources with automated backup and recovery processes.

Speaker Bio
John W. Jones is a Solution Architect at NetApp. He joined NetApp in 2006 as a Microsoft specialist to better understand application level storage requirements when architecting storage solutions for SQL, SharePoint and Exchange. Before joining NetApp, he spent about ten years working for Microsoft gold system integrators doing system administration, design and implementations. He holds a current MCTS certification and was awarded a Microsoft MVP in 2006.

Windows Media File (.zip 11 MB)

June 2009

The Running Total Problem and Other "Previous Row" Calculations and Groupings

The ROW_NUMBER() and RANK() "windowing functions" work great but what if you are still using SQL Server 2000? What if you need to number groups of rows in a particular order or sequence that even ROW_NUMBER() won't handle? What if you need to "copy data down" to the next row or do something to the next row based on the previous row like a Running Total, Grouped Running Total, or a 5 day average sliding window? Even SQL Server 2008 doesn't have functions like that! So what do you do? Use a RBAR Cursor or While Loop? Not on your life. It's too slow! This Developer-to-Developer session demonstrates a unique technique to solve all those problems in a super fast set-based fashion. Some of the "bad" techniques will also be demonstrated so you know what to watch out for.

"A Developer must not guess - a Developer must KNOW!" There are many myths and legends about what makes high performance code. The problem is that most folks demonstrate their "speed" on only 10 or 20 rows. As the number of rows in a table go up, the Execution Plan changes and maybe that code that someone is so proud of doesn't work in the face of scalability. How can you test for such a thing? Easy - build a million row test table to test against. This Developer-to-Developer session demonstrates how to create and control the content of a million row table without buying any 3rd party tools. It's all done in T-SQL and it works in less than 30 seconds. Better than that, the code is only 4 lines long plus 1 line for each desired column and two of those are duplicates which makes this method easy to remember.

Speaker Bio
SQL Server MVP Jeff Moden is back with more T-SQL tricks up his sleeve in two more "Developer-to-Developer" presentations. As you may recall, Jeff gave the first ever "Developer-to-Developer" presentation for SEMSSUG last February on the Tally table and how to use it to replace loops. Jeff has several articles and more than 15,000 posts (as he says, "Some are actually useful!" ) on SQLServerCentral.com. This double header session is actually a preview of part of what's to come in the book he's currently for RedGate/Simple Talk publishing and two of the presentation abstracts that he submitted for this year's PASS conference.

Windows Media File (.zip 27 MB)

August 2009

SQL Server Replication

We will be covering the complete life cycle around merge replication and how it can be used in your shop.  This will include many of the day to day task needed to manage merge replication, creating publications with static and dynamic filters, publishing and republishing subscriptions disaster best practices for recovery of published databases and many tricks for getting the most out of merge replication

Speaker Bio
Tommy Brickle, DBA at Plex Systems

Windows Media File (.zip 21 MB)

September 2009

Reducing Storage Costs through De-Duplication

Break through some of the confusing terminology surrounding technology related to de-duplication. Learn how it can save storage space, and what targets are prime for de-duplication and which are not. Greg will also discuss some different de-duplication strategies, such as inline or post-processing de-duplication.

Speaker Bio
Greg Simmons, Sr. Storage Engineer, Adexis

Windows Media File (.zip 7 MB)

October 2009

Deploying, Managing and Using SSIS

SQL Server Integration Services is Microsoft's technology for developing Extract-Transform-Load processes for SQL Server. It provides developers and administrators with all of the tools they need to develop high-performing, production-ready applications for integrating data from disparate systems and technologies. This session will cover built-in features of SSIS that make it easier for organizations to deploy SSIS packages across the enterprise, log package execution and errors and manage ETL processes through multiple environments.

Speaker Bio
Christopher Campbell, Principal Consultant, Blue Granite

November 2009

Business Intelligence - Starting from Scratch

Starting from scratch with business intelligence.

Speaker Bio
Michael Edwards, Solution Architect at New World Systems

Livemeeting (.zip 17 MB)

Back to Top