A DBA's Look at the Data Catalog
A data catalog is a way of classifying and adding metadata about the information in your database for compliance purposes. Take a look at how one DBA is using Redgate's Data Catalog.
2019-07-11
4,621 reads
Steve Hall
Explicit Transactions
There are frequent misunderstandings about Explicit Transactions, not limited to use of 'nested transactions'. This article attempts to explain by example many of the behaviors of this feature.
2018-07-13 (first published: 2015-12-30)
18,113 reads
Blogs
Using OneLake for Excel Files in Microsoft Fabric
By DataOnWheels
Hey data friends! This blog is to discuss an edge case I’ve run into...
Another AI Faux Pax
By Steve Jones
I was experimenting with a local model (article) and as a part of this,...
Monday Monitor Tips: Using the PowerShell API
By Steve Jones
Redgate Monitor has grown tremendously from its early days and I find many customers...
Forums
SSMS gets very messy
At work we have quite a few databases that I'm frequently browsing. This is...
restore db as db_copy. resolve hardcoded references within procedures to db.
So I backup & restore db as db_copy. within both there is a proc...
Transpose sql table rows into columns
I want to transpose sql table rows to columns. I have written a query...
Question of the Day
Sparse Column Defaults
What are the restrictions for defaults on columns declared as sparse?
See possible answers