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?
2008-04-04
1,816 reads
Longtime SQL Server expert David Poole brings us a look at Agile Development and how he's been converted. (From Feb 2008)
2009-09-18 (first published: 2008-02-14)
12,696 reads
This article presents ten business analysis guidelines, representing best practices from successful projects.
2007-12-03
3,044 reads
This article discusses prioritizing code by age, using analysis tools and automation, looking at threats from multiple angles, and the importance of education
2007-11-09
1,458 reads
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 Modifications
2007-09-18
3,422 reads
Alex and Alex continue their series of three articles on 'Unit Testing' database development work with some examples of unit testing stored procedures.
2007-08-31
4,297 reads
Scott examines strategies for dealing with constraints that business stakeholders may put on software development teams.
2007-08-29
2,486 reads
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.
2007-07-30
3,539 reads
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.
2008-05-19 (first published: 2007-07-25)
6,578 reads
This article looks at logging your database changes from a developer's perspective.
2007-04-26
4,581 reads
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
By Steve Jones
One of the features we advocates have been advocating for is a better way...
Microsoft fixed the AVX instruction issue in SQL Server 2025 CU1. The container now...
Comments posted to this topic are about the item 25 Years of SQL Server...
Comments posted to this topic are about the item The Decoded Value
Comments posted to this topic are about the item Deploying SQL Server Developer Edition...
In SQL Server 2025, what is returned from this code:
DECLARE @message VARCHAR(50) = 'Hello SQL Server 2025!'; DECLARE @encoded VARCHAR(MAX); SET @encoded = BASE64_ENCODE(CAST(@message AS VARBINARY(1000))); SELECT BASE64_DECODE(@encoded)See possible answers