MinervaSQL’s Post

https://zurl.co/iXoI Runbook for Loading and Managing Data with Composable JSON Tags in SQL Server #Microsoft #Azure #SQLServer #MinervaDB #DBA #SQL #AzureSQL

#AzureDaily 📣 Azure Database users, learn from Lesson Learned #497: Understand ordering of 📦restore packages & container backups for #AzureSQL👩💻! Improve error handling during restores + streamline backup & export processes.🚀 #AzureDatabase #SQL #CloudExpert #MicrosoftAzure

#AzureDaily 📢 Azure Database Lesson Learned: Handling "row value expressions not allowed" error in GIS query ❗ Avoid using row value constructor in SQL query - use logical operator 'AND' instead. Increases query compatibility with Azure SQL DB ☁️🔧 #MicrosoftAzure #AzureDatabase #SQLTips

SQL Server 2022 has introduced a new feature called the parallel buffer scan. This improves the performance of Buffer Pool scan operations on large-memory machines by turning it into a multithreaded process. Our latest blog post provides an in-depth look at this feature, including how it works and how it can benefit your large SQL Server instances. Check out the link to learn more. https://lnkd.in/gjW78gSj #sqlserver2022 #sqldba #sqltips

Do you have a large memory SQL instance? A good feature to know about in SQL Server 2022?

SQL Server 2022 - (New Feature /Update) - Reduced buffer pool I/O promotions = Reduced the incidents of a single page being promoted to eight pages when populating the buffer pool from storage, causing unnecessary I/O. The buffer pool can be populated more efficiently by the read-ahead mechanism. This change was introduced in SQL Server 2022 (all editions) and included in Azure SQL Database and Azure SQL Managed Instance. (https://lnkd.in/edSTfaJy)

Discover a smooth transition from SQL Server to #AzureCosmosDB in this insightful Dev.to article. https://lnkd.in/e6MbTUb9

[Article] Data Management Views (DMVs) Comparison for SQL Server 2019 and Azure SQL Database In this article, we look at Data Management Views (DMVs) differences between a SQL Server 2019 instance and Azure SQL Database. Author: Michelle Gutzait >>> https://lnkd.in/edKyBsiR #sql #sqlserver #microsoftsqlserver #mssql #mssqlserver #datamanagementviews #dmv #sqlserver2019 #azuresqldatabase

T-SQL Fundamentals, 4th Edition -------------------------------------------- Query and modify data effectively with the latest T-SQL features Master Transact-SQL's fundamentals, and write correct, robust code for querying and modifying data with modern Microsoft data technologies, including SQL Server 2022, Azure SQL Database, and Azure SQL Managed Instance. Long-time Microsoft Data Platform MVP Itzik Ben-Gan explains key T-SQL concepts, helping you apply your knowledge with hands-on exercises. Ben-Gan first introduces T-SQLs theory and underlying logic, illuminating it as both a language and a way of thinking. Next, he walks through core topics, including logical query processing, single table queries, joins, subqueries, table expressions, set operators, data analysis, data modifications, temporal tables, and transactions and concurrency. Building on this foundation, you'll enhance your coding capabilities, from programmatic constructs to the powerful new SQL Graph. Throughout, Ben-Gan presents reusable T-SQL sample code that works in cloud, on-premises, and hybrid environments.

Curious about the max degree of parallelism in SQL Server? It's a setting that determines how many processors can be used for query execution. Understanding it can optimize performance and speed up queries. Let's explore its impact together! #SQLServer #MaxDegreeOfParallelism #QueryOptimization https://lnkd.in/dDNYF_rH