Transparent Data Encryption (TDE) in SQL Server is a security feature that encrypts the entire database, ensuring that data files, log files, and backups are stored in an encrypted form on disk.

In SQL Server 2016, we saw the first release of PolyBase in the mainline SQL Server product. This supported access to Hadoop and Azure Blob Storage. With SQL Server 2019, the focus changed to ...

The goal is to ensure that data masking of a production database directly protects the database users outside of the production environment. Masking in SQL Server works by masking sensitive data to ...

In SQL Server Change Data Capture, change activities in a table such as delete, insert, and update are easily available in a relational format. All the required inputs necessary to track changes made ...

SQL Server Big Data Clusters (BDC) is a new capability brought to market as part of the SQL Server 2019 release. BDC extends SQL Server’s analytical capabilities beyond in-database processing of ...

Are you still running SQL Server 2005? We know it’s hard to let go, but it’s been 10 years. In its time SQL Server 2005 was a great choice for your departmental and mid-market IT needs. Over the last ...

Big Data Clusters make it easier for customers to manage a big data environment. Software Assurance customers are eligible for a grant of SQL Server Big Data Node Licenses for use with licenses ...

In SQL Server, the initial dialect for stored procedures (or stored procs) was Transact-SQL, aka T-SQL; in Oracle, it was PL-SQL. Both databases have added additional languages for stored ...

While SQL Server introduced support for JSON data in SQL Server 2016, it relied on using the non-optimized NVARCHAR(MAX) data type. While it worked, the functionality was limited, and performance ...