Marc Beacom, Author at DawaBI - Page 2 of 10


About Marc Beacom

Marc Beacom is President of DawaBI, a Data Warehouse and Business Intelligence Consultancy firm focusing on Making Data-Driven Decisions Possible. He has been working with SQL Server for over a decade delivering scalable solutions for organizations of all sizes. He has earned several industry certifications and degrees. Marc is an active member of the community and has served 5 years on the board of two Colorado SQL Server User Groups (Denver and Colorado Springs), 1 year as a Regional Mentor for PASS and is currently on the boards of two Colorado nonprofit organizations; Colorado GiveCamp and Camp To Belong Colorado.

PASS Virtual Chapter Events: June 2014


DateTimeTitle Link
June 11 12:00 MST PASS DBA Virtual Chapter: A Comedy of Errors sponsored by Dell Software
June 11 10:00 MST Whats New in Hyper-V 2012 R2
June 13 12:00 CST SQL 2014 Clustered Updatable Columnstore Indexes
June 17 11:00 UTC Rolling Upgrades, The Easy Way!
June 19 12:00 EST The Accidental Report Designer: Data Visualization Best Practices in SSRS
June 26  2:00 EST Workload Tuning with Distributed Replay

Colorado SQL Events for June 2014

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.


June 18th

Confio Software in Boulder
4772 Walnut Street, Suite 100
Boulder, CO 80301


The Life Cycle of a Query

Have you ever wondered what really happens behind the scenes when you execute a query? In this unique demonstration, Todd will use a video game engine (Unreal Development Kit) and will dramatically show The Life Cycle of a Query in 3D. We will follow a query from beginning to end and “run through” the various SQL Server components all queries must use including the Protocol Layer, Relational Engine, Storage Engine, Buffer Pool and then back out to the client. A volunteer at the end will then don an Oculus Rift Virtual Reality Headset for 3D Gaming and then race through the sections in under a minute to win a prize. Participants will leave with a better understanding of the major components and with a conceptual framework to explore the components more in-depth.


Todd Kleinhans  has been working with SQL Server since 1999. He has worked as a dba, developer, data architect, manager, and consultant. Todd has served in the past on the board of the Denver SQL Server User Group and is the current VP of Marketing. He enjoys presenting at user groups, virtual groups, and SQL Saturday events


Third Wednesday

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



Third Thursday

Microsoft DTC Office
7579 Technology Way, Suite 400
Denver, CO 80237


SQL 2014 In-Memory OLTP What, Why, and How

In-Memory OLTP is one of the most significant new features in the SQL Server 2014 release. In this session we will learn about the benefits of this new feature and how it works inside the SQL engine. We will touch on when it makes sense to use it, and most importantly learn how you can implement this new feature should you see the need in your environment.

Presenter: Andy Vold, Architect RevGen Partners

Andy Vold, a SQL Server MCSA, MCTS and MCITP, is an Architect with RevGen Partners working primarily in business intelligence, SSIS/ETL, and database development. He enjoys helping clients by building database and business intelligence solutions to solve their complex business needs. Andy is a past board member of the Denver SQL Server Users Group.

Northern Colorado

UNC Loveland Center at Centerra
2915 Rocky Mountain Ave.
Loveland, CO. 80538
Breckenridge Conference Room 2nd floor

PASS SQLSaturday Events: June 2014


June 7, 2014 SQLSaturday #307 – Iowa City 2014
June 7, 2014 SQLSaturday #294 – Philadelphia 2014
June 14, 2014 SQLSaturday #281 – Edinburgh – BI Edition 2014
June 14, 2014 SQLSaturday #316 – Christchurch 2014
June 14, 2014 SQLSaturday #288 – South Florida 2014
June 14, 2014 SQLSaturday #299 – Columbus 2014
June 17, 2014 SQLSaturday #321 – Cairo 2014
June 21, 2014 SQLSaturday #303 – Rochester 2014
June 21, 2014 SQLSaturday #286 – Louisville 2014
June 28, 2014 SQLSaturday #313 – Rheinland 2014
June 28, 2014 SQLSaturday #293 – Maine 2014
By |May 15th, 2014|PASS, SQLSaturday|

The Importance of Networking

In a survey conducted by Business Network SW, the organization found that 87% of businesses partake in some form of networking. The reasons why these individuals felt networking was important varies, but the top three reasons building relationships, looking for new opportunities and business development. Whatever the reason behind choosing to network with other business owners, being around like-minded individuals can help bring about new ideas, offer different ways to implement processes and even result in a few collaborations or new business.

 Where to Network

Finding the time and opportunity to network with other businesses can be a challenge. Conferences are one place where you can come together with people learning about a topic you’re all interested in. For example, at local user group meetings or a conference such as the Mile High Tech Con which will run July 24-26. This is a great opportunity not only to learn more about BI, but to connect with other business professionals.networking

Social media is another good place to connect with others. Participate in blogs, join a group on Facebook or follow complimentary businesses on Twitter.

 How to Network

The business world is made up of people with all different types of personalities. While some are extroverts and find it easy to strike up a conversation with someone new, others are introverts and may find it more difficult to exchange information. One thing that can help both types of personalities is having a prepared couple of sentences that explains who you are and what your company does. While you will want to give it your own personal spin, here is a simple formula you can use.

I am (fill in your name here), the (your role in the company) from (your company). We make/produce/offer (product or service). + Something truly unique.

Having this statement in mind ahead of time will help you avoid a lot of awkwardness. Hopefully the conversation will flow naturally from there. If not, there are always the throw back topics.

  • Where are you from?
  • What are your hobbies?
  • Do you have a family?
  • Do you like to travel? Have you been anywhere recently?

The key is to listen to what the other person is saying and make a connection on a personal level. They will remember you far longer than if you spend the entire time talking about yourself.

Other Tips to Make Your Networking Successful

Once you’ve made a connection, be sure to exchange business cards. Take a minute to jot down a few notes on the back of the card about the conversation you just had with this person. Does he have a Yorkie that he adores? Do you know the dog’s name? Does he like to travel and just returned from Italy? This is important, because when you get home, you’re going to contact each of the people you made a connection with. You’ll want to send them a personal email or letter.

The letter should read something like this:

Dear Jack,

I enjoyed meeting you at the Pass Summit last week. Your Yorkie Samantha sounds like quite a character. I hope she enjoyed the dog toy you brought her home from Italy.

I was thinking about our two companies and how we are similar and realized we might be able to work together on ________.

I would love to set up a time for a conference call so we can discuss this idea further.

Again, it was good to meet you.

Kind regards,

Jane Smith

With this type of connection, you’ll be more likely to gain a trusted business ally who will work with you for years to come.

Why Network?

Networking gives you an opportunity to meet people who don’t normally run in your social or business circles. This in turn brings in fresh ideas and additional contacts you might not otherwise have had. For example, Jack and Jane may decide to endorse one another’s products to their current clients as they are not in competition with one another. Networking has a way of snowballing. You meet one new person, who introduces you to another and so on. It is an excellent way to grow your business and build your professional reputation.


I had the pleasure and opportunity to meet Don Gabor several years back at a Pass Summit in Seattle. Don is a master at the art of starting conversations and networking. Visit his site at to learn more about him and several of his resources.

By |May 8th, 2014|Networking|

Colorado SQL Events for May 2014

SQL Meetings are training events for SQL Server professionals and those wanting to learn about SQL Server.

Tuesday, May 6, 2014 Denver SQL Lunch
Wednesday, May 21, 2014 Boulder Policy-Based Management by Tom Norman
Tuesday, May 20, 2014 Northern Colorado Evening Meeting
Wednesday, May 21, 2014 Colorado Springs Evening Meeting

PASS SQLSaturday Events: May 2014


Date Event
May 3, 2014 SQLSaturday #285 - Atlanta 2014
May 3, 2014 SQLSaturday #305 - Dallas - BA Edition 2014
May 10, 2014 SQLSaturday #308 - Houston 2014
May 10, 2014 SQLSaturday #298 - Jacksonville 2014
May 17, 2014 SQLSaturday #292 - Detroit 2014
May 31, 2014 SQLSaturday #306 - Redmond 2014

View future events on the SQLSaturday website.

By |April 15th, 2014|PASS, SQLSaturday|

Colorado SQL Events for April 2014

Tuesday, April 1, 2014 Denver SQL Lunch
Tuesday, April 15, 2014 Boulder Taking your Skills to the Next Level by Doug Brendle
Tuesday, April 15, 2014 Northern Colorado Evening Meeting

PASS SQLSaturday Events: April 2014


Date Event
April 5, 2014 SQLSaturday #296 - Melbourne 2014
April 5, 2014 SQLSaturday #295 - Las Vegas 2014
April 12, 2014 SQLSaturday #283 - Puerto Rico 2014
April 12, 2014 SQLSaturday #297 - Colorado Springs 2014
April 12, 2014 SQLSaturday #267 - Lisbon 2014
April 26, 2014 SQLSaturday #270 - Krasnodar 2014
April 26, 2014 SQLSaturday #284 - Porto Alegre 2014
April 26, 2014 SQLSaturday #282 - Costa Rica 2014
April 26, 2014 SQLSaturday #291 - Chicago 2014
April 26, 2014 SQLSaturday #289 - Orange County, CA 2014
View future events on the SQLSaturday website.
By |March 15th, 2014|PASS, SQLSaturday|

Colorado SQL Events for March 2014

Tuesday,March 4, 2014 Denver SQL Lunch
Tuesday, March 18, 2014 Boulder Advanced Spatial Analysis: Beyond Bubble Charts by Jason Horner
Monday, March 17, 2014 Northern Colorado
Wednesday, March 19, 2014 Colorado Springs

PASS SQLSaturday Events: March 2014

DateEvent March 1, 2014SQLSaturday #278 – Budapest 2014 March 1, 2014SQLSaturday #268 – Connecticut 2014 March 6, 2014SQLSaturday #280 – Vienna 2014 March 15, 2014SQLSaturday #276 – Silicon Valley 2014 March 22, 2014SQLSaturday #269 – Exeter 2014 March 22, 2014SQLSaturday #277 – Richmond 2014 March 29, 2014SQLSaturday #275 – Copenhagen 2014 March 29, 2014SQLSaturday #262 – Boston 2014 March 29, 2014SQLSaturday #287 – Madison 2014 March 29, 2014SQLSaturday #279 – Phoenix 2014
View future events on the SQLSaturday website.
By |February 18th, 2014|PASS, SQLSaturday|