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

Learning From Breakage

I've had the fortunate, or maybe unfortunate, experience of being thrown into a few jobs with no training. At a couple of my bartending jobs, I had to start working without any training, calling over someone to help run the ordering machine while I made and served drinks. I managed to slowly learn how things worked throughout that first shift, so I was ready to work on my own the second night. I had a similar experience at a tech job, starting as the lead DBA/IT Manager in a crisis, having to try and solve problems after ask others how things were supposed to work. I ended up fixing a bit of code, adjusting networking, and directing others on my first day.

When we have a crisis, we often learn a lot from the situation. I've been through crashed upgrades, virus breakouts, hardware failures, and more in my career. While each was stressful and often not enjoyable, I learned a lot each time and came through the incident a more capable developer/DBA/whatever. When we work through a tough time, we are often better equipped for the next time something goes wrong.

I ran across a great piece that says you never really know a system unless you've broken one. This is Tim O'Brien, a software architect who has learned a lot about databases from failure. In fact, I love his interview question for data professionals: "tell me about the worst database schema you ever created. What did it teach you to avoid?" I've certainly learned a few things over time from my schema designs, but those are stories for another piece.

The piece draws parallels to today's use of GenAI technology and vibe coders who seem to have success that they highlight in posts without discussing the problems. I do believe AI technology is going to make a lot of things easier (and faster) to build and then fix when they break. And they are going to break, partially because AI tech might not do a great job, and partially because we might not direct it well enough. Clear communication is key when working with AI.

I've started to build some skills with AI, but as I try to tackle more complex tasks or scale up my work, I realize that I often don't know enough about either the problem or AI technology, and I'm going to make mistakes. I'm going to break things and then have to fix them, or more likely, learn how to get the AI to reduce the number of broken things in some way before I have to take over.

And learning to take over might be the number one skill with AI tech, but that's something that you will only learn from the AI not working well for you in a variety of situations.

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

Python in Action to Auto-Generate an Optimized PostgreSQL Index Strategy

sabyda from SQLServerCentral

We have a script that can be used to help tune ind...

External Article

How to View SQL Server Object Code Easily with sp_showcode

Additional Articles from SimpleTalk

sp_helptext has served SQL Server DBAs for years, but it has its very obvious – and many – limitations: broken lines, missing triggers, no help with encrypted objects, to name just a few. That’s where sp_showcode comes in…

Blog Post

From the SQL Server Central Blogs - NVMe vs PVSCSI: Real-World Performance Testing for SQL Server Workloads on VMware

aen from Anthony Nocentino Blog

End-to-end NVMe vs PVSCSI testing over NVMe/TCP to a Pure Storage FlashArray: TPC-C and DiskSpd results and analysis.

Blog Post

From the SQL Server Central Blogs - An LLM Saved My ATtiny85 From Certain Death

Bert Wagner from Bert Wagner

I almost ordered parts for a circuit that would have destroyed itself the instant I powered it on.
Instead, an LLM caught the critical flaw in my design, saving me...

T-SQL Fundamentals

Site Owners from SQLServerCentral

For anyone else who needs to write queries or develop T-SQL code for SQL Server, Azure SQL Database, or Azure SQL Managed Instance

 

 Question of the Day

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

 

Adding and Dropping Columns I

I have this table in my SQL Server 2022 database:
CREATE TABLE [dbo].[CityList]
(
[CityNameID] [int] NOT NULL IDENTITY(1, 1),
[CityName] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
I decide to add two new columns for the StateProvince and Country. What code should I use?

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)

URL Safe or Not?

If I use BASE4_ENCODE() in SQL Server 2025, is the output URL Safe by default?

Answer: No

Explanation: The default for the second parameter, url_safe, is 0, so these are not safe by default. Any value other than 0 is evaluated as true and the result is URL sage. Ref: BASE64_ENCODE() - https://learn.microsoft.com/en-us/sql/t-sql/functions/base64-encode-transact-sql?view=fabric-sqldb&viewFallbackFrom=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.


Analysis Services
Connecting Power BI to SSAS and effective user not working - Hi everyone, Below is a consolidated summary of what we validated Architecture & data path The on-premises data resides in SQL Server, accessed by Power BI Service via on-premises Analysis Services (SSAS Tabular). Effective flow: Power BI Service ? Power BI Gateway ? SSAS Tabular ? SQL Server The issue is not SQL connectivity, but authentication and […]
Anything that is NOT about SQL!
Fantasy Football 2026 - The thread for the league in 2026. Players from last year have priority.
Editorials
An SSIS Upgrade - Comments posted to this topic are about the item An SSIS Upgrade
Where Your Value Separates You from Others - Comments posted to this topic are about the item Where Your Value Separates You from Others
Your AI Successes - Comments posted to this topic are about the item Your AI Successes
Article Discussions by Author
Semantic Search in SQL Server 2025 - Comments posted to this topic are about the item Semantic Search in SQL Server 2025
Encoding URLs - Comments posted to this topic are about the item Encoding URLs
Fixing the Error - Comments posted to this topic are about the item Fixing the Error
T-SQL in SQL Server 2025: Encoding Functions - Comments posted to this topic are about the item T-SQL in SQL Server 2025: Encoding Functions
Which Table I - Comments posted to this topic are about the item Which Table I
Using Python notebooks to save money in Fabric: The Fabric Modern Data Platform - Comments posted to this topic are about the item Using Python notebooks to save money in Fabric: The Fabric Modern Data Platform
SQL Server 2022 - Administration
High Availability setup - has anyone seen this method? - Hi all, I recently moved to a new employer who have their HA setup in a way I've never seen and I'd just like to get opinions on it; I'm not saying it's right or wrong, just different (but it does appear to have caused issues). The way that I'm used to is that two […]
Certificates expired - Can't restore after creating new certificate - The previous DBA created a certificate which expired 12/31/2025. I came in hoping to have an easy day for New Year's Eve and found all of the backups were failing.  After doing the research, I found the certificate had expired. 1.  I created a new certificate since I couldn't update the expiry date. 2.  I […]
SQL Server 2022 - Development
advice on diving into devops for managing BI projects - hi , i know this is a sql server forum but i think my brain is aligned more with members of this forum than any other. we have a large netsuite migration in which multiple erps are involved.   The technologies on which those erp's run vary from db2 to all flavors of sql server based […]
Simplifying WHERE Condition with LIKE test on multiple columns - Good Evening, Is there a simpler way to rearrange the following WHERE condition: [Column_1] LIKE 'Beta08%' OR [Column_1] LIKE 'Beta11%' OR [Column_1] LIKE 'Beta16%' OR [Column_1] LIKE 'Beta17%' OR [Column_1] LIKE 'Beta15%' OR [Column_1] IN ('Beta192') OR [Column_2] LIKE 'Beta08%' OR [Column_2] LIKE 'Beta11%' OR [Column_2] LIKE 'Beta16%' OR [Column_2] LIKE 'Beta17%' OR [Column_2] LIKE […]
 

 

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

 

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