Blog Feed Info

This page provides an aggregate of feeds from Colorado SQL community members that blog about SQL Server.  If you live in Colorado and would like your fieed listed, please send us an email at and let us know.

ColoradoSQL Bloggers

Wednesday, July 30, 2014 3:54:35 AM
SQL Saturday is coming this weekend in Baton Rouge, LA and I’m presenting a full day pre-con on Friday on Predictive Analytics.  It’s a full day deep dive on how to start using Predictive Analytics in your organization, and ideal for people who are brand new to the field. What should you expect in a full day session […]
Sunday, July 27, 2014 4:02:32 PM
Thank you to everyone that attended my "Capture Change and Apply it with Change Data Capture and SSIS" session at Mile High Tech Con on Saturday. I have uploaded the zip file that has both the demo solutions and the slides.

Thanks to Marc Beacom and all of the other volunteers at the Mile High Tech Con, was a great event and glad that there will be another technical event here in the Denver area each year!
Wednesday, July 23, 2014 7:12:21 AM
I’m presenting a full day pre-con on Friday, August 1 in Baton Rouge, LA on titled Predictive Analytics in the Enterprise and there is still time to register!  You may have heard about predictive analytics and are wondering what it is all about, and this session will answer all your questions.  But it will also get you […]
Tuesday, July 22, 2014 1:44:19 PM
This is the week for something new – Mile High Tech Con.  The inaugural event conceived by Marc Beacom is being held this week from July 24-26 at the Auraria Campus in Denver, CO.  It’s a new conference with a unique format.  A day of all-day sessions on Thursday, another day of 90-120 minute deep […]
Tuesday, July 22, 2014 4:00:31 AM
When you become involved with the SQL community, you see a lot of great tools contributed to make life easier for the rest of us.  The function of these tools range greatly, from helping to analyze your system state, collect data about your enterprise, or performing regular maintenance.  I’ve used many of these tools over […]
Thursday, July 17, 2014 9:16:08 AM
Last week I had the privilege to speak at CodeStock in Knoxville, TN. I have to admit that I was not all that pleased at taking a red eye flight, but that is all on me. The city of Knoxville was nothing but a good experience. I found myself just amazed at how pretty that […]
Tuesday, July 15, 2014 3:09:54 AM

PASS SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Please note that in order to attend one of these event, you must register. Please register soon as seating is limited, and let friends and colleagues know about the event. Most events are free, however a nominal fee may be charged so that lunch may be provided (not pizza).

The post PASS SQL Saturday Events: August 2014 appeared first on DawaBI.

Wednesday, July 09, 2014 9:55:47 AM

Technical conferences have always been a great venue for networking and increasing my knowledge base. Mile High Tech Con will be no different. I would like to invite you to be part of the inaugural Mile High Tech Con which will be held July 24 -26 in Denver, Colorado. Mile High Tech Con will highlight innovative topics that will inspire strategic decision making while offering relationship building and networking. Here are the speakers and topics: There is still time to register and attend. You don’t want to miss it!

The post Will you be attending Mile High Tech Con? appeared first on DawaBI.

Tuesday, July 08, 2014 5:00:47 AM

I’ve always had issues writing a pivot in TSQL without going back to books-on-line to figure it out.  Maybe because I haven’t done it enough, but it always seems a bit convoluted.  That meant it was time to write about it and break it down so I could make sense of it.  Let’s set up the demo data first.  Based on the data I was working on pivoting I wrote up some simple demo data.  It has a name, objective and a result for the said objective.  It has one record per objective and the pivot should line up those objectives so there is one row per name instead of one row per objective.   DECLARE @BaseData table (   Name   varchar(10)   ,Objective  varchar(5)   ,Result   varchar(15)  )   INSERT @BaseData SELECT ‘Bob’,'Obj1′,’Complete’ UNION SELECT ‘Bob’,'Obj2′,’Pending’ UNION SELECT ‘Lisa’,'Obj1′,’Pending’ UNION SELECT ‘Lisa’,'Obj2′,’Pending’ UNION SELECT ‘Don’,'Obj1′,’Complete’ UNION SELECT ‘Seth’,'Obj1′,’Complete’ UNION SELECT ‘Seth’,'Obj2′,’Complete’ UNION […]

The post A Simple TSQL Pivot appeared first on DawaBI.

Tuesday, July 01, 2014 5:00:13 AM

Here is a helpful guide to go through when designing dashboards (before and after). These tip should help your dashboard design by improving the layout, functionality, and usability. 1) Avoid scrolling and/or multiple pages for a single dashboard. Anything more than 1 page is considered a report. The graphs and numbers should always be together, allowing the user to do quick analysis. 2) Choose the correct visualization. Take advantage of visualizations and graphs that allow the user to quickly associate patterns. a. Example 1: Avoid most gauges, what might work for a car’s dashboard won’t necessary work in a business. They take up space and say very little. b. Example 2: Pie charts with more than 4-6 items can make it hard to compare sizes of the slices. c. Example 3: Using text instead of a line chart; can give a better understanding of where the data is going. d. Example 4: Using a bar chart […]

The post Designing Dashboard Layouts – 15 Tips & Tricks appeared first on DawaBI.

Page 1 of 3 1 2 3 > >>