Knowledge Base
Search Results ...
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[.....]
SQL Server Memory Settings for Large Databases
SQL Server, MySQL, DB2, Azure SQL, and Azure Synapse are popular relational database management systems (RDBMS) that offer a significant level of customization for managing memory settings. This feature is particularly useful when dealing with large databa[.....]
DB2 Explain Plan and Query Diagnostics
SQL servers, whether they be SQL Server 2019, MySQL 8.0, DB2 11.5, Azure SQL, or Azure Synapse, are all about speed and efficiency. For a database administrator, understanding how a query is processed is crucial to optimizing database performance. This is[.....]
Building Dynamic SQL Reports with SSRS Note from the Data Whisperer
With the proliferation of data across various industries, there is an increasing demand for professionals who are adept at creating dynamic SQL reports. SQL Server Reporting Services (SSRS) offers a wide range of tools for creating, managing, and deliverin[.....]
SQL Server Data Classification Features Note from the Data Whisperer
SQL Server 2019, MySQL 8.0, DB2 11.5, Azure SQL, and Azure Synapse all have robust data classification features that are instrumental in data protection. Data classification in SQL Server 2019 is a tool that allows organizations to categorize and label the[.....]
MySQL ENUM and SET Columns: Pros and Cons
In the world of databases, managing data types is crucial for ensuring data integrity, performance, and ease of use. MySQL provides a unique data type called ENUM that can be very useful in certain scenarios. ENUM is a string object that allows you to spec[.....]
Parameterizing SQL Server Agent Jobs
SQL Server Agent jobs are a powerful tool for automating and scheduling tasks in SQL Server 2019. While these jobs are incredibly useful, they can become cumbersome when you need to manage jobs with similar tasks but different parameters. That's where para[.....]
Using SSIS Script Task for REST API Calls
In today's data-driven world, integrating and synchronizing data across various platforms is a common necessity. With SQL Server Integration Services (SSIS), you can accomplish this task with ease. One of the powerful features of SSIS is the Script Task, w[.....]
DB2 Audit Facility Configuration Tips
The DB2 Audit Facility is an integral part of the IBM DB2 database that allows database administrators (DBAs) to track and record activities within the database. It serves as an essential tool for DBAs to monitor data access, authorization changes, SQL err[.....]
Designing Historical Snapshots with Slowly Changing Dimensions
Slowly Changing Dimensions (SCD) is a common term in Data Warehouse that refers to the dimensions whose data changes slowly, rather than changing on a regular time basis. These dimensions can provide a historical perspective on the data to track changes ov[.....]