SQL Lunch Calendar

We have been working hard trying to get speakers to complete the year for our SQL Lunch schedule. I am excited to announce that the calendar is almost complete. There are still a few openings in December if any of you are brave enough to give us fifteen to thirty minutes of your time email me at pleblanc@tsqlscripts.com. If you are interested in receiving updates about the upcoming SQL Lunches please go here: http://www.tsqlscripts.com/sqllunch.aspx and register.

Date: 9/14/2009 Time: 11:30 AM Presenter: Jeff Cole. Jeff has been designing and building information technology systems for over 20 years. He has experience across many industries including banking & finance, health care and telephony using a variety of mainframe languages as well as the gamut of Microsoft development environments. He has been working lately in the middleware space developing systems on multiple platforms using integration technology to solve complex connectivity problems. Jeff is currently working with Attunity to help customers modernize legacy systems and make the most of their technology investments with an emphasis on the Microsoft technology stack including SQL Server and Integration Services. Topic: Oracle-CDC for SQL Server Integration Services. Leverage your SQL Server skills and software to reduce cost and accelerate Oracle data replication, synchronization, and real-time integration and enable operational reporting, business intelligence and data warehousing projects.

Date: 9/28/2009 Time: 11:30 AM Presenter: Thomas LeBlanc. Thomas is a Database Administrator for Amedisys, Inc in Baton Rouge, LA. He has been in the IT field for 20 years starting as a COBOL programmer, graduating to dBase, FoxPro, Visual FoxPro, VB 3 thru 6 and even some .Net(C#). Designing and developing normalized databases has become his passion. Full-time DBA work started about 8 years ago for Thomas while working at a Paper Mill in St. Francisville, LA continuing with IEM, then Amedisys. Current activity at Amedisys involves 4 other DBAs Topic: Historical DMV Information DMV are great to find information about performance without running a trace. But there information is lost once the SQL Server service is restarted. After finding some useful scripts online (Thanks SQL Server community!!!) , I decided to schedule a job to run the night before to store Index Usage, Least Used Indexes, SP Usage, Missing Index and Expensive CPU Usage. We will review the scripts and historical data captured.

Date: 10/12/2009 Time: 11:30 AM Presenter: Tim Mitchell .Tim is a Microsoft SQL Server consultant, developer, speaker, and trainer.  He has been working with SQL Server for over 6 years, working primarily in database development, business administration, data integration, and automation.  He has earned a number of industry certifications and holds a Bachelor's Degree in Computer Science from Texas A&M at Commerce. Tim is principal and senior data engineer for Tyleris Data Solutions, a business intelligence and data management consulting firm.  As an active member of the community, Tim has spoken at venues including SQL Saturday and the PASS Business Intelligence SIG, and is an active volunteer and speaker at the North Texas SQL Server User Group in Dallas.  Tim is an author and forum contributor on SQLServerCentral.com and has published dozens of SQL Server training videos on JumpstartTV.com. Topic: Deploying Report Builder 2.0 for Self-Service Reporting For the DBA, creating and maintaining reports can take up a significant amount of time.  Constantly changing requirements, an endless stream of ad-hoc requests, and simple formatting changes all add up to a good deal of maintenance.  To lighten the load, Microsoft offers SQL Server Report Buider 2.0, an easy-to-use reporting tool for building published and ad-hoc reports using SQL Server Reporting Services.  In this SQL Lunch presentation, we'll look at the capabilities of Report Builder 2.0 and how it can be used with SSRS to allow users to create and maintain many of their own reports.

Date: 10/26/2009 Time: 11:30 AM Presenter: Barry Ralson. Barry is currently Vice President for Technical Solutions with Birmingham-based ComFrame Software. Since joining ComFrame in 2001, his client successes include Aflac, Honda, and the Children's Hospital of Alabama. In addition to speaking at the Alabama .Net Code Camps 1, 4 and 5, Barry has delivered presentations on Business Intelligence with Microsoft technologies at SQL Saturday 1 and 4. Topic: Accidental DBA and Performance Data Collector A new feature in SQL 2008 may well improve the ability of “accidental DBA’s” to monitor, manage and tune SQL Server.  This presentation will outline how to setup Performance Data Collector (PDC) and use the included Management Data Warehouse reports to take action on your database server based on information and not ‘gut feel’ or hunch.

Date: 11/9/2009 Time: 11:30 AM Presenter: Brandon Fridge. Brandon is a Developer for Lamar Advertising Topic: SQLCacheDependency The SQLCacheDependency class provides an extremely lightweight and simple method of integrating your web app with the browsers built in caching.

Date: 11/23/2009 Time: 11:30 AM Presenter: Patrick LeBlanc. Patrick is the Sr. Database Administrator for Lamar Advertising. He is the founder of TSQLScripts.com, leader of the Baton Rouge Area SQL Server User Group, Founder of SQL Lunch and a regular blogger on SQLServerCentral.com. Topic: SSIS – Dynamic File Name SSIS is a very flexible and robust tool. One of the great features is the script task. Using the script task I will show you how dynamically build file names.