System Development Life Cycle

SQLServerCentral Article

Putting Unit Tests to Work

  • Article

Testing is an important part of any software development process, but it's a part that many of us skimp on or ignore because of the tedious nature of testing. Longtime author Grant Fritchey has been working with Visual Studio Team Edition for Database Professionals and has written us an article on how you can make your unit testing easier.

3 (1)

2008-01-16 (first published: )

7,521 reads

SQLServerCentral Article

Writing Maintainable Code

  • Article

No developer or DBA wants to be told how to write their code. Everyone has their own style, but this can cause problems in a team environment where different people need to work on the same section of code. New author Pam Abdulla brings us a few simple techniques that can help you write more maintainable code.


9,541 reads

SQLServerCentral Article

Unit Testing and Code Generation

  • Article

One of the fundamental skills a developer needs is the ability to test their code. Most people don't really do a good job, partly because they don't have a good process and leave testing until the end. Grant Fritchey brings us a new method of unit testing T-SQL stored procedures that can help you build automated tests for your code.

4 (4)


17,431 reads

External Article

SQL Server Performance Testing

  • Article

This (new) design bothered me. It violated one of the fundamentals that I'd learned and read about for years; namely keeping the primary key small and narrow. It also looked like it would be difficult to maintain. Finally, after arguing back and forth about the merits and drawbacks of each of the designs, we decided that testing them was the only way to be sure


4,359 reads


Daily Coping 29 Jun 2022


I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Daily Coping 28 Jun 2022


I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Creating a Database Audit Specification can create new users & schemas in the background


I love database audits. They are simple, easy to use, effective, not overly resource...

Read the latest Blogs


Data factory question

By hayunscha

Upon my adventures of Azure data factory and all the wonders it can do...

Best practice

By sqlenthu 89358

Hello friends, I am planning to setup some process for archival. The configuration part...

MySQL and Cloud SQL

By khapunkap

Hello all, I’m working on a go web app and am using the app...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers