SQL Guatemala

To check the available advanced options configured at instance level in SQL Server, you need to use the sp_configure system...

2017-11-24

45,032 reads

Finally I am MCSA

by Eduardo Pivaral

SQL Guatemala

I have recently obtained the certification Microsoft Certified Solutions Associate: SQL Server 2012/2014.
I began with this path almost 2 years...

2017-11-20

79 reads

Query to determine mirrored database status

by Eduardo Pivaral

SQL Guatemala

I am sharing today a SQL Script to quickly check on an instance which databases are in mirrored and their...

2017-11-10

6,352 reads

SSIS Basics: Integration Services Catalogs

by Eduardo Pivaral

SQL Guatemala

In the new Project deployment model for SQL Server Integration Services, a new SQL Server database is used to provide...

2017-11-06

235 reads

T-SQL Basics: MERGE Statement

by Eduardo Pivaral

SQL Guatemala

One useful sentence when you need to add data to an existing table from an external source or database, and...

2017-10-06

389 reads

Blogs

Presenting with Visual Studio Code

By Andrew Pruski

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...

dataMinds Saturday 2026 – Slides

By Koen Verbeeck

At Saturday the 21st of February I’m presenting an introduction to dimensional modelling at...

Read the latest Blogs

Forums

AllocationType as ROW_OVERFLOW_DATA

By inHouseDBA

Hello, I inherited a number of tables with like 20-30 column using nvarchar(256) in...

connections vs apis

By stan

hi , i hear more and more that we have too many connections to...

Visit the forum

Question of the Day

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')

Msg 195, Level 15, State 10, Line 1 'JARO_WINKLER_DISTANCE' is not a recognized built-in function name.

See possible answers