Knowledge Base
Search Results ...
Using SSIS with Script Task for API Data Pulls
In today's data-driven world, APIs (Application Programming Interfaces) have become an essential tool for retrieving remote data. Developers often need to integrate these data sources with SQL databases, and this is where SQL Server Integration Services (S[.....]
Comparing SSRS vs Power BI Paginated Reports (2017 Edition)
Welcome to SQLSupport.org. Today, we're going to discuss and compare two significant reporting tools from Microsoft: SSRS (SQL Server Reporting Services) and Power BI Paginated Reports. These tools, compatible with several platforms such as SQL Server 2016[.....]
Designing Surrogate Keys for BI Fact Tables
In the world of Business Intelligence (BI), fact tables are the cornerstone of any data warehouse. They store the measurable, quantitative data about a business. When designing these fact tables, it's essential to consider the use of surrogate keys. Surrog[.....]
Using SSRS Expressions for Dynamic Row Coloring
When it comes to data visualization and reporting, SQL Server Reporting Services (SSRS) is one of the most powerful tools in a database administrator's toolkit. One of the most useful features of SSRS is its ability to use expressions to dynamically contro[.....]
Managing SQL Agent Jobs Across 50+ Servers
Managing SQL Agent Jobs across a multitude of servers can be quite a task. However, with the right use of SQL Server 2012 and SQL Server 2014, this task becomes manageable and efficient. The SQL Server Agent is a component of Microsoft SQL Server which is[.....]
Using SSRS Subreports for Reusable Output Blocks
In the world of SQL Server Reporting Services (SSRS), one of the most powerful features that can be used to create highly reusable and modular reports is the subreport. This feature is available in versions of SQL Server 2012 and SQL Server 2014, as well a[.....]
Extracting Metadata from SSRS Reports for Cataloging
SQL Server Reporting Services (SSRS) is a powerful tool that allows developers to design and manage reports. However, when working with a large number of reports, it can become difficult to manage the metadata associated with each report. This blog post wi[.....]
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[.....]