A Fundamental Security Mistake
Steve Jones thinks Microsoft is making a fundamental security mistake in the way they build features for the various editions of SQL Server. Read today's editorial and see if you agree.
Full Text Index Management in SQL Server 2005 Express Edition
Recent installments of our series dedicated to the most important features of SQL Server 2005 Express Edition have focused on its Full Text Indexing capabilities. This article covers other full text indexing management methods.
String Manipulation - CHARINDEX()
I see charindex used quite commonly in string manipulation. What I rarely see used is the optional third parameter. Here...
Defining a Database
What is a database exactly? Steve Jones wonders if we should define it differently after viewing a list of some of the largest databases in the world, many of which might not equate to what a DBA or developer would consider a "database."
SQL Server 2008 Administration in Action - Sample Chapter
A sample chapter on clustering from Manning Publishing. Read it to learn a bit on clustering and preview this new book.
Defining a Database
What is a database exactly? Steve Jones wonders if we should define it differently after viewing a list of some of the largest databases in the world, many of which might not equate to what a DBA or developer would consider a "database."
Defining a Database
What is a database exactly? Steve Jones wonders if we should define it differently after viewing a list of some of the largest databases in the world, many of which might not equate to what a DBA or developer would consider a "database."
Defining a Database
What is a database exactly? Steve Jones wonders if we should define it differently after viewing a list of some of the largest databases in the world, many of which might not equate to what a DBA or developer would consider a "database."
Holidays and Parties, Gift, Expectations, and Wishes
Most companies do something at the holidays, although it seems to be less with each year, and certainly this holiday...
Understanding SQL Server fixed database roles
I know there are fixed database roles that come with SQL Server. How do I best use them within my installations? What should I watch out for? In this tip we will cover each of the database roles and recommendations on when to and when not to use them.
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