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,518 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
949 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
890 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
801 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
929 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,502 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,108 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
661 reads
2016-03-29
481 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
824 reads
Blogs
The Data API Builder Start and Add Extensions in VS Code
By Steve Jones
One of the things that I like about the Data API Builder (DAB) is...
Using OneLake for Excel Files in Microsoft Fabric
By DataOnWheels
Hey data friends! This blog is to discuss an edge case I’ve run into...
Another AI Faux Pax
By Steve Jones
I was experimenting with a local model (article) and as a part of this,...
Forums
AD, powershell and ssis
Hi, i have a requirement that involves visiting multiple folders in AD for active,...
File date from Extended Event .xel files
I know this, but I do not remember it. I have scoured by saved...
SSMS gets very messy
At work we have quite a few databases that I'm frequently browsing. This is...
Question of the Day
Sparse Column Defaults
What are the restrictions for defaults on columns declared as sparse?
See possible answers