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,972 reads
tSQLt
2019-08-13
2,156 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,147 reads
2017-08-17
1,822 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,092 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,728 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,755 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,708 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,616 reads
2016-03-11 (first published: 2015-01-08)
14,972 reads
Blogs
Creating a New Sequence–#SQLNewBlogger
By Steve Jones
I wrote about sequences in an editorial recently and decided to start using them....
An All Star Lineup for EightKB
By Steve Jones
An online conference is coming on June 17, 2020 that is full of high...
How should I store currency values in SQL Server?
On Twitter, Michael Dyrynda writes: ?? Never ever ever ever ever ever ever ever...
Forums
Filestream or Filetable or None...what to be used?
I've been assigned with a project that includes converting the columns in the existing...
How to force MS SQL to select a partition instead of making a full table scan
Hi all, I am currently designing a datamart layer in MS SQL 2016 Enterprise....
Daily 3 Coping
Today’s tip is find three good reasons to be hopeful for the future. http://voiceofthedba.com/2020/06/03/daily-coping-3-jun-2020/
Ask SSC