Showing posts with label PASS Summit 2013. Show all posts
Showing posts with label PASS Summit 2013. Show all posts

Friday, December 13, 2013

SQLSaturday #271 Albuquerque

I'm a bit late in getting the news out on my blog, but I will be presenting at SQLSaturday #271 in Albuquerque, NM on January 25th! I will be presenting my new "Master the Date Dimension Like a Time Lord" presentation that I did for the first time at PASS Summit 2013 as a Lightning Talk.

Now you will be able to see it as a full hour long session and dig into all the details on using a single script to create a Date Dimension that can cover all of the uses you can think of for a data warehouse! And yes, if you can't tell from the title of the session, there will be references to my current favorite TV show, Doctor Who mixed in! :)

Please register to attend SQLSaturday #271 and I'm looking forward to going into Albuquerque early to enjoy the area with my family and see all of you at the event on 1/25!

Wednesday, December 11, 2013

Denver SQL Server User Group Holiday Party

Instead of our normal monthly meeting next Thursday (12/19), the Denver SQL Server User Group will host a Holiday Networking Party sponsored by TekSystems at Great Northern Tavern (8101 East Belleview Avenue, Denver CO 80237). We will have limited space, so if you want to come you will need to RSVP at http://denversqlugholiday2013.eventbrite.com. The party will start at 5:30pm and go until we get kicked out of the room or run of things to talk about! There will be appetizers and a limited number of drink tickets as well as some prizes to give away. It will be a great time to get together and just talk about whatever we want to, no formal presentations, just food, drink and good company! :)

As a courtesy to others that may want to come, please only RSVP if you know you can attend and if you have RSVP'd and find that you can no longer attend, please cancel your RSVP via the EventBrite page.

Also, while I'm talking about DSSUG, just wanted to send out a quick thank you to everyone that used our PASS Summit 2013 registration discount code. The group will receive $250 from PASS because of the number of people that used the code for their registration to PASS Summit 2013! We will be sure to put that money to good use for the group in 2014. Keep your eyes out in 2014 for more of this type of registration discount code for other conferences.

Sunday, October 20, 2013

PASS Summit 2013

PASS Summit 2013 was in Charlotte, NC this year for the first time and after a few years in a row in Seattle, WA. Was great to get away from Seattle and I have been flying in and out of Charlotte all year, so it was nice to spend some time inside the downtown (Uptown) area itself. After spending a whole week in Charlotte, I really love the city and hope that I will be able to spend more time in the city again. Now for my summary of the week at PASS Summit 2013!

I got into Charlotte at around 1am on Monday, October 14th after the 6 hour drive from Jacksonville, FL after 3 days of PDW training at Pragmatic Works HQ (more on this in a later blog post) and some off-roading fun with co-workers. I was not signed up for any pre-cons on Monday or Tuesday so I had all day Monday off to enjoy the sights and tastes of Charlotte! Started the day on Monday with a guided Segway tour of Uptown Charlotte. I have never been on a Segway before, so there was a brief intro to how to use it and surprisingly it only takes a few minutes to pick up how it works. The tour was awesome and I would highly recommend it to anyone that is thinking about. From there I got my registration materials for PASS Summit 2013, which I got to use the Speaker registration area for the first time! The one recommendation I have being a first time presenter at PASS Summit is to still give the speaker shirts to even those that only do a Lightning Talk session. I understand that they are only 10 minute sessions, but this is how speakers get their first chance to present to a large conference and it shows that you are still part of the speaker core for the event.

After registration and saying hello to all of the #SQLFamily that were already at the Charlotte Convention Center we made our way to The Olde Mecklenburg Brewery for lunch and some beer! Was great to find a place in the US that makes an authentic Düsseldorf style Altbier. I lived in Düsseldorf, Germany for a year right out of college and Altbier was one of very first beers I ever liked to drink (didn't like American beer at the time) so I was really happy to have it again after 15+ years. They also had a lot of German food, which was very good as well. The next stop on our Charlotte craft beer tour was supposed to be Birdsong Brewery, but the were not open on Monday, so we then wandered over to NoDa Brewery which was right across the street and they weren't open for another 30 minutes or so. We decided to walk the extra half mile or so to Heist Brewery, which probably one of the larger craft brewery facilities with lots of dining/bar space. Beers at Heist were very good and the Beer Cheese with Pretzel sticks was excellent.

By the time we got back into Uptown it was time for the annual Networking Dinner that Andy Warren and Steve Jones organize at the Buffalo Wild Wings attached to the NASCAR Hall of Fame and right across the street from the Charlotte Convention Center. Was a huge crowd of people at the event this year, was great to see so many new and familiar faces again. After the Networking Dinner wound down I walked over to the Carolina Ale House, which became the unofficial home for many before/during/after events during PASS Summit 2013.

Tuesday was a day full of meetings with PASS for me, being a local Chapter Leader and SQLSaturday organizer, PASS always sets up this day at Summit for us to get a chance to talk with them and the other leaders/organizers. Meetings were good and I think that many new ideas were expressed. I have to say that I think the format of the meeting at last year's Summit went a bit better, especially the SQLSaturday Roundtable where I heard about some great ideas for helping the event run more smoothly, which did implement for SQLSaturday #190 a few weeks ago and it did make a difference. Tuesday evening was the PASS Summit Volunteer Party at a local bowling alley in the EpiCentre. Another great event that PASS puts on for those of us that help organize and speak at the event each year. This is the 2nd year that I have been able to attend this event and it is always a great time to wind down and enjoy some fun with everyone that helps make this event what it is every year. Later that evening was also the first night of #SQLKaraoke at Fox and Hound (conveniently only a block from my hotel, Dunhill Hotel). I stay way too late at the karaoke event, but it was just way too much fun.

Wednesday is the first actual day of the Summit, and since I was out way too late for #SQLKaraoke I didn't wake up early enough for the keynote (plus I knew it would be recorded and online) and I wanted to make sure I was well rested since I had my first presentation at Summit later that afternoon. Wednesday is SQLSaturday shirt day at Summit, so I made sure to put on my Kansas City #191 speaker shirt before going to the convention center. I stopped by the Community Zone to see how things were going with the setup there and also visit some of the community leaders there. I also stopped by the Pragmatic Works booth to see how it was setup and meet some of the people from our sales offices that I had not yet met. The lunch on Wednesday is always the Chapter lunch, where each chapter has table(s) in the lunch area and they encourage everyone to sit at the appropriate tables for where they live. The Denver group had 4 tables this year and we had at least 3 of them filled during the lunch and there were some new people that we hope to see at future meetings! Always love that PASS does this at the Summit each year and we have found a few new members each year from that, so it is more than worth it. The afternoon went by very fast as I spent some time preparing in the speaker room before my presentation slot late in the afternoon. The setup for the presentation didn't go as smoothly as I would have hoped. They put the Lightning Talks in a smaller room again (this is a not so good tradition at Summit as Lightning Talks are becoming more popular) and while there is a 6 port video switcher in the room, only 2 or 3 are setup. For the Lightning Talks it would be nice if all of the ports were made available and we could all get our laptops setup and tested, instead we each had to rush up there when it was our time and get connected. There were some very good presentations during the Wednesday slot I was in, including Rob Volk and Ed Watson's "DBAs in Toyland" presentation. The scariest thing about this presentation that I learned from Ed Watson afterwards is that all of the nightmare scenarios they covered all really happened! I think that mine went ok, my resolution did not get setup like I wanted in the VM, so some things were getting cut off on the screen. I was able to get through all of the material and I think that at least a handful of people got my Doctor Who jokes/references. After finishing my presentation I needed to get back to the hotel to change for the Exhibitor Reception at the Pragmatic Works booth, since we have done a free book signing now for the last 2 years which is very popular and we need everyone there just for crowd control. We were also passing out wristbands for our #SQLKaraoke event at Prohibition/Sip later that evening as well. The reception went well, had some issues with the line for the book signing, but we were able to give out all of the books we had in about an hour. I left the reception early to get to our event (which was conveniently across the street from my hotel) and see how the prep was going. Surprisingly there were already quite a few people there even though it was clear on the wristbands that it didn't start for another hour. The location quickly filled up and there were a lot that got up a did karaoke in front of the live band or just traditional karaoke. Another very successful event with over 600 people attending!

Thursday was the one day that I knew I would be able to attend some sessions, as I only had to work in the Pragmatic Works booth from 9am-noon, the rest of the day was free. The booth duty was very easy since most of the attendees were in the keynote at that time. After lunch I did attend a SQLCAT session on PDW, which I have to say was quite disappointing since there really wasn't a lot of PDW specific content as the title/description indicated. For the next session I went to see the 2nd Lightning Talks sessions to show my support for the other speakers doing what I had done the previous day. These talks were all good as well, but the standouts were Niko Neugebauer and Richard Douglas. Richard did a session on explaining T-SQL to a Star Wars geek, which was very funny. Niko had the assistance of Scott Stauffer for a very funny and informative session on NodeXL. Also, the Denver area had a 2nd presenter in the Lightning Talks with Jeff Renz doing a quick overview of his favorite topic, DataVault! The last session of the day is one that I have gone to at many conferences over the years and love it every time, the "BI Power Hour". This is a session as they point out that has absolutely no content that you will be able to use in your normal work, but does show some ways to use the Microsoft BI tools that you have probably not seen before. We finally got a very valid explanation (at least in Matthew Roche's view) of why the products all have Power at the beginning at are collectively called Power BI. As always there was a lot of SWAG that they threw out into the crowd, and since most of us in the front row got into the room 30+ minutes before the session started, we were each given one of these SQL Server 2012 USB 8GB flash drives/phone chargers (called 8GB Powerstick).



Pretty cool device, but definitely the largest USB flash drive I have ever seen. Thursday evening at PASS Summit is the Community Appreciation Party which all attendees are invited to and this year it was held at the NASCAR Hall of Fame, which is right next to the convention center. Since that event didn't start until later in the evening I decided to get some dinner with friends at a sushi restaurant, fantastic food and even better company and discussions. This is by far the best thing about going to PASS Summit is all of the side networking that goes on during the week. After dinner I headed back to my hotel to change clothes and drop off my bag. Since it was so late and the event was going to end soon I used my hotel's free limo service to drop me off, saving at least a half hour. The event was good, was closed to the public, so only the attendees of the conference were let in and we had the chance to see the whole place. Nice setup in there with the cars, but not being a NASCAR fan (love Formula 1 and IndyCar) I didn't really get much out of it. A group of us decided to try and find another #SQLKaraoke location and there was a place near the Carolina Panther's stadium called, Hartigan's. Very interesting place (those that attended or know about this place will know what I'm talking about) by far the funnest place I've been to for #SQLKaraoke. Had to leave early though since I was scheduled to be in the Community Zone from 7am - 8am on Friday.

Friday started way too early, especially after a late night at #SQLKaraoke, with getting to the Community Zone before 7am. Not sure why we needed to be there that early since the only attendees coming in that early were looking for coffee and breakfast. It was fun to talk to other community leaders though and get/share ideas on running our groups. Worked out well to be sitting down in that area though, since I got pulled into a PDW Roadmap meeting that I was not directly notified of ahead of time, but got pulled in to represent Pragmatic Works. Very interesting information, but nothing that I can talk about here since it was a NDA protected session. After that, I grabbed some early lunch with co-workers and then headed back to the exhibit hall for more Pragmatic Works booth coverage. Got to do a lot more demos during this time since many attendees were trying to get through all of the exhibitors before the floor closed at 2pm. Once the hall closed it was time to break down, amazing how fast most of those big booths can get torn down! I had to leave for a few minutes to get my rental car to use for my speaking at SQLSaturday #237 (more on this in a separate post) and getting to my client site in Columbia, SC on Sunday.

That ends what happened as part of PASS Summit 2013 for me, but my time in the Charlotte area did not end until Sunday! Overall, PASS Summit 2013 went by way too fast (as it always does), but it was great as always to spend time with #SQLFamily and get some more learning on to keep up with all of the changes are always happening with Microsoft SQL Server. My biggest to-dos that I still have left is to watch both keynotes that I missed via streaming media, if I pick up anything from that I'll make sure to put together a separate post on that as well. There are also many other sessions that I missed, but I knew that our chapter would be getting access to the recording for all sessions, so I wasn't too worried about that and will catch up on those as soon I get access to the recordings. Attendance at the event seemed very good and the convention center did work very well. The main complaint that I would have about the convention center itself is that the exhibit hall was kind of out of the way, being on the lowest level with the meal hall, but nothing else down there. Some exhibitors that I talked to were saying that it was hurting them, since there was not as much traffic as there would normally be when that hall is in the main traffic flow of the convention center. I'm sure that I will think of other things in the days ahead as I'm able to process things more, if necessary I'll add updates to this post or create new ones.

Tuesday, October 8, 2013

T-SQL Tuesday #47 - SWAG

It T-SQL Tuesday again, and for this month's topic it is about the Stuff We All Get (Stuff sometimes replaced with another word) or SWAG!

I have been going to technical conferences since around 2000 when I started going to TechEd and PDC as a .NET developer and PASS Summit for the last 7 years along with the short-lived Microsoft Business Intelligence Conference. Through all of those conferences as you can imagine I have received a literal ton of SWAG.

While the conference bags are usually really nice and I do end up using some of them afterwards (I hate using them at the conference I get it for though because I'm afraid of mine getting mixed up with everyone else's). I'm going to pick my one favorite as something that I pack for almost every trip and grab to take with me almost every evening in the fall and spring.



This is the pull over that was given to all of the speakers and organizers of SQLSaturday #169 in Denver 2012! We debated on what we were going to do for a speaker shirt to be different that year and since our SQLSaturday is in late September, we thought it would be great if it was a pull-over that could be worn over any other shirt on those colder evenings/morning. We even had a version for women that was slightly different, in that it was cut more for women in the middle and had the holes at the end of the sleeves so that it could be pulled down on the arms and would not roll up. I actually like that we didn't do that for the men's version since I tend to pull up my sleeves sometimes.

That is definitely the one bit of SWAG that I have received over the last 13 years that I really like and use a bunch. Looking forward to seeing what the SWAG will be next week at PASS Summit 2013 (if you haven't registered yet, there is still time and use code SUM521CH to get $150 off!). For those of you going to Summit, see you next week! :)

Wednesday, September 11, 2013

SQLSaturday #191 & PASS Summit 2013

For those that are in the Kansas City area, I'll be there this weekend to speak and enjoy the area (hopefully getting to ride some coasters at Worlds of Fun too). So, if you are in the area, make sure you stop by to see my session in the Amazon room at 11:15am on SQL CDC and SSIS 2012, titled "Capture Change and Apply it With Change Data Capture and SSIS". Currently registration for the event is full, but you can get in on the wait list. Hope to see you all there! This is my 2nd year in a row at the KC SQLSaturday event, so I'm really looking forward to catching up everyone that I know in the area, and meet a bunch of new ones too.



Today, PASS released the full schedule for PASS Summit 2013 in Charlotte, NC where I will also be presenting! I have attended the PASS Summit every year since 2007 when it was in my backyard at Denver. This year I'm really excited that I get to join the long list of great speakers, while I'm only doing a Lightning Talk session (10 minutes or shorter presentations) this year, I'm hoping that will lead to being chosen for regular sessions in the future. My presentation titled, "Master the Date Dimension Like a Time Lord" will be on Wednesday, October 16th at 3:00pm in 212A-B in the Lightning Talk 101 or LT-101 session. I have made a point of attending the Lightning Talk sessions over the last few years, because it is a great way to see new speakers and lots of great quick presentations in just a single session (yes, I know there are 2 separate Lightning Talk sessions, LT-102 is on Thursday, same time, same room with fellow Coloradan, Jeff Renz presenting).

Monday, August 26, 2013

SQL Community Updates

Just a few quick updates on things going on with the #SQLFamily!

SQLSaturday #190 Denver Pre-Cons

We are offering pre-cons for the first time this year at SQLSaturday #190 in Denver on Friday, September 27th. There are 3 different pre-cons to choose from and they are priced at $99 until 8/31 on 9/1 the early bird price will expire and the cost will go up to $125, so register before 8/31! Below are the 3 pre-cons we are offering:




Carlos Bossy - Predictive Analytics in the Enterprise 
Tim Mitchell - Real World SSIS: A Survival Guide 
Dmitri Korotkevitch - SQL Server Internals from the Practical Angle

Go to http://denversqlsaturday.com for more details and to register for the pre-cons and the SQLSaturday itself on Saturday, September 28th!


SQLSaturday #237 Charlotte BI Edition

If you are in the Charlotte area for PASS Summit 2013, stick around through the weekend and come to SQLSaturday #237 on Saturday, October 19th. I am honored that I have been selected to present my "SSIS 2012: More Than Just a Pretty UI" session at the event. Looking forward to seeing everyone that was at PASS Summit earlier in the week and those that were not able to attend Summit.



Charlotte BI Group - October Meeting

And while I'm talking about the Charlotte area I am also planning on attending the Charlotte BI Group meeting on Tuesday, October 1st as well. I'll be in the Columbia, SC area that week, so why not spend some time with other #SQLFamily and get a preview of what Melissa, Jason and Rafael will be presenting at PASS Summit a couple of weeks later!

Wednesday, July 24, 2013

I'm Speaking at PASS Summit 2013!

While I didn't make the cut for the regular sessions at PASS Summit 2013, I have been selected to speak in one of the two Lightning Talk sessions that will be during the conference on October 15-18 in Charlotte, NC! If you haven't yet registered for the conference, use the code SUM521CH to get $150 off.

I'm beyond excited to finally get to present at the PASS Summit, which I have been attending regularly since 2007. I don't yet know the details of which of the two Lightning Talk sessions I will be in, but as soon as I get those details I'll post an update here. I'm also very happy that they chose the funnest of the sessions that I submitted, which is titled "Master the Date Dimension Like a Time Lord". If you read my blog post on Monday then you already know that this session will be related to a regular presentation that I'm already working on for User Groups & SQLSaturdays (I actually submitted it as a regular session for PASS Summit as well).

Hope to see you all in Charlotte for PASS Summit 2013 and if you are coming, come and say hi!

I also got news last night that I will be presenting at SQLSaturday #191 in Kansas City on September 14th! This will be the 2nd year that I have presented at the Kansas City SQL Saturday, so I'm really looking forward to seeing familiar faces there in September. I will be presenting my CDC/SSIS 2012 session titled, "Capture Change and Apply it With Change Data Capture & SSIS".

Tuesday, April 23, 2013

MSCA & MCSE

I wanted to put this post up earlier, but waited for official confirmation from Microsoft. Last Wednesday I took the 70-462 (Administering Microsoft SQL Server 2012 Databases) certification exam and passed it!

Those that know the new SQL Server 2012 certification setup are saying, "So what, you still have 1 more to pass before MCSA and 2 more after that for MCSE". Yes, that is correct, but thankfully I was able to take all 5 of the exams in the SQL Server 2012 MCSE Business Intelligence series when they were in beta form last Spring. After waiting a few months to get the results on those beta exams (when you take them in beta you don't get the immediate results like you do for normal exams, they have to manually graded and evaluated) I found out that I had passed 3 out of the 5: 70-463 (Implementing a Data Warehouse with Microsoft SQL Server 2012), 70-466 (Implementing Data Models and Reports with Microsoft SQL Server 2012), 70-467(Designing Business Intelligence Solutions with Microsoft SQL Server 2012). Ironically enough these are the last 3 exams in the series, not the first ones. I already passed 70-461 (Querying Microsoft SQL Server 2012) in March after a few attempts as well.

With that I got my confirmation on Saturday morning from Microsoft that I had achieved the requirements for the SQL Server 2012 MCSA (Microsoft Certified Solutions Associate) certification. While I was relieved to get that message, I immediately logged into the MCP (Microsoft Certified Professional) website to see if everything was there for MCSE (Microsoft Certified Solutions Expert) Business Intelligence as well. For some reason it was only showing the MCSA, not the MCSE. I was a bit surprised, but figured I would wait a couple of days to see what happened. Sure enough on Sunday morning I did get the message that I had the MCSE as well. Guess the MCP systems run a pass each night and can only pick up one of these certifications at a time.


For those of you out there that are also trying to get the new SQL Server 2012 certifications, keep pushing yourself to get them. For me getting these certifications is more of a personal goal, even though there are some benefits from Pragmatic Works as well. Hopefully you will also get the support your need. I have linked to each of the pages on the Microsoft site for the exams that I took. Microsoft has also published a great series of pages and videos on the Born to Learn 90 Days to MCSA series. If you are in the Denver area there is a Certification Study Group that meets every Thursday (except the 3rd Thursday of each month) at the Cherry Creek Presbyterian Church - Community Life Center (contact marketing at denversql dot org for more information).

If you have never taken a Microsoft certification exam before, I would encourage you to sign up to take one to get an idea of what they really are like, even if you really aren't ready. If you can sign up for one before May 31 there is a Second Shot deal going on, where you can get a voucher code that allows you to retake an exam that you didn't pass the first time again for free. Just make sure you request the voucher first and when you setup your exam appointment put that code into the voucher box on the registration form, then you will need to use that same voucher code again when you register to retake that same exam again. The Second Shot vouchers only work if you put it in the first time you take that specific exam.


This was my big goal for early 2013, so I'm glad to have that one off my back. I'm enjoying not worrying about studying for any other certifications right now, but I'm sure I'll find more to challenge myself with! I'm pushing myself to do more speaking engagements this year and so far it looks like it is paying off with 2 SQLSaturdays over the next 2 months (#215 in Jacksonville, FL & #200 in Philadelphia, PA). I'm planning on speaking at the Charlotte BI Group in August and I will be submitting for at least 3 other SQLSaturday's for September thru October. Plus, I did submit for PASS Summit as well, which hopefully I will get chosen for as well.

Good luck!

Sunday, April 14, 2013

SQLSaturday #215 & SQLSaturday #200!

I've got a couple of upcoming events that I will be speaking at that I wanted to make sure I spread the word on.

First on 4/27 I'll be in Jacksonville, FL to present at SQLSaturday #215. Please visit their website to register and view the complete schedule for the day! They are also doing a pre-con on 4/26 with Brian Knight and Devin Knight on Building a SQL Server 2012 BI Platform, should be a great session (I'd be there too, if I didn't have to drive from Columbia, SC to Jacksonville on Friday afternoon).

And earlier today I found out that I will also be presenting on 6/1 in Philadelphia, PA at SQLSaturday #200! I really happy to be spreading out and presenting in more new places this year and Philly will be great since my Dad lives in the area and will give me a chance to spend some time with him in the days before the SQLSaturday (hopefully I can convince him to come out to the SQLSaturday and see my present too). The schedule for SQLSatuday #200 should be up sometime Monday, so check this link and it should be there soon. Click here to register for SQLSaturday #200!

Hopefully I have some more events that I'll be presenting at in the future as well, looking at SQLSaturday #191 in Kansas City (had a great time presenting there last year) and SQLSaturday #227 in Charleston, SC on the Saturday before PASS Summit 2013 in Charlotte, NC.