I was trolling the docs and noticed the SIGN() function. I have never written this in production code, but it is an interesting function. This post looks at where...
2026-09-07 (first published: 2026-08-26)
485 reads
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend or a foe, from full-throated defenses to a lab built to prove me wrong.
2026-09-04 (first published: 2026-08-25)
96 reads
I have been experimenting with MCP servers in a few ways, including the Redgate Monitor MCP Server. It took me a few tries, and some help from engineers to...
2026-08-31 (first published: 2026-08-24)
380 reads
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small servers with zero activity showed no progress, and then all 30 finished at the same...
2026-09-02 (first published: 2026-08-23)
285 reads
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people who prefer a GUI over writing code to handle deployments, but the implementation has enough...
2026-09-02 (first published: 2026-08-21)
480 reads
We aren’t the only company that does this, but Redgate Software does try to be data driven. Across my 18 years, I’ve had plenty of people use evidence from...
2026-09-04 (first published: 2026-08-21)
244 reads
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform. Power BI, data engineering, warehousing, data science, real-time analytics, Copilot, and other experiences can all...
2026-08-28 (first published: 2026-08-20)
570 reads
I recently started playing with the MCP Server for SQL Server, which is a part of the Data API Builder (DAB). I’m not sure why there wasn’t a separate...
2026-08-28 (first published: 2026-08-19)
501 reads
If you spend your days tuning queries, managing pipelines, or keeping a production database alive, you already carry most of what an AI engineering role needs. What is missing...
2026-08-18
408 reads
I’ve been rebuilding my three-site SQL Server demo lab, and I ran into something I’ve wanted for a long time. If you’ve ever designed a SQL Server environment on...
2026-08-26 (first published: 2026-08-18)
281 reads
By James Serra
(This is the third post in a three-part series on how AI is changing...
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
Comments posted to this topic are about the item Pay for Performance, which is...
I wrote about this several years ago but will contribute again a life hack...
Hi I have this query that is slow during the 'not in' part of...
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers