Automated Database Testing with Redgate SQLCop

SQLCop offers 100+ open-source tests to enhance database security and standardisation.

See my latest blog post on how to install, run and apply SQLCop to your SQL Server setup.

www.leebrownhill.com/posts/8_redg...

#SQLServer #Redgate #SQLCop #tSQLt

The only slightly justifiable use for this I've seen is in tsqlt. But you could accomplish the same with table variables.

All the more tSQLt goodness here

Try it out and let the wonderful folk know how it is going https://twitter.com/sqlity/status/1318897532743962624

Just discovered @SQLStad's tSQLt test generator https://github.com/sanderstad/PStSQLtTestGenerator. It builds basic unit tests from database metadata - really useful for "catching up" when you're adding unit testing to an existing database for the first time.

Probably should have mentioned
username sa PW http://dbatools.IO
https://cloud.docker.com/u/sqldbawithabeard/repository/docker/sqldbawithabeard/tsqlt

Want to play with tSQLt?
Be good if it was all set up in a linux container?

docker pull sqldbawithabeard/tsqlt

SQL2017 Linux container with the examples as well

Learning how to write unit tests for SQL using tSQLt. Very interesting how this works.

Yeah… nothing like the fresh smell of tSqlT tests in the morning :) Happy Friday!

Current status: Writing tSQLt tests for legacy stored procs
So. much. this:

Rocked out some #tsqlt tests today :D