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,529 reads
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,529 reads
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
958 reads
Data security is always one of the important points which can not be ignored. Nowadays if you are working for...
2016-11-27
900 reads
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
In the Series of SQL SERVER 2016, this is another post. Before Jumping in detail just think if you have...
2016-10-22
938 reads
This is another article in the series of SQL SERVER 2016 Journey . I am pretty much sure you might aware...
2016-10-16
1,523 reads
In the Series of SQL SERVER 2016 journey, this is our new article. In this article, we are sharing a...
2016-10-15
1,138 reads
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
488 reads
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,537 reads
Next Monday, March 9, 2026, my one-day live online training SQL Server 2025 Unleashed:...
By HeyMo0sh
As someone who’s worked with data for over 20 years and with many cloud...
By HeyMo0sh
2025 belongs to the AI startups. If you peek into the tech headlines, you’ll...
Comments posted to this topic are about the item A Quick Restore
Comments posted to this topic are about the item Guarding Against SQL Injection at...
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers