-
Critical Checks for Oracle DB Tablespaces and Datafiles
When was the last time you checked on your Oracle database tablespaces and their datafiles, how those things are set up and organized? Are you sure that your tablespaces and datafiles are set up in a way that won’t cause an error the next time data is inserted into a table? If you are coming…
-
Recovery Options for Azure Key Vaults
I recently had a post about how to manage deleted Azure Key Vaults: how to find them after they’ve been deleted, how to recover them if you didn’t really want them to be deleted, and how to purge them if you want them to be permanently removed. In today’s post, I am going to cover…
-
Limitations of Azure Synapse Analytics SQL Pools
In the past couple of months, I have run into some annoying limitations and unsupported features with T-SQL in our Azure Synapse Dedicated SQL Pools, which is where my team puts our data warehouses for reporting needs across our business. These unsupported features were a bit surprising to me, which is why I’ve decided to…
View Older Posts
- June 2026
- February 2026
- January 2026
- December 2025
- November 2025
- October 2025
- September 2025
- August 2025
- May 2025
- April 2025
- March 2025
- February 2025
- January 2025
- November 2024
- October 2024
- September 2024
- July 2024
- June 2024
- May 2024
- April 2024
- March 2024
- February 2024
- January 2024
- December 2023
- November 2023
Posts by Tag
AI Artificial Intelligence AWS Azure Azure SQL Database Azure SQL Server Bicep Blog Change Management Change Tracking Cloud Development Coffee Break Conference Copilot Cryptography Database Database Tools Development Documentation Encryption ETL Fernet Git Indexes Key Vaults Liquibase Microsoft SQL Server Oracle Oracle Cloud Infrastructure Organization PASS Data Community Summit PostgreSQL Programming Python Red-Gate SQL SQL Prompt SQL Server Management Studio Stress Management Synapse Analytics Test Data Manager Unit Testing Version Control WordPress Work Management