Knowledge Base
Search Results ...
Developing SSIS Frameworks for Package Logging and Alerts
SQL Server Integration Services (SSIS) is a critical component in the Microsoft SQL Server 2012/2014 database suite, enabling the development of high-performance data integration and workflow solutions. A robust SSIS framework not only facilitates the exec[.....]
DB2 Identity Columns vs SQL Server Sequences
In the world of databases, the means of generating unique, sequential values can be crucial for various applications. Two such methods of generating these values are DB2 Identity Columns and SQL Server Sequences. This blog post will delve into each of thes[.....]
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[.....]