Powershell Day 25

Day 25 RMO   I have observed that no body has written anything about RMO. And replications is one of my...

SQL Azure Deployments

You’ve set up your access to a SQL Azure site so you’re ready to go. Now how do you get...

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