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)
820 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
35,950 reads
2020-02-17
166 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)
15,575 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,868 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
By DataOnWheels
Hey data friends! This one comes from my personal vault (aka backlog of drafts...
Data's the new oil, and SQL is your refinery. It's still the go-to language...
You can’t just exec DROP ROLE your_role_name; if it’s granted perms or other roles...
Comments posted to this topic are about the item Why you should avoid Implicit...
Hello, I have an SSRS report, version 2019, that has two parameters, which will...
Good evening, I have a rather peculiar issue while trying to calculate Numerator and...
In a SQL Server 2022 Enterprise Edition AG, how many replicas can be configured with synchronous commit mode?
See possible answers