The Good, the Bad and the Ugly SQL Cursor types

T-SQL cursors are generally bad approach and are often misused. In today’s world of correlated subqueries, CTE’s, recursive CTE’s, ranking...

Big Numbers

What had me reflecting on numbers was an article in the Financial Times (Conduit of Contention if you can find...

Build a schedule for SQL Saturday

A new feature has been added to SQL Saturday.  Now when you register for an event you can build your...

Calling SCOM in C#

Written by David Postlethwaite
I’m sure there are many out there using System Centre Operations Manager (or SCOM for short)...

Dual monitors, dual laptops, and the best way to manage them

Here is a tip that could make you much more productive:  At home, I have a desktop computer with dual-monitors...

Marking FK Constraints NOT FOR REPLICATION

When administering Merge Replication, sometimes we need to mark foreign
key constraints NOT FOR REPLICATION.  In some cases, we might...

Modified Insert Unknown Row to Dimension Table

A little over a year ago Patrick LeBlanc wrote a blog post about inserting an unknown row into a dimension. ...

Re-blog – July 22-July 28

As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week.  Some posts...

Roundup for Un-SQL Friday #005: Bad Interviews

It’s time for the Un-SQL Friday #005 roundup!

From managers…
First up, The Lone DBA admits that he wasn’t always (ahem) one of us…he’s got...

SQL Azure – simple description, part I.

I was studying SQL Azure parameters some time ago and found out that there are no materials which tell you...