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: March 2018

Configuration service database design pattern

In many cases, we are required to store configuration values for an application, application functionalities or user-specific parameters. Normally application-level parameters are stored in the configuration files. However, if the parameters values are driving domain or business logic inside of the database call, then making an external call to the…

Read more

5 comments, 272 reads

Posted in SQL Design Patterns on 30 March 2018

The Journey Begins

Thanks for joining me! Target Audience. Database developers, designers and architects. Background. I am lazy efficient, at least am trying to be. First I coded, and coded, and coded. Over time I realized that I like to code, but more, I like to code smart. So I start to read,…

Read more

2 comments, 252 reads

Posted in SQL Design Patterns on 30 March 2018