Sites Microsoft


In-Memory OLTP in Standard and Express editions, with SQL Server 2016 SP1

Publié le 17 novembre 2016 sur Microsoft SQL Server database engine blog
 

We just announced the release of Service Pack 1 for SQL Server 2016. With SP1 we made a push to bring a consistent programming surface area across all editions of SQL Server. One of the outcomes is that In-Memory OLTP (aka Hekaton), the premier perform …

SQL Server 2016 SP1 brings new innovation opportunities to software partners

Publié le 17 novembre 2016 sur sql server team blog
 

Yesterday at Connect(); we announced SQL Server 2016 Service Pack 1 (SP1), which introduces a common programming surface across SQL Server editions. This move makes innovative database features such as in-memory performance across workloads, encryption …

CREATE OR ALTER – another great language enhancement in SQL Server 2016 SP1

Publié le 17 novembre 2016 sur Microsoft SQL Server database engine blog
 

We are happy to announce that SQL Server 2016 SP1 and SQL Server v.Next have new T-SQL language statement – CREATE [OR ALTER]. This statement combines CREATE and ALTER statements and creates object if it does not exist, or alter it if it is alrea …

Announcing the Next Generation of Databases and Data Lakes from Microsoft

Publié le 16 novembre 2016 sur sql server team blog
 

This post was authored by Joseph Sirosh, Corporate Vice President of the Microsoft Data Group. For the past two years, we’ve unveiled several of our cutting-edge technologies and innovative solutions at Connect(); which will be livestreaming glob …

SQL Server 2016 Service Pack 1 generally available

Publié le 16 novembre 2016 sur sql server team blog
 

Microsoft is pleased to announce the availability of SQL Server 2016 Service Pack 1 (SP1). With SQL Server 2016 SP1, we are making key innovations more accessible to developers and organizations across all SQL Server editions, so it will be easier than …

Announcing SQL Server on Linux public preview, first preview of next release of SQL Server

Publié le 16 novembre 2016 sur sql server team blog
 

This post was authored by Tiffany Wissner, Senior Director of Data Platform Marketing Today, we are excited to announce the public preview of the next release of SQL Server on Linux and Windows, which brings the power of SQL Server to both Windows …

SQL Server 2016 Service Pack 1 (SP1) released !!!

Publié le 16 novembre 2016 sur microsoft sql server release services
 

With cloud first strategy, the SQL Product Team has observed great success and adoption of SQL Server 2016 compared to any previous releases. Today, we are even more excited and pleased to announce the availability of SQL Server 2016 Service Pack 1 (SP …

Unable to drop a user in a database

Publié le 15 novembre 2016 sur css sql server engineers
 

A user called in for help because he wasn’t able to drop a user from a database.  The error message is below Msg 15136, Level 16, State 1, Line 2The database principal is set as the execution context of one or more procedures, functions, or …

Microsoft SQL Server team hosts Ask Me Anything session

Publié le 14 novembre 2016 sur sql server team blog
 

This post was authored by Vin Yu, Program Manager, Data Platform The Microsoft SQL Server team will host a special Ask Me Anything session on /r/SQLServer, Friday, November 18th, 2016 from 9:30 am to 2:00 pm PDT. AMA event opens up for questions on Thu …

Columnstore Index: Why do I need to create clustered columnstore Index on In-Memory OLTP- tables for Analytics?

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

Please refer to this blog under MSSQL Tiger Team blog site   Columnstore Index: Why do I need to create clustered columnstore Index on In-Memory OLTP- tables for Analytics? Thanks Sunil Agarwal

In-Memory OLTP: Is your database just in memory or actually optimized for memory?

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

Please refer to my blog under MSSQL Tiger Team blogs In-Memory OLTP: Is your database just in memory or actually optimized for memory? Thanks Sunil Agarwal

Columnstore Index: Which Columnstore Index is right for my workload?

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

Please refer to the following link for the blog that I posted under MSSQL Tiger Team Columnstore Index: Which Columnstore Index is right for my workload?   Thanks, Sunil Agarwal

Columnstore index: Why do we refer to it as In-Memory Analytics?

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

Fyi: I posted this blog under MSSQL Tiger Team blog site Columnstore index: Why do we refer to it as In-Memory Analytics? Thanks Sunil Agarwal

.Net 4.6.2. Framework client driver for Always Encrypted resulting in intermittent failures to decrypt individual rows

Publié le 5 novembre 2016 sur microsoft sql server release services
 

The SQL Product team has identified an issue with .Net 4.6.2 framework client driver for Always Encrypted enabled database on SQL Server 2016 and Azure SQL Database. The issue can lead to intermittent failure while trying to decrypt the records from th …


Pages :