Unit Testing

Redgate Takes over the SQLCop Project

  • Article

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 […]

5 (1)

2019-08-13

2,563 reads

Set your team up for valued software delivery with Unit Testing

  • DatabaseWeekly

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

Why don’t you unit test SQL Server code?

  • Article

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

Data Sample Scripter

  • Script

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: )

2,080 reads

Blogs

A simple Machine Learning process example (supervised) – just to start with

By

I have just written the fifth article of the Machine Learning topic. !!! This...

Always On: Troubleshooting Consolidated

By

Working on Always On and configuration/setup of AG we have observed many errors. especially...

Changing Git Credentials in Windows

By

tl;dr For Windows when you need a different account. I had to work with...

Read the latest Blogs

Forums

SQL Server Version - Columnstore - Segment elimination

By etl2016

Hi From docs of MS, its not very evident, which SQL version (onwards) has...

How to set alert when AlwaysOn High Availabilty database stop synchronizing

By santosh.mane

Hi, We are having our production database on AlwaysOn High Availability, it sometime stopped...

SSRS page number by a certain column grouping

By Siten0308

Hello, I have been givin a task and not sure how to handle this,...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers