Event Location:
Jefferson State Community College
4600 Valleydale Road
Birmingham, Alabama
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,
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,
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,
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,
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,
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,
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,
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,
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,
Abstract:
Discussion on various forms of SQL Injection attacks and some guidelines on how to avoid them.
Speaker(s): Kevin Boles,
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,
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,
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,
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,
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,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
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 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.
LinkedIn: http://www.linkedin.com/pub/dean-richards/6/167/a90
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.
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.
LinkedIn: https://www.linkedin.com/in/stuartainsworth
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.
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!
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
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.
LinkedIn: http://www.linkedin.com/in/thesqlguru
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.
LinkedIn: http://www.linkedin.com/in/arcanecode
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.
LinkedIn: http://www.linkedin.com/in/thesqlguru
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.
LinkedIn: http://www.linkedin.com/in/thesqlguru
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 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.
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.
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.
The following is a list of sponsors that helped fund the event.