Interesting deck from Martin Fowler: http://martinfowler.com/articles/schemaless/

A good reason to have SQL Prompt and just ignore what the formatting is in a VCS.

Eric M Russell (4/15/2015)

---

Walking around with your organization's production data, financial spreadsheets, or work email on your laptop is dumb in an age where VPN is an option and wifi...

Are the updates to a row in batch (lots of rows) or singletons? If it's the latter, I wouldn't worry here. There could be page splitting, but it's relatively few....

If you don't include the century, then what is this date?

4/12/49

Assuming this is US (Apr 12), is it 1949 or 2049?

Please also wrap this in a transaction if you're not sure.

select *

from SomeTable

where Auxid = 1219947569

AND Name = 'WALMART T'

and CID = 11987968

begin transaction

Delete from SomeTable

where Auxid = 1219947569

AND...

As mentioned, you cannot restore databases. You could use a copy to move tables, objects, data from one version to the other.

If you are trying to install on the same...

You have the name in the variable you set from the cursor. Use an IF statement to check if it's master and then skip the rest of your loop script.

After crossfit

First, the Starbucks story is made up, but based on real events reported by people. However, don't get wrapped up in I left my laptop on a table. You could...

Andrew..Peterson (4/9/2015)

---

Steve, one of your comments was interesting "...it usually requires I've got good control of production to prevent changes from being made there that aren't also made...

Carl B. (4/9/2015)

---

Hi Steve,

We are upgrading all our databases with migration scripts. We implement it in a way that the tool (that is used to run the conversions) knows which...

In addition to David's link, I've got a bit on my blog (more coming): https://voiceofthedba.wordpress.com/tag/tsqlt/

There are also some posts from David Green: http://blog.dgta.co.uk/

We've got a few things at SimpleTalk :...

There are people doing this with databases. Red Gate has numerous clients doing it, and I've run into others that have built their own systems.

The article was written to introduce...

John Hick-456673 (4/7/2015)

---

Ha! It is a very quasi CI environment; mostly, when I feel updates need to go out, I fire off the batch file that calls the ps1 scripts...