We all understand the value of Unit Testing, but how come so few organisations maintain unit tests for their in-house applications? We can no longer pretend that unit testing is a universal panacea for ensuring less-buggy applications. Instead, we should be prepared to actively justify the use of unit tests, and be more savvy about where in the development cycle the unit test resources should be most effectively used.
Three CLR-resident functions for 16-, 32-, and 64-bit FNV1a hashing
In SQL Server, we treat XML with a reverence that is disproportionate to its importance. The SQL Server team have indeed gone big on XML, as Michael Cole’s book reveals. The industry has gone big in another direction: JSON.
The challenge is to identify the sequence of accounting transactions.
The majority of companies that suffer a major data loss subsequently go out of business. Wesley David remembers vividly the day when the organisation he worked for found that they couldn't restore their data, and the subsequent struggles that ensued. Shoulda-woulda-coulda.
Come to a free day of SQL Server training on Feb 25, 2012 in Redmond, WA.
Options and impacts when creating, altering and dropping an index
This Friday Steve Jones asks whether you think the salespeople or the technical people are more important to the success of a company. And if they should be better compensated.
This article by Jonathan Roberts demonstrates how to use dynamic SQL and overcome its downsides.
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Efficient query performance in Amazon Redshift often comes down to how well you manage...
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Recently, our dev teams approach me for advice on improving their huge heap table...
After upgrading 2 Merge Replicated databases to SQL 2022 and re-establishing the Merge Replication...
Comments posted to this topic are about the item Why Your Index Isn't Being...
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers