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
Warm-up Presentation
Transaction Basics
Paul Paiva
An overview of what transactions are all about. The following areas will be covered:
- What is a transaction?
- What is a distributed transaction?
- When should I use a transaction?
- How to use transactions during ad hoc work in the SSMS query window to safeguard against accidents.
Actual code samples will be presented and executed, live!
Paul Paiva has 16 years experience in virtually all aspects of Microsoft SQL Server. In these years he has worked in the roles of production DBA, database developer, database architect, applications developer, business intelligence and data warehouse developer, and instructor for students aspiring for MCDBA certification. He has performed numerous data migrations and supported large databases (3 Terabyte, 1+ billion rows) with high transactions. Presently he is an independent SQL Server consultant with CoCreative Solutions. He is a member of the Professional Association for SQL Server (PASS), blogs about lessons learned from a developer’s approach to SQL Server administration, and has been the co-president of the Boulder SQL Server Users’ Group for the past two years.
Main Presentation
Isn't That Spatial?
Jason Horner (twitter)
This presentation is a 1hr deep dive into 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.
SpringsSQL
Third Wednesday
Mr. Biggs
5825 Mark Dabling Boulevard
Colorado Springs, CO 80919
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
Managing SQL Server Permissions
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.
DenverSQL
Third Thursday
Microsoft DTC Office
7579 Technology Way, Suite 400
Denver, CO 80237
Warm-up Presentation
Securing Your Service Accounts
Brandon Tucker
"What are service accounts, and how do they affect me?" Everyone's asked it before, and some have never gotten the proper answers. Though it's unlikely to answer all the questions of the universe in this 30-minute presentation, we'll explore the security concerns with service accounts, pitfalls to avoid, and considerations to streamlining your SQL Server service accounts!
Over the past five years, Brandon has explored the SQL Server product as both a developer, administrator, and consultant. Starting in Salt Lake City, he translated his academic knowledge base into real-world scenarios in the health insurance, education, and transportation industries. Brandon has presented at Code Camps/User Groups in UT, as well as User Groups/SQL Saturdays here in Denver. On the side, Brandon casually DJs electronic music and enjoys disc golf, skiing, and beer. He currently holds a BS Computer Science from Neumont University (by way of Bucknell University) and an MCITP: Database Developer.
Main Presentation
SSIS Data Transformations
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.
Stunningly handsome yet surprisingly humble, Mike Sexton spent the first ten years of his career as a public defender in New York. Realizing he could make far more money as a junior programmer than as a lawyer with 10 years’ experience, he had a revelation, the words of which that are not appropriate for a family publication. Since then Mike has traveled the lands taming errant database applications, publishing and blogging at www.sqlmountain.com. He recently published Applied Architecture Patterns on the Microsoft Platform, which may be found at finer bookstores. Mike can be found living the high life in Colorado with a hot blonde on his arm.
