Sqlmusings - sqlmusings.com - belle's sql musings
General Information:
Latest News:
Demystifying T-SQL Subqueries–Part II 19 Nov 2012 | 11:53 am
In the last post (Demystifying T-SQL Subqueries – Part I) we looked at how to use scalar subqueries. Let’s continue our subquery adventure. As with Part I, the following T-SQL query samples are using ...
Demystifying T-SQL Subqueries–Part I 13 Nov 2012 | 10:39 am
When I teach SQL Server Development/T-SQL courses, subqueries is usually one of those topics that students find confusing. Usually it’s a head scratcher, although there are some who just get it. So le...
Downloading Vancouver Weather Data Using PowerShell 15 Sep 2012 | 01:19 pm
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...
The blue pill or the green pill – following the rabbit-hole to Tableau Wonderland 15 Sep 2012 | 02:49 am
The company I work for is evaluating tools for BI/Visualization, and Tableau is one of the front runners that we are considering. I’ve been fortunate to be able to attend this week’s Advanced Tableau ...
Get SQL Server 2012 SSRS Report Rendering Extensions Using PowerShell 25 Aug 2012 | 08:58 pm
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 renderi...
PowerShell Deep Dives / SQL Server PowerShell Cookbook 21 Aug 2012 | 03:08 pm
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 PowerShe...
Microsoft Private Cloud Sweepstakes – ends September 6 2012 10 Aug 2012 | 09:20 am
Learn About The Microsoft Private Cloud to Win a Trip for Two to Mexico! Microsoft has released new and exciting products that will change the way IT Pros utilize Virtualization and Microsoft Private ...
Thanks to everyone who attended PowerShell PowerHour! 26 Jul 2012 | 02:46 pm
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 construc...
What’s Inside an SSIS 2012 .ispac File? 17 May 2012 | 08:10 am
If you’re curious, you can rename the .ispac file and give it a .zip extension, and extract. Voila, we see all the files that make up the ispac – a manifest, your DTSX files, and a .param file. Also n...
Get a Report Handle Using SSRS2008 and PowerShell V3 14 May 2012 | 06:10 am
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 ReportingService2...
