SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Don Halloran

SQL Server, SSIS, SSAS and maybe even SSRS rants and raves (and, on occasion, useful code or designs).

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


I have been doing a lot of thinking about data models for the last couple of weeks. I have, just now, had some thoughts which evolved from what I was thinking about regarding phone numbers and contacts in a forum post here https://www.sqlservercentral.com/Forums/1911234/A-simple-example-which-after-15-years-of-relational-design-work-still-breaks-my-brain-phone-numbers

TL;DR: Currently when testing for key…

Read more

0 comments, 205 reads

Posted in Don Halloran on 19 December 2017

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 the previous entry to do so, but the SSC CMS doesn't seem to have processed the delete yet.

Just a quick one today. TL;DR: Remove yourself from some unnecessary AD… Read more

0 comments, 498 reads

Posted in Don Halloran on 13 November 2017

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 for 'nt authority\anonymous logon' while working with SQL you know how frustrating it can be. I'm going to throw a troubleshooting tip that doesn't get much attention into the… Read more

0 comments, 2,943 reads

Posted in Don Halloran on 12 November 2017

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 this is due to the way the engine estimates the number of rows in the inserted and deleted pseudotables. This post will be a quick demonstration of that. Read more

0 comments, 296 reads

Posted in Don Halloran on 7 November 2017

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 store some attributes about widgets, but neither can provide the complete picture by itself.

Lots of consumers want to interact with widgets holistically - that is to… Read more

0 comments, 316 reads

Posted in Don Halloran on 5 November 2017

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 a SQL person for 15 years, so it may be that I look at this topic with considerations that don't get much attention more widely.

So, enterprise data integration! Or…

Read more

6 comments, 6,162 reads

Posted in Don Halloran on 19 November 2014

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 follows from relation types:
create table T(type_T)
create table U(type_T) = T 
declare @V table(type_T) = U 
Strong typing could be enforced, which might…

Read more

1 comments, 860 reads

Posted in Don Halloran on 15 June 2011

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


After all of this SMO stuff failed (changing the permission set to unsafe got around the security exception, but instead I got an error about functionality being disabled in the SQLCLR) I gave up and turned back to the idea of opening a connection and using the engine to…

Read more

0 comments, 1,345 reads

Posted in Don Halloran on 15 June 2011

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 to upgrade just uninstall your previous version and run the 1.5 installer. You will have to redo your configurations - but now there's a configuration form for that! If your… Read more

2 comments, 868 reads

Posted in Don Halloran on 22 January 2011

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 the revision history page for upgrade instructions and the list of changes.

Read more

8 comments, 642 reads

Posted in Don Halloran on 20 January 2011

SSMSDeploy Now Available!

I have finished my website, done all my recompilations, checked all my settings, and finally SSMSDeploy is on the internet, ready to be downloaded.

You can find the setup files as well as the source code for the addin and the wrapper at my new website: allmhuran.com

There are a… Read more

1 comments, 526 reads

Posted in Don Halloran on 19 January 2011

SSMSDeploy will be available, with source, for donation

After much um-ing and ah-ing I have decided to release my addin, with source code, under the GNU GPL.

I've also registered a domain and hosting service to keep this and any other projects or articles I might like to make available, but I also intend to keep publishing here…

Read more

4 comments, 510 reads

Posted in Don Halloran on 15 January 2011

SSMSDeploy Demo #2 - new features

I've made some changes to the addin, adding some new features:

  • Comments: You can now add a comment to your request. The comments show up on most of the addin windows, and you can also see the comment as a tooltip in the deployment list. Requests with comments have their…

Read more

0 comments, 533 reads

Posted in Don Halloran on 15 January 2011

Updated SSMSDeploy Demo Video

This is just a quick note before I head off for work that I have made a new demo video for the addin. I don't think I inadvertently called it "SQL Deploy" anywhere in the commentary (at least on the third or fourth try).

More importantly, this one was recorded…

Read more

0 comments, 541 reads

Posted in Don Halloran on 10 January 2011

SSMS Addin Wrapper - Source Code and Usage

Code First, KTHX!

Here, as promised, is the source code for the SSMS wrapper.


My apologies for the brief delay on this. When I started working on this project I had only intended to write the wrapper and release just that. Once I had the idea for my SSMSDeploy…

Read more

1 comments, 2,054 reads

Posted in Don Halloran on 10 January 2011

SSMSDeploy - Demo Video Available!


1) I have discovered that there was already a tool called SQL Deploy, so I have renamed my addin to SSMSDeploy, and am in the process of updating any existing references and making a new demo video. Apologies to the author(s) of the original SQL Deploy.
2) New video…

Read more

0 comments, 508 reads

Posted in Don Halloran on 9 January 2011

SSMS addin (and wrapper)

So I mentioned I'd been working on an SSMS addin. What I didn't mention was that I've also been working on a wrapper to make addin creation easier. I actually first looked at this nearly 12 months ago, but so much reading and trial and error was required that I…

Read more

1 comments, 1,283 reads

Posted in Don Halloran on 4 January 2011

Easy CDC part 2: Automating a Quick Initial Load, and Some Gotchas


A couple of weeks ago I made this post about quickly building a CDC system against a vendor ERP database. The key features of this system were the following:
  • the ERP had no built in support for CDC or data warehousing (eg, no inserted/updated datetime columns on tables)

Read more

1 comments, 1,147 reads

Posted in Don Halloran on 1 January 2011

Interlude: SSMS tips


I know I said I was going to add more information about the CDC system in this post, but I wanted to throw up a quick sideline before Christmas.

SSMS is a powerful tool, and one I am very happy with. It contains a lot of really useful features…

Read more

3 comments, 1,206 reads

Posted in Don Halloran on 23 December 2010

Easy CDC in 5 hours (less for you!) using automatic code generation.


Update #3:
Another reformat, thanks to andreas for giving me the heads up. The pre tags aren't behaving across browsers so I have had to set a fixed width of 600 pixels. I have also set the inline code text to 10 pixel consolas, which still looks pretty decent…

Read more

4 comments, 998 reads

Posted in Don Halloran on 21 December 2010

Older posts