Automating CRUD procedures generation using T-SQL (enhanced).
In this post I will describe the helper procedure that based on metadata generates numerous database objects around views and...
2019-01-03
349 reads
In this post I will describe the helper procedure that based on metadata generates numerous database objects around views and...
2019-01-03
349 reads
In this article I continue to explore the ways to secure the data via contextual views and describe the technique...
2018-10-18
505 reads
In this post we will discuss how to fetch data from a large dataset for web applications using pagination technique....
2018-10-17
391 reads
This post helps in deciding between choosing foreign key and check constraints in case we need to constraint the data...
2018-10-16
411 reads
We are often required to pass the data between different database procedures and functions. In this post I will review...
2018-09-06
298 reads
In this post I will show how in some cases we can split a long procedure to a small and...
2018-05-23
1,736 reads
I try to avoid dynamic SQL as much as possible and consider it as a necessary evil. However, in some...
2018-05-21 (first published: 2018-05-09)
2,487 reads
In this post you will find two small functions that convert binary value to a decimal one and vice versa.
2018-05-19
397 reads
Deployment process equally responsible for deploying both database objects as well as an initial state of the database/applications. In this...
2018-05-10
599 reads
Designing implementation of interface is as critical as designing interface itself. In this post we will discuss some advice on...
2018-04-14
1,283 reads
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
By Steve Jones
I leave tonight for Australia. I was in London 3 days ago, so this...
By Brian Kelley
As I look at the state of information technology today, I see one constant:...
Sample data: jan 10gb feb 15gb mar 16gb april 14gb(truncate data) may 18gb june...
Everybody (well almost) knows that if you want to learn the design patterns for...
How many table hints can I include in a query?
See possible answers