Monthly Archives: March 2012

What’s New in SQL Server Reporting Services (SSRS) 2012?

SQL Server 2008 R2 was an exciting release for Reporting Services. It gave us features such as:
– Shared Data Sets
– Report Parts
– New Visualization, including spatial visualizations

There’s are also significant changes and new features to SSRS 2012 – but a some of these can only be materialized if you are using SSRS 2012 integrated in SharePoint 2010. Nonetheless these are still pretty exciting changes, and can change the landscape of reporting for our end users (read: more Self Service BI):
Read more

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.

Read more

Insert XML files to SQL Server using PowerShell

One way to bulk upload your XML files into SQL Server is by using PowerShell. In the script below I am using SQL Server 2012 and PowerShell V3 (CTP).

Note that you can use the script in SQL Server 2005/2008/R2 and PowerShell V2, with some slight changes in syntax.

I use Invoke-Sqlcmd to get this done.

Read more

SQL Server 2012 is launching … March 7, 2012 – ready, set, go!

I am a self-professed SQL Server geek. Yes I am. And I am very, very excited about the SQL Server 2012 launch. SQL Server 2012 is a significant leap from its predecessors, and SQL Server is entering a whole new world with this version. Be part of the coolness – Register here for the Virtual Launch event

There are a lot of improvements that I am pretty excited about, but I have to play favorites right now. My absolute favorites are the BI improvements:

Read more