Knowledge Base
Search Results ...
Auditing Access to Sensitive Tables with Triggers and SQL Audit
Securing access to sensitive data is a key priority for any organization. One way to ensure data security is by auditing access to sensitive tables. SQL Server 2012, SQL Server 2014, MySQL 5.6, DB2 10.5, and Azure SQL provide robust tools for auditing acce[.....]
Migrating SQL Server Workloads to Azure VMs (Pre-MI Era)
In recent years, the shift towards cloud computing has been rapidly gaining momentum and many companies are migrating their SQL Server workloads to Azure Virtual Machines (VMs). This transition can provide numerous benefits including cost savings, scalabil[.....]
Modern Disaster Recovery Testing in a Hybrid Cloud World
Welcome to our SQLSupport.org blog. Today, we will be discussing modern disaster recovery testing in the complex, hybrid cloud world. As IT environments evolve and become more complex, disaster recovery testing becomes even more critical to ensure business[.....]
PostgreSQL vs SQL Server for Medium-Scale Applications
In the world of database management, decisions about which database system to use can significantly impact the performance and efficiency of your applications. Today, we will focus our comparison on two big players in the industry: PostgreSQL and SQL Serve[.....]
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[.....]