New & Notable


Do memory-optimized tables perform better than 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.


In-memory OLTP improved in SQL Server 2016

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

Get Started

How to set up dynamic data masking in SQL Server 2016

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.


Three steps to using 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.

Have a question for an expert?

Please add a title for your question

Get answers from your peers on your most technical SQL Server challenges.

You will be able to add details on the next page.

Find Solutions For Your Project

SQL Server Basics

View All Get Started

Blog: SQL Server with Mr. Denny

Sections from across SearchSQLServer

  • News

    View All
  • SQL Server Data Warehousing

    Massively parallel processing reaches the cloud

    Microsoft opened the preview of Azure SQL Data Warehouse, a petabyte-scale, distributed columnar data warehouse service with massively parallel processing.

  • SQL Server Migration Strategies and Planning

    New features announced for SQL Server 2016

    Microsoft CEO Satya Nadella announced the SQL Server 2016 preview for this summer. Its new features model the ethos of "mobile first, cloud first."

  • Microsoft SQL Server Consolidation and Virtualization

    SQL Server advances unveiled at PASS 2014

    Microsoft previewed a cloud database update and highlighted three new analytics applications at PASS 2014, reflecting its idea of using data to 'understand the past, analyze the present and predict the future.