How is easy to work with JSON in SQL SERVER 2016 ?
If you are a developer then surely you might have used JSON (JavaScript Object Notation) but, if not then don’t...
2017-03-28
1,510 reads
Rajat Jaiswal
- Interests: I am always interested in Microsoft Technology specially asp.net & SQL server. Other than this I love Singing ,dancing and playing musical instruments.
How easy it is to implement Row Level Security in SQL SERVER 2016 ?
To understand RLS (ROW LEVEL SECURITY) let’s understand the different problems first.Problem 1 Suppose, you have a Multi-tenant e-commerce website...
2017-03-27
940 reads
Why Do People Think Dynamic Data Masking is a Good Idea? - SQL SERVER 2016 #5
Data security is always one of the important points which can not be ignored. Nowadays if you are working for...
2016-11-27
883 reads
How DATEDIFF_BIG a new feature of SQL SERVER 2016 Can Keep You Out of Trouble
In the series of SQL SERVER 2016, this is a new post. in this post, we will discuss DATEDIFF_BIG and...
2016-10-22
793 reads
If You Read One Article About Split String in SQL SERVER 2016s Read this One #3
In the Series of SQL SERVER 2016, this is another post. Before Jumping in detail just think if you have...
2016-10-22
926 reads
Do you know Compress & Decompress function in SQL SERVER 2016 ?
This is another article in the series of SQL SERVER 2016 Journey . I am pretty much sure you might aware...
2016-10-16
1,457 reads
Here Come New Ideas for DROP IF EXISTS in SQL SERVER
In the Series of SQL SERVER 2016 journey, this is our new article. In this article, we are sharing a...
2016-10-15
1,083 reads
9 Amazing features of SQL SERVER 2016
Although, I know I am bit late to share this thing on our blog but it says in Indian proverb...
2016-10-11
659 reads
2016-03-29
479 reads
How to do Step by Step Merge Join Transformations - #123
In last post tip #122, We discussed Merge transformation. Now in this tip, we are going to discuss Merge Join....
2015-12-31 (first published: 2015-12-18)
2,512 reads
Blogs
First Time Speaking with a Mask at an Event
By DataOnWheels
Over the past couple of months, I have started losing my ability to talk...
A New Word: Apolytus
By Steve Jones
apolytus– n. the moment you realize you are changing as a person, finally outgrowing...
Tired of Tedious SQL Queries? AI Tools Can Automate The Boring Parts
If you've ever wrestled with complex SQL code, you know the drill. Hours spent...
Forums
Do you listen to music when you work?
Comments posted to this topic are about the item Do you listen to music...
Slow update on temp table
I have a job running each night starting at 4:30AM and usually finishing at...
Table Partitioning - remove null range
hi guys, I have a partitioned table AM_ITM_INSTNC_MSS and I want to get...
Question of the Day
Read Only Replica in SQL Server Standard
Our environment runs using SQL Server Standard. We are implementing Availability groups. Our database has been experiencing high read volumes, so I want to let the application read the Synchronized Secondary replica, as I read that HADR does this. Can we implement this?
See possible answers