Key Sets, or Inverted Keys - defining a key as a set of tuples

TL;DR:
I have been doing a lot of thinking about data models for the last couple of weeks. I have, just...

Login failed for 'NTAUTHORITY\ANONYMOUS LOGON' - the fix you probably haven't tried yet

Just a quick one today. TL;DR: Remove yourself from some unnecessary AD groups.
If you've ever received the message "login failed...

Login failed for 'NT AUTHORITY\ANONYMOUS LOGON' - the fix you probably haven't tried yet

If you're seeing this for the second time, my apologies. I wanted to update the title but had to delete...

Improving instead-of-insert cardinality estimates for inserted and deleted pseudotables in SQL 2014+

Tricky triggers
In my last entry I noted that the performance of "instead-of" triggers can be tricky.
One of the reasons for...

SOA and message based integration - the challenge of bulk data changes

I'm working on problems of enterprise data integration in the role of enterprise architect, but I am and have been...

An attempt at creating a "universal", set-oriented, near-real-time ODS ETL interface

Defining the Problem
Imagine I have two different systems - say, a CRM and an ERP - on different SQL Servers. Both systems...

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

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

SSMSDeploy 1.5 Available: new configuration form and highly tweaked request list

SSMSDeploy version 1.5 is ready. This one has a LOT of GUI tweaks. No database changes in this one, so...

SSMSDeploy 1.1 Now Available

Fixed a couple of issues and made some GUI tweaks. Please see the download page for the latest version, and...