Showing posts with label Presenting. Show all posts
Showing posts with label Presenting. Show all posts

Tuesday, November 17, 2015

#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 PASS Summit 2015 in Seattle.

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 Date/Time Dimension talk that I have done many times over the last few years at SQLSaturdays & User Groups across the country.

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 this year's Lightning Talk I decided to focus on Power BI, my new favorite tool in the Microsoft BI stack. And to get that focus down it was on creating dashboards really quickly using Power BI. This was not the first time that I had demo'd Power BI, 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.

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).

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.



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 PASS Summit 2016!

Friday, March 20, 2015

Denver SQL Server User Group March 2015 #denversql

Thanks to everyone that attended my "Near Real-Time Data Warehouse Updates with CDC and SSIS" presentation at the Denver SQL Server User Group meeting last night. For anyone that wants my slides and demo scripts, you can download them from the link below:



Thanks again and I hope to see you all again at a future Denver SQL Server User Group meeting!

Thursday, March 19, 2015

Boulder SQL Server User Group March 2015 #bouldersql

I had a great time presenting to the Boulder SQL Server User Group 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:



Thanks again to everyone from the Boulder SQL Server User Group and the attendees that came out last night!

Monday, August 25, 2014

Denver SQL Server User Group August Meeting

It was great to present at the Denver SQL Server User Group 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. :)

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 PASS Summit 2013). Below is the link to download the slides and zip file with the SQL script to create a Date Dimension in seconds.



DATEDIMScripts.zip

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 Denver SQLSaturday 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 http://denversqlsaturday.com to register for both!

Monday, June 30, 2014

Mile High Tech Con #MHTechCon

My speaking calendar is really filling up! :)

I have been selected to speak at the Mile High Tech Con that will be held on July 24-26 at the Auraria Campus in Denver, Colorado! I will be presenting "Capture Change and Apply it With Change Data Capture & SSIS" 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 14SK_SteveWake when you register for Thursday and/or Friday and save some money!

Looking forward to seeing everyone at this event in a few weeks!

Wednesday, June 25, 2014

Speaking at PASS Summit 2014! #Summit14

I am honored and thrilled to announce that I was selected for the 2nd year in a row to present a session at the PASS Summit! PASS Summit is an annual conference put on by PASS (Professional Association of SQL Server) 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 use this link to register 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).

I will be doing a Lightning Talk (short 10 minute presentation) titled "What Version of SSDT do I Need?", 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.

Looking forward to seeing everyone in Seattle in November!

Saturday, June 14, 2014

BIG PASS and Next Week

Last Thursday evening I had the pleasure to present virtually to the BIG PASS group in Irvine, CA. BIG PASS is run by Mickey Stuewe (blog | Twitter) whom I have meet at the last 2 PASS Summits and multiple other PASS events over the years, was a great time presenting to the group and would love to do it again in the future. I presented my "Building a Better Workstation" session for the first time and to be honest it ran longer than I expected, just so much good stuff to talk about and some great questions from the audience as well. As promised, below is a link to download the slides for this presentation so that you can use all of the links provided in the slides.


Next week will be very busy for me! On Wednesday evening I will be doing presentation for the Denver .NET User Group called "Business Intelligence for the .NET Developer". Looking forward to talking to this group and talking about how my career changed from being a .NET Developer to a BI Consultant and how I think others could do the same (if they want to). If you are in the downtown Denver area on Wednesday evening around 5:30pm MT, please register and stop by!

Update: 6/19/2014 - Thanks to those that attended the Denver .NET group last night, below are the slides from that presentation:


On Thursday morning I will be doing the FREE Pragmatic Works webinar series "Training on the T's" again @ 9am MT/11am ET. I will be presenting the "Building a Better Workstation" session and try my best to get it into the 45 minute timeframe! This is a free webinar, so register here if you are available at 9am MT/11am ET on Thursday. If you can't attend at that time there will be a recording of the whole session posted at a later time and I will update this post with that link once it is available. Looking forward to doing another session for this great series!

Update 6/19/2014 - Thanks to everyone that attended my Pragmatic Works "Training on the T's" session "Building a Better Workstation" the slides are the same as in the first attachment above in this post, so feel free to download them. The video link for this should be posted in the next few days, I'll post that link here as soon as I get it.

Then on Thursday evening will be the Denver SQL Server User Group June meeting at 5:30pm MT in the Microsoft DTC office (7595 Technology Way, Suite 400, Denver, CO 80237). Andy Vold (Twitter) will be presenting "SQL 2014 In-Memory OLTP – What, Why, and How" and Chris Shaw (blog | Twitter) will be presenting "What is the Best Disaster Recovery Solution?". For more details on both of these sessions and our group, please go to denversql.org. All of our meetings are FREE and we try to make as much time for networking as possible at every meeting.

Friday I'm planning on attending my first TDWI meeting at the June Denver meeting. Should be a good meeting with Laura Reeves presenting "Data: The Real Power Behind Today’s Technology". If you are interested in attending this meeting on Friday from 1pm - 4pm MT at Innovation Pavilion (9200 E Mineral Ave, Centennial, CO 80112) make sure you register at this link for this FREE event.

Overall a very busy week for me, but that is way better than just sitting around bored! :)

Thursday, April 10, 2014

SQLSaturday #297

SQLSaturday #297 in Colorado Springs is this coming Saturday! If you haven't registered yet, why not? It's a free event that has the best SQL Server professionals traveling from all over to present and attend this awesome event. If you able to make into Colorado Springs by Saturday, you should be at the event! I will be presenting "Capture Change and Apply it With Change Data Capture & SSIS" at 3:15pm (keep your eyes on the schedule page or use the Guidebook app to track any changes to the schedule). I'm looking forward to seeing everyone this Saturday, make sure you register and support all of the sponsors of this event when you are there.

Below are some more details from Chris Shaw's blog about the food drive that is also being done as part of the event:
What we are asking is that when you come to the event on April 12th that you bring with you food items that you would like to donate the more items that you bring the better your odds are in taking home one of these awesome SWAG items. We will soon be sending everyone who is signed up more details on individuals can participate in our food drive. You don’t have to bring any food items to be registered for the giveaways and there will be opportunities to participate in our Data-Rodeo for additional chances to win. Why a Data-Rodeo you ask? This year’s theme in going to be centered around the old west, our event will be taking place in a historical building that is over 100 years old, in the heart of the oldest part of town.
See y'all on Saturday!

Tuesday, March 11, 2014

Upcoming SQLSaturdays

Sorry for the lack of posts over the last few weeks, it has been very busy, but I will get the last post in the encryption series up very soon.

Wanted to spread the word about a few SQLSaturdays that are coming up, which I will be at!

SQLSaturday #295 - Las Vegas, NV (4/5/14)

This is the first SQLSaturday in Las Vegas and while I did not get one my sessions selected to present, I will still be in Vegas that weekend thru Wednesday (4/9/14). Was a great excuse to take some time to visit Vegas, which I haven't been back to in around 10 years. Looking forward to seeing how the Vegas crew puts on a first time event and meet up with all of the #SQLFamily in a very fun city! If you are going to be at SQLSaturday #295, I'll see you there!


SQLSaturday #297 - Colorado Springs, CO (4/12/14)

Glad to see the Colorado Springs SQLSaturday back on the schedule again after taking a break for a year. Also very happy to be presenting at the event again this year. I'll be presenting my CDC with SSIS 2012 session "Capture Change and Apply It With Change Data Capture & SSIS" later in the afternoon (schedule is always possible to change, so make sure to check beforehand for exact time and room). The organizers are going to do a food drive at this event as well, to help out the local food banks which have been very stressed after all of the wild fires last year. The group down in the Springs always puts on a great event, so please register to attend this event if you are going to be in the Colorado Springs area on 4/12!


SQLSaturday #285 - Atlanta, GA (5/3/14)

The Atlanta SQLSaturdays are typically the biggest in the country (maybe even the world), so I'm very honored to be speaking at this event for the first time! Looking forward to spending some time in Atlanta, instead of just transferring from one flight to another at the airport. I'll be presenting my review of the new features in SSIS 2012 session "SSIS 2012: More Than Just a Pretty UI" in the afternoon. As mentioned above, make sure to check the schedule on this page to verify when and what room I'll be presenting in. If you are going to be in Atlanta on 5/3, register for this great event with over 50 sessions!

Best thing about all 3 of these events, they are all FREE! These events are held throughout the world and put together by community volunteers that want to share with everyone the SQL Server technology that we all love. Also be sure to talk to the sponsors at each event as it would be impossible to put on these events without their support. For those in the Denver area, we are working on the announcement for our 4th SQLSaturday in the coming weeks!

Friday, February 14, 2014

PASS BI Virtual Chapter Presentation February 2014

On Thursday, February 13th I had the pleasure to present my "Master the Date Dimension Like a Time Lord" presentation for the PASS Business Intelligence Virtual Chapter. Was a great group of attendees that had lots of questions, which hopefully I was able to answer to their satisfaction. Also had a few attendees that mentioned they were also big Doctor Who fans as well, which always makes the presentation fun to do when there are those that get the references to the show.

I have presented this session multiple times before, but I keep changing it as I go based on comments I receive. So, since the content changes, below is the link to download the latest version of the slides and the script to build the Data Dimension table as I demo in the presentation.

Master.zip

If you come up with something that you think is really cool added to this script, please send it to me and I can pass on your updates to others as I present this again in the future.

Thanks again to all of those that attended. If you missed the session there should be a recording of the session available soon, and as soon as I get word that it is posted I will update this post with that link.

3/1/2014 - Recording of the session has been posted on the PASS DW/BI VC YouTube page.

Monday, January 27, 2014

SQLSaturday #271 Albuquerque

Saturday I had the privilege to present a session at SQLSaturday #271 in Albuquerque, NM. This was the 2nd year in a row that I have presented at the SQLSaturday in Albuquerque and I love going back each time because Keith Tate, Meredith Ryan and the whole ABQSQL crew do a great job putting on this event. This year the event was in a different location that was pretty amazing looking and the spaces they made available were great too. My session was at the very beginning of the day at 8am, so I had to make sure I didn't party too much the night before at the Speaker/Volunteer party. Speaking of which, that party was held at a local micro brewery and we even had a room that with a glass wall so that we could see all of the beer vats. Beer was great and I even shared this with my wife and son who traveling with me to this event to make it into a mini-vacation from Thursday - Sunday.

Was awesome to spend a few days in ABQ this time as I drove in for last year's event on Friday and left right as the event finished on Saturday. This time with the family we were able to go up to the Sandia Peak Tramway, visit Old Town Albuquerque and Petroglyph National Monument. All great places to visit and always nice to learn about another area of the country!


Back to the SQLSaturday event itself, things started a bit slow (it is a Saturday morning so this is expected), but quickly there were over 100 attendees going to sessions throughout the day. Since my session was first thing I expected that I would have a lower attendance, and while I only had 10 attendees in the room they all commented to me afterwards that they enjoyed it and learned something new, so that makes it all worthwhile! Here is a link to download the file that all of the content from my "Master the Date Dimension Like a Time Lord" session. For those that were not at SQLSaturday #271 and may have seen this presentation in the past, I have updated it to make the script to generate the date dimension for both SQL 2008 and SQL 2012. I also took sometime to clean up some of the code to be more SQL centric instead of Oracle that it was originally written for. I will continue to tweak this script and the presentation over time, so keep your eyes here for future updates to the scripts!

Thanks again to the Albuquerque SQL group and I look forward to coming back again in the future!

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!

Tuesday, September 17, 2013

Building a Technical Presentation - Part 3

After a longer delay than I wanted, it's the final part of my Building a Technical Presentation series! If you missed Part 1 or Part 2, see those links to catch-up.

Practice, Practice, Practice and Practice Some More!

The biggest key to success with presenting that I have learned over the years is that the more practice you can do the better you will feel when it is time to do the presentation. Most of the time that I have been really nervous for a presentation is when I have not practiced the presentation enough or it has been a longer break from presenting. I actually had that happen just this last weekend at SQLSaturday #191 in Kansas City. I was doing a presentation that I have done at least 5 times now, so it was nothing to do with not knowing the material, but it was just because it had been a few months since I was at a SQLSaturday and presenting in front of people. The nervousness only lasted for the first few minutes of the presentation, but it was a weird feeling that I don't recall having in the recent past since I have been presenting pretty regularly this year.

So, you might ask how do I practice? Well everyone does it a little different and you will have to find the way that works best for you. For a lot of people they will stand in front of a mirror and do the presentation or use a video camera or even do it in front of friends/family. I have found that I can practice in my head and it comes off as well as I expect, but that has only come after a few years of doing presentations. The most important thing is to find the way that works best for you and do it, trying to do a presentation cold, without practice is not recommended unless it is something that you are EXTREMELY comfortable talking about (or it is a panel discussion or something like that which really requires no preparation).

Presenting

The next thing that will happen, is to actually do the presentation! Hopefully you have had the chance to get to the room you are going to the presentation early to make sure you understand how things are setup. Leave yourself plenty of time to get your laptop setup and test the connections to the projectors. If you are going to be using a microphone, that is another good thing to make sure you have time to test out and get connected correctly, nothing throws me off faster than fighting with a mic to get it working. Same goes for making sure your slides are working and showing up correctly on the projector.

If you have some time with the people in your presentation before the session starts and there won't be a formal introduction, it might be a good time to do some conversation starters or what some call, "Breaking the Ice". That can help both you and the crowd get relaxed and ready for you to present to them. I like to try and do it sometimes as it does help to take your mind off of the presentation for a few minutes, especially if you are extremely nervous.

As you were practicing, hopefully you worked on not putting in a bunch of "umhs" and "ahs" that are typical time fillers you might say as you are trying to think of the next thing to say. Don't feel like you have to fill every single second of a presentation with your voice, a few pauses are natural and good for the audience as it gives them time to "digest" what you just said. It also gives the audience a chance to ask some questions, assuming you are going to take questions during the session. When questions are being asked it is a good time to take a drink of water to help calm your nerves as well.

Once you have finished your presentation don't forget to thank the audience for attending your session and this is also a good time to thank the selection committee for the event, if appropriate.

Feedback

After you have completed the presentation you will probably be on a bit of a "rush" as your adrenaline will still be flowing and hopefully it all went well. Now you will want to hear from others how you did, hopefully you will get some people that come up to you and tell you how it went, but you can also ask those that you know what they thought too. Another great way to get feedback is to use sites that specialize in that, like speakerrate.com, which I have used for years to track my presentations. This does require that people go to the site and fill it out which can be difficult to get them to do especially when there is no internet access. Some of the events that you go to will provide speaker feedback forms, so you can either collect those at the end of the presentation or the event will collect them and provide the results to you. It is always good to keep track of how well you are doing. Try not to take all of the feedback too personally, some people will be a bit rough, and others will not give a lot of details, so take it all together to help you improve.

Demos/VMs

For this series of posts I wanted to focus on just the speaking and presenting fundamentals for those that have not presented before. The big step that you eventually need to take with presenting will be doing live demos along with talking about topics. While this can be very scary to do, you can make it easier on yourself by making sure that the environment you do these demos in is stable and repeatable. I switched many years ago from doing any demos on the actual laptop or computer that I have connected for the presentation, just because of the stability issues as you usually have lots of other programs running in the background on your main computer (think about Dropbox, backup and virus scanners, IM programs, etc. that are all running in the background). Instead of trying to remember to manually stop all of these programs before you start your presentation, I have switched to using only Virtual Machines or VMs for my demos. The reason I do this is because the VM is something that I build, so it gives me the experience on installing all of these programs and also I make sure to only install what I need in those VMs. And for me the best feature of VMs is that you can setup what are called Snapshots in most VM hosting programs, where the disk image is "frozen" to that point in time and you can just restore back to that before you start your presentation so that you know everything is reset to the way it all worked the last time.

I have tried just about all of the VM hosting applications out there over the years and I have been using Oracle's free VirtualBox for the last 3 years without any issues. Previously I was doing a lot of my demos on a Mac and using either VMWare Fusion or Parallels Desktop and both worked perfectly fine on the Mac, so if you are using a Mac I can recommend both of those, along with VirtualBox which also runs on the Mac. For the last couple of years I have been using Windows laptops, so I did try Microsoft's Hyper-V, but found that it was not built to work well with a laptop, since it has issues with wireless networking and display resolutions. Hopefully with some of the future upgrades to Windows maybe I can switch back to Hyper-V, but at this point I'm using VirtualBox exclusively.

For whatever VM program you do choose, the other big hurdle will be where to get your licenses to install Windows Server, SQL Server, SharePoint Server, etc. As I have mentioned in previous posts I do have a personal TechNet subscription that provides those for me, but that program is being phased out. You can use the evaluation versions of Microsoft server software in your VMs, with the warning that those are time-bombed, so make sure you do check before you do your presentation that you still have time left. Otherwise you hopefully have access to an MSDN membership through your work. I still have hopes that Microsoft will come out with some membership that does not require as much cost as MSDN in the next year to replace TechNet, but no word yet on that.

Conclusion

So that covers everything that I have been thinking about to put into this series of posts and helps to document how I go through the process of creating new technical presentations and then some tips on actually doing the presentations themselves. Thanks for following along with this series and I hope that you found it useful. The best thing that I can hope comes out of this series is if even one person that has not presented before uses this to help them put together their first presentation. If you do that, please feel free to contact me with any feedback!

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!

Thursday, August 8, 2013

Charlotte BI Group - August Meeting

I had the pleasure of presenting my "Capture Change and Apply It with Change Data Capture and SSIS 2012" session at Tuesday evening's Charlotte BI Group to a full room with lots of great questions asked by the attendees. For those that attended, thank you very much for your comments and questions and to the organizers of the group: Javier, Melissa, Jason and Rafael thank you all for letting me present and meet with your group.

For those that want to see the slides that I presented and try out the demos that I showed in the presentation, below is a link to download everything.


The requirements for these samples to work are SQL Server 2012 Evaluation, Developer or Enterprise Editions, AdventureWorks2012 and AdventureWorks2012DW. Also as I mentioned in the session you must have full admin rights to the SQL Server instance that you are going to try and setup CDC on, so a local instance on your own workstation/VM is recommended.

Thanks again and I will see you all again in October at PASS Summit 2013 in Charlotte and/or SQLSaturday #237!

Tuesday, July 30, 2013

Building a Technical Presentation - Part 2

For Part 2 of my Building a Technical Presentation series, I'm going to cover getting all of the ideas for your presentation together and creating the slides. If you missed Part 1 of this series, click here.

Putting Thoughts Together

After coming up with the Subject of your presentation we covered in Part 1, hopefully you also had a bunch of ideas on what you want to cover in your presentation. I have used multiple different tools to capture all of these ideas in the past, including pen & paper, Notepad and Evernote. Lately, I have just started to put these ideas into PowerPoint directly since that is where they will end up for the presentation anyway. I'll just start to put all of the ideas down on a basic bullet list template in PowerPoint and maybe try to start organizing them into a rough outline of what I want the presentation to cover. Do worry too much at this stage to get everything in the correct order or even on slides that make sense, at this stage it's more about just getting all of your ideas down. Try not to edit this too much, even the things that you think are not going to be a great idea may help you come up with something else later on, so put it all down.

Creating the Slideshow

Now that you have most of the ideas together for your presentation (you will not have everything at this point as you will always come up with new items as you build/practice it) it's time to start making the slides that you will use for this presentation. There are some presentations that will not have many slides and others that you might end up with way too many. It is hard to strike that proper balance and only after presenting multiple times will you start to get a feel for your pace. My general rule of thumb is to not try and do more than 5 or 6 slides for a 45-60 minute presentation, when there is a demo involved. As I mentioned in Part 1 you should not push yourself into doing your first presentations with live demos, so the number of slides will be higher if you are presenting in a 45-60 minute slot. As a rule of thumb for myself I know that I will usually talk on each slide for an average of 5 minutes.

The easiest way to start building your slideshow is to start with the title slide. I like to keep it simple, just the title as you submitted the session in large text to make it very clear. Keep in mind that this will probably be the slide that you will pull up before you start your presentation, so you can add some graphics and animation to catch people's attention as you are waiting for the session time to begin and the attendees to take their seats. You should also put your name on this slide along with some basic info like your title and company that you work for (or get a company slide template that has the logo on it, then you can skip typing the company name on your intro slide).

For my presentations I tend to use the bulleted list format for most of my slides, if the material on the slide lends itself to a table, chart or graph I will do that as well. The biggest thing to keep in mind with the text that you put on slide is to not put every word you are going to say on it, use the text on the slide to be summary of what you are going to talk about. Some like to use pictures or other graphics and animations to "spice" up their presentations, but that is completely up to you and how you think the audience you are presenting this to will take that. I think that this is another thing that you will start to use more as you get more comfortable presenting and using the tool to build your slideshow in. Also keep in mind that the more this "spice" you add to the presentation is more of the time that they are not paying complete attention to you and maybe even what you are saying. Just keep the amount of text on these slides to a minimum as much as possible, you want them to be used for you and the audience to keep track of where you are in the presentation and to get the summary points for notes. You don't want to put so much text on them that the audience feels they need to read everything on the slide instead of listening to you.

Along with adding graphics and animations to your slideshow the next big debate is over manually advancing your slides or having them automatically timed. I have yet to do a presentation where I use automatically timed slides, but is becoming a more popular way to do presentations, especially when you have a lot to cover in a short time. Automatically timed slides as you can imagine require a lot of preparation ahead of time to make sure you are in sync with the slides. The big issue with this type of presentation is that you will need to let everyone know to hold questions for the end or have a way to pause it to take questions. Some presenters love doing it this way, as it helps them to keep on time and make sure that they cover everything. That last point is where I think this method goes wrong, I like to make my presentations dynamic and I know that I have never covered the material in my presentations the same way twice. Keeping the audience involved is important and by them not being able to ask questions will make it very hard for them to stay involved.

Dedicate the last couple of slides in your presentation to a quick summary slide, which allows you to go over all of the points you covered. Also put in a slide with your contact info, email, blog address, social networking details, etc. and make sure to mention if you are going to post your slides or extra material to your blog or other site and give them that address and when to look for it.

Now that you have your slides completed you should put the tool into presentation mode and click through each slide to make sure that everything flows well and that you don't have too much detail on the slides. Make sure to read through everything on the slides or even have a friend/family member go through them to make sure you didn't make any silly mistakes. At this time you may have too few or too many slides, which is fine we will get into fine tuning this in the next part of this series.

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".

Monday, July 22, 2013

Building a Technical Presentation - Part 1

I've been looking for something that I could do a multi-part series on with my blog for a few months now and as I started work on a brand new presentation I thought that would be a perfect subject! While I will always encourage people to get into presenting, it can be a bit daunting for anyone that has not done them before or you did them a long time ago (high school or college). Hopefully this series will help you get started on your first presentation and give it at a local user group in the near future!

Subject

As you might expect the first thing that you need to come up with for a presentation is a subject. When coming up with a subject for a technical presentation it can be very broad or specific depending on the time that you have available for the presentation. You can speak about a lot more in a 60 minute slot then you can in a 10 minute one. I have actually found over the years of presenting that I have done now that the longer the time slot the easier it is to come up with something, where the shorter slots require you to really have the details worked out. This might seem counter to how you might think it would go if you have not presented before, but once you get comfortable with presenting you will find that once you get started it will be easy to go for 60 minutes or more on a subject that you know a lot about.

The other thing to keep in mind when choosing a subject is whether or not you will do any demos in the presentation. When you are just starting out with presentations, especially technical presentations I would recommend staying away from doing live demos in your presentations until you are more comfortable. Live demos add a whole set of issues that are very different from just a standard presentation and I will cover that in a later part of this series. For first time presenters I would suggest coming up with something that you can cover by just talking and presenting slides, maybe even a video. Watch out with videos that they aren't too long and if they have audio that the audience needs to hear keep in mind that is time you are not presenting anything. For first time presenters you can use screenshots to cover the step-by-step process, instead of doing a live demo.

When choosing a subject for your presentation it is important to keep in mind what the audience is for the presentation and also if you plan on presenting it in different forums (webinars, user group, SQLSaturday, conferences, etc.). I try to make the subjects that I pick general enough in the early stages that I can mold the presentation to fit different forums and time slots as much as possible. I know that sounds like a lot to think of right from the start, but if you can keep all of this in mind it should help you create a presentation that you will be able to use in a variety of places. Along those lines, I almost never create a new presentation with the thought that I will only present it once. The only way that you are going to make yourself more comfortable presenting is to have something that you can do over and over again. As with everything else in life the more times you do the same thing the better it gets.

You would be amazed at the ways that you can find the subject for a presentation. I have spent hours just sitting down hoping that something will come to me and coming up with nothing and then as I'm sitting down watching TV or reading an idea will pop in my head. The idea for the subject of the presentation that I'm currently working on which inspired this series actually came up in a dinner conversation with a friend as we were talking about past projects. I remembered a specific project I was working on and as I described it to him he mentioned that I should write a blog post about it. I didn't think much about it at the time, but later that night it came to me that while it might make a great blog post it would also make a great presentation. The subject that I came up with was how to create a date/time dimension for a data warehouse, but make it easy to create, update and be reuseable. Sounds simple enough, which is what can make for great presentations, it is something just about everyone needs if they are creating a data warehouse, but they don't want to spend a lot of time on it. It is a broad enough subject that I can create a variety of different versions and it will also have some good demos/scripts that can be used by the attendees.

Title 

So, now that you have some subjects in mind for your presentation you can start to think about titles for your presentation. Depending on the presentation that I'm working on sometimes this comes out right away and other times it may take more time and I have even changed the title of a presentation after giving it a few times because I think that the new title is better. Do sweat it if you can't come up with the title right away, start working on the other pieces of it that I will go over in future parts and I'm sure that something will come up the more you work on it.

Some of the things to keep in mind when you are trying to come up with a title for your presentation is if there are any letter/word limits on the length of it. Depending on where you are planning on presenting this presentation you may find different submission rules for titles. For example, user groups won't really care how long your title is, but if you submit to conferences like SQLSaturday or PASS Summit there are limits and it is generally less than 100 characters. While that sounds like a lot you will find that it can be hard to convey everything you want in the title with that few characters. Thankfully it is rare it is just the title that people will see, usually there is also a session summary that will be many more characters in length that you can use (we will talk about writing these summaries/abstracts in a future part of this series).

There is always a debate on it the title of your presentation should be something witty or funny, especially for technical presentations. This really depends on what your audience for the presentation is, as you do more presentations you will get a better feeling for how comfortable you are with doing titles that might be less serious. I tend to change this up depending on what the subject of my presentation is and where I'm planning on presenting it. SQLSaturdays are a great example of it being like a major conference, but since it is on a Saturday it tends to be more relaxed, so funny/witty titles are more the norm. For a conference like PASS Summit they tend to not be so witty, but if you become known as a speaker that does those kind of presentations then using a witty title will work there as well.

As I mentioned at the top of this I decided on this series as I started working on a new presentation. This presentation that I'm working on is a completely atypical for my presentations, in that I came up with the title for it before I had most of the details for the presentation worked out. Don't get me wrong, I had the subject that I was thinking about, but I had not fully fleshed that out when the title came to me. The first thing that I came up with for this presentation title is because of an acronym. For those of you that don't know me so well, I am a big Science Fiction geek, my dad took me to see Star Wars on opening weekend when I was almost 6 years old (this is the FIRST Star Wars, later re-titled Episode IV, not this prequel stuff), so that had a huge impact on me and to this day I am a big Star Wars geek (yes, I'm very comfortable calling myself a geek). As I was thinking about this new presentation I was also thinking about the 50th anniversary of Doctor Who this year. If you follow Doctor Who you know that it is a time travel series with a character called The Doctor that cannot die of old age and in fact regenerates with each new actor that takes over the role (convenient plot idea to keep a show alive for 50 years). The "ship" that The Doctor uses for time travel is called the TARDIS which is an acronym that stands for Time And Relative Dimension In Space. So, when I knew that I wanted to do this presentation on how to easily create a date/time dimension in a data warehouse I knew that I had to work The Doctor in somehow! The first version of the title I came up with was "TARDDISS: Time And Real Date Dimensions In SQL Server", while clever I wanted to see if I could make it so it didn't sound like a snake was pronouncing this title. After some thinking I came up with "TARDDIS: Time And Reuseable Date Dimensions In Script", this title helped get rid of 2nd 'S' and also does a much better job of stating what the presentation is about.

That is the first part of this series, in the coming parts of this series I plan to walk through the steps that I follow to create this new TARDDIS presentation. The next part will focus on pulling together your thoughts for the presentation and creating the slideshow.

Tuesday, June 18, 2013

Midlands SQL Server User Group - June 2013 Monthly Meeting

Thank you to all of those that came to the Midlands SQL Server User Group meeting tonight in the Columbia, SC area. I presented my "Capture Change and Apply it With Change Data Capture & SSIS 2012" session and there were lots of good questions that I hope will lead to at least some of the attendees trying out CDC in their environments!

Below is the link that I promised during the session to download both the presentation slides and all of the scripts and code that I used in the demo.


The requirements for these samples to work are SQL Server 2012 Evaluation, Developer or Enterprise Editions, AdventureWorks2012 and AdventureWorks2012DW. Also as I mentioned in the session you must have full admin rights to the SQL Server instance that you are going to try and setup CDC on, so a local instance on your own workstation/VM is recommended.

Friday, May 17, 2013

Denver SQL Server User Group - May 16, 2013

Last night I presented "Capture Change and Apply it with Change Data Capture and SSIS" at the Denver SQL Server User Group meeting as a representative of our sponsor for May, Pragmatic Works. Session went well, got some really good questions and comments to make the session even better which I will be working on before I present it again at the Midlands SQL Server User Group next month!

For those that want to use all of my sample code from the presentation, feel free to download it from the embedded link below and try it out on your own computer. The requirements for these samples to work are SQL Server 2012 Evaluation, Developer or Enterprise Editions, AdventureWorks2012 and AdventureWorks2012DW. Also as I mentioned in the session you must have full admin rights to the SQL Server instance that you are going to try and setup CDC on, so a local instance on your own workstation/VM is recommended.

Thanks again to all of those that attended the Denver SQL Server User Group meeting last night!