I had someone ask me about using triggers to detect changes in their tables. As I explained a few things,…
Browsing: SQL
Over the past 25 years, I’ve worked with SQL Server in all kinds of environments: startups, mid-size companies, and global…
What a year …At the end of May 2024, I went on full time disability. For the first time in…
Top 10 Features of SQL Server 2025 #SQLServer2025 #MicrosoftSQL #DatabaseUpdates #SQLAI #SQLFeatures #SQLServerCopilot #VectorSearch #MicrosoftFabric #DataEngineering #TechUpdates #decodeites #mssqlfun The…
I wrote an editorial on the view of GenAI tech from execs and someone commented that they wanted references for…
I read Brent’s first look at SSMS and Copilot in there. He didn’t have a great opinion of the tool,…
Someone sent me this code.WITH p AS ( SELECT ID, ROW_NUMBER() OVER (ORDER BY ID ASC) AS RN FROM wp_posts…
Tired of inventory headaches? Stock shortages and gluts don’t just cause stress; they cost you. Good news: an SQL-powered product…
So, you want to get your SQL skills razor-sharp without dropping any cash? You’re in the right place. I’ve pulled…
One of the new features in Kubernetes v1.33 is the ability to resize CPU and memory resources for containers online,…