Common Algorithm Concerns
Steve doesn't have a lot of concerns about AI models writing code and reusing algorithms, but others might not feel the same way.
2024-05-29
174 reads
software development
There's No Free Lunch with Open-source Software
As a member of the PostgreSQL open-source community, I have been following the recent license change by Redis Labes on March 20, 2024. Redis introduced a dual license model, specifically adding the Redis Source Available License (RSAL), which prevents other vendors from providing Redis as a service without a paid subscription from Redis Labs. The […]
2024-04-13
148 reads
The Code Freeze
Today Steve discusses code freezes, those times when you don't allow changes to be made by developers.
2024-04-10
174 reads
Database Feature Toggles
In software development the concept of feature toggles are used to selectively turn on and off features. They are, for example, used to restrict some newly introduced features to a select group to see how these features work. While this concept has been long used for user-facing application code, it is also a practice that is useful for database code.
2024-03-22
Re-platforming
Sometimes you need to completely change your software, perhaps on a new platform. Steve has a few thoughts on this drastic action.
2024-03-20
144 reads
The Art of the Code Review
Code reviews are a good way to not only improve your quality, but also raise the skill level of your staff.
2024-02-28
201 reads
Free SQL Server
There are a number of ways to run SQL Server for free (or low cost) for development. Read a bit about how to do this.
2024-02-23
2,971 reads
Un-Stable Teams
At Redgate, the teams change every year and Steve has a few reasons why this is good.
2024-02-12
164 reads
Django's ORM vs. Raw SQL: When to Use Which
When it comes to building websites, how you work with your database can make a huge difference in how well your site runs. That's especially true if you're using Django, a popular tool for making websites with Python. Django comes with something called an Object-Relational Mapping (ORM) layer, which is a fancy way of saying […]
2024-01-26
3,929 reads
Take A Vote and Accept Your Loss
Learning to make decisions and then get work done is important to Steve. Read his thoughts today on many of the decisions software teams need to make.
2024-01-24
154 reads
Blogs
AI Step 1
By Vinay Thakur
As this is an Artificial Intelligence (AI) World, things are changing. We can see that...
Beginner’s Guide: Building a Dockerized Todo App with React, Chakra UI, and Rust for Backend
In a containerized app, React and Chakra UI provide a robust and accessible user...
A New Word: Nachlophobia
By Steve Jones
nachlophobia – n. the fear that your deepest connections with people are ultimately pretty...
Forums
Call dynamic sql storedprocedure from SSIS execute sql task
hi, I have a table called Rules Create table Rules ( Id int ,...
Migrating database with many orphan users.
I am currently upgrading a very old database running SQL Server 2008 to SQL...
Active and Active Cluster
Hi Team, I am planning to apply security updates for SQL Server 2016 on...
Question of the Day
The Funny SELECTs
What is returned from this query?
SELECT
( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate >= '01/01/2011' AND soh.OrderDate < '01/01/2012') AS OrdersIn2011
, ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate >= '01/01/2012' AND soh.OrderDate < '01/01/2013') AS OrdersIn2012
, ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate >= '01/01/2013' AND soh.OrderDate < '01/01/2014') AS OrdersIn2013; See possible answers