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.
Third Tuesday (September 20)
Level 3 Communications
Title: SQL Programming: The Good, the Bad and the Ugly
Presenter: Victor Kushdilian
An insight into some common poor SQL development practices that can severely impact the performance of the database server. I will bring to light my experiences from 4 production SQL environments including some real examples with a focus on how to detect and avoid these practices.
Victor Kushdilian has over 20 years experience developing database applications starting with PL1/CICS/DB2 as an employee at IBM. Founded SportsWare, Inc in 1994 - a company developing and marketing desktop software for the fledgling fantasy sports market. As one of the founding businesses in the industry, designed, developed and sold The Commissioner series of fantasy sports software products using various database platforms including Foxpro, VB, Delphi.
Developed and launched one of the first commercially available web sites supporting fantasy leagues in 2001 using SQL Server 2000. Converted to a contract BI Developer in 2008 and have worked in 4 production SQL Server environments with the responsibilities that include design and development of complete database systems including functions/procs/jobs/schema, various SSIS packages, and complete SSRS reporting systems. I have successfully revamped 2 database systems to create highly scalable, high performance reporting solutions.
Currently working at Ball Manufacturing in Broomfield as a BI Developer and Analyst designing and developing a new data warehouse (SSAS) which will collect manufacturing metrics from 19 remote SQL Servers.
Title: "So You Are a New DBA - Now What?"
Presenter: Todd Kleinhans ( twitter )
In this presentation Todd will go over a recent client experience of being a new dba in an existing environment. It will be a mix of screenshots, some code, and audience participation.
Topics will include:
- Professional Conduct
- Immediate Concerns and Projects
- Getting Access to Systems
- Escalation Procedures
- Documentation - We Don't Need No Stinkin' Documentation!
- What Maintenance?
- Scheduling Changes and Maintenance
- Routines and Monitoring
- Optimization and Tuning
- Free Tools
Todd Kleinhans has been working with SQL Server since 1999. He has worked as a dba, developer, data architect, manager, and consultant. His current job is as a Senior SQL Server DBA consultant at Datavail.
Third Wednesday (September 21)
Title: “This is SQL Jeopardy!”
The category is “Colorado Springs SQL Server User Group”. The clue is “A thrilling, mettle-proving battleground of fun in which knowledge of SQL is proven amongst peers in 20 glorious minutes!” If you said “What is SQL Jeopardy?” you are absolutely right! Join our very own T-“Do Not Call Me Alex” SQL Princess in our first ever SQL Jeopardy as we set our members against one another to determine who will be crowned the SQL Jeopardy Champion!
Rebecca is currently a database administrator with six fun-filled years of experience in SQL Server administration and development. With a background in a variety of technologies, she possesses over twelve years of notable success in providing and implementing technology solutions in an assortment of industries including aerospace manufacturing, container shipping, and local government. Sometimes referred to as the “T-SQL Princess,” she is also the Vice President of Marketing for the Colorado Springs SQL Server User Group and an overall goofball.
Title: Devs are from Mars, Report Servers are from Venus
Do you remember what it was like to fall in love? Wasn't it wonderful? Lately it just hasn't been the same. You've been stuck in the same old routine, doing the same old charts and tables. Maybe Reporting Services doesn’t tell you what’s wrong. Maybe you're even thinking about seeing other reporting products (!) In this session, Doug will re-ignite your passion for RS by showing you how to design for better performance, explaining what RS has been trying to tell you through logs (but you haven't been listening), and demonstrating some new -- and easy -- tricks you may not have known RS can do. After this session, you'll want to spend some time alone with your new old flame.
Doug (MCTS) is a business intelligence, database, and sometimes ASP.NET/C# developer with ten years experience using Microsoft web and database products in the agriculture, insurance, taxonomy, and healthcare industries. He currently works for University Physicians, Inc. as a BI developer.Contact URL: http://www.douglane.net
Third Thursday (September 15)
Microsoft DTC Office
Title: PASS Summit 2011 Debrief
Presenter: DenverSQL Board Members (and more!) ( twitter )
Ever wonder what it's like to attend the PASS Summit? Did you want to attend but just couldn't get the boss to approve it? Do you attend the User Groups for free pizza? If you answered yes to at least one of these questions, you will love this month's meeting!
This year's PASS Summit has come and gone, growing by over 20% since last year. In order to shake up the traditional style, some of the DenverSQL Board Members (Marc Beacom ( blog | twitter ), Jason Horner ( blog | twitter ), Steve Wake ( blog | twitter ), Brandon Tucker), first-time PASS attendee Mike Fal ( blog | twitter ), and possibly more will be giving short, informal talks on their experience this year. Topics will include:
- Business Intelligence track
- DBA track
- The social side of PASS
- What it's like to attend PASS for the first time
- ...and more!
Please join us for these talks as well as an open forum/panel afterwards to discuss anything not covered. Have your questions ready...this will be your chance to get a feel for everything the PASS Summit has to offer!
Marc Beacom ...