Knowledge Base
Search Results ...
New Query Store Enhancements in SQL Server 2022
Welcome to another insightful article on SQLSupport.org. Today, we are going to explore the new Query Store enhancements introduced in SQL Server 2022. Over the years, SQL Server has evolved to offer a more robust, high-performing, and secure data platform[.....]
Automating Index Recommendations with SQL Server 2022
Welcome to another insightful post on SQLSupport.org. Today, we delve into the realm of SQL Server 2022 and its impressive new features. Our focus will be on exploring how to automate index recommendations using SQL Server 2022. This latest version of SQL[.....]
SQL Server and AI Embedding Solutions for Search Note from the Data Whisperer
Welcome to another insightful post from SQLSupport.org, your trusted partner in all SQL-related matters. Today, we delve into the future of databases by exploring SQL Server and AI embedding solutions for search notes from the Data Whisperer. We're going t[.....]
SQL Server Temporal Table Cleanup and Audit Use
One of the most powerful features of SQL Server 2022 and Azure SQL is the ability to create temporal tables. A temporal table is an extension of a regular table that allows you to keep a history of data changes. However, like any powerful tool, temporal ta[.....]
SQL Server 2022: Ledger Tables for Compliance Use Cases
In the era of data-driven decision making, the need for data integrity and compliance is paramount. With the release of SQL Server 2022, Microsoft introduced a new feature, Ledger Tables, to address this need. Ledger tables provide an immutable, tamper-evi[.....]
SQL Server Extended Events for Live Monitoring
In the dynamic world of database administration, SQL Server Extended Events (XEvents) has emerged as a powerful tool for live monitoring. Introduced in SQL Server 2008, Extended Events provide a method to collect data about SQL Server’s behavior, offering[.....]
SQL Server Advanced Query Store Configuration
Welcome to SQLSupport.org's latest blog post. Today, we delve into the advanced configuration of Query Store in SQL Server 2022, Azure SQL, and delve into the integration with technologies such as Microsoft Fabric, Delta Lake, OpenAI + SQL, and Databricks.[.....]
SQL Server DMV Queries for Active Sessions
In the world of data management, understanding what's happening under the hood of your SQL Server is critical. One of the most powerful tools at your disposal is the Dynamic Management Views (DMVs) that come with SQL Server 2022 and Azure SQL. These DMVs c[.....]
SQL Server CLR Integration Security Considerations
Security has always been a critical aspect of data management, and with the increasing surge of data-driven operations, its importance is ever on the rise. SQL Server CLR Integration provides a versatile platform to run managed code inside the SQL Server.[.....]
SQL Server Database Sizes with Drive Information
Notes from the Field: When managing storage across a SQL Server environment, it’s not enough to just know how large each database is, you must need to understand which drives are hosting those files. This is especially important when balancing I/O,[.....]