I would like to say a huge and warm thank you to all who attended my sessions for SQLSaturday#43 in Redmond. It was such a great event, and I hope you enjoyed the sessions – and enjoyed the whole day with all the wonderful speakers.

As promised here are the files for my sessions:
Read the rest of this entry »

I did a presentation today for VANPASS on PowerShell and SQL Server – thank you to those who attended! It was a great lively crowd Thanks to Idera too – for the freebies – and to Black Ninja Software for the pizza and pop!

Here are the files as promised: VANPASS – SQL Server and PowerShell – Donabel Santos

The zipped file contains the presentation and all of the samples (ones that I demo’d, and ones I didn’t have time to demo). The demos are:

• Demo 01 – Common PowerShell Tasks – Complete.PS1
• Demo 02 – PowerShell Basics – Complete.PS1
• Demo 03a – SQL Server 2008 Mini Shell – Complete.PS1
• Demo 03b – Server and Database Properties.PS1
• Demo 03c – SQL Server Services and Jobs.PS1
• Demo 03d – Scripting SQL Server Objects.PS1
• Demo 03e – Searching for Objects.PS1
• Demo 03f – Basic DDL and DML Import.PS1
• Demo 03f – Basic DML.PS1
• Demo 03g – Backup and Restore.PS1
• Demo 04 – SQL Server PSX – Complete.PS1
• Demo 05 – SQL Server PSSnapin – Complete.PS1
• Demo – SSIS.PS1
• Demo – SSRS.PS1
• Out-Report from Chad Miller

I have used a lot of resources when I was creating all these samples, and I have tried to enumerate them in my presentation. And I also just realized I had a lot of samples and was only able to get through 2/3 of them.

I enjoy presenting at VANPASS, it is always a great crowd. Please feel free to drop me a line, or comment on my blog, or message me on twitter(sqlbelle) – if you have other SQL Server PowerShell questions, or if you had questions at the presentation that I wasn’t able to address.

Thanks to Richard Baumet and Scott Stauffer for inviting me to speak.
And thanks to Idera too – I love using your PowerShell Plus!

… written by one of our cool DevTeach speakers Peter de Betta?

Yup, it’s a free MS Press Ebook on SQL Server 2008. What else can we SQL Server junkies ask for? (Ok, fine I said that too soon, there’s probably still a fair bit of stuff we want out of SQL Server).

Anyway, this is the link to Peter’s blog about the book :
http://sqlblog.com/blogs/peter_debetta/archive/2008/09/16/introducing-sql-server-2008-the-book.aspx

This is the excerpt:

To get your free copy, browse to http://www.microsoft.com/learning/sql/2008/default.mspx. From there, look in the Special Offers section for the “Free e-book offer“. Although the site states you can get excerpts, the whole book is available for reading.

Coolio?

DevTeach day
- done my presentation on PowerShell! thanks for my awesome crowd – they stayed with me from PowerShell ground zero to about 20 feet up. You’ve seen the tool now, go make me proud
- also attended Shereen’s session. She’s the master of customizing your SharePoint pages!

DevTeach night
- DevTeach speakers dinner at Sala Thai. Fun and lively chat with Scott Stauffer, Peter de Betta, and Ted Neward. Also brief chat with Kevin Kline and his wife while we were at the lounge waiting to go to dinner. Very nice people!

DevTeach tomorrow
- we have the Black Ninja Booth. Come visit us! We always welcome good chats, hi’s and hellos! We also have a few things to give away (shirts, goodies, and Telerik Web Control license!)
- looking forward to tomorrow’s sessions!

Twitter/Tweetie
- wow this could be very addicting eh? I find myself using my iphone/tweetie more.

Brag Bag
- got nominated for BCIT’s Teaching Excellence Award!! Did I put enough smileys here? Thank you to whoever nominated me, it is a pleasure and privilege and very much appreciated.

That’s it, I’m ready to crash for the night!

Updates : day after
- also fun chats with Don Kiely, Etienne Tremblay, Medhat Elmasry, Brian Pidcock at our Black Ninja booth, and quick chat with Richard Baumet while we were both prepping for our presentations
- when able to sneak out of the booth, attended Sherman Woo’s session on SharePoint Dev tips and tricks, Peter de Betta’s Choosing the Right Encryption Technologies , Kevin Kline’s End to End SQL Server Troubleshooting, Brad McGehee’s SQLDiag presentation; I wish I could have see more presentations!

SQLTeach/DevTeach Vancouver 2009 - Stimulus Package

SQLTeach/DevTeach is offering a “stimulus package” – register for 2 attendees to the SQLTeach/DevTeach Vancouver conference on June 8-12, 2009

Excerpt from DevTeach site:

In difficult times the best thing you can do is to upgrade your skills. This is why DevTeach came up with the idea of an Education stimulus package. You can get a free registration when your company or group registers two attendees at our main event. So register 2 attendees and get one free! This promotion is applicable on the early bird price and will run until June 8th. You can take advantage of this deal even if you are using a rebate code. If you compare our price with any similar event in the USA you will find that our price is significantly lower. For you guys coming from the US it’s even a better deal because of the exchange rate

Sorry I have been sick and out of commission for a week. The past few days, I’ve been drinking the meds the doctor gave me, which just really knocks me right out.

I apologize for the delay, but here are the materials, finally.

SharePoint 101

SharePoint 101 – Slides

SharePoint Web Parts

SharePoint Web Parts 101 – Slides

SharePoint Web Part Sample Projects:

1. Hello World Web Part

2. Simple Web Part with Custom Properties and Verbs

3. Connectable Web Parts

Enjoy! I’ll start blogging more again, as soon as I’m 100% better

The Victoria Code Camp last weekend had been awesome! The location was great, and the attendees were awesome. They were all attentive and curious, and they even laughed at some of my jokes

I have been really sick the past couple of days, but I will be posting the materials/slides and demo code soon. I plan to have it up by tomorrow!

And please feel free to keep the questions coming in It makes my work a lot more interesting!

I’m doing a couple of sessions at the Victoria Code Camp on January 26, 2008! Thank you to Nolan Zak for giving me this opportunity.

These are my two sessions:

SharePoint 101
This session will provide a high level overview of Windows Sharepoint Services 3.0 and Microsoft Office Sharepoint Server (MOSS 2007). This session will also cover demos of out-of-the-box Sharepoint components like: sites, lists, document libraries, and web parts.

SharePoint Web Parts
This session will cover Web Part concepts, and will walk you through creating custom ASP.NET Web Parts for SharePoint (MOSS 2007, WSS 3.0). Features will also be introduced towards the end of the session.

Schedule is posted at http://www.victoriacodecamp.com/SessionSchedule.aspx.
The list of speakers can be found at http://www.victoriacodecamp.com/CampSpeakers.aspx

Just posting the schedule here as well for your reference:

Morning Schedule

Afternoon Schedule

As usual, I will be posting the materials I will use at the presentations. Hope to see you there! Beautiful Victoria, here I come!