What Are Your Indexing Strategies?
A couple weeks ago, I got some pretty great new. The book proposal that I had submitted to Apress was...
2011-03-22
628 reads
Blog Posts
21st March - Today is International Day for the Elimination of Racial Discrimination
How to Counter Intolerance, Adapted from UNESCO’s Recommendations
1. The Battle Against Intolerance Requires Law
Every Political Entity needs to reinforce Human...
2011-03-21
1,107 reads
Blog Syndication
I got sent an email recently asking how I went about syndicating my blog on some of the popular SQL...
2011-03-21
1,734 reads
Communication
It sure seems like there’s a lot of miscommunication between developers and database specialists. In fact, the communication can become...
2011-03-21
2,613 reads
Database Mail – Collection of SQL Server Scripts
As part of my blogging I’ll be periodically providing readers with a collection of my scripts which I use on...
2011-03-21
929 reads
Dedupe Data CTE
As a DBA working with SQL Server, some data issues arise that need to be fixed. One such data issue...
2011-03-21
1,380 reads
Dedupe Data CTE
As a DBA working with SQL Server, some data issues arise that need to be fixed. One such data issue is the duplication of data. Duplicate data can happen...
2011-03-21
10 reads
Diskpart command line utility
To get the disk information internal. there is a utility called diskpart this is good utilityto understand your disk information....
2011-03-21
456 reads
Next Up: SQL Connections!
SQL Saturday #70 is officially in the books. There's some administrative stuff: I will do a blog post about lessons...
2011-03-21
778 reads
SQL Server Connections in a week
I’m heading to SQL Server Connections next week, part of the DevConnections conference featuring a whole slew of technologies. Once...
2011-03-21
786 reads
Blogs
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Advice I Like: In 100 Years
By Steve Jones
In 100 years a lot of what we take to be true now will...
Forums
AllocationType as ROW_OVERFLOW_DATA
Hello, I inherited a number of tables with like 20-30 column using nvarchar(256) in...
is it true we cant debug c# scripts in ssis anymore under vs
Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...
Question of the Day
Missing the Jaro Winkler Distance
I upgraded a SQL Server 2019 instance to SQL Server 2025. I wanted to test the fuzzy string search functions. I run this code:
SELECT JARO_WINKLER_DISTANCE('tim', 'tom')
I get this error message:Msg 195, Level 15, State 10, Line 1 'JARO_WINKLER_DISTANCE' is not a recognized built-in function name.What is wrong? See possible answers