In part one Chris Kempster covered a variety of security recommendations primarily for production systems. In Part two of this series he continues to explore security at a variety of levels where you may not realize you are vulnerable.
2019-10-04 (first published: 2004-01-30)
35,421 reads
This article by Chris Kempster covers a wide variety of areas concerned with data migration. Primarily, it focuses on process, standards and some of the many issues to consider when undertaking this role.
2017-08-23 (first published: 2004-03-24)
56,859 reads
This article by Chris Kempster shows you how to quickly move a database by detaching or taking a database offline.
2008-02-08 (first published: 2004-05-18)
148,316 reads
In this series of articles, Chris Kempster will discuss some of the finer aspects of SQL Server security and also touch on OS, physical and application security to open up this science for general discussion.
2007-10-02 (first published: 2002-01-14)
50,633 reads
For the most part the DTC (Distributed Transaction Coordinator) just works. What happens when it doesn't? Chris had to resolve an issue with it recently and documented some of the steps he used.
2004-01-19
19,927 reads
SQL Mail comes with SQL, but you have to load Outlook to use it. The alternative is to send email directly via SMTP. Combine that idea with alerts and you've got a new article!
2004-01-13
14,445 reads
Full text indexing is interesting, but not always easy for the user to apply well. Chris has some ideas about to make that
2003-12-11
12,209 reads
Chris Kempster brings us a basic look at the database design topic of denormalization.
2003-12-01
17,804 reads
One of our favorite authors is back with a great how-to on log shipping. This isn't the baked in log shipping, this is a code your own solution that gives you a starting point for your situation. Even if you don't need it now, it's worth looking at to gain a better understanding of how shipping works.
2003-11-26
26,205 reads
Another product review! Chris put AdeptSQL (a schema comparison and sync product) to work and wrote up the results. This article also includes some feedback from the vendor that is worth reading.
2003-11-03
5,190 reads
A while back I wrote a quick post on setting up key mappings in...
By Steve Jones
In 100 years a lot of what we take to be true now will...
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...
Comments posted to this topic are about the item 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