SQLPeople Interview

Have you heard about this new project out there called SQLPeople?  It is a new (relatively) project that is the brainchild of Andy Leonard.  Andy is trying to help...

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

Stop Asking and Start Making Decisions Today

Ever have one of those days where no matter how hard you try you just can’t seem to make any...

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

Why Build a Brand?

Why should you go to the trouble to start blogging, speaking, answering questions or anything else. What’s the point?
I’ve written...

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 23

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

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

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

A SQL Server Hardware Nugget A Day – Day 22

For Day 22 of this series, I want to talk a little about 32-bit vs. 64-bit hardware, and the related...