Problems displaying this newsletter? View online.
SQL Server Central
Featured Contents
Question of the Day
Ad for State of Database Landscape survey
The Voice of the DBA
 

The case for "Understanding our business" training

Early in my career, I discovered that the technical skills I gained outside the DBA discipline made me a better DBA. Some skills applied directly; others helped me follow complex conversations with non-DBA colleagues. I learned that when colleagues seek you out first—not last—you’ve earned their trust. They value your opinion and rely on your insight.

Now, nearing the end of my career, I realise my focus was right but too narrow. Technical depth alone isn’t enough. When you learn how other parts of your organisation work, you spot more opportunities and understand how to make the most of them.

In my experience, companies put sparse effort into maintaining business awareness in technical teams. This shows itself in out-of-control cloud costs, gold-plated features and prioritising the wrong thing.

Why Business Awareness Matters

In my experience, many companies invest little in helping technical teams understand the business. The result is familiar: spiralling cloud costs, gold-plated features, and misplaced priorities.

Most of us receive formal training only for security awareness. Because I work in an ISO27001-compliant environment, I must confirm that I know where to find—and have read—company policies on:

  • Acceptable use
  • Anti-bribery and corruption
  • Business continuity
  • Remote working
  • Physical and electronic security

That’s around twenty documents, each followed by a quiz to prove I didn’t just click Next, Next, Accept.

We should also test our knowledge of our own organisation. Companies evolve. Strategies shift. Priorities change. What you knew when you joined might no longer be true today.

How Organisational Knowledge Fades Over Time

The diagram below is simple, but it highlights a real problem: how awareness of the broader organisation fades as a company grows.

3 Sizes of organisation

In a start-up, two or three people sit around one desk. Everyone knows everything. As the company expands, people specialise. You might still share a floor or Slack channel, but no one can know everything in detail.

Then comes success — and separation. Departments grow into sub-departments, and communication between them starts to thin.  Teams use the same words to mean different things — “customer,” “sale,” “priority.”  Without effort, the natural result is a slow drift toward “us and them” between departments.

What would "Understanding Our Business" training look like?

If we introduced an annual “Understanding Our Business” review, I would expect it to focus on a few simple but revealing questions:

What matters most right now and why?

Is our top priority revenue growth, risk management, cost control, market awareness or something else?

  • Start-ups usually focus on revenue and market awareness
  • Mature organisations shift toward efficiency and long-term stability.

Knowing where we are in that journey helps us direct effort to the right activities.

Who are our most valuable customers, and why?

Value isn't just about revenue. When I worked in advertising, we viewed our customers in 3 ways

  • Large, high revenue and profit.  High financial impact, but fickle.  Large customers are more mercenary and can drop you at short notice.
  • Medium revenue with longevity.  These customers keep your lights on and your bills paid
  • Low revenue but different.  Their needs spurred innovation and experimentation.  This gave us an edge that helped recruit the medium and large clients.

Understanding who the customer truly is matters. At one company, we served as an intermediary. Website users weren’t our customers—the paying clients were the businesses behind those services. During one product change, a team outsourced part of the website without consulting IT. When month-end came, finance couldn’t invoice anyone because no transactions had been captured. The oversight also broke our marketing data flow. Two months later, another team repeated the same mistake.

These issues weren’t technical—they were organisational blind spots.

What are the information flows?

As DBAs, we are often privileged to know where the hidden rivers of data are buried.  We know how fast they are flowing, from where and to what. By sharing that knowledge, we help others understand dependencies, identify waste, and spot risks.

Even if we don’t know whether every data source is still in use, making flows visible allows the right people to decide.

 What does an effective business case look like?

A strong case:

  • Defines the problem.
  • Describes what happens if we ignore it.
  • Highlights the benefits of taking action.
  • Lists the resources required.
  • Identifies the people needed upstream, downstream, and at the centre of the change.

Good business cases clarify thinking and simplify decisions. Even if the outcome is no change, the process still adds value.

Where do I go to find out more?

If “Understanding Our Business” becomes formal training, it needs an accessible FAQ or knowledge hub.

Each topic should list subject-matter experts and stewards so employees can ask questions and share insights.

Closing thoughts

Formal “Understanding Our Business” training would give new employees a strong start and refresh knowledge for existing staff. It would help everyone share a common, current view of how the organisation works—today, not yesterday.

As the business evolves, so must the training. Only then will it strengthen awareness instead of paying lip service to it.

 

David.Poole

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

Ad for State of Database Landscape survey
 
 Featured Contents
SQLServerCentral Article

SQL Server 2025 has arrived!

bobward from SQLServerCentral

SQL Server 2025 has been released to GA. Read about the new version in this piece by Bob Ward.

External Article

How to Build an AI-Powered T-SQL Assistant with Python & SQL Server

Additional Articles from SimpleTalk

If you’re a SQL Server DBA or developer looking to harness AI for your everyday scripting workflows, this article will walk you through building an AI-powered T-SQL assistant using Python and SQL Server.

Blog Post

From the SQL Server Central Blogs - Scooby Dooing Episode 10: The Case of the Copy-and-Paste Consultant

SQLEspresso from SQLEspresso

Every Scooby-Doo episode has one thing in common — there’s always a fake ghost. Sometimes, that “ghost” is really just a guy in a mask trying to scare everyone...

Blog Post

From the SQL Server Central Blogs - Regression Testing: DAX User Defined Functions

Joyful Craftsmen from Joyful Craftsmen Blog

User Defined Functions is a new feature in PowerBI currently in public preview. There is a lot of buzz in the air regarding this because it opens new scenarios...

Architecting Power BI Solutions in Microsoft Fabric

Steve Jones - SSC Editor from SQLServerCentral

Business Intelligence (BI) tools like Power BI are used by a wide range of professionals, creating diverse and complex scenarios, and finding the right solution can be daunting, especially when multiple approaches exist for a single use case. The author distills his 17 years of experience on various data platform technologies in this book to walk you through various Power BI usage scenarios.

 

 Question of the Day

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

 

Specifying the Collation

I am dealing with issues on my SQL Server 2022 instance related to collation. I have an instance collation of Latin1_General_CS_AS_KS_WS, but a database collation of Latin1_General_CI_AS. I want to force a few queries to run with a specified collation by using code like this:
DECLARE @c VARCHAR(20) = 'Latin1_General_CI_AS'

SELECT  p.PersonType,
        p.Title,
        p.LastName,
        c.CustomerID,
        c.AccountNumber
 FROM Person.Person AS p
 INNER JOIN Sales.Customer AS c
 ON c.PersonID = p.BusinessEntityID
 COLLATE @c
Will this solve my problem?

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)

What is the original database name?

What is returned when this code is run?

SELECT ORIGINAL_DB_NAME()

Answer: The database this login specified when connecting

Explanation: This returns the database specified in a connection string or in the -d parameter with SQLCMD. Ref: ORIGINAL_DB_NAME - https://learn.microsoft.com/en-us/sql/t-sql/functions/original-db-name-transact-sql?view=sql-server-ver17

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 2019 - Administration
Columnstore index question - Hi experts, I’ve been going through several articles and videos about Columnstore indexes, but I haven’t been able to find clear answers—so I wanted to ask here. I have a table (a heap, with no nonclustered indexes either) that contains about 110 million records. There’s a job that runs once a week with this query(with […]
SQL Server 2019 - Development
Need to overload tempdb - Yes, you read that title correctly. I have a somewhat hilarious problem. We have some queries that are overloading tempdb which fills up the drive and brings everything to a halt. This is a reporting server, not OLTP, so we've been given permission from the application owner to kill all queries that fill up the […]
Analysis Services
Member was not found in the cube when the string - Hey, I've not done a cube for many years but I find myself supporting a colleague troubleshoot why his Cube "Timesheet" isn't processing. The error I'm getting is: The '[2025-11-11 09:00:00]' member was not found in the cube when the string, [Instruction Date].[By Calendar].[Date].[2025-11-11 09:00:00], was parsed. On the face of it I expected the […]
Editorials
Being Mindful of Design Time - Comments posted to this topic are about the item Being Mindful of Design Time
Internal Staff Growth - Comments posted to this topic are about the item Internal Staff Growth.
Do You Really Need HA? - Comments posted to this topic are about the item Do You Really Need HA?
SQLServerCentral.com Test Forum
Trying a new post to see what happens - is this visible? select @@version
Administration
Cannot get KB959420 - Hi, we lost our sever sql2000 To restore database to a new one we need fix KB959420 because system dbs require same version. I cannot find KB959420  anywhere Can anyone help me? Thanks Fabio
Article Discussions by Author
Getting the Object Code - Comments posted to this topic are about the item Getting the Object Code
T-SQL in SQL Server 2025: Concatenating Strings - Comments posted to this topic are about the item T-SQL in SQL Server 2025: Concatenating Strings
Identify a Slipstream Installation - Comments posted to this topic are about the item Identify a Slipstream Installation
Implementing PostgreSQL with Python for Real-Time Logging and Monitoring - Comments posted to this topic are about the item Implementing PostgreSQL with Python for Real-Time Logging and Monitoring
SQL Server 2025 Unveiled: The AI-Ready Enterprise Database with Microsoft Fabric Integration - Comments posted to this topic are about the item SQL Server 2025 Unveiled: The AI-Ready Enterprise Database with Microsoft Fabric Integration
The New Database CheckDB - Comments posted to this topic are about the item The New Database CheckDB
SQL Server 2022 - Administration
Transactional Replication - Recently stood up a 2022 Enterprise server. Have 8 publications with subscriptions on a SQL 2019 server for reporting purposes. 7 of the publications work as expected, the 8th does the snapshot, but fails when populating the subscriber. It fails on the same table/file every time and moves on to the next file if I […]
 

 

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

 

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