Monthly Archives: July 2017

How to Configure TDE database with AlwaysOn using the Azure Key Vault in SQL Server 2016

Posted on July 28, 2017 by Prashanth Jayaram

One of the recent tasks that I have undertaken seemed rather like an experiment to me. I set out to configure Transparent Data encryption (TDE) using asymmetric key protection with Azure Key Vault with AlwaysOn. That, to me, opened a … Continue reading →

Posted in AlwaysOn, SQL 2016, SQL AZURE | Leave a comment

How to analyze SQL Server database performance using T-SQL

Posted on July 10, 2017 by Prashanth Jayaram

The performance of a database is the most challenging and critical part of database optimization. The challenge every DBA faces is to identify theΒ most resource-intensive databases. This article talks about the natively available features that can accomplish the task of … Continue reading →

Posted in SQL Server 2017, sysfiles, T-SQL | Leave a comment

SQL Server 2017

Posted on July 6, 2017 by Prashanth Jayaram

Top String Functions Machine Learning – Python Integration Resumable Index Operations   Happy Learning!!

Posted in SQL Server 2017 | Leave a comment