Knowledge Base
Search Results ...
MySQL Full Text Search vs LIKE
In the realm of database management systems, text searching is an essential feature that aids in data retrieval. Two common methods for executing text searches in MySQL are Full Text Search and the LIKE operator. Each has its advantages and disadvantages,[.....]
Monitoring Database Growth Over Time with T-SQL
One of the most critical tasks of a database administrator (DBA) is monitoring and managing database growth. It can be daunting, especially when dealing with large databases and complex systems, like SQL Server 2016, SQL Server 2017, MySQL 5.7, DB2 11.1, o[.....]
SQL Server Cluster Configuration on Windows Server 2016
SQL Server cluster configuration is a crucial step for any organization that depends on SQL Server for data management. In this blog post, we will guide you through the process of setting up a SQL Server cluster on Windows Server 2016. We will be focusing[.....]
Dynamic SQL in SSIS Packages
Dynamic SQL is a powerful tool that can significantly enhance the functionality of SQL Server Integration Services (SSIS) packages. It allows SQL and T-SQL scripts to build and execute SQL statements dynamically at runtime. This feature provides a great de[.....]
DB2 Table Reorganization for Performance Gains
In the era of data-driven decision making, database performance is of paramount importance. One such performance optimization technique is table reorganization. In this blog post, we will be focusing on DB2 table reorganization and how it can lead to signi[.....]
Troubleshooting MySQL Connection Timeouts
In the realm of database administration, encountering MySQL connection timeouts can be quite a common occurrence. These issues often arise due to server overload, network instability, or configuration problems. This post will guide you through the process[.....]
SQL Server Always On High Availability Setup Guide
In the world of databases, ensuring high availability and data resilience is paramount. One of the key technologies that can help achieve this is SQL Server Always On. Introduced in SQL Server 2012 and improved in subsequent versions, Always On provides a[.....]
Security Best Practices for SQL Server 2017 Note from the Data Whisperer
In the fast-paced world of technology, data security is a top priority. With the ever-increasing amount of data being handled, SQL Server 2017 has become a preferred choice for database management systems (DBMS). This post will focus on security best pract[.....]
Partition Switching in Large Fact Tables Note from the Data Whisperer
As data warehouses continue to balloon with the exponential rise in data generation, SQL Server admins are faced with the challenge of optimizing their environment for improved performance. One such optimization technique that has proven useful for large f[.....]
Configuring Azure SQL Firewall Rules
Azure SQL Server, a fully managed relational database service from Microsoft Azure, provides a broad range of SQL Server functionalities on the cloud. One of the fundamental aspects of managing your Azure SQL Server instance is setting up firewall rules. T[.....]