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,692 reads
tSQLt
2019-08-13
2,094 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,002 reads
2017-08-17
1,789 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,064 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,727 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,629 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,633 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,553 reads
2016-03-11 (first published: 2015-01-08)
14,702 reads
Blogs
Azure Storage tips
By James-Serra
As a followup to my blog post Azure Data Lake Store Gen2 is GA,...
Managing Agent Jobs on Availability Group Servers
As always, the scripts in this post can also be found on our Git...
Permissions required for row counts to show up on Object Explorer Details
I ran into a rather obscure permissions problem the other day. Since I wasn’t...
Forums
buy medical weed online
Very important Health information that might help you or some one you know,((www.legalweedonlinestore.com/)) the...
wholesale hemp buds uk
Treasure valley farm is a B2B company. Our bulk top class CBD hemp flower...
Why Getting Data Right Matters
Comments posted to this topic are about the item Why Getting Data Right Matters,...
Ask SSC