SQLSaturday #17 - Baton Rouge 2009
Event Date: 08/01/2009 00:00:00
Event Location:
- Louisiana State University - College Of Engineering
- 1109 Patrick F. Taylor Hall
- Baton Rouge, Louisiana
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: Codecraft
Abstract: Winning a round of golf doesn’t make you Tiger Woods. Knowing how to ride a bike doesn’t make you Lance Armstrong and collecting a salary to do something doesn’t mean you are proficient at it. Being able to write software that doesn’t break and getting paid for it doesn’t make you a professional. Software development is a craft and, like every other craft, to be a master craftsman you must be one who practices it with great skill. Learn the tools of the craft, the discipline to use them and start your journey to becoming a master craftsman.
Speaker(s):
- Phillip Jackson
Track and Room: .Net - N/A
Title: Care and Feeding of TempDB
Abstract: Well, every single SQL Server instance in existence has a tempDB, so I expect to see everyone in attendance for this presentation on the hows, whys and wheretofors of this very important database!
Speaker(s):
- Kevin Boles
Track and Room: Infrastructure - N/A
Title: Providing Enhanced Business Value Using Scorecards
Abstract: You hear people talk about scorecards and the differences between scorecards and dashboards. What are those differences and what do they mean to you? Scorecards using Microsoft BI tools are not difficult to create, but without proper planning and design they will miss the mark and fail to provide the desired business benefit. In this session you’ll learn about best practices in creating scorecards, as well as examine some unique client approaches to really get to the heart of the business problem.
Speaker(s):
- John Lauer
Track and Room: BI/SQL Admin - N/A
Title: Indexing For Performance
Abstract: Everything you need to know about SQL Server indexing! Specific areas of focus include: understanding index physical structures, evaluating index usefulness and selection, generating and maintaining index statistics, and optimizing queries using indexes. There will be many demonstrations to illustrate key topics and recommendations.
Speaker(s):
- Ryan Richard
Track and Room: SQL Development - N/A
Title: Can you control your reports? (SSRS 2005)
Abstract: Having trouble or trying to figure out how you can navigate to your reports through your application, without creating a complete dashboard? This session will show you how to navigate and control your reports through your application using links. Also let you know what additional options you have out of the box with the different rendering extensions available.
Speaker(s):
- Ryan Duclos
Track and Room: .Net - N/A
Title: SSIS: Beyond the Basics
Abstract: In this session, we’ll explore some of the useful tasks and data flow components of SSIS. Join in as we review the File System Task and the For Each Loop container, as well as data flow components including the Lookup Transformation, the Conditional Split, and the Derived Column. This session will include various demonstrations using SSIS 2008.
Speaker(s):
- Tim Mitchell
Track and Room: BI/SQL Admin - N/A
Title: Table-Valued Parameters (TVP)
Abstract: Table-valued parameters are a new parameter type in SQL Server 2008. Table-valued parameters are declared by using user-defined table types. You can use table-valued parameters to send multiple rows of data to a Transact-SQL statement or a routine, such as a stored procedure or function, without creating a temporary table or many parameters. Ever wanted to sent a list to a stored procedure? We will show you how!
Speaker(s):
- Phillip Jackson
Track and Room: SQL Development - N/A
Title: Disk Partition Alignment
Abstract: EVERYONE can benefit from this presentation!! Improper disk alignment will rob the server of 15-50% IO throughput capability. We will cover what disk partition alignment really is, how it affects performance and how you can get it done correctly.
Speaker(s):
- Kevin Boles
Track and Room: Infrastructure - N/A
Title: Introduction SQL Profiler
Abstract: What is the SQL Profiler? Looking for a trouble shooting tool or a performance tuning tool, then you should be using the SQL Profiler. In this session I will provide an overview of some typical yet practical everyday uses of the SQL Server Profiler.
Speaker(s):
- Patrick LeBlanc
Track and Room: SQL Development - N/A
Title: RML Ultities
Abstract: Microsoft Support (CSS, formerly PSS) has made available a ultitiy to do an analysis of a trace file. This session will go through an explanation of how to use this utility and interpret the results.
RML Utilities can answer questions about where the most resources are being consumed, queries that are responsilble for heavy usage, changes in plans during trace and if queries are running slow in comparison to other traces.
Speaker(s):
- Thomas LeBlanc
Track and Room: BI/SQL Admin - N/A
Title: TFS/VSTS 2010 sneak peek
Abstract: A Look at some of the new cool features in TFS/VSTS 2010. Both from Project Managment, Coding and QA.
Speaker(s):
- Michael Moles
Track and Room: Infrastructure - N/A
Title: Geospatial capabilities of SQL 2008
Abstract: What does the introduction of spatial capabilities in SQL Server 2008 mean? In this session we will go over the standards, data types, and implementation of SQL 2008’s spatial features. Also, we will discuss how to implement geospatial data and some possible implications and ramifications spatial data that might result.
Speaker(s):
- Stacey Hopkins
Track and Room: SQL Development - N/A
Title: SSIS Introduction
Abstract: See a sample of what SQL Server Integration Services has to offer with some real-life examples and usage demos that will inspire you to take advantage of the powerful engine of SSIS. Your old DTS packages will shiver in fear.
Speaker(s):
- William Assaf
Track and Room: BI/SQL Admin - N/A
Title: SQL 2008 Reporting Services - Getting Started
Abstract: Providing relevant data to both systems and end users via SQL 2008 Reporting Services. In this session I will provide an overview of reporting services and demonstrate several methods of deployment, including via Windows Sharepoint Services.
Speaker(s):
- Mark Verret
Track and Room: SQL Development - N/A
Title: The Modern Resume: Building Your Brand
Abstract: Steve Jones, founder of SQL Server Central talks about how to update your resume to fit into today’s modern world, and take advantage of the tools offered by blogging, social networking, and more.
Speaker(s):
- Steve Jones
Track and Room: Infrastructure - N/A
Title: Windows Communication Foundation
Abstract: Communication breakdown: What is WCF and what you can do with it. We’ll cover the basic ideas behind WCF and then show a practical example of using it to build N-tiered applications.
Speaker(s):
- Joseph Besse
Track and Room: .Net - N/A
Title: BI Solutions for a Tough Economy
Abstract: Do all stakeholders in your organization ‘know the score’? In this tough economic climate, it is more important than ever to have visibility into the key metrics that determine organizational survival.
Excel Services provides a powerful and flexible tool for increasing visibility of key metrics throughout the organization. Through examples, this session will show attendees the most useful capabilities of Excel Services for collaboration, including Excel-based KPI’s, dashboards and charting. Learn how to leverage Excel experience to rapidly create SharePoint sites to securely share actionable information.
Speaker(s):
- Barry Ralston
Track and Room: BI/SQL Admin - N/A
Title: Zen Coding
Abstract: The philosphy of being a professional code craftsman.
Speaker(s):
- Brian Rigsby
Track and Room: .Net - N/A
Title: DMV Overview
Abstract: A tour of Dynamic Management Views in SQL 2005 and 2008, covering the most important DMV’s and getting you started on getting the most you can out of these crucial performance indicators.
Speaker(s):
- William Assaf
Track and Room: SQL Development - N/A
Title: Test Driven Development
Abstract: Test Driven Development using C#.net and NUnit – Introduction to test driven development and how to create and run tests using C#.net and NUnit.
Speaker(s):
- Joseph Besse
Track and Room: .Net - N/A
Title: Reporting Services 2008 - Report Authoring
Abstract: Introduction to Reporting Services 2008 and an overview of some the Report Authoring changes from Reporting Services 2005 and Reporting Services 2008.
Speaker(s):
- Ryan Duclos
Track and Room: BI/SQL Admin - N/A
Title: Custom ETL using SSIS Scripting
Abstract: In this session, we will explore the Script Task and Script Component tools within SSIS. Learn how to break out of the traditional flat-file ETL mold and, using VB.NET or C#, create custom scripts to address unconventional transformations and related tasks.
Speaker(s):
- Tim Mitchell
Track and Room: .Net - N/A
Title: Deadlocks: Detection, Troubleshooting, and Prevent
Abstract: As an enterprise application grows and load increases, some concurrency issues are bound to surface. Deadlocks are one of the more aggravating of this class of problems. Fortunately, each release of SQL Server includes better tools for troubleshooting deadlocks. Trevor will provide a strong foundation on deadlocks and then demonstrate approaches for handling them in SQL Server 2000, 2005, and 2008.
Speaker(s):
- Trevor Barkhouse
Track and Room: Infrastructure - N/A
Title: The Basics of Scrum and Why it Works
Abstract: Scrum is a lightweight, agile project management framework that allows us to focus on delivering the highest business value in the shortest time. We will discuss real-world implementations from a project management and development perspective.
Speaker(s):
- Brad McDonald
Track and Room: Infrastructure - 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.
Brad McDonald
Kevin Phillips and Brad McDonald are both Certified ScrumMasters who have implemented Scrum on a large-scale, enterprise wide project.
Mark Verret
Mark Verret is the IT Manager for the LSU Highway Safety Research Group. He has over 20 years experience in the IT field. He has worked with SQL Server for the past 12 years implementing Business Intelligence and data warehousing related projects.
Steve Jones
Twitter: - way0utwest
LinkedIn: Steve Jones
Contact: http://www.voiceofthedba.com/
Steve Jones is a Microsoft SQL Server MVP and has been working with SQL Server since version 4.2 on OS/2. After working as a DBA and developer for a variety of companies, Steve co-founded the community website SQLServerCentral.com in 2001. Since 2004, Steve has been the full-time editor of the site, ensuring it continues to be a great resource for SQL Server professionals. Over the last decade, Steve has written hundreds of articles about SQL Server for SQLServerCentral.com, SQL Server Standard magazine, SQL Server Magazine, and Database Journal.
Joseph Besse
I’m currently one of the system architects for Lamar Advertising and have over 10 years experience developing software in various industries. I’ve worked with a variety of communication stacks over the years including: DCOM, TCP/IP, HTTP, .Net Remoting, Web Services, MSMQ, and WCF.
Barry Ralston
Contact: http://www.sqlbipro.com
Barry Ralston is Chief Architect for Business Intelligence with Birmingham-based ComFrame Software. Barry is also Microsoft Corporation’s Virtual Technical Specialist (VTS) for Business Intelligence, responsible for assisting in Alabama, Mississippi and Northwest Florida in sales efforts including customer meetings, software demonstrations and Proof of Concept efforts. Barry’s client successes include: Georgia Tech Research Institute, Bank of Hawaii, Honda Manufacturing of Alabama and Aflac.
Michael Moles
Michael B. Moles - Mike is co-owner and Chief Executive Officer of Antares Technology Solutions, Inc. with over twenty years experience in custom software design and development, project management, and Quality Assurance. Antares is a Microsoft Gold Partner as well as inner circle partners. Mike continues to stay very involved in our continued relationship and partnership with Microsoft. Mike sits on the Baton Rouge Area Chamber Board and is very active in the technology sector. He
Stacey Hopkins
LinkedIn: Stacey Hopkins
Mr. Hopkins has been working with computer systems, networks, and databases since 1991. He has worked in various industries including banking, law, and wholesale/retail. He has spent the last 10 years focusing on databases, business intelligence, and enterprise data management.
Joseph Besse
I graduated from Nicholls State University with a major in Computer Information Systems and a minor in Computer Science and have been writing software in exchange for money since 1999. I was part of a small startup company as my first job out of college (it did not succeed). I spent a few years as a consultant before landing a job at Lamar. I started programming in Visual Basic before almost switching to Java. .Net was released and I switched to VB.Net. I made the transition to C# shortly after.
Ryan Duclos
Contact: http://about.me/rduclos
Ryan Duclos is a Lead Technical Consultant for Perficient, Inc. (PRFT), where he is passionate about Microsoft development utilizing the .Net Framework, SQL Server, and Windows Azure technologies. He lives and works in LA (Lower Alabama!) and loves spending time with his family, as well as being a community influencer for Microsoft. Ryan recently became a Microsoft Azure MVP.
Tim Mitchell
Twitter: - @Tim_Mitchell
LinkedIn: Tim Mitchell
Contact: http://www.TimMitchell.net
Tim Mitchell is a business intelligence architect, author, and trainer. He has worked with SQL Server for over a decade, specializing in data warehousing, ETL/SSIS, and reporting. He holds a Bachelor’s Degree in Computer Science from Texas AM at Commerce, and is recognized as a Microsoft Data Platform MVP. Tim is a business intelligence consultant and principal at Tyleris Data Solutions.
Tim is an active community speaker and volunteer, having spoken at over 100 events including the PASS Summit, SQLBits, Dev Connections, SQL Intersection, and scores of SQLSaturdays. He blogs at TimMitchell.net, and tweets at @Tim_Mitchell.
Brian Rigsby
I am a senior developer with Antares Technology Solutions.
Phillip Jackson
Contact: http://rampantcodecraft.blogspot.com/
After leaving Mechanical Engineering at LSU for a degree in Computer Science at Southeastern Louisiana University, Phillip is an aspiring software craftsman taking the scientific approach to development. Software development is both his profession and his hobby. He is currently a developer with Antares Technology Solutions Inc.
Kevin Boles
Twitter: - @TheSQLGuru
LinkedIn: Kevin Boles
Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.
William Assaf
Twitter: - william_a_dba
LinkedIn: William Assaf
Contact: http://www.sqltact.com
William Assaf, Data Platform MVP, is a principal consultant in Baton Rouge, LA. Initially a .NET developer, and later into database administration and architecture, William currently works with clients on SQL Server and Azure SQL platform optimization, management, disaster recovery and high availability, and leads a crack multi-city team of consulting SQL DBA’s. William has written for Microsoft SQL certification exams since 2011 and was the lead author of the 2017 and 2019 editions of “SQL Server Administration Inside Out” by Microsoft Press. William is a member of the Baton Rouge User Groups board, a regional mentor for PASS, and past lead of the annual SQLSaturday Baton Rouge Planning Committee, having run one of the largest SQLSaturdays.
Ryan Duclos
Contact: http://about.me/rduclos
Ryan Duclos is a Lead Technical Consultant for Perficient, Inc. (PRFT), where he is passionate about Microsoft development utilizing the .Net Framework, SQL Server, and Windows Azure technologies. He lives and works in LA (Lower Alabama!) and loves spending time with his family, as well as being a community influencer for Microsoft. Ryan recently became a Microsoft Azure MVP.
Tim Mitchell
Twitter: - @Tim_Mitchell
LinkedIn: Tim Mitchell
Contact: http://www.TimMitchell.net
Tim Mitchell is a business intelligence architect, author, and trainer. He has worked with SQL Server for over a decade, specializing in data warehousing, ETL/SSIS, and reporting. He holds a Bachelor’s Degree in Computer Science from Texas AM at Commerce, and is recognized as a Microsoft Data Platform MVP. Tim is a business intelligence consultant and principal at Tyleris Data Solutions.
Tim is an active community speaker and volunteer, having spoken at over 100 events including the PASS Summit, SQLBits, Dev Connections, SQL Intersection, and scores of SQLSaturdays. He blogs at TimMitchell.net, and tweets at @Tim_Mitchell.
Patrick LeBlanc
Contact: http://sqldownsouth.blogspot.com/
Patrick LeBlanc is currently a BI Consultant for Pragmatic Works. I have 9 years experience with developing and deploying database solutions. Patrick is a regular speaker at SQLSaturday, User Groups and SQL Lunches. He is also the founder of TSQLScripts.com and SQLLunch.com. Patrick is also the President of the Baton Rouge Area SQL Server User Group.
Thomas LeBlanc
Twitter: - TheSmilingDBA
LinkedIn: Thomas LeBlanc
Contact: http://Thomas-LeBlanc.com
Thomas LeBlanc (Microsoft Data Platform MVP) is a Data Warehouse Architect in Baton Rouge, and uses his 30+ years in IT to develop OLTP systems with normalized databases for high-performing T-SQL and dimensional data marts. Development is done in SSIS, SSAS, SSRS, Power BI, and Excel. As a PASS volunteer, he is past chair of Excel BI and Data Arch VCs and is active in the Baton Rouge Analytics and SQL Server User groups, as well as SQLSaturday in Baton Rouge. You can find his blog at TheSmilingDBA.BlogSpot.com and website at Thomas-LeBlanc.com
John Lauer
John Lauer is a Senior Manager at Hitachi Consulting and is a member of their Microsoft BI National Team. Mr. Lauer has 15 years experience in IT and consulting and 9 years specializing in Business Intelligence and Performance Management (BIPM). BIPM experience includes a mix of financial planning analysis and various BI reporting/analysis implementations. Client experiences come from a variety of industries that include Chemicals, Construction Products, Consumer Goods, Financial Services,
Ryan Richard
I am currently a software developer in Baton Rouge, LA. I have worked in the IT industry for the past 18 years, including stints as a systems engineer, a DBA, and most recently as a software developer. My current interests include web applications, Internet startups, and neural networks.
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).
Phillip Jackson
Contact: http://rampantcodecraft.blogspot.com/
After leaving Mechanical Engineering at LSU for a degree in Computer Science at Southeastern Louisiana University, Phillip is an aspiring software craftsman taking the scientific approach to development. Software development is both his profession and his hobby. He is currently a developer with Antares Technology Solutions Inc.
Kevin Boles
Twitter: - @TheSQLGuru
LinkedIn: Kevin Boles
Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.
William Assaf
Twitter: - william_a_dba
LinkedIn: William Assaf
Contact: http://www.sqltact.com
William Assaf, Data Platform MVP, is a principal consultant in Baton Rouge, LA. Initially a .NET developer, and later into database administration and architecture, William currently works with clients on SQL Server and Azure SQL platform optimization, management, disaster recovery and high availability, and leads a crack multi-city team of consulting SQL DBA’s. William has written for Microsoft SQL certification exams since 2011 and was the lead author of the 2017 and 2019 editions of “SQL Server Administration Inside Out” by Microsoft Press. William is a member of the Baton Rouge User Groups board, a regional mentor for PASS, and past lead of the annual SQLSaturday Baton Rouge Planning Committee, having run one of the largest SQLSaturdays.
Sponsors
The following is a list of sponsors that helped fund the event: