The Presenters Packing List

In my previous post I mentioned a packing list. I use this list prior to heading out to speaking engagements. I thought others might find it useful so I thought I’d put it here, along with a short explanation when needed.

Laptop – Pretty obvious

Backup Laptop – I bring my netbook along, as a backup computer. Just in case the main one dies.

External Hard Drive – I also bring along an external drive that has all my presentations, necessary ISOs, etc. This way in a real crisis I can borrow another presenters laptop to do my presentation. This actually happened at a SQL Saturday, only it was my laptop that got borrowed when a fellow presenters laptop failed to boot. Fortunately he had everything on a thumb drive.

Extension cord – I have been in a few venues where the power plug was almost out of reach. I keep a 12 foot extension cord in my bag that has three, three prong outlets on it. Even if you don’t need it for your presentation, it’s quite handy in the hotel room, and especially so if you’re flying. Often waiting areas have few outlets, most of which are usually occupied. I’ve never been turned down though when I whip out my handy extension cord and ask if we could both plug into it.

CAT-5 Network Cable – I keep a 12 foot network cable in my backpack, I’ve been to several places that had no wireless but did have wired. Heck, even going to business meetings it’s come in hand on more than one occasion. Also great in the hotel room as you can run the cord a distance and relax in bed.

Spare Mouse – Normally I like a trackball, but it’s easy enough to forget, so I keep a small travel mouse in my bag all the time.

Presenters Mouse – Please, please, please my fellow presenters! If you are going to present and have more than 3 slides in your presentation invest in a decent presenters mouse. It’s very distracting when you stand by the screen, then have to keep running back to your laptop to advance to the next slide.

Zune – True, I don’t use it during the presentation, but I keep it handy when I travel.

Kindle – Again, not used during presentation, but a great way to make the trip go by quickly, or to look up an answer to something you’ve been asked.

Cell phone – OK, I admit it, I once went to a week long convention and left my cell phone sitting in my desk charger at home.

USB Cords – Check to make sure you have all the cords you need for all the toys you are bringing. You will need at least one for each device, so you can interface with and also recharge.

Powered USB Hub – If you have more than a few devices, you might also wish to bring along a powered USB hub. Even if you don’t plug it into your laptop you can still use it to charge all your stuff.

Spare Batteries – I use rechargeable batteries in everything, a great investment and good for the environment. Before I leave I swap out batteries in everything I’m bringing for fresh ones, and make sure to bring enough spares to resupply everything at least once. If you are going to be gone a long time, you might also bring along your battery charger.

USB Thumbdrives – I keep a few thumbdrives in my bag, usually ones I picked up at some conference for free. I’m often asked by attendees if they can get a copy of my demos/slides, but then they don’t have a drive. Sometimes I even have the foresight to put the material on them in advance.

Business Cards – I bring along a big stack of business cards, they are easy to hand out (put a pile by the door and near or on the podium). Let’s face it, while business may not be your main motivation for being there, you wouldn’t want to turn any potential new customers down either.

Pen/paper – Keep a small notepad and paper handy, it’s great for writing down contact info, or “to do’s” that arise during an event.

Mouse pad – Sometimes your mouse just won’t work where you need it to, maybe the surface is too reflective, or not reflective enough. A spare mouse pad fixes that quickly.

Laptop cable locks – If I’m going to a multi-day conference, I might only need my big laptop for the day of my presentation. For the other days my netbook will do fine. To make sure my big laptop is safe in my room I use a cable lock to secure it to my desk or some other fixed object. Also handy if you want to leave it in a speakers lounge for a while, sadly there have been incidents where laptops have gone missing.

Penlight – I keep an inexpensive penlight in my bag, sometimes I have to get down low to run my power cord / video cable, or perhaps dig deep in my bag for something. A little extra light never hurts.

Swiss Army Knife – I have a collection of Swiss Army Knives, but by far my favorite is the CyberTool. It’s made for working on computers, I’ve found it extremely useful. Warning, you can’t take this on the airplane with you thanks to TSA rules, but you can put it in your suitcase so you have it while you are at your destination.

Swag – If you plan to give away anything, don’t forget to bring it along.

Cash – Keep a small amount of money in your bag. Maybe $20 (or the equivalent in your local currency). Keep it in small bills, plus a few dollars in coins. One late Sunday night I was caught in an airport with no open restaurants. Naturally there’s been no meal service on the plane and I was hungry. Fortunately I had quite a few ones and some change on me, so I was able to grab some food from the vending machines. Not fine cuisine, but kept me alive and my stomach from rumbling. Also handy if you have a car and need to stay in a parking deck or feed a curbside parking meter.

Power Supplies – Don’t forget them.

The “Extras”

Sometimes when I travel, if I’m going by my own vehicle and I’ll be there for several days, or if I’m helping to host an event, I’ll grab my “extras” bag. It’s a spare laptop bag, one of a bunch I’ve gotten from attending various conferences. In it I toss in things I might need. Among some of the contents are:

Extra CAT5 network cables; Extension VGA cables; A power bar with multiple outlets; small network hub; a variety of USB cables; Extra earbuds for my Zune;

Start Packing

Well there’s my list. Use it and adapt it as you see fit. Feel free to leave a comment with your own ideas of things in your laptop travel bag.

Advertisement

Speaking on the SS Titanic

If you listened to the episode of Deep Fried Bytes that I was interviewed on you’ll recall I was interviewed along side fellow SQL Server MVP Denny Cherry (blog | twitter). He recently wrote a blog post called “When the demo’s don’t work the men and women are separated from the boys and girls.

I know from the perspective of the audience it looks like presenters are calm, rehearsed and have everything under control. Sadly, we are usually freaked out, winging it, and trying to herd a group of cats.

Well OK, it’s not quite that bad, but sometimes it does feel like it, especially when disaster hits in the form of our demos going bad. Denny and several others have been sharing stories about their demo disasters so I thought I’d give you a glimpse into the scary mind that is Arcane Code and share with you too.

Demoing Beta software is a lot like working with kids and animals

The old show business wisdom of “never work with kids or animals” could easily extend to beta software. I was demoing the early beta of PowerPivot. I’d rehearsed and work though my presentation several times all without a hitch. So naturally when I was doing it before the audience, nothing seemed to work right. The data imports crashed, none of the charts would display correctly, and it crashed Excel twice. What to do?

Well, I’m a big believer in Scott Berkun’s advice in “Confessions of a Public Speaker”. Let the audience in on it, don’t try to BS. Heck, a lot of the time there are people in the audience far smarter than I am. I’ve even had PHD’s attend my sessions. Even if an audience member is new at coding they’re still smart enough to smell someone trying to feed them a line.

So I simply admitted what was happening, explained what they should be seeing, and kept going. I skipped ahead to some things that were working, fortunately this group took an intermission about halfway through the meeting for a pizza break. While they chowed down I was able to reboot, and get the demos working again. I even had enough time for a few pieces of pepperoni myself!

When they returned, I brought them up to speed on what I’d done, showing them the now working pivot charts. I finished off the section I was on, then returned to my original flow.

A pretty shade of Blue

On two occasions I’ve been bitten by the “Blue Screen Of Death” The first was trivial, I was presenting at CodeStock last year. (By the way CodeStock is open for registration and speaker call, go check it out.) Just as I advanced to the very last slide in my deck, the “any questions here’s my e-mail/blog again” slide, the audience started laughing. I turned to see the “BSOD” screen on the big projector. Fortunately the session was over and I was able to field questions without needing the computer.

The other time though had a bit more of an impact. It was fairly early in my presentation and I had installed Windows 7 Beta 1 on my PC so I could learn it. A few slides in my laptop screen suddenly went black. I was puzzled then saw a BSOD quickly followed by a reboot. What to do?

Well, I just made a quip about using beta software, then proceeded to talk about what had been on the slide I’d been showing and the next one as well while my machine rebooted and I started launching PowerPoint and my demos. It’s a bit hard to talk and launch, but you can get the hang of it, and I think short pauses are OK, especially if the audience sees what’s up. Remember, they can feel your pain, everyone has experienced that lovely shade of blue at some time or another.

More power Scotty, I need more power!

My worst disaster wasn’t directly demo related, nor did the audience ever see it, but it was still a nightmare. I had traveled 3 hours to attend a SQL Saturday. I got to the hotel about 11 pm, to my horror I found I’d left my laptop power supply at home. To make it worse, I’d been using the laptop on the way over (don’t worry my lovely wife was driving) so there wasn’t a lot of battery power left.

Fortunately my wife had her laptop. I wound up staying up until 4 am downloading the various ISOs I needed to install the software I needed to do demos on her computer. Bleary eyed I showed up the next day and was able to do my presentations, using her laptop plus sucking up the remaining power on my laptop. It was a close call, on my laptop I had about 15 minutes of power left when my session was over.

Pain is funny

If you look at YouTube, you’ll find no shortage of people hurting themselves. Falling off things, getting whacked in inappropriate body parts, and we all laugh. So as you laugh at my pain, I hope you’ll take away some of the lessons I learned, should you speak, or even do a presentation at your office.

1. Never BS. Follow Burken’s advice, if something goes wrong simply acknowledge it and move on.

2. Know your stuff. When your computer crashes, and it will, be prepared to keep talking. Know your slides well enough so you can talk even without them. Be prepared to describe in vivid detail what the audience would see if Visual Studio / SQL Server / your tool of choice was running.

3. Create a list, and check it twice. After the forgotten power supply incident, I created a packing list. I have on it all the things I’ll need to do demos with. I check it, and double check it, before I zipper up my laptop bag and suitcase.

4. Have a backup box. I got home from a trip a few years ago, to find the internal screen on my laptop had quit working. I was lucky that it was when I got home, but it still taught me a lesson. Now when I head out, I have two laptops, my main demo box and my netbook.

As netbooks are relatively inexpensive, it wasn’t a big investment, plus with their long battery life they are great for pulling out and taking notes on all day. True, there are a few things I cannot do on my 2 gig netbook that I can do on my 8 gig laptop, but I can at least still run PowerPoint, show the code, etc, even if I can’t run the main demos.

I also keep an external portable hard drive handy. On it I have all the ISOs I might need to load up a computer with the software I need to do a demo. I also have all my demos backed up on it, along with a nifty piece of freeware called Virtual Clone Drive. It installs easily, and lets you mount an ISO as if it were another CD / DVD drive.

As you can see, public speaking is not all fun and games. But it’s intensely gratifying, and I encourage you to give it a try if you ever get the chance.

Give Camp Birmingham

This weekend Give Camp Birmingham will take place. If you’ve not heard of Give Camps before, they are a chance for developers to put their expert skills to use to help out charities. Typically developers will setup or update websites for these charities, train them on social media, or help with other technical tasks.

To find out more, just go to www.givecampbirmingham.org, all of the details are there along with a link to register.

Hope to see you there!

Birmingham User Group Holiday Party is on! Dec 6 2010

I’m pleased to announce the third annual Birmingham User Group Holiday Party. Each year user groups across Birmingham gather for a combined Holiday Party.

As in past years, this event will be at Richards BBQ and Grill on Acton Road. We’ll begin about 5 with a social hour, and order food around 6 pm, to begin eating between 6:30 and 7. Don’t worry though, if you are running late you’re still welcome. We’ll conclude around 8pm. As in past years, we’ll simply order off the menu which has a wide variety of selections, enough to satisfy everyone’s taste buds. With the mix of groups, each person will be responsible for their own bill.

We highly encourage everyone to bring their spouses and kids. You may bring a gift for your own kids to open if you wish. We promise to keep the geek talk to a minimum.

This event is open to all of the Birmingham tech community, there is no requirement to be part of an existing user group to attend.

 

For more details, e-mail me, arcanecode at gmail.com.

SSIS For Developers at DevLink 2010

I have the honor of presenting at DevLink 2010 today. DevLink is a great conference in Nashville, TN, this year attendance topped 800 people. In my session,  SSIS For Developers, we’ll look at how SSIS, commonly used in Data Warehousing, can also be used by most developers to solve issues that frequently come up in the course of their job. Data conversion and exporting data are two good examples, and we’ll also look at how to call your new SSIS job from your .Net application.

There are two code demos used during the presentation, both available at my Code Gallery site. The first is the basic SSIS For Devs demo with the three packages. The second is the more complex example showing how to call SSIS from your .Net application.

What I learned at CodeStock 2010

June 25/26 brought the annual CodeStock event. A big congrats to Michael Neel, the East Tennessee .Net Users Group and the volunteers for their hard work and dedication. As you will note from the previous post I had the honor of being chosen to present two sessions. I appreciate everyone who showed up and participated, lots of great questions and interaction. The new venue at the University of Tennessee in Knoxville really worked out well. The hotels were across the street, and there were plenty of places to eat within short walking distance. The conference center easily held the over 450 attendees, it never felt cramped our crowded.

Thanks also to the many great sponsors for their support. RecruitWise, for their taking the main sponsorship should get a special shout out. I also got to spend some time with the great folks from both TechSmith and DevExpress, it’s great to get to know the people who make the tools you use to get your job done. I had the best seat at dinner one night, sitting right between @BetsyWeber (TechSmith) and @RachelHawley (DevExpress).

I spent quite a bit of time in Open Spaces and “The Lounge” as we began to call it, the area in the lobby with comfy chairs where we gathered in informal discussion. Lots of great topics, including global teams, professionalism, going independent, and much more. I also participated in a open spaces session where Hal Rottenberg did a group discussion and recorded it for his PowerScripting podcast. (Great podcast for learning more about PowerShell, I’ve been listening for quite a while.)

I attended a few sessions when I wasn’t participating in Open Spaces or presenting myself. Jennifer Marsman’s session on VS2010 Tools for Architecture, Modeling and Visualization was quite interesting. I also got a lot of really good ideas from Tim Corbett’s session on the structure of the RDL/RDLC file.

My favorite session though had to be Steve Andrews’ session on T4. If you’ve never heard of T4, it is a code generation language built right into Visual Studio 2008/2010, and available as a download for 2005. It’s easy to use yet also very powerful. There’s also some T4 libraries you can download that will make using T4 easy to use. I can’t wait to begin using this for some of my SQL Server database projects I do with Visual Studio Database Developer (Data Dude). Check out Steve’s blog for more info on T4.

Of course my favorite part had to be “PostStock”, the party hosted by @AlanStevens and his lovely wife. It was quite nice, for the bulk of the evening we sat on his front porch having great conversations. Naturally technology was a frequent topic, but we also touched on other topics such as the importance of family and the epicurean delights from fine food, wine and cigars. Somewhere after midnight we relocated to the Stevens backyard and gathered around the fire pit. (Not too closely, it was pretty hot.) Alan and Steve Andrews broke out their guitars and serenaded us with song after song. The highlight was when they did a rousing rendition of “Code Monkey”.

CodeStock is an awesome event, I’ve been the last few years and will continue to attend. See you at CodeStock 2011!

CodeStock 2010

It’s June, must be time for CodeStock! For those who don’t know, CodeStock is a conference but on annually by the East Tennessee .Net Users Group. This year I am fortunate to have been selected for two presentations.

The first is The Decoder Ring for Data Warehousing / Business Intelligence. This is a concepts talk in which you’ll learn about the terms and overall design of a Data Warehouse, and what they mean when they say Business Intelligence. While we’ll mention the products SQL Server offers, unfortunately we won’t have time for much in the way of a demo.

My second session of the day is a nice follow on to the above session, but will also work even should you not have been in the first session. In SSIS For Developers, we’ll look at how SSIS, commonly used in Data Warehousing, can also be used by most developers to solve issues that frequently come up in the course of their job. Data conversion and exporting data are two good examples, and we’ll also look at how to call your new SSIS job from your .Net application.

There are two code demos used during the presentation, both available at my Code Gallery site. The first is the basic SSIS For Devs demo with the three packages. The second is the more complex example showing how to call SSIS from your .Net application.

Off and Running with PowerPivot for Excel 2010 at the Huntsville .Net Users Group

Tonight, April 19, I will be presenting at the Huntsville .Net Users Group. The subject will be PowerPivot for Excel 2010. Attendees will get to learn all about Microsoft’s new self-service Business Intelligence tool. Both the Excel and SharePoint pieces of PowerPivot will be discussed, plus the audience will get to see demonstrations of the new Excel add-on.

The slides in PDF format are available, PowerPivot.pdf

Spring seems to be a busy time for user groups, code camps, and SQL and SharePoint Saturdays. This Saturday, April 24 I will be speaking at the SQL Saturday in Atlanta Georgia. On May 1 I will be presenting at the Huntsville, Alabama SharePoint Saturday. The SQL Server event is already sold out, with a waiting list. There are still a few seats left for the share point Saturday event so hurry now before it gets sold out too!

SQL Saturday 29 Birmingham

We just finished up our SQL Saturday here in Birmingham Alabama. It was number 29 in the list of SQL Saturdays. First off let me cover some supporting material for the two sessions I gave. The first was an introduction to Microsoft’s new self service BI tool, PowerPivot. Attendees can download my slides here: PowerPivot Slides  You can also see all my posts so far on PowerPivot at https://arcanecode.com/category/powerpivot/ or by picking PowerPivot from the drop down over on the right side of this blog.

My second session of the day was an introduction to SSIS. Step by step instructions, the sample project, and the slide deck can all be found on my Code Gallery site. At the end we got a bit rushed for time, hopefully some of your questions can be answered from some of my past posts on SSIS. If not feel free to send me an e-mail (rcain at comframe.com or arcanecode at gmail.com) and I’ll see what I can do to help.

Attendees of both sessions may also find my Introduction to Data Warehousing/Business Intelligence slide deck helpful to clarify some BI terminology.

In my roles as speaker, volunteer, and event planner I had little time to take pictures, but I did grab a few at the very end of the day, I thought I’d share them here:

IMAGE_152 

Some lucky winners of books looking over the remaining stack to pick out their prize.

John Baldwin, our fearless leader is in the grey shirt all the way on the right.

IMAGE_153

Obligatory crowd shot. Dividers broke this big room down to 4 rooms where we had our sessions.

IMAGE_154

One more crowd shot, showing some of the higher end swag including a Wii, a Garmin GPS, multiple

copies of Office and Windows 7, and two copies of the SQL Server MVP Deep Dives book I coauthored.

My role in event planning was acting as the speaker coordinator. Finding quality people willing to travel to Birmingham, on their own time and expense,  to give presentations. Thanks to Sven Aelterman, Kevin Boles, Louis Davidson, Janis Griffin, Kevin Grohoske, Geoff Hiten, Rodney Landrum, Vincent Mayfield, Aaron Nelson, Barry Ralston, Joe Webb and Jim Wooley. It was their presentations that helped us draw the big crowd we did.

Speaking of the crowd, much thanks to all of you who attended. The folks in my sessions were very attentive, asked many good questions, and kept the discussion lively and interesting. I’m glad all of you came and hope to see you all next year.

I also would be remiss if I didn’t thank all of our sponsors. Without their donations we would not have been able to put on the event. Microsoft, Teksouth, Bit Wizards, Confio, Redgate, Attunity, Telerik, Intellinet, CozyRoc, Wrox, TekSystems and O’Reilly Publishing and to the SQL PASS organization.

I should also give personal note of thanks to my employer COMFRAME, for putting up with my extended lunches and letting me juggle my schedule to run errands and do other planning activities and presentation prep time.

Finally a few last thanks and kudos are definitely in order. The first should go to Vito Amato and his merry band of volunteers. They kept everyone in cold drinks, helped the speakers with their needs, answered attendees questions, checked folks in at the door, and in general did everything that needed to be done to keep the event running smoothly.

A big thanks and congratulations to John Baldwin, our fearless leader, and his right hand man Morgan Smith for taking the leadership to plan and organize the event. They worked long and hard to make the event the success it was.

If you want to keep the fun and education continuing, we’d love to have you join us at our monthly user group meetings, http://www.steelcitysql.org/. Thanks for a great SQL Saturday, and I can’t wait for next year’s!

SharePoint Saturday Birmingham – Intro to Microsoft PowerPivot

spsbham Last Saturday I not only attended but presented at SharePoint Saturday Birmingham. First I have to give Terry Webster a shout out, he did a fantastic job organizing and running the event. I learned a lot, although I admit I felt a bit like a fish out of water, being a SQL Server guy in the SharePoint pond.

Thanks too to all the volunteers who helped run the show, my co-presenters, and the many vendors who attended. Without the support of all those folks this event would not have been possible.

I also want to thank everyone who attended my PowerPivot presentation. Last Friday I did a rather lengthy overview that encapsulated much of my presentation; here are the slides that you saw at the event.

I also want to give you a quick overview of the steps I did in my demo so you can follow along. First you’ll need the bits. The PowerPivotPro has a good blog entry on where to download them from:

http://powerpivotpro.com/2009/11/18/powerpivot-ctp3-beta-download-links/

All you need are the first two items, Office 2010 Beta 2 and PowerPivot for Excel 2010 to reproduce what I did in the demo I presented.

Next you’ll need some data. I had a SQL Server instance installed and used the AdventureWorks2008 LT database available at CodePlex. The LT version is the light weight version of the full AdventureWorks sample, I chose it for it’s simplicity.

http://msftdbprodsamples.codeplex.com/

If you don’t have SQL Server on your box you can use alternate data, or check with your friendly neighborhood DBA. Many have AdventureWorks installed on a test box and might be able to help you out.

OK, so to get this far you’ve downloaded and installed everything, and have access to a dataset. Ready? Let’s go.

1. Launch Excel 201, and click the PowerPivot tab.

2. Click the PowerPivot window button.

step01

3. Click the “From Database” button on the Home tab. In the menu select “From SQL Server”

step02

4. The Table Import Wizard will appear. In “Server name” field, click the drop down and pick your database server. Leave it set to the “Use Windows Authentication” (unless told otherwise if you are using a database provided by a DBA). Under Database name, pick AdventureWorksLT2008. It’s probably a good idea to click the Test Connection button just to make sure everything is correct. If so press Next to continue.

step03

5. On the next screen, leave it at the default of “Select from a list of tables and views to choose the data to import” and click Next.

6. On the next screen pick these tables: SalesOrderDetail, SalesOrderHeader, Product, Product Category, Address, Customer, CustomerAddress. Note the “Preview & Filter” button. In the future you may wish to experiment with this to filter the data you are importing, but it’s not needed for this demo. Click Finish to move on.

step04

7. On the next screen you’ll see it importing the tables. When it gives you the Success message click Close.

8. (Note, this next step differs just slightly from the live presentation, in it I added a column but did it in a different place.) Click on the SalesOrderDetail tab. Click on a blank cell under the Add Column out to the right of the data.

9. In this example we’ll decide that 80 percent of our Line Total is cost, which means the other 20% is profit. We’ll calculate the profit by clicking in the fx bar and typing =[LineTotal]*.20

step05

10. Right click on the “CalculatedColumn1” column header and select “Rename column” from the menu. The column header will highlight and allow you to type over it. Change the name to Profit.

11. Click on PivotTable and pick “Single Pivot Table” in the drop down menu.

step06

12. In a pop up dialog, it will ask if you want a new or existing worksheet. Pick “New worksheet” and click OK.

13. Over on the right you will see the “Gemini Task Pane”. Gemini is the original code name for PowerPivot. To create a basic PowerPivot pivot table, follow these steps.

14. Under SalesOrderDetail, click on then drag the LineTotal and Profit fields to the Values area.

15. Under ProductCategory, drag the Name down to Row Labels.

16. Under Product drag the Name to the Row Labels area.

17. Under the Address, click and drag the CountryRegion, then StateProvince to the ColumnLabels area.

18. Drag the StateProvince to the Slicers Vertical area.

19. Your Gemini Task Pane should look something like:

step07

20. Your spreadsheet should look something like:

step08

At this point you have completed all of the steps as shown in the presentation. Now start playing. You can jump back to the PowerPivot data sheets by clicking the “PowerPivot window” button as shown in step 1. Back there you might try experimenting with a chart, or on the pivot table apply different effects and slicers.

TechMixer University – SSIS for Developers

In addition to help recruit speakers, I also had the privilege of speaking at TechMixer University 2009.

The slide deck and main demo can be found at my Code Gallery site:

https://code.msdn.microsoft.com/Release/ProjectReleases.aspx?ProjectName=SSISForDevs&ReleaseId=2883

The calling of SSIS from .Net demo can be found at:

http://code.msdn.microsoft.com/ssisfromnet

Thanks to everyone who attended TechMixer University. I look forward to seeing you next year!

SQL Saturday 25 Gainesville GA – October 10 2009

SQL Saturday 25 Logo

SQL Saturday 25 occurred in the lovely town of Gainesville GA on October 10th. At the event I did two presentations.

My first presentation of the day was Introduction to SQL Server Integration Services. The sample project, slide deck, and step by step instructions can be found at http://code.msdn.microsoft.com/introssis . In addition I also showed how to call SSIS from a .Net application. You can find that sample at http://code.msdn.microsoft.com/ssisfromnet

The second presentation is SQL Server Full Text Searching. You can find the slide deck in PDF format as well as sample code at http://code.msdn.microsoft.com/SqlServerFTS.

Thanks to Stu and the crew for a great event!

SQL Saturday Redmond – October 3 2009

I am fortunate enough to be able to give three presentations at Redmond WA’s SQL Saturday event. The first session is “Introduciton to Data Warehousing / Business Intelligence”. Here is the PDF slide deck for that presentation. (Right click and save as if you want to save a copy for later reference).

The second presentation is SQL Server Full Text Searching. You can find the slide deck in PDF format as well as sample code at http://code.msdn.microsoft.com/SqlServerFTS.

The final presentation of the day was Introduction to SQL Server Integration Services. The sample project, slide deck, and step by step instructions can be found at http://code.msdn.microsoft.com/introssis . In addition I also showed how to call SSIS from a .Net application. You can find that sample at http://code.msdn.microsoft.com/ssisfromnet .