belle's sql musings

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 [...]

No related posts.

Getting More Information About Your PowerShell Error

I just have to blog this little gem. Every now and then I would be running a PowerShell script, I’d get an error but I wouldn’t get anything useful from the default error message besides the line number. Little Gem cls $error[0] | fl -force Sample For example, this is an error I would get [...]

No related posts.

Reflecting on life, death, and what matters

I was strolling into the office liesurely one morning this week, when one of my co-workers saw me in the hallway and motioned me to hurry because I was apparently late for a meeting. I didn’t realize an invite for an early morning meeting was sent out the night before, around 10:33PM, which I was [...]

No related posts.

Resolving PowerShell V3 ISE error with Invoke-Sqlcmd

The PowerShell ISE is much improved in V3, needless to say I am really enjoying writing scripts with this tool! It is however, not without hiccups. I was trying to run the Invoke-Sqlcmd cmdlet when I got the following error in the PowerShell ISE Mixed mode assembly is built against version ‘v2.0.50727′ of the runtime [...]

No related posts.

Significant Changes to SQL Server 2012 Editions, Licensing

As a gist, the new SQL Server 2012 will have a new set of editions: - Standard – will be the new basic version - Enterprise - Business Intelligence - Developer (no more DataCenter, Workgroup and Standard for Small Business) For licensing, Microsoft is doing away with per processor licensing – but replacing this with [...]

No related posts.

Installing SQL Server Denali CTP3 Weird Issue – Invalid Handle

I was busily preparing my new VMs all night (shiny new VMs!!). Planning to get 2 Windows 2008 R2 Enterprise boxes out as my new playgrounds, one as a Domain Controller, another one as my new Denali CTP3 box. When I was starting to install Denali, not long after launching the install, I got this [...]

No related posts.

PowerShell and SSRS: Passing Values to Query-Based Parameters Programmatically

I wanted (needed!) to write a script to automatically generate a number of reports based on sets of parameters. Most of the scripting I’ve done before are for straight up parameters that I can pass using SMO or through the URL string. This time, I had a cascading query-based parameter, ie one parameter that is [...]

No related posts.

Download SSRS Parameterized Reports in PDF with PowerShell

Here’s a short PowerShell script that : 1. Connects to your report server 2. Loops through a set of parameters stored in an array 3. Saves the PDF version of the report to a local folder, with appropriate names Here’s a snippet of code to set your SSRS parameters programmatically using PowerShell $params = $null; [...]

No related posts.