The Redgate Data Catalog can be controlled using Powershell and/or API calls.  There is nothing to stop you exporting stuff from your read-only DB and using it to generate what...

Ideally the descriptions should all be in the common language of the business.  I think there is a case for a technical description though I would see this as a...

@jeff, how do they know the mid string search will always work? How is that more provable than your method?

There's a bit more to CI than throwing it against the...

I had a driving day for my fortieth.  The Ferrari felt like a knackered Fiat until it hit 90mph when, all of a sudden, it came alive and I thought...

The more you dig into data generation the more complicated it gets.  Even if you have a good data generator configuring it to generate data that looks like your production...

I've had a few of these.  The worse one was a deployment pipeline that rewrote the SQL scripts that it executed while attempting to police what it would and wouldn't...

I've had two jobs as a direct result of writing for SQLServerCentral and a number of opportunities.

One of our directors gave me an hour of her time to give me...

Whatever your patching strategy I would hope people are moving to

• Scripted deployments for server installs, service packs and patches
• A large battery of mechanical tests to verify both their...

The reality is that IT workers are paid well above the average wage.  The cost of an annual subscription to one of the MOOCs is not high when expressed in...

Article "Oiling the gears for the data dictionary (Part 2) " on the way.  Have a great New Year Steve

SAS makes much of its ability to push models down to Teradata.  From what I have seen of SAS you are best off doing as much as possible in the...

I find that a lot of specialisms get taken for granted.  It's really easy to set something up and get it running.  The true test is when something breaks or...

Fast forward to 2020 and SQL Server is a transactional DB, an Analytical DB (column store & SSAS), a GraphDB and you could argue that the JSON and XML facilities...

I think you have to make the distinction between decisions and outcomes.

A decision that was correct at the time it was made may have a disastrous outcome and the decision...

Worth reading about Netflix and the Chaos Monkey approach