Knowledge Base
Search Results ...
SSIS REST API Integration with Script Tasks
In the ever-evolving world of data integration, Microsoft's SQL Server Integration Services (SSIS) continues to be a reliable tool for ETL (Extract, Transform, Load) processes. The release of SQL Server 2022 has introduced new features that enhance its cap[.....]
SSRS ReportViewer Integration in ASP.NET Core Note from the Data Whisperer
Greetings to all data enthusiasts! Today, we're delving into a highly sought-after topic in the realm of database management: SQL Server Reporting Services (SSRS) ReportViewer integration in ASP.NET Core. With the advent of SQL Server 2022 and Azure SQL, t[.....]
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[.....]
SSRS Interactive Sorting with Groups
In today's fast-paced and data-driven world, the ability to quickly and efficiently analyze data is essential. SQL Server Reporting Services (SSRS), part of the SQL Server 2019 suite, is a powerful tool for creating, managing, and delivering reports. One o[.....]
Introduction to Azure SQL Database: First Impressions Note from the Data Whisperer
Greetings, fellow data enthusiasts, and welcome back to SQLSupport.org. I am the Data Whisperer, and today I am excited to share my first impressions of Azure SQL Database. As many of you are already aware, Azure SQL Database is a cloud-based relational da[.....]
Extracting Data from PDF Invoices with Python and SQL Integration
With the advancement in technology, businesses have started to receive invoices in PDF format. Although it has made the invoice processing efficient, it is challenging to extract data from these PDF invoices. But with the help of Python and SQL integration[.....]
Preserving Data Integrity While Refactoring Warehouse Keys
As data grows exponentially in today's digital world, the need to refactor warehouse keys becomes increasingly significant. The goal of refactoring is to improve the design of existing code without altering its external behavior. Preserving data integrity[.....]