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
9,701 reads
Unit Testing
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,009 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)
9,578 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,069 reads
Data Sample Scripter
Generates code for INSERTs as well as generating data form tables for INSERT. Will also find and script all dependencies recursively, present all scripts in dependency order, and generate a reverse-dependency order set of conditional DELETE statements.
2016-06-13 (first published: 2015-06-04)
2,099 reads
Blogs
SSAS Tabular – Process Add memory consumption
For me it’s a bit surprising how little information can be found regarding the...
Our SQL Server 2019 Administration Inside Out Fun Author Survey
By Will Assaf
SQL Server 2019 Administration Inside Out Honored again to be leading the talented SQL Server...
What's New in SQL 2019? at the Data Architecture Virtual User Group and Q&A followup
By Will Assaf
Thanks to all 180+ of you who joined the Data Architecture Virtual User Group...
Forums
Grant a user access to job history
Hello. I would like to give a user the right to see the history...
Concat XML field values ?
Hi I have the XML field below I need to concatenate the "Purpose of...
convert string + add '.'
Hello Please help me (how to modify a character string in sql server 2017)...
Ask SSC