A community of more than 1,600,000 database professionals and growing

The Voice of the DBA

Deploy the Database First

This editorial was originally published on Jan 26, 2015. It is being republished as Steve is traveling.

One of the patterns I've seen in some environments is people are trying to deploy changes rapidly to their database backed applications. That's not news, but what is interesting is some of them are staging the deployment of the database changes first. Not as in I deploy database changes at 8:00pm and then application changes at 8:30pm. These people try to deploy the database changes on Monday, and their application changes will follow on Tuesday, Wednesday, or even a month later.

It's an interesting concept, though I think it requires a lot of forethought in your designs, as well as very tight coding from your front ends that won't be disturbed by extra columns in a result set. That's not easy to do, but it's certainly possible, and it can even be useful if you deploy feature flags extensively in your application.

As we become more dependent on databases for our applications, and our customers expect systems to be running constantly, I think it behooves us to find ways to make alter and enhance our applications without downtime. While there are patterns to keep applications running when the database goes down, I expect that the reality is that we need to find ways keep the database up as we alter it, which for me means making non-breaking changes.

I think it's possible in many cases to upgrade a database over time by carefully planning your schema changes and accounting for those changes in your front end architecture. However it's not easy, as I mentioned, and you do need to commit to very stable and careful programming practices for your developers.

Steve Jones from SQLServerCentral.com

Join the debate, and respond to today's editorial on the forums

Redgate University

Self-paced online training courses with easy to follow classes on getting started, exploring advanced features, and making the most of Redgate products. Learn the fundamentals, best practices, and top tips from the experts - Redgate’s Microsoft Data Platform MVPs and engineers.
Start Learning

The industry standard for comparing and deploying SQL Server database schemas

Trusted by 71% of Fortune 100 companies, SQL Compare is the fastest way to compare changes, and create and deploy error-free scripts in minutes. Plus you can easily find and fix errors caused by database differences. Download your free trial

Featured Contents

TOP vs Max/Min: Is there a difference?

Mike Byrd from SQLServerCentral.com

Is there a difference between using TOP and MAX/MIN to return and end value to a table? More »

Power BI Introduction: Visualizing SQL Server Audit Data — Part 9

Additional Articles from SimpleTalk

SQL Server Audit is a powerful feature that can help you comply with regulations such as HIPAA and SOX, but it’s not easy to view the data collected. In this article, Robert Sheldon demonstrates how Power BI can be used to view and filter SQL Server Audit results. More »

Database DevOps without compromising the data

Database DevOps has arrived and is here to stay. However this has also brought friction with the increasing importance of data privacy and protection. Redgate’s Compliant Database DevOps whitepaper outlines how you can introduce DevOps processes and their benefits while also keeping your information and data safe. More »

From the SQLServerCentral Blogs - Adding the Constraint Name to the PK at the End of Create Table–#SQLNewBlogger

Steve Jones from SQLServerCentral Blogs

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as... More »

From the SQLServerCentral Blogs - Gathering all the Logs and Running the Availability Group Failover Detection Utility with PowerShell

Rob Sewell from SQLServerCentral Blogs

30/11/2018 – Function has been updated to deal with named instances. Last week the Tiger Team released their Availability Group Failover Detection... More »

Question of the Day

Today's Question (by Kendra.Little):

What does the "cost threshold for parallelism" setting configure in SQL Server?

Think you know the answer? Click here, and find out if you are right.

We keep track of your score to give you bragging rights against your peers.
This question is worth 1 point in this category: Administration.

We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center.

Microsoft SQL Server 2017 on Linux

This comprehensive guide shows, step-by-step, how to set up, configure, and administer SQL Server 2017 on Linux for high performance and high availability. Written by a SQL Server expert and respected author, Microsoft SQL Server 2017 on Linux teaches valuable Linux skills to Windows-based SQL Server professionals. You will get clear coverage of both Linux and SQL Server and complete explanations of the latest features, tools, and techniques. Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Kendra.Little):

Which configuration changes the threshold at which statistics are automatically updated in SQL Server 2016 to a dynamic threshold based on the table's rowcount? (Rather than the old threshold of ~20% of the rows in the table.)

This question assumes that you have not enabled trace flag 2371.

Answer: Database compatibility level 130

Explanation:

Database compatibility level 130 changes the threshold at which statistics are automatically updated.

This is independent of settings for cardinality estimation and query optimizer hotfixes.

You can still use Trace Flag 2371, but the behavior it enables becomes default at compatibility level 130.

» Discuss this question and answer on the forums

Database Pros Who Need Your Help

Here's a few of the new posts today on the forums. To see more, visit the forums.

SQL Server 2017 : SQL Server 2017 - Development

SQL Server Job which downloads the files using Script Task fails after few runs on the Agent - I have an SSIS Package which uses a script task to download some zip files daily from websites. The Package is...

Issue with midnight in stored procedure - I have a very straight forward check in a stored procedure that makes sure an EndTime was entered from an...

Email results of Failed Jobs - Thanks you for your time and any help or questions are appreciated. Currently i have approximately 300+ jobs...and trying to get...

SQL Server 2016 : SQL Server 2016 - Development and T-SQL

Subquery - another way to achieve the same result? - All, I have the following DDL/DML: /****** Object: Table . Script Date: 13/12/2018 23:44:46 ******/

Stumped trying to shred XML data into table rows - Hello experts, I have the following table: MyTable ( MyKey varchar(100) not null primary key, ColXml varchar(max) null ) The ColXml column has xml data...

SQL Server 2014 : Administration - SQL Server 2014

Stuck Parallel Query - I've never seen this before, and I have no idea what to do (other then kill the SPID). Third party vendor...

SQL Server 2014 : Development - SQL Server 2014

need 3rd day of Calendar month - date precision to exclude minutes - I need query (in my case an INSERT) to run only if today's date is 3rd day of Calendar Month? how...

SQL Server 2012 : SQL 2012 - General

how to speed retrieving data from big table data when select from it? - Problem I have table have 20 columns when make select data from new SQL query&

Basic Question: Do you have to restart the instance if you change database or log file growth - Hi All, I have changed the default autogrowth to 300000MB. Do I need to restart the server instance in order...

CREATE EXTERNAL DATA SOURCE - Im trying to extract data stored as a csv file in azure blob storage and import it into my main...

SQL Server 2008 : SQL Server 2008 - General

Suggestion on import data - Hi, Every month I will import data into table. The data doesn't have any primary key. It has year and month...

How to clean buffer cache without using DBCC command? - My situation is that I don't have permissions to run DBCC dropcleanbuffers/freeproccache, but I need to find a way to...

How Check string of Boolean expression is return true or false - Hi Guys, I have a requirement in my project is how to check string of boolean expression is true or...

SQL Server 2008 : T-SQL (SS2K8)

PERCENTILE_DISC for median calculation - Question: is PERCENTILE_DISC for median calculation works for both odd and even number of records? In SQL Server 2008 to calculate...

Can it be improved again? - Hi there, I have want to modify a SP to select item's activities from a main table of 2 million...

Data Warehousing : Integration Services

Automaticaly Build and Deploy SSIS packages. - Hi we're trying to automatically build and deploy an SSIS package up to the Integration Services Catalogue when we check changes...

SQL Server 2005 : SQL Server 2005 Security

SQL Server Active Directory helper? - Hi I am not able to start SQL Server Active Directory helper in my server 2003. What is the use of...

Career : Employers and Employees

Do recruiters primarily recruit for contract jobs? - I live in New Mexico (yes, we're part of the USA, despite opinions to the contrary). New Mexico is primarily...

This email has been sent to newsletter@newslettercollector.com. To be removed from this list, please click here.
If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com.

This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.