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,528 reads
Rajat Jaiswal-337252
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
957 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
899 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
814 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
936 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,521 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,136 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
687 reads
2016-03-29
486 reads
The Unconventional Guide to How to Implement Lookup Transformations TIP #124
This is one the articles in the series of step by step SSIS tutorial. In this post, we are going...
2015-12-20
834 reads
Blogs
Learn Better: Pause to Review More
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Azure SQL Managed Instance Next-Gen: Bring on the IOPS
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
SQL, MDX, DAX – the languages of data
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Forums
Two foreign keys to the same table. Can't cascade deletes.
Not sure if this is really a relational theory question but it seems about...
Connecting Power BI to SSAS and effective user not working
Hi everyone, Below is a consolidated summary of what we validated Architecture & data...
High Availability setup - has anyone seen this method?
Hi all, I recently moved to a new employer who have their HA setup...
Question of the Day
Encoding URLs
I have this data in a SQL Server 2025 table:
CREATE TABLE Response ( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY , ResponseVal VARBINARY(5000) ) GOIf I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use? See possible answers