Connect With Us





View John M. Bunch's profile on LinkedIn

Search

Recent blog posts

SQL Azure - what's the big deal?

Details
Category: For IT Decision Makers
Published on Sunday, 30 October 2011 15:31
Written by John M. Bunch
At a recent conference I heard much hoopla, hype, and well-intentioned trumpeting of Microsoft's branded cloud offering called Windows Azure. This brief post will summarize my basic thoughts and reaction to it, with a focus on SQL Azure.  (Side note - I pronounce it ah-zoo-ur, rather than ashz-er.  Whatever.) 

Read more: SQL Azure - what's the big deal?

Loading data from a sequence of flat files, extracting the date from the file name, and adding the date the data flow.

Details
Category: Integration Services
Published on Sunday, 30 October 2011 15:52
Written by John M. Bunch
ForEachFile Here's the situation.  You need to run a daily Integration Services task that loads data from a sequence of text files into a single database table.  The records from each file need to be sorted by date, but the date only appears in the file name.

Read more: Loading data from a sequence of flat files, extracting the date from the file name, and adding...

Creating a Parametered Report Listing Mean Standardized Test Scores

Details
Category: Reporting Services
Published on Sunday, 30 October 2011 15:54
Written by John M. Bunch

This will be a basic table report listing the mean FCATMathScaleScore by race, gender, and LEP (Limited English Proficiency) for a selected school. FCATMathScaleScore is a typical state-wide standardized achievement test - in this case, the Florida Comprehensive Achievement Test.  All data below is randomly generated and anonymized.

Read more: Creating a Parametered Report Listing Mean Standardized Test Scores

Subcategories