Sites Microsoft


A SQL Server tale of two cities

Publié le 21 mai 2019 sur sql server team blog
 

No one disputes that data is critical to the lifeblood of business, applications, and the computer industry. SQL Server sits at the forefront of any discussion about data these days. So its no coincidence that SQL Server is seen, heard, and felt at maj …

SQL Server 2017 achieves top TPC benchmarks for OLTP and DW on Linux and Windows

Publié le 16 mai 2019 sur sql server team blog
 

Once again, SQL Server 2017 has led the pack with three new TPC benchmarks published in April 2019, ranking SQL Server 2017 as the fastest database for online transaction processing (OLTP) and data warehouse (DW) workloads on Windows and Linux. Togethe …

#SQLDataWins is back!

Publié le 13 mai 2019 sur sql server team blog
 

You love data. You love the way it helps you and your organization make better decisions. You love the way it creates real insight into trends that are shaping our world. Plus, data is just plain cool; whats not to love about that? We love data too. Th …

The May release of Azure Data Studio is now available

Publié le 8 mai 2019 sur sql server team blog
 

Were excited to announce the May release of Azure Data Studio (formerly known as SQL Operations Studio) is now available. You can download Azure Data Studioand review the release notes to get started. Please note: After downloading Azure Data Studio, s …

When is Spinlock a Significant Driver of CPU utilization in SQL Server?

Publié le 3 mai 2019 sur SQL Server Support Blog
 

When is Spinlock a Significant Driver of CPU utilization? SQL Server uses multiple mechanisms for synchronizing access to shared structures. One such mechanism is a spinlock. Briefly, a spinlock is a type of lock acquisition mechanism which is designed …

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 …


Pages :