2020-02-17
139 reads
Testing
Testing Databases: What’s Required?
Phil Factor reviews the various types of database test that need to run during development work, what sort of test data they require, and the challenges with managing this data, and in keeping the test cell stocked with the correct database, and data, in a way that allows rapid cycles of database testing.
2019-07-18
Testing Databases: What’s Required?
Phil Factor reviews the various types of database test that need to run during development work, what sort of test data they require, and the challenges with managing this data, and in keeping the test cell stocked with the correct database, and data, in a way that allows rapid cycles of database testing.
2019-05-20
Testing Databases: What’s Required?
Phil Factor reviews the various types of database test that need to run during development work, what sort of test data they require, and the challenges with managing this data, and in keeping the test cell stocked with the correct database, and data, in a way that allows rapid cycles of database testing.
2019-05-14
Are your automated tests slowing you down?
Slow, unreliable tests prevent teams doing great work, and make continuous delivery impossible. So what can you do to improve your automated tests?
2017-07-17
3,128 reads
Acceptance Testing with FitNesse: Database Fixtures, Project Overview
There aren't many frameworks for writing acceptance tests for databases, including SQL Server. FitNesse is an obvious choice since it is designed with a Wiki-style interface that, once it is configured and set up correctly, makes it very easy for a non-specialist to set up individual tests.
2014-11-10
5,527 reads
Not unit testing your databases? You should be
Releasing a product without testing it is generally accepted as an unforgivable sin in the software development world. And frankly, there really isn’t an excuse not to test when we have whole suites of testing tools available to us
2014-09-03
8,387 reads
Automated testing in Microsoft Azure
Matthew Flatt was trying to measure the performance of a tool interacting with Microsoft Azure, and had trouble getting a consistent test. His solution? Run the tests on VMs in Azure, housed in the same data center as the blob storage.
2014-06-18
2,717 reads
SQL Server Unit Testing with tSQLt
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
2011-01-19
3,084 reads
William Durkin, Serial Red Gate Beta Tester
In this article sponsored by Red Gate, read about a beta tester's experience with new versions of SQL tools.
2009-07-16
1,595 reads
Blogs
T-SQL Tuesday #125 – Unit testing databases – we need to do this!!
By HamishWatson
Welcome to the first April edition of T-SQL Tuesday. I’m honoured to be hosting...
T-SQL Tuesday Live–7 Apr 2020
By Steve Jones
Last week went a little crazy, and I learned something: don’t post a Zoom...
Getting Your dbatools Version–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Forums
How not to have sql to restart on the same node but failover on 1st failure in a
Hi, By default sql tries to restart on the same node in case of...
Do I need to update statistics after compressing table?
I page-compressed a table with one Clustered and 4 non-clustered indexes, 5 million rows....
Iterating Over Calculated Tables using Power Query
Comments posted to this topic are about the item Iterating Over Calculated Tables using...
Ask SSC