Knowledge Base
Search Results ...
Advanced Usage of CROSS APPLY for Lookup Joins
In this blog post, we will dive into the advanced usage of the CROSS APPLY operator for lookup joins in SQL. This operator, available in SQL Server 2016 and 2017, as well as Azure SQL, allows us to execute a function for each row in a query. While it can b[.....]
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[.....]
Hybrid Backup Strategies: On-Premise SQL + Azure Blob
Hybrid backup strategies are increasingly being adopted by organizations seeking to leverage the benefits of both on-premises and cloud-based solutions. SQL Server 2016 and 2017, MySQL 5.7, DB2 11.1, and Azure SQL are some of the technologies employed in t[.....]
Minimizing TempDB Contention in SQL Server
As a database administrator, one of the challenges you may encounter is TempDB contention in SQL Server. This can notably impact the performance of your databases. TempDB contention happens when multiple tasks are trying to create or delete temporary objec[.....]
Log Shipping Monitoring Dashboard with T-SQL and Views
As data professionals, we are constantly monitoring and managing data in various database platforms. In this blog post, we are going to discuss a very important aspect in the world of data management, that is, creating a Log Shipping Monitoring Dashboard u[.....]
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[.....]