SQL Design Patterns

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

182 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

448 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

311 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

283 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

239 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,631 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

367 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

570 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,440 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,216 reads