Tips

Tips

• Introducing DBCC CHECKDB for Analysis Services 2016

  DBCC CHECKDB, a long-awaited feature for SQL Server Analysis Services, provides the ability to perform database consistency checks against tabular and multidimensional databases.  Continue Reading

• Upgrade SQL Server 2014 SP1 in eight steps

  Upgrade from SQL Server 2008 R2 to SQL Server 2014 SP1 using backup and restore. This eight-step plan takes you through everything from log backups to end-to-end testing.  Continue Reading

• In-memory OLTP reborn with SQL Server 2016

  Microsoft's in-memory OLTP needed improvements, and they are here with SQL Server 2016. Learn about the enhancements to this query-boosting feature.  Continue Reading

• Comparing memory-optimized tables and disk-based tables

  In all tests performed by expert Basit Farooq, memory-optimized tables outperformed disk-based tables by running faster and generating less disk I/O.  Continue Reading

• SQL Server 2016 addresses in-memory OLTP limitations

  Once hampered by limitations, in-memory OLTP will be more robust and complete in SQL Server 2016. Learn about the improvements.  Continue Reading

• An introduction to SQL Server 2016 dynamic data masking

  An expert provides a step-by-step guide for how to use dynamic data masking in SQL Server 2016 CTP2 and Azure SQL database to protect sensitive data.  Continue Reading

• How to set up the new SQL Server data encryption feature

  If you're tired of decrypting data to perform operations on it, the new SQL Server data encryption feature Always Encrypted may be the answer.  Continue Reading

• Understanding the Microsoft Sync Framework

  An expert explains the Microsoft Sync Framework, a platform for synchronizing heterogeneous data distributed across applications, services and devices.  Continue Reading

• Microsoft Azure Blob Storage database backup and restore

  With Microsoft Azure Blob Storage Service, you can easily perform database backup and restore. Here is a step-by-step approach to using the service.  Continue Reading

• Two ways to encrypt database backups with SQL Server

  SQL Server 2014 provides two features that let database administrators easily encrypt database backups. An expert provides two demos that show you how.  Continue Reading

• Top three third-party SQL Server security auditing tools

  For most companies, SQL Server's security auditing tools aren't always enough to meet regulation requirements. The answer is third-party products.  Continue Reading

• A look at StretchDB, a new feature in SQL Server 2016

  Stretch Database, a new feature in SQL Server 2016 often called StretchDB, lets companies "stretch" their databases to store infrequently used data in the cloud while keeping heavily used data on-premises.  Continue Reading

• Use Transparent Data Encryption to protect data at rest

  Transparent Data Encryption (TDE) is an effective tool for encrypting data at rest. An expert walks you through the features and future of TDE.  Continue Reading

• SQL Server, Hadoop both part of Analytics Platform System

  A need for data warehouses designed for large-volume data loading and complex analytical workloads led to Microsoft's Analytics Platform System.  Continue Reading

• Introducing row-level security in Azure SQL databases

  Row-level security, a new feature for Azure SQL databases, helps Microsoft database platforms get to the same level as Oracle and DB2.  Continue Reading