System Development Life Cycle

Software Tool Design: Design by Sketching

  • Article

Developers can get so used to relying on computers for everything that they can forget how useful it can be in the design process to elicit and refine ideas whilst working in groups, using a sketchbook, pencils and crayons. Sometimes we all need a jolt to force us to take a different approach to solving software design problems.

4.5 (2)

2008-08-29

3,357 reads

Deploying Database Developments

  • Article

When a team is developing a database application, it is a mistake to believe that deployment is a simple task. It isn’t. It has to be planned, and scripted. Alexander Karmanov describes many of the problems you’re likely to meet, and provides an example solution that aims to save the DBA from the nightmare complexity of an unplanned deployment.

2008-07-01

3,321 reads

Testing SQL Stored Procedures Using LINQ

  • Article

The need to test a program that accesses and manipulates a back-end SQL Server® database is very common. In many such cases, the application interacts with the back-end data through the use of SQL stored procedures. In this type of scenario, you can think of the stored procedures as auxiliary methods of the system under test; and they must therefore be tested just like any other module in the system.

2008-05-08

4,526 reads

Blogs

Daily Coping 10 Jul 2020

By

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

Daily Coping 9 Jul 2020

By

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

Refreshing a Power BI Dataset in Azure Data Factory

By

I recently needed to ensure that a Power BI imported dataset would be refreshed...

Read the latest Blogs

Forums

temp table performance in sql 2016

By rohitkocharda

HI everyone, I just restored a DB on sql2016 from sql2012. One of my...

Nearest Proximity For every record

By marty.seed

Hello! We have a query we are trying to build with a key component....

Isnull in a Where Clause

By luismarinaray

Dear friends, We used Stored Procedure on our Queries for us to get  valuee...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers