Sites Microsoft


Released: Microsoft Azure SQL Database Management Pack (6.7.28.0)

Publié le 10 mai 2017 sur microsoft sql server release services
 

We are happy to announce the release of Azure SQL DB Management Pack! We have significantly enhanced the feature set in this release. Some of the highlights are support for Azure AD authentication, health monitoring for database geo replication, health …

Announcing Power BI Report Server

Publié le 3 mai 2017 sur sql server team blog
 

This post was authored by the Power BI Team Today Microsoft announced Power BI Premium — a capacity-based licensing model that increases flexibility for how users access, share and distribute content in Power BI. The new offering also introduces …

Threat Detection in Azure SQL Database is now Generally Available

Publié le 3 mai 2017 sur sql server security blog
 

We are excited to announce that Threat Detection is now Generally Available in Azure SQL Database. Threat Detection detects anomalous activities indicating unusual and potentially harmful attempts to access or exploit databases. Threat Detection levera …

Newly created Azure SQL databases will be encrypted at rest by default

Publié le 3 mai 2017 sur sql server security blog
 

Earlier today, we announced that all new Azure SQL databases will be encrypted with Transparent Data Encryption (TDE) by default, to make it easier for everyone to benefit from encryption at rest. The change in default will happen gradually by region. …

A Stand Out Performance by KillaDBA

Publié le 1 mai 2017 sur sql server team blog
 

This post was authored by Nikki Thomas Two weeks ago, we welcomed special guest performer Homer McEwen (aka KillaDBA) to SQL Saturday. The database administrator from Atlanta writes and records songs about SQL Server to help others gain a better unders …

SQL Server community-driven enhancements in SQL Server 2017

Publié le 28 avril 2017 sur sql server team blog
 

This post was authored by the SQL Server Tiger Team Although SQL Server 2016 runs faster, SQL Server 2017 promises to run even faster and empower customers to run smarter with intelligent database features like the ability to run advanced analytics usi …

Certificate-based authentication for Azure SQL DB using Azure Active Directory with recent Azure RM PowerShell version

Publié le 25 avril 2017 sur sql server security blog
 

This is a new version of the previous blog on Token-based authentication (see https://blogs.msdn.microsoft.com/sqlsecurity/2016/02/09/token-based-authentication-support-for-azure-sql-db-using-azure-ad-auth/ ) updated to accommodate recent Azure RM Powe …

Get to cloud faster with a new database migration service private preview

Publié le 25 avril 2017 sur sql server team blog
 

  Last week at the Microsoft Data Amp online event, Microsoft announced a private preview for a new database migration service that will streamline the process for migrating on-premises databases to Azure. Using this new database migration service …

“You Shall Not Regress!!!” – How SQL Server 2017 prevents plan regressions?

Publié le 25 avril 2017 sur Microsoft SQL Server database engine blog
 

SQL plan regression is a case when a T-SQL query that executed fine becomes much slower or uses more resources because the underlying SQL plan changed. SQL Server 2017 would not allow that kind of regressions if you enable new automatic tuning feature …

How to find query plan choice regressions with SQL Server 2017 CTP2

Publié le 24 avril 2017 sur Microsoft SQL Server database engine blog
 

SQL Server 2017 in CTP2.0  version automatically identifies potential performance regressions in SQL queries, enables you to easily find potential issues, and gives you information what should you do to fix the issue. In CTP2.0 version is added ne …

Released: Public Preview for SQL Server vNext Replication Management Pack (6.7.40.0)

Publié le 21 avril 2017 sur microsoft sql server release services
 

We are happy to announce that public preview for SQL Server vNext Replication Management Pack is ready. Please install and use this public preview and send us your feedback (sqlmpsfeedback@microsoft.com). You can download the public preview at: ht …

Graph Data Processing with SQL Server 2017

Publié le 20 avril 2017 sur sql server team blog
 

SQL Server is trusted by many customers for enterprise-grade, mission-critical workloads that store and process large volumes of data. Technologies like in-memory OLTP and columnstore have also helped our customers to improve application performance ma …

Resumable Online Index Rebuild is in public preview for SQL Server 2017 CTP 2.0

Publié le 20 avril 2017 sur sql server team blog
 

We are delighted to announce that Resumable Online Index Rebuild is now available for public preview in the SQL Server vNext 2017 CTP 2.0 release. With this feature, you can resume a paused index rebuild operation from where the rebuild operation was p …

Introducing Interleaved Execution for Multi-Statement Table Valued Functions

Publié le 20 avril 2017 sur Microsoft SQL Server database engine blog
 

For SQL Server vNext and Azure SQL Database, the Microsoft Query Processing team is introducing a new set of adaptive query processing improvements to help fix performance issues that are due to poor cardinality estimates. Improvements in the adaptive …


Pages :