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

How Do the Experts Become Experts?

Today we have a guest editorial as Steve is at PASS Europe.

What do you do when something goes wrong with an installation or you see some error message that you have never seen before? Most likely, you’ll ‘Google it’ to find the answer. Often, you’ll find a blog post, article, or forum thread describing the same or similar problem along with a possible solution. It’s surprising that most of the time, someone, somewhere, has already encountered the issue and figured it out. If you don’t find the answer, you can always post your question on a forum or even on Twitter and, usually, someone will provide an answer in a short time. I’ve noticed that the same names show up with the answers again and again for a given subject area. These people are the experts that we rely on. I often wonder how they know so much and how they became experts.

My first thought is that they must have ‘insider information,’ such as some friends at Microsoft. For some experts this is true. I recently ran into a technical issue on Azure while editing an article. It turned out that a recent update had introduced a bug to the functionality I was testing. The author I was working with was able to find out from the Azure team when the bug was fixed so I could continue editing the article. Microsoft does depend on people in the community for feedback and to help drive the direction of their products. Many of these people are answering questions and writing blogs about solving the issues.

Some folks do have insider information through the MVP (Most Valuable Professional) award program. Of course, this type of information can’t be shared with the public until it’s announced by Microsoft, but Microsoft does have a great relationship with the MVPs. I’ve even taken advantage of this relationship as an MVP myself. When writing my 2016 Reporting Services book a couple of years ago, I was able to get quite a few answers from the team about the new features. This helped me out quite a bit since there was not much documentation available at that point.

I’ve also wondered if the experts have a sort of sixth sense when it comes to operating systems, programming, databases, or whatever the topic may be. From the outside, they make everything look so easy. What I realized is that they have spent so much time working with the technology, that they have run into many common problems. They may also purposely ‘break’ things to test the limits. One thing I’m sure of, you learn a lot when things go wrong.

In addition to having some friends on the inside, lots of experience, and a willingness to experiment with the technology, these people share what they know with the rest of us. That makes our jobs easier, and for that, I thank them.

Do you have some ideas about how experts got that way? Tell us in the comments.

Kathi Kellenberger

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

 
 Featured Contents
Technical Article

Stairway to Reliable Database Deployments Level 4 – Preparing for Production Deployment

Massimo Preitano from SQLServerCentral

This level examines how a rehearsed changeset is transformed into production-ready deployment artifacts. By consolidating scripts into controlled execution units and validating the resulting artifacts, the approach ensures that production deployment remains predictable and aligned with what was proven during rehearsal.

External Article

SSMS Copilot is Messing With Your AI Prompts

Additional Articles from Brent Ozar Blog

You might notice that the advice you get from Copilot in SSMS isn’t very good, but it isn’t necessarily AI in general. Part of the problem is something specific about SSMS Copilot and the way it prompts LLMs, and I wish I could tell you exactly what it is, but I can’t because I don’t have access to how SSMS is changing your prompts.

Blog Post

From the SQL Server Central Blogs - Stop Using Pandas for Aggregations — Try DuckDB Instead

epivaral from SQL Guatemala

If you've ever loaded a 2 GB CSV into pandas just to run a few aggregations — and watched your machine struggle — there's a better tool for the...

Blog Post

From the SQL Server Central Blogs - Understanding Fabric Ontology

James Serra from James Serra's Blog

What problem is Fabric Ontology trying to solve? For years, most data conversations have started with tables. We ask where the data lives, what columns are available, how the...

Storytelling with Data: Let's Practice!

Site Owners from SQLServerCentral

Influence action through data! This is not a book. It is a one-of-a-kind immersive learning experience through which you can become—or teach others to be—a powerful data storyteller.

 

 Question of the Day

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

 

Secure Communications

As of June 2026, what is the best version of TLS to use with SQL Server?

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)

Converting Money

Does this run successfully on a SQL Server 2022, US English default installation?

DECLARE @YenAmount MONEY;
SET @YenAmount = ¥1500; 

SELECT @YenAmount AS RawValue;

Answer: Yes

Explanation: This works fine. code running successfully Ref: Money and Smallmoney - https://learn.microsoft.com/en-us/sql/t-sql/data-types/money-and-smallmoney-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.


Editorials
Celebrating 30 years of PostgreSQL, A Thank you message - Comments posted to this topic are about the item Celebrating 30 years of PostgreSQL, A Thank you message
Everything I Needed to Know Used to be Found in One Book - Comments posted to this topic are about the item Everything I Needed to Know Used to be Found in One Book
Even When You Know What You're Doing, You Can Screw Up - Comments posted to this topic are about the item Even When You Know What You're Doing, You Can Screw Up
The New Software Team - Comments posted to this topic are about the item The New Software Team
Article Discussions by Author
Fuzzy String Matching in SQL Server 2025 - Comments posted to this topic are about the item Fuzzy String Matching in SQL Server 2025
Representing Money - Comments posted to this topic are about the item Representing Money
No More Deadlocks - Comments posted to this topic are about the item No More Deadlocks
Five SQL Server 2022 T-SQL Functions You Should Be Using Right Now - Comments posted to this topic are about the item Five SQL Server 2022 T-SQL Functions You Should Be Using Right Now
Unraveling the Mysteries of the Ephemeral Model: The Fabric Modern Data Platform - Comments posted to this topic are about the item Unraveling the Mysteries of the Ephemeral Model: The Fabric Modern Data Platform
QUOTENAME Behavior - Comments posted to this topic are about the item QUOTENAME Behavior
Stop Prompting Your AI Agent. Give It a Playbook. - Comments posted to this topic are about the item Stop Prompting Your AI Agent. Give It a Playbook.
Finish the quote - Comments posted to this topic are about the item Finish the quote
Database Mail in SQL Server 2022 - Comments posted to this topic are about the item Database Mail in SQL Server 2022
SQL Server 2022 - Administration
provisioning sql server via VMware Cloud Foundation - Hello, has anyone here ever provisioned and actually used an MS SQL Server with this tool: https://blogs.vmware.com/cloud-foundation/2026/02/12/mssql-adds-wsfc-vcf/ Are there already any experiences regarding advantages or disadvantages? I’m particularly interested in feedback from real users. What’s written on websites isn’t always easy to verify. Thank you in advance. Best regards, Andreas
SQL Server 2022 - Development
Running script without having permission to Function - Good Morning. I have a T-SQL Script which has been developed to execute a Function1 (which itself calls another Function2). Unfortunately I do not have permission to execute these functions. Hence I am trying to re-write the Script to enable the core logic of these functions to be incorporated in to it. Function1 takes TWO […]
 

 

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

 

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