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

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 […]
Tuesday, June 09, 2015 6:32:13 AM
I’ll be the first to tell you I’m not a fan of extended events. The why is a whole other blog post unto itself, but since T-SQL Tuesday is all about learning, I figured I’d take a stab at things. Furthermore, since I like to talk about Powershell, it seems like a good opportunity to […]
Wednesday, June 03, 2015 3:00:21 AM
Last week, while perusing through the usual interesting links from Twitter, I came across an article from Kendra Little (@Kendra_Little) titled “Not Everything Should be Automated”. It’s brief post where Kendra talks about why she has stopped automating some of her tasks. The title is attention grabbing (well, it grabbed MY attention), but there’s a […]
Friday, May 29, 2015 3:25:00 AM
This article is part 7 in a series on the top 10 most common mistakes that I have seen impacting SQL Server Performance and Resiliency. This post is not all inclusive. Most common mistake #7: Disaster Recovery Plans Often people hear disaster recovery plan and the first reaction is to start worrying about the costs. […]
Thursday, May 28, 2015 4:56:44 AM
Keeping with the theme of my last blog post, let’s talk a little more about Powershell basics. More specifically, let’s talk about the basics of reusing your Powershell scripts. Most DBAs have their library of scripts that they take with them from job to job, helping them be more effective at their job. Whether it’s […]
Thursday, May 28, 2015 3:21:01 AM
You might have been following along with my recent series of posts related to a number of resiliency tips for SQL Server. I have compiled these tips based off my observations over the last 20 or so years. Over the summer I have the opportunity to present a session that is based on these tips. […]
Page 1 of 3 1 2 3 > >>