Sites Microsoft


Released: New SQL Server Dashboards Management Pack and System Center Management Pack for Analysis Services and Reporting Services (6.6.7.6)

Publié le 10 mars 2016 sur microsoft sql server release services
 

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

Publié le 9 mars 2016 sur microsoft sql server release services
 

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)

Publié le 8 mars 2016 sur css sql server engineers
 

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

Publié le 8 mars 2016 sur Microsoft SQL Server database engine blog
 

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

Publié le 7 mars 2016 sur sql server team blog
 

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

Publié le 7 mars 2016 sur microsoft sql server release services
 

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

Publié le 7 mars 2016 sur sql server team blog
 

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

Publié le 7 mars 2016 sur sql server team blog
 

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

Publié le 7 mars 2016 sur sql server data tools team blog
 

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

Publié le 7 mars 2016 sur sql server team blog
 

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

Publié le 7 mars 2016 sur Microsoft SQL Server database engine blog
 

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

Publié le 7 mars 2016 sur Microsoft SQL Server database engine blog
 

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

Publié le 6 mars 2016 sur Microsoft SQL Server database engine blog
 

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)

Publié le 6 mars 2016 sur Microsoft SQL Server database engine blog
 

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 …


Pages :