Knowledge Base
Search Results ...
Handling Schema Drift in Modern ETL Pipelines
Schema drift is a term used to describe the phenomenon where the structure of a database changes over time. This can be a result of both intentional and unintentional actions such as adding or deleting columns, changing data types, or modifying constraints[.....]
Creating Vector Indexes in SQL Server for Similarity Search
A similarity search is a type of search that finds objects that are similar to a specified example. This type of search is common in areas like multimedia retrieval, data mining, bioinformatics, among others. To perform similarity searches efficiently, dat[.....]
Automating Report Delivery via Outlook Graph API
In the constantly evolving field of data management, it is essential to stay updated with the latest technologies and methodologies. Among the various advancements, an interesting one is the automation of report delivery via Outlook Graph API. This is a po[.....]
Comparing Data Lakes and Traditional Warehouses for BI
In our fast-paced digital world, managing data efficiently and making it accessible for Business Intelligence (BI) has become a critical aspect of business. Traditionally, companies relied on data warehouses to manage and store data. However, with the adve[.....]
Custom RBAC for SSRS Folder Permissions Note from the Data Whisperer
Streamlining permission management is a critical aspect of any robust security architecture. When SQL Server Reporting Services (SSRS) is included in your data storage and management structure, it is crucial to implement custom role-based access control (R[.....]
Documenting Databases Automatically with Python Scripts
In the world of database management, there are two things that are certain: databases will grow, and documentation will lag behind. As a database administrator or developer, you know the importance of keeping your database documentation up-to-date. However[.....]
Bulk Loading Parquet Files into SQL Server with PolyBase
Welcome to SQLSupport.org! Today we'll be exploring how to use PolyBase to bulk load Parquet files into SQL Server. Parquet, a compressed and efficient columnar storage format, has been rapidly gaining in popularity due to its impressive speed and flexibil[.....]
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[.....]
Designing Secure APIs for Database Access
In the world of data management, security is a paramount concern. Especially when it comes to designing APIs for database access, where a compromise could potentially expose sensitive data. Today, we will explore how to design secure APIs for database acce[.....]
Running SQL Workloads Inside Kubernetes with Stateful Sets
SQL workloads, a necessary part of any database-driven application, are often run on dedicated servers or in the cloud. However, with the advent of containerization and orchestration technologies, running these workloads inside a Kubernetes cluster using S[.....]