Wednesday, July 13, 2005

6:30:00 PM

• Location: Pikes Peak Library - Ruth Holley Branch  Get Map

• Topic: Application and Database Security

• Presenter: Terry Ray, Imperva

• Description: Terry Ray led a discussion on application and database security

Wednesday, August 10, 2005

6:30:00 PM

• Location: Pikes Peak Library - Ruth Holley Branch  Get Map

• Topic: Merge Replication vs. Updating Subscriptions

• Presenter: Andrew Lias,

• Description: Andrew Lias led a discussion on Merge Replication vs. Immediate and Queued Updating Subscriptions

Tuesday, September 13, 2005

6:30:00 PM

• Location: Pikes Peak Library - Ruth Holley Branch  Get Map

• Topic: SQL Server and XML

• Presenter: Wolfgang Baeck,

• Description: Wolfgang Baeck led a discussion on SQL Server and XML. Both SQL Server 2000 and 2005 was covered

Thursday, October 13, 2005

6:30:00 PM

• Location: Pikes Peak Library - Ruth Holley Branch  Get Map

• Topic: SQL Server Q&A

• Presenter: Chris Shaw, Premiere Global Services

• Description: SQL Server Questions and Answers SQL Game

Tuesday, November 08, 2005

6:30:00 PM

• Location: Pikes Peak Library - Ruth Holley Branch  Get Map

• Topic: Leveraging Data Modeling and Metadata

• Presenter: Greg Keller, Embarcadero

• Description: Greg Keller from Embarcadero will talk about how you can leverage data modeling and metadata to:

Tuesday, December 13, 2005

6:30:00 PM

• Location: Pikes Peak Library - Ruth Holley Branch  Get Map

• Topic: Scripts for Production Release

• Presenter: Kat Meadows, El Paso County

• Description: Kat Meadows from El Paso County will present on automation of production releases. She will walk through scripts used to release new objects or modifications into your production environment in order minimize user or process error

Tuesday, January 10, 2006

6:30:00 PM

• Location: Pikes Peak Library - Ruth Holley Branch  Get Map

• Topic: SQL Server Q&A with Microsoft

• Presenter: Bruce Prang, Microsoft

• Description: Representitives from Microsoft will be on hand getting feedback on SQL Server. This will be your opportunity to get answers on and provide input to the product we all work with.

Wednesday, February 15, 2006

5:30:00 PM

• Location: Pikes Peak Library - Ruth Holley Branch  Get Map

• Topic: SQL Tuning and development lifecycle

• Presenter: Russell Tuttle, Quest Software

• Description: The discussion will cover: Producing “production ready code” faster, Building and maintaining highly performing and available databases, Providing effective application triage, performance analysis, and end user response time support, & Managing change and compliance in a complex application environment

Tuesday, March 14, 2006

5:30:00 PM

• Location: Pikes Peak Library - Ruth Holley Branch  Get Map

• Topic: SQL Server 2005 Partitioning

• Presenter: Chris Shaw, Premiere Global Services

• Description: We will discuss the Architecture of Table Partitions, Creating Table Partitions, & Using Table Partitions.

Wednesday, April 19, 2006

5:30:00 PM

• Location: El Paso County IT Building  Get Map

• Topic: SQL Server 2005 New Tools

• Presenter: Paul Nielsen,

• Description: Explore every nook and cranny of Management Studio – Object Explorer, Query Editor, Query Designer, Summary Page Reports, and Table Designer. See the new features in Profiler including deadlock graphs and merging system monitor graphs. Count the many new ways to watch transactions and locks.

Thursday, May 18, 2006

5:30:00 PM

• Location: El Paso County IT Building  Get Map

• Topic: Schedule Collisions and the Effect on Performance

• Presenter: Steve Write,

• Description: Heavy contention for disk resources can dramatically impact SQL Server performance, and SQL Server Agent jobs can be some of the biggest offenders. In this presentation we’ll cover: - How and why jobs and job collisions can cause disk contention - How to isolate the sources of disk contention using Windows performance counters and analyze the data using some simple formulas, - How to reduce contention in general via “leveling” your job schedules.

Wednesday, June 21, 2006

5:30:00 PM

• Location: El Paso County IT Building  Get Map

• Topic: Server Sprawl Problem

• Presenter: Todd Behrbaum, PolyServe

• Description: Tens to hundreds of instances of SQL Server are deployed on dedicated servers. Server utilization rates lurk in the low teens. Why? Because shared servers complicate capacity planning and responding to unplanned capacity needs takes too long. SQL Server is also deployed on dedicated servers because this limits the impact of server failures to single instances. For instances requiring high availability, active-passive clusters further decrease server utilization rates and drive up the cost of high availability to a point where many instances run unprotected. These factors have caused SQL Server sprawl, whereby more than twice as many servers than required are being purchased and managed to meet current application requirements.

Wednesday, July 19, 2006

5:30:00 PM

• Location: El Paso County IT Building  Get Map

• Topic: SQL Server Protection

• Presenter: Bob Roudebush, DoubleTake

• Description: Database Management Systems (DBMS) are the hidden engines behind some of your company's most critical information applications including Enterprise Resource Management (ERP), Customer Relationship Management (CRM) and Accounting systems. If this critical business information is stored in a DBMS, it is imperative to adequately protect it to maintain application availability and to preserve your company's current and historical data. In this session, learn how real-time replication and SQL availability capabilities from Double-Take can help you keep these critical systems up and running.

Wednesday, August 16, 2006

5:30:00 PM

• Location: El Paso County IT Building  Get Map

• Topic: CompactDBA's Remote Monitoring

• Presenter: Raul Salas, Mobile Monitoring Solutions

• Description: Today's DBA is pressed for higher performance and strict Service Level Agreements concerning Uptime. At the same time, a DBA's personal life may also have higher demands as well...kids baseball games, strict daycare hours, and dual career couples work demands place a premium on free time. CompactDBA can assist the DBA to exceed employer's expectations and give the DBA some additional freedom to meet their family and social obligations by giving them the ability to recieve performance alerts AND take action to correct a performance issue from Their cell phone/PDA. We will cover the capabilities of CompactDba as well as the business benefits of mobile based Monitoring.

Wednesday, September 20, 2006

5:30:00 PM

• Location: El Paso County IT Building  Get Map

• Topic: SQL Server Optimization

• Presenter: Paul Nielsen,

• Description: There are as many SQL Server performance tips and tricks as there are DBAs – including indexing, locking and blocking, physical schema design, killing cursors and tuning the server. Optimization Theory, based on 22 years of designing databases and turning around failed database projects, is a framework that explains the dependencies between these various strategies and how to plan and design an optimized database. Learn practical strategies for all your database development needs through this session as it combines coding techniques, architecture strategies and database theory.

Wednesday, October 18, 2006

5:30:00 PM

• Location: El Paso County IT Building  Get Map

• Topic: What's in your Tool Box

• Presenter: Kat Meadows, El Paso County

• Description: Every database professional should have the tools needed to complete their job. But do you re-invent them each time you start a new job or do you take them with you. We will be discussing what items should go into your tool box and to use them in your current job and ones in the future.

Wednesday, January 17, 2007

5:30:00 PM

• Location: Residence Inn  Get Map

• Topic: SQL Server Integration Services

• Presenter: Eric Johnson, Consortio Services & President of CSSQLUG

• Description: SQL Server Integration Services (SSIS) is the new extract, transform and load (ETL) tool in SQL Server 2005. SSIS replaces and improves upon the previous Distributed Transaction Services. SSIS is now a truly powerful enterprise level ETL tool. SSIS provides graphical tools for designing, building and debugging SSIS packages. This presentation will provide an overview of SSIS and a look into the many functions for merging, cleaning and aggregating data. You’ll also learn about your options for scheduling and running SSIS packages both with and without SQL Server.

Wednesday, February 21, 2007

5:30:00 PM

• Location: Residence Inn  Get Map

• Topic: SQL Server 2005 Migrations Round Table

• Presenter: Eric Johnson, Consortio Services & President of CSSQLUG

• Description: The CSSQLUG Board will host an open discussion on SQL Server 2005 migrations. Come with your questions, tips, ideas, etc.... as they relate to migrating to SQL Servr 2005. Additionally, Josh Jones will start us off with an overview of MyLittleAdmin for SQL Server. http://www.mylittleadmin.com

Wednesday, March 21, 2007

5:30:00 PM

• Location: Residence Inn  Get Map

• Topic: A Solution for SQL Server Automation

• Presenter: Andrew Wright , StrataVia

• Description: SQL Server environments are growing like wildfire, and companies are struggling to keep up with the growing demands on their often limited DBA staff. As the SQL Server presence grows, often so do the number of alerts and emails which act as thought-breakers. These thought-breakers can prevent a DBA from working on more value-add tasks such as capacity planning, tuning and optimization, and planning for the additional growth and direction of their company’s data. The historical solution has been to hire more DBAs, often causing more complexity and entering into a vicious cycle of hiring DBA after DBA. Tools are sometimes purchased to help alleviate the DBA workload, but the workload does not seem to reduce. Database Automation offers a credible solution to help DBAs scale effectively and receive less thought-breakers throughout their day. By bringing the benefits of standardization and automation to database administration, DBAs can reduce their workload and concentrate more of their time on higher value tasks. Thoughtfully implemented automation also scales with growth in data and infrastructure, keeping undue complexity at bay.

Wednesday, April 18, 2007

5:30:00 PM

• Location: Progressive Insurance  Get Map

• Topic: SQL Server 2005 Query Plan Options

• Presenter: Kalen Delaney, www.InsideSQLServer.com

• Description: Being able to determine how SQL Server is processing your critical queries is the most crucial step in determining what queries are tunable, and how you might begin your tuning efforts. SQL Server 2005’s graphical query plan output is similar to SQL Server 2000’s, but there are some important differences. We will cover the basics of reading various kinds of query plans, both text based and graphical. We will also look at the XML showplan feature available through the SQL Server Management Studio and through the SQL Server Profiler and discuss the various uses for plans in XML format.

Wednesday, May 16, 2007

5:30:00 PM

• Location: Residence Inn  Get Map

• Topic: Encryption and Certificates in SQL Server

• Presenter: Volkan Buyukacar,

• Description: With all the privacy regulations coming into scene data encryption is becoming more important for the businesses every day. Luckily the tools to employ encryption are becoming more available and easier to set up and support also. Microsoft also contributed to this momentum by integrating new encryption capabilities into SQL Server 2005. Although the encryption is made easy in SQL 2005, there is still some hesitation against these tools due to the bad experiences from complicated encryption tools in the past. In this 50 minute session we will try to cover encryption in SQL 2005 at an introductory level to remove some of the prejudices against encryption.

Wednesday, July 18, 2007

5:30:00 PM

• Location: Residence Inn  Get Map

• Topic: An Introduction to Analysis Services

• Presenter: Mike White, IntrinsiQ, LLC

• Description: Are you ready to investigate the power of Business Intelligence in SQL Server 2005? Perhaps you have a reporting system that is running out of steam using legacy approaches? Join us Tuesday, June 19, 2007 when Mike White presents an introduction to the setup, capabilities, and use of Analysis Services. Come join us to explore this exciting technology!

Wednesday, August 15, 2007

5:30:00 PM

• Location: Residence Inn  Get Map

• Topic: Advanced Tips & Techniques for Using Profiler

• Presenter: Brad McGehee,

• Description: While most DBAs know how to use Profiler to capture a basic trace, what many DBAs don't know is how to leverage all of the Profiler events and use them to see exactly how their SQL Servers are running at the most basic level. The insights gained from this seminar will provide you new and unique ways to identify a wide range of SQL Server 2005 performance problems, giving you the technical knowledge you need to know to be a master DBA. Prerequisites: You should have a basic understanding of how to use SQL Server Profiler 2005.

Wednesday, October 17, 2007

5:30:00 PM

• Location: Residence Inn  Get Map

• Topic: Nordic O/R dbms

• Presenter: Paul Nielsen,

• Description: Nordic (New Object/Relational Design) is a full featured, Open Source project implemented in a strong T-SQL abstraction layer. It supports super class/sub classes, inheritance, polymorphism, complex inheritable associations that are tied to objet workflows, and object profiles. Version 2.0 presents a cleaner API, and a generic sample .NET UI. While an O/R dbms design is not appropriate for every project, applications with many is-a relationships, flexible associations benefit from moving from 2-D relational modeling to 3-D OOA/D modeling. Nordic v 2.0 will be officially launched as an open source project November 21 at SQL Teach in Vancouver.

Wednesday, November 14, 2007

5:30:00 PM

• Location: Residence Inn  Get Map

• Topic: Columnar Databases Overview

• Presenter: Joshua Jones, Consortio Services

• Description: Most SQL Server DBAs know that SQL Server is a Relational Database system. They also take for granted, without even realizing it, that SQL Server is a row store; that is, data is stored in terms of rows, each row being a unique record with various values assigned to it for each column. This format works great for retrieving specific values of a column for a given record, or set of records. However, it can be cumbersome to retrieve all values for all records for a given column. Columnar databases are a way of storing data that optimizes searching data in this manner. In this presentation, we’ll talk about what a column-based database is, how its built, and what applications there are for it in the real world. We’ll discuss its key differences from row-based databases, and what the potential impact of this new database type is in the commercial realm for SQL Server professionals.

Wednesday, December 19, 2007

6:00:00 PM

• Location: Residence Inn  Get Map

• Topic: 2nd Annual Winter Party

• Presenter: Joshua Jones, Consortio Services

• Description: It’s time once again for the Colorado Springs SQL Server Users Group Winter Party! For the month of December, our regularly scheduled meeting on Wednesday, December 19th (at our normal location at the Residence Inn on Academy), will feature food, drink, a door prize raffle, and time to socialize and network with fellow SQL Server professionals. There won’t be a formal presentation, other than standard user group business. Think of this as time to get out and celebrate the season with your peers, get some good food, and win a prize. If you're a registered member, be on the lookout for an Evite shortly. If you aren't registered yet, register now and send an email to josh.jones@springssql.org that you'd like to join us!

Wednesday, January 16, 2008

5:30:00 PM

• Location: Residence Inn  Get Map

• Topic: LINQ – What is it and why should I care?

• Presenter: Ben Hoelting, Colorado Technology Consultants, Inc.

• Description: First, get a look at LINQ. LINQ is a new feature provided by the .Net Framework 3.5 and Visual Studio 2008. It provides a simple way to access data from multiple data sources (SQL Server, XML Docs and even your own in memory object collections). See demos of how to use it and the different features it provides. Next, dive in to why it matters. We’ll look at things like performance, security and learning curve concerns. I will also discuss how LINQ fits in with some of the common OO Design Patterns as well as real world demos of how you can use it today.

Wednesday, February 20, 2008

5:30:00 PM

• Location: Residence Inn  Get Map

• Topic: A New Encoding Scheme for Representing Materialized Path Hierarchies in SQL Server

• Presenter: Troy Ketsdever, Configuresoft

• Description: Presentation of a new means for representing hierarchies in a high-performance way for SQL Server, complete with reference example. Includes comparisons with materialized path representation.

Wednesday, April 16, 2008

5:30:00 PM

• Location: TekSystems  Get Map

• Topic: CANCELLED!! SQL Server 2008 Data Compression

• Presenter: Joshua Jones, Consortio Services

• Description: DUE TO WEATHER, THIS MEETING HAS BEEN CANCELLED. With the increasing size of enterprise databases, and the cost-efficiency mindset of most IT shops, maximizing disk space is a priority in every environment. FOrutnately, SQL Server 2008 will help by introducing several new features, including backup and data compression. Come this presentation to learn about the new data compression features in SQL Server 2008 including how this new feature works, and the pros and cons of implementing compression in your database.

Wednesday, May 21, 2008

5:30:00 PM

• Location: ConfigureSoft  Get Map

• Topic: SQL Server 2008 Data Compression

• Presenter: Joshua Jones, Consortio Services

• Description: With the increasing size of enterprise databases, and the cost-efficiency mindset of most IT shops, maximizing disk space is a priority in every environment. FOrutnately, SQL Server 2008 will help by introducing several new features, including backup and data compression. Come this presentation to learn about the new data compression features in SQL Server 2008 including how this new feature works, and the pros and cons of implementing compression in your database.

Wednesday, June 18, 2008

5:30:00 PM

• Location: ConfigureSoft  Get Map

• Topic: Code

• Presenter: Paul Nielsen,

• Description: Code. Lots of T-SQL code. Scripts. New features, old favorite stuff, and DMVs. Just T-SQL, and then more T-SQL. And bring your T-SQL questions!

Wednesday, July 16, 2008

5:30:00 PM

• Location: ConfigureSoft  Get Map

• Topic: Wait-Time Based SQL Server Performance Management

• Presenter: Dean Richards, Confio Software

• Description: Using Wait Time Analysis and Wait Types is a newer method for tuning SQL Server instances. As a result, there is often confusion on exactly what the data means. The issue typically centers around the fact the wait time data is analyzed at the wrong level or the collected wait time data is not detailed enough. This presentation will focus on these problems and review several real-life case studies of using SQL Server Wait Type data coupled with Wait-Time based performance analysis to solve the most difficult performance related issues.

Wednesday, August 20, 2008

5:30:00 PM

• Location: ConfigureSoft  Get Map

• Topic: Change Data Capture

• Presenter: Marc Beacom,

• Description: We'll dive into the new Change Data capture (CDC) feature of SQL Server 2008.

Wednesday, September 17, 2008

5:30:00 PM

• Location: ConfigureSoft  Get Map

• Topic: Data Mining with SQL Server

• Presenter: Carlos Bossy, Aabcom Solutions

• Description: Data mining gives you valuable insight into the large amount of data companies have gathered over the years. You can leverage the data mining techniques to assist in forecasting sales, send targeted mailings to specific customer types, suggestive sales, market basket analysis to name a few. Data mining will allow you and your company to gain the competitive edge over the competition. However, where do you start? Join Carlos at the Denver SQL Server User Group where he will give you a jump start into Data Mining.

Wednesday, October 15, 2008

5:30:00 PM

• Location: ConfigureSoft  Get Map

• Topic: Advanced Declarative Constraint Implementation in SQL Server

• Presenter: Troy Ketsdever, Configuresoft

• Description: Experienced data modelers are familiar with the standard declarative constraints provided in SQL that help to enforce business rules. In this session, we look at examples of complex business rules that would typically be ignored in the implementation at the database layer, and work through various techniques for enforcing them using a declarative model.