Community Archives - DawaBI


ColoradoSQL for March 2012

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

(Location has moved please see website at for more info)


Presentation 1:

Title: Smart Coding for Addressing Index Fragmentation

Rather than simply running pre-formed maintenance plans that may have unexpected results, learn to write smart code code that assess which tables have indexes that need to be rebuilt, then judiciously decide which ones to target, and optionally automate this process.

Level: Beginner to Intermediate, for both DBAs and Developers

Presentation will include.

What tables are indexed?

What columns does table X have indexed?

Are there any included columns in the indexes?

– Write scripts for judiciously rebuilding indexes based on your criteria of table size (rows or bytes) and fragmentation level.


Presenter: Paul Paiva ( blog )

Paul Paiva has 16 years’ experience with Microsoft SQL Server. 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 three years.



Third Wednesday

Hyatt Place Garden of the Gods

503 West Garden of the Gods Road
Colorado Springs, CO 80919

Presentation 1:

Title: Oracle for the SQL Server DBA

Are you curious about Oracle, but afraid to admit it? It is common for many DBA’s to be biased to one database platform, but it has become more and more demanding of the database administrator to manage and have a firm knowledge of more than one in many environments. This session will introduce the SQL Server DBA to Oracle in a way that will meet their day to day challenges in a multi-platform database environment. Come learn about how Oracle and SQL Server are very similar, different and how to translate common concepts in SQL Server to Oracle database administration. No prior experience in Oracle is required and important features and concepts will be covered to assist the SQL Server DBA in incorporating Oracle into their database skill set.


Presenter: Kellyn Pot’vin

Kellyn Pot’vin, (pronounced Poet-Vaughn) has been a database administrator for over eleven years, a new Oracle ACE, specializing in large database performance tuning. In the last year, she’s been working with large SSD databases and Exadata, taking advantage of the newest technology and performance tuning features. Kellyn is known for her technical blog,, and is a member of the board of directors for Rocky Mountain Oracle Users Group, (RMOUG). She’s performed numerous presentations on performance tuning and written articles for various technical newsletters and Web sites, starting out as an active participant on the Oracle-L list. She currently contributes to several technical sites and publications, including ITNewsCast and OraDBPedia. Kellyn lives with her three children in Broomfield, CO, and currently is honing her technical skills at I-behavior, a marketing firm in Louisville, CO.


Presentation 2:

Title: What is the Best Disaster Recovery Solution

Case Study Get ready to work through a real world problem, we are going to spend this session reviewing a company and the challenges they faced when it comes to Disaster Recovery. Once we have a good handle on the challenges they have, we will talk through what the solution for them would be. Consider this a follow up to last month’s meeting. Take a few minutes to download and review some of the specifics on this company.

Presenter: Chris Shaw ( blog | twitter )



Third Thursday

Microsoft DTC Office

7579 Technology Way, Suite 400
Denver, CO 80237


Presentation 1:

Title: Big Data

Why is Big Data such a hot topic these days? Is there anything different at the conceptual level than what we are doing with data today? What is Microsoft’s offering in the Big Data space? Why is a guy from the SQL Server product team talking to us about noSql concepts and open source products?


Presenter: Kevin Cox ( web | twitter )

Kevin Cox has been working with databases for over 35 years and with SQL Server for more than 25 years. He is an author, lecturer and mentor in database subjects. Kevin is currently with the Microsoft SQL Server product group in the Customer Advisory Team and feels fortunate to be able to work on the largest projects around the world.

By |March 15th, 2012|Uncategorized|

Announcing the fourth certification study session

The Denver SQL Server User Group is starting another round for the certification study group. Last year we ran three sessions with each focusing in on a specific subject area (DBA, Dev, BI). For the next session starting next week, we thought we would try a general study session and allow for anyone wanting to study for any of the exams to participate.

Please send an email to so that we can add you to an email list. We’ll use this list to send any updates as they relate to the certification study group. Several of you have already sent us an email expressing your interest and have been added to the list so no need to send a second email. We can get your email address at Monday’s meeting if you don’t respond.

The Concept

The concept of the study sessions is to assist you in your path to passing the Microsoft SQL Server certifications. The core of this is self-study utilizing the training kits and other resources you have available. We’ll meet in person on a regular basis (once a week or so) to discuss any questions or concepts to better strengthen your understanding of the materials. The duration of the study session will last 6 weeks.

First Meeting Details

If you are interested, we will be meeting Monday April 25 at 6:30 pm at Chipotle on Arapahoe Road just west of I-25 for the first meeting. We will discuss future meetings and a study plan.

Chipotle – MAP

8547 E Arapahoe Rd. Greenwood Village, CO 80112

Phone 303.488.2002

Helpful Links

Below are links to additional information and study materials for the different tests. Here is information on special offers Microsoft has through June 30, 2011. To ask any questions to the group, the user group forms can be found at the following links: BIDev, and DBA.

Study Materials

Microsoft Certified Technology Specialist (MCTS)

BI 70-448 Materials TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance

DEV 70-433 Materials TS: Microsoft SQL Server 2008, Database Development

DBA 70-432 Materials TS: Microsoft SQL Server 2008, Implementation and Maintenance

Microsoft Certified IT Professional

BI 70-452 Materials PRO: Designing a Business Intelligence Infrastructure Using Microsoft SQL Server 2008

DEV 70-451 Materials PRO: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008

DBA 70-450 Materials PRO: Designing, Optimizing and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008

By |April 23rd, 2011|Uncategorized|

SQLSaturday #52 – Colorado Details


What is SQL Saturday?

SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Admittance to this event is free.  If you wish to have lunch with us there is a $10 lunch fee.  All other costs are covered by donations and sponsorships. Please register soon as seating is limited.  Please also let friends and colleagues know about the event.

When and Where?

SQL Saturday #52 Colorado is September 25, 2010 at the Cherry Creek Presbyterian Church 10150 E. Belleview Avenue Englewood, CO 80111.

Who is Presenting and what is the Schedule?

We have 36 sessions being presented by 25 local and national SQL Server Professionals.  The topics range from Business Intelligence, Database Administration, Database Development and Professional Development.  The schedule can be viewed here:


Special Presentation: We are honored to host a special lunch time presentation by Steve Jones, founder and editor, co-founder of and SQL Share, SQL Server MVP along with a host of other credits and community contributions.  Something you won’t want to miss out on.

Food Drive

SQL Saturday #52 Colorado is a community event.  All organizers and speakers are all volunteers giving their time to give back to the community.  We volunteer for any number of reasons but most important, we volunteer to help others.  At SQL Saturday #52 Colorado, you can also give back to the local community.  We will be accepting food donations that will be distributed to local food banks as well as help the victims of the Boulder fire.  Food donations will be collected in the morning during event check-in.  Those that bring a food donation to SQL Saturday #52 Colorado will be entered into a separate drawing that will be held during lunch.

Where can I register?

Event registration is now open at:

Thanks to our sponsors for making this event possible!




By |September 12th, 2010|Uncategorized|

Denver SQL Server User Group Board Meeting Notes from 20090901


To address a few questions on what does the board actually do and to bring more visibility to all of the members plus non-members, I thought I’d write-up some notes from last weeks board meeting.  We are always looking for feedback as to what you think is not working, or maybe what is so we can focus more on it. Please let us know any thoughts; good or bad.


The board typically meets once a month on the first Tuesday.  A few days prior to the meeting we will email each other different agenda items to be discussed.


Last weeks notes are as follows:

  1. Group Sponsorship
    1. Given that we are a non profit organization with no real revenue stream, we rely heavily on our sponsors.  Our main swag source has put a freeze on anything new until further notice.  Therefore, we will need to start looking for some additional sources.  We will draft up some letters and start sending them out to potential new sponsors.  We’ve heard from several members that having the possibility of bring home some type of swag is always nice.
  1. Speakers
    1. Speakers are a large part of the user group and we’ve now gone to hosting two presentations at our regular meetings.  The two presentations, we aim to have an intro level topic for 30 minutes and then a 60 minute more advanced topic.   Tracking down quality speakers and getting them scheduled is a never ending job.  It seems that the stream of speakers always fluctuates throughout the year.  We are back to only having scheduled speakers for the next meeting.   We all will be searching for speakers.
    2. We discussed a topic idea that was suggested by a member around job hunting and the current market conditions.  We’ve had one Professional Development topic recently which was presented by Steve Jones on “Ways To Build Your Brand“.  We had a lot of great feedback from this presentation.  Given the member feedback, we will look at hosting another PD topic in the near future.  A rough guide for PD topics maybe 1 30 minute and 1 60 minute presentation in a year.
  1. Certification Study Group
    1. Chris Randall has been working with different vendors and sponsors on this regard.  For this initial study session, the idea is to focus on the Administration exams.  The bulk of the studying will be self study with a cram session on a Saturday (tentatively set for Nov. 14).  We will then take the exam as a group afterwards. We will take the feedback and our experiences with this initial session and refocus for a second.  The second session will focus on the Developer exam targeted for February.   We’ll then repeat this for the BI exam in April.
  1. Lab
    1. The hope and idea of the labs is to provide some additional hands on time with SQL Server while others around to help out.  We discussed the logistics and timing of this event and thought for the initial go or two that it would work out best to hold the labs the same date as the Certification Study Group sessions.  We realize that there maybe some conflict for folks that would like to attend both the Certification Study Group along with the Lab but hope this number will be relatively low.  We will take all feedback into consideration for future labs to improve the offering and value.
  1. SQLSaturday Denver
    1. The board, earlier this year,  discussed holding some sort of larger community event.  We all thought this was a great idea but wanted to focus on getting a certification study group and lab up and running first.  This summer,Steve Jones a co-founder of SQLSaturday, approached us about holding an event here in Denver.  We’ve had an initial discussion with the organizers of the Tech Tri-Fecta about merging a SQLSaturday with their event and all thought it was a great idea.  Our tentative aim is February for this combined event.  We are still seeking a facility to host this event.
  1. Mentors
    1. A member sent us an email a short time ago seeking information or if we offer any type of mentoring program.  This member is relatively new to SQL Server and is lacking real world experiences.  The board thought this was a great idea and we will roll out an initial offering shortly.  We thought the role we could play best, at least initially, would to be facilitators and connecting different members.
  1. Member Recruitment
    1. Getting new members along with increasing attendance rates at meetings helps for several reason.
      1. The more members we have the more diverse the knowledge pool becomes.  With more members, we have a broad range of backgrounds to potentially share by way of speaking, answering questions on the forums or at the meetings and potentially more mentors.
      2. The more members we get along with more folks showing up for meetings, the higher probability of attracting more sponsorship. Sponsorship of course helps with the food and refreshments that are offered at the meetings along with more swag.
      3. So, we are working on sending out targeted mailings to local colleges and universities. Some of which maybe great resources for hosting a SQLSaturday event.
  1. Board Elections
    1. In order to keep some fluidity after the elections three board positions were setup to have elections on the odd years with the other two the even years.  This way the entire board doesn’t have the potential to rotate out and the new board left trying to keep the momentum.  The elections are typically held in November and the re-elected or new board member starts officially the first of the year.  On the occasion that a sitting board member decides to step down, we may hold out of cycle elections. This year the following three positions are up for election:
      1. President – Term 2010 – 2011
      2. VP Marketing – Term 2010 – 2011
      3. Treasurer –  Term 2010 – 2011
  1. December Meeting
    1. This is always a debate as to if we should hold the meeting or not and if so, do we hold a typical meeting or something fun.  We’ve not yet decided but please let us know your thoughts.
  1. Book reviews
    1. We’ve had a few questions recently with regards to what has happened to the book review program that was recently started.  We’ve had a good initial response from this program.  Unfortunately, the major book publishers we were working with have stopped sending books.  We have and will continue to follow-up with these publishers as well as reach out to others.
    2. UPDATE: Wrox ROCKS!  Wiley publishing delivered to the group several books for review.  Thanks Wiley!



By |September 10th, 2009|Uncategorized|

Denver SQL Server User Group Meeting – Tonight (20090219)!

Denver SQL Server User Group:

A Biking Buddy Adventure Works hospitality report.  Always have something in common to talk about with a biking buddy that is a palatable drive from your zip code.

Thursday February 19, 2009


Ever want to bike with someone but would like to have something in common to talk about?  And, with the flaky gas prices would rather drive within your own comfort area to meet up with your biking buddy?  Come see this Adventure Works hospitality report was created.  See how Adventure Works has extended its offerings to pair up bike riders with like demographics and within customer acceptable driving distance.  This report leverages Dundas charts, Spatial Data types, Data Mining, and Virtual Earth REST interface to create a powerful hospitality solution to Adventure works customers interested in participating in a Biking Buddy program.


David Gollob David Gollob is a long time Microsoft Consulting Services (MCS) veteran.He started at Microsoft in Dec ’96 as a Principal Consultant specializing in database architecture, particularly high volume OLTP systems.He came from Sybase (Colorado and Switzerland) and prior to that many years as an independent consultant helping customers architect mission critical database systems.Dave’s accomplishments in his past technical career included three patents in: Data Directory Services, High Volume Billing Processing, and Data Distribution Design approaches.Dave has had a highly decorated career at Microsoft; particularly in MCS (Rocky Mountain District and the Communications Sector).When not bolstering his technical passions; Dave savors his time with his kids.Outside family and work; Dave loves skiing, mountain biking, fly fishing, and oil painting.

7595 Technology Way
Suite 400
Denver, CO 80237
Directions to Microsoft

Typical Meeting Agenda:
5:30 – 6:00 – Food / Socializing

6:00 – 6:10 – User Group Business

6:10 – 6:30 – Vendor / Open Panel

6:30 – 8:00 – Main Presentation

8:00 – 8:30 – Give Away / Wrap-Up

Pass it on: 

If you feel that a friend or colleague would benefit from our user group, please feel free to forward on this notice.  If you received this notice from a friend or colleague, please consider becoming a member of our user group.  There are no dues to membership but you will have the added benefits of receiving event reminders and attendance to members only meetings.  Becoming a member is quick and painless, simply go to the membership section of the user group web site which and complete the form.  That’s it!


Meeting Sponsor:        

TEKsystems, Inc.

Host Sponsor: 



By |February 19th, 2009|Uncategorized|

Congratulations to Glenn Berry – SQL Server MVP

I just leaned today that Glenn Berry has had his MVP award renewed for another year.  If you have not read his weblog, I’d highly recommend checking it out at  Besides the informative information he blogs about, he is also a very active member in the community and presents for the local SQL Server User Groups.

Congratulations Glenn!  Well deserved.

By |July 27th, 2008|Uncategorized|