Cannot Failover Nodes Using TempDB on Local Storage
I ran into an interesting issue while installing SQL 2012 SP1 in a failover cluster configuration and utilizing the local...
2014-05-08
849 reads
Blog Posts
Find SQL Database Owner with T-SQL
One thing that on occasion bugs me about PDW or APS or whatever it happens to be called this week...
2014-05-08 (first published: 2014-04-29)
4,115 reads
Getting Local Books Online
One of the things that’s annoyed me in the last few versions is that Books Online isn’t smoothly installed for...
2014-05-08
887 reads
Recent Event Recap
These last few weeks have been quite a blur of projects, travel, and end-user training, and I’m enjoying every bit...
2014-05-08
727 reads
Speaking at MagicPASS on May 28, 2014
If you’re wondering who the mystery speaker is – it’s me! I’ll be doing two presentations at Magic Pass on May...
2014-05-08
339 reads
SQL Server is not a toy
I began my career working with Sybase on UNIX. Everything was done via the shell. There were strong practices in...
2014-05-08
791 reads
SQLSaturday in Houston
This upcoming Saturday I will be presenting two sessions at SQLSaturday in Houston (more info). I hope to see you...
2014-05-08
786 reads
The Cardinality Estimator in SQL Server 2014 – Going Forward and Backward
I saw a talk from Joe Sack (b | t) on the cardinality estimator (CE) in SQL Server 2014 and found...
2014-05-08 (first published: 2014-04-30)
3,523 reads
The Importance of Networking
In a survey conducted by Business Network SW, the organization found that 87% of businesses partake in some form of...
2014-05-08
589 reads
Another User Has Locked My File!
I had an SSIS package fail in a script task this morning. As part of the why process I opened...
2014-05-07
346 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