Knowledge Base
Search Results ...
SQL Server 2022: Parameter Sensitive Plan Optimization
SQL Server 2022 is here and it brings a host of powerful features, one of which is Parameter Sensitive Plan Optimization. This new feature assures the best possible query performance for your server by choosing the optimal execution plan based on the param[.....]
DB2 Federation Setup with SQL Server and Oracle
Federation setup in databases aims to create a unified data system from heterogeneous databases. Today, we will discuss the Federation setup between SQL Server, Oracle, and DB2. We will use the latest versions of these technologies: SQL Server 2019, MySQL[.....]
SQL Server 2022: Contained Availability Groups
Welcome to a new blog post from SQLSupport.org. Today, we will dive into SQL Server 2022 and explore the concept of Contained Availability Groups. Contained Availability Groups, an exciting feature introduced in SQL Server 2022, provide an enhanced level o[.....]
SQL Server Execution Plan Caching Explained
In the world of database management, understanding how SQL Server handles and caches execution plans can significantly optimize your database performance. Execution plans represent the actual steps your SQL Server 2019, MySQL 8.0, or DB2 11.5 will take to[.....]
SQL Server Filegroup Design for ETL Loads
Welcome to SQLSupport.org! In this blog post, we are going to discuss SQL Server Filegroup Design for ETL (Extract, Transform, Load) Loads. We'll be focusing on SQL Server 2019, MySQL 8.0, DB2 11.5, Azure SQL, and Azure Synapse. When dealing with ETL loads[.....]
SQL Server Database Scoped Configurations
SQL Server 2019, MySQL 8.0, DB2 11.5, Azure SQL, and Azure Synapse all offer robust ways to manage and configure databases. One such method is through database scoped configurations. These configurations allow you to tailor database settings without impact[.....]
SQL Server Database Projects with Visual Studio
SQL Server Database Projects offer a robust and integrated environment for database developers to work on their data-tier applications using Visual Studio. With support for SQL Server 2019, Azure SQL, Azure Synapse, MySQL 8.0, and DB2 11.5, SQL Server Data[.....]
SQL Server Ledger Tables for Immutable Audit Trails
In the ever-evolving world of data management and database administration, maintaining an accurate and immutable audit trail is crucial. With the help of Ledger tables in SQL Server 2019, MySQL 8.0, DB2 11.5, Azure SQL, and Azure Synapse, creating an uncha[.....]
SQL Server Token-Based Security for APIs
In the dynamic world of technology, APIs play a crucial role in facilitating seamless interaction between different software systems. As we continue to rely on APIs for the exchange of sensitive data, it becomes significantly important to implement robust[.....]
Using SQL Server PolyBase for External Data Access
SQL Server PolyBase is a significant feature that was introduced in SQL Server 2016 and considerably enhanced in SQL Server 2019. It allows SQL Server to run queries on external data in Hadoop or Azure blob storage. It also allows the use of data from Orac[.....]