Data security is always one of the important points which can not be ignored. Nowadays if you are working for any specific domain like Banking or Healthcare then there are a lot of compliance rules which you have to follow. Data Masking is one of the best ways to help you to secure your sensitive …
In the series of SQL SERVER 2016, this is a new post. in this post, we will discuss DATEDIFF_BIG and how it is helpful. So, before jumping into directly in technical details, we all know that time is very important and every second valuable and countable but sometimes every microsecond & nanosecond is also countable …
In the Series of SQL SERVER 2016, this is another post. Before Jumping in detail just think if you have a comma or other separator string and if you have to split it by separator field then for such task in previous SQL SERVER versions either you will write a function which split the string …
This is another article in the series of SQL SERVER 2016 Journey . I am pretty much sure you might aware of Gzip Compression algorithm. If not then try this link. So, SQL SERVER 2016 introduce this two awesome functions for Compress & Decompress the data. Before SQL SERVER 2016 version we have data compression …
In the Series of SQL SERVER 2016 journey, this is our new article. In this article, we are sharing a new cool feature which introduced in SQL SERVER 2016 which is DROP IF EXISTS (DIE) . In our development many times it happens that we need to drop a table and as a best practice …
Although, I know I am bit late to share this thing on our blog but it says in Indian proverb “Der aai durust aai” means it’s OK you came late but you came that is more important. Anyways, so you all might aware that Microsoft launched SQL SERVER 2016 officially in June 2016. You …
Yes, you saw the correct news. SQL SERVER 2016 finally released on 1st June 2016. It is most awaited NEWS. You will find many surprising features in this Build. Below are some upcoming features which you will see in this feature 1) Temporal Table 2) Stretch Database 3) Row Level Security 4) Poly Base 5) …