Database Weekly is the seven-day roundup from SQLServerCentral. We scour the Internet with a fine-toothed set of queries to compile the most informative weekly newsletter about SQL Server. Over 670,000 SQL Server professionals rely on it to kick-start their week.
Sign up to our newsletter now, to keep up to date with all the latest news.
Latest Database Weekly Newsletter Articles
SQLCLR in SQL Server 2017
Microsoft is recommending enabling “CLR Strict Security” in SQL Server 2017, which means users cannot create any CLR assemblies unless they have elevated permissions. This could be a breaking change anywhere you want to use dynamic CLR.
Graph Data Processing with SQL Server 2017
Graph extensions are fully integrated in the SQL Server 2017 engine. This article introduces two new types of tables in SQL Server 2017 databases, Node and edge tables, as well as the new MATCH clause for pattern matching and navigation.
Introducing Batch Mode Adaptive Joins
SQL Server 2017 and Azure SQL Database introduce a new set of adaptive query processing improvements, such as batch mode memory grant feedback, batch mode adaptive joins, and interleaved execution, to help fix performance issues that are due to inaccurate cardinality estimates. In this post, we’ll introduce batch mode adaptive joins.
SQL Server 2017 Community Technology Preview 2.0 now available
SQL Server 2017 CTP 2.0 adds a number of new capabilities, including the ability to run advanced analytics using Python in a parallelized and highly scalable way, the ability to store and analyze graph data, the Adaptive Query Processing family of intelligent database features and resumable online indexing.
Wanna speak at the PASS Summit? Here’s how
The PASS Summit is the biggest SQL Server community event, and a lot of us speakers have “present at PASS” on their bucket list. it means getting in is legendarily difficult because competition is fierce. Brent Ozar shares what he's learned over the years about getting sessions accepted.