SQLServerCentral - www.sqlservercentral.com

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

Featured Contents

Featured Script

The Voice of the DBA

A Buggy Release

I definitely believe in a DevOps process, though a thoughtful, incremental one. I think this is the best way to develop software, whether you release every day or every year. Yes, you can implement DevOps and release once a year. You just end up tracking, testing, communicating, and being ready for that once a year release. Of course, I bet you don't release once a year since I'm sure you'll patch the system at least once.

One of the core principles of DevOps is to use automation where you can. Remove humans and ensure that repeatability is possible for moving software from one machine to the other. Communicate, test, and then alter your process to work better. This requires the monitoring and input of humans to examine the process, but they shouldn't be involved in deployments other than approving them. It's too easy for an individual to make a mistake.

However, DevOps isn't a panacea for building better software. Witness the issues at Knight Capital, where they went from having $364mm in assets to losing $460mm in 45 minutes. Mostly because of a problem deployment, where an engineer didn't deploy code to all the servers in their farm. Certainly a clean deployment to every system might have prevented this, but the reuse of old flags in code is problematic, as is leaving old code around that could be executed.

In addition to moving to a DevOps mindset, I'd also say that you should be sure that you follow good software development practices as well. Clean out old code (including database code) and be very, very careful about reusing any part of your software, including flags, for a new purpose. It's far, far too easy to make mistakes here.

Steve Jones from SQLServerCentral.com

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

The Voice of the DBA Podcast

Listen to the MP3 Audio ( 3.5MB) podcast or subscribe to the feed at iTunes and Mevio . feed

The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at www.everydayjones.com.

Everyday Jones

Follow Steve Jones on Twitter to find links and database related items and announcements.

ADVERTISEMENT

Quickly search
for SQL across
your databases

Featured Contents
 

Azure SQL Limitations compared with a SQL Server Enterprise

Daniel Calbimonte from SQLServerCentral.com

In this article, we will compare a traditional SQL Server Enterprise Edition with an Azure SQL Database and see the differences. More »
 

What's "Actually" going on with that Seek?

Additional Articles from SQLPerformance.com

Rob Farley digs deeper into seeks and actual rows read, demonstrating a case where you want a non-sargable expression in the WHERE clause. More »
 

Redgate’s 2016 Roadmap

Additional Articles from Redgate

What do you get for your Support & Upgrades package? Read this blog post to learn about the new functionality and improvements Redgate is releasing this year. Find out more. More »
 

From the SQLServerCentral Blogs - Using a Lookup Component in SSIS for Surrogate Keys in a Fact table

Thomas LeBlanc from SQLServerCentral Blogs

There are many suggestions for loading a data warehouse using SQL Server integration Services (SSIS). Once you get started, you... More »
 

From the SQLServerCentral Blogs - Another Query to Help Find the Right Event

Jason Brimhall from SQLServerCentral Blogs

Finding the right event or combination of events to monitor may seem like quite a daunting task with so many... More »

Question of the Day

Today's Question (by Brett Shearer):

What happens when the following four statements are run?

create database [  ] -- 2 spaces
create database [ ] -- 1 space
drop database [ ] -- 1 space
drop database [  ]  -- 2 spaces

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 2 points in this category: Oddity.

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

SQL Server T-SQL Recipes

SQL Server T-SQL Recipes is an example-based guide to the Transact-SQL language that is at the core of SQL Server. This edition has been lightly updated for SQL Server 2014 and provides ready-to-implement solutions to common programming and database administration tasks. Learn to create databases, create in-memory tables and stored procedures, insert and update data, generate reports, secure your data, and more. Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Shiva N):

What is the output of this T-SQL? 

 SELECT COUNT(*) , COUNT(10) , COUNT(1);

Answer: 1,1,1

Explanation:

The answer is: 1,1,1. An aggregate funciton will work successfully without using any from clause and table. In this case, the count of each of these items is 1 item.

Ref: COUNT - https://msdn.microsoft.com/en-us/library/ms175997.aspx

» Discuss this question and answer on the forums

Featured Script

Fibonacci Series in TSQL

Vignesh Arulmani from SQLServerCentral.com

This function is used to generate the fibonacci series for given number.

Check this out..

select * from dbo.fn_generate_fibonacciseries(10)

Regards,

Vignesh Arulmani

More »

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 2016 : SQL Server 2016 - Administration

I nedd code to purge or clear sql server logs (current) not database logs - I nedd code to purge or clear sql server logs (current) not database logs

Reporting Services 2016 503 error on attempting to fix authentication - I have just installed a clean SSRS 2016 Express (and SQL 2016 Express) on a new laptop running Windows 10. The...

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

STDistance with SPATIAL INDEX QUERY TO SLOW :) - hi all, i have to following query : DECLARE @latitude float=31.24326 DECLARE @longitude float=34.79418 DECLARE @g geometry= geometry::Point(@longitude, @latitude, 4326); DECLARE @h...

Exclude zero till get first nonzero value.(use cte or select) - Hi Friends , input code : CREATE TABLE #First_nonzero ( value int ) GO INSERT INTO #First_nonzero VALUES (0), (0), (0), (0), (1), (2), (0), (3), (0) Expected_output : 1 2 0 3 0 please some one suggest me how...

SQL Server 2014 : Development - SQL Server 2014

Temp Table vs Permenant Table - Hello, I have a SP that uses 4 big temp tables and then inserts data in real sql table and then...

Dynamic query - Hi, In continuation with a previous topic I asked I still have issue with a new dynamic query (this is kind...

Script to stop service using XP_CMDSHELL, restore full and differential .bak files in a single script - Hi - I have a need to stop some application services based on the database environment I am refreshing, restore full...

SQL Server 2012 : SQL 2012 - General

Best method for Update then insert with single transaction - Guys- I have a table with 23 billion rows so Merge is out, as it scans the entire thing and has...

Cannot Execute SQL Configuration Manager - I have several SQL instances running on my development computer. One for SQL2008R@ (64), two for SQL2012 (64), and one...

SQL Server 2012 : SQL Server 2012 - T-SQL

Better method for computed column? - Hi all. Below I am creating 3 tables. Order_hdr (OH), Order_dtl (OD) and Product_Stat (PS). I had a static field in...

Find all 35 combinations in 7 numbers ? - I have a table like this : [IMG]http://i64.tinypic.com/biry21.jpg[/IMG] How can I get all possible 35 combinations of each date by SQL query. Thanks...

How to read XML - Hi All, I want to read/update values of Id1,Id2 in below XML which is stored in one of the table's XML...

SQL Server 2008 : SQL Server 2008 - General

Linked server error on SQLserver 2008R2 - Just getting this error when i try to create a Linked server from Server2 a SQLServer 2008 R2 server to...

"##MS_PolicyEventProcessingLogin##" errors - I installed the Oracle 11g client on my (Windows 2008 SPK2/SQL 2008 R2) and set up a Linked server to...

How to imbed an image into an email sent by dbmail - Hello all and thank you in advance for your time and expertise. I am sending out customer statements in email using...

SQL Server 2008 : SQL Server 2008 Performance Tuning

Need Help! ETL Stored Procedure Used to Work but Now Very Slow - There is something bogging down our computer/server and causing job schedules to hang or fail and I cannot find it....

Same Query but different logical/physical reads - I have a same query to find MIN(download_id) but different data ranges in where clause. The criteria which has more...

Programming : Connecting

Windows Authentication form Web application - I have SQL Server 2012 Standard installed on Windows Server 2008 R2 Datacenter. SQL is set to allow mix mode...

SQLServerCentral.com : Articles Requested

Bad Scalar Functions (or other UDF) - If you can share a story of a real scalar or multi-statement table UDF and how you fixed it, I'd...

SQL Server 7,2000 : Administration

SQLServerAgent Error: 32. [SQLSTATE 42000] (Error 22022) - Our maintenance job for recycling SQL Server Agent errorlog frequently fails with following error: ----------------------------------------------------------------------- SQLServerAgent Error: 32. [SQLSTATE 42000] (Error 22022) ----------------------------------------------------------------------- When...
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.
This transmission is ©2015 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com