Sites Microsoft


New Azure SQL Database offerings add capabilities to scale data up and out

Publié le 27 août 2015 sur sql server team blog
 

Tiffany Wissner, Senior Director of Data Platform MarketingAt Microsoft we’re committed to meeting the needs of our customers by offering choices as they build cloud applications for scale and performance. Today we’re continuing to deliver …

Row-Level Security for Azure SQL Database is Generally Available

Publié le 19 août 2015 sur sql server security blog
 

Row-Level Security (RLS) for Azure SQL Database is now generally available. RLS enables you to store data for many users in a single database and table, while at the same time restricting row-level access based on a user’s identity, role, or execu …

Cumulative Update #2 for SQL Server 2014 SP1

Publié le 18 août 2015 sur microsoft sql server release services
 

Dear Customers, The second cumulative update release for SQL Server 2014 SP1 is now available for download at the Microsoft Support site. Cumulative Update 2 contains all the SQL Server 2014 SP1 hotfixes. To learn more about the release or servicing… …

Cumulative Update #9 for SQL Server 2014 RTM

Publié le 18 août 2015 sur microsoft sql server release services
 

Dear Customers, The 9 th cumulative update release for SQL Server 2014 RTM is now available for download at the Microsoft Support site. Cumulative Update 9 contains all the SQL Server 2014 RTM hotfixes which have been available since the initial releas …

SQL 2016: Columnstore row group Merge policy and index maintenance improvements

Publié le 17 août 2015 sur SQL Customer Avisory Team
 

                A Columnstore index contains row groups that can that have a maximum of 1,048,576 rows. A row group can be closed and compressed due to multiple reasons before that m …

Always Encrypted Key rotation – Column master Key rotation.

Publié le 13 août 2015 sur sql server security blog
 

 Many standards that are used to regulate data security define key rotation requirements in order to meet compliance. In many cases, there are defined regulations that distinguish between the key-encrypting keys (KEK) and data-encrypting keys (DEK …

Using the SSMS ConnectionDialog

Publié le 12 août 2015 sur css sql server engineers
 

I was attempting to add the SSMS connection dialog to my utility and ran into problems with referenced assemblies. The ConnectionDialog is documented here: https://msdn.microsoft.com/en-us/library/microsoft.sqlserver.management.ui.connectiondlg.aspx Th …

Yes, You Really Can

Publié le 11 août 2015 sur sql server security blog
 

I thought today would be a good day to remind you about Microsoft’s stance on customer validation of the security of our online services. In addition to the numerous certifications and audits performed on our services, Microsoft has a bug bounty p …

Choosing hash distributed table vs. round-robin distributed table in Azure SQL DW Service

Publié le 11 août 2015 sur SQL Customer Avisory Team
 

This topic explains the various Azure SQL Data Warehouse distributed table types, and offers guidance for choosing the type of distributed table to use and when. There are two types of distributed tables in Azure SQL DW at the writing of this article, …

Eliciting your feedback about upgrading SQL Server

Publié le 7 août 2015 sur microsoft sql server release services
 

SQL Server DBAs – The SQL Server engineering team needs you and your input! We’re running a high-velocity planning program about upgrading SQL Server and this process is literally driven on your feedback. Don’t think you need a super-sized…(read more …


Pages :