The idea behind Azure SQL Developer is for anyone to build, iterate, and test locally at no cost. This means NO Azure subscription to deal with and NO credit...
2026-08-03 (first published: 2026-07-23)
287 reads
I’m sure many of you are using AI regularly, perhaps chatting, perhaps using some sort of agent. I’m doing the same, but in this case, I had it tackle...
2026-07-29 (first published: 2026-07-22)
546 reads
This blog series on Audit/Compliance/Security, this is first blog where we would discuss about GRC and different audits and other important information, later we will discuss each audit frameworks...
2026-07-21
99 reads
In the previous post, we've built a SQL Server 2025 sandbox in an OrbStack container in a Macbook. If you are like me who switched from a Windows laptop...
2026-07-29 (first published: 2026-07-20)
642 reads
Thanks to everyone for attending my talk today at Day of data Baton Rouge 2026 (formerly SQL Saturday Baton Rouge). The slides are here: Building an API with DAB...
2026-07-18
104 reads
Here’s the scenario: one of my SQL Server instances migrated to the DR array. The VM moved, the old volumes were destroyed, and nobody created a Protection Group on...
2026-07-27 (first published: 2026-07-17)
502 reads
We are product focused at Redgate Software. Here is another of our values that focused on this: The text on the next page is: Shipping something amazing is better...
2026-07-17
68 reads
It can feel as if Microsoft has put the Copilot name everywhere, and that is not far from the truth. The important thing to understand is that Microsoft Copilot...
2026-07-27 (first published: 2026-07-16)
493 reads
A fugitive cyber-criminal, a wingsuit, and 24 million flight records. Somewhere between Doha and Dublin, Krypto jumped between planes mid-air.
2026-07-24 (first published: 2026-07-16)
173 reads
Say you need outside help. You’ve exhausted all the things that you could do and, still, nothing works. So, you decide that calling in for help is the next...
2026-07-24 (first published: 2026-07-16)
569 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