Sites Microsoft


Cumulative Update #10 for SQL Server 2016 SP1

Publié le 17 juillet 2018 sur microsoft sql server release services
 

The 10th cumulative update release for SQL Server 2016 SP1 is now available for download at the Microsoft Downloads site. Please note that registration is no longer required to download Cumulative updates. To learn more about the release or servicing m …

Cumulative Update #2 for SQL Server 2016 SP2

Publié le 17 juillet 2018 sur microsoft sql server release services
 

The 2nd cumulative update release for SQL Server 2016 SP2 is now available for download at the Microsoft Downloads site. Please note that registration is no longer required to download Cumulative updates. To learn more about the release or servicing mo …

Approximate Count Distinct enters Public Preview in Azure SQL Database

Publié le 16 juillet 2018 sur Microsoft SQL Server database engine blog
 

Kevin Farlee Principal Program Manager, SQL Database We are pleased to announce the public preview of Approximate Count Distinct, the first of the Approximate Query Processing features.  Approximate Query Processing is a new family of features whi …

Public Preview of MATCH support in MERGE DML for Graph tables in Azure SQL Database

Publié le 16 juillet 2018 sur Microsoft SQL Server database engine blog
 

SQL Server 2017 and Azure SQL Database introduced native graph database capabilities used to model many-to-many relationships. The first implementation of SQL Graph introduced support for edges to represent relationships, nodes to represent entities an …

Public Preview of Row Mode Memory Grant Feedback in Azure SQL Database

Publié le 16 juillet 2018 sur Microsoft SQL Server database engine blog
 

Last year SQL Server 2017 and Azure SQL Database introduced query processing improvements that adapt optimization strategies to your application workload’s runtime conditions. These improvements included: batch mode adaptive joins, batch mode mem …

Public Preview of Table Variable Deferred Compilation in Azure SQL Database

Publié le 16 juillet 2018 sur Microsoft SQL Server database engine blog
 

Last year SQL Server 2017 and Azure SQL Database introduced query processing improvements that adapt optimization strategies to your application workload’s runtime conditions. These improvements included: batch mode adaptive joins, batch mod …

Validate your Azure network environment for SQL Managed Instance

Publié le 12 juillet 2018 sur Microsoft SQL Server database engine blog
 

Azure SQL Managed Instance is a fully managed PaaS SQL Server Database Engine hosted in Azure cloud that is placed in Azure Virtual network, and you need to ensure that your network is properly configured. In this post your will see a PowerShell script …

SQL Server 2008 end of support is the first step to tomorrow’s database

Publié le 12 juillet 2018 sur sql server team blog
 

Today, Takeshi Numoto blogged about the upcoming SQL Server 2008 and 2008 R2 end of support. If youve been thinking about what to do with your SQL Server 2008 and 2008 R2 databases, youre not alone. These databases reach end of support on July 9, 2019, …

Released: Public Preview for Version Agnostic SQL Server MP (2012-2017)

Publié le 10 juillet 2018 sur microsoft sql server release services
 

Adding Support for SQL Server 2012, 2014, 2016 Monitoring in the Version Agnostic SQL Server Management Pack We moved to version agnostic management packs with SQL Server 2017+ MP. That is, 2017+ MP is built to monitor SQL Server versions 2017 and up. …

SQL Server 2008 and 2008 R2 are reaching end of support. What’s next?

Publié le 6 juillet 2018 sur sql server team blog
 

SQL Server 2008 and 2008 R2 have had a tremendous run. But all good things come to an end, right? On July 9, 2019, Microsoft will end Extended Support, which means no more updates or support of any kind, potentially leaving you vulnerable to security a …

Using custom types as arrays in T-SQL

Publié le 6 juillet 2018 sur Microsoft SQL Server database engine blog
 

One of the missing language features in T-SQL language is array support. In some cases you can use custom types to work with arrays that are passed as parameters to your stored procedures. Custom types in T-SQL enable you to create alias for some table …

June 2018 Leaderboard of Database Systems contributors on MSDN

Publié le 5 juillet 2018 sur Microsoft SQL Server database engine blog
 

Congratulations to our June top 10 contributors! Alberto Morillo and Visakh Murukesan maintain their top positions. This Leaderboard initiative was started in October 2016 to recognize the top Database Systems contributors on MSDN forums. The …

PowerShell cmdlets for managing SQL Vulnerability Assessments

Publié le 5 juillet 2018 sur sql server security blog
 

We are pleased to announce the availability of PowerShell cmdlets for managing SQL Vulnerability Assessments for your SQL Servers. The cmdlets can be used to run assessments programmatically, export the results and manage baselines. They enable the sce …

Released: Public Preview for SSAS and SSRS 2017+ Management Packs (7.0.8.0)

Publié le 4 juillet 2018 sur microsoft sql server release services
 

We are getting ready to release brand new management packs for SQL Server Analysis Services and SQL Server Reporting Services 2017. Please install and use this public preview and send us your feedback (sqlmpsfeedback@microsoft.com)! We apprec …


Pages :