SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

ColoradoSQL in May

All ColoradoSQL user group meetings start at 5:30 and provide food and refreshments. There is no cost to attend so bring a co-worker.


Tuesday May 17

Level 3 Communications

Room 4LA-07

1025 Eldorado Blvd
Broomfield, CO 80021



Managing SQL Server Permissions
Technorati Tags: ,

Mike Fal (twitter | blog)
When your boss asks you who has access to your databases, do you break out into a cold sweat? Or, instead, are you worried about those other people who might have 'sa' access to your server and might be causing trouble on your server? Either way, as DBAs we need to be able to audit our SQL Server security. This presentation will give you a general overview of the different types of roles that you can use to manage access, what they mean, and how we look at the security gremlins hiding under the covers of our databases.

Mike Fal is a SQL Server DBA with 10+ years of experience, with some brief excursions into Oracle and Netezza. He currently works for a nation-wide marketing agency, supporting over 100 database servers with databases from 1 GB to 4 TB in size. Mike holds a Bachelor's Degree from the University of Colorado at Boulder and has been caught playing trombone in public on more than one occasion.


Wednesday May 18

Mr. Biggs

5825 Mark Dabling Boulevard
Colorado Springs, CO 80919



Encryption, Compliance and Auditing

Tom Norman (twitter)

I have this database which must meet all of these governmental regulations. Just like the government to make life a lot harder but wait, now they say I most also meet International regulations. Can this be true? Why me? Let's look at what we can do to help us pass audits and comply with the laws around us. We will explore the features in SQL Server 2008 which help us.


Tom Norman, Sql Server Database Administrator, TSYS. Tom has been working with Sql Server since 1998. He has worked internationally with Sql Server. His current responsibilities include Replication, Performance and Server Compliance of all Production databases in the US and UK. Tom and his team are currently working on a project to upgraded several products to Sql Server 2008 R2 and bring them into PCI compliance. Tom is the past President of the Denver Sql Server User Group.


Thursday May 19

Microsoft DTC Office

7579 Technology Way, Suite 400
Denver, CO 80237


Warm-up Presentation

Isn't That Spatial?

Jason Horner (twitter)

Isn't that Spatial is a 30 minute whirlwind tour of the spatial features introduced in SQL Server 2008. We will cover the basics of working with spatial data including: importing, querying, and visualizing. As time permits, we will dive into some best practices for working with spatial data and ways to improve spatial query performance.

Jason has been working with SQL Server since version 6.5 and currently holds several Microsoft certifications including: MCSD, MCDBA and MCTS. His most recent focus has been architecting large scale BI solutions. Previously, he helped architect, design, and build several high volume OLTP systems in a wide range of business domains.

Main Presentation

Hardware 201: Selecting and Sizing Database Hardware for OLTP Performance

Glenn Berry (twitter | blog)

The foundation of database performance is the underlying server hardware and storage subsystem. Even the best designed and optimized database application can be crippled by an inadequate hardware and storage infrastructure. Recent advances in new processors and chipsets, along with improvements in magnetic and SSD storage have dramatically changed the evaluation and selection process compared to the past. Many database professionals struggle to keep up with new technology and often simply let someone else make their hardware selection and sizing decisions. Unfortunately, the DBA usually gets the blame for any performance issues that crop up later. Don't let this happen to you! This session covers current and upcoming hardware from both Intel and AMD and gives you the tools and resources to make better hardware selection decisions to support SQL Server OLTP workloads.

Glenn works as a Database Architect at NewsGator Technologies in Denver, CO. He is a SQL Server MVP, and he has a whole collection of Microsoft certifications, including MCITP, MCDBA, MCSE, MCSD, MCAD, and MCTS, which proves that he likes to take tests. His expertise includes DMVs, high availability, hardware selection, full text search, and SQL Azure. He is also an Adjunct Faculty member at University College - University of Denver, where has been teaching since 2000. He recently completed the Master Teacher Program at Denver University - University College. He is the author of two chapters in the book SQL Server MVP Deep Dives, and blogs regularly at http://sqlserverperformance.wordpress.com.

Marc Beacom  ...

Marc Beacom

Marc Beacom – MCTS (BI, Dev), Principal Architect and Owner at DawaBI, has over 15 years of technical and business experience. DawaBI focuses on Making Data-Driven Decisions Possible by delivering user friendly and scalable data warehouse and business intelligence solutions. Marc is an active volunteer within the community and currently is co-organizer of the Colorado GiveCamp, served a year as a PASS Regional Mentor and served five years on the leadership board for the Denver and Colorado Springs SQL Server User Groups.


Posted by Glenn Berry on 17 May 2011

Another good set of presentations this month. I'm looking forward to Thursday.

Posted by Marc Beacom on 17 May 2011

I agree!  All three groups have been doing great in getting some top notch speakers.  Thanks to you for sharing and giving back to the community!

Leave a Comment

Please register or log in to leave a comment.