Things That Should Be In TSQL

Relation Types

create type type_T(i int primary key clustered, j int check (j > 0)) -- relation type. Includes constraints!
create table T(type_T)

Relvar Assignment

This...

vCentre Useful Queries: Part II

After posting on twitter last week that I needed something to write a blog post about my good friend Christian...

ColoradoSQL in June

All ColoradoSQL user group meetings start at 5:30 and provide food and refreshments. There is no cost to attend so...

Getting Backup File Information from a Table Valued UDF - SQLCLR to the Rescue?

Update:

After all of this SMO stuff failed (changing the permission set to unsafe got around the security exception, but instead...

SQL Books Arrived Today

A small post regarding a couple SQL books I bought from Amazon.
A couple new books arrived in the mail from...

SSAS Maestro–Redmond Day 2–Redux

Wow, what a day 2! This was our first day of lecture and it was a doozy. Stacia and I...

SSIS Configurations: When and How

Configurations in SSIS are a lovely tool that when implemented correctly can greatly reduce package maintenance.  It is very possible...

T-SQL Tuesday #19 – Disasters & Recovery

There are three types of disasters that are seldom expected. Read about the fun of dealing with these different types of disasters.
Related Posts:

The Mystery of Missing Backup Files December...

T-SQL Tuesday #19 – Disasters & Recovery

When I first read this article, I thought to myself “I have no clue on this one.  What could I...

T-SQL Tuesday #19 – Disaster Recovery

This month Allen Kinsel hosts T-SQL Tuesday #19 with a disaster recovery theme. This is the blog party idea started...