Knowledge Base
Search Results ...
SSIS Project Deployment: Environment Variable Tips
SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. It is a platform for data integration and workflow applications. In this blog post, we wi[.....]
Using Temp Tables vs Table Variables in Joins
In SQL Server, developers often face the decision of whether to use temporary tables or table variables when performing joins. Both methods come with their own advantages and disadvantages, and understanding these can help improve the performance and effic[.....]
Working with Legacy DTS on Modern SQL Servers
Legacy DTS (Data Transformation Services) packages can be a challenge to work with on modern SQL Server versions like SQL Server 2016 and 2017. They are no longer natively supported, but with a few workarounds, it is possible to continue using them, albeit[.....]
DBA Checklists: What to Monitor Every Morning
The life of a Database Administrator (DBA) revolves around ensuring that database systems run efficiently and securely. A crucial part of this is daily monitoring and maintenance. In this post, we will be discussing a checklist that a DBA should follow eve[.....]
Surrogate vs Natural Keys in Warehouse Dimensions
The choice between surrogate and natural keys in warehouse dimensions is one that can significantly impact the efficiency and effectiveness of your database management system. Before we delve into the specifics of each, it's important to understand that th[.....]
Slow SSRS Reports: Identifying Dataset Bottlenecks
In a world that thrives on data, speed is king. Slow running reports can be a source of frustration for users and a headache for developers. In this post, we will explore how to identify bottlenecks in SQL Server Reporting Services (SSRS) datasets, which a[.....]
Backup Encryption in SQL Server 2016
In recent years, the importance of data security has become paramount. With SQL Server 2016, the need for data encryption, particularly for backups, has been addressed. The introduction of the Transparent Data Encryption (TDE) feature, which was first intr[.....]
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[.....]