Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag System Development Life Cycle Rss

   Items 1 to 20 of 100    Older >>
 

Templates and teamwork

SQL Server expert David Poole discusses how teams can work together and share templates in Management Studio.  Read more...
By David Poole 2013/01/31 (first published: 2008/05/20) | Source: SQLServerCentral.com | Category: system development life cycle
Rating: |  Discuss |   Briefcase | 8,113 reads

An Example of Test-Driven Development, Part 5

The fifth installment of this fantastic series by MVP Andy Leonard looks at database versioning. Be sure to read this one to continue learning more about TDD.  Read more...
By Andy Leonard 2010/11/26 (first published: 2009/08/20) | Source: SQLServerCentral.com | Category: test-driven development
Rating: |  Discuss |   Briefcase | 10,154 reads

Generating Insert Statements

This article from new author Oleg Netchaev describes the cursor-less script used to generate insert statements. This allows you to efficiently and easily add data generation statements to your project deployments.  Read more...
By Oleg Netchaev 2010/05/14 (first published: 2009/07/01) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 29,590 reads

A Search and Replace Script when Moving Objects from Prod to Test

Recently Ben Kubicek created a script that would allow him to copy his production db to a test instance and correct the production specific SQL code in stored procedures and views.   Read more...
By Ben Kubicek 2010/02/03 | Source: SQLServerCentral.com | Category: search
Rating: |  Discuss |   Briefcase | 7,285 reads

Accidently Agile

Longtime SQL Server expert David Poole brings us a look at Agile Development and how he's been converted. (From Feb 2008)  Read more...
By David Poole 2009/09/18 (first published: 2008/02/14) | Source: SQLServerCentral.com | Category: system development life cycle
Rating: |  Discuss |   Briefcase | 12,645 reads

An Example of Test-Driven Development, Part 5

The fifth installment of this fantastic series by MVP Andy Leonard looks at database versioning. Be sure to read this one to continue learning more about TDD.  Read more...
By Andy Leonard 2010/11/26 (first published: 2009/08/20) | Source: SQLServerCentral.com | Category: test-driven development
Rating: |  Discuss |   Briefcase | 10,154 reads

Generating Insert Statements

This article from new author Oleg Netchaev describes the cursor-less script used to generate insert statements. This allows you to efficiently and easily add data generation statements to your project deployments.  Read more...
By Oleg Netchaev 2010/05/14 (first published: 2009/07/01) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 29,590 reads

Practical Database Change Management (Part 2)

The final article on Change Management examines the more technical aspects of Change Management.   Read more...
Rating:  Rate this |   Briefcase | 2,758 reads

Practical Database Change Management (Part 1)

Changing a database an integral and crucial part in every application's life cycle. Part 1 of this series looks at the steps and procedures prior to implementing the change  Read more...
By Additional Articles 2009/06/24 | Source: SQL Server Performance | Category: administration
Rating: (not yet rated)  Rate this |   Briefcase | 3,352 reads

SQL Unit Testing

This article talks about an easy way to add hundreds of unit tests in your solution using SQL Load Test from Codeplex.  Read more...
Rating: |  Discuss |   Briefcase | 8,811 reads

A Little DOS for a Poor DBA

Yakov Shlafman brings back the world of the command prompt to make life easier for a DBA that must deploy a series of scripts to their servers.  Read more...
By Yakov Shlafman 2008/11/06 | Source: SQLServerCentral.com | Category: scripting
Rating: |  Discuss |   Briefcase | 12,439 reads

Fast Project Rollbacks

When a project is completed, one of the next steps is to roll this project out to the production environment. However a good rollback process is important to ensure that you can remove those changes if there are problems. Longtime author David Poole talks about how he handles this.  Read more...
By David Poole 2008/10/22 | Source: SQLServerCentral.com | Category: deployment process
Rating: |  Discuss |   Briefcase | 3,903 reads

Software Tool Design: Design by Sketching

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.  Read more...
Rating:  Rate this |   Briefcase | 2,884 reads

theSystem - Part III

Continuing on with his series on building a game in SQL Server, Steve Fibich talks about some more of the tables and the data they contain.  Read more...
Rating: |  Discuss |   Briefcase | 2,651 reads

Deploying Database Developments

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.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,819 reads

Templates and teamwork

SQL Server expert David Poole discusses how teams can work together and share templates in Management Studio.  Read more...
By David Poole 2013/01/31 (first published: 2008/05/20) | Source: SQLServerCentral.com | Category: system development life cycle
Rating: |  Discuss |   Briefcase | 8,113 reads

Tracking Database Schema Changes with DbPro

Tracking changes to your development environments is important to ensure that your deployments to production go smoothly. Jacob Sebastion brings us a look at how well the Visual Studio Team System Edition for Database Professionals can help you with this task.   Read more...
Rating: |  Discuss |   Briefcase | 6,269 reads

The Lighter Side - Life is like an analogy

Longtime SQL Server author and expert David Poole takes a break from SQL Server to bring us a few life lessons for software development.  Read more...
By David Poole 2008/05/14 | Source: SQLServerCentral.com | Category: career
Rating: |  Discuss |   Briefcase | 6,672 reads

Scalability and Goal Testing for Developers

Often developers are tasked with not only developing functional code, but also with ensuring that the code they develop scales well and performs in the application environment.  Read more...
By Additional Articles 2008/05/09 | Source: DevX | Category: scalability
Rating:  Rate this |   Briefcase | 2,160 reads

Testing SQL Stored Procedures Using LINQ

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.  Read more...
Rating:  Rate this |   Briefcase | 4,295 reads
   Items 1 to 20 of 100    Older >>
 
Tags
strategies (58)    
miscellaneous (6)    
t-sql (6)    
sql server 7 (5)    
administration (4)    
programming (4)    
advanced querying (3)    
database design (3)    
naming standards (3)    
testing (3)    
.net (2)    
availability (2)    
installation (2)    
visual basic 6 (2)    
basics (1)    
best and worst practices (1)    
best practices (1)    
career (1)    
deployment process (1)    
dts (1)    
error handling (1)    
insert (1)    
kpis (1)    
linq (1)    
management studio (ssms) (1)    
scalability (1)    
scripting (1)    
search (1)    
secure programming (1)    
security (1)    
sql server 2005 (1)    
sqlcmd (1)    
stored procedures (1)    
test-driven development (1)    
video (1)    
vsts (1)    
xml (1)