SQL SERVER ON LINUX INSTALLATION – PART4 – Install SQL Server Tools on Ubuntu – Updated!
Installing SQL Server on Linux does not install SQL Server tools by default. You have to install it individually. In...
2017-06-13
1,670 reads
SQL Geek
SQL Server 2017 – DMF – sys.dm_db_log_info
The release of Microsoft SQL Server 2017 brought a lot of very interesting new features. One of them is the...
2017-06-12
962 reads
Top Function – Performance Gain
Recently, I presented at Singapore SQL Pass Chapter on the topic T-SQL Fun, and the most of the attendees were...
2017-06-05
456 reads
Log File Space Issue Monitoring Using SQL Server DMV
As a continuation of “Database Monitoring using DMV” series, this blog will cover how quickly you can address the log...
2017-06-14 (first published: 2017-05-31)
5,765 reads
SQL Server 2017 sys.dm_os_enumerate_fixed_drives
In SQL Server 2017, you can use the new DMV sys.dm_os_enumerate_fixed_drives to identify free disk space. The DMV is replacement...
2017-05-15
1,527 reads
SQL Server 2017 – The operating system returned the error 21
Recently, I was exploring SQL Server 2017 CTP 2.0 using SQL Server Management Studio V17. Till the time, I was...
2017-05-15
4,634 reads
Setting Up a Subscription
In the last two blogs, we went through Configure Distribution Database and Publication Creation. If you haven’t read them, I...
2017-05-10
3,619 reads
Setting Up a Publication for Transaction Replication
In the previous blog, we discussed how to Configure Distribution Database. Once you setup your Distribution database successfully, you can...
2017-05-09
2,860 reads
Configure Distribution Database
In this blog, we are going to learn about the Distribution database, how to configure the Distribution database, and how...
2017-05-18 (first published: 2017-05-06)
12,084 reads
SQL Database File Wise Disk Space Monitoring
As a DBA, you get alerts many times regarding the database file space issue. To address the issue, you may...
2017-04-21
1,176 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