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.

Contextual View

by faiggarayev

SQL Design Patterns

In this post I describe technique of presenting data that is context specific - for example, data that will be changing...

2018-04-11

1,183 reads

Hide and Abstract the physical layer

by faiggarayev

SQL Design Patterns

How to build an abstraction layer between physical and logical layers in the database code

2018-04-07

175 reads

Extending built-in data types

by faiggarayev

SQL Design Patterns

add generic user defined table data types as extension to built-in ones

2018-04-05

159 reads

Soft Delete

by faiggarayev

SQL Design Patterns

How to delete without deleting

2018-04-03

261 reads

Configuration service database design pattern

by faiggarayev

SQL Design Patterns

In many cases, we are required to store configuration values for an application, application functionalities or user-specific parameters. Normally application-level...

2018-03-30

532 reads

The Journey Begins

by faiggarayev

SQL Design Patterns

Thanks for joining me! Target Audience. Database developers, designers and architects. Background. I am lazy efficient, at least am trying to...

2018-03-30

319 reads

All authors

Forums

Visit the forum

Contextual View

Hide and Abstract the physical layer

Extending built-in data types

Soft Delete

Configuration service database design pattern

The Journey Begins

Blogs

10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives

The Book of Redgate: Evidence

When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?

Forums

Alamat Kantor BCA KCU Yogyakarta Tlp:08217555651

Alamat Kantor BCA KCU Purwodadi Tlp:08218154374

Alamat BCA KCU Solo Slamet Riyadi Tlp:08218200203

Question of the Day

BIT_COUNT() V