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.
BoulderSQL
Third Tuesday
Level 3 Communications
Room 4LA-07
1025 Eldorado Blvd
Broomfield, CO 80021
Presenter: Scot Reagin ( web )– SJReagin & Associates
Having developed and delivered public and private training in the use of specific technologies (including DTS/Integration Services, Analysis Services, and MDX), best practice implementation strategies, and overall information architectural concepts, Scot is a respected speaker at business and technical conferences including TDWI, SQL Connections, Microsoft Tech-Ed, and PASS (Professional Association for SQL Server).
The presentation will cover Security/Dynamic Security, Backup/Recovery, and the automation of partition creation/processing.
SpringsSQL
Third Wednesday
Mr. Biggs
5825 Mark Dabling Boulevard
Colorado Springs, CO 80919
Presentation 1:
Presenter: Gabriel Villa ( blog | twitter )
Intro to "Denali" SQL Server Security
Get up to speed on the new security features in "Denali", the next version of SQL Server. Disclose the new permissions, roles and encryption added to Denali. You'll discover some commonly overlooked practices in securing your SQL Server databases. Learn about physical security, passwords, privileges and roles, and preventative best practices. I'll demonstrate auditing and .Net code samples to use on your applications to prevent vulnerabilities.
Originally from El Paso, Texas, Gabriel has over 10 years’ professional developer experience using Microsoft technologies. Gabriel is an MCPD, ASP.NET Developer and an MCTS in SQL Server 2008 Database Development. He has developed desktop, web and database systems for the medical, retail, imports distributors, and automotive industries. Gabriel recently moved with his wife and three kids to Colorado Springs, where he works for a small ISV developing software for the big-ticket retail industry.
Presentation 2:
Presenter: Chris Shaw ( blog | twitter )
Utility Databases
If you were asked what average runtime was of your slowest stored procedure, could you provide the answer? What if you needed to provide that information for last month? Do you review your error logs each day? Do you know the growth percentages of your databases for the past year or even the past month? If your database has an unusual growth event will you know about it? In the utility database that we create during this session we will track stored procedure information along with information about the hard drives such as free space. We will look at how you can have the errors in your error logs emailed to you each day. The goal of this session is to help you automate and centralize as many of your day-to-day tasks as you can.
Chris Shaw started his database career while in the Marine Corps working with Lotus Ami Pro databases somewhere in 1993. From there he went on to companies such as Wells Fargo, Pulte Mortgage and Yellow Pages Inc., and later consulted with insurance companies including Anthem Blue Shield. Chris has enjoyed writing and speaking about SQL Server over the last 10 years at events such as SQL Connections, Pass and SSWUG Ultimate conferences. Chris received the Microsoft MVP award.
DenverSQL
Third Thursday
Microsoft DTC Office
7579 Technology Way, Suite 400
Denver, CO 80237
Presenter: Chris Shaw ( blog | twitter )
Utility Databases
If you were asked what average runtime was of your slowest stored procedure, could you provide the answer? What if you needed to provide that information for last month? Do you review your error logs each day? Do you know the growth percentages of your databases for the past year or even the past month? If your database has an unusual growth event will you know about it? In the utility database that we create during this session we will track stored procedure information along with information about the hard drives such as free space. We will look at how you can have the errors in your error logs emailed to you each day. The goal of this session is to help you automate and centralize as many of your day-to-day tasks as you can.
Chris Shaw started his database career while in the Marine Corps working with Lotus Ami Pro databases somewhere in 1993. From there he went on to companies such as Wells Fargo, Pulte Mortgage and Yellow Pages Inc., and later consulted with insurance companies including Anthem Blue Shield. Chris has enjoyed writing and speaking about SQL Server over the last 10 years at events such as SQL Connections, Pass and SSWUG Ultimate conferences. Chris received the Microsoft MVP award.
