All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend so bring a co-worker…or two. These events provide for great learning opportunities as well as networking with other local SQL Server professionals.
Level 3 Communications
Title: Eating the Elephant: SQL Server Table Partitioning
Is your table fat? Do you need to manage a table that has billions of rows within it and are overwhelmed by index rebuilds that take more than 12 hours? SQL Server's table partitioning gives the DBA the tools to manage this beast and support very large tables in a way where index management and data retrieval does not become unwieldy. This presentation will take you step by step through choosing an appropriate partitioning key, setting up the partitioning on the table, and finally maintaining the partitions.
Mike Fal is a musician turned SQL Server DBA, with 10+ years of experience along with some brief excursions into Oracle and Netezza. He has worked for several different industries, including healthcare, software development, marketing, and manufacturing and has experience supporting databases from 1 GB to 4 TB in size. Mike received his Bachelor's Degree from the University of Colorado at Boulder in 1996 and has been caught playing trombone in public on more than one occasion.
No meeting as they hosted SQL Saturday #104
Microsoft DTC Office
Title: TDE, oh what fun! Auditing, no!!
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.
I need to install TDE, what do I do? Move the database to other server, can I do that? I used certificates, can I change them. I don’t like governments making me do all this stuff, it complicates my database. What does TDE do to my backups? Can I remove it? Auditing, no, let’s run for the hills. Let’s see how Sql Server can help us with these issues.
Presenter: Tom Norman
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 has just finished upgrading several products to Sql Server 2008 R2 on VMware while putting them on a new SAN and bringing them into PCI compliance. Tom is the past President of the Denver SQL Server User Group and actively speaks at SQL Saturday events and local events.
Marc Beacom ...