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

380 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

519 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

405 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

443 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

313 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,760 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

413 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

612 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,499 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,294 reads

SQL Design Patterns

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

Contextual View Part II or how to hide sensitive data

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

Lookup. Foreign Key Constraint vs Check Constraint

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

How to pass data between procedures using temp tables.

Helper function to convert binary to decimal and back

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

Helper procedure to dynamically execute list of statements

Best-practices, guiding principles of choosing procedure parameters

Blogs

SQL Server Logins vs. Users: Why You Really Need to Know the Difference

Using AI to Test a SQL Query

Your SQL Starting Line: Best Free Databases for Beginners

Forums

A Basic Data API Builder ADD

Sentiment Analysis & Key Phrase Detection

can ssrs detect rls and cls thru proxy like user ids?

Question of the Day

A Basic Data API Builder ADD

SQL Design Patterns

Blogs

Forums

Question of the Day

Cookies on SQLServerCentral