Exploring Excel 2013 for BI Tip #6: GeoFlow–The Latest Excel Visualization

As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...

Fargo SQL Saturday (#SQLSat175) Schedule Is This Weekend

We are down to the last few days before first SQL Saturday in Fargo.  It’s been some work pulling it...

Industry Expert Interview

I don’t know if I would consider myself an industry expert, but hey, it says it on the Internet, so...

PowerSQL – Database Backup Report across all Servers – Centralized Approach

This topic provides and describes the quickest way to find when and what databases are being backed up recently.Backups are...

Review of The Way

The Way, starring Martin Sheen and directed by Emilio Estevez has been on my want to watch list for a...

Service Application Architecture

Hello Friends,

As discussed in my previous blog the new architecture of Service Application in 2010. Today I am here with...

snippet designate a certain time of the day in getdate()

Snippet to designate a certain time of the day to evaluate in the current day. If you need to limit a...

Speaking at the 2013 Carolina Code Camp

On Saturday, May 4, the Enterprise Developers Guild in Charlotte will hold their annual Carolina Code Camp. There's a number...

Creating Dimension Table ==> Time (Example)

Script for Dimension table for Time.
Here Date_ID is the primary key which can be used as the foreign key...

Cumulative Update – 7 for SQL Server 2012 RTM Is Now Available !

The 7th cumulative update release for SQL Server 2012 RTM is now available. Cumulative Update 7 contains all the hotfixes...