Tips

Tips

• 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

• Built-in tools for monitoring and optimizing OLAP cubes

  Optimizing online analytical processing performance is critical. Fortunately, tools are available to help monitor and improve how OLAP cubes perform.  Continue Reading

• Seven reasons to upgrade to SQL Server 2012

  Support for early versions of SQL Server has ended. But rather than upgrade to SQL Server 2014, companies are turning to SQL Server 2012. Here is why.  Continue Reading

• Top four tips for virtualizing your SQL Server instance

  The increasing need for SQL Server instances is raising costs. Basit Farooq shows you how to control the costs through effective virtualization.  Continue Reading

• The dark side of Microsoft SQL Server Express

  Don Jones explains why Microsoft SQL Server Express can be more dangerous than you'd think and why it might be worth it to invest in the paid edition.  Continue Reading

• Five tips to avoid a performance bottleneck or other SQL Server snares

  Basit Farooq provides five tips for SQL Server users, from avoiding a hardware performance bottleneck to dealing with database design.  Continue Reading

• Using Power BI to enhance SQL Server self-service business intelligence

  SQL Server DBAs and developers should be familiar with Power BI for Office 365. Here's an overview of what it does and how to use it.  Continue Reading