Arcanecode - arcanecode.com - Arcane Code
General Information:
Latest News:
Atlanta Code Camp 2013 24 Aug 2013 | 06:39 am
On Saturday August 24, 2013 I’m presenting “What’s New In PowerShell v3… and 4!” at the Atlanta Code Camp. If you would like a copy of the demos, you can e-mail me either arcanecode at gmail.com or rc...
Dealing with the Date Dimension Deployment Dilemma 14 Aug 2013 | 06:54 am
For those of you who have routines that load up a date dimension, you know that it can be a little slow to run. There are times when I am deploying my database project (hey, you are using SSDT SQL Ser...
Updating AdventureWorksDW2008R2 for Today 22 Jul 2013 | 07:09 pm
Back in May I did a post called “Updating AdventureWorksDW2012 for Today”. In that post I included a script that would take the AdventureWorksDW2012 sample database, available on CodePlex, and convert...
Make Your SSAS Data Source View Pretty 17 Jul 2013 | 05:08 am
Anyone who works with SSAS (SQL Server Analysis Services) knows the DSV (Data Source View) is the key to the project. It is through the DSV that everything else is built on. Unfortunately, in most pro...
SSAS Duplicate Attribute Error – Another Cause 15 Jun 2013 | 03:34 am
I had a real head banger this afternoon and I’m not talking about the heavy metal playlist I was jamming to in my iPod. I had a table that, in addition to the surrogate key, business keys, etc had th...
Updating AdventureWorksDW2012 for Today 8 May 2013 | 06:48 am
Like many of my fellow MVPs and Presenters, I use the Adventure Works sample data from Microsoft to do my presentations. Being a BI guy, I specifically use the AdventureWorksDW2012 version, the Data W...
SSIS tip for Lookup Transformations 4 Apr 2013 | 11:54 am
The Lookup Transformation is a cornerstone of almost any SSIS package. The vast majority of packages that load Fact tables use Lookups extensively. Many of these lookups reference the same tables over...
The Phoenix Project 2 Apr 2013 | 09:30 pm
Just wanted to take a second during my lunch break to let you know about a book called “The Phoenix Project”. Back in ancient times, the 1980’s, a man named named Eli Goldratt wrote a book entitled “...
Run As Robert 2 Apr 2013 | 04:41 am
Recently I was a guest on Richard Campbell’s podcast “RunAs Radio”. It was a lot of fun, we talked about Business Intelligence as it’s evolved and what its future might be with technologies such as Ha...
SSDT – Error SQL70001 This statement is not recognized in this context 28 Mar 2013 | 03:44 pm
One of the most common errors I get asked about when using SQL Server Data Tools (SSDT) Database Projects is the error “This statement is not recognized in this context”. This is actually a pretty sim...
