So 2012 has been a really hectic year for me so far. But… my book is out!
About This Book
- Provides over a hundred practical recipes that utilize PowerShell to automate, integrate and simplify SQL Server tasks
- Offers easy to follow, step-by-step guide to getting the most out of SQL Server and PowerShell
- Covers numerous guidelines, tips, and explanations on how and when to use PowerShell cmdlets, WMI, SMO, .NET classes or other components
- Builds a strong foundation that gets you comfortable using PowerShell with SQL Server–empowering you to create more complex scripts that you need in your day-to-day job
Who This Book Is For
This book is written for the SQL Server database professional (DBA, developer, BI developer) who wants to use PowerShell to automate, integrate, and simplify database tasks. A little bit of scripting background is helpful, but not necessary.
I’m trying to get some data I can play around with Tableau, fortunately information for Canadian climate data is available in CSV and XML from http://www.climate.weatheroffice.gc.ca/. I thought I’d go fetch the Vancouver daily weather data since 1953 using PowerShell.
Here’s a few PowerShell snippets for anyone interested. I haven’t cleaned these up yet, but should be pretty functional.
There are new rendering extensions supported in SSRS 2012. Welcome extensions are the OPENXML rendering formats, to be used with Word 2007/2010 (.docx) and Excel 2007/2010 (.xlsx).
To list the rendering extensions, you can use the ReportViewer from the Reporting Services Redistributable Package.
You can download from here
[System.Reflection.Assembly]::Load("Microsoft.ReportViewer.WinForms, Version=22.214.171.124, Culture=neutral, PublicKeyToken=89845dcd8080cc91") | Out-Null
$ReportServer = "http://KERRIGAN:80/ReportServer"
$rv = New-Object Microsoft.Reporting.WinForms.ReportViewer
$rv.ProcessingMode = "Remote"
$rv.ServerReport.ReportServerUrl = $ReportServer
This should list all the currently supported extensions.
This has truly been a busy and exciting year for me. I’ve been blessed to have not one, but two books, in the works.
The PowerShell Deep Dives project is a community-written book on 300 level PowerShell topics. With topics ranging from administration, scripting, to PowerShell Platforms, there is definitely something for everyone. This book will be published by Manning, and all royalties will go to charity. Simply said, all the authors in this book will be contributing their time for charity.
I am very happy and humbled to say my abstract for a chapter for the PowerShell Deep Dives book has been accepted. To say that I will be part of this project is both an honor and a pleasure.
In no particular order, here are the authors of the PowerShell Deep Dives book.If I missed anyone, or if there are incorrect blogs/twitter handles, please let me know.
I just wanted to say thanks to everyone who attended Idera’s PowerShell Power Hour. I’ve had a great time doing the presentation, and I hope you enjoyed it. Thank you for all the positive and constructive feedback! 🙂
The webcast is archived by Idera here:
The scripts and slides can be downloaded from my site:
In order to work with report items with SQL Server Reporting Services 2008, most of the time you need to get a handle to the report items.
Here is a sample code snippet that uses the ReportingService2010 web service and PowerShell V3 CTP.
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.