Master database file or MDF file is a primary database file that contains fields, tables, indexes, stored procedures and other data in SQL Server. Like other data files, this file is also susceptible ...

description Tutorial on how to create a basic environment for Always Encrypted with Intel SGX enclaves in Azure SQL Database, how to encrypt data in-place, and issue rich confidential queries against ...

It's important to plan for security before you configure your replication topology. This tutorial shows you how to better secure a replication topology. It also shows you how to configure distribution ...

Azure SQL Database and the upcoming release of SQL Server introduce a novel database recovery mechanism that combines traditional ARIES recovery with multi-version concurrency control to achieve ...

There’s been a lot of discussion recently about autonomous databases, which offer the promise of keeping database systems stable and performant while alleviating much of the tuning and configuration ...

To satisfy compliance standards, internal regulations or basic security principles, applications often need to limit a user’s access to only certain rows of data in a database. For example: An oil and ...

In this tutorial we’re going to talk about compound clips, which are Final Cut Pro X’s version of nesting. It’s a way to take a handful of clips on a project and compress them down to a single file.

Using SQL Server Management Studio 2008, right-click on your database, select Reports then Standard Reports then choose Index Physical Statistics. This report will show fragmentation details for all ...