Practical Database Change Management (Part 2)
The final article on Change Management examines the more technical aspects of Change Management.
2009-06-25
3,251 reads
System Development Life Cycle
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.
2009-04-08
9,551 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.
2008-08-29
3,357 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.
2008-07-01
3,321 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.
2008-07-01
2,665 reads
Templates and teamwork
SQL Server expert David Poole discusses how teams can work together and share templates in Management Studio.
2014-11-27 (first published: 2008-05-20)
10,145 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.
2008-05-08
4,526 reads
SQL Server source code analysis and management adds database security
SQL Server source code analysis and management add database security by debugging and testing SQL applications. Learn about SQL source code analysis.
2008-05-06
2,617 reads
Connection Strategy for Multiple Database Environments
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.
2008-04-28
3,880 reads
theSystem - Part II
Continuing on with his series on building a game in SQL Server, Steve Fibich expands the schema and objects in this article.
2008-04-16
3,094 reads
Blogs
First Time Speaking with a Mask at an Event
By DataOnWheels
Over the past couple of months, I have started losing my ability to talk...
A New Word: Apolytus
By Steve Jones
apolytus– n. the moment you realize you are changing as a person, finally outgrowing...
Tired of Tedious SQL Queries? AI Tools Can Automate The Boring Parts
If you've ever wrestled with complex SQL code, you know the drill. Hours spent...
Forums
Do you listen to music when you work?
Comments posted to this topic are about the item Do you listen to music...
Slow update on temp table
I have a job running each night starting at 4:30AM and usually finishing at...
Table Partitioning - remove null range
hi guys, I have a partitioned table AM_ITM_INSTNC_MSS and I want to get...
Question of the Day
Read Only Replica in SQL Server Standard
Our environment runs using SQL Server Standard. We are implementing Availability groups. Our database has been experiencing high read volumes, so I want to let the application read the Synchronized Secondary replica, as I read that HADR does this. Can we implement this?
See possible answers