|
Topic:
|
Extend Your Knowledge with Extended Events!
|
|
Date:
|
September 17, 2013 6:00pm
|
|
Speaker:
|
Janis Griffin
|
|
Bio:
|
Janis Griffin has over 25 years of DBA experience including design, development and implementation of many critical database applications. Before coming to Confio over 6 years ago, Janis held DBA positions working with both real-time network routing databases and OLTP business to business applications. As a Principal Architect and Senior Manager, Janis has mentored many other DBAs on best practices in database performance tuning. |
|
Location:
|
New Horizons Computer Learning Center
|
|
Overview:
|
SQL Server Extended Events can be used to gather a wide range of performance information, and in troubleshooting in SQL Server. Extended Events use less system resources and provide better information than SQL Profiler and they allow for correlation of SQL Server event data along side of OS or Application event data. This presentation will explore what Extended Events are, how to set them up and use them in several case studies. |
| Sponsor: |
Confio Software
|
| Next Meeting: |
November19, 2013 - Robert Cain
|
|
Topic:
|
Managing the SQL Server SSIS Catalog
|
|
Date:
|
July 16, 2013 6:00pm
|
|
Speaker:
|
Sven Aelterman
|
|
Bio:
|
Sven is a lecturer in Information Systems at Troy University in Troy, Alabama. He teaches undergraduate courses in data warehousing and network infrastructure and security. He is also the technology specialist for the Sorrell College of Business and performs a variety of technology roles with a global scope. He continues consulting work through Adduxis, where he assists customers with software development projects using the Microsoft .NET Framework. Co-author of The Art of SQL Server FILESTREAM. |
|
Location:
|
New Horizons Computer Learning Center
|
|
Overview:
|
In SQL Server 2012, the new project deployment model also provides benefits for managing and monitoring your SSIS solutions. This session delves into the SSISDB, the database where your packages and their execution details and results are stored. You’ll learn about the schema of the SSISDB and how to use the provided stored procedures and views to manage your SSIS catalog. |
| Sponsor: |
TEKSouth
|
| |
|
|
Topic:
|
Indexing Deep Dive
|
|
Date:
|
June 18, 2013 6:00pm
|
|
Speaker:
|
Kevin Boles
|
|
Bio:
|
Kevin is a SQL Server expert, working exclusively with the product since version 6.5. With almost 20 years of database experience, he holds many SQL Server related certifications and is also an MCT and was a SQL Server MVP from 2007 to 2012. Kevin teaches occasionally and has been a very successful independent consultant for almost 15 years. His passion is the relational engine, especially scalability, performance analysis and tuning. |
|
Location:
|
New Horizons Computer Learning Center
|
|
Overview:
|
Another in TheSQLGuru's very popular "Deep Dive" series, this time covering indexing. You will learn about the internal structures of heaps, clustered indexes and nonclustered indexes. We will examine included columns and covering indexes, filtered indexes, indexed views, indexing DMVs and finding the right indexes. There are some incredibly helpful graphics as well as some nice samples to help you transition theory to practice. |
| Sponsor: |
TEK Systems
|
|
Topic:
|
SQL Server Database Development Using SQL Server 2012 Data Tools
|
|
Date:
|
Tuesday, March19, 2013 6:00pm
|
|
Speaker:
|
Robert Cain
|
|
Bio:
|
In addition to being on the Steel City SQL Board, Robert (http://arcanecode.com) is a Microsoft MVP SQL Server, MCTS Certified in BI, and works as a Senior Consultant for Pragmatic Works. He is also a technical contributor to Plurasight Training, co-author of Volumes 1 and 2 of "SQL Server MVP Deep Dives", as well as the upcoming "Professional SQL Server 2012 Administration". A popular speaker, Robert has presented at events such as TechEd, SQL Rally, and numerous SQL Saturdays. |
|
Location:
|
New Horizons Computer Learning Center
|
|
Overview:
|
The former Visual Studio Database Projects have now been integrated into the all new SQL Server Data Tools (SSDT). In this session we'll look at the tools included with SSDT such as the all new localdb, database snapshots, and the new way to publish your database. You'll also learn how to reverse engineer existing databases into your project, as well as how to do safe refactoring. Finally we'll not the limitations around the new SSDT and ways you can work around them. We'll also highlight differences between the new SSDT and the former Visual Studio Database Projects. |
| Sponsor: |
Atlanta MDF
|
| Next Meeting: |
April 16,2013 TBD
|
|
Topic:
|
An Overview of PowerPivot for Excel
|
|
Date:
|
Tuesday, February 19, 2013 6:00pm
|
|
Speaker:
|
William Pearson III
|
|
Bio:
|
Bill created Island Technologies® Inc. in 1997, and has developed a large and diverse customer base since. Bill's background as a CPA, Internal Auditor, Management Accountant, SQL Server MVP (BI) and Analysis Services Maestro enable him to provide value to clients as a liaison between Accounting / Finance and Information Services. Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies, and focuses his practice upon the integrated Microsoft business intelligence solution. Bill is a member of the Boulder BI Brain Trust. |
|
Location:
|
New Horizons Computer Learning Center
|
|
Overview:
|
In this presentation, Microsoft BI Architect and SQL Server MVP Bill Pearson explores “self-service BI” as a concept. He then provides a walkthrough of the primary features of PowerPivot, focusing on how we can exploit its capabilities to offer the benefits of BI to decision makers and analysts throughout our organizations. “There’s no service like self-service …” This session applies equally to SQL Server and Analysis Services 2008, 2008R2 and 2012 data sources. |
| Sponsor: |
Atlanta MDF
|
|
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.
|
|
|
|
|
Steel City SQL
The Birmingham Chapter of PASS
|
|
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.
|
|