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 22, 2015 4:00:57 AM
Last week, as part of T-SQL Tuesday 68, I introduced you to two Powershell functions for validating and setting your SQL Server configurations. While useful, they depend on some sort of configuration source, which begs the question: How do we get this source? This post covers the third function that will help you create your […]
Tuesday, July 14, 2015 3:00:27 AM
Welcome to another month of T-SQL Tuesday, started by Adam Machanic(@adammachanic) and hosted this month by Andy Yun(@SqlBek). The topic for this month’s blog party is “Just say ‘NO’ to defaults!”, a call on what we have learned and how we manage SQL Server defaults in our environments. While you will probably find lots of […]
Friday, July 10, 2015 6:49:32 AM
This is a short break from my usual blog posts to share some information on upcoming presentations I’m giving that might interest you. Performance Palooza – Virtual Performance Chapter Coming up in two weeks (July 23), I’ll be part of the annual Performance Palooza that is run by the Performance PASS Virtual Chapter. I’m pretty excited, as […]
Friday, July 10, 2015 5:47:12 AM
Microsoft has announced this morning the General Availability date for the new Power BI as July 24th! I had a feeling the announcement was coming after the stability of the last couple of monthly updates was so good and that Power BI Designer did not get it's normal monthly update in June.

Power BI Designer is going to be renamed to Power BI Desktop and they have opened up a GitHub project to open source some of the visualizations and allow for more to be developed by the community! Looks like support for Excel is going to work through Excel Online for now, not sure what this means for the existing Excel add-ons. Also for those of you that missed it the Android Power BI app is also now available!

With this GA release it will finally move out of preview and I assume they will start to charge for the Pro level. Looking forward to this moving out of beta and seeing how everyone starts to use it!
Thursday, July 09, 2015 6:58:07 AM
Contrary to popular belief, it’s not all about Powershell for me. Yeah, I do a lot with it and want to share that knowledge, but I’m still a SQL Server DBA and there are many challenges I encounter day to day where I use my other skills. Policy Based Management(PBM) is one of those areas […]
Sunday, July 05, 2015 7:38:53 AM
All of the recordings for 24 Hours of PASS: Growing Our Community sessions are now available! I was honored to be selected for this event and you can get to the slides and recording for my "Introduction to the Power BI Designer" session using this link. Thanks to the team at PASS for going a great job editing out the technical difficulties that happened in this session, I had to look at it a couple of times to find the break, so they did a great job fixing that.

There were many good questions that I answered most of them at the end of the session, but there was one that I didn't know the answer to at the time, which was what version of the SAP Business Objects Universe does Power BI Designer/Power BI work with. I found this support article that lists SAP Business Objects BI 4.1 SP2 or higher as the version that the current Power Query for Excel supports, which I would assume is the same for the Power BI Designer and I also found this blog post along with this video on YouTube that demos this connectivity with the existing Power Query for Excel.

That was the only unanswered question that I know about from the session, if any of you have other questions after watching the session, please feel free to send me an email or just post it in the comments below.

Thanks again and I hope to see you at the PASS Summit 2015 in Seattle on 10/27 - 10/30. Don't forget to use the discount code LC15WTG2 when you register to save $150 off the current price!

Oh and one more thing for tonight's Women's World Cup final, GO USA! :)
Wednesday, July 01, 2015 4:58:02 AM
Over the last two posts, I’ve covered what the SQLPS provider is and how you can get started with it. Now it’s time for other side of the story. If you’ve started working with the provider or done some reading on the web, various hurdles have probably popped up. These hurdles can frustrate and discourage […]
Friday, June 26, 2015 5:32:56 AM
Glad that I had a full 2 week vacation before this week! Amazing what can happen in one week.

Week started off with accepting an offer for a new job at Chipotle! Looking forward to using all of my SQL BI knowledge to help them out. It has been a great run at RevGen Partners and I appreciate all of the help and support I have received over the last year there. I'll miss all of the friends that I know there, but the good thing is I'm staying in Denver, so I'm sure I'll run into them many times in the future.

Many have asked why I decided to move away from consulting and the only thing that I can say is that I realized that I really want to see how the decisions and changes that I make will go over a much longer period of time. Maybe I'm getting old, but I just started to feel like I wanted to see things over the long term, not just for the next few weeks/months. I really enjoyed that in my time at Visa where I got to see a decision that I had a lot of influence in turn into something much bigger than I ever would have hoped, but it took time and patience to see that happen. I see a lot of great potential for that at Chipotle and I am looking forward to the challenge of Retail/Food Service which I have not worked in since High School (yay Pizza Hut New Haven)! Thankfully for all of you I'll be in the HQ buildings, not in the kitchen. ;)

Next thing this week was my 24 Hours of PASS: Growing our Community presentation "Introduction to the Power BI Designer" on Wednesday afternoon. I was very well prepared and ready for it, once we opened it up I was happy to see over 200 attendees in the opening minutes. Then the strangest thing that I have seen with GoTo Meeting happened when the whole session came to an end for everyone about 15 minutes in. After my initial panic of trying to figure out what to do I just clicked on the email link and sure enough it was back up and working fine. Lost some attendees, but still had over 150 when it was back up and running again and I only lost a few minutes. Session went well and there were lots of good questions at the end, wish I could answer all of the when/what type questions, but that is all part of doing a presentation on a beta product that we don't know everything about yet. Stay tuned to this space for a link to the video once it is posted next week and I'll answer any questions that we didn't get to at the end of the session.

Then on Thursday night I got the email that I didn't think I was going to get until later on Friday. After 4 attempts I'll be speaking at PASS Summit 2015 in a regular session slot! I was jumping for joy last night when I got the email and had to read it 4 times just to make sure. I know that there is a lot of controversy in the SQL Community about the selection process for PASS Summit, but I have been a Program Committee Volunteer for 3 years in a row now and I know that it has gotten better over those years and has helped me understand what it takes to put something like this on (along with organizing 4 SQLSaturdays). So, in October I'll be presenting my "Date Dimension: Past & Future in One Script" session, which is definitely one of my favorite sessions that I have done many times over the last couple of years. The cool thing is that this presentation came from a Lightning Talk that I did at PASS Summit 2013 (my first time speaking at a PASS Summit). Just goes to show you what patience and experience can do. I'll also be doing another Lightning Talk at PASS Summit 2015 on "Power BI Designer: Nothing to Dashboard in 10 Minutes!". Looking forward to putting this one together since it should be a lot of fun and for those doubters out there I will even be able to show how to do at least 2 dashboards in 10 minutes! :)  If you have not yet registered for PASS Summit 2015, please click on this link and use the discount code LC15WTG2 to get $150 off!

And not to get too political or anything, but the week was topped off with the SCOTUS gay marriage decision, which my response is: "It's about time!". Way to go SCOTUS, very proud to be an American today!

Looking forward to the US Women's World Cup game tonight against China and relaxing a bit over this weekend, cause after reading this I'm already really tired. :)

What a week!
Tuesday, June 23, 2015 8:29:49 AM
In the previous post, I gave an overview of what the SQLPS provider is and how it works. Now I want to pull back the curtains a bit and demonstrate how you can navigate the provider and use it effectively for managing your SQL Server instances. For those new to Powershell, this can be an […]
Tuesday, June 16, 2015 6:58:08 AM
One of the key entry points for using Powershell and SQL Server is the SQLPS provider. If you’ve been reading my blog for any length of time, you’ve seen me make use of the provider for one task or another. It’s an incredibly useful tool and can help you manage some basic tasks in SQL […]
Page 1 of 2 1 2 > >>