Knowledge Base
Search Results ...
Monitoring SQL Agent Job Failures with T-SQL
SQL Server Agent jobs play a critical role in the daily operations of many organizations. However, despite their importance, it can be challenging to keep track of job failures, especially in larger environments where many jobs are running simultaneously.[.....]
Using MERGE Statement in T-SQL ETL Loads
The MERGE statement, introduced in SQL Server 2008, is a powerful tool that simplifies the process of performing insert, update, and delete operations in a single statement. It is particularly useful in ETL (Extract, Transform, Load) processes, where data[.....]
Monitoring Database Growth Over Time with T-SQL
One of the most critical tasks of a database administrator (DBA) is monitoring and managing database growth. It can be daunting, especially when dealing with large databases and complex systems, like SQL Server 2016, SQL Server 2017, MySQL 5.7, DB2 11.1, o[.....]
Managing SSRS Permissions via T-SQL Scripts
Welcome back to SQLSupport.org! Today, we will focus on managing SQL Server Reporting Services (SSRS) permissions via T-SQL scripts. Microsoft SQL Server 2016 and 2017, as well as MySQL 5.7, DB2 11.1, and Azure SQL all offer unique ways of handling SSRS pe[.....]
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[.....]
Building Incremental Load Logic in T-SQL
In this blog post, we will discuss a critical aspect of ETL (Extract, Transform, Load) process: the incremental load logic in T-SQL. Incremental load refers to the process of updating a data warehouse with new data from operational databases. The goal is t[.....]
Handling Decimal Rounding in T-SQL for Invoices
Handling decimal rounding in T-SQL can be a bit tricky, especially when dealing with invoices where precision is paramount. There exist a myriad of ways to round numbers in SQL, but we will focus on the ROUND function. ROUND is supported in SQL Server 2012[.....]
Creating a Central Logging Framework with T-SQL
In today's data-driven world, system logging is an essential aspect of any enterprise database system. The ability to track, monitor, and analyze system events is crucial for system management, performance tuning, troubleshooting, and security auditing. Th[.....]