Blogging: Building a Blog

I took an interest in building  a blog/website several years ago when I first started my company and working for...

Deadlock Monitoring

There are four different ways you can get information about deadlocks in your system. These are:
traceflag 1204traceflag 1222trace eventsextended eventsFor...

Link: How USB Charging Works

Good discussion of how USB charging works.

Microsoft Data Appliances Help Simplify MSBI Projects

As some of you know, I am really excited about the data appliances Microsoft and HP have released this year. ...

Re-blog – January 20 – January 26

Welcome to the Friday Re-Blog summary post.  The aim of these posts is to bring some old posts that newer readers may...

SQL Server - Generate SQL INSERT from Excel

Generate SQL Server INSERT statements with Excel Concatenate.
A developer requested  access to a Production database. The details were to COPY...

SSAS fact table dilemma

Here is a situation I ran into recently concerning using a fact table in SSAS.  This experience may help you out if...

The Kind of DBA I Want to Be

The Kind of DBA I Want to Be
Rokusaburo Michiba (Iron Chef Japanese)

I was a big fan of the original Iron...

Database 101

I had an interesting phone call this morning from our professional services team.  They are carrying out what I can...

Introduction to XML DML (Part 2) - Using the modify() method: replace value of

This is the second part of a 3 part blog which will attempt to show some different ways of how...