Knowledge Base
Search Results ...
Using Dynamic SQL Safely with sp_executesql
In the SQL Server world, dynamic SQL is often viewed with a mixture of suspicion and caution. This is largely due to the potential security risks associated with its misuse - most notably SQL injection attacks. However, when used correctly and safely, dyna[.....]
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[.....]
Backup Compression Ratios: SQL Server vs MySQL
In the world of database management, backing up your data is a critical operation. Equally important is the ability to effectively compress these backups to maximize storage efficiency. This article will compare the backup compression ratios of SQL Server[.....]
Refactoring SQL Stored Procedures for Performance
Welcome to SQLSupport.org. In this blog post, we will discuss the refactoring of SQL stored procedures for performance enhancement. This is a crucial aspect of SQL Server Management which can significantly improve the efficiency of your databases. We will[.....]
DB2 for z/OS vs DB2 LUW: Differences for Application Developers
IBM's DB2 database platform is available in two distinct editions: DB2 for z/OS and DB2 LUW (Linux, Unix, Windows). Both variants of DB2 are powerful and flexible, capable of handling a wide range of data workloads. However, there are several important dif[.....]
Validating Complex Joins with CHECKSUM and HASHBYTES
Complex SQL joins can be a headache, especially when it comes to validating the results. When joining multiple tables, one may encounter unexpected results due to the complexity of join conditions or the presence of duplicate records. In this blog post, we[.....]
Getting Started with Azure Blob Storage Backups
One of the tremendous advantages of the cloud is the ability to scale resources as needed. The Microsoft Azure platform offers a variety of services and solutions for businesses, including Azure Blob Storage - a scalable, cost-effective solution for storin[.....]
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[.....]
Enterprise Patterns for Slowly Changing Dimensions
One of the most critical challenges faced by data architects is managing Slowly Changing Dimensions (SCD) in the enterprise data warehouse. In this era of Big Data, handling changing data over time is vital for businesses to develop accurate historical rep[.....]