Sites Microsoft


Columnstore Index: Parallel load into clustered columnstore index from staging table

Publié le 19 juillet 2016 sur Microsoft SQL Server database engine blog
 

SQL Server has supported parallel data load into a table using BCP, Bulk Insert and SSIS. The picture below shows a typical configuration of a Data Warehouse where data is loaded from external files either using BCP or SSIS. SQL Server supports paralle …

SQL Server 2016 posts world record TPC-H 10 TB benchmark

Publié le 18 juillet 2016 sur sql server team blog
 

SQL Server 2016 delivers unparalleled performance and security built-in for your most mission critical transactional systems and data warehouses, along with an integrated business intelligence and advanced analytics solution for building intelligent ap …

Columnstore Index: Differences between Clustered/Nonclustered Columnstore Index

Publié le 18 juillet 2016 sur Microsoft SQL Server database engine blog
 

SQL Server 2016 provides flavors of columnstore index; clustered (CCI) and nonclustered (NCCI) columnstore index. As shown in the simplified picture below, both indexes are organized as columns but NCCI is created on an existing rowstore table as shown …

Columnstore Index – BTree index vs Columnstore Index

Publié le 18 juillet 2016 sur Microsoft SQL Server database engine blog
 

In earlier blog why columnstore index, we had discussed what is a columnstore index and why do we need it. The columnstore storage model in SQL Server 2016 comes in two flavors; Clustered Columnstore Index (CCI) and Nonclustered Columnstore Index (NCCI …

Microsoft JDBC Driver 6.0 for SQL Server is now released!

Publié le 14 juillet 2016 sur sql server team blog
 

This post was authored by Andrea Lam, Program Manager, SQL Server. We are pleased to announce the full release of the Microsoft JDBC Driver 6.0 for SQL Server! The updated driver provides robust data access to Microsoft SQL Server and Microsoft Azure S …

The SQL Server Basic Installer: Just Install It!

Publié le 13 juillet 2016 sur microsoft sql server release services
 

20+ years ago when I joined Microsoft I was handed a diskette (maybe it was two), and was told “Here is SQL Server. Go install it”. So I proceeded to install SQL Server 4.20 on my Windows NT 3.1 desktop machine (I won’t tell you the h …

Why am I getting NULL values for query_plan from sys.dm_exec_query_plan?

Publié le 13 juillet 2016 sur css sql server engineers
 

Recently we got a customer who called in and wanted to know why he received NULL for query_plan when querying sys.dm_exec_query_plan.   This customer referenced a blog from https://dzone.com/articles/dmexecqueryplan-returning-null.  In t …

SQL Server 2014 SP2 is now available

Publié le 12 juillet 2016 sur sql server team blog
 

The SQL Server team is excited to bring you SQL Server 2014 Service Pack 2 (SP2). This service pack is available on the Microsoft Download Center and will also be available on MSDN, MBS/Partner Source and VLSC in the coming weeks. As part of …

The elastic future of data warehousing

Publié le 12 juillet 2016 sur sql server team blog
 

This post was authored by Joseph Sirosh, Corporate Vice President, Data Group. Announcing the general availability of Azure SQL Data Warehouse, an elastic, parallel, columnar data warehouse as a service. A defining characteristic of cloud computing is …

Always Encrypted in Azure SQL Database is Generally Available

Publié le 11 juillet 2016 sur sql server security blog
 

I’m happy to announce Always Encrypted in Azure SQL Database is now generally available! Always Encrypted is a feature designed to ensure sensitive data and its corresponding encryption keys are never revealed in plaintext to the database sy …

Why do I get the infrastructure error for login failures?

Publié le 9 juillet 2016 sur css sql server engineers
 

In the past few weeks, I saw this error come across quite a bit and thought I will provide an explanation for the reasons why we generate this error. It is very possible that you came across either one of the flavors of the two error messages shown bel …

Tips & Tricks on ‘cloning’ Azure SQL virtual machines from captured images

Publié le 6 juillet 2016 sur css sql server engineers
 

While we have documentation on how to create a VM from captured image under “How to capture a Windows virtual machine in the Resource Manager deployment model”, it doesn’t address some specifics on SQL Server.  We have seen more …

Developing Databases using Always Encrypted with SQL Server Data Tools

Publié le 5 juillet 2016 sur sql server security blog
 

We are excited to announce that SQL Server Data Tools (SSDT) now supports developing databases using Always Encrypted. Always Encrypted is a feature in SQL Server 2016 and Azure SQL Database that ensures your sensitive data is never revealed in plainte …

Announcing SQL Server Management Studio – July 2016 Release

Publié le 1 juillet 2016 sur microsoft sql server release services
 

Today, we are very pleased to announce the first monthly update of SQL Server Management Studio (SSMS) following the SQL Server 2016 release. This update remains a fully-supported generally-available (GA) quality release. It includes support for Azure …


Pages :