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 info@coloradosql.org and let us know.

ColoradoSQL Bloggers

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.

Monday, June 30, 2014 8:18:35 AM
My speaking calendar is really filling up! :)

I have been selected to speak at the Mile High Tech Con that will be held on July 24-26 at the Auraria Campus in Denver, Colorado! I will be presenting "Capture Change and Apply it With Change Data Capture & SSIS" on Saturday, July 26 @ 1pm. This is the first time this event has been put on in Denver and has 3 days of great content, Thursday and Friday are paid, longer sessions and Saturday is all free sessions. If you are in Denver that week, please check it out and if you use the promo code 14SK_SteveWake when you register for Thursday and/or Friday and save some money!

Looking forward to seeing everyone at this event in a few weeks!
Friday, June 27, 2014 9:15:15 AM

Using the basic group-by in a T-SQL query is very common when dealing with grouping, but there is one other option that often gets overlooked. In SQL-Server, you can also do multiple grouping sets, by grouping on different sets of fields. The benefits, a more efficient and all-in-one query; versus doing separate individual, group-by, queries put together via a union. Here is a basic example of using grouping sets on the Adventure Works database. SELECT [CustomerID] ,TerritoryID ,SUM([SubTotal]) AS TotalSpent FROM [AdventureWorks2012].[Sales].[SalesOrderHeader] GROUP BY GROUPING SETS ( (CustomerID), (TerritoryID), () ) ORDER BY TotalSpent desc; In this query, we are doing three types of grouping, on CustmerID, TerritoryID, and empty group. The results of the query: Each of the groups are distinguishable by null values, used as placeholders in the columns that are not used in the set. • CustomerID – Gives the total spent per customer, with null value in […]

The post WRITING QUERIES WITH MULTIPLE GROUPING SETS appeared first on DawaBI.

Wednesday, June 25, 2014 12:36:17 PM
John Morehouse and I were sitting around during a recent SQL Saturday talking about what experiences we learn the most from and how we can use that to help us when we are speaking at an event of some sort. We found that being able to relate the topic that we were teaching back […]
Wednesday, June 25, 2014 5:00:51 AM
I am honored and thrilled to announce that I was selected for the 2nd year in a row to present a session at the PASS Summit! PASS Summit is an annual conference put on by PASS (Professional Association of SQL Server) with thousands of attendees from across the world, this year it is being held on November 4 - 7 in Seattle, WA. There will be over 200 different sessions presented by speakers from the community and Microsoft on a wide range of SQL Server topics in 5 different tracks. If you are interested in attending, please use this link to register and be sure to use the code UNSUMF59 when you register to get $150 off your registration fee (if you use it by this Friday 6/27 you will save a total of $450 off the full registration fee).

I will be doing a Lightning Talk (short 10 minute presentation) titled "What Version of SSDT do I Need?", which is a small part of the "Building a Better Workstation" presentation that I have already presented a couple of times. I'm sure that it will be a fun session as there are currently a lot of questions/issues with what versions of SSDT work with what in each version of SQL Server.

Looking forward to seeing everyone in Seattle in November!
Thursday, June 19, 2014 6:33:24 AM
Last Thursday evening I had the pleasure to present virtually to the BIG PASS group in Irvine, CA. BIG PASS is run by Mickey Stuewe (blog | Twitter) whom I have meet at the last 2 PASS Summits and multiple other PASS events over the years, was a great time presenting to the group and would love to do it again in the future. I presented my "Building a Better Workstation" session for the first time and to be honest it ran longer than I expected, just so much good stuff to talk about and some great questions from the audience as well. As promised, below is a link to download the slides for this presentation so that you can use all of the links provided in the slides.


Next week will be very busy for me! On Wednesday evening I will be doing presentation for the Denver .NET User Group called "Business Intelligence for the .NET Developer". Looking forward to talking to this group and talking about how my career changed from being a .NET Developer to a BI Consultant and how I think others could do the same (if they want to). If you are in the downtown Denver area on Wednesday evening around 5:30pm MT, please register and stop by!

Update: 6/19/2014 - Thanks to those that attended the Denver .NET group last night, below are the slides from that presentation:


On Thursday morning I will be doing the FREE Pragmatic Works webinar series "Training on the T's" again @ 9am MT/11am ET. I will be presenting the "Building a Better Workstation" session and try my best to get it into the 45 minute timeframe! This is a free webinar, so register here if you are available at 9am MT/11am ET on Thursday. If you can't attend at that time there will be a recording of the whole session posted at a later time and I will update this post with that link once it is available. Looking forward to doing another session for this great series!

Update 6/19/2014 - Thanks to everyone that attended my Pragmatic Works "Training on the T's" session "Building a Better Workstation" the slides are the same as in the first attachment above in this post, so feel free to download them. The video link for this should be posted in the next few days, I'll post that link here as soon as I get it.

Then on Thursday evening will be the Denver SQL Server User Group June meeting at 5:30pm MT in the Microsoft DTC office (7595 Technology Way, Suite 400, Denver, CO 80237). Andy Vold (Twitter) will be presenting "SQL 2014 In-Memory OLTP – What, Why, and How" and Chris Shaw (blog | Twitter) will be presenting "What is the Best Disaster Recovery Solution?". For more details on both of these sessions and our group, please go to denversql.org. All of our meetings are FREE and we try to make as much time for networking as possible at every meeting.

Friday I'm planning on attending my first TDWI meeting at the June Denver meeting. Should be a good meeting with Laura Reeves presenting "Data: The Real Power Behind Today’s Technology". If you are interested in attending this meeting on Friday from 1pm - 4pm MT at Innovation Pavilion (9200 E Mineral Ave, Centennial, CO 80112) make sure you register at this link for this FREE event.

Overall a very busy week for me, but that is way better than just sitting around bored! :)
Page 1 of 3 1 2 3 > >>