|
Steel City SQL
The Birmingham Chapter of PASS
|
|
|
Topic:
|
How to Use SSRS Lookups to Create an Integrated Report
|
|
Date:
|
Tuesday, April 17, 2012 6:00pm
|
|
Speaker:
|
James Aden
|
|
Bio:
|
James has worked with CTS for the past 3 years doing IT consulting work with clients in a variety of industries. James works regularly with SQL Server, with an emphasis on reporting services. |
|
Location:
|
New Horizons Computer Learning Center
|
|
Overview:
|
In this presentaion, James will show how to use the Lookup, LookupSet, and MultiLookup functions provided in SSRS to build an integrated report from separate, related data sources. |
| Sponsor: |
CTS
|
|
Topic:
|
SQL Server 2012 T-SQL
|
|
Date:
|
Tuesday, March 20, 2012 6:00pm
|
|
Speaker:
|
Kathi Kellenberger
|
|
Bio:
|
Kathi is a Sr. Consultant with Pragmatic Works. She loves to write and speak on SQL Server topics, having written over two dozen articles and presented at many SQL Server events. Kathi is author of “Beginning T-SQL 2008” and co-author of “Professional SQL Server 2005 Integration Services” and “Beginning T-SQL 2012.”. |
|
Location:
|
New Horizons Computer Learning Center
|
|
Overview:
|
There is a lot to love about SQL Server 2012: AlwaysOn, ColumnStore Index and so much more. Have you heard about all the new T-SQL features? Attend this meeting to learn all about the many new T-SQL features available in 2012. |
| Sponsor: |
SQL Saturday #112
|
|
Topic:
|
Fundamentals of Physical Join Operators
|
|
Date:
|
Tuesday, February 21, 2012 6:00pm
|
|
Speaker:
|
Kevin Boles
|
|
Bio:
|
Kevin is a SQL Server expert, working exclusively with the product since version 6.5. With over fifteen years of database experience, he holds many SQL Server related certifications and is also an MCT and MVP. Kevin teaches occassionally and has been a very successful independent consultant for almost ten years. He is also a Mentor with SolidQ, a top-tier global SQL Server consulting firm. His passion is the relational engine, especially scalability, performance analysis and tuning. |
|
Location:
|
New Horizons Computer Learning Center
|
|
Overview:
|
This is a wonderful session for those that don't yet grok the three types of joins available to the SQL Server engine or the scenarios for which each join type is optimal. All will be explained here with some very slick visual demonstrations of internal data flow as well as TSQL code samples. Getting more advanced we will also cover how bad performance can get when suboptimal joins are used and some things you might be able to do about that. |
| Sponsor: |
SQL Saturday #112
|
|
Topic:
|
Common T-SQL Programming Mistakes
|
|
Date:
|
Tuesday, March 15, 2011 6:00pm
|
|
Speaker:
|
Kevin Boles
|
|
Bio:
|
Kevin is a SQL Server expert, working exclusively with the product since version 6.5. With over fifteen years of database experience, he holds virtually every SQL Server related certification including MCT and MVP. Kevin teaches occassionally and has been a very successful independent consultant for the past ten years. He is also a Mentor with Solid Quality Mentors, a top-tier global SQL Server consulting firm. His passion is the relational engine, especially performance analysis and tuning. |
|
Location:
|
New Horizons Computer Learning Center
|
|
Overview:
|
This presenation will examine a variety of oopsies MANY developers fall prey to - some obvious, some fairly subtle and some down right sneaky! Lots of code examples with the bad AND good code presented. |
| Sponsor: |
TEKSystems |
|
Topic:
|
What I Learned at the PASS Summit 2010
|
|
Date:
|
Tuesday, November 16, 2010 6:00pm
|
|
Speaker:
|
Tracy Hamlin, Morgan Smith, John Baldwin and Rober Sanderson
|
|
Bio:
|
The Execeptional DBA and others. |
|
Location:
|
New Horizons Computer Learning Center
|
|
Overview:
|
All the Steel City SQL membes that made it to this years PASS Summit will bring you a little snippet of some of the things learned including SQL Server Denali, Powershell, Performance Tuning and many other topics. Plus there will be lots of swag to hand out. |
| Sponsor: |
PASS |
|
Topic:
|
Leveraging Visual Studio 2010 Database Development Tools
|
|
Date:
|
Tuesday, October 19, 2010 6:00pm
|
|
Speaker:
|
Nat Thompson
|
|
Bio:
|
Nat Thompson has over thirteen years experience in the Information Technology field. He holds certifications in Information Systems Security (CISSP) and Project Management (PMP). Over the course of his career he has worked in software development, database development and software development management. Currently his focus is on leveraging development tools to improve the efficiency and quality of the software development life cycle. |
|
Location:
|
New Horizons Computer Learning Center
|
|
Overview:
|
Overview of the new Database Project features of Visual Studio 2010. Walkthrough of how to use these tools to bring database development more in line with other software development lifecycle practices. |
| Sponsor: |
PASS |
|
Topic:
|
Tips and Tricks for Writting Better SQL Queries
|
|
Date:
|
Tuesday, July 20, 2010 6:00pm
|
|
Speaker:
|
Joe Webb
|
|
Bio:
|
Joe Webb has over 17 years of industry experience and has consulted extensively with companies in the areas of business process analysis and improvements, database design and architecture, and technical training. He is a six-time recipient of the Microsoft SQL Server MVP award and is the author or coauthor of three books, including Microsoft SQL Server Deep Dives. Joe regularly speaks at conferences in North America and Europe and has served on several Boards. |
|
Location:
|
New Horizons Computer Learning Center
|
|
Overview:
|
Transact-SQL is not a very difficult language to learn. As long as the syntax is correct, it can be quite forgiving. However to truly get the best performance from your SQL Server, careful consideration should be given to the structure and logic of the queries. In this session, we’ll discuss some Transact-SQL tips and tricks that can be employed to help you write better queries, allowing your server to perform better. |
| Sponsor: |
Doug Wilhelm of Mortgage America |
|
Topic:
|
Disk Partition Management & Care and Feeding TempDB
|
|
Date:
|
Tuesday, May 18, 2010 6:00pm
|
|
Speakers:
|
Kevin Boles
|
|
Bio:
|
Kevin is a SQL Server expert, working exclusively with the product since version 6.5. With over fifteen years of database experience, he holds virtually every SQL Server related certification including MCT and MVP. Kevin teaches occassionally and has been a very successful independent consultant for the past ten years. He is also a Mentor with Solid Quality Mentors, a top-tier global SQL Server consulting firm. His passion is the relational engine, especially performance analysis and tuning. |
|
Overview:
|
Kevin be reviewing a hodge-podge of goodies related to tempdb configuration and monitoring and IO configuration and optimization. Every database server out there should be doing these things right to get the most out of their hardware!
|
|
Topic:
|
Advanced String Manipulation Using CLR in SQL Server 2005
|
|
Date:
|
Tuesday, April 20, 2010 6:00pm
|
|
Speakers:
|
Terry Webster
|
|
Bio:
|
Terry Webster is a Senior Systems Architect for Teksouth Corporation and focuses in commercial software development. Terry is heavily involved with SharePoint, ASP.NET and SQL Server development technologies. Prior to Teksouth, Terry was the CTO for Highmark Technologies for three years and Manager of Web Development for EBSCO Industries for more than 10 years. |
|
Overview:
|
SQLCLR Tips and Tricks for Advanced String Manipulation – Terry will demonstrate several different approaches to handling advanced string manipulation via the SQLCLR in order to optimize performance and actually get around some limitations of SQL Server.
|
|
Topic:
|
Hierarchies in SQL Server
|
|
Date:
|
Tuesday, March 16, 2010 6:00pm
|
|
Speakers:
|
Evan Koch
|
|
Bio:
|
Evan Koch has worked with CTS for the past 8 years doing IT consulting work, primarily for clients in the financial services industry. Evan works heavily with both SQL Server and BizTalk Server technologies. |
|
Overview:
|
In this session, Evan will present alternative approaches to representing hierarchical data within a SQL Server database. The first will be to represent trees as nested sets as found in Joe Celko’s SQL For Smarties book, and the second approach will use the hierarchyID data type in SQL Server 2008.
|
|
|
|
The Professional Association for SQL Server (PASS) is an independent, not-for-profit association, dedicated to supporting, educating, and promoting the Microsoft SQL Server community. From local user groups and special interest groups (SIGs) to webcasts and the annual PASS Community Summit � the largest gathering of SQL Server professionals in the world � PASS enables knowledge sharing, in-depth learning, access to the Microsoft SQL Server team, and the ability to influence the direction of SQL Server technologies.
PASS was founded in 1999 by Microsoft and CA and continues to enjoy executive level endorsement from both organizations. As the number one user community for Microsoft SQL Server, Microsoft looks to the PASS community for valued feedback, input, and inspiration. PASS Mission Empower the global Microsoft SQL Server community to connect, share, learn and be inspired through networking, knowledge sharing, peer-based learning, and the ability to influence the direction of Microsoft SQL Server products and services.
|
|