Knowledge Base
Search Results ...
Best Practices for Managing Linked Servers Securely
Linked servers provide a robust environment to execute distributed queries against different data sources, be it SQL Server, MySQL, DB2, or Azure SQL. However, managing these linked servers securely is a crucial aspect of any database administration. This[.....]
Using Change Data Capture (CDC) for Audit Requirements
In today's data-driven world, being able to track and audit changes to your database is not just a sensible precaution, it can also be a regulatory requirement. Fortunately, SQL Server 2012, SQL Server 2014, MySQL 5.6, DB2 10.5, and Azure SQL all support a[.....]
Migrating DTS Packages to SSIS 2016
Migrating DTS packages to SSIS 2016 can be a daunting task, particularly for databases that have been heavily invested in SQL Server 2012 or SQL Server 2014. However, with careful planning and execution, the transition can be a smooth one. This blog aims t[.....]
Using SSIS Expressions for Dynamic Connection Strings
Welcome to another post on SQLSupport.org. Today, we will be discussing a fascinating topic: Using SSIS Expressions for Dynamic Connection Strings. SSIS (SQL Server Integration Services) is a powerful tool offered in SQL Server 2012 and SQL Server 2014 for[.....]
Paginated SSRS Reports with Drill-through Navigation
In this blog post, we will explore the creation of paginated SQL Server Reporting Services (SSRS) reports with drill-through navigation. We will be focusing on SQL Server 2012 and 2014, MySQL 5.6, DB2 10.5, and Azure SQL. Paginated reports are optimized fo[.....]
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[.....]
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[.....]
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[.....]
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[.....]