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

Writing as an Art and a Job

I remember listening to an interview with Rick Reilly in the mid 2000s. He was the back page columnist for Sports Illustrated for years as well as a writer in various pieces. He talked about how he would lay on the couch in his office sometimes, trying to think of what to write. His kids would come in looking for attention, but couldn't understand that Dad was "working".

I had been writing the editorials at SQL Server Central and I could relate. Moving from 2 to 5 (eventually 6) editorials a week was a lot of work. It was stressful in a way I couldn't imagine when I started writing them. I quickly realized that if I had to produce a new one every day, I was in trouble. There would be days I'd struggle. I needed to have a queue of pieces at least partially ready if I were going to manage this job and find balance with my family.

Recently I was listening to an interview with Lee Child, who writes the Jack Reacher series. He said that writing is both a creative endeavor and a job. It requires some inspiration and time, but it also requires you to buckle down and get to work. This is an area where delays are inevitable (everyone gets writer's block) and if you aren't thinking ahead delays will occur. Delays aren't great for newspapers or other scheduled events.

SQL Server Central became a newspaper.

One of the things I did early on was start to enhance my powers of observation. There's no magic here; it's really a habit to look at things in your life in a different way. For me, this meant considering each question posted on the forums, each bug reported in SQL Server, each complaint/criticism/success through the lens of both telling a story and generalizing the wider issue.

I learned to write about what I experienced by seeing the experience as a source of inspiration.

I started keeping notes. First in a text file, then OneNote, then Evernote, and today, Joplin. As I would see something interesting in the world, I'd make a note, copy a URL, write a sentence or two. I then regularly go back and flesh out these ideas and add to them. It's similar to the recommendations I make for blogging: make notes, expand those later.

The job part of this was making time to write on a regular basis. I used to try and write every day. I had some success, but I also learned some days I struggle to articulate my thoughts. Rather than struggle, I learned to just abandon the effort and go do other work, or sometimes, go to the gym or get away.

The flip side of that is that when I feel the writing is flowing, I write more. I don't stop after one editorial (or blog) and I'll try to tackle another one or two. If I struggle with one topic, I may find another easier, so I flip through notes and keep trying to get another one when I am in the mood to write. I sometimes find I can write 3 or 4 in a day and then not do much writing for another few days.

Many of you reading this do technical work. You work on systems, or in code, or both. However, the world is changing. I started this piece with the 25th anniversary of SQL Server Central in mind, but really, AI is front of mind. I've had 3 conversations today about AI stuff, and the one thing that stands out is communication and clearly expressing yourself if crucial to getting AI to work well for you.

Learn to write better. It helps in your communications with humans and with AI LLMs.

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

Supervised versus Unsupervised Training of an Artificial Neural Network

Stan Kulp-439977 from SQLServerCentral

Supervised training of an artificial neural network entails training the network to associate defined patterns with specified labels. Optical Character Recognition is an example of supervised training, where each input pattern is mapped to an alphanumeric character. In unsupervised training, a neural network learns to extract recurring patterns from noisy data. One of the earliest […]

External Article

How to Help Copilot Encourage Good Database Standards

Additional Articles from Brent Ozar Blog

I know a lot of y’all lag behind on upgrading SSMS, but v22.3 just introduced something that you need to be aware of. It’s going to impact any of your users who DO upgrade their SSMS, or who use Github Copilot. There’s something that you can do in order to improve Copilot’s code quality and make it match your preferred coding standards.

Blog Post

From the SQL Server Central Blogs - What is ALM in Fabric?

HamishWatson from The Hybrid DBA's Blog

As someone who’s worked with data for over 20 years and with many cloud platforms, my main focus has always been on helping teams streamline their development process. A...

Blog Post

From the SQL Server Central Blogs - Advice I Like: In 100 Years

Steve Jones - SSC Editor from The Voice of the DBA

In 100 years a lot of what we take to be true now will be proved to be wrong, maybe even embarrassingly wrong. A good question to ask yourself...

Technical Article

Databricks Data Intelligence Platform: Unlocking the GenAI Revolution

Site Owners from SQLServerCentral

This book is your comprehensive guide to building robust Generative AI solutions using the Databricks Data Intelligence Platform. Databricks is the fastest-growing data platform offering unified analytics and AI capabilities within a single governance framework, enabling organizations to streamline their data processing workflows, from ingestion to visualization. Additionally, Databricks provides features to train a high-quality large language model (LLM), whether you are looking for Retrieval-Augmented Generation (RAG) or fine-tuning.

 

 Question of the Day

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

 

String Similarity II

What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?

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)

Fun with JSON I

I have some data in a table:

CREATE TABLE #test_data
(
    id INT PRIMARY KEY,
    name VARCHAR(100),
    birth_date DATE
);

-- Step 2: Insert rows  
INSERT INTO #test_data
VALUES
(1, 'Olivia', '2025-01-05'),
(2, 'Emma', '2025-03-02'),
(3, 'Liam', '2025-11-15'),
(4, 'Noah', '2025-12-22');

If I run this query, how many rows are returned?

SELECT *
FROM OPENJSON(
     (
         SELECT t.* FROM #test_data AS t FOR JSON PATH
     )
             ) t;

Answer: 4

Explanation: This returns 4 rows. The inner query using FOR JSON PATH) returns a single row with all data. The OPENJSON splits this by the different JSON documents into 4 rows. Ref: OPENJSON - https://learn.microsoft.com/en-us/sql/t-sql/functions/openjson-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
Can an Azure App Service Managed Identity be used for SQL Login? - I'm fairly certain I know the answer to this from digging into it yesterday, but would like a second opinion. We're (finally) moving some applications to cloud-native, using Azure App Services and the developer would like to, if possible, use a Managed Identity and Key Vault for the application to connect to the SQL Server […]
Ola Hallengren Index Optimize Maintenance can we have data compression = page - I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we have data_compression = page ? I have checked online and see @DataCompression = 'Page' --please add this line for IndexOptimize script . Not sure if it is true or not so checking with the experts.
SQL Server 2019 - Development
how to write this query? - hi everyone I am not sure how to write the query that will produce the expected results.  Basically, I need to convert data found in columns and put them into rows.  I have provided sample data and screenshot of expected result.  Can someone please help me with this? Thank you Sample Data drop table if […]
how do i map the "current" object entry in for each to one variable - hi, in an ssis  for each loop over an object variable called MyListVariable, i am trying to map the current list entry to a single variable called FileName. The evidence suggest i'm not doing this right as FileName isnt changing inside the loop.  I set the name property in the flat file connector of a […]
SQL Azure - Administration
Azure Synapse database refresh - Hi Team, I am trying to refresh the Azure Synapse Dedicated pool from production to lower environment. Is there a standard documented process which we can follow similar to Azure SQL database. I have searched in various forums but none of them were worked in our environment due to policy restrictions. Please do the needful. […]
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE - Hello, Is there a way in Azure SQL Database to change the 'Blocking Process Threshold' like you can do in SQL Managed Instance? I tried but couldn't find anything that works.  sp_configure is not supported.  It seems to have a default of 20 or 30 seconds before logging a 'block'.  Wanted to change it to […]
Editorials
Rollback vs. Roll Forward - Comments posted to this topic are about the item Rollback vs. Roll Forward
Having a Little Fun at SQL Server Central - Comments posted to this topic are about the item Having a Little Fun at SQL Server Central
Article Discussions by Author
Foreign Keys - Foes or Friend? - Comments posted to this topic are about the item Foreign Keys - Foes or Friend?
Fun with JSON I - Comments posted to this topic are about the item Fun with JSON I
A Quick Restore - Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server) - Comments posted to this topic are about the item Guarding Against SQL Injection at the Database Layer (SQL Server)
Designing SQL Server Pipelines That Are Ready for AI Before You Actually Need AI - Comments posted to this topic are about the item Designing SQL Server Pipelines That Are Ready for AI Before You Actually Need AI
String Similarity I - Comments posted to this topic are about the item String Similarity I
SQL Server 2022 - Development
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset) - SQL Server is typically viewed as a transactional or analytical database engine. However, it is also a deterministic numerical computation environment capable of handling large-scale scientific data. This article demonstrates how Microsoft SQL Server can: Store astronomical datasets Compute derived physical quantities Reconstruct velocity from an algebraic invariant Compare simulation results against real observational data […]
 

 

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

 

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