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, September 03, 2015 3:00:28 AM
Today I had a bit of a Twitter conversation with some SQL folks I know that were looking for Powershell help. It’s a common enough thing, of course. The trick is, we SQL people are so used to having the #sqlhelp hashtag as our first line of defense for figuring out problems that it’s weird […]
Wednesday, September 02, 2015 10:31:33 AM
Wow, is it already September? Can't believe how time is flying by! Sorry for the lack of posts, it has just been crazy busy with a new job and getting the Denver SQLSaturday setup for 9/19 (if you haven't registered, you better soon since we are up over 250 attendees now).

Enough about that stuff, I'm getting back out on the speaking circuit again after taking the summer off! I'll be presenting at the Kansas City SQLSaturday on 10/3. Currently I'm scheduled to present "Date Dimension: Past & Future in One Script" @ 9am, so first session right after the keynote! I'm really looking forward to presenting my freshly updated version of this session that I will also be presenting at PASS Summit 2015 later in October. If you are going to be in the KC area on 10/3, make sure you register for one of the best SQLSaturday's in the region. It is at a new location this year, but they are still having BBQ for lunch. Can't wait to eat as much BBQ as I can and see all of you in my session.
Tuesday, September 01, 2015 3:00:32 AM
Apologies for the unplanned blogging hiatus, but I’m back. While I’ve got a few technical post ideas bouncing around in my head, some events over the past two weeks have arisen that I want to blog on. If you’re hoping for more Powershell posts, do not despair! They will be along shortly. Recently PASS took […]
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 PowerBI.com. 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 […]
Page 1 of 2 1 2 > >>