Advice I Like: Lots of Ideas
“A multitude of bad ideas is necessary for one good idea” – from Excellent Advice for Living Whenever we read about the success of someone or something, we often...
2026-09-18 (first published: 2026-09-04)
293 reads
“A multitude of bad ideas is necessary for one good idea” – from Excellent Advice for Living Whenever we read about the success of someone or something, we often...
2026-09-18 (first published: 2026-09-04)
293 reads
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your SQL Server Estate”. I’ll drop the recording into this post once it’s published. What I...
2026-09-14 (first published: 2026-09-04)
557 reads
Most enterprise questions do not live neatly in one place. The numbers may be in a warehouse, the rules may be buried in PDF files, and the explanation may...
2026-09-09 (first published: 2026-09-03)
487 reads
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine until an auditor or an incident review asks for something older. Until now the usual...
2026-09-11 (first published: 2026-09-02)
183 reads
I was updating my session for the Data API Builder (DAB) recently, mostly to work with the MCP server capabilities. As I was trying to get this working, I...
2026-09-11 (first published: 2026-09-02)
310 reads
I am excited to host T-SQL Tuesday for the first time. I want to hear about that one outage that stands out in your memory. We all have incidents...
2026-09-01
189 reads
Redgate had some Claude training recently, which I went through as my knowledge has been gained in bits and pieces and is fragmented. I wasn’t sure I’d get a...
2026-08-31
117 reads
gnossienne– n. the awareness that someone you’ve known for years still has a private and mysterious inner life. One of the things I’ve learned throughout my life is that...
2026-08-28
68 reads
How I used AI for this postChatGPT to generate images based on info specifically provided by me,including examples.Grammarly to catch grammar and sentence construction errors. I did a presentation...
2026-09-09 (first published: 2026-08-27)
275 reads
A few months ago I started using Deepstash. Deepstash breaks books into the key ideas, usually 10-12 per book. If I am thinking about reading a book, I check...
2026-08-27
110 reads
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
This week I was at PASS Data Community Summit in Seattle, and I attended...
By James Serra
(This is the third post in a three-part series on how AI is changing...
Comments posted to this topic are about the item Pay for Performance, which is...
Comments posted to this topic are about the item Helping an English Student with...
Comments posted to this topic are about the item Adding Bits I
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