Knowledge Base
Search Results ...
Columnstore Indexes in SQL Server 2016: Real-World Use
In the world of big data, the ability to quickly and efficiently analyze large datasets is vital. SQL Server 2016 introduced a significant feature to help with this task: Columnstore Indexes. This type of index stores column data together, as opposed to tr[.....]
DB2 Stored Procedure Debugging Techniques
Debugging stored procedures in IBM's DB2 is an art that requires a certain level of expertise. DB2 11.1, for instance, provides a rich set of tools and technologies to simplify the debugging process. Using the right techniques, you can identify and address[.....]
Managing SQL Agent Job Ownership and Alerts Note from the Data Whisperer
Welcome to another edition of SQLSupport.org's blog, where we unravel the complexities of SQL Server management. Today, we'll be discussing the nuances of managing SQL Agent Job Ownership and Alerts. This is a crucial task for DBAs as it ensures the smooth[.....]
Configuring Azure SQL Alerts for Resource Governance
When it comes to managing your SQL Server instances, whether they reside on SQL Server 2016, SQL Server 2017 or even MySQL 5.7 and DB2 11.1, resource governance is crucial. However, when these instances are hosted on Azure SQL, you gain a host of cloud-bas[.....]
Using CHECKSUM to Detect Changes in Staging Tables
In today's data-driven world, maintaining data integrity is paramount to the success of any business. Detecting changes in data is a vital aspect of maintaining this integrity, especially in staging tables where data is often updated or modified. One effic[.....]
Tuning SSRS Performance for Multi-Tenant Report Servers
As businesses grow and diversify, there is an increasing need to serve multiple clients from a single reporting platform. SQL Server Reporting Services (SSRS) offers an effective platform for multi-tenant reporting but to ensure optimal performance, tuning[.....]
Using Table-Valued Parameters for Bulk Operations
In the world of SQL Server, efficient data handling is a necessity. One of the most effective ways to handle bulk data operations is through the use of Table-Valued Parameters (TVPs). Available in SQL Server 2016 and later, TVPs allow you to send multiple[.....]
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[.....]