Fuzzy-String Search: Find misspelled information with T-SQL
An optimized Damerau-Levenshtein Distance (DLD) algorithm for "fuzzy" string matching in Transact-SQL 2000-2008
2014-01-10 (first published: 2012-09-18)
31,070 reads
Articles
Stop & Start Your VM’s on Azure with Powershell
This is a very simple script can be used as a framework for you to stop and start your VM’s on Azure with Powershell.
2014-01-10
3,020 reads
An Introduction to Windows Azure Table Storage
Windows Azure Tables are intended for the storage of large amounts of schemaless data. Tables are just containers of rows of data. Mike Wood describes the practicalities of getting started with using the system.
2014-01-09
2,593 reads
Relational database or graph database? Why not have both?
SQL Server may not be the best solution for every problem, but we have the means to extend its capabilities by linking it to external resources; in this case, using SQLCLR to query a graph database.
2014-01-08
9,281 reads
SQL Server 2014 Hybrid Cloud Scenarios: Migrating On-Premises SQL Server to Windows Azure Virtual Machines
This article describes how to use the new wizards in SQL Server Management studio to get access to Windows Azure and then create and configure your VM.
2014-01-08
3,114 reads
An AlwaysOn Bug with Service Broker Transmission Queue
Paul Brewer talks about an AlwaysOn problem affecting the Service Broker Transmission Queue.
2014-01-07
4,465 reads
Data Science Laboratory System – Graph Databases
Graph database are an intriguing alternative to the relational model. They apply graph theory to record the relationships between entries more naturally, and are a good fit for a range of data tasks that are difficult in SQL. Buck Woody gives an introduction to Graph databases and shows how to get Neo4J up and running to get familiar with the technology.
2014-01-07
3,331 reads
A Simple Recursion Finds Joins
When you need to find all the related rows and tables to a parent table, here's one way you might approach the problem.
2014-01-06
8,190 reads
Fighting Tooth and Nail for Performance
You need a SQL Server-based application that will work with huge amounts of data and must perform calculations of startling complexity. How far will you go to deliver the required performance?
2014-01-06
172 reads
Exporting CLR Assemblies from SQL Server back to .dll files
You have imported an assembly into a SQL Server database to use the CLR functions and stored procedures it contains. However later, you lost the original .dll file and you would like to create the .dll file again from what's in the database. In this tip, we look at how you can recreate the .dll file.
2014-01-06
2,453 reads
Blogs
Learning from Mistakes: T-SQL Tuesday #194
By Steve Jones
We’re a week late, once again my fault. I was still coming out of...
Stupid Things I Did With AI: ASCII Art
By Steve Jones
I ran across this article recently (https://www.gatesnotes.com/meet-bill/source-code/reader/microsoft-original-source-code) and it has a great opening piece...
Simple Talks Podcasting in 2026
By Steve Jones
I’m in the UK today, having arrived this morning in London. Hopefully, by this...
Forums
Cumulative Update 23 - KB5074819 - Database Mail - No longer working.
Hi there, Has anyone else had any trouble with Database Mail in Cumulative Update...
Script Task execution error with HTTP request
I have a script task that tries to execute a HTTP request, which seems...
SQL Server 2025 Standard Developer Edition
Comments posted to this topic are about the item SQL Server 2025 Standard Developer...
Question of the Day
URL Safe or Not?
If I use BASE4_ENCODE() in SQL Server 2025, is the output URL Safe by default?
See possible answers