I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll highlight something that I think it’s interesting enough to share....
2025-03-31 (first published: 2025-03-17)
549 reads
I received a sobering reminder this week of a lesson we all have learned or should have learned long ago. Something I said online came back around months later...
2025-03-26 (first published: 2025-03-17)
395 reads
I’ve been working with SQL Server for a very long time. Out of the box, SQL Server works great, however there is regular care and feeding that needs to...
2025-03-17
22 reads
If you're a data analyst drowning in Excel, you know the pain. Endless filtering, formula nightmares, and the dreaded "file not responding" message. Excel's great for small stuff, but...
2025-03-17
310 reads
Here’s a way to centralize management, rotate secrets conveniently without downtime, automate synchronization and reduce secret exposure risks.Secrets management is an essential aspect of modern application development. It is vital...
2025-03-15
127 reads
This may or may not be helpful in the long term, but since I’m doing it to be super cautious, I figured I would blog about it. We migrated...
2025-03-31 (first published: 2025-03-14)
243 reads
“I’m sick of hearing about Red Gate.” The first article in the book has this title, which might seem strange, but the short piece then talks about how many...
2025-03-14
39 reads
IT leaders have a lot on their plates! Budgets, staffing, security, uptime, and keeping everything running smoothly. When SQL Server performance becomes an issue, a common reaction is often...
2025-03-26 (first published: 2025-03-13)
6,956 reads
Want to really level up your SQL game? I mean, go from good to great? This March 2025, grab the interactive course Window Functions in PostgreSQL absolutely FREE. This is your chance to master...
2025-03-13
6,647 reads
We published an article recently at SQL Server Central on Tally Tables in Fabric from John Miner. In it he showed how this can be efficient. A day after...
2025-03-21 (first published: 2025-03-12)
6,976 reads
I’m excited to announce the release of a new open-source project that fully automates...
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Comments posted to this topic are about the item AI Experience Gap that we...
Comments posted to this topic are about the item Squared Values
Comments posted to this topic are about the item I Don't Want To Do...
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers