Topic:  Business Intelligence - Starting from Scratch

Speaker:  Michael Edwards, Solution Architect, New World systems

November LiveMeeting

Topic:
Deploying, Managing, and Using SSIS
Date:
Thursday, Oct 8th, 2009
Speakers:
Christopher Campbell, Principal Consultant, Blue Granite
 
Location:
Microsoft Heartland District Offices, 1000 Town Center, Southfield, MI
Overview:
 
SQL Server Integration Services is Microsoft’s premier 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.
 TitleOwnerCategoryModified DateSize 
 TitleOwnerCategoryModified DateSize 
Topic:
Reducing Storage Costs through De-Duplication
Date:
Thursday, Sep 17th   6:00pm
Speakers:
Greg Simmons, Sr. Storage Engineer, Adexis. 
Speakers:
Break through some of the confusnig 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.
Topic:
SQL Server Replication
Date:
Thursday, August 13, 2009   6:00pm
Speakers:
Tommy Brickle, DBA, Plex Systems 
Speakers:
Overview:  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.
 TitleOwnerCategoryModified DateSize 
Topic(s):                 The Running Total Problem and Other "Previous Row" Calculations and Groupings
Creating the Million Row Test Table
 
Overview:               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:                 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.
 TitleOwnerCategoryModified DateSize 
Topic:                      Improving  SQL database storage efficiency and performance
Overview:               What SQL Server performance counters 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:                 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.
 TitleOwnerCategoryModified DateSize 
Date:                       April 9, 2009
Topic:                     Table Partitioning
 
Overview:               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:                Tommy Brickle is a Database Administrator with Plex Systems
 TitleOwnerCategoryModified DateSize 

Date:                       March 12, 2009.

Topic:                      What happens in SQL Server Plan Cache?
Overview:               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.
NOTE:                      Due to technical difficulties with recording equipemt, the livemeeting is not available. We are attempting to acquire the slides from the presenter and will post them once we do.
Speaker:                 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
 TitleOwnerCategoryModified DateSize 

Topic:

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

Date:

Thursday, February 12, 2009   6:00pm

Speakers:

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

 

Overview:

RSS:  Provide 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.

Tally Table:  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 CSVColumn... all with no cursors, no loops, no functions, and no performance problems.

 TitleOwnerCategoryModified DateSize