This week there was a headline that said "Open Source Software Powers 96% of Modern Applications, New Study Finds" and if you stopped reading there, you might think, hey, it's not in the apps I work on. Or you might think that because you use OSS software, most of the world also does. Microsoft, Oracle, […]
2024-12-07
82 reads
When and where should you test code? Steve has a few thoughts when we consider the database as a crucial part of our software.
2024-06-26
160 reads
With Flyway, you can adopt a test-driven development strategy that will allow you to test and evaluate databases, and database objects, at every phase of the database development lifecycle. The further down the delivery pipeline that bugs appear, the more costly in time and resources they are to fix. This approach will allow you to catch many of them before the database change even gets committed to version control, making a continuous delivery process much easier to adopt and sustain.
2024-02-12
A software bug causes a lot of legal issues in the UK. It's something that upsets Steve, partially because the software wasn't well tested.
2024-02-05
209 reads
Most applications have large and complex databases at the back end, making it hard for developers to adequately test their work before it goes out. Having a fast, repeatable process to deliver data on demand is an essential part of an effective software development lifecycle, ultimately leading to improved customer satisfaction. In this article, we’ll explore the journey our own engineering team went on to leverage our own tool, Redgate Clone, to spin up short-lived database instances in containers for automated testing.
2023-10-25
In this article, we are going to learn the basics of SQL unit testing and how to write a SQL unit test through the tSQLt framework.
2024-01-09 (first published: 2023-09-08)
Automated testing is a way to ensure you can repeatedly examine your code as you make changes by running a series of tests. Since these are automated, you have the ability to execute all tests with one programmatic call rather than hoping a developer runs all tests. This also allows the effort of writing tests […]
2023-10-15 (first published: 2023-02-22)
899 reads
Can you catch minor code changes that might cause issues? Steve advocates for more testing to ensure you can.
2020-12-03
105 reads
2020-05-07
103 reads
There is constant pressure in software delivery to release at speed and often. To take an idea or fix and deliver it into the hands of customers in as...
2019-05-20
By Brian Kelley
I will be back in Seattle this year attending the 2025 PASS Data Community...
By Steve Jones
Another of our values is this: Motivation isn’t about carrots and sticks. Constant oversight...
By Steve Jones
Today is my last day of work for six weeks. I start my sabbatical...
Comments posted to this topic are about the item Three Times a Day
Given a record mapping table: Id Initial Updated 1 1 2 2 3 4...
Hi i recently exported a number of "to be purged resultsets " to .tsv's. ...
In my SQL Server 2022 database, I run this code:
ALTER TABLE dbo.OrderHeader ADD ModifiedStamp DATETIME CONSTRAINT df_Created_Getdate DEFAULT GETDATE() GOI decide I need to add auditing to another table and run this:
ALTER TABLE dbo.Tracker ADD Created DATETIME CONSTRAINT df_Created_Getdate DEFAULT GETDATE() GOWhat happens with these statements? See possible answers