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

Daily Coping Tip

Make time for a friend and have a coffee, meal, or just spend time.

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.

Psychological Safety

One of the biggest challenges to becoming better at building, deploying, and operating software is the culture changes required. DevOps requires we work as a team, which can be hard to do. Often people have competing interests and goals. They don't trust each other as much as we'd like, and maybe more importantly, management doesn't trust the people doing the work.

There is plenty of blame thrown around when things don't work as expected (or aren't delivered). That's a poor culture in which to be creative or experimental. In reality, those things are a lot of what we do in software development. We aren't solving the same problem over and over, building a bridge or house that is mostly constructed as many others are. Instead, we are assembling more complex systems in different ways.

Most of us aren't building airplanes, but the situations and problems in this article could easily be applied to many software development projects. Ambitious sales, targets set by management, not engineers. A lack of listening to feedback and unstated pressures to just push things through the system, regardless of potential issues. Perhaps the only thing I agree with from Boeing's side is that they can't find all defects, just like we can't find all bugs. However, we can often find many and minimize or eliminate the impact of the critical ones.

The pressure on Boeing engineers and line workers is similar to those in software, both on developers and operations. Development needs to deliver features, whether well-tested or not. Operations need to get these out, regardless of the impact on the system. It's a gross generalization, but one repeated over and over in a few places I've worked.

Culture is critical. Part of DevOps is frequent deployments from a faster speed of deployment. However, that's only one part. The other is that we continually learn and improve how we do things. We raise the bar of quality. If we are only focused on moving forward without getting better, we get into the position that Boeing was in. No trust, no psychological safety, and no attempt by management to implement DevOps culture. Instead, they're just pushing for more features with (hopefully) more automated testing, but no real impetus to ensure this is the case.

More and more of the world is run by software. Whether this is in cars, restaurants, or government. When software doesn't work well, there can be substantial problems that not only impact a bottom line, but can prevent people from getting goods or services they depend on. I know many of you that build and operate software try to do a good job, and I hope you know this means polishing your craft and improving your abilities. I also hope that management will learn that their support in improving quality is as important as the drive for more features in software.

Steve Jones - SSC Editor

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

 
  Featured Contents
SQLServerCentral Article

Women as Tech Leads – Tackling the Challenges at the Data Community Summit

Press Release from SQLServerCentral

The WIT panel at this year's PASS Data Community Summit includes a number of women who will answer questions on growing your career and rising up the org chart within your organization.

Technical Article

Stairway to DAX and Power BI Level 19: Dates Functions: STARTOFMONTH(), STARTOFQUARTER(), STARTOFYEAR()

Bill Pearson from SQLServerCentral

Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson introduces three DAX Time Intelligence functions related to the Start of Periods: STARTOFMONTH(), STARTOFQUARTER(), and STARTOFYEAR(). He discusses the syntax, uses and operation of each, and then provides hands-on exposure to the function in Power BI.

External Article

Backing up MySQL Part 1: mysqldump

Additional Articles from SimpleTalk

mysqldump is one of the most popular database backup tools in the MySQL world. The tool is prevalent partly because it’s very basic and quite powerful – mysqldump database backup tool is command line-based, very simple and very straightforward to use. As far as MySQL or its flavors (MariaDB and Percona Server) are concerned, this command line-based tool is one of the top choices for junior and senior database engineers across the world alike.

External Article

Expert-led PASS Data Community Summit Pre-cons

Additional Articles from Redgate

Spaces are still available for next month's PASS Data Community Summit pre-conference sessions - but they’re booking up fast! Choose from 18 deep-dive full day pre-cons, featuring some of the best minds in the data industry, covering everything from technical processes to personal growth.
Register now

Blog Post

From the SQL Server Central Blogs - The Reason We Use Only One Git Repo For All Environments of an Azure Data Factory Solution

Meagan Longoria from Data Savvy

I’ve seen a few people start Azure Data Factory (ADF) projects assuming that we would have one source control repo per environment, meaning that you would attach a Git...

Blog Post

From the SQL Server Central Blogs - SQL Server Registered Servers

Kevin3NF from Dallas DBAs

Query multiple SQL Server instances at one time! Thanks for watching! Kevin3NF Follow @Dallas_DBAs
The post SQL Server Registered Servers appeared first on DallasDBAs.com.

 

  Question of the Day

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

 

THROW Messages

What are my options for the message returned by THROW?

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)

The Assert Transformation

What does an Assert Transformation in Azure Data Factory do?

Answer: This transformation allows you to set custom rules for data validation and quality

Explanation: This assert transformation lets you build custom rules for data quality and data validation. These can be for things like uniqueness, expected values, or something else. 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.


SQL Server 2017 - Administration
Db is slow - Hi SQL Gurus, One of our production database is running very slow. I checked blocking , I didn't see any blocking. Also, check for running processes and look for any waittype. I see null. How to get more insights on a running sql server for a specific databases? What all can he checked in this […]
SQL Server 2016 - Administration
Transaction Logs and Service Stop - Hi! If the SQL Server service is manually stopped (not task killed) does that commit transactions?  Could you theoretically then take the MDF files of a database to a new server and use them to start the database up there without having to bring over the existing LDF files too? Thanks for your thoughts!  
SQL Server 2016 - Development and T-SQL
SQL - How to get rows for a unique object which are not processed even once for - I have a scenario, wherein I want to return the Zuora Object name from my log table of MSSQL 2016. It should only return in result if it is not processed even once for the current date. For example, Account object out of 3 runs was not processed in the first, processed in the second […]
Development - SQL Server 2014
SQL Scheduled Job Performance - I am currently trying to write a query that tells me when a SQL agent job ran last and also how long it took. This is my code currently with cte2 As (select j.name as 'JobName', j.job_id as 'JobID', msdb.dbo.agent_datetime(run_date, run_time) as 'RunDateTime', run_duration as 'RunDurationSeconds' From msdb.dbo.sysjobs j INNER JOIN msdb.dbo.sysjobhistory h ON j.job_id […]
SQL Server 2019 - Administration
How can I refine my query in a best way with optimum results (for large database - How can I refine my query in a best way with optimum results (for large database tables) ? I tried to optimize the query with same results. please see my query. I used two inner join by using the same derived tables which is fine. Our client is now experiencing the slow performance issues by […]
SQL Server Replication - I am setting up SQL Server replication (transaction) with below steps and configuration: Configuration: 1. Publisher on Machine A 2. Distribution on Machine B 3. Subscriber on Machine C Steps: 1. Created a common sql server user with same password on both machine A and B 2. On machine B set up the distributor by […]
SQL Server 2019 - Development
Refinement of my query in a best way with optimum results (for large data) - How can I refine my query in a best way with optimum results (for large database tables) ? I tried to optimize the query with same results. please see my query. I used two inner join by using the same derived tables which is fine. Our client is now experiencing the slow performance issues by […]
Float - Hi, I am having problem with generating a Float which generates a output of adding 1 every second month. Currently, I have a solution of dividing the target by 365, but then I wont get the value to change exactly when the month starts. My data consists of date, employee id and target Hope one […]
SQL Server 2008 - General
SQL query but bad performance - Hello, I have the below query working properly by but very slow, the sub-query is the cause of slow but I don't what is the best way to replace it. SELECT TblStyle.StyleCode,TblColor.Ename + '('+TblColor.Code+')' Color, ISNULL (TblQCDecisionStatus.Ename, 'Need Sample') Status,TblQcbrandManagerColorDecision.CreationDate, TblQcbrandManagerColorDecision.Comment, supplier.Ename Supplier, SUM( TblQCPackingList.Quantity) TotalQuantity, --Sum of all sizes quantity of the same color […]
SQL Azure - Development
New to Azure - which IDE tools? - I've been working as a developer within SQL Server for over 15 years now (DWH and transactional) and think it's time I added SQL Azure to my toolbelt. I've created an account, server and database etc in Azure. Which tools are commonly used in organisations for doing the actual development? I've got Azure Data Studio […]
Azure Data Studio Intellisense Cache Notebooks vs SQL Files - Hi, I've noticed that my SQL notebooks will take a long time to refresh the intellisense compared to a .sql file. When I create a new object, no matter how many times I "Refresh Intellisense Cache", the object will not show up in intellisense until I close the notebook, reopen, reconnect, etc (and even then, […]
Azure Data Factory
How to copy ADF pipeline from one subscription to another and change the config - Hello, I have a pipeline which is a chain of several sprocs, activities etc... My ADF uses user assigned managed identity of the relevant subscription, let's call it ArchiveUser that accesses several Azure sql servers and azure blob storages. Pipeline in Dev Dev subscription ArchiveUser set up in dev subscription Azure sql servers in dev […]
SSRS 2016
Definition of the Report is invalid when Deploying Report - I'm a little new to SSRS and I hope I can get some direction. I have a Report which consists of 4 different Subreports all in their own rectangle to facilitate page breaks (See attachment). Some of the Subreports were copied and slightly altered (new text) and some are used as is. They all run […]
Suggestions
Please fix the "Post Offset" problem. - Clicking on post notifications takes us to the correct thread but frequently takes us to the wrong post.  I've determined that the issue is that posts on any given thread that are marked as "SPAM" are not counted in the "15 posts per page" count. Any chance of getting this fixed (along with the broken […]
Email Notifications is broken again. - Howdy folks... The email notifications for subscribed posts is broken and has been since about 26 Oct 2022.  At least that seems to be when I stopped getting them.  Others (on "The Thread") have confirmed this issue, as well. The emails for what followers post is fine, though.
 

 

RSS FeedTwitter

This email has been sent to [email protected]. To be removed from this list, please click here. If you have any problems leaving the list, please contact the [email protected]. 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.
[email protected]

 

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