Click here to monitor SSC
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 46    Older >>
 

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 | 949 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,322 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,651 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 | 237 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,419 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,969 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,344 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,322 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,234 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 | 417 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,106 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

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.   Read more...
By Additional Articles 2014/06/18 | Source: Just Azure | Category: testing
Rating: (not yet rated)  Rate this |   Briefcase | 2,014 reads

Is Unit Testing Important?

Testing our applications is important, but at what level do we need to test? Steve Jones talks about unit testing today, and wonders if this is prevalent for SQL Server developers.  Read more...
By Steve Jones 2014/03/24 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 375 reads

Model Based Testing at Red Gate

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.  Read more...
By Additional Articles 2013/12/13 | Source: SimpleTalk | Category: agile
Rating: (not yet rated)  Rate this |   Briefcase | 2,027 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.  Read more...
By Additional Articles 2013/05/16 | Source: SimpleTalk | Category: tsqlt
Rating: (not yet rated)  Rate this |   Briefcase | 5,043 reads

Generating Data for Database Tests

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.  Read more...
By Additional Articles 2012/04/11 | Source: SimpleTalk | Category: data
Rating: (not yet rated)  Rate this |   Briefcase | 3,978 reads
   Items 1 to 20 of 46    Older >>