I am Dedicated Agile champion, Database Manager and Solutions Architect with two decades of experience in improving database functionality, diagnosing problems, building successful project teams, and improving SDLC and business processes.

I love data and databases and the challenge that comes with designing solutions. This blog is an attempt to share my knowledge with those who are interested.

Automating CRUD procedures generation using T-SQL (enhanced).

by faiggarayev

SQL Design Patterns

In this post I will describe the helper procedure that based on metadata generates numerous database objects around views and...

2019-01-03

388 reads

Contextual View Part II or how to hide sensitive data

by faiggarayev

SQL Design Patterns

In this article I continue to explore the ways to secure the data via contextual views and describe the technique...

2018-10-18

523 reads

Pagination pattern or how to fetch a large dataset for a web report.

by faiggarayev

SQL Design Patterns

In this post we will discuss how to fetch data from a large dataset for web applications using pagination technique....

2018-10-17

413 reads

Lookup. Foreign Key Constraint vs Check Constraint

by faiggarayev

SQL Design Patterns

This post helps in deciding between choosing foreign key and check constraints in case we need to constraint the data...

2018-10-16

451 reads

Decision tree on the pattern of choosing how to pass data to a procedure

by faiggarayev

SQL Design Patterns

We are often required to pass the data between different database procedures and functions. In this post I will review...

2018-09-06

323 reads

How to pass data between procedures using temp tables.

by faiggarayev

SQL Design Patterns

In this post I will show how in some cases we can split a long procedure to a small and...

2018-05-23

1,773 reads

Helper procedure to dynamically execute list of statements

by faiggarayev

SQL Design Patterns

I try to avoid dynamic SQL as much as possible and consider it as a necessary evil. However, in some...

2018-05-21 (first published: 2018-05-09)

2,510 reads

Helper function to convert binary to decimal and back

by faiggarayev

SQL Design Patterns

In this post you will find two small functions that convert binary value to a decimal one and vice versa.

2018-05-19

421 reads

How to deploy data for the lookup tables, small dimensions and other meta-data with your database code

by faiggarayev

SQL Design Patterns

Deployment process equally responsible for deploying both database objects as well as an initial state of the database/applications. In this...

2018-05-10

619 reads

Best-practices, guiding principles of choosing procedure parameters

by faiggarayev

SQL Design Patterns

Designing implementation of interface is as critical as designing interface itself. In this post we will discuss some advice on...

2018-04-14

1,299 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

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

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

connections vs apis

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

is it true we cant debug c# scripts in ssis anymore under vs

Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...

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