Knowledge Base
Search Results ...
MySQL Query Cache Usage and Deprecation
The MySQL Query Cache was a well-regarded tool for improving the performance of MySQL database servers. Its function was to store the result set from SELECT queries so that if the same query gets executed again, it could retrieve the result from the cache[.....]
Creating SSRS Drillthrough Reports with Parameters
Welcome to SQLSupport.org! Today, we will be delving into a popular subject: creating SSRS Drillthrough Reports with parameters. These reports are valuable tools that allow users to navigate from one report to another while passing information. They provid[.....]
Using Common Table Expressions in SSIS Scripts
Common Table Expressions (CTEs) are a powerful tool in SQL that can simplify complex queries by breaking them down into more manageable pieces. In SQL Server Integration Services (SSIS) scripts, they can be used to improve readability and maintainability.[.....]
DB2 Log Retention Settings and Recommendations Note from the Data Whisperer
DB2 Log Retention settings are an integral part of database management and optimization in SQL Server 2019, MySQL 8.0, DB2 11.5, Azure SQL, and Azure Synapse. They provide a mechanism to control the volume of logs retained, thus directly influencing the am[.....]
Best Practices for Connection Pooling in MySQL
Connection pooling in MySQL is a technique used to enhance the performance of executing commands on a database. With the use of technologies like SQL Server 2019, MySQL 8.0, DB2 11.5, Azure SQL, and Azure Synapse, efficiency and scalability can be achieved[.....]
SQL Server Always Encrypted Explained
In today's data-driven world, database security is of paramount importance. One of the most powerful security features provided by SQL Server 2019 is Always Encrypted. This feature ensures sensitive data, such as credit card numbers or personally identifia[.....]
Implementing Data Governance with SQL Tags Note from the Data Whisperer
Welcome to the SQL Support blog. Today, we delve into an important element of database management, which is Data Governance. Data Governance entails the overall management of the availability, integrity, and security of the data employed in an enterprise.[.....]
Tuning Subqueries in MySQL for Performance
In the world of database management, subqueries are a powerful tool for retrieving data based on specific conditions. However, they can also be a hindrance to performance if not optimized properly. In this blog post, we will discuss some strategies for tun[.....]
Automating SSIS Package Deployment
The automation of SSIS package deployment is a critical aspect of the SQL Server Integration Services (SSIS) framework that can significantly improve efficiency and productivity. SSIS is a tool provided by Microsoft that enables complex data transformation[.....]
Using SQLCMD Variables in Deployment Scripts Note from the Data Whisperer
SQLCMD mode in SQL Server 2019 is an interactive command line tool for SQL Server that allows users to execute Transact-SQL commands directly, execute script files, and execute commands in an operating system. One of the powerful features of SQLCMD mode is[.....]