Junk dimensions

Junk dimensions are dimensions that contain miscellaneous data such as flags and indicators.  When designing a data warehouse, you might...

Pitching Pebbles – Using Certificates to Grant Privileges

If you fill the jar with pebbles first, you'll never have room for the big rocks.
I’m sure you’ve heard the...

SELECT GetDate() – 30 AS [This actually works??];

I just ran across this in a piece of code (that I didn’t write):
… WHERE Thing >GETDATE()- 30
Aaaand it works....

PASS Summit 2012 Evaluation Results

I say it all the time because it’s worth repeating, feedback is a gift. Good, bad or indifferent (well, not...

CONCAT() string function–SQL Server 2012

As the name indicates, CONCAT() will concatenate two or more strings. This is one of the two string functions introduced in...

SharePoint Reports and Scorecards on Apple Devices

While some people may consider this topic off limits the fact remains that more and more companies are adopting Apple...

Contracting is business not employment: Read the small print

This post is about a contracting in UK. Some of terms mentioned here will not mean a great deal to...

Read About SQLSatuday #100 & See the Coffee Cup Too!

Here’s a great post from Karla Landrum about her trip (with husband Rodney) to Brazil for the milestone making #100....

Using Dynamic Values in XMLA

Using Dynamic Values in XMLA
XMLA

A question was raised on Twitter today via the #sqlhelp hash tag about passing parameter values...

Undocumented Gotcha in Merge Replication Tracking

In the spirit of Robert Davis's (blog | @SQLSoldier) blog post: Undocumented Gotchas of Transactional Replication, I decided to contribute an...