Monthly Archives: February 2012

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!) …

Read more

SQLSaturday #108 in Redmond is coming up!

I am both excited and nervous (as usual)! SQLSaturdays are special events for me – especially when I’m presenting!

I will be presenting on SSRS Beyond the Basics (aka SSRS 202). Here’s my abstract:

SQL Server Reporting Services – Beyond the Basics

You’re already familiar with your data sources and datasets, and already comfortable with your basic tables and matrices. Now you want to add a bit more “zing” to your reports.

In this presentation we will look different ways of using and extending Reporting Services. In this session we will work with expressions to add dynamic components to SSRS, create drilldowns and drillthroughs, use custom code to modularize our logic, connect to non-SQL Server data sources, and utilize your geospatial data by plotting them onto SSRS maps.

We’ll include a few more cool stuff you might not have known about SSRS! This presentation will be demo-filled. You’ll be sure to go home with ready-to-use tricks up your sleeve.

Read more

Fixing Orphaned Users – the PowerShell/SMO way – NOT!

I’ve been working with quite a few PowerShell/SMO scripts for the last little while, and so far so good. Just recently I needed to map some orphaned users, and I thought – why not? Let’s do it in PowerShell.
This would have been the script that *should* work:

#unfortunately this doesn't work
$user.Login = "marymargaret";
$user.Alter();
$user.Refresh();

Read more

Calling Students for Imagine Cup Canada 2012

Are you a student? Bored of your usual routine assignments? Are you looking for a challenge? Are you looking to start your career *while* you’re still in school? Or do you just want to change the world?

If you said “yes”, or even “kinda” to any of these questions, then you might want to check out – better yet, participate -in Imagine Cup Canada 2012.

Imagine what??

The Imagine Cup is a premier technology competition for students that encourages students to imagine, think, innovate – for the world. We have so many problems globally, and sometimes, all it takes is a little inspiration and a little nudge to make a difference.

Microsoft Canada is hosting Imagine Cup in two categories: Software Design and Windows Phone Game Design. The top three teams in Canada in each category will compete in a Canadian championship event to win cash, career opportunities, and chance to represent Canada at the worldwide finals in Sydney, Australia!

This isn’t your typical assignment though, this promises loads of challenge, loads of fun. You also don’t just get a “typical” mark and a pat in the back – if you win, you take home some goodies (say, Kinect), and a kickstart to your future.

Read more

SQLSaturdays 108 (Redmond) and 114 (Vancouver)

I love SQLSaturdays. What’s not to love? They’re free one day training events, and they’re packed with SQL Server fun (I’m a geek, what can I do?) Whether you’re someone who’s just interested to see what SQL Server is, or you’re already working with SQL Server and need more in depth guidance in some aspects, there’s most likely a session for you.

There’s a couple SQLSaturdays coming up if you are in the Vancouver/Lower Mainland area.
SQLSaturday#108 in Redmond – February 25, 2012 at Microsoft, Building THE MIXER, 15255 NE 40th Street, North Commons, Redmond, WA 98052 (Check out the schedule)

SQLSaturday#114 in Vancouver – March 17, 2012 at BCIT in the South-West buildings, 3700 Willingdon Avenue, Vancouver, BC, Canada (Check out the schedule)

Hope to see you at both events!

Resolving SSRS and PowerShell New-WebServiceProxy Namespace Issue

When you’re working with PowerShell and SSRS, you may occasionally come across a script that works once, then just mysteriously decides not to work anymore on a second or third invocation. Or it may just not work period, even though you think the syntax is short and straightforward, and you know you’re not misspelling any syntax.

Please note I am running this on the PowerShell ISE, and PowerGUI – and tried on both PowerShell V2 and V3.
Read more