2020-02-17
144 reads
Unit Testing
Using tsqlt Tests to Practice Queries
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.
2019-09-24
10,023 reads
Redgate Takes over the SQLCop Project
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,187 reads
Unit Testing, Databases, and You
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
Set your team up for valued software delivery with Unit Testing
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
Set your team up for valued software delivery with Unit Testing
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
Free Database Unit-Testing Framework for SQL Server
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
Why don’t you unit test SQL Server code?
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
SQL Server Unit Testing in Visual Studio
Unit test stored procedures in Visual Studio using an existing database or new SQL scripts
2020-01-03 (first published: 2017-05-01)
11,796 reads
Is It Worth Writing Unit Tests?
What's the overhead for writing unit tests? Ed Elliot breaks it down, looking at the ways in which unit tests both take more time and save time.
2015-07-23
7,172 reads
Blogs
Getting the Proc Code–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Running SQL Server in Google Cloud Platform
By Daniel Janik
On a few occasions I’ve referred to GCP (Google Cloud Platform) as the “Windows...
More ADLS Gen2 enhancements
By James-Serra
On the heels of More Azure Blob Storage enhancements come more enhancements for Azure...
Forums
Copy Azure SQL DB App data to Azure Synapse
Hello, I am looking for the best way to copy change data from my...
Enable normal user to execute a sys stored procedure
I tried GRANT EXECUTE ON OBJECT :: sys.sp.droprolemember TO John; GO Cannot find the...
Enable user to execute a sys stored procedure
I am struggling to enable a user to be able to execute a system...
Ask SSC