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.