www.sqlpass.org    Professional Association for SQL Server
 Meeting Archive

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.
 Sponsors

  

sql_micro_sm.gif