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
5,070 reads
tSQLt
2019-03-01 (first published: 2015-03-26)
10,039 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
6,021 reads
2016-03-19 (first published: 2015-01-08)
16,915 reads
A T-SQL Code Testing Guide
Testing our database code is a fairly immature process for many of this, but perhaps we could build a guide that helps everyone learn to write better and more comprehensive tests.
2018-11-23 (first published: 2014-10-07)
499 reads
Getting Started Testing Databases with tSQLt
There are several frameworks for assisting with the testing of SQL Server databases, but tSQLt is popular because it is written in TSQL and is simple for a database developer to set up and use. It doesn't get in the way. Rob Sheldon shows you how to get started.
2013-05-16
5,333 reads
Ten Things I Wish I’d Known When I Started Using tSQLt and SQL Test
The open-source Unit Test framework tSQLt is a great way of writing unit tests in the same language as the one being tested. In retrospect, after using tSQLt for a while, what are the 'gotchas'; those things that you'd have been better off knowing about before you get started? David Green lists a few tips he wished he'd read beforehand.
2012-09-13
4,444 reads
RE: Top N across groupings
What if there's a tie for revenue ?If there's a tie, the sub-query will return you top 2 rows, but if you join that based solely on Revenue, you can & will get more than 2 rows per state in the resultset.
2005-03-01
RE: Partitioning Tables
Hi,Partitioning view is really a good option. but while implementing in our scenario we are facing some problems such as we cannot create index on the partitioned views as it gives some error saying that "underlying tables have some constraints" and even we had the triggers on the table which we have decided to split […]
2005-02-14
2004-12-23
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers