The T-SQL Hammer
The over-reliance on a familiar tool is best described with the quote, “if all you have is hammer, everything looks...
2010-02-23
4,134 reads
Chad Miller
The T-SQL Hammer
The over-reliance on a familiar tool is best described with the quote, “if all you have is hammer, everything looks...
2010-02-16
3,474 reads
Providing Online Help for Powershell Modules
As a finishing touch for the SQL Server Powershell Extensions 2.0 Release I wanted to provide an online version of...
2010-02-02
2,003 reads
The Powershell V1 to V2 Conversion
This post is about my experience converting the CodePlex project, SQL Server Powershell Extensions (SQLPSX) Powershell V1 function libraries into PowerShell V2 Advanced...
2010-02-01
2,075 reads
The Black Art of PowerShell V2 Version Numbers
Last week while helping someone in the SQLPSX forums having an issue importing modules I suspected they had a CTP...
2010-01-28
823 reads
SQL Saturday #32
I presented a one hour session at SQL Saturday #32 in Tampa on Powershell ETL: "In this sesssion we will look...
2010-01-23
423 reads
Finding Invalid SQL Logins
As many of you know the system stored procedure sp_validatelogins is used for finding invalid logins. Although sp_validatelogins is useful there's...
2010-01-19
2,220 reads
Hello SMO (F#) World!
Reading The F# Survival Guide has motivated me to write my version of an F# "Hello World!" utility. What I mean...
2010-01-13
23,315 reads
Finding Invalid SQL Logins
As many of you know the system stored procedure sp_validatelogins is used for finding invalid logins. Although sp_validatelogins is useful there's...
2010-01-12
5,064 reads
PowerShell V2 Remoting
To use remoting you'll need to install Powershell V2, unless you're running Windows 2008 R2 or Windows 7, you'll need...
2009-12-02
1,197 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