Problems displaying this newsletter? View online.
SQL Server Central
Featured Contents
The Voice of the DBA

Really Important Software

I remember reading about the Boeing 787 (the Dreamliner) being designed. I was fascinated by the process and excited to fly one. I finally did and enjoyed it. Since then, I try to fly on those when I can as the spacious ceiling and other changes seem to make for a better flight. I impressed with the work they did and the scale of the changes, both in manufacturing and software. There's a short timeline here and if you ever get the chance to take a tour of the factory, do it. It's very cool.
I fly a lot. Last year I took around 50 flights on airplanes, some of them Boeing, some Airbus, some 737s, 777s, 787s, A350s, and a few others. I haven't flown on a Boeing 737-Max 8, though I did just recently fly a 737-800. When a few of those planes crashed, I somewhat chalked this up to pilot training and a lack of options on the planes. I'm not exonerating Boeing or the airlines, but i wasn't concerned. I saw an interesting piece at Vox, but was still curious. After all, I'm in software and I fly a lot.
There's an analysis of the crash from a software developer at the IEEE site that's worth reading. It's a look at the issues, the potential ways things could have been addressed and, perhaps most importantly, the idea that our software is not necessarily going to fix problems. Software is a way of reading data and then affecting changes in the hardware, but it isn't perfect. One of the quotes in the article puts this in perspective for me: " Every time a software update gets pushed to my Tesla, to the Garmin flight computers in my Cessna, to my Nest thermostat, and to the TVs in my house, I’m reminded that none of those things were complete when they left the factory—because their builders realized they didn’t have to be complete."
Data matters, but as we all know, data is sometimes incorrect, jumbled, or otherwise problematic. In this case, Not only does it appear the data could be incorrect, but the plane software isn't looking at all the data, and it certainly doesn't take all the inputs from the pilots. While humans make plenty of mistakes, they need to have inputs and overrides in software systems.
I don't want to get caught up in the issue with these planes, but rather look more generally at our systems. DevOps looks at the idea that we don't know everything about how to build our software when we start. We definitely know it needs work when it leaves our factory, but we also know that this is the case. We take feedback, learn, and adjust what we do. We constantly drive quality up, or at least, that's the goal. Money and politics can get in the way, but the more they do, the less you're doing DevOps.

Steve Jones - SSC Editor

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

Redgate SQL Change Automation
  Featured Contents

Writing R Code in SQL Server - Level 3 of the Stairway to Machine Learning Services

ginger.grant from SQLServerCentral

In this level, learn about how to get the tools needing for coding in R and how to execute some code that connects to SQL Server.

Enable SQL Server Agent Mail Profile

Additional Articles from

Learn how to configure SQL Server Agent to allow emails to be sent for job notifications and alerts.

The BI Journey: The Expert’s Advice – Part 2

Additional Articles from SimpleTalk

A BI project should return value to the company quickly, not only after months or even years of work. In this article by Gogula Aryalingam, Ruthie, the intern, determines which items from her manager's requirements she can complete before the big meeting. She continues working on her semantic model by including a Date table, the star schema, measures, formatting, and more.

From the SQL Server Central Blogs - Drop It Like It’s Hot (Part 2 of the Rename/Drop Objects Process)

Pam Mooney from SQLServerCentral

Dread the drop no more! Part 2 of the rename/drop process.

From the SQL Server Central Blogs - Shrinking a large database with limited outage windows

Kenneth.Fisher from SQLServerCentral

Yes, I realize you shouldn’t shrink your database (data files or log files), but I recently had a case where ... Continue reading


  Question of the Day

Today's question (by Steve Jones - SSC Editor):


Statistics Profile


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


Redgate SQL Provision


  Yesterday's Question of the Day (by Steve Jones - SSC Editor)

Service Broker Groups

When we group message types and directions together in Service Broker, what are we creating in each database that will send and receive messages?

Answer: A Contract

Explanation: Grouping message types and directions together define a contract in Service Broker. Ref:

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.

Bulk Update From List - I would like to update the EmailAddress column of a database table with emails from a list . So basically I have two lists, Emails and Username lists. I want to check each value of the UserName column against the Username  list. Then I would like to update the EmailAddress column with the email from […]
I need help to build a query with wildcard and strings. - Hello I need a query to bring all the account  (6 varchar) when the user type into the field the three first numbers or full account I have account 100101, 100102, 100103, 235101,235102, When user type 100 all the 100's will be in the report. If anyway   I was using wildcard but it didn't work. […]
Combing FailOver Cluster Instance with AlwaysOn Availability Group for DR - Hello Folks, I've a requirement to add AlwaysOn for DR on top of an existing FCI (Failover Cluster Instance). Please provide detailed steps on how to configure this. Any issues on this setup. Existing FCI - 2 Node Active-Passive (Physical Servers) Environment: SQL 2014 Enterprise / Windows Server 2012 R2   Many thanks!
SSRS - Display field value based on user - Hello, WHile using SSRS, I only want to display a fields data value if the user is a specific person, otherwise I want to set the field value in the Tablix to "0'.  I believe  the following  expression would be correct but isgenerating an error message.  Can someone provide some insight?  Many Thanks in advance! […]
QotD: 'Answer This' link still active after answering question -   With the new interface, the only way I seem to be able to get back to the list of questions is to click on QotD in the menu bar, but then many of the questions I'd already answered (correctly or incorrectly) appear as unanswered, i.e. the 'Answer This' link is active. I'm using Chrome […]
Deleting or updating two rows based on a value of one of them - Hi I need help in updating or deleting two rows based on the value of one of the columns. For example, please note the sample data I have provided. CheckNumber 20009, I have three rows. two of the rows have a value of 1 in removed.  In this case, I need to update to any […]
Add Zero(0) to columns based on Min and Max value of the record. - Here min Calendar year is 2010 and max Calendar year is 2013 How to add Zero to employes who does not have that year Input sample: Salesamount CalendarYear Employee 637000 2010 282 3440000 2011 282 4415000 2012 282 3294000 2013 282 1898000 2011 291 4985000 2012 291 3631000 2013 291 478000 2012 296 1209000 2013 […]
XMLAErrorOLE DB error: OLE DB or ODBC error: Invalid column name - I recently added two new measures into my cube, the measures were called AssetValueUSD and InvoiceValueUSD, I also added them to my perspective and my partition query. When I then processed the cube I got an error XMLAErrorOLE DB error: OLE DB or ODBC error: Invalid column name 'AssetValueUSD'. Any idea what I've missed?
Change of a data flow arrow to point to different component ? - It doesn't seem to be possible to change a data flow arrow to point to a new component ? i.e. If I want to insert a new "Row Count" component between a Slowly Changing Dimension component and an "Insert Destination" component for an existing ETL process. Or is there some "trick" that can allow me […]
Dimension property : OrderBy Key - Hi guys, I'm a newbie in development of Sql Server Analysis, I would like to ask some guidance. It's a basic really. I have a Date Dimension with one of the attribute is Month. Question is in that property OrderBy there are 4 options : Key Name Attribute Key Attribute Name The default is Name, […]
Status Update 2 May 2019 - It's been a few days, but I've been out of town and no time to review changes. Quite a few items worked through this week and some nice changes. Code scrolling for wide lines (yay!) Forum rewriting of some links/titles is fixed to allow links to specific posts Remembering your notification settings works with replying […]
Fixate the Menu bar - Is it possible to make Menu bar and Search bar to be always visible and not scroll with the page?
SSIS: Ignore corrupted files when importing flat files - Hello, I created a package that imports csv files into a foreach from a defined directory to a sql server table. It is possible that in this directory there are some corrupt files that is to say they do not have the right number of columns waited by the source component of the flat file. […]
TSQL: How to transform first row as column name? - Hello, I hope you are all well. I would like your help on a data transformation task that I have. I would like to convert the first row of a table to a column name I am working on SQL Server Azure and I get daily data from another service.This service loads a table that […]
Date time time zone conversion built in function - I have legacy databases that stores all data in U.S. Central Standard Time.   Some servers are on CST and others are on UTC.  Built-in function getdate() gets date in the server time, while getutcdate() gets date in UTC.  I need a function that will always return date in CST irrespective of the server time. I […]


RSS FeedTwitter

This email has been sent to {email}. To be removed from this list, please click here. If you have any problems leaving the list, please contact the This newsletter was sent to you because you signed up at
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.


- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -