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

Daily Coping Tip

Share an encouraging news story to inspire others

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 Bus Factor?

I was on a webinar recently and someone mentioned the bus factor, which is a phrase I'd heard before, but not in a long time. Essentially this is the number of people, or maybe a certain specific group of people, who can get hit by a bus before your organization has serious issues.

Do you explicitly know who is important in your organization? I'm sure most executives think their personal factor is 1, meaning they can't disappear without issues. I'm not sure I agree, though certainly we can't lose all executives at once. In one small company I worked in, we never put more than two execs in a plane or car for a trip out of town, just in case something happened.

This week, I wonder what your bus factor is in technology. If you think about your projects, your applications and infrastructure, do you know who the critical people are and how many are needed to keep things going? Or could everyone quit and new hires would take over. In other words:

How many people can get hit by a bus before your org fails?

I think that in Redgate, we don't have many people that are irreplaceable. We have four advocates, and while we have different strengths and abilities, we can fill in for each other. Likely our advocate factor is 4. We'd struggle slightly if all four of us left, though I think our sales engineers and some developers could fill in for us.

In development, we move people around regularly, and while they are valuable and great contributors, I think we could work around a large number of them leaving. I have no idea how many would cripple the company, but it would have to be a number much greater than 10.

It's worth recognizing when you have people in critical positions that are hard to replace. Do you have a single COBOL programmer still keeping something going, or maybe just one long time employee that knows how the BizTalk server runs and no one else makes changes. Think about it today, and let us know if you think there are single points of failure in your organization.

Steve Jones - SSC Editor

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

 
  Featured Contents

Native SQL Backups for Amazon RDS Databases

Bill Brightman from SQLServerCentral.com

Use native SQL Server backups with Amazon RDS databases to easily import and export data between local server and the AWS cloud.

Compare Artificial Intelligence Models Built with T-SQL

Additional Articles from MSSQLTips.com

This tip looks at using artificial intelligence models with SQL Server to predict outcomes.

From the SQL Server Central Blogs - 3D Printing Ear Savers Aug 6th 2020

Tim Radney from Tim Radney - Database Professional

I have now printed over 20,000 ear savers. I hit 20k printed yesterday on Aug 5th, exactly 4 months after starting this project. As of 7PM Eastern today, my...

From the SQL Server Central Blogs - Down Tools Week 2020 (10 minute video/podcast episode)

Kendra.Little from SQLServerCentral

In this episode of Dear SQL DBA, I talk about how Redgate runs "Down Tools Week," what I'm working on as part of the project, and how this has...

 

  Question of the Day

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

 

BDC Instances

What are the types of SQL Server instances that are part of a BDC (Big Data Cluster)?

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)

Holding Dirty Pages

What must happen before a dirty page is written to disk?

Answer: The associated log record must be written to disk

Explanation: Write-ahead logging is used to ensure log records are written to disk before data records. This prevents a dirty page from being written before the log record is hardened. Ref: Writing Pages - https://docs.microsoft.com/en-us/sql/relational-databases/writing-pages?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 - Development
Stored Procedure with Money Value - hi everyone, I've a "problem" with a Stored Procedure and .net application because two values (money) are managed as double and this generate a mismatch with currency (should be 187,50 but is 18750). In SQL, I created a User Table and SP: CREATE TYPE tbl_FIC_InvoiceGuest AS TABLE ( Invoice_Token nvarchar(50) NULL, Invoice_Total money NULL, ) […]
SQL Server 2016 - Administration
SQLServer2016 SP2 CU14 - Hi, Version: Microsoft SQL Server 2016 (SP2) (KB4052908) - 13.0.5026.0 (X64) Mar 18 2018 09:11:49 Copyright (c) Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2016 Standard 10.0 (Build 14393: ) (Hypervisor) We would like to install latest patch CU14 .But Last time CU12 installation was failed in this server. Can we […]
SQL Server 2016 - Run Jobs on Dynamic Logical Schedule - Hello, In SQL 2016, I currently have monthly, weekly and daily maintenance plans that run on a fixed schedule. As a new requirement, I need to run it more dynamically than on a fixed time. The plan is: 1. If 1st of month - then run Monthly job 2. Then check if this is a […]
SQL Server 2016 - Development and T-SQL
sql2016 - if column cell changes, insert value into another column cell - How can I calculate or insert TrimWgt (17.15 from MasterRolls value =3) and (17.15 from MasterRolls value = 4) into another column if the MasterRolls column increments or different from the the previous. If I had another column in the table or I can create another table. Please assist. My table is updating every 30-60 […]
Development - SQL Server 2014
PIVOT table with more than one aggregate and for only weeks with data. - I need help to pivot my sql output for Class with aggregates of QTY and CUBES for WEEKS. Some rows will only have one of the classes. I would like to end up with something like this.   SELECT Datepart(wk, ompcreateddate + 84) AS week, CONVERT(VARCHAR, ompcreateddate + 84, 101) AS date, cmopostcode AS Zip, […]
SQL Server 2019 - Administration
Azure Data Studio and Jupyter Notebooks - Trying to install the PowerShell Kernel for ADS and it wont complete the download, this I am guessing is down to our policy to no longer allow connections to anything using the older TLS/SSL protocols, so it's blocking the download.   Anyone know of a way I can force ADS to use a different version […]
SQL Server 2019 - Development
SSMS SQL Editor "shortcut in the current line" - My fingers were fumbling at the keyboard in the SSMS SQL query editor window, and I ended up with a little [->] icon in the gray gutter bar on the left (where break point icons show). I knew approximately the keys I was working with and searched the Web. On this page: https://docs.microsoft.com/en-us/sql/ssms/sql-server-management-studio-keyboard-shortcuts?view=sql-server-ver15 I found […]
Reporting Services
SSRS page footer doesnt go all the way at the bottom of each or any page - Hello, I have a report almost like an invoice, and i put a page header, and it works, always appears at the top of the ssrs report page no problem. THE PROBLEM.... i have a page footer, and there is a gap between the bottom and the invoice totals etc., i attached a screen shot, […]
TextBox Property>Action>GotoURL for Multiple Values? - Hi I am using two stuff commands in my query. One gets the date of an action, there can be more than one and it was requested to have them strung along do it looks like 1/1/19,2/1/19,3/1/19 etc.... The other stuff command builds a url so the report can link back to the page for […]
SSRS 2016
How to access SSRS out of network - Hi All, I and new to SSRS and have Installed and configured a Reporting Service in my client (Its working in my network and users can access it). I want to test it at first to find out if the users can access to my reports via Internet?(because the final server which is going to […]
SSDT
SSIS dtexec Error - The 'OraOLEDB.Oracle.1' provider is not registered. - Hi I am have one SSIS package that connects to Oracle and pulls the data. I am trying to execute this package using DTExec utility. "C:\Program Files (x86)\Microsoft SQL Server\130\DTS\Binn\DTExec" /ISSERVER "\SSISDB\\\.dtsx" /SERVER "" But I am facing oracle connectivity error "The 'OraOLEDB.Oracle.1' provider is not registered on the local machine." continuously. I have designed […]
Analysis Services
SSAS dimensions and measures to JSON - Hi, I am in a situation where my front end needs names/unique names for all dimensions(levels and members) and also measures/calculations.  What is the best way to go about doing this?
Strategies and Ideas
Need help resisting falling back to dimensional/snowflake schemas - In a structure for an International business with a SalesOrder and SalesOrderLine, a data model needs created that answers these questions: 1. Show me which SalesOrders are in the sale region of South-East Asia 2. Show me the status of each sale order item. 3. Show me the total sales against each sales region compared […]
Integration Services
Import Active Directory objectGUID using .Net Provider for MS Directory Services - For a few years now I have been using SSIS and a ".Net Provider for OleDB\OLE DB Provider for Microsoft Directory Services" Connection in to extract Active Directory account information into a text file, so that I can cross check AD user accounts with accounts in older "downstream systems" that can't talk with Active Directory.  […]
SSIS - How to convert DateTime from ISO format - Hello, In my source file having DateCreated column as ISO format string like '2020-08-05T05:50:49.844Z'. I want to convert from ISO date string to DateTime2 in SSIS. Please advice best way to achieve this. Thanks, Sabarish
 

 

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

 

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