This is Big Data

I’m sure some people have bigger data, but Facebook has some serious daily growth. The highlight? 500TB a day.
A day.
That’s...

“It’s Alive” - SSIS Design Patterns

I’m happy to announce that the book I’ve been working on for the past two years is complete and has...

“It’s Alive” – SSIS Design Patterns

I’m happy to announce that the book I’ve been working on for the past two years is complete and has...

Error: ACCESS DENIED on installation

Error: ACCESS DENIED on installation Generally you would get error on: >> During installation >> when try to start the sql services....

Installing SQLServer for SCCM 2012 – Some points to note on patch levels

The prerequisite SQLServer 2008 R2 patch level for System Center Config Manager 2012(SCCM) is SP1 with Cumulative Update 6 (CU)

 
 
 
 
For...

PowerShell Split-Path Bug And A Workaround

Split-Path is a cmdlet built into Windows PowerShell that returns a specific part of a path, e.g.  a parent directory...

Cisco VPN Client 5 on Windows 8

NOTE: Always create a backup before doing any type of Windows registry modifications!!!!
With the full public release of Windows 8...

Colorado SQL - SQL Saturday Events September 2012

Publisher  ...

Error: No mapping between account names and security IDs was done

I recently decided to move over to Windows 8 so I can take advantage of Hyper-V and get off a...

Normalization & Denormalization

Normalization & Denormalization Someone asked me about this basic thing which we generally do not think much, so realize that should...