Knowledge Base
Search Results ...
SQL Server Ledger Tables for Immutable Audit Trails
In the ever-evolving world of data management and database administration, maintaining an accurate and immutable audit trail is crucial. With the help of Ledger tables in SQL Server 2019, MySQL 8.0, DB2 11.5, Azure SQL, and Azure Synapse, creating an uncha[.....]
SQL Server Token-Based Security for APIs
In the dynamic world of technology, APIs play a crucial role in facilitating seamless interaction between different software systems. As we continue to rely on APIs for the exchange of sensitive data, it becomes significantly important to implement robust[.....]
Using SQL Server PolyBase for External Data Access
SQL Server PolyBase is a significant feature that was introduced in SQL Server 2016 and considerably enhanced in SQL Server 2019. It allows SQL Server to run queries on external data in Hadoop or Azure blob storage. It also allows the use of data from Orac[.....]
SQL Server Query Store for Performance Regression Analysis
SQL Server Query Store is a powerful tool for performance regression analysis. Since its introduction in SQL Server 2016, it has become an indispensable feature for performance tuning and troubleshooting. The Query Store offers a way to track query perform[.....]
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[.....]
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[.....]
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[.....]
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[.....]
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[.....]
SQL Server Transparent Data Encryption Setup
Transparent Data Encryption (TDE) is a powerful feature that you can utilize to secure your data at rest. It performs real-time I/O encryption and decryption of data and log files, ensuring that your sensitive data is secure from unauthorized access. Let's[.....]