A SQL Server tale of two cities
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
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!
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
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?
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
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
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
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
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
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
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 …