I've had two other careers, maybe more, before becoming a data person

I wonder whether it could be made easier to sue firms for negligence when you find that they've lost your details to the Dark Web. The problem with this...

@andrew..Peterson

There was a book that Microsoft gave away with SQL Server in the early days that was wonderful. It used _PUBS database for all the examples and was...

@dan-2 Meenan

Very good point. I generally do it that way to preserve any permissions or extended properties. In this article I did it the simpler way just because...

@Paul.kohlmiller

The idea of idempotency in build scripts has been around a long time. It is a useful word, and there isn't anything else that quite captures the principle....

@roworthm,

Yes, I rather forgot that and the Tech reviewer reminded me. I ought to change those checks. Sadly, I've been using these routines a long time! On...

Somewhere, there is a large corporation that curses and swears at a system I put in place twenty years ago that did an ETL job. It is still in use...

@robert

I expect that RedGate would be happy about the link because they are linking to the Redgate site. Where might be the problem?

Re: copyright: I'm no lawyer,...

@robert,

This is fine on a company Wiki that is accessible only to your company, with an attribution to the source. Redgate, who own this site, are only concerned...

Thanks. @IwasBornready

This series has been received quite quietly so far, so it is nice to know that someone appreciates them!

I think that, when you put the code into source control you should add all the details of the beverages and liquor you'd consumed in the preceding 24...

it certainly can. It is no crime but it is a sign that there...

Ah yes. Mergers are a real testing ground, especially if the 'natural' business terms, constraints and even units of measurement of the merging companies are different. This isn't really...

I've had to work with plenty of databases that have mimicked the old card file system. The old card file had that great advantage that you could write ad hoc...

There are several JSON and XML ODBC drivers being sold. There has to be some mapping of the JSON documents to tables. You generally use XML-based schema configuration...