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, SQLoncall

• 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, SQLoncall

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

Friday, January 30, 2009

6:30:00 PM

• Location: Old Chicago  Get Map

• Topic: 2009 Kickoff Party

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

• Description: We want to see you at the 2009 Kickoff Party at Old Chicago on Academy and Austin Bluffs. Each and ever member is invited and may bring a guest. There will be food, drink, pool, and just good fun. Please come and get ready for a great 2009.

Wednesday, February 18, 2009

5:30:00 PM

• Location: ConfigureSoft  Get Map

• Topic: Intro to SSIS 2008

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

• Description: SQL Server Integration Services (SSIS) is the extraction, transform, and load (ETL) tool in SQL Server. SSIS replaces and improves upon Distributed Transaction Services (DTS) from previous version. Now a truly powerful enterprise level ETL tool is available with SQL Server. 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.

Wednesday, March 18, 2009

5:30:00 PM

• Location: ConfigureSoft  Get Map

• Topic: The Modern Resume: Building Your Brand Online

• Presenter: Steve Jones,

• Description: Steve Jones, founder of SQL Server Central talks about how to update your resume to fit into today's modern world, and take advantage of the tools offered by blogging, social networking, and more.

Wednesday, April 15, 2009

5:30:00 PM

• Location: ConfigureSoft  Get Map

• Topic: SQL Server Tune-Up

• Presenter: Chris Shaw, SQLoncall

• Description: Just like you tune up your car, or you head to the Doctor for a health visit, your SQL Server needs a tune up on occasion. In this session we will talk about how to do your SQL Server tune up and what you should be looking for. This session is designed for DBAs and the accidental DBA.

Wednesday, May 20, 2009

5:30:00 PM

• Location: ConfigureSoft  Get Map

• Topic: SQL Server 2008 OLTP Database Consolidation Best Practices

• Presenter: Maurice De Vidts, Hewlett Packard Company

• Description: The presentation covers server side performance considerations that help co-locate multiple databases within a single instance database server(s) and the applicable storage optimizations in a SAN attached storage environment. In addition, the presentation will cover advanced topics such as NUMA memory allocation on the server side. Although the presentation focuseses on single instance consolidation, many of the findings are applicable to multi-instance hosted environments as well.

Wednesday, June 17, 2009

5:30:00 PM

• Location: Consortio Services  Get Map

• Topic: Meta Data – Cardinality explored

• Presenter: Jeremy Lowell,

• Description: The importance of certain meta data in each database plays a critical role in design enhancements, performance and scalability. In this session we will go over some of the overlooked importance with what a simple cardinality query output can produce. Attendees should walk away with a usable script for their environment and knowledge as to how this information can be utilized to better design their database(s) and help them to scale. This simple dataset is critical for performance tuning, design (table, t-sql, indexing), reporting and testing. Ideal attendees will be developers (.Net, SQL, report writers, Business Intelligence), database administrators, testers and those who are simply curious.

Wednesday, July 15, 2009

5:30:00 PM

• Location: Consortio Services  Get Map

• Topic: SSIS 2008

• Presenter: Peter Myers, SolidQ

• Description: SSIS 2008 Data Profiling in 2008 Slowly Changing Dimension Transformation Fuzzy Lookup Using SSIS as a SSRS data source

Wednesday, August 19, 2009

5:30:00 PM

• Location: Consortio Services  Get Map

• Topic: Memory Management in SQL Server Analysis Services

• Presenter: Steve Wright, SQL Sentry

• Description: In this presentation Steve Wright will discuss methods used to manage memory in SQL Server Analysis Services focusing primarily memory limits and preallocation. He will also present some examples from the field of performance issues due to mis-configuration, how they were identified, and ultimately resolved.

Wednesday, September 16, 2009

5:30:00 PM

• Location: Consortio Services  Get Map

• Topic: SQL Server Tuning

• Presenter: Dean Richards, Confio Software

• Description: Many DBAs and Developers are faced with tuning poorly performing SQL statements. However, many tuning projects fail because the process being used is inefficient. This presentation will walk through a process Confio Software uses with great success and will include topics such as: SQL diagramming, wait time data, indexing strategies, column selectivity and several more that will help the you succeed on future tuning projects.

Wednesday, October 21, 2009

5:30:00 PM

• Location: Consortio Services  Get Map

• Topic: SQL Server 2008 Reporting Services: Yesterday, Today and Tomorrow

• Presenter: Steve Wake, Visa

• Description: Reporting Services is now in its’ third major release as part of the Microsoft SQL Server family, come see how the product started as an add-on to SQL Server 2000 and has grown into a product that Microsoft now includes in almost every major software product they develop. In this presentation we will look at what Reporting Services is and how it can be deployed and used in your applications. We will also get a look at the big changes that Microsoft is working on for the SQL Server 2008 R2 release that will be coming out later in 2010 as well.

Wednesday, November 18, 2009

5:30:00 PM

• Location: Consortio Services  Get Map

• Topic: Disaster Recovery Planning (The points often forgotten)

• Presenter: Chris Shaw, SQLoncall

• Description: Too often companies have no plan for disaster recovery. Yet something as simple as a RAID configuration shows some steps have been taken to prepare of a disaster. We will spend time looking at what may be missing to complete the disaster recovery plan. This session can help you start to get documents in place that will help with the ease of working through a disaster successfully. Discussion at the end of the session is directed around a flood disaster that left a bank crippled and how they were able to recover.

Thursday, January 21, 2010

5:30:00 PM

• Location: Consortio Services  Get Map

• Topic: SQL Encryption and You

• Presenter: Todd Kleinhans, TransFirst

• Description: What Is Encryption and Why Should I Care A Brief History of Cryptology Alice Meets Bob Demo Encryption Hierarchy & Key Management How to Change What You Don't Know Data Encryption System Encryption Rotating Keys and RBAR Cloud Encryption

Wednesday, February 17, 2010

5:30:00 PM

• Location: Consortio Services  Get Map

• Topic: PowerShell 101 for the SQL Server DBA

• Presenter: Joshua Jones, Consortio Services

• Description: any DBAs have heard about the new scripting technology from Microsoft, but have yet to really dive right in. You may have heard about a new scripting language for Windows Admins; PowerShell. However, PowerShell holds a lot of benefits for SQL Server DBAs. In this presentation, I’ll guide you through getting your feet wet with PowerShell, understanding what it can and can’t do, and take an in depth look at many of the specific areas PowerShell can make your life easier. We'll cover installation, security, exploring SQL Server, and scripting simple tasks such as backups, server configuration, and policy management.

Wednesday, March 17, 2010

5:30:00 PM

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

• Topic: MyLifeBits and SQL Integrated Full-Text Search

• Presenter: Todd Kleinhans, TransFirst

• Description: A Brief History of MyLifeBits Total Recall Searching Structured and Unstructured Data Introducing Integrated Full-Text Search A Small Intranet Uploading Data and Documents Google-like Search Storing Your Data Both Locally and In the Cloud

Wednesday, April 21, 2010

5:30:00 PM

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

• Topic: Best Practices Using the ADO.NET Entity Framework 4.0 – Level 300

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

• Description: LINQ (Language Integrated Query) has changed the way developers work with objects. LINQ to SQL and The ADO.NET Entity Framework (EF) have taken LINQ into the data access space. These technologies give developers some powerful tools, but they also lend themselves to some poor design practices. During this talk we will identify some of the pitfalls EF exposes from a DBAs perspective. EF can be an integral part of any application, when used properly. Microsoft is investing in EF and it will be an important part of software development in the future. Join us to learn how developers like to use it today and prepare your SQL Server DBs for the future of data access.

Wednesday, May 19, 2010

5:30:00 PM

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

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

• Presenter: Glenn Berry, NewsGator Technologies

• Description: 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 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 and 2008), presents and explains over twenty DMV queries that you can quickly and easily use to detect and diagnose performance issues in your environment.

Wednesday, June 16, 2010

5:30:00 PM

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

• Topic: 10 Largest SQL projects in the world and how they scale

• Presenter: Kevin Cox, Microsoft

• Description: What are the largest projects on SQL Server? How do they scale? How do they accomplish HA/DR? Kevin will talk about these topics at the next SQL Server Users Group meeting.