At Stack Overflow, our environment has multiple implementations of a largely – but not 100% – identical schema. (By “schema,” I mostly mean the set of tables within a database.) I sometimes need to retrieve or update data across a large number of sites. Let’s say, pulling or removing information from the Users table, and related tables, across all of our databases.
2023-09-01
Communication can be challenging when we don't work closely with others. Steve draws a comparison with a popular children's show in the US.
2023-08-14
153 reads
At Redgate Software, we've been trialing Copilot from GitHub with our developers. I managed to get access for this experiment and have tried a few things, though I'm not sure I've found it very useful. I'll continue to work with Copilot, but for now, I just don't find Copilot AI helping me with the types […]
2023-07-31
226 reads
Reviewing Pull Requests (PR) is something that developers should take seriously, but Steve doesn't think this always happens.
2023-07-28
364 reads
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
147 reads
Steve saw a policy on code usage in software development and wondered how many companies have this.
2023-07-19
178 reads
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
302 reads
2023-05-10
193 reads
2023-05-08
196 reads
2023-05-01
146 reads
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Comments posted to this topic are about the item Squared Values
Comments posted to this topic are about the item I Don't Want To Do...
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers