Managing Microsoft Fabric at scale quickly becomes painful if you rely only on the UI. Workspaces, capacities, and tenant-level settings all need repeatable, scriptable management. FabricTools is a community-driven PowerShell module...
2026-01-07 (first published: 2025-12-24)
236 reads
When organizations migrate workloads to Azure, the focus is usually on architecture, performance, and security. Cost management should be part of that conversation—but in practice, it’s often treated as...
2026-01-07 (first published: 2025-12-22)
250 reads
Following the advice in Smart Brevity improves communication.
2026-01-06
16 reads
Redgate Monitor has been able to monitor replication for a long term, but it required some work from customers. Now we’ve added native monitoring. This is part of a...
2026-01-05 (first published: 2025-12-15)
287 reads
There's a great article from MIT Technology Review about resetting on the hype of AI. AI's current state is somewhere between the die hard evangelists and the doomsayers
2026-01-05 (first published: 2025-12-19)
375 reads
If someone is trying to convince you it’s not a pyramid scheme, it’s a pyramid scheme – from Excellent Advice for Living For sure. As much as I am...
2026-01-02
18 reads
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t do this natively, as this really needs an XEvent session. I decided to see if...
2026-01-02 (first published: 2025-12-17)
2,189 reads
One feature that I have been waiting for years! The new announcement around optimize CPU for RDS SQL Server is a game changer because it lets you right-size vCPUs...
2026-01-02 (first published: 2025-12-11)
497 reads
For a number of years I have subscribed to Randy Franklin Smith's Patch Tuesday newsletter. It tends to hit my inbox in the wee hours of Wednesday.
2025-12-31 (first published: 2025-12-10)
239 reads
I haven’t posted in a while (well, not here at least since I’ve been posting at the Straight Path Solutions site recently), but I did want to reply to...
2025-12-31 (first published: 2025-12-10)
309 reads
By Vinay Thakur
Following up on my Part 1 baseline, the journey from 2017 onward changed how...
By Brian Kelley
In cryptography, the RSA and ECC algorithms which we use primarily for asymmetric cryptography...
By Steve Jones
In today’s world, this might mean something different, but in 2010, we had this...
I've got a table with 186,703,969 rows, about 300GB of data. There are several...
I created a SQL Database in Azure Portal but I've just noticed it also...
Comments posted to this topic are about the item An Unusual Identity
What values are returned when I run this code?
CREATE TABLE dbo.IdentityTest2
(
id NUMERIC(10,0) IDENTITY(10,10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
INSERT dbo.IdentityTest2
(
somevalue
)
VALUES
( 'Steve')
, ('Bill')
GO
SELECT top 10
id
FROM dbo.IdentityTest2 See possible answers