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

How to pass data between procedures using temp tables.

In this post I will show how in some cases we can split a long procedure to a small and manageable parts using a simple technique of passing data in temp tables

Read more

1 comments, 1,618 reads

Posted in SQL Design Patterns on 23 May 2018

Helper function to convert binary to decimal and back

In this post you will find two small functions that convert binary value to a decimal one and vice versa.

Read more

3 comments, 365 reads

Posted in SQL Design Patterns on 19 May 2018

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

Deployment process equally responsible for deploying both database objects as well as an initial state of the database/applications. In this post, I will talk about different options on how to bring your own meta-data with the deployment

Read more

3 comments, 562 reads

Posted in SQL Design Patterns on 10 May 2018

Helper procedure to dynamically execute list of statements

I try to avoid dynamic SQL as much as possible and consider it as a necessary evil. However, in some cases, dynamic SQL is the only way. Often, especially while wringing maintenance script, we prepare dynamic scripts that we need to execute statement by statement. In this post, I will…

Read more

2 comments, 2,435 reads

Posted in SQL Design Patterns on 9 May 2018