SQL Community Support

I have blogged before about my appreciation for the SQL community mainly within the PASS organization as that is what...

Welcome To Machine

Hello World.  Stardate 1513.1.  After reading that, if you know what I am referring to, you are a tech-head and...

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