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,056 reads
tSQLt
2019-08-13
2,196 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,216 reads
2017-08-17
1,839 reads
Adding PK Exceptions to SQLCop Tests
In this piece, Steve Jones shows how you can enforce a requirement of a Primary Key (PK) with a unit test, but also allow exceptions where needed.
2016-05-12
1,103 reads
Download tSQLt Today and Start Unit Testing
The latest version of tSQLt is now available with some SQL Prompt snippets to help you get started.
2015-07-30
1,729 reads
Checking Table Metadata with tSQLt
In this article on tSQLt, learn how you can use the AssertResultSetsHaveSameMetaData method from the framework to enforce your API.
2015-06-11
4,785 reads
Testing Simple Calculations and UDFs with tSQLt
This article will give you a basic look at how you can test your user defined functions with the tSQLt framework.
2015-05-18
4,733 reads
Prevent sp_ Procedures with SQLCop
Learn how you can use SQLCop to prevent your developers from writing stored procedures that are named sp_ something.
2015-01-15
5,629 reads
2016-03-11 (first published: 2015-01-08)
15,127 reads
Blogs
What Agent Jobs are Running??
By gbargsley
Do you run SQL Agent Jobs in your environment? Do you know what is...
Unboxing SQL Clone 2020 for a PoC
By Steve Jones
When I got a new machine, I had SQL Clone on my old machine,...
Daily Coping 4 Aug 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Secondary replica is down at moment
Hi Team , We have three node cluster setup where the one primary server...
SQL 2016 vs SQL 2008R2 float to numeric Difference:
Hi, we are upgrading from SQL server 2008 R2 to SQL server 2016 between...
Extended Events
I have set up an extended event to capture the queries users may be...
Ask SSC