Knowledge Base
Search Results ...
Monitoring Azure SQL with Log Analytics
In today's data-driven world, monitoring your database server is crucial to ensure optimal performance and quick troubleshooting. For Azure SQL users, Microsoft has provided a powerful tool, Azure Log Analytics, which can be used to monitor, analyze, and o[.....]
Building Audit Frameworks Across Multiple Platforms
In the era of data-driven decision making, auditing your databases across multiple platforms has become a critical task. It is essential to ensure that your data is consistent, accurate, and secure. As such, we will explore how to build an audit framework[.....]
SQL Server Query Plan Forcing
SQL Server Query Plan Forcing is a powerful feature that allows DBAs to fix a specific query plan for a query. This ensures consistent performance by preventing automatic changes to the query plan due to factors like statistics updates or SQL Server versio[.....]
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.[.....]