Sites Microsoft


The case of the filter predicate with window functions such as ROW_NUMBER and RANK

Publié le 25 avril 2019 sur SQL Server Support Blog
 

I recently helped troubleshoot a query performance issue that involved the window function « ROW_NUMBER ». The running theory was that the query’s filter predicate should target the index resulting in a seek, but was instead applied via a Filter op …

SQL Server Management Studio (SSMS) 18.0 released for general availability

Publié le 24 avril 2019 sur sql server team blog
 

When I joined the SQL Tools team as a PM back in October 2018, my top priority was to release SQL Server Management Studio (SSMS) 18. I expected a fair amount of work but didnt realize how complicated the process would be. 6 months later, having passed …

SQL Server 2019 community technology preview 2.5 is now available

Publié le 24 avril 2019 sur sql server team blog
 

Were excited to announce the monthly release of SQL Server 2019 community technology preview (CTP) 2.5. SQL Server 2019 is the first release of SQL Server to closely integrate Apache Spark and the Hadoop Distributed File System (HDFS) with SQL Server i …

The April release of Azure Data Studio is now available

Publié le 18 avril 2019 sur sql server team blog
 

We are excited to announce the April release of Azure Data Studio (formerly known as SQL Operations Studio) is now available. Download Azure Data Studioand review the Release notes to get started. Please note: After downloading Azure Data Studio, say Y …

Automated machine learning from SQL Server with Azure Machine Learning

Publié le 16 avril 2019 sur sql server team blog
 

This post was co-authored by Jeff Shepherd, Deepak Mukunthu, and Vijay Aski. Recently, we blogged about performing automated machine learning on SQL Server 2019 big data clusters. In todays post, we will present a complementary automated machine learni …

3 ways to gain insights with SQL Server 2019 big data clusters

Publié le 15 avril 2019 sur sql server team blog
 

Businesses today are faced with the challenge of staying profitable and investing in future innovations. Speed and flexibility are the name of the game, and effective data-scaling techniques are highly sought after. Yet exploding data volumes, diverse …

SSIS – Package Installation Wizard – Next button grayed out

Publié le 9 avril 2019 sur SQL Server Support Blog
 

Issue:   Recently I came across an issue where the Next button for the Package Installation Wizard doesn’t come-up (or) it is grayed out.    Please refer the below screenshot:   Resolution:   We went ahead and registered the be …

SSIS – Always on AG (Availability Group) and Error – Please Create a Master Key

Publié le 9 avril 2019 sur SQL Server Support Blog
 

In this blog, I would like to address one of the issues that I came across recently with the SQL Server Integration services package execution in SQL always on environment.   In this scenario, to use SSIS with Always On, you have added the SSISDB …

JDBC Connections fails with « The driver could not establish a secure connection to SQL Server…. »

Publié le 9 avril 2019 sur SQL Server Support Blog
 

Issue:   While working on customer issue recently, I came across following scenario where there was a problem in connecting to the SQL Server from the IBM Java application (JDK 1.7) if we enable only TLS 1.2 protocol on both SQL and Application se …

SQL-SQL linked server connections fails after applying latest windows security patches .

Publié le 3 avril 2019 sur SQL Server Support Blog
 

Symptoms SQL-SQL linked server connections and distributed query execution fails due to an error message NT AUTHORITYANONOYMOUS LOGON after installing Windows security patches that are released in March 2019 SQL linked server connection initiated from …

How to develop and submit Spark jobs to SQL Server Big Data Clusters in IntelliJ

Publié le 1 avril 2019 sur sql server team blog
 

Were delighted to release the Azure Toolkit for IntelliJ support for SQL Server Big Data Cluster Spark job development and submission. For first-time Spark developers, it can often be hard to get started and build their first application, with long and …

We have moved!

Publié le 29 mars 2019 sur sql server security blog
 

Thanks for visiting! This blog has now been migrated to: https://techcommunity.microsoft.com/t5/Azure-SQL-Database/bg-p/Azure-SQL-Database/label-name/SQLServerSecurity  

Our new Azure SQL Database blog site is live

Publié le 29 mars 2019 sur Microsoft SQL Server database engine blog
 

Follow us in our new blog site going forward: https://techcommunity.microsoft.com/t5/Azure-SQL-Database/bg-p/Azure-SQL-Database

SQL Server Management Studio 18.0 Release Candidate 1 is now available

Publié le 28 mars 2019 sur sql server team blog
 

As we get closer to the General Availability of SQL Server Management Studio (SSMS) 18, we have decided to have a quick release of the Release Candidate (RC) build. You can download SSMS 18.0 RC1 today and for more details on whats included, please see …

SQL Server 2019 community technology preview 2.4 is now available

Publié le 27 mars 2019 sur sql server team blog
 

Continuing with our monthly release cadence, were excited to announce the release of SQL Server 2019 community technology Preview 2.4. Previewed in September 2018, SQL Server 2019 is the first release of SQL Server to closely integrate Apache Spark and …


Pages :