Chirag Shah

Backup Compression, TDE, and MaxTransferSize

This blog describes enhancement in SQL 2019 for TDE enabled databases in which MaxTransferSize is no longer required. Backup Compression and Transparent Data Encryption (TDE) have been two valuable features for customers using SQL Server. In version of SQL Server prior to SQL Server 2016 for TDE enabled databases – specifying WITH COMPRESSION had no […]

Backup Compression, TDE, and MaxTransferSize Continue Reading

Establishing Linked Server to SQL Server using MSOLEDB Driver

Technical Reviewer:  Krishnakumar Rukmangathan – Support Escalation Engineer, SQL Server BI Developer team, Microsoft Troy Moen –  Sr. Escalation Engineer  Linked server enable the SQL Server Database Engine to read data from remote data sources and execute commands against remote database servers. This particular blog will discuss how to leverage the new MSOLEDB driver to

Establishing Linked Server to SQL Server using MSOLEDB Driver Continue Reading