2020-02-17
145 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,312 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,397 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)
13,997 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,446 reads
Blogs
Updated Pluralsight Course – Managing the Kubernetes API Server and Pods
My updated course “Managing the Kubernetes API Server and Pods” in now available on Pluralsight here! If...
Daily Coping 11 May 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
What do you do when technology changes? : T-SQL Tuesday #138
Our host for this month’s TSQL Tuesday is Andy Leonard (blog|twitter). He’d like us...
Forums
high CPU
CPU Usage was running very high than normal. Identified the top query, so removing...
Is the a way in SSIS to add a comma to the end of each row of a csv file?
Is the a way in SSIS to add a comma to the end of...
SSRS Report Subscription Fails (Failure sending mail) due to column contents
I've had this problem rear its head before but not in some time. There's...
Ask SSC