SQLSaturday #114 in Vancouver – PowerShell and ETL with SSIS

SQLSaturday #114 in Vancouver is coming up. It will be held at the BCIT Burnaby Campus – SW buildings. Have you registered yet?

If you haven’t, you can still register! I love SQLSaturdays. I personally enjoy attending them a lot, and wished there were more SQLSaturdays in the Vancouver vicinity so I can attend more. Although if I had the time and money, I’d fly to other SQLSaturdays too (did you know there’s a SQLSaturday in Honolulu, Dublin and Portugal?).

If you’re in the database/SQL Server field, you should have plenty of reasons to attend. There’s lots of awesome stuff to learn, especially since SQL Server 2012 has just launched last March 7, 2012! Plus, this is a free training event. Yup, you read it right, it’s a free awesome event. One day of SQL Server training can cost you a few hundred dollars, but SQLSaturdays are packed with different sessions, and you don’t even have to worry about the dollar cost.

Continue reading

SQLSaturday#108 Redmond – SSRS Beyond the Basics – Thank you to Attendees!

One more SQLSaturday done 🙂 I love SQLSaturdays, it’s always a fun experience for me. Uhm, ok, maybe let me qualify that. It’s always a nervewracking AND fun experience for me – when I’m speaking. I just always want it to be worth people’s time to attend my presentations.

I think there was a good crowd at my session, and I’m quite happy to see they seemed to have fun too (I hope!) …

Continue reading

SQLSaturday#65 SSRS 2008/2008 R2 from the Ground Up

Thank you to all the troopers who attended my really-early-morning-cold-and-snowy session at SQLSaturday#65 in Vancouver, BC. It was such a great event; thanks to all volunteers, sponsors, speakers and organizers (kudos to Scott Stauffer (blog | twitter) .. Thanks to Todd McDermid (blog | twitter) too for helping me give out swags during my session, and thanks for the great powerpoint slide decks which I’ve used in 2 SQLSaturdays now! 🙂

sqlsat65-schedule

As promised, here are the SQLSaturday#65 presentation materials for SQL Server 2008/2008 R2 Reporting Services from the Ground Up

Brent Ozar (blog | twitter) has a few pictures of the event 🙂

Sample Reports (pdfs)

Report with different visualization components (data bar, sparkline, indicator, gauge, chart)
sqlsat65 - sample report - employee sales with visualization

Report with drilldown, barcode, gauge
sqlsat65 - sample report - employee sales with drilldown barcode and gauge

Report using map (from ESRI shapefile for Canada) and Bing Maps layer
sqlsat65 - sample report - canada sales on map
Continue reading

SQLSaturday #43 (Redmond) – SQL Server Reporting and SQLServer/PowerShell

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.

sqlsat43 redmond sessions

As promised here are the files for my sessions:
Continue reading

VANPASS Presentation and Demo Files on SQL Server and PowerShell

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

Continue reading

Have You Downloaded the Free MS Press SQL Server 2008 Ebook Yet?

… 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, dinner, twitter, brag bag – my musings for the day

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 Stimulus Package

SQLTeach/DevTeach Vancouver 2009 - Stimulus Package
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

Victoria Code Camp Materials

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 🙂

Victoria Code Camp Stuff Coming Really Soon!

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!