You paste a slow Redshift query plan into PlanTrace and one of the tuning insights reads “SORTKEY optimization candidate”, pointing…
Browsing: SQL
As part of my running the SQL Saturday charitable foundation, I get sponsorship money from vendors. Primarily Microsoft and AMD,…
We work hard at Redgate, though with a good work-life balance. One interesting observation for me (as an American) is…
DROP TABLE IF EXISTS dim.Account;CREATE TABLE dim.Account ( id INT IDENTITY(1,1) NOT NULL ,[4444] VARCHAR(10) NULL ,[4444_desc] VARCHAR(550) NULL ,aa…
I almost did not publish this book.Not because I doubted the ideas. Because I was not ready for anyone to…
While wandering around the documentation looking for some Question of the Day topics, I learned something new about the money…
It’s the second tuesday of the month, which means T-SQL Tuesday time! This month’s topic is chosen by myself, and…
We keep adding new AI capabilities to Redgate Monitor, where it makes sense. Check out this new feature we’ve added…
Can I be honest with you for a second? We need to talk about how AI actually makes you feel,…
Since the release of my book Deciphering Data Architectures: Choosing Between a Modern Data Warehouse, Data Fabric, Data Lakehouse, and…