Knowledge Base
Search Results ...
SSRS Subscription Setup with PowerShell Automation
SQL Server Reporting Services (SSRS) is a powerful tool for generating and delivering reports from various data sources. It becomes more valuable when we configure it to deliver reports regularly using SSRS Subscriptions. However, setting up and managing S[.....]
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 Columnar Tables in BLU Acceleration
As data continues to grow exponentially, data management technologies are evolving to meet the increasing need for speedy access and efficient storage. One such technology is IBM's DB2 BLU Acceleration - a revolutionary technology designed to make the most[.....]
MySQL Common Table Expressions for Recursive Queries
In the world of database management, recursive queries are an essential tool for handling hierarchical or tree-structured data. They allow us to perform complex operations and retrieve deeply nested data efficiently. This blog post will dive into the funda[.....]
Azure Purview Integration with SQL Databases Note from the Data Whisperer
Welcome to the latest edition of our blog posts from the Data Whisperer at SQLSupport.org. Today, we're diving into the depths of Azure Purview and its integration with SQL databases. Azure Purview is a unified data governance service that helps organizati[.....]
SSIS Parameterization and Environment Configs
In today's data-driven world, a sound understanding of database technologies is essential. SQL Server Integration Services (SSIS) is one of such technologies, favored for its powerful data migration and transformation capabilities. However, to harness its[.....]
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[.....]
MySQL 8.0 Window Functions Explained
In the world of Database Management Systems (DBMS), MySQL 8.0 has made a significant impact by introducing a myriad of new features. One such feature, which we will discuss today, is the Window Functions. They perform a calculation across a set of table ro[.....]
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[.....]
Building Reusable Script Components in SSIS
As database professionals, we are always looking for ways to streamline our processes and improve efficiency. One highly effective way to accomplish this is by building reusable script components in SQL Server Integration Services (SSIS). In this post, we[.....]