Meeting Archive

 

When: Thursday, February 12th, 2015 , 6:00PM - 8:30PM
Where:

Microsoft Polaris Office

8800 Lyra Drive
4th Floor
Columbus, OH

6:00 - 6:30 - Networking & social time
6:30 - 6:45 - Welcome and announcements
6:45 - 7:45 - Presentation
7:45 - 8:30 - Door prizes and Question & Answer session

Food and drinks will be provided.

Topic

 
DBA Basics: The Four Tasks every DBA should know.

Abstract

Performance tuning, index design, etc... these are great skills to have, but

there are four basic tasks that every DBA should know how to do backwards and

forwards without even thinking about it. They are, in this order: Restore,

Backup, Index Maintenance, and Consistency Checking. After attending this

session, you will be able to restore a database in a few different ways, take

the right backups in order to restore that database, know how and when to

maintain the indexes and statistics, and check for database corruption.

Presenter

David Maxwell has over 10 years of experience with SQL Server, with a keen interest in performance tuning, monitoring, and troubleshooting. He has had experience in environments as diverse as health care institutions, auto manufacturers, and insurance companies. His occasional writings can be found at http://dmmaxwell.wordpress.com/

 

When: Thursday, November 8, 6:00PM - 8:30PM
Where:
Improving Enterprises 4449 Easton Way, Suite 100 Columbus, OH 43219

6:00 - 6:30 - Networking & social time
6:30 - 6:45 - Welcome and announcements
6:45 - 7:45 - Presentation
7:45 - 8:30 - Door prizes and Question & Answer session

Food and drinks will be provided.

Topic

 The Microsoft Business Intelligence (BI) Consumer

Abstract

Microsoft (MS) has a lot of great end-user BI applications and platforms like SharePoint, PowerPivot 2012, Excel Services, PerformancePoint, and PowerView 2012 as shown on Microsoft’s website at http://www.microsoft.com/en-us/bi/products.aspx.  Come to this session to see Microsoft’s capabilities, what tools should be used for which audience, and to learn how you can create these types of visualizations yourself for your BI users.

Presenter

Andrew Holowaty is a national BI consultant working in seven states within three industries in the past two years.  He has his MBA, PMP, MCDBA, MCSD, and MCAD with 20 years of experience.  He lives in Dublin, Ohio with his wife and four children.  His oldest child, who is 13 years old wants to be in the NFL.

When: Thursday, October 11th, 6:00PM - 8:30PM

Where: Goodwill Columbus, 1331 Edgehill Rd, Columbus, Ohio 43212

6:00 - 6:30 - Networking & social time
6:30 - 6:45 - Welcome and announcements
6:45 - 7:45 - Presentation
7:45 - 8:30 - Door prizes and Question & Answer session

For those who can't attend in person, Live Meeting will be available here.

Topic

Transaction and Balance Facts: Identical Cousins

Abstract

Ralph Kimball wrote extensively about the difference between transaction facts and balance facts, and rightly so, because transactional facts are additive in time and balance facts are not. But experience with these two seemingly disparate fact types reveals that they are actually identical cousins! This presentation will use a common personal concept -- the checking account -- to show that these facts are closely related and how to think appropriately about their relationship conceptually and with examples using SQL Server.

 

Presenter

Dave Rodabaugh

Located in Columbus, Ohio, Dave Rodabaugh has over a decade of experience doing one thing: data warehousing and business intelligence using the Microsoft suite of products. His background as an engineer and exclusive focus on business intelligence has helped clients be successful in both initial-effort and rescued BI projects. He co-owns Atlas Analytics, through which he consults to clients in Ohio and beyond.


 

When: Thursday, September 13th, 6:00PM - 8:30PM

Where: Goodwill Columbus, 1331 Edgehill Rd, Columbus, Ohio 43212

6:00 - 6:30 - Networking & social time
6:30 - 6:45 - Welcome and announcements
6:45 - 7:45 - Presentation
7:45 - 8:30 - Door prizes and Question & Answer session

For those who can't attend in person, Live Meeting will be available here.

Topic

Turning Clues Into Facts - Investigating Beyond Query Basics

Abstract

This session will tackle a challenging BI fact table source query. You will see lots of code using PIVOT, UNPIVOT, and Common Table Expressions to build a fact table from transactions whose variable column descriptions are buried in another table.

 

Presenter

Chris Umbaugh

Located near Toledo, Ohio, Chris is a business intelligence/data warehousing contractor specializing in the Microsoft stack with 15 years of experience. He has successfully delivered complete one-man BI solutions and more recently has had the privilege of serving on a larger BI team in Hilliard, Ohio responsible for the design and delivery an enterprise-wide data warehouse. He will sometimes write in third person but promises never to talk that way.


 

When: Thursday, August 9th, 6:00PM - 8:30PM

Where: Goodwill Columbus, 1331 Edgehill Rd, Columbus, Ohio 43212

6:00 - 6:30 - Networking & social time
6:30 - 6:45 - Welcome and announcements
6:45 - 7:45 - Presentation
7:45 - 8:30 - Door prizes and Question & Answer session

For those who can't attend in person, Live Meeting will be available here.

Topic

SQL Reporting Services Question and Answer

Abstract

This session will be less presentation and mostly answering any questions you may have about SQL Reporting Services. We will have a half a dozen or so tips and tricks to stimulate discussion, but really we want to take this time to answer questions that can range from how to get started, to design ideas, to using report manager. Now really, sitting round eating free pizza and talking about Reporting Services, it doesn’t get any better than that does it?

 

Presenter

Stuart Johnson

Stuart has designed, built, delivered, and integrated applications for businesses across much of the western hemisphere. For some
time his focus has been on using the MS SQL Server business intelligence tools to bring insight into business processes. Stuart still has
this fear in the back of his mind that Business Intelligence is an oxymoron (Two words that don't go together). He continues to ignore those
fears and works diligently to develop systems and reporting solutions that make all of the problems in an enterprise obvious to everyone.
Boy does that get people scrambling.


 

When: Thursday, July 12, 6:00PM - 8:30PM

Where: Goodwill Columbus, 1331 Edgehill Rd, Columbus, Ohio 43212

6:00 - 6:30 - Networking & social time
6:30 - 6:45 - Welcome and announcements
6:45 - 7:45 - Presentation
7:45 - 8:30 - Door prizes and Question & Answer session

For those who can't attend in person, Live Meeting will be available.

Topic

Database Containment in SQL Server 2012

Abstract

What is it? What are the benefits? What are the drawbacks?.

 

Presenter

Lisa Gardner


When: Thursday, May 10, 6:00PM - 8:30PM

Where: Goodwill Columbus, 1331 Edgehill Rd, Columbus, Ohio 43212

6:00 - 6:30 - Networking & social time
6:30 - 6:45 - Welcome and announcements
6:45 - 7:45 - Presentation
7:45 - 8:30 - Door prizes and Question & Answer session

For those who can't attend in person, Live Meeting will be available.
Audio will be available via LiveMeeting

Food and drinks will be provided.

Topic

SQL Installations, When Point & Click Ain’t Your Shtick

Abstract

If you are faced with multiple SQL server installations or just want a reliable way to document what has transpired, Clark Hahn will be presenting on text based procedures that can help you have both a standardized method for server setup and delivery and better documentation. By using combinations of the Configuration file and T-SQL workable solutions can be created for the small IT Shop on a budget or the ’Accidental DBA’. This topic is intended for junior and accidental DBA, or anyone who just hasn’t had the time to explore beyond ‘Point & Click’.

 

Presenter

Clark Hahn is a ‘Database Specialist’ employed with the State of Ohio, Office of Budget and Management. Having 20+ years of database experience starting on a mainframe platform. Two years ago Clark found himself jumping into a new database platform and a group of peers who had never heard of a green screen.  He also found himself being audited, for best practices, and needed a way to quickly get these practices and policies implemented on multiple servers. This presentation will cover many of his findings.


 

When: Thursday, April 12, 6:00PM - 8:30PM

Where: Goodwill Columbus, 1331 Edgehill Rd, Columbus, Ohio 43212

6:00 - 6:30 - Networking & social time
6:30 - 6:45 - Welcome and announcements
6:45 - 7:45 - Presentation
7:45 - 8:30 - Door prizes and Question & Answer session

For those who can't attend in person, Live Meeting will be available <span title="blocked::https://www.livemeeting.com/cc/usergroups/join?id=JQZ4P9&role=attend&pw=M}wx7/+'r blocked::https://www.livemeeting.com/cc/usergroups/join?id=SNFMN8&role=attend&pw=n%K$7T6fn">here.
Audio will be available via LiveMeeting

Food and drinks will be provided.

Topic

Upgrade Road Map: Let's Delve into SQL Server 2012

Abstract

We will review the upgrade process to SQL Server 2012. An upgrade is 75% project planning and 25% execution. Everyone knows that, right? Actually, no. A checklist of considerations a company would likely encounter coming from SQL Server 2005/2008 or R2. The pros and cons of in place upgrade vs. the build out new approach. There will be many real world lessons learned sprinkled in as the presenter has led many upgrades and migrations of SQL Server. Key takeaways include: when to upgrade in place compared to build new, usage of and how to gauge the usefulness of Upgrade Advisor, deprecated features and how to test for them.

Presenter

Craig Purnell

Career Database Professional
Twitter: @CraigPurnell

LinkedIn: http://www.linkedin.com/in/craigpurnell


 

When: Thursday, March 8, 6:00PM - 8:30PM

Where: Goodwill Columbus, 1331 Edgehill Rd, Columbus, Ohio 43212

6:00 - 6:30 - Networking & social time
6:30 - 6:45 - Welcome and announcements
6:45 - 7:45 - Presentation
7:45 - 8:30 - Door prizes and Question & Answer session

Topic

Blue-collar SQL: How to Frame a Window

Abstract

"A cross-platform—Microsoft SQL Server, Oracle Database, and MySQL—perspective on SQL's windowing functions and analytical OVER() clause and some of their more advanced capabilities or lack thereof."

Presenter

Kevin Cross

Kevin Cross has been in IT since 1999 as an administrator, an analyst, an architect, a developer, and, most recently, a manager. No matter his role, he always seems to end up near a database of either the Microsoft, Oracle, MySQL, or IBM flavor; therefore, he is a bit addicted to SQL programming. As he says online, "[I was] Born in Jamaica, W.I., raised in the Bronx,New York, U.S., and developed in code..."

Sponsor

This meeting was sponsored by Experts-Exchange www.experts-exchange.com

 


 

When: Thursday, February 9th, 6:00PM - 8:30PM
Where: 
 Goodwill Columbus, 1331 Edgehill Rd, Columbus, Ohio 43212

6:00 - 6:30 - Networking & social time
6:30 - 6:45 - Welcome and announcements
6:45 - 7:45 - Presentation
7:45 - 8:30 - Door prizes and Question & Answer session

For those who can't attend in person, Live Meeting will be available here.
Audio will be available via LiveMeeting

Food and drinks will be provided.

Topic

Think Multidimensionally and Write Better MDX

Abstract

Writing MDX can be daunting, especially for technologists experienced in writing queries against relational databases.  This presentation will demonstrate a methodical thought pattern for "seeing" the multidimensional lattice in SQL Server Analysis Services, culminating in several statements to encapsulate these thoughts.  Thereafter, some very simple MDX will be written to demonstrate how to use these concepts and statements.

Presenter

Dave Rodabaugh

When not tending to family matters, I work as an independent business intelligence consultant/trainer dealing exclusively with the Microsoft SQL Server suite of products. Principal Consultant and Partner, Atlas Analytics.


When: Thursday, February 9th, 6:00PM - 8:30PM
Where: 
 Goodwill Columbus, 1331 Edgehill Rd, Columbus, Ohio 43212

6:00 - 6:30 - Networking & social time
6:30 - 6:45 - Welcome and announcements
6:45 - 7:45 - Presentation
7:45 - 8:30 - Door prizes and Question & Answer session

For those who can't attend in person, Live Meeting will be available here.
Audio will be available via LiveMeeting

Food and drinks will be provided.

Topic

  Evaluate your daily checklist against 100+ instances of SQL Server while you get a cup of coffee

Abstract

This talk will give you an introduction into monitoring SQL Server using Policy Based Management and Central Management System which is provided out of the box with SQL Server 2008. I will then show you how you can combine these features with the Enterprise Policy Management Framework on codeplex to provide monitoring for your whole SQL Server farm. This topic assumes you know nothing about PBM and CMS and will include lots of examples with only a few PowerPoint slides. 

Presenter

John Sterrett

John Sterrett is a senior database administrator at Remote DBA Experts. John has been active within the SQL Server community, including hosting the first and second SQL Saturday in West Virginia. John also presented a spotlight session at SQL Rally and a lightning talk and chalk-talk at the SQL Server 2010 Member Summit, presented sessions at SQL Saturday’s, and presented to the Pittsburgh SQL Server User Group. John is one of the co-founders for the WVPASS User Group. John is a syndicated blogger at SQLServerPedia and contributes tips at MSSQLTIPS. You can find his blog at www.johnsterrett.com

 


When: Thursday, December 8, 6:00PM - 8:30PM
Where: 
 Goodwill Columbus, 1331 Edgehill Rd, Columbus, Ohio 43212

For those who can't attend in person, Live Meeting will be available here.
Audio will be available via LiveMeeting

Food and drinks will be provided.

Topic
Businesses are hungry for data. How can you satisfy the hunger of your users and your clients?

Abstract

The Open Data protocol (OData) allows you to share information with your users without sharing the underlying structure of your database. Microsoft makes getting started with OData simple with WCF Data Services.

Presenter

David Amaya 

David Amaya, SQL Server MCITP, is a Database and Application Developer who has worked in a variety of industries ranging from social services to online media. Specializing in the Microsoft stack, he seeks to empower business users to work with the data they need without compromising the security, efficiency and integrity of the data.


When: Thursday, November 10, 6:00PM - 8:30PM
Where: 
 Goodwill Columbus, 1331 Edgehill Rd, Columbus, Ohio 43212

6:00 - 6:30 - Networking & social time
6:30 - 6:45 - Welcome and announcements
6:45 - 7:45 - Presentation
7:45 - 8:30 - Door prizes and Question & Answer session

For those who can't attend in person, Live Meeting will be available here.
Audio will be available via LiveMeeting

Food and drinks will be provided.

Topic
Injecting TDD into your ETL with the SQL Server Stack

Abstract

Agile development is really starting to take-off and is becoming more mainstream in application development projects. However, I do not hear much talk of using agile methods like Test Driven Development (TDD) in Extract, Transform, & Load (ETL) projects for data warehousing. To increase development velocity it is important to select and incorporate the right pre-built components so the development effort can focus on the business requirements of ETL and not the repeatable plumbing that should be a constant over development projects. This blog is the first in a series of developing frameworks and patterns (TDD, Error Handling, End-to-End traceability, Performance, Configuration, and Logging) to decrease ETL development times of BI projects and increase quality which translates into more satisfied clients.

Presenter 

Andrew Holowaty 

Andrew Holowaty is Technical Lead Consultant in the MCC BI group and has been working with Microsoft tools and products for over 18 years. He has an MBA with a focus on consulting from The Ohio State University and is certified with a PMP, MCDBA, MCSD, and MCAD. Andrew lives in Dublin, Ohio with his wife and four children.


When: Thursday, October 13th, 6:00 PM - 8:30 PM

Where: New Location This Month - HalcyonIT 5880 Innovation Dr., Dublin, Ohio 43016

6:00 - 6:30 - Networking & social time
6:30 - 6:45 - Welcome and announcements
6:45 - 7:45 - Presentation(s)
7:45 - 8:30 - Door prizes and Question & Answer session


For those who can't attend in Person, Live Meeting will be available here.

Audio will be available via Live Meeting.

Food and drinks will be provided.

Topic - Beauty and Truth - Using MS Reporting Services for Information Design

This presentation will focus on how you can make what is important jump out to your users. Information design takes a combination of art, graphic design, technique, and technical skills. We will cover and demonstrate the concepts of Signal to Noise Ratio, the Stop Light Effect, and the Christmas Tree Effect. Good design is difficult in a very different way than most of what database professionals usually deal with. Come and see some new ideas and techniques to get your reports popping and the information jumping.

Presenter - Stuart Johnson

Stuart is currently a System Designer for a Fortune 20 company. Stuart has over 25 years in designing, developing, and delivering software systems to companies in the United States as well as the United Kingdom. His experience includes dealing with a wide variety of systems. These include real time data collection, business process improvement applications, and business intelligence systems. While experienced with a number of development platforms, his current areas of concentration involve the Microsoft set of development tools and platforms. Specific technology areas of interest include Analysis services, Reporting services, and Integration Services.


When: Thursday, September 8th, 6:00 PM - 8:30 PM

Where: Goodwill Columbus, 1331 Edgehill Rd, Columbus, Ohio 43212

6:00 - 6:30 - Networking & social time
6:30 - 6:45 - Welcome and announcements
6:45 - 7:45 - Presentation(s)
7:45 - 8:30 - Door prizes and Question & Answer session


For those who can't attend in Person, Live Meeting will be available here
.
Audio will be available via Live Meeting

Food and drinks will be provided.

Topic - BI Made Simple

More info to come...

Presenter - Brian Knight  

 

Brian Knight, SQL Server MVP, MCITP, MCSE, MCDBA, is the owner and founder of Pragmatic Works. He is also the co-founder of SQLServerCentral.com, BIDN.com and SQLShare.com. He runs the local SQL Server users group in Jacksonville (JSSUG). Brian is a contributing columnist at several technical magazines and does regular webcasts at SQLShare.com. He is the author of a dozen SQL Server books. Brian has spoken at conferences like PASS, SQL Connections and TechEd and many Code Camps. His blog can be found at http://www.bidn.com.

Pragmatic Works

At Pragmatic Works, our goal and purpose is to democratize technology. Whether that be by starting the Pragmatic Works Foundation to increase access to technology or by developing applications to increase the productivity of developers. All of our employees are focused on making technology easier and more accessible to everyone. 

Pragmatic Works is a privately held technology company headquartered in Jacksonville, FL with a sales offices near Boston, MA and a technology center in Atlanta, GA

 

 


When: Thursday, August 11th, 6:00 PM - 8:30 PM
Where: 
Goodwill Columbus, 1331 Edgehill Rd, Columbus, Ohio 43212

6:00 - 6:30 - Networking & social time
6:30 - 6:45 - Welcome and announcements
6:45 - 7:45 - Presentation(s)
7:45 - 8:30 - Door prizes and Question & Answer session


For those who can't attend in Person, Live Meeting will be available here
.
Audio will be available via Live Meeting

Food and drinks will be provided.

Topic - BI: Fact Table Modeling - Real World Case Study in 'Threshing' Out the Grain of a Fact

This data warehousing case study in fact modeling will demonstrate how to properly discover the grain of a fact table. Together we will prototype the ETL to turn detailed transactional data into a structured and powerful fact table.

Presenter - Chris Umbaugh  [@chrisumbaugh - umbaughbi@gmail.com]

Located near Toledo, Ohio, Chris is a business intelligence/data warehousing contractor specializing in the Microsoft stack with 15 years of experience. He has successfully delivered complete one-man BI solutions and more recently has had the privilege of serving on a larger BI team in Hilliard, Ohio responsible for the design and delivery an enterprise-wide data warehouse. He will sometimes write in third person but promises never to talk that way.  


When: Saturday, July 14th, 6:00 PM - 8:30 PM
Where: 
Goodwill Columbus, 1331 Edgehill Rd, Columbus, Ohio 43212

6:00 - 6:30 - Networking & social time
6:30 - 6:45 - Welcome and announcements
6:45 - 7:45 - Presentation(s)
7:45 - 8:30 - Door prizes and Question & Answer session


For those who can't attend in Person, Live Meeting will be available here
.
Audio will be available via Live Meeting

Food and drinks will be provided.

Topic - Blue-collar SQL: Building and Leveling High-rises

A beginners guide to UNPIVOT and PIVOT introduced in SQL 2005. Includes some helpful tips and tricks for successful transformation of data to aid you to "broaden your horizons."

Presenter - Kevin Cross

I have been in IT since 1999 as an administrator, an analyst, an architect, a developer and, most recently, a manager for Elliott Tool Technologies LTD in Dayton OH. I have been managing and developing in SQL since Microsoft SQL Server 6.5 and have also handled applications running on Oracle, MySQL and IBM Universe. I guess you can call me a SQL addict. Fortunately, Elliott uses an ERP and other systems driven by MS SQL, and so my obsession for SQL can be quenched daily.

 

When: Thursday, May 12th, 6:00PM - 8:30PM
Where:
Goodwill Columbus, 1331 Edgehill Rd, Columbus, Ohio 43212

For those who can't attend in Person, Live Meeting will be available here
.
Topic - Service Broker

Have you heard of Service Broker? Do you know what it is? How about how to use it? This session will answer these questions and more. Service Broker is arguably one of the least known and used features of SQL Server. We'll explore Service Broker and learn what it is and how it works. We'll walk through the setup and configuration along with demonstrating its use. You'll leave this session with a better understanding of Service Broker, its use and implementation, along with ideas of how you can implement it in your own environments.

Presenter - Brian Davis

Brian Davis has over 11 years in the IT field in multiple areas including software development, support, user training, and as a DBA. He has been working with SQL Server since 2003 and has hands on experience with SQL Server 2000/2005/2008/2008R2. He is also an active member in the Ohio North SQL Server User’s Group.

 


 

 When: Thursday, April 14th, 6:00PM - 8:30PM
Where:
Goodwill Columbus, 1331 Edgehill Rd, Columbus, Ohio 43212

For those who can't attend in Person, Live Meeting will be available here
.
Audio will be available via Live Meeting

Food and drinks will be provided.

Topic - Dr. DMV: How to Use Dynamic Management Views to Monitor and Diagnose Performance Issues With High Volume OLTP Workloads

SQL Server 2005 introduced Dynamic Management Views (DMVs) that allow you to see exactly what is happening inside your SQL Server instances and databases with much more detail than ever before. SQL Server 2008 R2 adds even more capability in this area. You can discover your top wait types, most CPU intensive stored procedures, find missing indexes, and identify unused indexes, to name just a few examples. This session (which is applicable to both 2005, 2008 and 2008 R2), presents and explains over thirty DMV queries that you can quickly and easily use to detect and diagnose performance issues in your environment.

Presenter - Glenn Berry

Glenn is a Database Architect at NewsGator Technologies in Denver, Colorado and has been a SQL Server MVP since 2007. Follow him (@GlennAlanBerry) on Twitter or via his blog.


When: Thursday, March 10th, 6:00PM - 8:30PM
Where:
Goodwill Columbus, 1331 Edgehill Rd, Columbus, Ohio 43212

Topic - PowerPivot: BI & Massive Data Analysis for Humans

The paradox of Business Intelligence: it's one of the few tech sectors that actually grows during recessions, and yet, satisfaction levels with BI investments remain on average quite poor. Also, BI remains the domain of specialists, off-limits to most of us. Why do these conditions persist when the funding, and therefore the business need, only continues to grow? In this session I will demonstrate how PowerPivot is opening the world of BI to a broader audience (& range of applications). The only prereqs: curiosity, and fondness for numbers :) I will explain how PowerPivot impacts & benefits you depending on role (analyst, DBA, BI Pro, etc.), show off its capabilities in real-world usage, and field as many q's as you can muster :)
Session Level: Beginner

Presenter - Rob Collie
Rob spent 13 yrs at Microsoft in Redmond WA before relocating to beautiful Cleveland early last year. At MS, he worked primarily on Excel, designing many features of Excel 2003 and 2007. In his final act at MS, Rob joined the PowerPivot team and designed much of the PowerPivot for Excel toolset. Today, Rob is CTO at Pivotstream, the world's leading adopter of PowerPivot. He also runs PowerPivotPro.com & PowerPivotFAQ.com, and consults/trains others on PowerPivot adoption.


 

When: Thursday, January 13th, 6:00PM - 8:30PM
Where: 
Battelle for Kids - 1160 Dublin Rd Suite 500, Columbus, OH 43215

Topic

T-SQL primer

 

Presenter

 

Topic - Better together, using the power of Integration services and delivering the results with Reporting Services, Or How to catch a terrorist.

Presenter - Stuart Johnson

Stuart is currently a System Designer for a Fortune 20 company. Stuart has over 25 years in designing, developing, and delivering software systems to companies in the United States as well as the United Kingdom. His experience includes dealing with a wide variety of systems. These include real time data collection, business process improvement applications, and business intelligence systems. While experienced with a number of development platforms, his current areas of concentration involve the Microsoft set of development tools and platforms. Specific technology areas of interest include Analysis services, Reporting services, and Integration Services.


When: Thursday, February 10th, 6:00PM - 8:30PM
Where: Goodwill Columbus, 1331 Edgehill Rd, Columbus, Ohio 43212

 

Dave Rodabaugh

Principal Consultant and Partner at Atlas Analytics

 

Business intelligence architect, developer, trainer, and manager with with experience in relational multidimensional data modeling with SQL Server, ETL with SSIS, MOLAP with SSAS, and reporting architecture in SSRS. Industry experience is with supply chain, insurance, and pharmaceuticals. Interested in architecting/developing ground-up BI solutions using Microsoft tools, managing BI teams, and providing business-level direction for effective use of BI for internal and customer-facing applications.


 

 

When: Thursday, December 9th, 6:00PM - 8:30PM
Where: 
Battelle for Kids - 1160 Dublin Rd Suite 500, Columbus, OH 43215


Topic

Database Design Fundamentals
  

In this session I will give an overview of how to design a database, including the common normal forms and why they should matter to you if you are creating or modifying SQL Server databases. Data should be easy to work with in SQL Server if the database has been organized as close as possible to the standards of normalization that have proven for many years. Many common T-SQL programming "difficulties" are the result of struggling against the way data should be structured and can be avoided by applying the basic normalization techniques and are obvious things that you find yourself struggling with time and again (i.e. using the SUBSTRING function in a WHERE clause meaning you can't use an index efficiently).

Presenter

Louis Davidson (BlogTwitter) 

Louis has over 15 years as a corporate database developer and architect. Currently he is the Data Architect for the Christian Broadcasting Network and NorthStar Studios in Nashville, Tennessee. Nearly all of Louis' professional experience has been with Microsoft SQL Server from the early days to whatever is the latest version currently in beta.  Louis has been the principal author on four editions of a book on database design, including one for SQL Server 2008. Louis' primary areas of interest are database architecture and coding in T-SQL, with experience designing many databases and writing thousands of stored procedures and triggers through the years.

 


 

When: Thursday, November 11th, 6:00PM - 8:30PM
Where:
Battelle for Kids - 1160 Dublin Rd Suite 500, Columbus, OH 43215

For those who can't attend in Person, Live Meeting will be available here
.
Audio will be available via Live Meeting

Food and drinks will be provided.

Topic

Take Control of Your Databases With Policy Based Management & Resource Governor

A large majority of a modern DBA's workload consists of managing their policies and resources on their system in order to ensure that they are being followed and resources are accessible when needed. SQL Server 2008 provides both Policy Based Management (PBM) and Resource Governor, which allows the DBA to discretely manage system policies and resources in a very structured way. In this session, we will show you how to configure, monitor, and administer these features to help lower your anxiety levels while increasing your system’s availability.

Presenter

Arie Jones (Blog, Twitter)

Arie Jones is a Principal Microsoft Consultant at Perpetual Technologies, Inc in Indianapolis, IN. He specializes in SQL Server and .NET platform solutions as well as some Oracle stuff as well. Basically, he works on high-end cross platform data warehousing stuff as well as managing a team of high specialized consultants running a wide variety of projects.


 

When: Thursday, October 14th, 6:00PM - 8:30PM
Where:
Battelle for Kids - 1160 Dublin Rd Suite 500, Columbus, OH 43215

For those who can't attend in Person, Live Meeting will be available here.

Audio will be available via Live Meeting

Food and drinks will be provided.

Topic

Factors for Successful Business Intelligence

Is your organization trying BI for the first time? Have you tried BI without much to show for it? You're in good company. Gartner says that the majority of BI projects fail. Learn factors for successful business intelligence projects using the Microsoft SQL Server suite of products, including technology selection, architecture, skills and staffing, team structure, development methodology, business analysis, and QA.

Presenter

Dave Rodabaugh

Dave Rodabaugh is an independent business intelligence consultant with 10 years of experience. He specializes in the Microsoft SQL Server suite of products.


 

When: Thursday, September 9th, 6:00PM - 8:30PM
Where: 
Battelle for Kids - 1160 Dublin Rd Suite 500, Columbus, OH 43215

Topic
Come hear Sam Nasr discuss the new features of SQL Server 2008 R2 SSRS. We’ll also have some special R2 prizes to give away!

Microsoft SQL Server 2008 R2 Reporting Services provides a complete, server-based platform designed to support a wide variety of reporting needs enabling organizations to deliver relevant information where needed across the entire enterprise.

1.      New Data Sources

2.      Expression Language Improvements

3.      Layout Control

4.      Data Visualization

5.      Report Builder

6.      SharePoint Integration

Presenter

Sam Nasr

Sam Nasr has been a software developer since 1995, focusing mostly on Microsoft technologies. Having achieved multiple certifications from Microsoft (MCAD, MCTS (MOSS), and MCT), Sam develops, teaches, and tours the country to present various topics in .Net. He is also actively involved with the Cleveland C#/VB.Net User Group, where he has been the group leader since 2003. In addition, he also started the Cleveland WPF Users Group in June 2009, and the Cleveland .Net Study Group in August 2009

 


 

When: Thursday, August 12th, 6:00PM - 8:30PM
Where:
Battelle for Kids - 1160 Dublin Rd Suite 500, Columbus, OH 43215

Topic
Stay Agile, Stay Sane

Agile software development emphasizes continuous depolyment and its methods do not directly include long term planning. DBAs must ensure data integrity and have a long term view for application scale, so Agile methods present challenges. Come learn about successful real-world practices iteratively developed in a high transaction internet service environment over the last five years. We have create a flourishing Agile shop while meeting high requirements for uptime, customer response, and data consistency. In this session we'll cover key habits for success, practices to avoid, how and when to get started, and why Agile development can be a great thing for DBAs. Topics will also include how "Testing in Production" can be a huge benefit.


 Presenter

Kendra Little (twitter, blog)

Kendra Little is a Senior DBA in the online advertising industry who has spent ten years nerding out on SQL Server. Kendra works closely with an Agile development team to deploy frequent incremental changes to scale and improve a busy production environment. She likes tuning production servers, developing tools to automate tasks, building SQL Reports for trending, and secretly enjoys writing troubleshooting guides and documentation. Kendra has a Masters degree in Philosophy and a salt shaker full of certifications, but all the best stuff she's ever learned has come from her smarty-pants colleagues and the SQL Server community. Read her blog at http://littlekendra.com.


 

When: Thursday, June 10th, 6:00PM - 8:30PM
Where:
Battelle for Kids - 1160 Dublin Rd Suite 500, Columbus, OH 43215

Live Meeting available
here.

Topics
Accelerating SQL with Solid State Technology

Solid-state technologies are changing the way that MS SQL users run their databases. DBA’s are achieving significant TCO savings through performance enhancements, reliability improvements, and reduced energy and real estate costs using solid-state technologies.  Solid state is changing the way datacenters look and how MS SQL Servers perform.
 
The Benefits of SQL Azure

This talk will focus on the real world benefits, features, architecture and ease of use of SQL Azure. Learn how your projects can benefit from a hosted data storage and query processing service. See by example how to design your program to use SQL Azure.

 Presenters

Fusion-io - http://www.fusionio.com/

 Aaron Stanley King (blog, twitter)


 When: Thursday, April 8th, 6:00PM - 8:30PM

Where: Battelle for Kids - 1160 Dublin Rd Suite 500, Columbus, OH 43215

Live Meeting available 
here.

Topic
Fundamentals of SQL Server Internals

Abstract

Want to know what makes SQL Server tick?
Ever wonder what SQL Server is doing when you run a query?
Ever wonder which parts of SQL Server are responsible for specific functionality?



Jeremiah Peschka can't promise answers to every question, but he can set you on the path to knowledge about the inner workings of SQL Server.

Presenter
Jeremiah Peschka (blog, twitter)


When: Thursday, March 11th, 6:00PM - 8:30PM
Where:
Battelle for Kids - 1160 Dublin Rd Suite 500, Columbus, OH 43215

Topic
Introduction to Analysis Services: OR How to do everything wrong and Still provide business value.

Abstract

This presentation will introduce Analysis Services using a real life business case and an honest exposition of how to get through the learning curve with SQL Analysis Services.

Along the way we will derive a fairly complete list of worst practices for Analysis Services development. Armed  with the list of worst practices and the insight gained from the live examples, attendees will have a much better idea of how, and how not, to use Analysis Services. They will also probably have a new insight for times they may be able to use Analysis Services that they may not have thought of previously.

Presenter
Stuart Johnson


When: Thursday, February 11th, 6:30PM - 8:30PM
Where:
Battelle for Kids - 1160 Dublin Rd Suite 500, Columbus, OH 43215

Topic
DBA Survivor (or What to Expect When You Are Expecting to Be a DBA)

Abstract

Do you have what it takes to survive as a DBA? Whether you are new to the field or not, Thomas LaRock can help you understand what separates those that are able to survive in their position and those that will struggle getting the job done. Find out what to expect when you are expecting to be a DBA. Attend this session and learn about how you can better communicate with others, how to manage expectations, and how to provide top-notch production support.

Presenter
Thomas LaRock
 - (Blog, Twitter)


 

When: Thursday, January 14th, 6:30PM - 8:30PM
Where: Battelle for Kids - 1160 Dublin Rd Suite 500, Columbus, OH 43215


Topic
Indexes and Other Free Performance Boosts

Abstract

The database is often viewed as a major performance bottleneck. There are a number of quick, easy, painless techniques that can increase the performance of an application not just by a small amount, but by orders of magnitude. These techniques includes simple indexing techniques, T-SQL techniques, and general database application design patterns that give great gains in performance. In this session, you will learn how to look at a database to identify these problem areas and how to resolve common issues that you will encounter.

Presenter
Jeremiah Peschka

Jeremiah Peschka is a SQL Server Developer and DBA in the Columbus, OH area with Cass Information Systems. He is a SQL Server MVP, user group leader, and PASS Director at Large. Jeremiah has a passion for spreading knowledge and writing about himself in the third person. When not using a computer, Jeremiah can be found playing guitar, reading, writing, wandering around central Ohio, or speaking at various SQL Server events.

 Resources

Jeremiah's presentation, materials, and links - http://facility9.com/go/index_rcc

Josef Richberg - Index Primer - Just what statistics are kept?-http://www.sqlservercentral.com/articles/Optimizer/68141/


 

When: Thursday, December 10th, 6:30PM - 8:30PM
Where: Battelle for Kids - 1160 Dublin Rd Suite 500, Columbus, OH 43215

Topic
Automating SQL Server Administrative tasks with PowerShell

Abstract
Most administrative functions consist of repetitive sequences of tasks which just take time. PowerShell is a powerful scripting environment which allows an administrator to automate those repetitive tasks, providing better results to the organization while saving the administrator time, and ensuring that the tasks get done properly every time.

This session will give an introduction to PowerShell and demonstrate a number of scripts which help SQL Server administrators effectively manage their environments.

Presenter
Allen White

Allen is a SQL Server Trainer for Scalability Experts, a leading provider of scalable solutions, training and services based on Microsoft SQL Server. He's spent over 35 years in IT, including operations, development, telecommunications, network admin and database design and administration. He's been using SQL Server since 1992 and is certified MCITP:Database Administrator, MCITP: Database Developer and MCT.

Allen has been awarded Microsoft’s MVP Award the last three years for his work in the SQL Server community. He's active in the Ohio North SQL Server User's Group and contributes in the MSDN Forums, answering questions about SMO and PowerShell, and maintains a blog at SQLblog.com.


 

 

 When: Thursday, October 8th, 6:30PM - 8:30PM
Where: Battelle for Kids - 1160 Dublin Rd Suite 500, Columbus, OH 43215

Topic
Understanding Execution Plans

Abstract
Attendees will be introduced to the wealth of data contained within the execution plans generated by SQL Server. From the simplest "SELECT *" query to complicated joins, the icons and properties that allow you to understand what is occuring within your query will be explained. You will leave knowing what kinds of execution plans you have available and what they can be used for. You'll learn about graphical exeuction plans; what do the icons mean and how are they related; how much information is available and how to access and interpret it. All this information will be used to help you understand what's happening within your queries so that you can identify and fix poor performance in your own environment.

Presenter
Grant Fritchey

Grant Fritchey, Microsoft SQL Server MVP, works for an industry-leading engineering and insurance company as a principal DBA. He's done development of large-scale applications in languages such as Visual Basic, C#, and Java, and has worked with SQL Server since version 6.0.

Grant spends a lot of time involved in the SQL Server community, including speaking, blogging, and he is an active participant int the SQLServerCentral.com forums.

He is the author of SQL Server Execution Plans (Simple Talk Publishing, 2008) and SQL Server Query Performance Tuning Distilled (Apress, 2008).

 


 

When: Thursday, September 10th, 6:30PM - 8:30PM
Where: Battelle for Kids - 1160 Dublin Rd Suite 500, Columbus, OH 43215

Food and drinks provided, thanks to this month's food sponsor: HMB Information System Developers.

Topic
Locking and Blocking Made Simple

Abstract
A good working knowledge of how SQL Server makes use of locking and transaction isolation levels can go a long way toward improving an application’s performance. In this session, we will explore SQL Server’s locking methodology and discover techniques for enhancing query response times.

Presenter
Joe Webb

Since its inception, Joe Webb has served as Chief Operating Manager for WebbTech Solutions, a Nashville-based consulting company. He has over 15 years of industry experience and has consulted extensively with companies in the areas of business process analysis and improvements, database design and architecture, software development, and technical training.

In addition to helping his consulting clients, Joe enjoys writing and speaking at technical conferences. He has spoken at conferences in Europe and the North America and has authored books including “The Rational Guide To: SQL Server Notification Services” and “The Rational Guide To: IT Consulting”.

Joe served for six years on the Board of Directors for the Professional Association for SQL Server (PASS), an international user group with 30,000 members worldwide. Joe culminated his tenure on the board by serving as the Executive Vice President of Finance for the organization. Joe also volunteers his time by serving on the MBA Advisory Board for Auburn University and the Computer Science Advisory Committee for Nashville State Community College.

Joe is a five time recipient of the Microsoft MVP Award for demonstrating a willingness to share his expertise with the SQL Server Community. Joe may be reached at joew@webbtechsolutions.com.

 


 

When: Thursday, August 13th, 6:30PM - 8:30PM
Where: Battelle for Kids - 1160 Dublin Rd Suite 500, Columbus, OH 43215

Food and drinks provided, thanks to this month's food sponsor: Red Gate Software.

Topic
End-to-End Troubleshooting for SQL Server

Abstract
Learning how to detect, diagnose and resolve performance problems in SQL Server can be very difficult.  It often takes years of on-the-job experience to learn how to use the tools and techniques that help you detect when a problem is occurring, diagnose the root-cause of the problem, and then resolve the problem.  This hands-on session will take you from the very start of a problem situation on SQL Server, showing you how to use the native tools that help you keep SQL Server at top performance.  This session will detail and demonstrate:
 
  • Performance Monitor (PerfMon)
  • SQL Profiler/Server-side Trace
  • Correlating PerfMon and Profiler results
  • Graphic Explain Plan and Transact-SQL Showplan
  • SQL Server 2005 and 2008 DMVs
  • When to use Trace Flags
These tools and techniques can make your long days shorter and make difficult troubleshooting activities much faster and easier.  Every DBA needs to know how to keep their SQL Server in tip-top condition, and you’ll need these skills to do it. 

Presenter
Kevin Kline
Kevin Kline is the Technical Strategy Manager for SQL Server Solutions at Quest Software, a leading provider of award winning tools for database management and application monitoring on the SQL Server platform. A Microsoft SQL Server MVP since 2004, Kevin is a founding board member of the international Professional Association for SQL Server (PASS) and served as president from 2002-2006. He is the lead author of SQL in a Nutshell and a co-author of Pro SQL Server 2005 Database Design and Optimization and Database Benchmarking: Practical Methods for Oracle & SQL Server. Kevin writes monthly columns for SQL Server Magazine and Database Trends & Applications and blogs at SQLBlog.com and SQLMag.com. Kevin is a top rated speaker, appearing at international conferences like Microsoft TechEd, the PASS Community Summit, Microsoft IT Forum, DevTeach,and SQL Connections. When he’s not pulling his hair out over work, he loves spending time with his four kids and in his garden. 

 

When: Thursday, July 9th, 6:30PM - 8:30PM
Where: Battelle For Kids - 1160 Dublin Rd Suite 500, Columbus, OH 43215

Food and drinks provided, thanks to this month's food sponsor: Red Gate Software.

Topic
Incremental Loads, Change Data Capture, and SSIS 2008

Abstract
Change Data Capture is a new SQL Server 2008 feature. One benefit of CDC is data filtering for Incremental ETL in SSIS: only touching rows that are new, updated, or have been deleted! In this presentation I walk through enabling Change Data Capture in SQL Server 2008, then present an overview of an SSIS package that utilizes Change Data Capture to perform Incremental ETL.

Presenter
Andy Leonard
Andy Leonard is an Architect and manager with Unisys Corporation, SQL Server Database and Integration Services developer, SQL Server MVP, PASS Regional Mentor (Southeast US), and engineer. He is a co-author of Professional SQL Server 2005 Integration Services , Professional Software Testing with Visual Studio 2005 Team System: Tools for Software Developers and Test Engineers , and MCITP Self-Paced Training Kit (Exam 70-441): Designing Database Solutions by Using Microsoft SQL Server 2005 . Andy founded and manages VSTeamSystemCentral.com and maintains two blogs there: Applied Team System and Applied Business Intelligence . He also blogs for SQLBlog.com . Andy's background includes web application architecture and development, VB, and ASP; SQL Server Integration Services (SSIS); data warehouse development using SQL Server 2000, 2005, and 2008; and test-driven database development.

 

 

 


When: Thursday, June 11th, 6:30PM - 8:30PM
Where: Battelle For Kids - 1160 Dublin Rd Suite 500, Columbus, OH 43215

Reminder: Battelle for Kids is now in Suite 500 at the opposite end of the building.

Food and drinks provided, thanks to this month's food sponsor: Red Gate Software.

Topic
Developing Something for Nothing - SQL Server Express Edition

Abstract
Join SQL Server expert Brent Ozar and SQL Server developer Jeremiah Peschka as they give an overview of the free tools you can’t afford to ignore in tough economic times! In this presentation, you’ll see how to improve your productivity with SQL Server Express Edition.

  • SQL Server Express Edition – the free version of SQL Server
  • SQL Server Management Studio Express – the free way to manage your Express Edition instances

 
Presenters
Brent Ozar

Brent is a SQL Server Domain Expert with Quest Software. Brent has a decade of broad IT experience, performing systems administration and project management before moving into database administration. In his current role, Brent specializes in performance tuning, disaster recovery and automating SQL Server management. Previously, Brent spent 2 years at Southern Wine & Spirits, a Miami-based wine & spirits distributor. Brent has experience conducting training sessions, has written several technical articles, and blogs prolifically at http://www.BrentOzar.com.

Jeremiah Peschka

Jeremiah Peschka is a SQL Server developer in the Columbus, OH area with HMB Information System Developers. Jeremiah has broad IT experience in systems administration, web design, application development, and database development spread across diverse platforms. In his current role, Jeremiah specializes in developing solutions based on the SQL Server platform. Jeremiah is currently the Group Leader for CBusPASS, the Columbus chapter of PASS, and the Group Leader for the PASS Application Development Virtual Chapter. He blogs, but not prolifically, at http://facility9.com.

 


 

When: Thursday, May 14th, 6:30PM - 8:30PM
Where: Battelle For Kids

Food and drinks will be provided.

Using Cloud-Based BI to Interpret Perfmon & Profiler Results

After learning how to use Perfmon and Profiler to gather performance statistics about your SQL Server, it still takes a lot of time to interpret those results and figure out what’s going on.  Microsoft’s SQL Server Data Mining team has built a free cloud-based data mining tool for Excel that can help slice and dice mountains of data and help you make sense of it all.

Even if you’re not ready for BI in the cloud, you can use this same type of tool in combination with a local SQL Server Analysis Services instance.  Wait!  Don’t freak out - it’s much easier than you think, and you never have to leave the comforting environment of Excel.  Even if this doesn’t sound like fun to you, you might want to learn about it because mid-level managers in your company might want to use this technique to analyze sales or customer data.

Attendees will learn how to install & configure data mining in Excel, how to analyze Perfmon data to break the server’s load into categories, and how to use BI to write a performance report about your SQL Server.

Brent Ozar

Brent is a SQL Server Domain Expert with Quest Software. Brent has a decade of broad IT experience, performing systems administration and project management before moving into database administration. In his current role, Brent specializes in performance tuning, disaster recovery and automating SQL Server management. Previously, Brent spent 2 years at Southern Wine & Spirits, a Miami-based wine & spirits distributor.

Brent has experience conducting training sessions, has written several technical articles, and blogs prolifically at http://www.BrentOzar.com. He's currently writing SQL Server Internals and Troubleshooting for Wiley/Wrox along with Christian Bolton, Justin Langford and Cindy Gross.  He's Editor-in-Chief at SQLServerPedia.com, where he also records video podcasts.

 

If you can't attend in person, you can join us using LiveMeeting:

Join the meeting.
Audio Information
Computer Audio
To use computer audio, you need speakers and microphone, or a headset.
First Time Users:
To save time before the meeting, check your system to make sure it is ready to use Microsoft Office Live Meeting.
Troubleshooting
Unable to join the meeting? Follow these steps:

  1. Copy this address and paste it into your web browser:
    https://www.livemeeting.com/cc/usergroups/join
  2. Copy and paste the required information:
    Meeting ID: NM86HK
    Entry Code: 5\-b6|jkH
    Location: https://www.livemeeting.com/cc/usergroups

 

Resources

Tutorial:
http://www.brentozar.com/perfmoncloud

Excel Table Analysis Tools for the Cloud:
http://www.sqlserverdatamining.com/cloud

ClearTrace:
http://www.cleardata.biz/cleartrace

Denny Cherry on SQL Server licensing:
http://itknowledgeexchange.techtarget.com/sql-server/yes-dbas-you-really-do-have-to-deal-with-licensing/

Microsoft web platform installer:
http://www.microsoft.com/Web/

 


 

When: Thursday, April 9th, 6:30PM - 8:30PM
Where: Battelle For Kids

Food and drinks will be provided.

Topic
Tips, Tricks, & Techniques from the Community

Speakers & Abstract

 A variety of people will be presenting on tips, tricks, and techniques they use to make their life easier on a day to day basis.

 


 

When: Thursday, March 12th, 6:30PM - 8:30PM
Where: Battelle For Kids

Food and drinks will be provided.

Topic
Dynamic SQL Tips, Tricks, & Techniques 

Speakers & Abstract

 

Jeremiah Peschka

Dynamic SQL is a powerful but difficult tool to master. Jeremiah will show you techniques for creating rock solid, fast, dynamic SQL that will meet the day to day needs of your production system.

George Brown

Do you have a need for search functionality within your database but are limited to using TSQL stored procedures?  Are you not using dynamic SQL due to the risk of SQL injection attacks?  Have you seen performance issues with your current stored procedures used for searches?  George Brown will bring examples he has come across in the past and will show how to use stored procedures with dynamic SQL, while still protecting against SQL injection attacks.   

 


 

When: Thursday, February 12th, 6:30PM - 8:30PM
Where: Battelle For Kids
1160 Dublin Rd
Suite 100
Columbus, OH 43215

Food and drinks will be provided.

A LiveMeeting is available for those who are unable to attend in person. Please visit Columbus PASS Chapter Thursday on LiveMeeting for more information.

Topic
Perfmon & Profiler 101

Abstract
These two tools are the key to successful performance tuning.  Brent will show how to get started with these tools, how to slice and dice the results, and even how to data mine the results to look for interesting trends.

Speakers

Brent Ozar

Brent is a SQL Server Domain Expert with Quest Software. Brent has a decade of broad IT experience, performing systems administration and project management before moving into database administration. In his current role, Brent specializes in performance tuning, disaster recovery and automating SQL Server management. Previously, Brent spent 2 years at Southern Wine & Spirits, a Miami-based wine & spirits distributor.

Brent has experience conducting training sessions, has written several technical articles, and blogs prolifically at http://www.BrentOzar.com. He's currently writing SQL Server Internals and Troubleshooting for Wiley/Wrox along with Christian Bolton, Justin Langford and Cindy Gross.  He's Editor-in-Chief at SQLServerPedia.com, where he also records video podcasts.

Resources

The presentation is available as a PowerPoint 2007 file or a PowerPoint 2003 file.

Brent’s posts about Perfmon and analytics are available online:
http://www.BrentOzar.com/perfmon
http://www.BrentOzar.com/perfmoncloud

In addition, Brent mentioned Excel Table Analysis Tools for the Cloud:
http://www.SQLServerDataMining.com/cloud

In addition, Brent is the Editor-in-Chief for SQL Server Pedia, which is an excellent community driven SQL Server resource.

 
   
   
   
   
   

Topic:        

Introduction to PASS and 2008 PASS Summit Review

Date:

Thursday, January 15, 2009

 

 

Speaker:

 

 

 

 

Jeremiah Peschka

Jeremiah Peschka is a consultant with HMB Information System Developers. He has over 5 years of experience working with SQL Server technologies and is the current president of CBusPASS - the Columbus SQL Server User Group.

Location:

Battelle For Kids

Overview:

This presentation will show the benefits of joining PASS, taking part in a PASS chapter, and provide a general overview of the 2008 PASS Summit. The future plans of the PASS chapter will also be discussed.

 

When: Thursday, November 12th, 6:30PM - 8:30PM
Where: Battelle for Kids - 1160 Dublin Rd Suite 500, Columbus, OH 43215

Topic
Dynamic Management Objects

Abstract

With the release of Microsoft SQL Server 2005, the curious DBA had a new arsenal of tools available for indentifying performance issues, automating maintenance tasks, and documenting their environments.  These tools are called Dynamic Management Objects. Join Tim Ford as he takes you on a tour through some of his favorite Dynamic Management Objects and see why you just may have found you new favorite thing about Microsoft SQL Server.

Presenter

Tim Ford

Timothy Ford has been working with Microsoft SQL Server for almost 10 years, originally as a developer in SQL Server 7.0 and Visual Basic 6; now as a DBA for the last 8 years. He specializes in mining information from the system tables for automation of administrative tasks and troubleshooting performance matters.

Tim has been a volunteer with the Professional Association for SQL Server (PASS) since 2002, serving as a founding leader of the DBA Special Interest Groups, on the Program Committee for 5 years, on the Editorial Committee, and as the co-creator and host of the annual SIG Quizbowl presented at each of the opening receptions of the PASS Summit for the past 5 years. 

He is an author and blogger, writing technical articles for MSSQLTips.com, Simple-Talk, SQL Server Central, and SQLServerpedia, where he also serves as the DBA Section Editor. 

Tim was one of the SQL Magazine Innovators of the Year for 2008 and is featured on the cover and in the associated story in the January 2008 issue.

When not engaged in the world of T/SQL you'll usually find him with a camera or spatula in his hands as he enjoys photography and cooking.

 


 

Welcome to the Columbus SQL Server Users Group