External Article

Model Based Testing at Red Gate

  • Article

Phil Scrace, a test engineer at Red Gate, talks about adopting Model Based Testing (MBT), a technique that combines graph theory and code writing to help keep pace with frequently changing functionality.


2,374 reads

External Article

Generating Data for Database Tests

  • Article

It is more and more essential for developers to work on development databases that have realistic data in both type and quantity, but without using real data. It isn't exactly easy, even with third-party tools to hand. Phil Factor shows how it can be done, taking the classic PUBS database and giving it a more realistic set of data.


4,244 reads

External Article

SQL Server Unit Testing with tSQLt

  • Article

When one considers the amount of time and effort that Unit Testing consumes for the Database Developer, is surprising how few good SQL Server Test frameworks are around. tSQLt , which is open source and free to use, is one of the frameworks that provide a simple way to populate a table with test data as part of the unit test, and check the results with what should be expected. Sebastian Meine and Dennis Lloyd, who created tSQLt, explain


3,084 reads


Rotating a Certificate Used by TDE


In terms of encryption, Key Rotation is the process of replacing your encryption keys...

Daily Coping 3 Feb 2023


Today’s coping tip is to ask other people about things they’ve enjoyed recently I...

Daily Coping 2 Feb 2023


Today’s coping tip is to challenge negative thoughts and look for the upside. I’m...

Read the latest Blogs


Ownership chaining

By Duncan Lawrence

Hi, I have four views on one database to which one sql authenticated user...

Schedule Jobs on a Clustered SQL Server

By Prasad Chava

Comments posted to this topic are about the item Schedule Jobs on a Clustered...

Encrypting the Database Encryption Key

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Encrypting the Database Encryption Key

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers