Advice I Like: Overnight Success
“Most overnight successes – in fact any significant successes – take at least 5 years. Budget your life accordingly” – from Excellent Advice for Living I’ll use a friend...
2026-11-20
11 reads
“Most overnight successes – in fact any significant successes – take at least 5 years. Budget your life accordingly” – from Excellent Advice for Living I’ll use a friend...
2026-11-20
11 reads
This is my late response to T-SQL Tuesday #204. I almost always forget about T-SQL Tuesday. Not because I don’t like it or don’t want to do it. I...
2026-11-19
11 reads
I was experimenting with CHOOSE() recently after I was asked a question. In a previous post, I found it can take a (ridiculous) number of arguments. In this post,...
2026-11-18
42 reads
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it appears many folks had a lot to say about whether or not blogs are relevant....
2026-11-17
29 reads
Should you adopt an off-the-shelf AI tool, partner with a specialist, build in-house, or acquire the capability? Use two questions and six practical signals to decide which path fits...
2026-11-17
42 reads
Part 1 of my What's New in SQL Server for the Developer series. IIF, CHOOSE, TRY_CONVERT, FORMAT, THROW, SEQUENCE, OFFSET/FETCH and EOMONTH, with examples you can run today.
2026-11-17
28 reads
Today at Ignite, Microsoft announced the public preview of the Azure SQL Database container. The line in the announcement that jumped out at me was this one: the container...
2026-11-17
21 reads
So far in this series I’ve been rebuilding members on arrays I already had. In my reseed post, I rebuilt aen-mongo-06 from a replicated snapshot of the primary. This...
2026-11-17
10 reads
Every copy of MongoDB data I’ve made so far in this series lives on a FlashArray. The snapshots sit on the same array as the volumes they protect, and...
2026-11-17
6 reads
In my reseed post, I spent a lot of time convincing you that you don’t need fsyncLock. One crash-consistent snapshot of the primary, replicated to every array, rebuilt every...
2026-11-17
9 reads
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
This is my late response to T-SQL Tuesday #204. I almost always forget about...
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
Comments posted to this topic are about the item Adding Bits II
Comments posted to this topic are about the item An Unlimited Token Budget
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, true)
GO
See possible answers