SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

SQL Design Patterns

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.

Archives: April 2018

Best-practices, guiding principles of choosing procedure parameters

Designing implementation of interface is as critical as designing interface itself. In this post we will discuss some advice on how to choose the right set of parameters for your procedures

Read more

1 comments, 1,179 reads

Posted in SQL Design Patterns on 14 April 2018

Contextual View

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

Read more

3 comments, 1,088 reads

Posted in SQL Design Patterns on 11 April 2018

Hide and Abstract the physical layer

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

Read more

6 comments, 125 reads

Posted in SQL Design Patterns on 7 April 2018

Extending built-in data types

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

Read more

2 comments, 122 reads

Posted in SQL Design Patterns on 5 April 2018

Soft Delete

How to delete without deleting

Read more

1 comments, 191 reads

Posted in SQL Design Patterns on 3 April 2018