Knowledge Base
Search Results ...
Using Azure Blob Storage for Offsite SQL Backups
Microsoft's Azure Blob Storage is an ideal solution for offsite backups, especially for SQL databases. With its global redundancy and massive scalability, Azure Blob Storage provides a highly reliable and cost-effective offsite storage option. Moreover, it[.....]
Cleaning Up Unused SSIS Packages from MSDB
SQL Server Integration Services (SSIS) is a powerful tool that allows for the integration and transformation of data. It is an essential component for managing data warehouses and data extraction, transfer, and loading (ETL) operations. Over time, you may[.....]
Always On Availability Groups in SQL Server 2012: Real-World Design
Always On Availability Groups, a feature introduced in SQL Server 2012, gives you a high-availability and disaster-recovery solution. With this, you get a failover environment for a discrete set of user databases, known as availability databases. This solu[.....]
Daily Health Check Scripts for ETL-Heavy Environments
Maintaining a healthy and productive environment is crucial for ETL-heavy environments. Today, we will discuss some daily health check scripts that can be used with SQL Server 2012, SQL Server 2014, MySQL 5.6, DB2 10.5 and Azure SQL to ensure the smooth op[.....]
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[.....]
SQL Profiler vs Extended Events in SQL 2012 Migration
SQL Profiler has been long considered the best tool for monitoring and troubleshooting SQL Server. Its primary use has been to capture and analyze SQL Server events such as batch statements, stored procedures, and login activity. However, with the release[.....]
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[.....]
Deploying Report Server Projects Across Multiple Environments
For many organizations, dealing with multiple environment setups such as development, testing, staging and production is a common scenario. This blog post aims to delve into how to deploy Report Server Projects across these varied environments. The SQL Ser[.....]
Using DB2 9.7 for Cross-Platform Finance Reporting
In today's fast-paced, data-driven financial world, the need for cross-platform data management and reporting has never been more important. One of the solutions that has proven itself in this arena is IBM's DB2 9.7. This database management system provide[.....]
Upgrading SSIS from 2005 to 2008 R2: Pitfalls and Fixes
Upgrading from SQL Server Integration Services (SSIS) 2005 to 2008 R2 is a necessary step for many organizations and developers. This transition allows you to take advantage of new features and improvements in performance and security. However, the process[.....]