http://www.sqlservercentral.com/Content tagged System Development Life Cycle posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)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.http://www.sqlservercentral.com/articles/System+Development+Life+Cycle/63352/2008/07/01http://www.sqlservercentral.com/articles/System+Development+Life+Cycle/63352/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.http://www.sqlservercentral.com/redirect/articles/63519/2008/07/01http://www.sqlservercentral.com/redirect/articles/63519/SQL Server expert David Poole discusses how teams can work together and share templates in Management Studio.http://www.sqlservercentral.com/articles/System+Development+Life+Cycle/62933/2008/05/20http://www.sqlservercentral.com/articles/System+Development+Life+Cycle/62933/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. http://www.sqlservercentral.com/articles/System+Development+Life+Cycle/3004/2008/05/19http://www.sqlservercentral.com/articles/System+Development+Life+Cycle/3004/Longtime SQL Server author and expert David Poole takes a break from SQL Server to bring us a few life lessons for software development.http://www.sqlservercentral.com/articles/Career/62932/2008/05/14http://www.sqlservercentral.com/articles/Career/62932/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.http://www.sqlservercentral.com/redirect/articles/62908/2008/05/09http://www.sqlservercentral.com/redirect/articles/62908/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.http://www.sqlservercentral.com/redirect/articles/62915/2008/05/08http://www.sqlservercentral.com/redirect/articles/62915/ SQL Server source code analysis and management add database security by debugging and testing SQL applications. Learn about SQL source code analysis.http://www.sqlservercentral.com/redirect/articles/62905/2008/05/06http://www.sqlservercentral.com/redirect/articles/62905/Greg Larsen looks at one way to design your database connection strategy to simplify changing application connections so you can plug-n-play databases with less administrative overhead when the need arises.http://www.sqlservercentral.com/redirect/articles/62900/2008/04/28http://www.sqlservercentral.com/redirect/articles/62900/Continuing on with his series on building a game in SQL Server, Steve Fibich expands the schema and objects in this article.http://www.sqlservercentral.com/articles/System+Development+Life+Cycle/62660/2008/04/16http://www.sqlservercentral.com/articles/System+Development+Life+Cycle/62660/Few would disagree that striving for a loosely coupled design is a bad thing. Unfortunately, the software we typically design is much more tightly coupled than we intend. How can you tell whether your design is tightly coupled?http://www.sqlservercentral.com/redirect/articles/62560/2008/04/04http://www.sqlservercentral.com/redirect/articles/62560/A look at how you can implement error handling in your stored procedures.http://www.sqlservercentral.com/redirect/articles/62312/2008/04/03http://www.sqlservercentral.com/redirect/articles/62312/In our organization, I have noticed that database requirements are never included as a portion of the system requirements. The requirements always focus on the interface and we derive the database design from the interface as well as fill in some of the gaps.http://www.sqlservercentral.com/redirect/articles/62573/2008/03/26http://www.sqlservercentral.com/redirect/articles/62573/Longtime SQL Server expert David Poole brings us a look at Agile Development and how he's been converted.http://www.sqlservercentral.com/articles/System+Development+Life+Cycle/62104/2008/02/14http://www.sqlservercentral.com/articles/System+Development+Life+Cycle/62104/In this video, Randy Dyess shows you how important SQL Server dependencies are and some of the faults with SQL Server 2005 with these. For example, SQL Server will allow you to create a stored procedure that points to a table that doesn't exist. He also shows you how this problem has been corrected in SQL Server 2008. http://www.sqlservercentral.com/redirect/articles/61970/2008/01/30http://www.sqlservercentral.com/redirect/articles/61970/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. http://www.sqlservercentral.com/articles/System+Development+Life+Cycle/2805/2008/01/16http://www.sqlservercentral.com/articles/System+Development+Life+Cycle/2805/This article presents ten business analysis guidelines, representing best practices from successful projects.http://www.sqlservercentral.com/redirect/articles/61487/2007/12/03http://www.sqlservercentral.com/redirect/articles/61487/In this column, I'll dig into check-in notes and policies. You'll learn how check-in notes work and how to write your own custom policy implementations.http://www.sqlservercentral.com/redirect/articles/61428/2007/11/30http://www.sqlservercentral.com/redirect/articles/61428/This handy control gives you everything you need to control how users input usernames, passwords, select servers, and choose connection types. http://www.sqlservercentral.com/redirect/articles/61418/2007/11/20http://www.sqlservercentral.com/redirect/articles/61418/This article discusses prioritizing code by age, using analysis tools and automation, looking at threats from multiple angles, and the importance of education http://www.sqlservercentral.com/redirect/articles/61425/2007/11/09http://www.sqlservercentral.com/redirect/articles/61425/SQL Server 2005 offers T-SQL language features that can improve your productivity. http://www.sqlservercentral.com/redirect/articles/61415/2007/11/07http://www.sqlservercentral.com/redirect/articles/61415/Some managers love to look solely at numbers when assessing performance, and key performance indicators (KPIs) are right up their street. But how useful are they in the context of software developmenthttp://www.sqlservercentral.com/redirect/articles/61200/2007/10/12http://www.sqlservercentral.com/redirect/articles/61200/In the latest in their popular series on 'Unit Testing' database development work , Alex K and Alex S give some examples of unit testing Database Modificationshttp://www.sqlservercentral.com/redirect/articles/3240/2007/09/18http://www.sqlservercentral.com/redirect/articles/3240/Alex and Alex continue their series of three articles on 'Unit Testing' database development work with some examples of unit testing stored procedures. http://www.sqlservercentral.com/redirect/articles/3204/2007/08/31http://www.sqlservercentral.com/redirect/articles/3204/Scott examines strategies for dealing with constraints that business stakeholders may put on software development teams. http://www.sqlservercentral.com/redirect/articles/3193/2007/08/29http://www.sqlservercentral.com/redirect/articles/3193/A thought provoking article from SQL Server expert and trainer Andy Warren. As a DBA you should think about the rules and decrees you have developed over the years and revisit them for application in your current situation. http://www.sqlservercentral.com/articles/System+Development+Life+Cycle/3119/2007/07/30http://www.sqlservercentral.com/articles/System+Development+Life+Cycle/3119/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. http://www.sqlservercentral.com/articles/System+Development+Life+Cycle/3004/2008/05/19http://www.sqlservercentral.com/articles/System+Development+Life+Cycle/3004/This article looks at logging your database changes from a developer's perspective. http://www.sqlservercentral.com/redirect/articles/2970/2007/04/26http://www.sqlservercentral.com/redirect/articles/2970/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. http://www.sqlservercentral.com/articles/System+Development+Life+Cycle/2805/2008/01/16http://www.sqlservercentral.com/articles/System+Development+Life+Cycle/2805/Learn how to keep track of previous versions of code in case your next upgrade doesn't go well from SQL Server guru Tim Chapman.http://www.sqlservercentral.com/redirect/articles/2809/2007/01/15http://www.sqlservercentral.com/redirect/articles/2809/