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)
1,156 reads
Step-by-step guide to solve the "INSERT EXEC cannot be nested" problem by using a CLR when unit testing stored procedures using the tSQLt framework.
2022-08-19
40,425 reads
2020-02-17
209 reads
In this short article, see how a unit test can be easily written in tsqlt, and how this can help us refactor or build better code.
2022-05-30 (first published: 2019-09-24)
16,184 reads
I am happy to announce the Redgate Software and I are supporting and taking over stewardship of the SQL Cop project at this point. With permission from its founder, George Mastros, we will host the main repository for the project at https://www.github.com/red-gate/sqlcop. This should be considered the official repository for the code from this point […]
2019-08-13
3,976 reads
As database changes are added to the DevOps pipeline, unit testing of those changes becomes crucial. In this article, Adam Hafner describes unit testing and how it applies to databases.
2019-05-31
There is a constant pressure in software delivery to release at speed and often. However, there is no sense in delivering fast if what you deliver contains errors or is of no value to the customer. Our latest blog explains how database unit testing can set your team up for valued software delivery.
2019-05-31
There is a constant pressure in software delivery to release at speed and often. However, there is no sense in delivering fast if what you deliver contains errors or is of no value to the customer. Our latest blog explains how database unit testing can set your team up for valued software delivery.
2019-05-21
Learn how to implement an advanced and cost-effective database unit-testing framework with tSQLt in SQL Server Management Studio.
2017-11-30
4,320 reads
This post will show the benefits of test-driven development and including automated SQL Server unit testing within your release pipeline. Even if you have a large code base and no existing unit tests, you can start introducing tests now to make your database code more robust to change.
2017-09-07
5,842 reads
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
You can find the slides and SQL scripts for my session “Spice up your...
Wa:083849450961 Jl. RC. Veteran. 9, dan No.9A, RT.9/RW.3, Bintaro, Kec. Pesanggrahan, Kota Jakarta Selatan,...
Wa:083849450961 Jl. Mangga Raya No.20, RT.4/RW.3, Duri Kepa, Kec. Kb. Jeruk, Kota Jakarta Barat,...
Comments posted to this topic are about the item Training the next generation
Which of the following meta commands (sometimes called backslash or slash commands) within psql will provide you with information about the databases on the cluster?
See possible answers