Full and Transaction Log Backups with media password are already obsolete however we can restore backups with media password in SQL Server 2016. This feature will be condemned in future release.
Blog | Jun 14, 2017
Blog | Apr 20, 2017
Dynamic data masking helps prevent unauthorized access to sensitive data by enabling customers to designate how much of the sensitive data to reveal with minimal impact on the application layer. DDM can be configured on the database to hide sensitive data as the result sets of queries over designated database fields, while the data in the database is not changed.
Blog | Sep 7, 2016
Query Store Feature helps a great deal in simplifying performance troubleshooting by helping you to quickly find performance differences. This feature is available in all the editions of SQL Server 2016.
Blog | Jun 14, 2016
Every new version of SQL Server Microsoft is getting better and better with new features making it a better choice among other data platforms. With the new installation features installation is more configurable.
Blog | May 26, 2016
Blog | May 5, 2016
TriCore employees have participated in earlier US chapters however it was for the first time that Satya Prakash, Associate Practice Manager at TriCore’s Gurgaon location office participated and presented this year. The event took place on March 26 at Kathmandu in Nepal.
Blog | Jan 18, 2016
It is very clear that you can get significant performance benefit from the Delayed Durability if you can tolerate Data loss.
Blog | May 21, 2015
Starting with SQL Server 2005, Microsoft introduced Dynamic Management Views (DMVs). DMVs return information which can be helpful in diagnosing and correcting performance issues. While there is a lot of information that can be found in the DMVs, this article will focus on identifying missing indexes.
Blog | May 19, 2015
One of the most common errors a DBA encounters is related to a “Slow Server Response Time”. This blog will help DBAs understand this error better and how to overcome it. To start with, a DBA needs to know that this problem can lie within memory, IO, CPU or TempDB.
Blog | May 13, 2015