SSAS - Creating and Using a Writeback Measure Group

Imagine you have spent the last 9 months developing a sales Data Warehouse and an Analysis Services cube.Your end users...

A Caution About Checkpoints

Checkpoints in SSIS are a great tool and they definitely have their place.  The downside to them is that they...

A small facet of information

G’day,
I’ve blogged about facets before, but I just thought that I’d mention them again, as they came in quite handy...

A SQL Server Hardware Nugget A Day – Day 24

For Day 24 of this series, I want to talk a little bit about the TPC-E OLTP benchmark.

The TPC...

A SQL Server Hardware Nugget A Day – Day 23

For Day 23 of this series, I want to talk a little about some things to consider as you make...

Powershell Day 24

Day 24 Performance Monitor  Sql Performance:  ? performance counters  sys.dm_os_performance_counters ? Top ten queries from sys.dm_exec_query_stats and sys.dm_exec_sql_text ? Processor: sys.dm_os_schedulers ?Memory : sys.dm_os_memory_clerks...

Gartner BI Magic Quadrant 2011

It’s often true that “a picture is worth a thousands words” but sometimes a picture can be such an effectively...

Announcing the fifth certification study session

The Denver SQL Server User Group is starting another round for the certification study group. Last year we ran three...

Announcing the fourth certification study session

The Denver SQL Server User Group is starting another round for the certification study group. Last year we ran three...

Welcome to SQLREPL

Hi everyone.  Welcome to my new blog.  I’m still in the building stages here so things may seem a little...