The Virginia Tour 2016
Three days of presentations in Richmond Virginia. From Naked SQL to Wheel of Doom - there is a wide breadth of knowledge to be shared.
Related Posts:
An Experiment with Deadlocks...
2016-03-11
1 reads
Jason Brimhall
SQL Server Locks – Back to Basics
Prelude in SQL Minor
Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to...
2016-03-08 (first published: 2016-03-01)
3,267 reads
SQL Server Locks – Back to Basics
A fundamental component of SQL Server is locking and locks. The locking mechanism helps to control access to resources to help maintain data integrity.
Related Posts:
An Experiment with Deadlocks March...
2016-03-01
40 reads
SQL Server Principals – Back to Basics
Prelude in SQL Minor
Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to...
2016-02-03 (first published: 2016-01-28)
3,315 reads
SQL Server Principals – Back to Basics
A fundamental component of SQL Server is the security layer. A principle player in security in SQL Server comes via principals.
Related Posts:
Easy Permissions Audit January 21, 2019
SQL...
2016-01-28
419 reads
All about the Change
The second Tuesday of January 2016 is now upon us and you know what that means. Well, I hope you...
2016-01-21 (first published: 2016-01-12)
1,424 reads
Alter Event Session
Ready for a change of pace? Good! Today is a really good time to start looking into one of the...
2016-01-13 (first published: 2016-01-08)
2,487 reads
All about the Change
The use of SQL Audit can be viable to track the changes that may be occurring within your SQL Server - from a settings point of view
Related Posts:
CRM Data...
2016-01-12
3 reads
Alter Event Session
Altering an Extended Event session is not necessarily a difficult task, but it is a very useful ability. Having this basic skill in your wheelhouse can be very positive...
2016-01-08
14 reads
Filtering Logged Data
Over the course of the past couple of articles, I have shown some interesting if not useful functionality in the...
2016-01-07 (first published: 2016-01-01)
1,225 reads
Blogs
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Forums
Missing the Jaro Winkler Distance
Comments posted to this topic are about the item Missing the Jaro Winkler Distance
25 Years Later: What SQLServerCentral Meant to Me
Comments posted to this topic are about the item 25 Years Later: What SQLServerCentral...
Doing Good at SQL Server Central
Comments posted to this topic are about the item Doing Good at SQL Server...
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