SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag Testing Rss

Search for any content tagged testing

   Items 1 to 20 of 51    Older >>
 

A Christmas Bug

A bug in American Airlines scheduling could impact travelers, but certainly will impact their bottom line.  Read more...
By Steve Jones 2017/12/04 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 72 reads

Automated Database Provisioning for Development and Testing

If your development team needs to work on anonymised copies of the current production database, and if changes are being delivered rapidly as well, that could mean a lot of time and routine DevOps work copying databases. SQL Clone was designed for tasks like this. Grant Fritchey investigates whether you save time, effort and scripting over the more traditional approach, and at what point it makes sense to use it.  Read more...
By Additional Articles 2017/10/10 | Source: SimpleTalk | Category: provisioning
Rating:  Rate this |   Briefcase | 3,519 reads

Why don’t you unit test SQL Server code?

This post will show the benefits of test-driven development and including automated SQL Server unit testing within your release pipeline. Even if you have a large code base and no existing unit tests, you can start introducing tests now to make your database code more robust to change.  Read more...
By Additional Articles 2017/09/07 | Source: Redgate | Category: unit testing
Rating: (not yet rated)  Rate this |   Briefcase | 5,265 reads

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?  Read more...
By Additional Articles 2017/07/17 | Source: Redgate | Category: testing
Rating: (not yet rated)  Rate this |   Briefcase | 2,887 reads

A DLM Approach to Database Testing

Database Lifecycle Management aims to make the development and modification of databases more predictable. Bugs are the source of more unpredictability than anything else, purely because it is so difficult to guess how long it will take to fix them. Good testing at all stages may take some time and effort, but it greatly reduces likelihood of the wildcard factor of the bug that is first detected during the deployment process; or worse, that gets into the production release.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 3,634 reads

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.  Read more...
By Steve Jones 2016/05/12 | Source: SQLServerCentral.com | Category: tsqlt
Rating: (not yet rated) |  Discuss |   Briefcase | 962 reads

Installing tSQLt

Get started testing your database code with the tSQLt framework.  Read more...
By Steve Jones 2016/03/11 (first published: 2015/01/08) | Source: SQLServerCentral.com | Category: tsqlt
Rating: |  Discuss |   Briefcase | 13,400 reads

Routine SQL DML Testing for the Unenthusiastic Tester

There are more exciting things in life than unit testing SQL Statements, checking the results, timings, and execution plans. Phil Factor demonstrates a PowerShell-based technique taking the tedium out of testing SQL DML.  Read more...
By Additional Articles 2015/11/26 | Source: SimpleTalk | Category: dml
Rating: (not yet rated)  Rate this |   Briefcase | 2,999 reads

Do You Have Scary Code?

Many organizations have code no one wants to touch. Steve Jones notes that's a bad place to be.  Read more...
By Steve Jones 2015/11/10 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 239 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.  Read more...
By Steve Jones 2015/06/11 | Source: SQLServerCentral.com | Category: tsqlt
Rating: (not yet rated) |  Discuss |   Briefcase | 4,429 reads

Documenting with Tests

The idea of using more unit tests to improve code quality has been around for some time. However Steve Jones notes today that some people use tests for documentation.  Read more...
By Steve Jones 2015/05/14 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 113 reads

SQL Cop and SQLServerCentral

Steve Jones runs the SQL Cop tests against the SQLServerCentral database and looks at the results.  Read more...
By Steve Jones 2015/03/23 | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: |  Discuss |   Briefcase | 4,989 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.   Read more...
By Steve Jones 2015/01/15 | Source: SQLServerCentral.com | Category: tsqlt
Rating: |  Discuss |   Briefcase | 5,354 reads

Testing

We know that software testing is important, but we often don't do a great job of executing. Steve Jones talk database testing today.  Read more...
By Steve Jones 2015/01/13 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 134 reads

Installing tSQLt

Get started testing your database code with the tSQLt framework.  Read more...
By Steve Jones 2016/03/11 (first published: 2015/01/08) | Source: SQLServerCentral.com | Category: tsqlt
Rating: |  Discuss |   Briefcase | 13,400 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.  Read more...
By Additional Articles 2014/11/10 | Source: SimpleTalk | Category: testing
Rating:  Rate this |   Briefcase | 5,369 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.  Read more...
By Steve Jones 2014/10/07 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 419 reads

Testing in Production

The Apple fall keynote recently didn't work as planned, and it seems as though their systems weren't tested well enough.  Read more...
By Steve Jones 2014/09/23 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 201 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  Read more...
By Additional Articles 2014/09/03 | Source: PluralSight | Category: testing
Rating:  Rate this |   Briefcase | 8,246 reads

Testing is Your Best Investment

One of the things that can make a big difference in how well your software performs is testing.  Read more...
By Steve Jones 2014/08/25 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 122 reads
   Items 1 to 20 of 51    Older >>