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,235 reads
tSQLt
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,737 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
5,198 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
5,197 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,150 reads
2016-03-19 (first published: 2015-01-08)
17,574 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
Blogs
How to Change the Browser Used by SSMS for AAD Auth
Did you know that you can change the browser used by SQL Server Management...
Typing with Your Tongue Part 2: Voice Access
By DataOnWheels
A few months ago, I wrote a post on how I use voice technology...
Tales From The Field Weekly Wrap Up for the Week of 03-20-2023 & Kiddos Growing Up
By SQLBalls
William, right, 11 years ago the morning of our college tour Hello Dear Reader! When...
Forums
Pentobarbital zu verkaufen - nembutalkaufen.com
Wir sind der beste legitime Anbieter von Natrium-Nembutal-Lösung (injizierbar), Nembutal-Pulver, Nembutal-Lösung zum Einnehmen (steril),...
Being Responsible for Data
Comments posted to this topic are about the item Being Responsible for Data
Contained Availability Groups
Comments posted to this topic are about the item Contained Availability Groups
Ask SSC