SQLSaturday #7 - Birmingham 2009
Event Date: 05/30/2009 00:00:00
Event Location:
- Jefferson State Community College
- 4600 Valleydale Road
- Birmingham, Alabama
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: BI for a Tough Economy, Data Mining
Abstract: Best Buy does it. American Express does it. Netflix does it. Microsoft is moving data mining from the unique to the routine. SQL Server Analysis Services 2008 and 2005 versions include a robust set of data mining algorithms and tools with which to harvest new insights into YOUR data. Make that marginal sale, discover a murky cost pattern, and find your truly profitable circumstances. Attendees will learn how to use two of the most applicable data mining algorithms included in the SQL Server products. Using the data mining model viewers, attendees will learn how to explore their model results. Through demonstration and lecture, the use of the Profit Chart and Lift Chart attendees will learn how to evaluate the effectiveness of
Speaker(s):
- Derek Comingore
Track and Room: Business Intelligence - N/A
Title: SQL Server Preproduction Tasks
Abstract: This session will cover the tasks you need to perform before you hand over a new SQL Server to production in order to keep the server running smoothly. After this session, you should be able to create a script that best suits your organization in order to make moving a server into production a quick and easy process. While the session is geared towards new systems, many of these preproduction considerations apply to existing SQL Servers as well.
Speaker(s):
- Ken Simmons
Track and Room: Database Administration - N/A
Title: Revitalizing a neglected SQL Server
Abstract: This session will focus on how a SQL Server installation becomes neglected over time, how to identify neglected components, and how to revitalize the neglected installation. In many cases a client may report specific performance issues or errors, but after investigation, it becomes obvious that the underlying issue is more widespread and results from lack of maintenance or planning. Learn how to survey a SQL installation for problems, and how to correct them.
Speaker(s):
- Tim Roper
Track and Room: Database Administration - N/A
Title: Tuna Helper- A Proven Process for Tuning SQL
Abstract: Many DBAs and Developers are faced with tuning poorly performing SQL statements. However, many tuning projects fail because the process being used is inefficient. This presentation will walk through a process Confio Software uses with great success and will include topics such as: SQL diagramming, wait time data, indexing strategies, column selectivity and several more that will help the you succeed on future tuning projects.
Speaker(s):
- Dean Richards
Track and Room: SQL Development - N/A
Title: Using Multi-dimensional Data in SSAS in ASP.NET
Abstract: This sessions will demonstrate several methods for querying multi-dimensional data and rendering the results in two-dimensional data controls. We will cover using both ADOMD.NET and SQL Server stored procedures to retrieve data from SQL Server Analysis Services multi-dimensional cubes.
Speaker(s):
- Terry Webster
Track and Room: Business Intelligence - N/A
Title: ASP.NET Databinding 101
Abstract: This session will demonstrate how easy it is to quickly display your data on a web page with a minimum amount of code. We will cover displaying, editing, deleting and inserting data.
Speaker(s):
- Terry Webster
Track and Room: SQL Development - N/A
Title: Disk Partition Alignment/Care and Feeding TempDB
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: Database Administration - N/A
Title: Confessions of a Data Integrator
Abstract: Most database professionals are charged with managing, extracting, and integrating data from sources which were not designed by themselves. This session focuses on methods of dealing with “somebody else’s” design choices, including a focus on dynamic SQL, datetime concerns, and data abstraction. This should be an interactive session, so feel free to bring your horror stories as well as your ideas for success!
Speaker(s):
- Stuart Ainsworth
Track and Room: SQL Development - N/A
Title: Introduction to SQL Server Statistics
Abstract: This beginner to intermediate level session will introduce you to statistics, including how to create, manage, troubleshoot, and more! Statistics are a key part of getting solid and repeatable performance and is easily just as important as having indexes. Whether you’re a DBA or trying to get by without one, this session will give you the information you need to know.
Speaker(s):
- Andy Warren
Track and Room: Database Administration - N/A
Title: SQL Injection
Abstract: Discussion on various forms of SQL Injection attacks and some guidelines on how to avoid them.
Speaker(s):
- Kevin Boles
Track and Room: SQL Development - N/A
Title: RESTful Data
Abstract: REST is an architectural style that allows for a layered, scalable, and cacheable enterprise information system. With ADO.NET Data Services, a database can be surfaced to a service as a REST-style resource collection that is addressable with natural URIs and can be interacted with using the usual HTTP verbs: GET, POST, PUT, and DELETE.
This session will describe RESTful Data, the benefits it conveys, and its uses. Then we will set up a data service using an existing database that developers would then access rather than accessing the database directly.
Speaker(s):
- Chris Eargle
Track and Room: SQL Development - N/A
Title: Getting the warm “Fuzzies” with SSIS
Abstract: This session is an overview of the Fuzzy Grouping and Fuzzy Lookup transformations provided with SQL Server 2008 Enterprise Edition. We will explore how to use these tools to simplify complicated data quality issues and help standardize data input for BI systems.
Speaker(s):
- Brad Marshall
Track and Room: Business Intelligence - N/A
Title: Data Mining ASP.Net Controls Library
Abstract: Intent of this session is to demonstrate use of Data Mining Web Controls Library with web applications. Data Mining Web Controls Library is a library intended to extend the data mining user experience in Microsoft SQL Server Analysis Services to the Web. This library provides a lightweight version of the data mining model viewers. Using Data Mining Web Controls, you can browse complex mining models from any computer that has Microsoft Internet Explorer installed.
Speaker(s):
- Tejas Patel
Track and Room: Business Intelligence - N/A
Title: Introduction to Data Warehousing with SQL Server
Abstract: Business Intelligence is one of the hot job skills for 2009. In this concepts talk you will learn the concepts behind building and designing data warehouses, and cut through the buzz words so you will walk away with a clear understanding of what words like dimensions, facts, and measures mean. You’ll also get a peak at the tools available in SQL Server 2008.
Speaker(s):
- Robert Cain
Track and Room: Business Intelligence - N/A
Title: SANs and SQL Server
Abstract: Lets get down and dirty on some fundamentals of how SANs work and how we can best utilize them to improve SQL Server’s IO performance and reliability.
Speaker(s):
- Kevin Boles
Track and Room: Database Administration - 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.
Ken Simmons
Contact: http://cybersql.blogspot.com
Ken Simmons is a database administrator/developer specializing in SQL Server and .NET. He is the Author of Pro SQL Server 2008 Administration (Apress, 2009) and Pro SQL Server 2008 Mirroring (Apress, 2009). He has been working in the IT industry since 2000 and currently holds certifications for MCP, MCAD, MCSD, MCDBA, and MCTS for SQL 2005.
Tim Roper
Tim Roper is a consultant for CTS Inc. He holds MCTS certifications in SQL Server 2005, Biztalk Server 2006 and Business Intelligence. He currently provides IT outsourcing support for clients in the SMB space.
Dean Richards
LinkedIn: Dean Richards
Dean Richards is a Senior DBA for DBMS Insights and has helped hundreds of companies solve database and virtualization performance issues. Dean has over 20 years of experience in both development and database administration and has focused his entire career on performance tuning of Oracle and SQL Server environments. Most recently Dean has focused on the trend to virtualize and move databases to the cloud.
Terry Webster
Contact: http://www.webbasics.net
Terry is a Senior Systems Architect for TekSouth Corporation in Birmingham, Alabama and owner of Web Basics. He has over 20 years experience in software engineering and design. Terry focuses on Microsoft Technologies and specializes in ASP.NET, VB.NET, VSTO, OBA, Business Intelligence, Sharepoint and other custom solutions.
Stuart Ainsworth
Twitter: - @codegumbo
LinkedIn: Stuart Ainsworth
Contact: http://codegumbo.com
Stuart Ainsworth (MA, MEd) manages a team of Service Reliability Engineers for the Gladiator Enterprise Information Security Services section of Profitstars, a division of Jack Henry and Associates. He’s a former DBA, developer, consultant, and public speaking professor. He’s one of the chapter leaders for AtlantaMDF, and a long-time organizer of SQLSaturday’s. He tweets infrequently (@codegumbo) and blogs even less often at http://codegumbo.com.
Chris Eargle
Contact: http://www.kodefuguru.com
Chris Eargle is a Telerik Developer Evangelist, INETA Director, and Microsoft Most Valuable Professional – C# from Columbia, SC, USA. He has over a decade of experience designing and developing enterprise applications, and he runs the local .NET User Group: the Columbia Enterprise Developers Guild. He is a frequent guest of conferences and community events promoting best practices and new technologies. His blog, kodefuguru.com, features content to guide you in becoming a .NET Ninja!
Derek Comingore
Contact: https://mvp.support.microsoft.com/profile/Derek.Comingore
Derek Comingore is a Senior Architect with ComFrame Software, a SQL Server MVP, a certified professional in several Microsoft technologies including SQL Server BI, a speaker at several local national SQL Server user groups, and is a published author on SQL Server topics. Derek has been using SQL Server since 1999 as a student in relational database classes at the University of North Dakota with version 7.0. Derek focuses on building delivering enterprise-class data warehousing and business i
Terry Webster
Contact: http://www.webbasics.net
Terry is a Senior Systems Architect for TekSouth Corporation in Birmingham, Alabama and owner of Web Basics. He has over 20 years experience in software engineering and design. Terry focuses on Microsoft Technologies and specializes in ASP.NET, VB.NET, VSTO, OBA, Business Intelligence, Sharepoint and other custom solutions.
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.
Robert Cain
Twitter: - https://twitter.com/arcanecode
LinkedIn: Robert Cain
Contact: http://arcanecode.com
Robert C. Cain (http://arcanecode.com) is a Microsoft MVP, MCTS Certified in BI, and is the owner of Arcane Training and Consulting, LLC. He is also a course author for Plurasight, author for Red Gate’s SImple Talk website, and co-author of 4 books. A popular speaker, Robert has presented at events such as the SQL PASS Summit, TechEd, CodeStock, and numerous SQLSaturdays. Robert has over 25 years experience in the IT industry, working in a variety of fields ranging from manufacturing to telecommunications to nuclear power.
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.
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.
Brad Marshall
Brad Marshall is a veteran IT professional with 18 years experience in data management and data warehousing solutions. Brad has held several Microsoft certifications through the years and is currently the Director of Commercial Products and Services at Teksouth Corporation, a high end data warehouse and BI consulting company specializing in BI solutions on the Microsoft platform.
Tejas Patel
Contact: http://intenseanalytics.com/default.aspx
Tejas Patel is a Business Intelligence Architect with EyeWonder, LLC. He has 8+ years of experience working in Business Intelligence field. He is a frequent presenter on local and regional technical conferences and events. He has designed and developed enterprise level Business Intelligence Solutions for many fortune 500 companies.
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: