Have you been thinking about migrating your reporting to Microsoft Fabric or Snowflake but you have no idea what it…
Browsing: SQL
The SQL analytics endpoint is a separate layer that maintains its own catalog and cache over the Delta tables in…
If you’ve been watching AI roll through the data community and thinking, “this seems useful, but I have no idea…
Annabel retired from Redgate Software this week. Across most of my career at Redgate, I’ve participated in many events, some…
A good week ago I hosted the monthly T-SQL Tuesday blog party. I invited the community the blog about the…
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve never tried it, but the batch…
You paste a slow Redshift query plan into PlanTrace and one of the tuning insights reads “SORTKEY optimization candidate”, pointing…
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…