Learn & Share ASP.NET & SQL SERVER | Microsoft Technologies, ASP.NET & SQL SERVER Tips with Rajat Jaiswal If you are a developer then surely you might have used JSON (JavaScript Object Notation) but, if not then don’t worry you might use sooner than later. JSON is kind of ecosystem which is most popular in …
Nerd Techies | Learn & Share knowledge with nerds To understand RLS (ROW LEVEL SECURITY) let’s understand the different problems first. Problem 1 Suppose, you have a Multi-tenant e-commerce website and different companies registered on your website and you have centralized single database for all the client. Now as a product owner it is your …
Though it’s true that having fast performing disk (15K rpm or SSD) is good for IO intensive applications but in a real scenario, it’s not enough. In my 5 years experience with an organization where we had DELL storage of 10 TB with approx 20 disks (600 GB each) of 15K rpm but yet we were facing alert, PAGEIOLATCH_SH, PAGEIOLATCH_EX …
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 …
A good database design provides the best performance during data manipulation which results in the best performance of an application. During database designing and data manipulation we should consider the following key points: 1). Make sure that every table in your database has a primary key : This will ensure that every table has a …
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 …