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 ...

Most databases include comment metadata on both tables and columns in a table. It would be nice to be able to pass this additional context to the LLM to get a better response. The main motivation ...

One of the few sessions I was able to see last week at the PASS European Conference (I had to leave very early, unfortunately) was Markus Raatz’s excellent “New Treasures for Microsoft BI Found on ...

Most organisations leverage the disaster recovery options available to them on Azure to ensure they are properly protected in case of a data center outage. Depending on their requirements, they can ...

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 ...