SQL Server expert David Poole discusses how teams can work together and share templates in Management Studio.  Read more...

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...

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...

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...

Longtime SQL Server expert David Poole brings us a look at Agile Development and how he's been converted. (From Feb 2008)  Read more...

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...

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...

The final article on Change Management examines the more technical aspects of Change Management.   Read more...

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...

This article talks about an easy way to add hundreds of unit tests in your solution using SQL Load Test from Codeplex.  Read more...

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...

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...

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...

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...

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...

SQL Server expert David Poole discusses how teams can work together and share templates in Management Studio.  Read more...

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...

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...

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...

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...