given your problem, I would have done this, Steve.

IF Object_Id('dbo.sometable') IS NOT NULL
   DROP TABLE dbo.sometable;

--we script version 1
CREATE TABLE dbo.sometable
  (
  somekey...

Some interesting thoughts there, Steve. I once wrote an article in early 2012 on using migration scripts with databases but it never occurred to me at the time that...

I wonder if the confusion is caused by the false idea that it is somehow wrong to add migration code to object-level build scripts.  I put all sorts of stuff...

I am flattered by the comparison with Justin Beiber, Patrick.

It is difficult to remove any ambiguity from an editorial because one has to keep it short.  'Hotheads' are  people who...

Patrick,

Thanks for showing an interest. I'm sure that everyone would be fascinated to read a guest editorial from you in response arguing, from the technical angle, the reverse; that the...

• This reply was modified 5 years, 7 months ago by  Phil Factor.

A splendid article as always, Steve....
Would it be worth saying that you can also get Azure Data Studio  from Chocolatey?
choco install azure-data-studio -y
This means that you can...

I certainly could be confusing operating systems with languages, but the whole business of...

Ah. Don't get me started about Format() and String-split(). It was just the poor functionality that got to me with String-Split. I hadn't realized it was so slow.  I'll run...

@robert See json-schema.org. The LEARN section is a good place to start. Also, and rather simpler at Newtonsoft . See their introduction...

Thanks a lot for some very interesting replies. The whole business of data transfer makes me pretty damned scared. The quicker and tighter we can nail down these issues the...

Yes, it is an interesting topic with some useful applications
I did a bit on this a while back in Bitwise Operations in TSQL

RedGate has that book out on 101 anti-patterns and there are a few that made me more than wince. I don't recall what they are but I do recall...

That's also how new and terrible "Best Practices" are born. And, yes, I agree.... "It Depends" is correct but can be abused like anything else. Eventually, people need to...

And if anyone thought I was exaggerating TSBs inability to do an upgrade, they are at it again!
TSB suffers another weekend of downtime

TSB customers have...

I think that CSV is important because almost the whole industry knows how it is done and offers it as the default way of transferring tabular data economically. There is...