SQL Saturday 50 (#sqlsat50) – A Tale
This past weekend I went to SQL Saturday 50 – this is a day long SQL training event that is put...
2010-09-21
820 reads
Blog Posts
Table Variables and Transactions
I actually had a question of the day submitted on SQLServerCentral about table variables and transactions, but the person didn’t...
2010-09-21
9,333 reads
What Did that Geek Just Say?
The National Institute of Standards and Technology, NIST, maintains a Dictionary of Algorithms and Data Structures. The dictionary is a great place to go to find out what people...
2010-09-21
6 reads
What Did that Geek Just Say?
Working in a technical field has it’s ups and downs. One of the more common annoyances I run into is...
2010-09-21
325 reads
What Did that Geek Just Say?
The National Institute of Standards and Technology, NIST, maintains a Dictionary of Algorithms and Data Structures. The dictionary is a great place to go to find out what people...
2010-09-21
4 reads
Aliases in SQL Server 2008
Recently I set up replication and as the target server was not on our domain I initially used an IP...
2010-09-20
982 reads
Breaking Into SQL Showbiz
You can tell by my face, I'm an expert
Matthew Velic (blog, Twitter) just asked this question on Twitter:
And really that’s...
2010-09-20
683 reads
Free SQL Server Training for the Week of September 20, 2010
Monday
PASS Data Warehousing/BI Virtual Chapter - Adaptive BI: Engineering a BI Solution - Davide Mauri
Tuesday
SQL Lunch - Restartability in SSIS - Kyle Walker
Pragmatic Works...
2010-09-20
647 reads
Home Theater Upgrades
Back in late 2003, I had my basement finished,and as part of that effort, I put in a dedicated home...
2010-09-20
608 reads
Kimball University: Microsoft Data Warehouse in Depth
Several years ago, late 2006, I decided to focus my career on Data Warehousing and Business Intelligence (DW/BI). I was...
2010-09-20
1,167 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
Why End-User Testing Is Even More Important with AI
Comments posted to this topic are about the item Why End-User Testing Is Even...
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...
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