tag:blogger.com,1999:blog-64991239182507396502024-02-06T23:20:26.427-07:00Wake BI BlogBusiness Intelligence (BI) blog for Microsoft BI technologies and integration into custom applicationsStevehttp://www.blogger.com/profile/05746734170065255114noreply@blogger.comBlogger133125tag:blogger.com,1999:blog-6499123918250739650.post-6679418098265288452015-11-17T08:48:00.000-07:002015-11-17T08:48:07.926-07:00#Summit15 Date and Time Script Updates!Finally getting caught up after a very quick but fun week with lots of networking and learning and #SQLFamily at <a href="http://www.sqlpass.org/summit/2015/Home.aspx">PASS Summit 2015</a> in Seattle.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://www.sqlpass.org/Portals/428/logo_event.png" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" src="http://www.sqlpass.org/Portals/428/logo_event.png" height="92" width="320" /></a></div>
<br />
This year's Summit was the first time that I got to present a full 75 minute presentation, so I was a bit stressed about that all week since my session was not until 9:30am on the Friday of the conference. The thing that was very reassuring is that I was doing my <a href="http://www.sqlpass.org/summit/2015/Sessions/Details.aspx?sid=7758">Date/Time Dimension talk</a> that I have done many times over the last few years at <a href="http://www.sqlsaturday.com/">SQLSaturdays</a> & User Groups across the country.<br />
<br />
I also got to do another Lightning Talk for the 3rd year in a row at a PASS Summit (wonder if that is some kind of record). The Lightning Talks for those that have not seen or done them can be more nerve racking than the 75 minutes sessions since they are only 10 minutes. When you are used to presenting for 60-75 minutes, 10 minutes or less is very difficult, unless you narrow the topic way down. For <a href="http://www.sqlpass.org/summit/2015/Sessions/Details.aspx?sid=40496">this year's Lightning Talk</a> I decided to focus on <a href="http://www.powerbi.com/">Power BI</a>, my new favorite tool in the Microsoft BI stack. And to get that focus down it was on creating dashboards really quickly using <a href="http://www.powerbi.com/">Power BI</a>. This was not the first time that I had demo'd <a href="http://www.powerbi.com/">Power BI</a>, but it was the first in a big venue with questionable internet access. And I did have a small issue with getting the Google Analytics Content Pack to actually refresh once I got it all setup, but I was able to move on and get the 2nd part of the demo working.<br />
<br />
With Friday's 75 minute session early in the morning I didn't have much hope of filling the room, plus it was across the street from the main convention center in one of the overflow rooms. I had around 25 people in the session and most of them were very engaged, which was awesome. It is always better to present to a smaller audience that really wants to see your session over a room full of people that are just there because it was close or they didn't want to leave from the previous session. I didn't have any major technical issues and I was able to get through the whole presentation with a few minutes to spare and lots of questions answered throughout (I even remembered to repeat the questions for the recording).<br />
<br />
In the week after I received a couple of emails from those that attended my session with some questions about the scripts that I provided to build the Date and Time Dimensions as I covered in the session. And we found that there were some errors in both scripts, which I have posted the fixed versions in a link below. This feedback is awesome and I love to know that people are trying to use the scripts and sharing these issues so that I can make the scripts better for everyone else that comes to this session later. Please feel free to reach out to me if you see any other issues or have questions about these scripts.<br />
<br />
<iframe frameborder="0" height="120" scrolling="no" src="https://onedrive.live.com/embed?cid=43F788CF3BDB5A0A&resid=43F788CF3BDB5A0A%2156161&authkey=ADa_Do8b9aCwBjI" width="98"></iframe>
<br />
<br />
Thanks to everyone that attended my sessions and hope that you got something out of them that you can use in your work! See you again next year at <a href="http://www.sqlpass.org/summit/2016/Welcome.aspx">PASS Summit 2016</a>!Stevehttp://www.blogger.com/profile/05746734170065255114noreply@blogger.com0tag:blogger.com,1999:blog-6499123918250739650.post-55833071623639612782015-10-13T15:11:00.003-06:002015-10-13T15:11:49.648-06:00#SQLSatOregon & PASS Summit 2015! #summit15 #powerbi<div class="separator" style="clear: both; text-align: center;">
<a href="http://www.sqlsaturday.com/images/sqlsat446_web.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="http://www.sqlsaturday.com/images/sqlsat446_web.png" /></a></div>
Time really does fly! Less than 2 weeks until <a href="http://www.sqlsaturday.com/446/eventhome.aspx">SQLSaturday Oregon</a> in Portland on 10/24 which I will be presenting my new "<a href="http://www.sqlsaturday.com/446/Sessions/Details.aspx?sid=38481">Power BI Is Awesome!</a>" presentation @ 3:30PM. Lots of fun with <a href="http://powerbi.com/">Power BI</a> for an hour. I really love this tool so it will be very fun and if you are there bring your questions and issues and I'll see what I can do to help everyone out. I'll also be in the <a href="http://www.sqlsaturday.com/446/Sessions/Details.aspx?sid=41506">Performance Clinic</a> at 4:45PM to answer any SQL Server BI questions that you have.<br />
<br />
<a href="https://upload.wikimedia.org/wikipedia/en/thumb/2/2b/Colorado_Rapids_logo.svg/201px-Colorado_Rapids_logo.svg.png" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" height="200" src="https://upload.wikimedia.org/wikipedia/en/thumb/2/2b/Colorado_Rapids_logo.svg/201px-Colorado_Rapids_logo.svg.png" width="134" /></a>I'll be enjoying Portland for the weekend, including a trip to <a href="http://www.providenceparkpdx.com/">Providence Park</a> to cheer on my <a href="http://coloradorapids.com/">Colorado Rapids</a> in their final game of the 2015 season on Sunday. I know that their season is already over, but I'm looking forward to seeing them play in another stadium and the <a href="http://www.providenceparkpdx.com/">Portland Timbers stadium</a> is high on my list!<br />
<br />
<a href="http://www.sqlpass.org/Portals/428/logo_event.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="http://www.sqlpass.org/Portals/428/logo_event.png" height="92" width="320" /></a>After the game is over Sunday evening I'll be making the drive up to Seattle for <a href="http://www.sqlpass.org/summit/2015/Home.aspx">PASS Summit 2015</a>! This will be the first year that I'm presenting a full hour session after doing Lightning Talks the last 2 years in a row (I'm doing another one this year again, for 3 straight years now). If you are going to be in the Seattle area on 10/26-10/30 I can't recommend attending <a href="http://www.sqlpass.org/summit/2015/Home.aspx">PASS Summit 2015</a> any more highly. I have lost count of how many PASS Summit's I have been to now, but I think it is my 9th time! My Lightning Talk on "<a href="http://www.sqlpass.org/summit/2015/Sessions/Details.aspx?sid=7760">Power BI: From Nothing to Dashboard in 10 Minutes!</a>" will be on Thursday, 10/29 @ 4:45PM and my full session "<a href="http://www.sqlpass.org/summit/2015/Sessions/Details.aspx?sid=7758">Date Dimension: Past and Future in One Script</a>" will be on Friday, 10/30 @ 9:30AM. If you still have not <a href="https://www.regonline.com/Register/Checkin.aspx?EventID=1628378">registered for PASS Summit 2015</a>, you can still use the discount code LC15WTG2 to get $150 off the registration fee.<br />
<br />
Hope to see you all in Portland and/or Seattle in a couple of weeks!Stevehttp://www.blogger.com/profile/05746734170065255114noreply@blogger.com0tag:blogger.com,1999:blog-6499123918250739650.post-56392725287043223852015-09-02T15:31:00.000-06:002015-09-02T15:31:33.915-06:00SQLSaturday KC! #SQLSatKCWow, 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 <a href="http://denversqlsaturday.com/">Denver SQLSaturday</a> setup for 9/19 (if you haven't registered, you better soon since we are up over 250 attendees now).<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://www.sqlsaturday.com/images/sqlsat444_web.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="http://www.sqlsaturday.com/images/sqlsat444_web.png" height="97" width="200" /></a></div>
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 <a href="http://www.sqlsaturday.com/444/EventHome.aspx">Kansas City SQLSaturday on 10/3</a>. Currently I'm <a href="http://www.sqlsaturday.com/444/Sessions/Schedule.aspx">scheduled to present "Date Dimension: Past & Future in One Script" @ 9am</a>, 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 <a href="http://www.sqlpass.org/summit/2015/Welcome.aspx">PASS Summit 2015</a> later in October. If you are going to be in the KC area on 10/3, make sure you <a href="https://www.sqlsaturday.com/444/RegisterNow.aspx">register</a> 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.Stevehttp://www.blogger.com/profile/05746734170065255114noreply@blogger.com0tag:blogger.com,1999:blog-6499123918250739650.post-90453865278684120042015-07-10T10:47:00.000-06:002015-07-10T10:47:12.837-06:00Power BI Release Date! #PowerBI<a href="http://blogs.msdn.com/b/powerbi/archive/2015/07/10/announcing-power-bi-general-availability-coming-july-24th.aspx">Microsoft has announced this morning the General Availability date for the new Power BI as July 24th</a>! 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.<br />
<br />
Power BI Designer is going to be renamed to Power BI Desktop and they have opened up a <a href="https://www.github.com/Microsoft/PowerBI-visuals">GitHub project</a> 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 <a href="https://play.google.com/store/apps/details?id=com.microsoft.powerbim">Android Power BI app</a> is also now available!<br />
<br />
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!Stevehttp://www.blogger.com/profile/05746734170065255114noreply@blogger.com0tag:blogger.com,1999:blog-6499123918250739650.post-30459841833135059932015-07-05T12:38:00.001-06:002015-07-05T12:38:53.567-06:0024 Hours of PASS: Growing Our Community Recordings #pass24hopAll of the recordings for <a href="http://www.sqlpass.org/24hours/2015/goc/Sessions.aspx">24 Hours of PASS: Growing Our Community</a> sessions are now available! I was honored to be selected for this event and you can get to the slides and recording for my "<a href="http://www.sqlpass.org/24hours/2015/goc/Sessions/SessionDetails.aspx?sid=35549">Introduction to the Power BI Designer</a>" <a href="http://www.sqlpass.org/24hours/2015/goc/Sessions/SessionDetails.aspx?sid=35549">session using this link</a>. 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.<br />
<br />
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 <a href="https://support.office.com/en-za/article/Connect-to-SAP-BusinessObjects-BI-Universes-Power-Query--4ee08c5a-8c98-433a-9be3-aee9b1a3c01b?ui=en-US&rs=en-ZA&ad=ZA">this support article</a> 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 <a href="https://powerbi.microsoft.com/downloads">Power BI Designer</a> and <a href="http://powerbi.com/">PowerBI.com</a>. I also found <a href="http://blogs.msdn.com/b/powerbi/archive/2014/05/19/power-bi-connectivity-to-sap-businessobjects-bi-now-generally-available.aspx">this blog post</a> along with <a href="https://www.youtube.com/watch?v=Ay-J0ddBpRk">this video on YouTube</a> that demos this connectivity with the existing Power Query for Excel.<br />
<br />
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.<br />
<br />
Thanks again and I hope to see you at the <a href="http://www.sqlpass.org/summit/2015/Welcome.aspx">PASS Summit 2015 in Seattle on 10/27 - 10/30</a>. Don't forget to use the discount code <a href="http://www.sqlpass.org/summit/2015/Welcome.aspx">LC15WTG2 when you register</a> to save $150 off the current price!<br />
<br />
Oh and one more thing for tonight's <a href="http://www.fifa.com/womensworldcup/">Women's World Cup</a> final, GO USA! :)Stevehttp://www.blogger.com/profile/05746734170065255114noreply@blogger.com0tag:blogger.com,1999:blog-6499123918250739650.post-4769813540103880472015-06-26T10:13:00.000-06:002015-06-26T10:32:56.859-06:00What a week! #pass24hop #summit15 #newbeginningsGlad that I had a full 2 week vacation before this week! Amazing what can happen in one week.<br />
<br />
Week started off with accepting an offer for a new job at <a href="http://www.chipotle.com/">Chipotle</a>! Looking forward to using all of my SQL BI knowledge to help them out. It has been a great run at <a href="http://www.revgen.com/">RevGen Partners</a> 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.<br />
<br />
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 <a href="http://http%3B//www.visa.com">Visa</a> 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 <a href="http://www.chipotle.com/">Chipotle</a> 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. ;)<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiApWngwGk0a_rZ2xSMXBhrzgiHucbi8PhSQrHXQ029tN5UXwQu8pR-Nf1-fuyPwZQiQgWR8bKalH1rzyhbVeAz4XpFUe_IOwnnmij3ffS-RhVLbOjFIZRoHXxrhqgXp8qTG8k4pFbZjiw/s1600/24HOP_GOC_SpeakerButton.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiApWngwGk0a_rZ2xSMXBhrzgiHucbi8PhSQrHXQ029tN5UXwQu8pR-Nf1-fuyPwZQiQgWR8bKalH1rzyhbVeAz4XpFUe_IOwnnmij3ffS-RhVLbOjFIZRoHXxrhqgXp8qTG8k4pFbZjiw/s1600/24HOP_GOC_SpeakerButton.png" /></a></div>
Next thing this week was my <a href="http://www.sqlpass.org/24hours/2015/goc/About.aspx">24 Hours of PASS: Growing our Community</a> presentation "<a href="http://www.sqlpass.org/24hours/2015/goc/Sessions/SessionDetails.aspx?sid=35549">Introduction to the Power BI Designer</a>" 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.<br />
<br />
<a href="http://www.sqlpass.org/Portals/428/images/PASS_2015_240x400.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="http://www.sqlpass.org/Portals/428/images/PASS_2015_240x400.jpg" height="320" width="192" /></a>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 <a href="http://www.sqlpass.org/summit/2015/Welcome.aspx">PASS Summit 2015</a> 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 "<a href="http://www.sqlpass.org/summit/2015/Sessions/Details.aspx?sid=7758">Date Dimension: Past & Future in One Script</a>" 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 <a href="http://www.sqlpass.org/summit/2015/Welcome.aspx">PASS Summit 2015</a> on "<a href="http://www.sqlpass.org/summit/2015/Sessions/Details.aspx?sid=7760">Power BI Designer: Nothing to Dashboard in 10 Minutes!</a>". 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 <a href="http://www.sqlpass.org/summit/2015/Welcome.aspx">PASS Summit 2015</a>, please <a href="http://www.sqlpass.org/summit/2015/RegisterNow.aspx">click on this link</a> and use the discount code LC15WTG2 to get $150 off!<br />
<br />
And not to get too political or anything, but the week was topped off with the <a href="http://www.cnn.com/2015/06/26/politics/supreme-court-same-sex-marriage-ruling/index.html">SCOTUS gay marriage decision</a>, which my response is: "It's about time!". Way to go SCOTUS, very proud to be an American today!<br />
<br />
Looking forward to the <a href="http://www.fifa.com/womensworldcup/">US Women's World Cup game tonight against China</a> and relaxing a bit over this weekend, cause after reading this I'm already really tired. :)<br />
<br />
What a week!Stevehttp://www.blogger.com/profile/05746734170065255114noreply@blogger.com0tag:blogger.com,1999:blog-6499123918250739650.post-64427091616899168812015-05-22T14:45:00.000-06:002015-05-22T14:45:18.333-06:0024 Hours of PASS: Growing Our Community #PASS24HOP<a href="http://www.sqlpass.org/portals/448/Images/banners/24HOP_GOC_page_2.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="http://www.sqlpass.org/portals/448/Images/banners/24HOP_GOC_page_2.png" height="50" width="400" /></a>I am proud to announce that I have been selected to present a webinar as part of the <a href="http://www.sqlpass.org/24hours/2015/goc/About.aspx">24 Hours of PASS series</a> on June 24-25! The theme of this <a href="http://www.sqlpass.org/24hours/2015/goc/About.aspx">24 Hours of PASS is Growing Our Community</a>, which is all about speakers who have not yet presented a regular session or pre-con at the <a href="http://www.sqlpass.org/summit/2015/Welcome.aspx">PASS Summit</a> in previous years. While I have presented at the last 2 <a href="http://www.sqlpass.org/summit/2015/Welcome.aspx">PASS Summits</a> in both cases they were 10 minute Lightning Talks, not a regular session (fingers crossed that I get one this year). If you have not yet registered for <a href="http://www.sqlpass.org/summit/2015/Welcome.aspx">PASS Summit 2015</a> in Seattle on 10/27 - 10/30, then <a href="https://www.regonline.com/Register/Checkin.aspx?EventID=1628378">use this link to register</a> and the discount code LC15WTG2 to get $150 off!<br />
<br />
I will be presenting my "<a href="http://www.sqlpass.org/24hours/2015/goc/Sessions/SessionDetails.aspx?sid=35549">Introduction to the Power BI Designer</a>" session at noon MT/18:00 GMT, which I have given at other venues a couple of times before and is now my new favorite session. I love how the new <a href="http://powerbi.com/">Power BI</a> is coming along and it is also a challenge to demo with the product being updated at least once every month.<br />
<br />
If you can attend <a href="http://www.sqlpass.org/24hours/2015/goc/Schedule.aspx">any of these 24 sessions starting at 6am MT/noon GMT</a>, please register as there is a fantastic line-up of sessions/speakers for these 24 hours and I'm honored to be in this group!<br />
<br />
<br />Stevehttp://www.blogger.com/profile/05746734170065255114noreply@blogger.com0tag:blogger.com,1999:blog-6499123918250739650.post-52773354080503526582015-05-04T15:36:00.001-06:002015-05-04T15:36:52.495-06:00Denver WIT May Meeting #DenverWIT #WITWednesday<div class="separator" style="clear: both; text-align: left;">
<a href="http://denverwit.sqlpass.org/Portals/385/Logos/400dpiLogo.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="http://denverwit.sqlpass.org/Portals/385/Logos/400dpiLogo.png" height="75" width="320" /></a></div>
Of course I realized after I posted the announcement about speaking at <a href="http://www.sqlsaturday.com/392/eventhome.aspx">SQLSaturday Atlanta</a> in a couple of weeks that I will also be speaking at the <a href="http://denverwit.sqlpass.org/">Denver WIT (Women in Technology)</a> meeting on the Wednesday before that, 5/13! The <a href="http://denverwit.sqlpass.org/">Denver WIT group</a> meets on the 2nd Wednesday of every month at the <a href="http://maps.google.com/maps?q=7595+Technology+Way%2c+Suite+400%2c+Denver+%2c+Colorado%2c+United+States">Denver Microsoft offices</a> and I was more than happy to help out by presenting my new "Power BI is Awesome!" session at this month's meeting.
<br />
<div>
<br /></div>
<div>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjk9_g7tsL1llZ0CsxTAwmkqh2TZWG0WX6_fi4sUqm7iXf7GFnuxFpeTuGWpQ9DjGYgquLY8-2KEfbo23hkJV-Vv9NMmQFg2vo9o2AhQFtxV_BQj-4QZ5IaKFp76J74_xbEEdFTtBhmpvM/s1600/Picture1.png" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjk9_g7tsL1llZ0CsxTAwmkqh2TZWG0WX6_fi4sUqm7iXf7GFnuxFpeTuGWpQ9DjGYgquLY8-2KEfbo23hkJV-Vv9NMmQFg2vo9o2AhQFtxV_BQj-4QZ5IaKFp76J74_xbEEdFTtBhmpvM/s1600/Picture1.png" /></a>If you are looking for a good intro into what Power BI is and what it soon will be then this is the session for you! I'll do a little bit of background on what Microsoft has been doing with Power BI over the last few years and where it is all going with the new Power BI Designer and <a href="http://powerbi.com/">PowerBI.com</a> website. There will be demos of the new stuff and some fun guessing where Microsoft might be heading in the future with this product line.<br />
<br /></div>
<div>
<br /></div>
<div>
<a href="http://www.eventbrite.com/e/may-2015-wit-wednesday-tickets-16795866890">Please RSVP at the EventBrite page</a> and I hope to see you all at the meeting on 5/13!</div>
Stevehttp://www.blogger.com/profile/05746734170065255114noreply@blogger.com0tag:blogger.com,1999:blog-6499123918250739650.post-53507833710165446652015-05-04T08:59:00.000-06:002015-05-04T15:19:18.289-06:00SQLSaturday #392 Atlanta #sqlsatatl<div class="separator" style="clear: both; text-align: center;">
<a href="http://www.sqlsaturday.com/images/SQLSAT392_web.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="http://www.sqlsaturday.com/images/SQLSAT392_web.jpg" /></a></div>
I'm very happy that I was selected for the 2nd year in a row to speak at the <a href="http://www.sqlsaturday.com/392/eventhome.aspx">SQLSaturday event in Atlanta on 5/16</a>! This is one of, if not the biggest SQLSaturday's in the world with over 500 attendees! If you are going to be in the Atlanta area on 5/16, <a href="http://www.sqlsaturday.com/392/RegisterNow.aspx">please register</a> and plan on attending my session, "<a href="http://www.sqlsaturday.com/392/Sessions/Details.aspx?sid=25722">Near Real-Time Data Warehouse Updates with CDC & SSIS</a>" at 2:30pm in BI Room 3 (keep you eyes on the <a href="http://www.sqlsaturday.com/392/Sessions/Schedule.aspx">schedule page</a> or use <a href="https://guidebook.com/">Guidebook</a> in case the schedule changes).<br />
<br />
Also, if you are going to be around on the Friday before, consider registering for one of the <a href="http://www.sqlsaturday.com/392/EventHome.aspx">all day pre-cons</a>. These pre-cons are just like the ones that you would get at the large conferences like <a href="http://www.sqlpass.org/summit/2015/Welcome.aspx">PASS Summit</a>, but at 1/3rd the price!<br />
<br />
Looking forward to meeting and seeing everyone in Atlanta in less than 2 weeks!Stevehttp://www.blogger.com/profile/05746734170065255114noreply@blogger.com0tag:blogger.com,1999:blog-6499123918250739650.post-49940379768084619212015-04-22T09:13:00.000-06:002015-05-04T17:20:02.342-06:00FREE #PowerBI Webinar @PragmaticWorks Training on the T's Tomorrow!I'll be doing a new session, <a href="http://pragmaticworks.com/Training/FreeTraining/ViewWebinar/WebinarID/1751">"Introduction to Power BI Designer" tomorrow at 11am ET</a> as part of the <a href="http://www.pragmaticworks.com/">Pragmatic Works</a> <a href="http://pragmaticworks.com/Training/FreeTraining">Training on the T's series of FREE webinars</a>! Please register at the link above and see how the new <a href="https://go.microsoft.com/fwlink/?LinkID=521662">Power BI Designer</a> that is currently in preview works and what I expect it means for the future of BI at Microsoft (I even do a little bit of a look back for those that aren't up on the latest with <a href="http://www.powerbi.com/">Power BI</a>).<br />
<br />
Looking forward to seeing everyone at the session tomorrow morning. Look for another post later this week with the link to the slides and answering any questions from the session that I don't get to in the session.<br />
<br />
<u><b>Update 5/4</b></u> - Thanks to everyone that attended this session on 4/23, below are some of the questions that I didn't get a chance to answer during the webinar.<br />
<br />
<b>Can data refresh be scheduled?</b><br />
With the new Power BI it will depend on which level you subscribe to. For the free version you can schedule refreshes only once a day, but the Pro level will allow you to schedule updates for every hour.<br />
<br />
<b>You demo'd the Power BI Designer desktop application, is there an online web-based version?</b><br />
Yes, they are planning on making a web version available on <a href="http://powerbi.com/">PowerBI.com</a> at the time of release. This is my guess is to why the roll out of features in Power BI Designer has been a bit slower, because they are making sure that all of this code can be run on both the desktop and web applications.<br />
<br />
<b>Power BI Designer Preview is only available as a 64bit application, will there be a 32bit version?</b><br />
No, Microsoft has made it clear that a lot of the issues with the current Power BI Excel add-ons being allowed to run in 32bit. 64bit gives the stability to run the millions/billions of rows of data in the application in memory.<br />
<br />
<b>What is the difference between Power Query and Power BI Designer?</b><br />
Power Query is the add-on that currently runs in Excel only. For Power BI Designer Microsoft is taking much of the functionality from Power Query and integrating it into that tool. In the end Microsoft will probably stop updating Power Query for Excel and make the newest versions only work in Power BI Designer, this is already apparent in some of the SaaS sources that they are adding which are all not available in Power Query.<br />
<br />
<b>What data types are supported in Power BI Designer?</b><br />
The types available are changing with new versions of the Power BI Designer, but as of the April 2015 release, <a href="https://support.powerbi.com/knowledgebase/articles/558030-data-types-in-power-bi-designer?WT.mc_id=Blog_Designer_Update">this link provides the full list </a>and some great detail on how to convert between them in DAX (thanks to the attendee that posted this link in the chat).<br />
<br />
<b>How is security managed?</b><br />
Microsoft is saying right now that the full version will support integration with Active Directory, what we have not heard is if that is on-premise and/or Azure. As of right now the only source that fully works with built in security is when you use a SSAS Tabular model and the <a href="https://support.powerbi.com/knowledgebase/articles/471577-create-an-analysis-services-connector">Power BI Analysis Services Connector Preview</a>. I would assume that in future updates before release that this connector will be upgraded to work with SSAS Multi-Dimensional models as well, but there is no timetable on when that will be. With some of the announcements at Microsoft Ignite today, I can see how the new Azure services for integration with Active Directory will be used to fill in this gap in some way.<br />
<br />
<b>Can you clarify what can be done locally at no cost and what?</b><br />
When you use Power BI Designer you can use all of the sources that it currently connects to as long as you are able to access those sources (for SQL Server you will need to be on the same domain or be able to access them). All of the manipulations of the data that you do to those sources (remove columns, rename columns, merge datasets together) is all stored and is repeatable as it is stored in the M language. This will allow you to update locally in Power BI Designer as much as you want inside the application (that might change when the full version is released). You can build reports on those models that you create, there is no limit to the number of reports you can build (at least currently). Once you have all of that setup the way that you want it can be saved to your local file system as a PBIX file and that file can be shared with others and viewed/updated in the Power BI Designer as long as they also have the required access to the data sources you setup. As far as we know that is all going to be free. It is only when you need to push the solution up to the <a href="http://powerbi.com/">PowerBI.com</a> site that you start getting into being charged and if you need to have the refresh of data scheduled once they are deployed to the web. As far as I know you can pass around PBIX files to anyone and as long as they have Power BI Designer and access to those data sources you can use it for free!<br />
<br />
<b>Can the Power BI reports be imported into SharePoint?</b><br />
Unknown at this time, I don't think that Microsoft is going to forget about allowing this kind of BI/Analytics in SharePoint. I would not be surprised if by the full release they have a way to deploy these PBIX solutions into SharePoint in some way. Or a 3rd party vendor will find a way to parse the XML in the PBIX file and make that happen.<br />
<br />
<b>How is it different from SSIS?</b><br />
Power BI Designer does not have all of the functionality that SSIS has, by design. Power BI Designer is meant for more of Business Analyst/Power User role. I expect over time that more a more functionality will be added to Power BI Designer to the point that it can do 90+% of what SSIS does, so then only the really complex ETL will need to be passed on to IT to do it in SSIS.<br />
<br />
<b>Can we connect to SAP DATA and other data providers?</b><br />
Microsoft is constantly adding new built-in connectors for different databases so it is very possible. If that data source can be connected to via ODBC, that is a built-in provider that could be used as well.<br />
<br />
<b>Can you use multiple data sources in the same project?</b><br />
Definitely! That is one of the major benefits of using this tool is that you can pull data in from as many different sources as you want and then join them together as required. As time goes on they should be able to do better auto-detection of the joins between data sources like Power Query can do today.<br />
<br />
<b>Can you import web data and then after making the changes upload to your own SQL Server?</b><br />
There is no out of the box way to do that type of export in Power BI Designer today, but if you used the current Power Query Excel add-on then you could make the necessary updates to the data from multiple sources and then either import the resulting data via Excel/CSV exports or just upload the model created as an SSAS Tabular model. At this point we don't know if there will be the ability to create the model in Power BI Designer and upload the model into SSAS Tabular or not, but I would not be surprised to see that in the full release.<br />
<br />
<b>We are looking at using this for some very confidential data. How can I use this internally and not push anything out to the world?</b><br />
If you want to share the PBIX files from Power BI Designer, that will work for moving the data/reports around internally. There is no requirement to use the <a href="http://powerbi.com/">PowerBI.com</a> website and that is where the costs come into play as well. Not sure about future plans to integrate with SharePoint, but I would assume that is coming as well.<br />
<br />
Thanks again to those that attended this webinar, I will continue to update this post when videos are posted. If you want to replay the entire webinar, <a href="http://pragmaticworks.com/Training/FreeTraining/ViewWebinar/WebinarID/1751">just go to this link</a> on the <a href="http://pragmaticworks.com/">Pragmatic Works</a> site. Thanks also to <a href="http://pragmaticworks.com/">Pragmatic Works</a> for letting me do this webinar!Stevehttp://www.blogger.com/profile/05746734170065255114noreply@blogger.com0tag:blogger.com,1999:blog-6499123918250739650.post-47824895930310171392015-04-13T09:19:00.000-06:002015-04-13T09:19:15.934-06:00SQLSaturday OC (Huntington Beach) #sqlsatoc<div class="separator" style="clear: both; text-align: center;">
<a href="http://www.sqlpass.org/images/SQLSAT389_web.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="http://www.sqlpass.org/images/SQLSAT389_web.jpg" /></a></div>
This last weekend I was in California for an extended weekend with my family at Disneyland and Huntington Beach to participate in the <a href="http://www.sqlsaturday.com/389/EventHome.aspx">Orange County/Huntington Beach SQLSaturday</a>! Awesome weather and great times visiting Disneyland and the Huntington Beach/LA area. I finally got to cross off visiting the <a href="http://www.griffithobs.org/">Griffith Observatory</a> from my list of todos in LA, it was quite the hike from where we had to park, but worth it for the view and the amazing show in the planetarium.<br />
<div>
<br /></div>
<div>
Back to the <a href="http://www.sqlsaturday.com/389/eventhome.aspx">Huntington Beach SQLSaturday</a>, thanks to the great crew there in the OC on putting on another successful event! For the first time I did <a href="http://www.sqlsaturday.com/389/Sessions/Schedule.aspx">2 presentations at this SQLSaturday</a> and both of them went very well with great interaction from the attendees that helped make the session extra informative for everyone there. Below I have posted the links to download the slides and demo materials from both presentations.</div>
<div>
<br /></div>
<div>
<iframe frameborder="0" height="120" scrolling="no" src="https://onedrive.live.com/embed?cid=43F788CF3BDB5A0A&resid=43f788cf3bdb5a0a%2155226&authkey=AGhW-JKsJ4YpGyw" width="98"></iframe> <iframe frameborder="0" height="120" scrolling="no" src="https://onedrive.live.com/embed?cid=43F788CF3BDB5A0A&resid=43f788cf3bdb5a0a%2155225&authkey=AMBwUjMglhkbIRA" width="98"></iframe>
</div>
<div>
<br /></div>
<div>
Thanks again to everyone that came out and I look forward to making my way back to the LA area again in the future!</div>
<div>
<br /></div>
<div>
Next <a href="http://www.sqlsaturday.com/">SQLSaturday</a> for me will be <a href="http://www.sqlsaturday.com/392/eventhome.aspx">Atlanta on May 16th</a>!</div>
Stevehttp://www.blogger.com/profile/05746734170065255114noreply@blogger.com0tag:blogger.com,1999:blog-6499123918250739650.post-56316812235060660122015-03-20T08:59:00.000-06:002015-03-20T08:59:37.784-06:00Denver SQL Server User Group March 2015 #denversqlThanks to everyone that attended my "Near Real-Time Data Warehouse Updates with CDC and SSIS" presentation at the <a href="http://denversql.org/">Denver SQL Server User Group</a> meeting last night. For anyone that wants my slides and demo scripts, you can download them from the link below:<br />
<br />
<iframe frameborder="0" height="120" scrolling="no" src="https://onedrive.live.com/embed?cid=43F788CF3BDB5A0A&resid=43F788CF3BDB5A0A%2155187&authkey=ANAkaXoDtLblQTQ" width="98"></iframe><br />
<br />
Thanks again and I hope to see you all again at a future Denver SQL Server User Group meeting!Stevehttp://www.blogger.com/profile/05746734170065255114noreply@blogger.com0tag:blogger.com,1999:blog-6499123918250739650.post-75838804234524042232015-03-19T08:40:00.001-06:002015-03-19T08:40:32.724-06:00Boulder SQL Server User Group March 2015 #bouldersqlI had a great time presenting to the <a href="http://www.meetup.com/BoulderSql/">Boulder SQL Server User Group</a> last night, thanks to Mark Tillman and Paul Paiva for having me present "Change Data Capture (CDC) and SSIS". Lots of great interaction from the attendees. For anyone that wants my slides and demo scripts, you can download them from this link:<br />
<br />
<iframe frameborder="0" height="120" scrolling="no" src="https://onedrive.live.com/embed?cid=43F788CF3BDB5A0A&resid=43F788CF3BDB5A0A%21681&authkey=ABmh5rhwaXiS5-E" width="98"></iframe><br />
<br />
Thanks again to everyone from the Boulder SQL Server User Group and the attendees that came out last night!Stevehttp://www.blogger.com/profile/05746734170065255114noreply@blogger.com0tag:blogger.com,1999:blog-6499123918250739650.post-31680790987789495052015-03-15T17:13:00.002-06:002015-03-15T17:13:52.180-06:00Presenting at Colorado User Groups! #sqlfamily #sqlpassI will be presenting at both the <a href="http://www.meetup.com/BoulderSql/">Boulder SQL Server User Group</a> and <a href="http://denversql.org/">Denver SQL Server User Groups</a> next week! I'm looking forward to doing my Change Data Capture (CDC) with SSIS talk at both groups. I've been doing this talk at <a href="http://www.sqlsaturday.com/">SQLSaturday</a>s across the country, but this will be the first time that I have done it in Colorado since April 2014 at <a href="https://www.sqlsaturday.com/297/eventhome.aspx">SQLSaturday #297 in Colorado Springs</a>.<br />
<br />
For more details about the Boulder SQL Server User Group meeting on Wednesday, March 18th at 5:30pm and to RSVP, please visit their <a href="http://www.meetup.com/BoulderSql/events/219745128/">Meetup.com website</a>.<br />
<br />
For more details on the Denver SQL Server User Group meeting on Thursday, March 19th at 5:30pm, please visit <a href="http://denversql.org/">denversql.org</a>.<br />
<br />
Looking forward to meeting all of you that can make it out to Boulder and/or Denver on Wednesday and/or Thursday next week!Stevehttp://www.blogger.com/profile/05746734170065255114noreply@blogger.com0tag:blogger.com,1999:blog-6499123918250739650.post-90655423574159271322015-02-19T10:50:00.001-07:002015-02-19T10:50:20.284-07:00Power BI Designer Preview Updates! #PowerBI<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhjzAcn_F_3houbV3pf2iVAkKNOWrwmwjxAEMCCZATs17LaSPyRqUNz7iMpjT-GAanoDTvmYFXR8MRp4j0FPzcI2gQbVKU5oumHbCak5WT0YPPMrynUnfT90pwIo6a4BgzS0neHnCoRSDw/s1600/power-bi-tools-logo.jpg" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhjzAcn_F_3houbV3pf2iVAkKNOWrwmwjxAEMCCZATs17LaSPyRqUNz7iMpjT-GAanoDTvmYFXR8MRp4j0FPzcI2gQbVKU5oumHbCak5WT0YPPMrynUnfT90pwIo6a4BgzS0neHnCoRSDw/s1600/power-bi-tools-logo.jpg" /></a><a href="http://blogs.msdn.com/b/powerbi/archive/2015/02/19/6-new-updates-for-the-power-bi-preview-february-2015.aspx">Microsoft just posted an announcement on the Power BI blog</a> that there is a new version of the <a href="http://powerbi.com/dashboards/downloads/designer?WT.mc_id=Blog_PBI_Announce_DI">Power BI Designer Preview</a> today! Below is a summary of the updates:<br />
<br />
<ol>
<li>Performance improvements</li>
<li>Dynamics CRM Online connector</li>
<li>Navigator Dialog improvements:</li>
<li>New Transformations:</li>
<ul>
<li>Age and Subtract operations for Date/Time columns </li>
<li>Aggregate Columns: Option to disable new columns’ prefix</li>
</ul>
<li>Field List improvements:</li>
<ul>
<li>Expand/Collapse tables</li>
<li>Hide/Unhide fields</li>
<li>Optimized layout (spacing, margins, and fonts)</li>
</ul>
<li>Report Pages Navigation - Keyboarding support</li>
<li>Lots of other bug fixes</li>
</ol>
<div>
For more details on each of these updates and a video demo of the updates, <a href="http://blogs.msdn.com/b/powerbi/archive/2015/02/19/6-new-updates-for-the-power-bi-preview-february-2015.aspx">visit the blog post</a>.</div>
<div>
<br /></div>
<div>
If you are already running the Power BI Designer Preview, just launch the app and it will detect the updated version and take you to the <a href="http://powerbi.com/dashboards/downloads/designer?WT.mc_id=Blog_PBI_Announce_DI">website to download it or just go to this link</a> and download/install the latest version (does not update inside the app, requires you to run the new installer to update).</div>
<div>
<br /></div>
<div>
Looks like there are going to be some good updates to this Preview and at a fast pace as well!</div>
Stevehttp://www.blogger.com/profile/05746734170065255114noreply@blogger.com0tag:blogger.com,1999:blog-6499123918250739650.post-26088030407563666352015-02-16T08:47:00.001-07:002015-02-16T08:52:35.008-07:00SQLSaturday Phoenix #sqlsat370 #sqlsatphoenix<a href="http://www.sqlsaturday.com/images/sqlsat370_web.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="http://www.sqlsaturday.com/images/sqlsat370_web.png" /></a>I'll be traveling to Phoenix, AZ in less than 2 weeks to speak at <a href="https://www.sqlsaturday.com/370/eventhome.aspx">SQLSaturday #370</a> on February 28th! Looking forward to going back to Phoenix again after making the trip down there a couple of years ago with the family for <a href="http://www.phoenixcomicon.com/">Phoenix Comicon</a> (yes, I am one of those geeks that goes to Comic/Sci-Fi Conventions). Looks like I'll be able to meet up with a bunch of my <a href="http://www.pragmaticworks.com/">Pragmatic Works</a> friends as there is big group of them speaking along with a a few from the Colorado area as well and many others that I haven't seen since <a href="http://www.sqlpass.org/summit/2015/Welcome.aspx">PASS Summit</a> last year! I am currently scheduled to present "<a href="https://www.sqlsaturday.com/viewsession.aspx?sat=370&sessionid=25913">Change Data Capture (CDC) with SSIS</a>" at 1:30pm in the Kachina room. If you are in the Phoenix area on February 28, please make sure you <a href="https://www.sqlsaturday.com/register.aspx">register for this great free event</a> and stop by to see me! :)<br />
<br />
Also, for anyone that is thinking about going to the <a href="http://passbaconference.com/2015/Home.aspx">PASS Business Analytics Conference</a> on April 20-22 in Santa Clara, CA, you can use the <a href="http://passbaconference.com/2015/Home.aspx">discount code USSE27 at registration</a> to save $150 off the current registration fee!Stevehttp://www.blogger.com/profile/05746734170065255114noreply@blogger.com0tag:blogger.com,1999:blog-6499123918250739650.post-48640106878073084672014-12-19T15:46:00.000-07:002014-12-19T15:46:24.035-07:00Big Power BI Updates!<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiT6m5zPg_NUfP3_0x1p8mKy-xURUkDvxcL5dpaGenEDcNck6PmtARBWt4fgdcla8xT4Gnz0AEgtgjhwBeg8WysgpVWaCc5QX8GS3WBH9GoloFxzieOggLfO_WnsUMbJ3koRE1Q2BFmEUM/s1600/power-bi-tools-logo.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiT6m5zPg_NUfP3_0x1p8mKy-xURUkDvxcL5dpaGenEDcNck6PmtARBWt4fgdcla8xT4Gnz0AEgtgjhwBeg8WysgpVWaCc5QX8GS3WBH9GoloFxzieOggLfO_WnsUMbJ3koRE1Q2BFmEUM/s1600/power-bi-tools-logo.jpg" /></a><a href="http://blogs.msdn.com/b/powerbi/archive/2014/12/18/new-power-bi-features-available-for-preview.aspx" target="_blank">Today Microsoft announced some very big updates to Power BI</a> that will make it more like the product I have been hoping for since it was first announced.<br />
<br />
First off the new <a href="http://www.powerbi.com/dashboards">PowerBI.com</a> site has launched in Preview mode with lots of info on all of these new features.<br />
<br />
Also today we got the <a href="http://go.microsoft.com/fwlink/?LinkID=521662" target="_blank">Preview download of the Power BI Designer</a> that allows for the design and viewing of Power BI solutions in a standalone application. Before you get too excited this first Preview release of the Power BI Designer only does Power Query and Power View functions, no Power Pivot or Power Map yet (hopefully those will be added in future releases). You can use existing Power Pivot models as a source, but you<br />
will not be able to update those Power Pivot models until a future release. I think that this new application will finally give us the unified development environment we have been looking for to do Power BI solutions.<br />
<br />
Also added today to Power BI is the Preview release of connecting to onsite SQL Server Analysis Services Tabular models. This is a Preview release as well, but can be <a href="http://support.powerbi.com/knowledgebase/articles/471577-create-an-analysis-services-connector" target="_blank">accessed from the existing Power BI online tools</a> and the new Power BI Designer.<br />
<br />
<a href="http://www.powerbi.com/dashboards" target="_blank">Power BI Dashboards</a> was also added to the feature list along with a few new visualizations (combo charts, fill maps, gauges, tree maps and funnel charts). A bunch of new data sources were also added with built-in support: Github, Salesforce, SendGrid, Zendesk, Dynamics CRM, and Marketo.<br />
<br />
And the <a href="http://www.powerbi.com/dashboards/downloads/ipad.html" target="_blank">Power BI app for Apple iPad</a> was announced that it would be available in the Apple AppStore sometime today (12/19). There was still not a link to go directly to the Apple AppStore as of late this afternoon, so this may not show up until after the new year since Apple is shutting down AppStore updates for the holidays very soon.<br />
<br />
Reading between the lines a bit on all of this it looks like Power BI is being positioned as a full standalone application that will no longer require Excel 2010/2013, Office 365 or even SharePoint (on-prem or online). I think that this is exactly what Power BI needs to become a much more accepted application in the Enterprise and I for one am very excited about the possibilities now!Stevehttp://www.blogger.com/profile/05746734170065255114noreply@blogger.com0tag:blogger.com,1999:blog-6499123918250739650.post-66310316616532612802014-12-07T15:19:00.001-07:002014-12-07T15:19:52.233-07:00SQLSaturday #362 - Austin #sqlsataustin #sqlsat362<div class="separator" style="clear: both; text-align: center;">
<a href="https://www.sqlsaturday.com/362/eventhome.aspx" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;" target="_blank"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh25JIT1ZDih27jIXqBPSUOR4MLkOPdYSSmMGr21cHDGPalCaRLwQTeQHUshKa5fDXhp8I_zzDNWPl5R7YlI_8YfwE5eiemgWhrdelNPpyWqCsl34SOkAcD9xwpH8_GgC_SNH7RDOXj10k/s1600/sqlsat362_web.png" /></a></div>
For my first speaking event of 2015 I'll be presenting "<a href="https://www.sqlsaturday.com/viewsession.aspx?sat=362&sessionid=25396" target="_blank">Capture Change and Apply It with CDC & SSIS</a>" at <a href="https://www.sqlsaturday.com/362/eventhome.aspx" target="_blank">SQLSaturday #362</a> in Austin, TX on <a href="https://www.sqlsaturday.com/362/schedule.aspx" target="_blank">January 31st @ 9am</a>. Looking forward to going to a city that I have wanted to visit for many years and going back to the area where I was born (Fort Hood, TX). My family moved from Texas when I was only a few weeks old as my Dad completed his service in the Army and went back into the private sector. I'm going to be flying in early on Friday, January 30 so that I can do some sight seeing for the day.<br />
<br />
If you are going to be in the Austin area, it would be great to see you! To register for SQLSaturday #362, just <a href="https://www.sqlsaturday.com/362/register.aspx" target="_blank">click on this link</a> and I'll see you there!Stevehttp://www.blogger.com/profile/05746734170065255114noreply@blogger.com0tag:blogger.com,1999:blog-6499123918250739650.post-55457274588091048372014-11-09T16:00:00.000-07:002014-11-09T16:00:20.169-07:00PASS Summit 2014 #summit14 #sqlfamilyI'm back home after an amazing week in Seattle for <a href="http://sqlpass.org/summit/2014" target="_blank">PASS Summit 2014</a>. Love visiting Seattle, especially when there are lots of #SQLFamily there to enjoy it with!<br />
<br />
I got into Seattle on Sunday afternoon via train from Portland. Was the first Amtrak train that I have ever been on and was a nice relaxing ride from Seattle to Portland. I guess I thought that I would see more of the coast on the train, didn't realize that it was going more inland, still some great scenary.<br />
<br />
The week itself went by really fast with <a href="http://sqlpass.org/" target="_blank">PASS</a> meetings on Tuesday and the conference itself starting on Wednesday. My presentation on SSDT, "<a href="http://1drv.ms/1pFPazv" target="_blank">What Version of SSDT do I Need?</a>" was on Wednesday afternoon, so it was good that I got that over with early in the week. I presented this session in the first set of Lightning Talk sessions with <a href="http://www.sqlpass.org/summit/2014/Speakers/Details.aspx?spid=242" target="_blank">Brent Ozar</a>, <a href="http://www.sqlpass.org/summit/2014/Speakers/Details.aspx?spid=706" target="_blank">Luke Jian</a>, <a href="http://www.sqlpass.org/summit/2014/Speakers/Details.aspx?spid=820" target="_blank">Mark Vaillancourt</a>, <a href="http://www.sqlpass.org/summit/2014/Speakers/Details.aspx?spid=212" target="_blank">Tim Radney</a> and <a href="http://www.sqlpass.org/summit/2014/Speakers/Details.aspx?spid=298" target="_blank">Craig Purnell</a>. Was great to share the spotlight with all of these speakers in a full room and we got through all of our presentations with time for questions at the end! Tim, Craig and I were all in the same Lightning Talk session at PASS Summit 2013 as well.<br />
<br />
Below is the updated version of my slides, with a change to the table of SSDT versions, correcting a small oversight on my part.<br />
<div>
<br /></div>
<iframe frameborder="0" height="327" scrolling="no" src="https://onedrive.live.com/embed?cid=43F788CF3BDB5A0A&resid=43F788CF3BDB5A0A%2147013&authkey=ACsqSm6jm0xGnCM&em=2" width="402"></iframe>
<br />
With the presentation out of the way I was able to enjoy the other sessions and parties throughout the week and see as many of my #SQLFamily as possible. Overall the week went very well and I'm already looking forward to <a href="http://sqlpass.org/summit/2015" target="_blank">PASS Summit 2015</a> back in Seattle on October 27 - 30!<br />
<br />
Thanks again to everyone that attended my session and I'm looking forward to an even better 2015!Stevehttp://www.blogger.com/profile/05746734170065255114noreply@blogger.com0tag:blogger.com,1999:blog-6499123918250739650.post-56911486604560220962014-10-25T12:04:00.000-06:002014-10-25T12:04:33.275-06:00SQLSaturday Oregon & PASS Summit 2014 #sqlsat337 #Summit2014Next week I'll be leaving for <a href="https://www.sqlsaturday.com/337/eventhome.aspx" target="_blank">SQLSaturday #337 Oregon</a> and PASS Summit 2014 where I will be speaking at both!<br />
<br />
<a href="https://www.sqlsaturday.com/337/eventhome.aspx" target="_blank">SQLSaturday #337 Oregon</a> will be my first trip to Portland, so I'm looking forward to seeing a new city and speaking to the Oregon SQL Server community. My session will be "<a href="https://www.sqlsaturday.com/viewsession.aspx?sat=337&sessionid=23541" target="_blank">Date and Time Dimensions for Every Day and Time in No Time</a>" at 1:15pm in Room 204 (keep your eye on the <a href="https://www.sqlsaturday.com/337/schedule.aspx" target="_blank">schedule page</a> or <a href="https://guidebook.com/" target="_blank">Guidebook</a> just in case it changes). I love giving this Date Dimension talk as it is something that every Data Warehouse needs and everyone hates setting them up, so I help with a single script and some advice. If you are going to be in the Portland area on Saturday, November 1st, please make sure <a href="https://www.sqlsaturday.com/337/register.aspx" target="_blank">you register</a> and I'll see you next Saturday!<br />
<br />
After <a href="https://www.sqlsaturday.com/337/eventhome.aspx" target="_blank">SQLSaturday #337</a> I'll take the Amtrak from Portland to Seattle on Sunday for my favorite conference, <a href="http://www.sqlpass.org/summit/2014/" target="_blank">PASS Summit 2014</a>! PASS Summit is a yearly SQL Server conference that has thousands of SQL Server professionals and speakers from across the world. For the second PASS Summit in a row I'll be presenting a session. After attending this amazing conference yearly since 2007 I have become very involved in the SQL Server community and love that I now get to be part of speakers/volunteers that make this event great. I'll be presenting "<a href="http://www.sqlpass.org/summit/2014/Sessions/Details.aspx?sid=7357" target="_blank">What Version of SSDT do I Need?</a>" at 3pm on Wednesday, November 5th in Room 606. I'll also be volunteering at the PASS Community Zone, so make sure to stop by and say hi!<br />
<br />
Looking forward to seeing everyone in Portland and Seattle in a week and hanging out with my #SQLFamily at both events!Stevehttp://www.blogger.com/profile/05746734170065255114noreply@blogger.com0tag:blogger.com,1999:blog-6499123918250739650.post-65160895436002283032014-09-11T20:42:00.000-06:002014-09-11T20:42:33.326-06:00SQLSaturday #300 and Other PostsI'll hopefully be flying out of Denver first thing Friday morning for <a href="http://sqlsaturday.com/eventhome.aspx" target="_blank">SQLSaturday #300</a> in Kansas City, assuming we don't get too much snow (currently only forecasting .2", so not too worried). Love visiting with all of my KC #SQLFamily each year and happy that I can get out there early Friday to do the BBQ Crawl! I'll be presenting my "<a href="http://sqlsaturday.com/viewsession.aspx?sat=300&sessionid=22709" target="_blank">Capture Change and Apply It with Change Data Capture and SSIS</a>" (I really need to shorten that title) talk at 2:15pm on Saturday.<br />
<br />
I was happy to contribute my first blog post to the RevGen Partners brand new <a href="http://www.revgenpartners.com/about-us/blog" target="_blank">UpShift blog</a> this week, <a href="http://www.revgenpartners.com/about-us/blog/item/10-sql-server-development-tools" target="_blank">SQL Server Development Tools</a>. Check it out if you are curious about what versions of SSDT work with what in the different versions of SQL Server.<br />
<br />
I also had my review of Microsoft BI posted to the <a href="https://www.trustradius.com/" target="_blank">TrustRadius</a> site as well today, "<a href="https://www.trustradius.com/reviews/microsoft-bi-2014-09-09-09-25-37" target="_blank">Why is Microsoft BI Right for Me?</a>". I tried to present as fair of a review as I could based on my 10+ years of experience with the tools.<br />
<br />
<br />Stevehttp://www.blogger.com/profile/05746734170065255114noreply@blogger.com0tag:blogger.com,1999:blog-6499123918250739650.post-37210641082390192072014-08-25T09:23:00.000-06:002014-08-25T09:23:19.211-06:00Denver SQL Server User Group August MeetingIt was great to present at the <a href="http://denversql.org/" target="_blank">Denver SQL Server User Group</a> again after a year plus on my birthday, last Thursday (8/21). I'm up in front doing the introductions and running the meetings every month, so no need to also present there all of the time too. :)<br />
<br />
I presented a 30 minute version of the Date Dimension talk that I have done in many different forms over the last year (including a 10 minute version at <a href="http://sqlpass.org/summit/2013" target="_blank">PASS Summit 2013</a>). Below is the link to download the slides and zip file with the SQL script to create a Date Dimension in seconds.<br />
<br />
<center>
<iframe frameborder="0" height="327" scrolling="no" src="https://onedrive.live.com/embed?cid=43F788CF3BDB5A0A&resid=43F788CF3BDB5A0A%2144042&authkey=AE6VTSb_OTLT-pw&em=2" width="402"></iframe>
<br />
<br />
<a href="https://onedrive.live.com/redir?resid=43F788CF3BDB5A0A!44041&authkey=!APg2ZTqFxK0vmek&ithint=file%2czip" target="_blank">DATEDIMScripts.zip</a></center>
<br />
Thanks again to everyone that attended the meeting, and looking forward to seeing you all again at the September meeting on 9/18. Also, don't forget the <a href="http://denversqlsaturday.com/" target="_blank">Denver SQLSaturday</a> is coming up on 9/20 and we only have around 30 open registrations left before we start up the waitlist. Also there are 3 great pre-cons on 9/19 that only cost $125 for a full day of training. Go to <a href="http://denversqlsaturday.com/">http://denversqlsaturday.com</a> to register for both!Stevehttp://www.blogger.com/profile/05746734170065255114noreply@blogger.com0tag:blogger.com,1999:blog-6499123918250739650.post-40763276317291178672014-07-27T21:02:00.000-06:002014-07-27T21:02:32.357-06:00Mile High Tech Con - Demo/Slides #MHTechConThank 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.<br />
<br />
<iframe frameborder="0" height="120" scrolling="no" src="https://onedrive.live.com/embed?cid=43F788CF3BDB5A0A&resid=43F788CF3BDB5A0A%2139937&authkey=ACtiN4DWxdtr-jk" width="98"></iframe>
<br />
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!Stevehttp://www.blogger.com/profile/05746734170065255114noreply@blogger.com0tag:blogger.com,1999:blog-6499123918250739650.post-75222513231498052382014-06-30T13:18:00.000-06:002014-06-30T13:18:35.836-06:00Mile High Tech Con #MHTechConMy speaking calendar is really filling up! :)<br />
<br />
I have been selected to speak at the <a href="http://mhtechcon.com/" target="_blank">Mile High Tech Con</a> that will be held on July 24-26 at the Auraria Campus in Denver, Colorado! I will be presenting "<a href="http://mhtechcon.com/Agenda" target="_blank">Capture Change and Apply it With Change Data Capture & SSIS</a>" 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 <b>14SK_SteveWake</b> when <a href="http://mhtechcon.com/Registration" target="_blank">you register for Thursday and/or Friday</a> and save some money!<br />
<br />
Looking forward to seeing everyone at this event in a few weeks!Stevehttp://www.blogger.com/profile/05746734170065255114noreply@blogger.comtag:blogger.com,1999:blog-6499123918250739650.post-38635638826760432842014-06-25T10:00:00.001-06:002014-06-25T10:00:51.596-06:00Speaking at PASS Summit 2014! #Summit14I am honored and thrilled to announce that I was selected for the 2nd year in a row to present a session at the <a href="http://www.sqlpass.org/summit/2014" target="_blank">PASS Summit</a>! <a href="http://www.sqlpass.org/summit/2014" target="_blank">PASS Summit</a> is an annual conference put on by <a href="http://sqlpass.org/" target="_blank">PASS (Professional Association of SQL Server)</a> 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 <a href="http://www.sqlpass.org/summit/2014/RegisterNow.aspx" target="_blank">use this link to register</a> 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).<br />
<br />
I will be doing a Lightning Talk (short 10 minute presentation) titled "<a href="http://www.sqlpass.org/summit/2014/Sessions/Details.aspx?sid=6272" target="_blank">What Version of SSDT do I Need?</a>", 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.<br />
<br />
Looking forward to seeing everyone in Seattle in November!Stevehttp://www.blogger.com/profile/05746734170065255114noreply@blogger.com0