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

RYO Maintenance Plan – Database Backups

Remember kids...
Anyone who knows me knows that I’m a big proponent of automating routine tasks. If I have to do...

SQL Server – Error Logs recycle without SQL Server Restart

If some long running error situation , the Error Log can become very big. In those situations , it can be time-consuming...

SQLCruise: The Trident

Move over Poseidon.  I’m hitting the sea with my own trident (assuming I can get it through the TSA).  My...

X on XMLA: i. Using XMLA

In my previous blog, I introduced the “X on XMLA” series.  In this blog, I will do more of an...