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,524 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
954 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
894 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
810 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
931 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,516 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,122 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
675 reads
2016-03-29
483 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
827 reads
Blogs
A Win in the Fight Against Cyber Scams
By Brian Kelley
Back in June I blogged about pig butchering and the amount of reported losses...
SQL Server I/O Bottlenecks: It’s Not Always the Disk’s Fault
By Kevin3NF
“SQL Server is slow.” We’ve all heard it. But that doesn’t always mean SQL...
Just a few weeks to PASS on Tour and the Redgate Summit
By Steve Jones
It’s just a few weeks until the PASS Summit on Tour in New York...
Forums
What the best ways to create an AG and do failovers with 8TB databases?
Hello. I've been working with AGs for a few years now. However, in my...
Deprecated but Forgotten: Why SQL Server’s Text, NText, and Image Data Types Still Haunt Your Systems
Comments posted to this topic are about the item Deprecated but Forgotten: Why SQL...
Why CQRS and Event Sourcing Are Gaining Ground in High-Concurrency Web Systems
Comments posted to this topic are about the item Why CQRS and Event Sourcing...
Question of the Day
Page Compression, Unique Identifiers and Speed
Would using a UNIQUEIDENTIFIER as a clustered primary key improves page compression and speeds up inserts compared to INT IDENTITY?