Contextual View
In this post I describe technique of presenting data that is context specific - for example, data that will be changing...
2018-04-11
1,136 reads
SQL Design Patterns
Hide and Abstract the physical layer
How to build an abstraction layer between physical and logical layers in the database code
2018-04-07
140 reads
Extending built-in data types
add generic user defined table data types as extension to built-in ones
2018-04-05
138 reads
2018-04-03
211 reads
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...
2018-03-30
381 reads
The Journey Begins
Thanks for joining me! Target Audience. Database developers, designers and architects. Background. I am lazy efficient, at least am trying to...
2018-03-30
284 reads
Blogs
Daily Coping 30 Nov 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Fail activity in Azure Data Factory and Why would I want to Fail
By Rayis Imayev
(2021-Nov-30) I heard a story about a young person who was asked why she was...
Hiding Email with a Dynamic Data Masking Function–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Forums
How to move Paas SQL Database from one subscription to another subscription
Hi experts, Can some one please post procedure/Steps to move ( including Logins, Users)...
Arithmetic overflow error converting expression to data type datetime when selec
I have such an issue. I want to select a column PDWEDT (it is...
inner join give me huge data when package id equal package id from another table
I work on sql server 2014 i face issue when join two tables as...
Ask SSC