Are Blogs Still Relevant? I Think They Still Are.
As for me, I'll keep writing whenever time permits. I don't expect every post to get hundreds of views or generate a lot of discussion. If someone finds an...
2026-11-10
52 reads
As for me, I'll keep writing whenever time permits. I don't expect every post to get hundreds of views or generate a lot of discussion. If someone finds an...
2026-11-10
52 reads
I built a free library of runnable SQL Server demos. Each reproduces a real production problem on purpose, measures the fixes, and checks its own predictions on SQL Server...
2026-11-09 (first published: 2026-10-29)
482 reads
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is one of those technologies that I want to understand better. As AI becomes part of...
2026-11-06 (first published: 2026-10-23)
162 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
42 reads
The STIG is detailed, which is a good thing, but I found myself wanting something a little more practical for day-to-day DBA work. Something I could open, work through...
2026-10-05 (first published: 2026-09-22)
538 reads
When I put together the invitation for T-SQL Tuesday #202, I wasn't sure what kind of stories would come out of it.
The topic was simple:
That one SQL Server outage...
2026-09-25 (first published: 2026-09-15)
258 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
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo subscription cost. This was meant for a private demo so I can learn more about...
2026-08-24 (first published: 2026-08-13)
630 reads
No two SQL Server environments are alike. A fix that resolves a performance issue in one environment may not work in another because every SQL Server instance has different...
2026-08-21 (first published: 2026-08-04)
736 reads
Aside from spinning up a SQL Server instance container, the free Azure SQL Database is another great tool for learning SQL. You can even use it for low-traffic or...
2026-08-14 (first published: 2026-07-30)
436 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