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

Daily Coping Tip

Be a realistic optimist. See life as it is, but focus on what’s good

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.

What's the Lunch Factor?

A few weeks ago I wrote about the bus factor. This is the number of people that could cripple your organization if they got hit by a bus. Maybe a better way of looking at this is the lottery factor. If these people won a lottery and quit, would they cause problems? There were some interesting answers in the discussion.

There is another factor that I heard about in a presentation that I found interesting: the Lunch Factor. This is the number of people that have to get involved for you to deploy changes to production. Today, I wonder what your lunch factor is? Leave a note in the discussion.

This may be one set of people in your organization for things like patches, which are supposedly tested and approved by the various vendors you use. For software that you develop internally, likely there is a slightly different group of people, with some overlap. Usually the Operations staff is the same in both situations.

In a true DevOps organization, the idea is that developers can actually release code to production. Maybe not every developer, or not every developer can release every type of change, but the idea is that developers can, and do, release code. They're also responsible for this code. In my discussion with Donovan Brown and Abel Wang of Microsoft recently, this is how they view the world.

They also would likely have most code released triggered and controlled by feature flags, which might ensure that customers can't see the code right away, or that the code doesn't break existing customer work. This also ensures that you can turn the feature off if there are problems. I'm a big fan of feature flags (or feature toggles) and think they are way too underutilized by many organizations.

Allowing developers to release code is difficult for many managers, and even for Operations staff. There is always the worry that developers don't have the expertise or accountability to make these decisions, and many orgs don't have the capability built in to allow this, much less give the authority to a wide group of people.

Microsoft does, as do lots of organizations trying to embrace DevOps and produce higher quality, more adaptable software. Many of these companies are bound by Sarbannes-Oxley and other regulatory rules, and they make it work. They grow, change, adapt, and most importantly, constantly improve their systems and process to allow this. For them, the lunch factor is 1, or maybe 0 if you consider that no one needs to get taken to lunch. What's your factor? What staff, managers, even change control boards have to get involved? Let us know today and then think if you could reduce that number.

Steve Jones - SSC Editor

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

Redgate SQL Prompt
 
 Featured Contents

Create AT&T Network Hierarchy Diagrams using SQL Server Data

Paul Brewer from SQLServerCentral.com

Diagrammatic support for large, complex hierarchical data structures in SQL Server.

Auto Scaling Azure SQL DB using Automation runbooks

Additional Articles from MSSQLTips.com

Learn how to auto scale an Azure SQL Database with Azure runbooks and using an existing runbook from the runbooks gallery.

Welcome to Redgate Deploy and Cross-platform Database DevOps

Additional Articles from Redgate

Until now, organizations wanting to introduce database DevOps have had to rely on – and purchase – different tools and solutions for different databases. A new cross-platform database DevOps solution, Redgate Deploy, changes the rules. Find out why in this latest blog post.

From the SQL Server Central Blogs - Assuming Good Intentions

Grant Fritchey from The Scary DBA

With all the stuff going on around the world over the last year, maintaining some degree of mental stability can be quite a challenge. Speaking only for myself, while...

From the SQL Server Central Blogs - I Want PASS to Survive

Steve Jones - SSC Editor from The Voice of the DBA

I want PASS to survive. I can say that unequivocally, because this organization has been a part of my career, my job, and my life for twenty years. Many...

 

 Question of the Day

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

 

Restoring the Deleted Azure Database

I have configured long term retention for the Sales database in Azure, setting this to retain backups for 6 months. This is an Azure SQL Database. After this has been running for 3 months, we have a major issue and need to restore from a previous backup. We do this, restoring the backup as Sales_New, then deleting the Sales database and renaming Sales_New back to Sales. I then realize that the retention period for this new database (Sales_New)was reset to 7 days. What has happened to the other backups from the original Sales database?

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)

Container Memory

What is the default max memory for a Linux container running SQL Server?

Answer: 80% of physical memory in the container

Explanation: The default is 80% of container physical memory. This can be altered with the MSSQL_MEMORY_LIMIT_MB environment variable. Ref: Linux Container Environment Variables - https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-configure-environment-variables?view=sql-server-ver15

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
Profiler and Tuning Advisor Stats Recommendation - I ran SQL Profiler and did a trace, and after handing the file off to the Tuning Advisor, it had some Index recommendations which is understandable. However, there are a ton of statistics recommendations. The capture I did was only for about 20 seconds. The recommendations were very numerous, but the main thing is that […]
display cluster alwayson in windows - hello , I need your help please in my server SQL on  ssms I can display my avaibility group always on and the nodes and the listen so if I connect through failover cluster manager I have nothing thanks    
SQL Server 2017 - Development
Email CSV file - We have a stored procedure and job that will email out invoices daily. It all works great, however, we are trying to get the current date in the CSV filename. Here is the line we are using now for the filename: @query_attachment_filename = 'test.csv' We are thinking of 3 different formatting options: MMDDYYYY.csv Wynne-MMDDYYYY.csv MMDDYYYY-Wynne.csv […]
SQL Server 2016 - Administration
Rebuliding a WSFC with availability groups - We have been having issues with nodes loosing communication on a underlying WSFC that we have our Production Always on Availability Groups on. The Server provisioning team seem to reckon that the cluster, that they built, is not in the best of shape and are talking about rebuilding all the cluster servers.  Being a DBA […]
SQL Server 2016 - Development and T-SQL
SSRS Int64 Multi Select Report Parmeter error - I have a SSRS report in VS2017 that pulls Int64 values into a Report Parameter named "pCampusEquipment" but fails at runtime with a "The property "ValidValues" of report parameter "pCampusEquipment" doesnt have the expected type" error. The parameter works fine if I changed parameter Data Type to "Text" instead of "Integer" but the SQL Call […]
Pivot with Ranges - This is my table BSEG_ID    DST_ID      BILL_SQ        AUDIT_CALC_AMT                Remarks 12334           REV-WSC      62                   6.40667                                For 0 - 60 (Next 62.000 cubic meter) @US0.10 per cubic meter 12334           REV-WSC      62                  64.06667                               For 60 - 120 (Next 62.000 cubic meter) @US1.00 per cubic meter 12334           REV-WSC      3.6                 11.16                                       For 120 - 180 (Next 3.600 cubic meter) […]
Development - SQL Server 2014
How to get all the column name and data type a table variable - there is a parameter in stored procedure, and this parameter is table variable, How to get all the column name and data type for a table variable? thanks!
SQL 2012 - General
How to select data based dynamically based on start and end of AffectedProduct ? - I work on SQL server 2012 I need to get data from #partsdata table where part number matches Affected Product both start and End as Example where I have Affected Product as APAMS-***G then I will get Parts That have start APAMS- and End by G start must be end with dash (-) this roles […]
SQL Server 2019 - Development
Create string from broken hierarchy - Hi I have a broken hierarchy where I need, for each row, to create a string that contains all possibæe combination ordered by creationdate (id column) So for the 1st row it would be: |96811577|2959885|5825374| as row 3 and 5 contains the same values then the result here should be the same as above. I […]
Issue with Foreign Keys - So recently I began to start a personal project to push my limits and try to gain an edge on database work. I have been using MySQL and I am using IonnDB to make use of the Foreign Key relational system. I wrote a long document of tables that I could copy and paste to […]
Reporting Services
Report acting Differently in SSRS Report Editor and on the Server - Having a really interesting problem.  I've added a subreport to an existing report, by adding a second detail row, merging the columns and putting the subreport there.  Originally I had the subreport set to hidden and visible by toggling a group button (in y case, Division).  Works, but when I run the report the row […]
Integration Services
SSIS : How to export data into Excel from Stored Procedure - I might be barking up a wrong tree,  but hope someone can advise on the forum. I have an established stored procedure, which returns a list of records, e.g. EXEC my_stored_procedure returns idColumn (INT) and descColumn (VARCHAR(50)). Now I have a new task to write SSIS to export same result set into an Excel file […]
Error running simple SSIS package - I have a simple package that loads a small staging table from a CSV file. I create the table (succeeds), truncate it, then reload it via OLE DB.  It fails on truncate table SQL task. [Execute SQL Task] Error: Failed to acquire connection "WIN-3SVP8BUQIEM_SQL_2016.AdventureWorksDW.sa". Connection may not be configured correctly or you may not have […]
PowerPivot
Default values for power bi slicer - In most any data analysis tools a fundamental function is the ability to set a default value for a slicer or report parameter. Power BI being the exception. I know there are dozens of semi effective results in a simple google search to circumvent this glaring deficiency in Power BI. I realize that this post […]
SQLServerCentral.com Website Issues
Changing my username email - Apologies if this has been posted but I did a search on email and profile and didn't find anything similar. I have changed jobs and consequently need to change the my email username. When I go to "Edit Profile" under "Profile" on my user account, I am able to do the changes and it says […]
 

 

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

 

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