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

Join SQLSat Memphis Virtually This Saturday

By

Looking forward to presenting at SQLSaturday Memphis virtually this weekend! Both my wife and I...

Failing SQL Agent Jobs – Part 4

By

Here we are, another Tuesday!! It is time for our Fourth and final installment...

I Want PASS to Survive

By

I want PASS to survive. I can say that unequivocally, because this organization has...

Read the latest Blogs

Forums

issue with adding another column in a table

By sameer

Hi, i have a table named as Book_master_tbl having only 10 records and as...

When one of your DBA colleagues leaves the company, what is your checklist?

By Cláudio Silva

Comments posted to this topic are about the item When one of your DBA...

Using Intel Optane/DAX/PMEM with FCI

By Luke L

I'm working to plan a new upgrade to our existing data warehouse infrastructure.  We're...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers