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 56    Older >>
 

Introduction to Testing Your PowerShell Code with Pester

Everyone knows how important code testing is, and to be thorough, you must automate testing. This includes scripts such as those written in PowerShell as well. In this article, Robert Cain introduces Pester, a tool for testing PowerShell code.  Read more...
By Additional Articles 2018/09/06 | Source: SimpleTalk | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 2,298 reads

Go Unit Tests: Tips from the Trenches

In this article, Michael Sorens describes unit testing for applications written in Go. While focused on Go, many of his recommendations and techniques can be applied to other languages as well.  Read more...
By Additional Articles 2018/08/13 | Source: SimpleTalk | Category: go
Rating: (not yet rated)  Rate this |   Briefcase | 2,524 reads

Effective Database Testing with SQL Test and SQL Cover

A well-established technique for improving application code quality, during software development, is to run unit tests, in conjunction with a code coverage tool. The aim is not only to test that your software components behave as you would expect, but also that your suite of tests gives your code a thorough workout.  Read more...
By 2018/04/17 | Source: Redgate | Category: testing
Rating: (not yet rated)  Rate this |   Briefcase | 2,671 reads

Software Testing Skills Must Shift with AI

Artificial intelligence (AI) is touching many parts of our lives and careers. Rama Anem discusses the impact of AI on software testing and how testers’ skills must adapt.  Read more...
By Additional Articles 2018/04/11 | Source: SimpleTalk | Category: artificial intelligence (ai)
Rating: (not yet rated)  Rate this |   Briefcase | 2,877 reads

Extending DevOps to the database with Redgate: the role of automated testing

This webinar will show you how to use Redgate's SQL Test to include automated testing as part of a database DevOps workflow. There will be a walk-through of an automated build and deployment process with DLM Automation in VSTS, and plenty of time to ask questions.  Read more...
By 2018/03/15 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 9,510 reads

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 | 77 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 | 4,297 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,723 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 | 3,034 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,754 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 | 965 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,422 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 | 3,156 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,431 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 | 5,001 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,356 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 | 136 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,422 reads
   Items 1 to 20 of 56    Older >>