SELECT DBMS_METADATA.GET_DDL('TABLE', '&tblNAME', '&Owner') FROM DUAL; ...

Earlier in 2023, we discussed The Importance of Metadata here in the DBA Corner column. And, indeed, metadata is more important than ever before because it helps us to understand our data. Data ...

This project provides a set of C# scripts designed to dynamically read and synchronize metadata between a source and destination SQL Server databases. The scripts are intended to be used within SQL ...

Part of the SQL Server 2022 blog series. The main difference between tempdb and other databases is the workload. With tempdb we are constantly creating and destroying objects such as temp tables. This ...

Part of the SQL Server 2022 blog series. The main difference between tempdb and other databases is the workload. With tempdb we are constantly creating and destroying objects such as temp tables. This ...