2014-09-05
1,785 reads
2014-09-05
1,785 reads
Despite all the advances in software tools, there seem to be several enduring truths about software development. By understaning these 'laws', Ziv’s law, Humphrey’s Law and Conway’s Law for example, you can remove some of the mystery of the process. Al Noel discusses these and other laws that seem to apply generally to the art of programming.
2013-06-03
6,714 reads
Continuous integration, or CI, brings developers closer to delivering error-free software flawlessly. Find out how to implement it.
2012-07-31
2,538 reads
When it comes to the subject of putting databases into source control, Troy Hunt is no shrinking violet. “Database source control is no longer negotiable”. In this article, published originally in his Blog, Troy explains how to do Continuous Integration from a database that is in a Version Control System (VCS).
2011-04-08
4,700 reads
With a large-scale development of a database application, the task of supporting a large number of development and test databases, keeping them up to date with different builds can soon become ridiculously complex and costly. Grant Fritchey demonstrates a novel solution that can reduce the storage requirements enormously, and allow individual developers to work on thir own version, using a full set of data.
2011-03-29
3,364 reads
In this next installment of the series on writing codeless applications, David Ziffer looks at the querying of data from the database.
2010-11-03
5,385 reads
Part four of this series on rapid application development looks at the CRUD routines that are needed for almost every application.
2010-10-27
7,060 reads
As we continue in this series, see how auditing tables are used to track all changes that are made to the main data tables.
2010-10-20
8,281 reads
In this article, learn why it makes sense to build a more standarized, more robust database based on rules and see how data modeling works in the RAP software.
2010-10-13
10,554 reads
A new series from David Ziffer describes a way of building applications in a more standardized fashion, and it provides a basic review of some software that can help.
2010-10-06
18,402 reads
By Ed Elliott
All Spark Connect Posts I have just finished an update for the spark connect dotnet...
By Steve Jones
One of the things I’ve been experimenting with in AI is taking things other...
By Steve Jones
I’ll be at SQL Bits tomorrow, Saturday Jun 20, 2025 for the final day...
In Azure SQL DB, i want to merge records from the staging table to...
Full error message: SSRS error: The Value for the image 'Image1' has a constant...
We are in the process of upgrading to SQL Server 2022 and would like...
I have a table, called dbo.logger, in SQL Server 2022. I decide to add two new columns to this table with this code.
ALTER TABLE dbo.logger ADD CreateDate DATETIME CONSTRAINT dfGetDate DEFAULT GETDATE() GO ALTER TABLE dbo.logger ADD ModifyDate DATETIME DEFAULT dfGetDate GOWhat happens when I run these two batches? See possible answers