software development

External Article

Some "Laws" of Software Development

  • Article

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

External Article

Supporting Large Scale Team Development

  • Article

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

Blogs

SQL Server 2025 GAs Today

By

If you aren’t watching the Ignite keynotes today, then you might have missed the...

Run SQL Server 2025 and SQL Server Management Studio on macOS Tahoe

By

Short version You want to get this running as fast as possible. Do these...

The Roundup for T-SQL Tuesday #192

By

Last week I asked you to write about SQL Server 2025 and what things...

Read the latest Blogs

Forums

Best way to log Data Flow errors in SSIS 2005?

By jakestopher

Hi everyone, I’m working with some old SSIS 2005 packages, and I’m trying to...

Advanced Excel Mastery for Finance, Accounting & Payroll – 2025 Edition

By jackraines1717

Unlock the full potential of spreadsheets with our “Advanced Excel Mastery” course tailored for...

2025 Form 1099 Reporting Requirements: Essential 1099 NEC Updates

By jackraines1717

Prepare your team for the upcoming compliance shift with our “2025 Form 1099 Reporting...

Visit the forum

Question of the Day

Specifying the Collation

I am dealing with issues on my SQL Server 2022 instance related to collation. I have an instance collation of Latin1_General_CS_AS_KS_WS, but a database collation of Latin1_General_CI_AS. I want to force a few queries to run with a specified collation by using code like this:

DECLARE @c VARCHAR(20) = 'Latin1_General_CI_AS'

SELECT  p.PersonType,
        p.Title,
        p.LastName,
        c.CustomerID,
        c.AccountNumber
 FROM Person.Person AS p
 INNER JOIN Sales.Customer AS c
 ON c.PersonID = p.BusinessEntityID
 COLLATE @c
Will this solve my problem?

See possible answers