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

Contextual View Part II or how to hide sensitive data

In this article I continue to explore the ways to secure the data via contextual views and describe the technique of hiding the data in the logical layer utilizing business rules. Click here to read full article.

Read more

0 comments, 361 reads

Posted in SQL Design Patterns on 18 October 2018

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

In this post we will discuss how to fetch data from a large dataset for web applications using pagination technique. Click here to read full article

Read more

2 comments, 196 reads

Posted in SQL Design Patterns on 17 October 2018

Lookup. Foreign Key Constraint vs Check Constraint

This post helps in deciding between choosing foreign key and check constraints in case we need to constraint the data in a field. Click here to read full article

Read more

1 comments, 205 reads

Posted in SQL Design Patterns on 16 October 2018