Improving Our Conversations
If we aren't having the same conversation, we aren't going to be heard. That's what Charles Duhigg, author of The Power of Habit, covered in the following TED talk:
2025-04-18 (first published: 2025-03-31)
359 reads
If we aren't having the same conversation, we aren't going to be heard. That's what Charles Duhigg, author of The Power of Habit, covered in the following TED talk:
2025-04-18 (first published: 2025-03-31)
359 reads
As a part of the Book of Redgate, we have a series of (red, of course) pages with the title “What we believe”. These are our values, as set...
2025-04-18 (first published: 2025-04-04)
409 reads
Understanding how permissions work in Microsoft Fabric can be essential for anyone managing access to Lakehouses, SQL Endpoints, or Semantic Models.
2025-04-16 (first published: 2025-04-03)
588 reads
Microsoft Fabric is transforming real-time analytics for financial institutions. It provides a unified data platform. This platform integrates various data sources into a single, cohesive system. This integration breaks...
2025-04-16 (first published: 2025-04-03)
333 reads
The Distributed Availability Group Dashboard can be downloaded from our GitHub repo. https://github.com/SQLUndercover/UndercoverToolbox/blob/master/DAG%20Dashboard.pbix. This comes off of the back of my last post looking at using a distributed availability...
2025-04-14 (first published: 2025-04-01)
370 reads
We value your privacy. This policy explains what personal data we collect and why.
What We Collect
Cookies (for analytics, only after consent)
IP addresses (stored anonymously by our hosting provider)
Contact form...
2025-04-14
13 reads
Does skipping a DBA save money? Wait until your system grinds to a halt, your backups fail, or your cloud bill skyrockets. The “DBA? We Don’t Need No Stinkin’...
2025-04-14 (first published: 2025-04-02)
596 reads
When in doubt, overtip – from Excellent Advice for Living This is close to my heart, since I spent a lot of time in college and after working as...
2025-04-11
23 reads
A while back I wrote about using AI to explore why people are not using Extended Events. You can read all about it here, but a short summary of...
2025-04-11 (first published: 2025-03-31)
297 reads
I admit that until I read the article, Who are you as a Leader?, I had never heard of an identity map. It's a pretty simply thing: mapping all...
2025-04-11 (first published: 2025-04-01)
542 reads
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
By Steve Jones
I saw a question asking about the next sequence value and decided to try...
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