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

Computer Disruptions

I travel a fair amount for work to speak at various events around the world. Traveling can be quite a disruption to my life, and I do work to limit the amount of time that I’m gone. As my kids have gotten older, I’m have less commitments at home and an extra night during a trip isn’t as much of a burden. It’s even enjoyable when my wife can accompany me to enjoy a few days visiting another part of the world.
I still get on airplanes enough that the scheduling matters. I often plan trips to limit the number of hours I spend in transit, which means I depend on the airlines to keep to their timetable. I’ve been lucky that I haven’t experienced many delays, usually localized to a specific airplane, but I do worry when I see reports like this about computer glitches for the airlines.
There are numerous computer systems that airlines share, some of which are still running on large mainframe systems. As the travel industry has grown, the software managing it has changed. From a single system (and company) coordinating all flights to a distributed set of applications that must interact and share data.
Do we think this is going to happen more frequently in the future? Is the state of software development improving enough to prevent large scale issues and disruptions? As much as I’m pleased by the advancements in software development and the higher quality of code, I still think that companies often take too many shortcuts, without enough testing and evaluation in their quest to build systems quicker.
I hope nothing goes too wrong as I’m traveling this year. I’m sure I’ll have a few delays, but if I do, hopefully I don’t miss any of the speaking engagements.

Steve Jones - SSC Editor

Redgate SQL Prompt
  Featured Contents

Using Notebooks in Azure Data Studio

Steve Jones - SSC Editor from SQLServerCentral

Learn how to use the notebook feature of Azure Data Studio to keep a set of queries together with some documentation.

Deploying and Reverting Clones for Database Development and Testing

Additional Articles from Redgate

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.

What happens when you cancel or kill a resumable index creation?

Additional Articles from Brent Ozar Unlimited Blog

SQL Server 2019 adds resumable online index creation, and it’s pretty spiffy according to Brent.

From the SQL Server Central Blogs - Information Measurement with SQL Server Part 4.4: Sørensen Distance and Its Relatives

SQLServerSteve from SQLServerCentral

By Steve Bolton …………As I discussed in more depth in the last three articles (not counting last month’s digression into Fisher Information, which is out of numerical order), theoreticians…

From the SQL Server Central Blogs - SSMS GUI not working? Try to use T-SQL!

Cláudio Silva from SQLServerCentral

One of the good things, when we have new clients, is that sometimes they have needs that you never heard before. This does not necessarily mean that they are…


  Question of the Day

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


Default Memory on Linux

What is the default memory limit that SQL Server on Linux will use?

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


Redgate SQL Change Automation


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

A new area code

I have this string in R:

> phone <- "(555) 867-5309"

I want to replace the area code with 800. In the US, the first three digits are the area code and the last seven are the main phone number. Which of these does this in R?

Answer: > substring(phone,2,4) <- "800"

Explanation: In R, the substring() function will extract out a string, or replace the partial string in an assignment. The string is 1 based, so the first character is a "(". The 2nd character is the "5" that starts the area code. We then give the ending position, not the length. This means 4 is used. We assign the value "800" to this substring. Ref: Substring -

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.

Status Update 10 Apr 2019 - I wanted to make a status update, and I’ll try to do more of these, as much for my own mental health as to disclose where we are. As of today, there are 104 issues open in Github. A slice of these (6-10) are infrastructure items related to hardware and tuning settings. Most are minor, […]
Intra-site links (at least to other forum posts)render incorrectly in the forums - When posting a URL to a forum post from this site, the site reformats the link to be the name of the topic. Great. BUT, the reformatted URL has two problems: the anchor to the specific post is stripped off (i.e. the pound sign and the post_id) any BBCode is processed as if it were […]
Blog issues: not syncing changes & missing links for original post and comments - Over the past two days I have updated 2 of my 3 most recent posts (“SSMS Tip #3” and “Differences Between Various Binary Collations”), but the changes aren’t coming though. For the old site I was told that it could take up to 48 hours to sync, but prior to the sync breaking it never […]
Using PIVOT - I need to know how can I use PIVOT , my query SELECT A.HIS_STD_OID, B.HIM_SERIES_ID FROM il_cps_conversion.dbo.HEALTH_IMMUNIZATION_SERIES A INNER JOIN il_cps_conversion.dbo.HEALTH_IMMUNIZATION_DEFINITION B ON A.HIS_HIM_OID = B.HIM_OID WHERE 1=1 --AND STDNT.STD_OID = A.HIS_STD_OID AND A.HIS_FIELDB_001 = '0' AND A.HIS_STD_OID = 'std01000001256' AND B.HIM_SERIES_ID <> 'TD' returns following data set with six rows and I need one […]
Small Rant MSDB.DBO.Sysschedules - WHY IN THE WORLD IS THE ACTIVE START AND END TIME STORED AS AN INT?!   I wanted to create some tlog backups using a script to say make the tlog schedule 15 minutes earlier than the diffs If it was stored as a Time(0) I could simply do a dateadd(minutes,@difftime,-15) but NOOOOOOOOOO I had […]
No markdown? - Pity the new forum uses BCC code instead of Markdown formatting.  the latter is so pervasive these days.
Weird issue with 2012 package and Visual Studio 2017 - In one of the projects I work on, we have several packages that pull from Oracle and write to a SQL Server 2012 database.  They’ve been working for years.  Recently we got new laptops and we’re running VS 2017 with all the usual plugins and extensions for SSDT-BI projects.  While working on one package, we […]
A single query to display the result of multiple date selection in month columns - Hi, If I run the following query it gives me a column with the customer prefix and a column with the sum of all the widgets sold for a particular month (in this case January 2019). SELECT customer.prefix, Count( as ‘Jan19’ FROM (SELECT ID, customer FROM dbo.widgets WHERE timestamp> ‘2019-01-01 00:00:01’ AND timestamp< ‘2019-01-31 23:59:59’ […]
Replace a NIC on secondary replica in AlwaysOn - Hi all Hoping I can get some assistance from the AlwaysOn/clustering gurus out there! We have a SQL 2016 availability group (asynchronous) which consists of a primary and secondary replica. The secondary replica has some hardware problems which we are trying to resolve. The hardware support people have recommended replacing one of the NICs. First […]
Date to record zero balance for an account version - Hi All, I’m trying to create the last column on the table below which tracks the latest date for a version of an account where the amount is zero, so the date should remain the same as the first time it went to zero until a new version is greater than zero. It the amount […]
SSIS Error: "Please Specify Server Password" - ProtectLevel = EncryptSensitiveWithPassword And I entered the password in the properties box, but get the error when running the scheduled job. In the scheduled job, the @COMMAND value is:   @command=N'/FILE "\"C:\SSIS_Packages\MyPackageName.dtsx\"" /DECRYPT "\"MyPassword\"" /CHECKPOINTING OFF /REPORTING E',   I would really prefer to not have passwords at all, but can’t seem to get around […]
How can I null out all but the most recent records in this table? - I have an old table that contains a sort of history tracking of clients & their info that we’ve imported.  I now need to null out a field named “RecordType” of all prior records for each client EXCEPT the most recent record for that client, but I’m not sure how to do this. In the […]
Trying to avoid granting Sysadmin to SSIS Proxy account - We have an ETL process involves a couple of packages – one that receives a Database backup from and external organisation and restores it to a staging server (this database obviously doesn’t contain any users mapped to logins or accounts in our organisation) – and a second package that queries that tables on that restored […]
Software dev best practices test? - Years ago I remember reading this manifesto almost about how a company should approach software dev and it was originally on this guy’s blog then it became well known and people referred to it as his first name. It was a list of things that healthy dev shops did and you could count up how […]
help with this query - Hi, i need this query to run against 20 instances from main server that have linked server to those 20 instances.i want to change the [@server]  to the right instance via cursor and make the SELECT statement to work. how can i write the query accordingly?   THX declare @server varchar(50) set @server = ‘servername\instnacename’ […]


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.


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