Articles

SQLServerCentral Article

Managing Jobs - Part 4

Andy has been busy lately on a project you'll be hearing more about soon (!), but he did manage to get part four of his managing jobs series done. This article discusses ideas for patterns to follow when building jobs, including writing to the console, setting errorlevels, and how to get them installed on the server. DBA's, if you're not developers, look at this article - this is stuff you can take to your development team and get better/more manageable jobs.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2003-06-25

8,009 reads

SQLServerCentral Article

Deleting Child Data Based Upon Criteria in the Parent Table

New Author! Thom's first article discusses the difficulties you encounter when your database doesn't support cascading deletes (or you've opted not to use it) and you need to delete data in a child table based upon a value in the parent table. Not exactly your run of the mill delete query. Take a look and please rate/comment the article!

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2003-06-24

5,284 reads

Technical Article

SQL Server DTS Best Practices

This article discusses various SQL Server Data Transformation Services (DTS) best practices. It is divided into sections like DTS naming conventions, DTS documentation, troubleshooting DTS packages, improving the performance of DTS packages, securing DTS packages, DTS resources.

2003-06-24

4,068 reads

Technical Article

Free BCP GUI

Pedro Estrada has published a free tool that according to his site "This is a complete application to have an easier interface to work with BCP against MSSQL servers. Just specify a server, database, table user name and password to BCP out or IN." Worth a try, and he has some other free utilities (some SQL, some not) on the site.

2003-06-19

1,922 reads

SQLServerCentral Article

UDF as Computed Column

UDF's are useful if somewhat tricky. Dinesh uses a common scenario where you have a self referencing table (the common example is an employees table where each employee has a managerid that links to another employee in the same table) to illustrate how a UDF can make querying easier, how to use it as the basis of a computed column, and how to index that column.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(2)

You rated this post out of 5. Change rating

2003-06-18

12,284 reads

Technical Article

myLittleAdmin for MS SQL and MSDE released !

myLittleTools.net is pleased to announce the release of myLittleAdmin, the most advanced and robuste web-based MS SQL and MSDE database administration tool. This new version offers a new skinnable interface and a lot of great new features, such as user levels, multi-databases support or SQL script generation. A lite version is available for free so that you can test it in your own environment. Use myLittleAdmin and do through a browser almost everything you did before with Enterprise Manager.

2003-06-17

1,164 reads

Technical Article

SQL Database Audit Tool released to beta

LockwoodTech has released a new sql tool that analyzes the SQL Server transaction log to passively audit a SQL Server database. You can track inserts, updates, deletes and full row level detail of past transactions (even before the tool was installed). Client supports powerful filtering, grouping and sorting of audit data.

2003-06-16

37 reads

Blogs

AI Step 1

By

RANK() vs DENSE_RANK(): #SQLNewBlogger

By

I haven’t done one of these in awhile, but I saw an article recently...

Using CAT for Testing of Data Agents

By

In last months one of the scenarios where you can use AI has been...

Read the latest Blogs

Forums

Missing the Jaro Winkler Distance

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Missing the Jaro Winkler Distance

25 Years Later: What SQLServerCentral Meant to Me

By Brian Knight

Comments posted to this topic are about the item 25 Years Later: What SQLServerCentral...

Doing Good at SQL Server Central

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Doing Good at SQL Server...

Visit the forum

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