TSQL Tuesday #62: Invitation to Healthy SQL – Why Page Verify?
I don’t think anyone’s ever been happy to get a support call at 11pm on a Saturday night. However this...
2015-01-15 (first published: 2015-01-13)
6,303 reads
Kenneth Fisher
Discussing Security with Boris Hristov on SQLHangout #29
Over the years I’ve done a number of posts on various aspects of security. In fact the first thing I...
2015-01-12
529 reads
SQL Judo’s Monthly Challenge – January 2014 – Restore the Master
Every month SQL Judo (Russ Thomas) (b/t) challenges us to do his Monthly DBA Challenge. I’ve decided it would be...
2015-01-08 (first published: 2015-01-05)
6,255 reads
Finding the reason for the error “Subquery returned more than 1 value”
First this type of error is because a subquery returned more than one row when it wasn’t allowed to. In...
2015-01-07
1,280 reads
Finding a common AD group for a set of users.
I work for a large organization that over the last few years has been doing a LOT of reorgs. And...
2014-12-31 (first published: 2014-12-29)
5,871 reads
2014 in review
The WordPress.com stats helper monkeys prepared a 2014 annual report for this blog.
Here’s an excerpt:
The Louvre Museum has 8.5 million...
2014-12-30
923 reads
Do you want to build an Audit?
So I’ve written my second article for SQL Shack. This time instead of an overview of auditing options in sql...
2014-12-29
1,210 reads
‘Twas 4:45 Friday
‘Twas 4:45 Friday, and all through the office
not a creature was stirring, not even the bosses.
The code was checked in,...
2014-12-25 (first published: 2014-12-16)
5,355 reads
Playing with the log – VLF order while growing the log
The log file is one of those parts of SQL Server I find fascinating. For instance it is composed of...
2014-12-23 (first published: 2014-12-17)
5,838 reads
Does a clustered index sort the rows within a page
This is just something I was curious about. I ran my tests and got an answer and now I thought...
2014-12-15
1,364 reads
Blogs
AI: Blog a Day – Day 5: Notebooks, Hugging face models and Fine Tuning
By Vinay Thakur
Continuing from Day 4 where we learned Encoder, Decoder, and Attention Mechanism, today we...
AI: Blog a Day – Day 4: Transformers – Encoder, Decoder, and Attention
By Vinay Thakur
Continuing from Day 3 where we covered LLM models open/closed and their parameters, Today...
Flyway Tips: Multiple Projects
By Steve Jones
One of the nice things about Flyway Desktop is that it helps you manage...
Forums
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
Supervised versus Unsupervised Training of an Artificial Neural Network
Comments posted to this topic are about the item Supervised versus Unsupervised Training of...
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