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

Our weekly webshow starts Friday! #DBAsAtMidnight

Let’s pretend we’ve never met. Depending on who you are, maybe we haven’t. It’s beside the point, really.
So hi, I’m...

PASS SQL Saturday - September 2012

PASS SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server.  Please note that in...