Many years ago, I was on call for a production system. This was common for me since I was one of several production DBA’s for the company. It was a normal weekend for me, and I got up and started playing with my kids. They were heavily into trains, and we were laying out our […]
2026-10-21
111 reads
Many years ago, I started at a smaller-sized company. About 150 employees; it was a SaaS company that provided survey software. It was growing quickly, and I was the primary DBA. I was hired not only to be a DBA, but to build a DB team to handle many of the issues the company faced […]
2026-10-19
138 reads
This week I hosted T-SQL Tuesday. This monthly event suggests a topic for bloggers to write about. It’s been going on for many years, and you can find more details here. https://tsqltuesday.com/ For my specific post, you can find the summaries here. T-SQL Tuesday #203 — Summary/Follow up I’ve spent 20+ years being asked questions about […]
2026-10-17
66 reads
Earlier this week, I recorded a talk called “AI: The Good, Bad, and the Future.” I talked about some of the good things that have happened with AI and some of the Bad. But what I really wanted to focus on was the future. I think many of us have heard the two letters AI […]
2026-09-12
165 reads
Managing incidents as a DBA /DB manager and some of the key things you should be doing.
2026-08-08
207 reads
This Editorial is coming to you during an exciting birthday for the United States. If you are in the US, you are most likely celebrating the 4th of July. This is the 250th anniversary for the US, quite a milestone. I hope that all my US friends are celebrating safely and responsibly. While it is […]
2026-07-04
412 reads
A Thank You message to the original founds of the PostgreSQL project and members of the community that have been working so hard for 30 years.
2026-05-30
313 reads
2026-04-25
104 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...
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