Creative Development
An interesting approach to schema changes is a creative solution to Steve. He asks if you have other creative solutions you've seen.
2023-07-21
140 reads
software development
A Paste Policy
Steve saw a policy on code usage in software development and wondered how many companies have this.
2023-07-19
164 reads
Database APIs
Today Steve talks APIs, which are important in much of software development. He thinks we ought to treat our database schema as part of an API.
2023-05-22
281 reads
2023-05-10
175 reads
2023-05-08
188 reads
2023-05-01
135 reads
Creating Documentation
Who should create documentation for software? In many companies, it's the developers. In fact, in Redgate, often our developers are tasked with updating articles for products on our documentation site. We do have a streamlined process that has developers can submitting changes in some format (markdown? ) and an automation process that automatically updates the […]
2023-04-26
219 reads
A Case for Document Storage
Someone makes a case for using a Document DB rather than a RDBMS. Steve has a few thoughts.
2023-04-24
173 reads
Living With Broken Software
Steve has to use software that is broken, but it's OK. It actually works well enough.
2023-04-03
117 reads
How to Connect SQL Server and Create C# Objects for Data Management
Learn about how you can work with your SQL Server data from C#. A good basic tutorial for beginning C# developers.
2023-03-24
16,105 reads
Blogs
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Advice I Like: In 100 Years
By Steve Jones
In 100 years a lot of what we take to be true now will...
Forums
AllocationType as ROW_OVERFLOW_DATA
Hello, I inherited a number of tables with like 20-30 column using nvarchar(256) in...
is it true we cant debug c# scripts in ssis anymore under vs
Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...
Question of the Day
Missing the Jaro Winkler Distance
I upgraded a SQL Server 2019 instance to SQL Server 2025. I wanted to test the fuzzy string search functions. I run this code:
SELECT JARO_WINKLER_DISTANCE('tim', 'tom')
I get this error message:Msg 195, Level 15, State 10, Line 1 'JARO_WINKLER_DISTANCE' is not a recognized built-in function name.What is wrong? See possible answers