Knowledge Base
Search Results ...
SQL Server Columnstore Index Rebuild Strategy
Welcome to another blog post from SQLSupport.org. Today we'll be discussing a critical topic for database administrators and professionals: SQL Server Columnstore Index Rebuild Strategy. This post is particularly relevant for those using SQL Server 2022 an[.....]
SQL Server Security Auditing Best Practices
In the world of data management, security stands as a paramount concern. With SQL Server 2022, Azure SQL, Microsoft Fabric, Delta Lake, Databricks, and OpenAI + SQL, we have a plethora of powerful tools that can help us ensure the safety of our data. In th[.....]
SQL Server 2022: Built-in Query Hints for Stability
Welcome to SQLSupport.org, the forum where SQL Server enthusiasts, both budding and veteran, come together to explore the fascinating world of SQL Server. Today, we delve into the built-in query hints of SQL Server 2022, the big brother in the SQL Server f[.....]
SQL Server Dedicated SQL Pools vs Serverless
In the world of databases, SQL Server has long been a go-to solution for many organizations. With the release of SQL Server 2019, Microsoft introduced a slew of new features, including big data clusters and data virtualization. Alongside these, Azure SQL a[.....]
SQL Server Database Project Deployment with Azure DevOps
The integration of SQL Server Database Project with Azure DevOps has revolutionized the way we handle database operations. This fusion provides a seamless and efficient environment for managing and deploying your database projects. Let's explore this integ[.....]
SQL Server 2022: Enhanced Backup Compression
Welcome to SQLSupport.org! Today, we are thrilled to discuss the enhanced backup compression in SQL Server 2022. This feature represents a significant step forward in the SQL Server landscape, promising improved performance and cost savings. It builds on t[.....]
SQL Server Synapse Link Integration Examples
The buzz around SQL Server 2019, MySQL 8.0, DB2 11.5, Azure SQL, and Azure Synapse is well justified. The integration of these technologies, particularly SQL Server Synapse Link, can unlock a new level of data analysis and manipulation. This blog post will[.....]
SQL Server Memory Grant Feedback Explained
SQL Server 2019 introduced a new feature known as Memory Grant Feedback (MGF), which is part of the broader group of Adaptive Query Processing features. MGF adjusts the memory grant size for both batch and row mode operators, ensuring that the SQL Server e[.....]
SQL Server 2022: XML Compression Enhancements
SQL Server 2022 brings a host of new features and enhancements, including some notable improvements in XML compression. XML data can be quite verbose and lead to high storage requirements. Hence, enhanced XML compression techniques are crucial in managing[.....]
Monitoring TempDB Usage in SQL Server
Monitoring usage of the TempDB in SQL Server is crucial for database administrators. TempDB is a system database in SQL Server, which holds temporary user objects, internal objects, and version stores. It plays an essential role in SQL Server performance.[.....]