SQLSaturday #2 - Tampa 2008
Event Date: 02/16/2008 00:00:00
Event Location:
- Doubletree Hotel Westshore
- 4500 West Cypress Stree
- Tampa, Florida
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: Writing Determinate Functions
Abstract: Determinate functions (also called characteristic functions) were originally used before SQL introduced the case statement. They allow you to make decisions mathematically, rather than with logic, which can make code dramatically faster. This session is not for people afraid of simple algebra.
Speaker(s):
- Jeffrey Garbus
Track and Room: Room 5 - N/A
Title: Managing SSIS Packages
Abstract: The key to long term success of SSIS based systems is a planned approach to configuration management and deployment. A carefully architected approach can simplify the management of the many variables within an organization that affect the functioning of these packages. These variables include server name, database names and file system, among others. In this session on management and deployment of SSIS, we will identify most of these variables that support our packages. Later, strategies for man
Speaker(s):
- Rushabh Mehta
Track and Room: Room 1 - N/A
Title: SQL Server Data Access Tips and Techniques
Abstract: You have optimized and tuned your SQL Server Database and now you need to access the data from your application. Learn and explore the variety of ways you can access the data using ADO.NET, the Data Access Application Block, LINQ To SQL, ADO.NET Entity Framework, ADO.NET Data Services, and the ASP.NET 3.5 Dynamic Data Framework. In this session we will walk-thru and build several examples for each technique as well as discuss tips, strengths, and weaknesses. Come with your questions and explore the wonderful world of data access to SQL Server!
Speaker(s):
- David Hayden
Track and Room: Room 4 - N/A
Title: Tips and Tricks for Reporting Services
Abstract: This session will show methods to make your reports both easier to create and more flexible. We will cover data driven layouts and formatting. We will see how templates make it easier to have more consistent report formats and how to setup data sources that are more portable. We will review emailing reports and how this can be integrated into your current application.
Speaker(s):
- Pam Shaw
Track and Room: Room 3 - N/A
Title: 20 Things You Need to Know About Analysis Services
Abstract: This is an updated version of a popular presentation given at the Tampa SQL Server Users Group in mid-2005. It now includes SSAS 2005 enhancements and UDM architecture.
Topics covered include:
What is Analysis Services? Why do you need it? Basic Cube Concepts: Hierarchies, Measures, Tuples Multidimensional Expressions (MDX) Capabilities Security Architecture Resources
Speaker(s):
- Mark Landry
Track and Room: Room 4 - N/A
Title: Getting With it With With (and Over On It, Too)
Abstract: While CTEs and Analytic functions were new features in SS2005, this talk will rather focus on the utility of these features focusing on uses gleaned from the speaker’s experience. We will cover performance enhancements, clarity of code, and problems to which the recursive capabilities of WITH can be applied as well as some ways to apply analytic functions to better performance.
Speaker(s):
- Terry Bomberger
Track and Room: Room 5 - N/A
Title: Migrating DTS Packages to SSIS
Abstract: Upgrading to SQL Server 2005 can be a major challenge for companies, but migrating your DTS packages to SSIS packages doesn’t have to be. This session will walk you through the steps needed to migrate your packages, including using the Upgrade Advisor and the Package Migration Wizard. We will discuss the items that the Wizard can handle, how to adjust for items that the Wizard can handle, and when it is best to throw the Wizard out the window.
Speaker(s):
- Jessica Moss
Track and Room: Room 1 - N/A
Title: Designing an Analysis Services cube
Abstract: Designing an Analysis Services cube is a completely different undertaking than designing a relational database. This presentation will cover the steps needed to design a cube, as well as the fundamental concepts needed for a good design.
Speaker(s):
- Robert Hatton
Track and Room: Room 3 - N/A
Title: SMO (SQL Management Objects) for SQL Server 2005
Abstract: SQL Management Objects (SMO) for SQL Server 2005 represent a .Net managed API for controlling almost all of SQL Server’s functions. Find out how to manage everything from the Job Scheduler to database schemas with ease in a .Net world. Demos will include live samples that can be used with Northwind or AdventureWorks that each attendee can take home with them.
Speaker(s):
- Brandon Kelly
Track and Room: Room 4 - N/A
Title: Index Selection for Performance Tuning
Abstract: I present everything you wanted to know about index selection, but didn’t know who to ask. Questions are welcome. Covered: Index types, how the optimizer selects indexes, forcing indexes.
Speaker(s):
- Jeffrey Garbus
Track and Room: Room 5 - N/A
Title: Introduction to Master Data Management (MDM)
Abstract: This session will provide an overview of the Master Data Management and also introduce the business value of MDM.In addition, we will look at Microsoft’s master data management software.
Speaker(s):
- Rushabh Mehta
Track and Room: Room 1 - N/A
Title: Introduction to SQL Server Integration Services
Abstract: In this session, you’ll learn the basics of SQL Server Integration Services (SSIS) by example with a real world ETL example. By the end of the session, you’ll know how to use SSIS to load dozens of files quickly in a loop and process them with some basic rules. No previous SSIS experience is needed for this session.
Speaker(s):
- Brian Knight
Track and Room: Room 1 - N/A
Title: Database Change Management with Team System
Abstract: Ever make a bunch of changes to your database then lose track of what you’ve changed? Frustrated with trying to come up with consistent, “meaningful” test data to test your applications? Wish you could unit test your database? Ever forget to make a backup copy of your stored procedure before you made that one line change (that happens to crash the system)? Tired of feeling like you’re not part of the team? Come see how you can take control of your database development with Team System.
Speaker(s):
- Jim Blizzard
Track and Room: Room 2 - N/A
Title: SQL Server CLR
Abstract: In this talk we will talk about all the things that the CLR can do in SQL Server (Stored Procedures, Triggers, Functions, etc.).
Speaker(s):
- Shawn Weisfeld
Track and Room: Room 2 - N/A
Title: Logging in SQL Server Integration Services
Abstract: Logging events and information about an SSIS package is an essential part of package management. SSIS comes with many options to allow you to view the run-time information of your packages. This session will discuss the different log providers available to you and an explanation of the data that is stored. We will show queries to retrieve relevant data and custom logging options.
Speaker(s):
- Jessica Moss
Track and Room: Room 3 - N/A
Title: Comparing Python and PowerShell DBA Scripting
Abstract: This session will discuss how DBAs can use scripting languages like Python, IronPython, and PowerShell to automate repetitive tasks across multiple database servers.
Speaker(s):
- Ronald Dameron
Track and Room: Room 2 - N/A
Title: Persisting and Tracking Workflows Using SqlServer
Abstract: SqlServer plays an important role for out-of-the-box tracking and persisting workflows. Without persistence, workflows could not handle processes that run over long periods of time. Without tracking information about a workflow as it runs, they can sometimes become black boxes while they run. This session will focus on getting DBA’s up to speed with what is happening under the hood and what is required to wire up these services within SQLServer.
Speaker(s):
- Bayer White
Track and Room: Room 5 - N/A
Title: Transactional Replication For Beginners
Abstract: Transactional replication is an amazing product that is often ignored because it looks complicated. In this session we’ll show you that you can set up replication in as little as 10 minutes, talk about some of the basic configuration options, and then field as many questions as time permits.
Speaker(s):
- Andy Warren
Track and Room: Room 2 - N/A
Title: Performance Tuning SQL Server Integration Services
Abstract: In this session you’ll learn how to performance tune SSIS’ data flow. Brian will show you a number of SSIS patterns and how to correct common mistakes. In this session, it is assumed you know the basics of SSIS already.
Speaker(s):
- Brian Knight
Track and Room: Room 1 - N/A
Title: Normalization and all that
Abstract: Discuss normalization and issues related to keys and identification as they apply to SQL and object oriented systems.
Speaker(s):
- Patrick Thompson
Track and Room: Room 5 - N/A
Title: SQL Server 2005 Reporting Solutions
Abstract: In this session we are going to discuss how to create reports with parameters and the different ways to setup report parameters, including multivalued parameters. Then we’ll look at how to create a Mailing Label report using SQL 2005 Report Server.
Speaker(s):
- Xidan Zhou
Track and Room: Room 3 - N/A
Title: TSQL Basics for Developers
Abstract: A quick and basic introduction to TSQL with a few tips thrown in. Finished with a few stupid developer tricks that cause you problems.
THIS WILL BE VERY BEGINNER and DEVELOPER ORIENTED.
If approved, i will provide a better and more complete session description.
Speaker(s):
- AJ Warnock
Track and Room: Room 3 - 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.
Mark Landry
Mark Landry has over thirty years of experience in software development.
He has been an independent software consultant for fifteen years specializing in object-oriented design and programming, relational and multidimensional database design, and data warehousing. He is considered a regional expert in Analysis Services.
Mr. Landry holds Bachelors and Masters Degrees in Computer Science.
Terry Bomberger
A long time ago (1982) in a place far away (Summit, NJ), Mr. Bomberger was a Facility Engineer in dire need of a CMMS for a pharmaceutical site. A database consultant was hired, a career change was made, and the rest is history. As a consultant, Mr. Bomberger has worked extensively in a wide range of technologies, roles, business application areas, and industries with a focus on databases. He is currently employed as an Architect by Tallan, Inc.
Bayer White
Contact: http://www.humanworkflow.net
Bayer White has been developing enterprise solutions for the past 11years using .Net Technologies. Since the first beta of the .Net Framework 3.0, his focus has been mastering Business Process Management (BPM) using Windows Workflow Foundation (WF). He is known within the Florida developer community by speaking at Florida Code Camps, blogging(http://www.humanworkflow.net) and writing articles focused on WF. He has also spoken at various conferences such as PASS, DevConnections, VSLive and MDC, a
Jeffrey Garbus
LinkedIn: Jeffrey Garbus
Contact: http://mssqlperformance.blogspot.com/
Jeff has been consulting on and performing technical training for MS SQL Server since 1989, Version 4, on OS/2. Since then, he has worked extensively with each release of the product, specializing in performance and tuning, from concept through legacy system, on systems of all sizes, from small start-up company applications to multi-terabyte data warehouses.
In addition to hands-on consulting, he speaks at SQLSaturdays several times/year, has a youtube channel with free training, and has written 20 books on database management systems.
His latest book is “Transact SQL the Definitive Guide.”
Rushabh Mehta
Twitter: - @rushabhmehta
LinkedIn: Rushabh Mehta
Contact: http://blogs.solidq.com/RushabhMehta
Rushabh Mehta is a Business Intelligence Mentor with SolidQ and the Managing Director for Solid Quality India Pvt. Ltd. He served as PASS President for 2010/2011 term.
Rushabh has worked with MS Data Platform since 1998 and has designed and developed BI systems since 2001. He has been the lead architect for many large-scale and complex BI solutions for clients such as Publix, Raymond James, Jackson Hewitt, US Dept. of Defense, and Microsoft. He is an MVP with Microsoft, Damp;B amp; Melissa Data
Jim Blizzard
Contact: http://snowstormlife.com/blogs/bliz
Jim Blizzard is the Developer Technical Specialist for Microsoft in Florida, Alabama, and Mississippi, and is based out of Tampa, Florida. Jim worked previously for Microsoft Consulting Services in the application development space, focusing on web development, and was a Developer Evangelist for Microsoft, spreading the good news of .NET to the masses in the Pacific Northwest.
Shawn Weisfeld
Twitter: - https://twitter.com/shawnweisfeld
LinkedIn: Shawn Weisfeld
Contact: http://www.usergroup.tv
Shawn (http://www.shawnweisfeld.com, shawn@shawnweisfeld.com) is passionate about building awesome applications and websites with .NET technologies and Azure. He is currently a Technical Evangelist for Microsoft based in Austin TX and founder of http://UserGroup.tv. Read his full bio at http://about.me/shawnweisfeld
Brandon Kelly
Contact: http://blogs.estatic.org/users/avatar.aspx?userid=2102
Mr. Kelly is a technical professional with over 10 years experience in developing and leading teams that write “killer apps”. Mr. Kelly owned and operated a private micro-consultancy (estatic.org / BusinessRx) for over 4 years, where he built a technical platform that allowed software developers around the world to create high-impact web applications with ease. In January, 2008 Mr. Kelly re-joined his colleagues at Tribridge. Tribridge’s success in the Microsoft consulting industry is represente
Jessica Moss
Twitter: - @jessicammoss
Contact: http://www.jessicammoss.com
Jessica M. Moss is a well-known architect, speaker, author, and Microsoft MVP of SQL Server Business Intelligence. Jessica#39;s expertise includes data warehouse modeling, Integration Services ETL, Analysis Services semantic modeling, Reporting Services report design, and helping customers across industries successfully implement and enhance their BI solutions. She enjoys sharing her knowledge with the SQL community and has co-authored numerous technical books.
Ronald Dameron
Twitter: - @RonDBA
LinkedIn: Ronald Dameron
Contact: http://RonaldDameron.com
Ronald Dameron is The Only DBA at a small software company building planet-scale mobile resource management software.
He has over 20 years IT experience on a variety of platforms. His current interests are Azure, PowerShell, SQL Server 2016 and Linux.
He was a PASS Summit 2015 Speaker Idol contestant and has spoken at SQLSaturday Tampa, Orlando, South Florida, and the Tampa and Orlando SQL User groups. He has recently earned the Competent Communicator Award from Toastmasters International.
He is most active on Twitter as @RonDBA.
Brian Knight
Twitter: - @BrianKnight
Contact: http://www.bidn.com/people/brianknight
Brian Knight, a SQL Server MVP, MCSE, and MCDBA, is the owner and founder of Pragmatic Works. He is also the co-founder of SQLServerCentral.com, BIDN.com, and SQLShare.com. Brian runs the local SQL Server users group in Jacksonville (JSSUG), is a contributing columnist at several technical magazines, and does regular webcasts at PragmaticWorks.com. He is the author of 15 SQL Server books and a frequent speaker at conferences such as PASS Summit, SQL Connections, TechEd, and many Code Camps.
Jessica Moss
Twitter: - @jessicammoss
Contact: http://www.jessicammoss.com
Jessica M. Moss is a well-known architect, speaker, author, and Microsoft MVP of SQL Server Business Intelligence. Jessica#39;s expertise includes data warehouse modeling, Integration Services ETL, Analysis Services semantic modeling, Reporting Services report design, and helping customers across industries successfully implement and enhance their BI solutions. She enjoys sharing her knowledge with the SQL community and has co-authored numerous technical books.
Robert Hatton
LinkedIn: Robert Hatton
Contact: http://www.RobertJHatton.com
Rob Hatton is the author of the Business Intelligence Team Handbook.
Rob is also a past president of the PASS Business Intelligence User Group here in Tampa. He is a veteran B.I. developer with more than 30 years of database experience and dozens of successful B.I. project deployments.
Brian Knight
Twitter: - @BrianKnight
Contact: http://www.bidn.com/people/brianknight
Brian Knight, a SQL Server MVP, MCSE, and MCDBA, is the owner and founder of Pragmatic Works. He is also the co-founder of SQLServerCentral.com, BIDN.com, and SQLShare.com. Brian runs the local SQL Server users group in Jacksonville (JSSUG), is a contributing columnist at several technical magazines, and does regular webcasts at PragmaticWorks.com. He is the author of 15 SQL Server books and a frequent speaker at conferences such as PASS Summit, SQL Connections, TechEd, and many Code Camps.
Patrick Thompson
Contact: http://www.standingwaiting.com/Resume/WebResume.htm
http://www.standingwaiting.com/Resume/WebResume.htm
Xidan Zhou
Microsoft Certified Database Administrator (MCDBA) Highest Education: Masters’ Degree in Computer System Engineering Has nearly ten year experience in IT, has been working with SQL server from version 6.5. Worked as both database/application developer and DBA.
David Hayden
Contact: http://www.davidhayden.com/
TBA
Pam Shaw
Pam has been a developer for over 25 years. For the last 20 years she has been developing for software vendors. For the last 5 years she has been actively involved with SQL Server. She has bee the President of the Tampa Bay SQL Server Group for the past year.
AJ Warnock
Will complete if session approved
Jeffrey Garbus
LinkedIn: Jeffrey Garbus
Contact: http://mssqlperformance.blogspot.com/
Jeff has been consulting on and performing technical training for MS SQL Server since 1989, Version 4, on OS/2. Since then, he has worked extensively with each release of the product, specializing in performance and tuning, from concept through legacy system, on systems of all sizes, from small start-up company applications to multi-terabyte data warehouses.
In addition to hands-on consulting, he speaks at SQLSaturdays several times/year, has a youtube channel with free training, and has written 20 books on database management systems.
His latest book is “Transact SQL the Definitive Guide.”
Rushabh Mehta
Twitter: - @rushabhmehta
LinkedIn: Rushabh Mehta
Contact: http://blogs.solidq.com/RushabhMehta
Rushabh Mehta is a Business Intelligence Mentor with SolidQ and the Managing Director for Solid Quality India Pvt. Ltd. He served as PASS President for 2010/2011 term.
Rushabh has worked with MS Data Platform since 1998 and has designed and developed BI systems since 2001. He has been the lead architect for many large-scale and complex BI solutions for clients such as Publix, Raymond James, Jackson Hewitt, US Dept. of Defense, and Microsoft. He is an MVP with Microsoft, Damp;B amp; Melissa Data
Andy Warren
Twitter: - @sqlandy
Contact: https://sqlandy.com
Andy Warren is a SQL Server consultant and trainer based in Orlando, FL. Focusing on administration, performance tuning, and SQL Server patterns and practices, he’s been a SQL Server MVP since 2008. Andy served two terms on the PASS Board of Directors, was a founding principal in SQLServerCentral, and created both the SQLSaturday and SQLRally event models.
Sponsors
The following is a list of sponsors that helped fund the event: