It can be quite a shock for developers to realize they can make radical changes to the data or schema, while testing, safe in the knowledge that it will take them only a few seconds to revert the database to its original state. Phil Factor demonstrates how it's done, using SQL Clone and PowerShell.
2019-04-11
To achieve gains from Database Lifecycle Management in general, and in Continuous Deployment in particular, it pays to aim for lightweight but consistent techniques and processes, refining them iteratively in the light of experience. Edward Elliott describes a Test-driven development process for developing SQL Server databases that worked for CD, based on a series of steps. Though the tools for CD may be necessary, they are not sufficient, without an effective structured process.
2017-07-11
3,560 reads
Many of us would like to be sure we could rollback changes made during a deployment if they caused issues. Steve Jones notes that it might not be worth actually building those scripts in advance.
2016-08-22
432 reads
Redgate’s Arneh Eskandari and Microsoft SQL Server MVP, Steve Jones, will show you how Redgate’s DLM (Database Lifecycle Management) solution works to improve your database development and deployment processes. Today 12noon EDT
2016-03-29
5,329 reads
Failures happen with manual and automated releases, they are a fact of life. Make sure you know how and when to rollback failed deployments
2015-12-31
1,609 reads
How can we ship safe, and ship often? Steve Jones has a few comments on the need for better engineering.
2015-02-11
77 reads
It's important that you are watching your databases' health to be sure that you can make changes, as well as rollback patches when issues occur.
2014-09-29
208 reads
The practice of continuous software development is growing, with continuous integration, deployment, and delivery being topics that Steve Jones is learning about. Today he talks about delivery.
2014-03-10
150 reads
As we ask developers to deliver software quicker, are we helping improve the quality of software? Steve Jones asks the question today.
2013-09-06
203 reads
As you pointed out the sysindexes script only works if the index statistics are kept up-to-date. I think your best bet would be to keep them up-to-date and use the script otherwise you would have to use a script to run SELECT COUNT(*) FROM etc which would definitely not be efficient.
2005-05-27
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
At a recent conference I was asked how I executed code during my presentation....
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers