2025-04-23
68 reads
Editorials
2025-04-21
141 reads
Upgrading Your OS
Windows 7 support is ending, but Microsoft doesn't have a good plan for home users. Steve notes that the OS upgrade treadmill ought to come to an end soon.
2025-04-18 (first published: 2019-06-13)
278 reads
Database First or Application First
Today Steve is wondering how you approach coordinating application and database changes. Share which one you deploy first.
2025-04-16
139 reads
How Much AI Code Would You Use?
Today Steve asks the question of how much of your code could be written by GenAI.
2025-04-14
105 reads
Two Events, Two Worlds: A Week in the Life of a Technologist
Last week, I had the chance to speak at two very different events, and the contrast between them really stuck with me. The first was all a traditional vendor conference- enterprise-level, built around a well-established product with over 40 years of vendor-driven development. Think polished sponsor tables, polished shoes, and more than a few suits […]
2025-04-12
49 reads
The Changing Nature of Data
The way we look at data is changing, especially when data privacy and protection is considered. Today Steve has some thoughts on address data and the implications for cities as well as databases.
2025-04-11 (first published: 2019-07-16)
421 reads
2025-04-09
169 reads
More Linux than Windows
Microsoft announced that Linux runs on more machines in Azure than Windows. Steve isn't surprised and thinks that Linux use will continue to grow.
2025-04-07 (first published: 2019-07-06)
256 reads
Using Feature Flags
Feature flags are being used in modern software development. Steve thinks these should also be a staple of database changes.
2025-04-07
168 reads
Blogs
Can I Change a Primary Key Value? #SQLNewBlogger
By Steve Jones
I heard someone say recently that you can’t change a primary key value in...
SQL Server Index Primer
By Kevin3NF
Indexes 101: What, Why, and When? “What Is an Index?” I get this question...
Secure Azure SQL Server Backups Using Managed Identities
By Arun Sirpal
I do believe most people know about the ability to backup your SQL server...
Forums
Update particular record in a table
I need to update greatherthan8 (category) record to Missing (status) if the same member...
Internationalisation
Quick one I hope in case I'm heading off in entirely the wrong direction!...
Size of DB on physical disk doesn't match Disk Usage by Table report
Hi everyone I am looking at the size of my db on disk (ie...
Question of the Day
Getting the TEXTSIZE
How can I check what value I used for TEXTSIZE? I ran this code:
SET TEXTSIZE 8096But then deleted the code and couldn't remember. Is there a way to check this? See possible answers