Problems displaying this newsletter? View online.
Database Weekly
The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com
Hand-picked content to sharpen your professional edge
Editorial
 

How Do You Know You Are Right?

I spend a significant amount of time working alone at my desk. I write articles, edit them, and share my opinions. However, I am constantly concerned about being wrong. How can I overcome this feeling? If this were a live session, I would eagerly listen to the answers to this question. Since it isn't, I will go ahead and share my methods and look forward to your feedback and ideas in the comments!

The Modern Starting Point

My first place to seek guidance is the Internet. Like most everyone these days, I love the Internet. This is, of course, despite its vastness and potential drawbacks (many of which stem from much of its content coming from people who are confident they are right, whether they are or not). While the Internet can be overwhelming at times with many answers purporting to be correct (and many of those not correct that they are correct), it serves as a treasure trove of knowledge that my set of Compton’s Encyclopedias never possessed. As long as you realize that Internet is not always as reliable as those books were, you can learn almost anything if you look around multiple locations saying the same thing. Or at least one source you actually trust

The Internet also has another issue: you often need a clear idea of what you are looking for. For instance, say I wanted to validate something like someone who told me of the only way to view your data in a database. So maybe I search for “how do you view the data in a database?” Typing this into a search engine, I found that this search led me to the CREATE VIEW statement. While it is true that if I had asked the question more precisely, I could have reached the SELECT statement I am probably looking for, I needed context that I may not have if I were not writing this editorial on SQL Server Central.

Not knowing enough about a subject to ask a question about it is a significant portion of my life at times. Searching and exploring the Internet to validate my knowledge, even when I am certain of it, is a bit maddening while also being mostly very educational.

Teamwork Enhances the Clichés

The overall point I am trying to get to here is that the old adage “two heads are better than one” is not entirely false, despite what the average introverted tech person may wish to believe. Where the Internet answers questions, they don't have the value that other people have. While effective collaboration and task adherence are crucial to working with other people, there is immense value in having individuals you can rely on and ask questions of, mostly without judgment. A little concerned/jovial judgement is okay at times, like if I need to ask how to view data in a database, I either deserve some teasing or may require medical attention.

Having a team or even something like pair programming  can be a beneficial approach, specifically because time spent thinking and validating ideas is a significant cost of producing work like programming because it is typically more about deciding what to do than it is rote work that is basically mindless. 

Getting things done correctly the first time pays off more than keys clacking out mediocre output. The time spent deliberating whether one’s position or design is correct is significantly reduced when two or more colleagues work together to validate the work being done.

What about Artificial Intelligence (AI)?

AI does not currently replace human beings (and it probably never will entirely) due to a lack of reasoning and contextual factors. For instance, consider my question about viewing data. The computer gave me the answer it did, because it lacks the context of the world I live in. Without extensive prompting it could take a while to really get it to know what I mean. But teammates probably already knows something about what we are doing without being told, and even if they can't give you the answer directly, they probably can give you a hand honing your questions with more context,

Not that I am dismissing AI. Currently, AI serves as another half teammate that can efficiently search and summarize data quickly and help you find answers. But it is nowhere near as efficient as a human expert that can reason that something is right or wrong based on the entire context of a situation. Well, not until you figure out how to ask it the question you really wanted to know.

What brought this up?

This realization struck me while I was working on a project today. I realized that I no longer had a specific individual I could simply ask, “Is this correct?” or at least, “Where should I look for this information?” As I expand my mind from being a SQL Server-only type programmer and start to consider how PostgreSQL, Oracle, MySQL, and any of the plethora of other data platforms (relational or otherwise), I don't always know how to ask the question in the terms of these other systems. Having someone close to ask some of these questions saves me time, and I can always reciprocate with things that I know.

The bottom line: some things are simply better when worked on collaboratively with a team.

Louis Davidson (@drsql)

Join the debate, and respond to the editorial on the forums

 
The Weekly News
All the headlines and interesting SQL Server information that we've collected over the past week, and sometimes even a few repeats if we think they fit.
Vendors/3rd Party Products

Run Redgate Monitor on PostgreSQL with TimescaleDB

From Blog – Redgate Software

I’m delighted to share that you can now run Redgate Monitor’s data repository on PostgreSQL with TimescaleDB, achieving dramatically improved performance and scalability at reduced cost. Why are we...

AI/Machine Learning/Cognitive Services

AI use damages professional reputation, study suggests

From Ars Technica

New Duke study says workers judge others for AI use—and hide its use, fearing stigma.

Administration of SQL Server

Counting NULLs in SQL Server Tables

From Curated SQL

Vlad Drumea counts that which does not exist: I’ve seen variations of the question “how to count all NULLs in all columns of a table”…

Restoring Multiple Differential Backup Files

From Curated SQL

Tim Radney violates Betteridge’s Law of Headlines: I was recently asked if you can restore multiple differential backups in preparation for a migration. I responded…

Create a Linked Server: #SQLNewBlogger

From SQLServerCentral Blogs

I had a customer recently that was asking about Li...

Don’t Let Your Kids Drop ACID.

From Brent Ozar Unlimited

We’re heading towards graduation time. In just a...

Your SQL Server Is Whispering…Are You Listening?

From DallasDBAs.com

Early Warnings of a Meltdown (and How to Catch Them) Most SQL Server crashes don’t come out of nowhere. They leave breadcrumbs – red flags that something’s not right....

Azure Databricks, Spark and Snowflake

Real-time Data Streaming in Snowflake

From Simple Talk

Real-time data ingestion has become essential for modern analytics and operational intelligence. Organizations across industries need to process data streams from IoT sensors, financial transactions, and application events with...

Cloud - Azure

Azure Vulnerability Assessments

From SQLServerCentral Blogs

Regarding managing databases in the cloud, security should never be an afterthought. That’s where Azure Vulnerability Assessments, officially named Microsoft Defender, come in—they help you spot weak spots in... The...

Conferences, Classes, Events, and Webinars

SQL Saturday New York City 2025 is Back!

From SQLServerCentral Blogs

After missing last year, SQL Saturday New York Cit...

Data Warehousing

Choosing a Warehousing Data Architecture

From Curated SQL

James Serra compares and contrasts OLAP architectures: As discussed in my blog and book “Deciphering Data Architectures: Choosing Between a Modern Data Warehouse, Data Fabric, Data Lakehouse,…

DevOps and Continuous Delivery (CI/CD)

Top 7 DevOps Job Titles in 2025: From Engineer to Director

From IT Pro - Microsoft Windows Information, Solutions, Tools

This guide to the most prevalent DevOps job titles in 2025 details what to expect from roles ranging from entry-level DevOps engineers to senior-level directors.

General

Rounded Corners in Power BI

From Curated SQL

Elena Drakulevska breaks out the sandpaper: I’ve been seeing all kinds of shapes in Power BI reports lately—and seems like there’s a lot of guesswork…

Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science)

Microsoft Fabric Continuous Integration maturity levels

From Kevin Chant

Reading Time: 3 minutesIn this post I want to en...

Validating Azure Key Vault Access Securely in Fabric Notebooks

From Data – Marc

Working with sensitive data in Microsoft Fabric requires careful handling of secrets, especially when collaborating externally. In a recent customer engagement, I needed to validate access to Azure Key...

Oracle/PostgreSQL/MySQL/other RDBMS

Checking Index Utilization in Oracle

From Curated SQL

David Fitzjarrell wants to see which indexes are in use: Database performance is one of the biggest areas for DBAs to address, measured primarily in…

Tracking Wait Classes in Oracle

From Curated SQL

Kellyn Gorman looks for performance bugbears: When...

Performance Tuning SQL Server

Darling Data Blocking Monitor App

From Curated SQL

Erik Darling announces a tool. If you’ve given Erik money in the past (which I can confirm is an easy enough task). If you’ve used…

Video: The APPLY Operator in T-SQL

From 36 Chambers – The Legendary Journeys

THE VIDEO THE SYNOPSIS In this video, I explain th...

Does The FORMAT Function Still Suck For Performance in SQL Server?

From Erik Darling Data

Does The FORMAT Function Still Suck For Performanc...

Introducing sp_PerfCheck

From Erik Darling Data

Erik Darling has some new code to help you check performance

PostgreSQL

Digging into Non-Idempotent Subqueries via CTE in PostgreSQL

From Curated SQL

Shayon Mukherjee continues pulling on a thread: A few days ago, I wrote about a surprising planner behavior with CTEs, DELETE, and LIMIT in PostgreSQL, a piece…

AI in the DBeaver Query Editor

From Scary DBA (Grant Fritchey)

You know I had to do it as soon as I found it was ...

Umair Shahid: Improving PostgreSQL Performance with Partitioning

From Planet Postgres

My recommended methodology for performance improvement of PostgreSQL starts with query optimization. The second step is architectural improvements, part of which is the partitioning of large tables. Partitioning...

PowerPivot/PowerQuery/PowerBI

Tools in Power BI

From SQLBI

Overview of some available tools that help you cre...

Calculated Columns vs Measures in DAX

From Excelerator BI

Level: Beginners Original: Feb 2016 It has been many years since Matt wrote his first take on Calculated Columns vs Measures, back in 2014 when he wrote the blog...

Security News and Issues

Passkeys for Normal People

From Troy Hunt's Blog

Let me start by very simply explaining the problem...

After the Breach: Finding new Partners with Solutions for Have I Been Pwned Users

From Troy Hunt

Presently sponsored by: Join Snyk's May 15th event...

T-SQL and Query Languages

Techniques to query Azure SQL’s new JSON Datatype

From Simple Talk

The new JSON field type and new functions in Azure...

Using EXCEPT and INTERSECT to Validate SQL Server Query Tuning

From SQLRx

This article explains how the EXCEPT and INTERSECT T-SQL operators can help compare query results when tuning SQL Server queries, stored procedures, and views. Recently, a customer requested that...

The Lighter Side

Data-Based Movie Reviews: Moneyball

From Simple Talk

A while back, a friend of mine, who is big into ba...

 
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. Note: This is not the SQLServerCentral.com daily newsletter list, and unsubscribing to this newsletter will not stop you receiving the SQL Server Central daily newsletters. If you want to be removed from that list, you can follow the instructions on the daily newsletter.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
webmaster@sqlservercentral.com

 

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