Released: New SQL Server Dashboards Management Pack and System Center Management Pack for Analysis Services and Reporting Services (6.6.7.6)
We are happy to announce that new versions of Analysis Services and Reporting Services Management Packs have been released! We are also releasing a new SQL Server Dashboards Management Pack that includes the dashboard components you are used to getting …
Release of SQL Server 2016 Upgrade Advisor Preview 1.4
SQL Server 2016 Upgrade Advisor Preview is a standalone tool that enables users of prior versions of SQL Server to identify what they need to do to upgrade their SQL Server database to a more recent version of SQL Server. By running an upgrade assessme …
SQL 2016 – It Just Runs Faster: TVPs with Spatial Column(s)
Table Valued Parameters (TVPs) containing spatial columns can be used as input parameter(s) to stored procedures. SQL Server 2016 improves the scalability, using native spatial validation(s), increasing performance by 15 times or more. TVP …
Columnstore Index Merge Policy for REORGANIZE
In the blog https://blogs.msdn.microsoft.com/sqlserverstorageengine/2016/03/07/columnstore-index-defragmentation-using-reorganize-command/ , we discussed how REORGANIZE command can be used to defragment a columnstore index. In this blog, we will …
Announcing SQL Server on Linux
Today, we announced our plans to bring SQL Server to Linux. This will enable SQL Server to deliver a consistent data platform across Windows Server and Linux, as well as on-premises and cloud. We are bringing the core relational database capabilities t …
Announcing SQL Server Management Studio – February 2016 Release
Today, we are very pleased to announce the latest preview of SQL Server Management Studio (SSMS). This release includes all updates included in the January release, and features improved support for high contrast settings in the SSMS activity monitor, …
First release candidate of SQL Server 2016 now available
We are excited to announce that our first SQL Server 2016 release candidate, SQL Server 2016 Release Candidate (RC) 0, is now available for download. This is an important milestone in the release of SQL Server 2016, as this marks feature completion for …
Technical Overview: SQL Server 2016 Release Candidate 0
The SQL Server engineering team is pleased to announce the availability of SQL Server 2016 Release Candidate 0. This is an important milestone in the release of SQL Server 2016, as it marks feature completion for most dimensions of the product and mean …
SQL Server Data Tools Preview update for Feb 2016
The SQL Server Data Tools team is pleased to announce an update for SSDT Preview is now available. The SSDT Preview update for Feb 2016 enables SSIS one-designer support for SQL Server 2012 and SQL Server 2014 in Visual Studio 2015. This will allow you …
Announcing SQL Server Stretch Database service preview
Microsoft is pleased to announce a preview of the new SQL Server Stretch Database service. With this preview, SQL Server 2016 users can dynamically stretch their on-premises warm and cold data to an Azure service that is engineered from the g …
Columnstore Index Defragmentation using REORGANIZE Command
Columnstore index, both clustered and nonclustered, can get fragmented like any other index. SQL Server 2016 allows customer to defragment this index using the familiar ALTER INDEX <index-name> REORGANIZE command instead of using a heavy hammer a …
Real-Time Operational Analytics: Memory-Optimized Tables and Columnstore Index
SQL Server 2016 supports real-time operational analytics both for disk-based (i.e. traditional tables) and memory-optimized tables without requiring any changes to your transactional workload. For disk-based tables, you can do it by creating a nonclust …
Real-Time Operational Analytics: Compression Delay option with NCCI and the performance
The previous blog https://blogs.msdn.microsoft.com/sqlserverstorageengine/2016/03/06/real-time-operational-analytics-compression-delay-option-for-nonclustered-columnstore-index-ncci/ showed the scenario and benefits of compression-delay option …
Real-Time Operational Analytics: Compression Delay Option for Nonclustered Columnstore Index (NCCI)
The previous blog https://blogs.msdn.microsoft.com/sqlserverstorageengine/2016/03/06/real-time-operational-analytics-filtered-nonclustered-columnstore-index-ncci/ showed how filtered nonclustered columnstore index (NCCI) can be used to …