Knowledge Base
Search Results ...
Converting Reports from Crystal to SSRS for Standardization
In today's fast-paced technology-driven world, businesses often find themselves in the process of system migration or upgrading. One such common scenario is the transition from Crystal Reports to SQL Server Reporting Services (SSRS). This conversion is typ[.....]
Cross-Site SQL Server Failover in Energy Sector DR Planning
The integrity and availability of data are of critical importance in the Energy sector. As such, Disaster Recovery (DR) planning should be at the forefront of any robust IT strategy. One of the most reliable ways to ensure data protection and high availabi[.....]
Designing Partitioned Tables with Monthly Roll-Off
Partitioning tables is an effective strategy for managing large databases. By dividing a table into smaller, more manageable parts, you can improve query performance and make maintenance tasks more efficient. The partitioning strategy you choose largely de[.....]
Migrating DB2 Data into SQL Server Using SSIS
The process of migrating DB2 data into SQL Server can be an intimidating task, but with the right tools and guidance, it can be achieved successfully and efficiently. One of the most reliable tools for this is SQL Server Integration Services (SSIS). SSIS i[.....]
Columnstore Indexes in SQL 2016 for Fact Tables
With the advent of SQL Server 2016, Microsoft has introduced enhancements to Columnstore indexes, making them even more valuable for fact tables in data warehousing scenarios. A Columnstore index stores data in a column-wise format, unlike the traditional[.....]
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[.....]