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

Invest in Yourself Stop Making Excuses

By

Bob Pusateri (B|T) tweeted a quote image that really struck a chord with me...

Every Execution Plan Is An Estimated Plan

By

I consider myself to be the most responsible for making such a huge deal...

SQLSaturday Orlando Notes – Kahoot

By

The last two years we did Family Feud as part of our end of...

Read the latest Blogs

Forums

SQL Management studio 2014 express edition

By bokswager

Guys, Can I use SSMS 2014 Express edition to connect to a lower and...

unable access sql provider in powershell without running an invoke-sqlcmd first

By Steve T

I encountered a weird issue and hope that somebody may have a fix for...

Function to pad Bigint with leading zeros or other single characters

By Shane Clarke

Comments posted to this topic are about the item Function to pad Bigint with...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers