Disaster Recovery: How to regain your lost sysadmin access
This article shows you the process which you require to regain your sysadmin access.
2012-02-21
19,739 reads
Articles
2012-02-21 (first published: 2010-10-06)
9,432 reads
Unit Testing Myths and Practices
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.
2012-02-21
3,133 reads
An Implementation of the FNV1a Hash Algorithm for SQL Server
Three CLR-resident functions for 16-, 32-, and 64-bit FNV1a hashing
2012-02-20
5,995 reads
2012-02-20
56 reads
TSQL Challenge 76 - Identify the sequence of accounting transactions
The challenge is to identify the sequence of accounting transactions.
2012-02-20
1,630 reads
How to Kill a Company in One Step or Save it in Three
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.
2012-02-20
4,949 reads
SQL Saturday #108 - Redmond
Come to a free day of SQL Server training on Feb 25, 2012 in Redmond, WA.
2012-02-20
1,565 reads
Use Dynamic SQL to Improve Query Performance
This article by Jonathan Roberts demonstrates how to use dynamic SQL and overcome its downsides.
2012-02-17 (first published: 2010-05-20)
32,708 reads
2012-02-16 (first published: 2010-09-29)
8,654 reads
Blogs
AI: Blog a Day – Day 6: Embeddings – How AI Understands
By Vinay Thakur
Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now...
The Book of Redgate: Mistakes
By Steve Jones
This is kind of a funny page to look at. The next page has...
ADF Pipeline Debugging Fails with BadRequest – The Sequel
A while ago I blogged about a use case where a pipeline fails during...
Forums
Dynamic Unpivot
I have a table I didn't design that has tons of repeating groups in...
Writing as an Art and a Job
Comments posted to this topic are about the item Writing as an Art and...
String Similarity II
Comments posted to this topic are about the item String Similarity II
Question of the Day
String Similarity II
What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?
See possible answers