A good week ago I hosted the monthly T-SQL Tuesday blog party. I invited the community the blog about the…
Browsing: SQL
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…
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…