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

Daily Coping Tip

Write down your hopes or plans for the next month

I also have a thread at SQLServerCentral dealing with coping mechanisms and resources. Feel free to participate.

For many of you out there working in a new way, I'm including a thought of the day on how to cope in this challenging time from The Action for Happiness Coping Calendar. My items will be on my blog, feel free to share yours.

Speedy Break Fix

I received a report at SSC of a missing toolbar in the forums. I checked, and sure enough, the toolbar for formatting code and text in responses was missing. I submitted a high-priority ticket, mostly because I hate unformatted code. The site was still usable, but people would be posting stuff that just didn't look good. The developers got to work and had a fix, but it still wasn't right. The wrong toolbar was showing. This was a generic toolbar, not the one that we have had for years (this one). They produced a second fix that contained the right toolbar.

The developers are in and out of the SQL Server Central codebase, working for a few days on open issues, then busy with other work for a week or two. They work in a DevOps style environment, with changes run through a Pull request/peer-review process, then CI, then an automated deployment. They often can make a change and deploy it in hours, or even minutes.

Is this a bad process?

It would be easy to say that the developers were moving too fast in their deployments and not testing things. However, the issue in production wasn't easily reproduced locally, and we found a few places where local dev environments don't quite match live. That's been an ongoing problem for as long as we've been developing software outside of production. The DevOps solution here is to adjust the environment setup in code so that dev does match production closer. I'd say this is my solution, but likely we'll find something else in the future that isn't the same and we will continue to need to adjust something to get the environments in sync.

What's the alternative? We could go slower and batch up a bunch of changes, testing them all, moving at a more waterfall-ish cadence. Would we catch this? Perhaps. However, we might not, and if we are batching changes, then bugs live for a longer time in production until we perform a new release.

Or we could build a quick patch, in one of two ways. One is by moving quickly, at an agile/DevOps speed, to quickly build a patch. That's a hacky, not-thought-through flow that many people use to fix a deployment, usually without the process and bounds that a good DevOps process provides.

The other option is to bundle a fix in the next release, which could be next week? Next month? Who knows. Slow processes don't necessarily make the final code better and can prevent rapid fixes.

Ultimately my feedback from here to the project manager is that we need a test, a process, or something that checks for these issues before release. While I know something else could break, I prefer these small deployments taking place often, with bumpers to limit the regressions we know about.

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

PostgreSQL in Azure using the Azure Data Studio Extension

Daniel Calbimonte from SQLServerCentral

Learn how to create a PostgreSQL database and work with it from Azure Data Studio.

External Article

Help shape the future of Flyway

Additional Articles from Redgate

We’ve got some big plans for this year, and are looking to talk to people who use Flyway in a professional capacity. If you are willing to talk to us about how you first started using Flyway, then get in touch. Of course we’ll also look to say thank you for your time in our usual fashion.

External Article

Enterprise SQL Server Performance Tuning and Management with dbWatch

Additional Articles from MSSQLTips.com

We need to transition our team from single instance management and monitoring to managing the overall environment and addressing our most pressing needs to support the organization. How can we move from managing the trees to managing the forest in an efficient and automated manner with a small team?

Blog Post

From the SQL Server Central Blogs - Identify When your SQL Database Was Last Used

rajendragupta16 from DBBlogger

Database servers are used for storing vast amounts of data. It is essential to know when any user last used the database. This blog will cov

Blog Post

From the SQL Server Central Blogs - Which Columns Are Looked Up?

Grant Fritchey from The Scary DBA

A common issue in performance is the lookup, key or RID, but the question frequently asked is, which columns are looked up? You need to know in order to...

 

 Question of the Day

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

 

Azure SQL Database Purchasing Models

What purchasing models are available for Azure SQL Database (as of Jan 2022)?

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

 

 

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

Managed Instance Database Limits

How many user databases are allowed in an Azure SQL Database Managed Instance (as of Jan 2022)?

Answer: 100

Explanation: Managed Instance is limited to 100 databases, the sum of the sizes for these must be under the storage limit. Ref: Resource Limits - https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/resource-limits#service-tier-characteristics

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 - Administration
Storage Performance Very low - At first I thought SQL was under high utilization, but now I'm thinking perhaps the SAN is under high utilization from other VMs, causing our disk IO capacity to diminish. Am I interpreting correctly that the disk IO performance during this peak (in stats) is bad? Avg Disk sec/Read the average is .159 which is […]
SQL Server 2016 - Administration
Where condition for performance - Hi, This is part of the query which I want to change by Removing OR. What is the best way to write a condition like this for better performance? Should I use IN( Looks like OR and IN works same when it comes to execution plan. Please advise. Where test_ID =@Some_CustID OR abcd.oldsome_custID =@Some_CustID If […]
TDE implementation on sql 2016 version - Hi, I'm implementing TDE for first time I researched below steps are what it takes. However, is there any detailed demo on this or what are prerequistes to keep in mind? Please let me know thanks Create a master key. Create or obtain a certificate protected by the master key. Create a database encryption key […]
SQL Server 2016 - Development and T-SQL
SSMA - SQL Server Migration Assistant - Not bringing over PK / FK from Oracle - Hi everyone, I wasn't sure where to post this topic, so I'm just going to post it here. I'm using SSMA to bring over Oracle tables and data to SQL server. But it doesn't look like the SSMA brought over the PK & FK.  Does anyone know if there is an option in SSMA to […]
Administration - SQL Server 2014
Supported SQL version with OS - Hi All, Continuation of this post https://www.sqlservercentral.com/forums/topic/upgrade-sql-and-os-of-legacy Would like to know, SQL 2000 supported OS versions? and for SQL 2005 as well. So that, I can build  2 test VMs so that we can move - SQL 2000 to 2005, 2005 to 2008R2 then finally to SQL 2014.
Development - SQL Server 2014
SELECTing into temp tables - Hi all Does anyone know if it is possible that when doing a "SELECT ...  INTO #temptable FROM ... " something might happen (such as a deadlock) resulting in the temp table being created, but empty when it otherwise wouldn't be? Thanks
SQL Server 2019 - Administration
Fixing SCOM 2019 discovery and unhealthy state errors - Hello experts, We are using SCOM 2019 along with SQL Server management packs. I'm trying to resolve error alerts like these: Information : SCOM Alert: : MSSQL on Windows: Discovery error Warning : SCOM Alert: : MSSQL on Windows: DB Engine is in unhealthy state I know that certain permissions are required in order for […]
SQL Server 2019 - Development
Stored procedure insert data with an id & return a list of all inserted ID's - I need to create a SQL server stored procedure to insert records with an ID column that is an identity.  After the insert if complete, I need to return all the records that were inserted by ID only.  I need ALL inserted records.  This table has stored data.  There is a datetime column, but it's […]
Encryption SQL2019 Decryption -SQL2016 - Hi Everyone, I am trying to encrypt a data column on SQL 2019 and decrypt on SQL 2016. I am not sure if it is possible to do this between SQL 2019 and SQL 2016. The data is replicated over to the SQL 2016 server. I am running the below on the two different servers […]
Stored Procedure Error - Hi I am creating stored procedure for the first time.  I am getting error: Msg 207, Level 16, State 1, Procedure CHECK_IMPORT_HISTORY, Line 9 [Batch Start Line 0] Invalid column name 'NUM_RECORDS'. Completion time: 2022-01-28T21:42:14.6129465-08:00 I even changed the name to NUM_RECORDS_1 in the output parameter and no luck with the error. What is wrong […]
Analysis Services
Change SSAS multidimensional default language / locale (e.g. for error messages) - Dear SSAS Fellows We have an SSAS server on premise, that had been installed in German language. That is, by default it displays error messages in German (screenshot attached). The server's Windows Regional format is German (Switzerland) and Windows Home location is Switzerland. The language of Analysis Services instance is set to English (United States). […]
Administering
SQLServer Error: 4060, Cannot open database in Availability Group DB - SQL Server Strange behavior: I have been Getting the following error massages nonstop after full backup fails. this massage gets generated for each database in this Availability Group.  The job runs every night, and it call SSIS package. Both the SSIS and Job seems okay and the tricky part is that job fails once in a while […]
SQLServer Error: 4060, Cannot open database in Availability Group DB - SQL Server Strange behavior: I have been Getting the following error massages nonstop after full backup fails. this massage gets generated for each database in this Availability Group.  The job runs every night, and it call SSIS package. Both the SSIS and Job seems okay and the tricky part is that job fails once in a while […]
SQLServer Error: 4060, Cannot open database in Availability Group - SQL Server Strange behavior: I have been Getting the following error massages non stop after full backup fails. this massage gets generated for each databases in this Availability Group.  The job runs every night, and it call SSIS package. Both the SSIS and Job  seems okay and  the tricky part is that job fails once […]
SQLServer Error: 4060, Cannot open database in Availability Group - SQL Server Strange behavior: I have been Getting the following error massages non stop after full backup fails. this massage gets generated for each databases in this Availability Group.  The job runs every night, and it call SSIS package. Both the SSIS and Job  seems okay and  the tricky part is that job fails once […]
 

 

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 webmaster@sqlservercentral.com. This newsletter was sent to you because you signed up at SQLServerCentral.com.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
webmaster@sqlservercentral.com

 

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