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...

Last Weeks Top “Reading” Links #29

For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...

Native SSMS a second class citizen no longer…

Intellisense can be a boon to adding quick development. Quick hints on scope specific variables, syntax suggestions, function descriptions and...

PowerShell – Get an UNC of a remote folder

To Read/Write/Rename/Copy/Delete a file configured across ‘N’ of servers in the same path, this script is going to be very...

Resolving data redundancy up front

 
Introduction
As all of us do when confronted with a problem, the resource of choice is to ‘Google it’.
This is where...