During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of the things he pointed out that differentiates an architect from a senior administrator/developer/engineer is that...
2026-11-13 (first published: 2026-11-03)
115 reads
For me, the objective is straightforward: have a backup strategy that is reliable, understandable, maintainable, and, most importantly, restorable. A successful backup job is good news. A successful restore...
2026-11-03
40 reads
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026. If you’d like to reply, your response should go live on November 10th, 2026. All...
2026-11-03
33 reads
AgentDBA began as a command line. That suits one DBA on one server, but it’s a poor way to give a team a read-only advisor. The obvious fix is...
2026-11-02
43 reads
I have a few Azure subscriptions, which are fairly small and not used that often. Mainly I do some SQL Server or Azure SQL experimentation. Sometimes I might create...
2026-11-11 (first published: 2026-11-02)
99 reads
This post shows you how to install containerd as the container runtime for Kubernetes and configure it to use the systemd cgroup driver. The commands below were tested on...
2026-11-11 (first published: 2026-11-01)
123 reads
In 1999 I released my first commercial software product. ShutOff 2000 was a Windows application that could log off or shut down Windows in multiple ways. It was successful...
2026-11-13 (first published: 2026-10-30)
377 reads
This month I want to look at a few of the things I’ve seen posted about cars during the last month. These are a few headlines, as well as...
2026-10-30
237 reads
SQL Server 2016 Has Reached End of Support. Now What?
On July 14, 2026, SQL Server 2016 reached the end of extended support. That means regular...
2026-11-09 (first published: 2026-10-30)
354 reads
(This post starts a three-part series on how AI is changing the way we build solutions in Microsoft Fabric. First, we’ll explore how the new unified Copilot in Fabric...
2026-11-04 (first published: 2026-10-29)
1,237 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