Start Here

Get in touch with a
TriCore Solutions specialist


Blog | Jun 14, 2017

Deprecated & Discontinued Database Engine Features in SQL Server 2016

Posted by Anil Kumar

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.

Read More

Blog | Apr 20, 2017

Dynamic Data Masking in SQL Server 2016

Posted by Vishal Srivastava

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. 

Read More

Blog | Sep 7, 2016

Overview of Query Store Feature---SQL Server 2016

Posted by Vaibhav Mishra

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.
Read More

Blog | Jun 14, 2016

SQL Server 2016 Installation Enhancements

Posted by Satya Prakash

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.
Read More

Blog | May 26, 2016

Resolving Blocking in SQL Server

Posted by Manish Shukla

Users who access a resource at the same time are said to be accessing the resource concurrently. Concurrent data access requires mechanisms to prevent adverse effects when multiple users try to modify resources that are actively being used by other users.
Read More

Blog | May 5, 2016

Tryst with SQLSaturday #482 – Nepal Chapter 2016

Posted by Smriti Jain

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.
Read More

Blog | Jan 18, 2016

Delayed Durability- Diminishes I/O throughput to improve performance in the SQL Query!

Posted by Anil Kumar

It is very clear that you can get significant performance benefit from the Delayed Durability if you can tolerate Data loss. 

Read More

Blog | May 21, 2015

SQL Server Performance Troubleshooting – Missing Indexes

Posted by Bob Lane

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.

Read More

Blog | May 19, 2015

SQL SERVER RESOURCE BOTTLENECK – CPU -The First in a Four Part Series.

Posted by Vikas Agarwal

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.

Read More

Blog | May 13, 2015

Understanding Backups with SQL Server AlwaysOn High Availability Mirrors

Posted by Jeremy Johns


Read More