Are Blogs Still Relevant? - T-SQL Tuesday #204
T-SQL Tuesday is a monthly blog party hosted by a different community member each month. This month, Jeff Iannucci
(blog) asks a rather meta question:
I’m asking folks to...
2026-11-10
28 reads
T-SQL Tuesday is a monthly blog party hosted by a different community member each month. This month, Jeff Iannucci
(blog) asks a rather meta question:
I’m asking folks to...
2026-11-10
28 reads
T-SQL Tuesday is a monthly blog party hosted by a different community member each month. This month, Marlon Ribunal
(blog) asks us to talk about that one SQL Server outage...
2026-09-08
68 reads
T-SQL Tuesday is a monthly blog party hosted by a different community member each month. This month, Jeff Taylor
(blog) asks us for our take on temp tables:
So, do you...
2026-08-31 (first published: 2026-08-12)
436 reads
T-SQL Tuesday is a monthly blog party hosted by a different community member each month. This month, Brent Ozar
(blog) asks us to fill in the blank:
When I’m looking at...
2026-07-14
81 reads
Ten years (and a couple jobs) ago, I wrote about naming default constraints to avoid having SQL Server name them for you. I closed with the following statement:
SQL Server...
2026-04-17 (first published: 2026-04-06)
428 reads
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person twice in May 2026. With summer vacations coming up, this is a perfect time of...
2026-03-30
63 reads
This is long overdue but life and distractions happened. It’s been a little over two months since I returned home from PASS Summit 2025.
2026-02-06 (first published: 2026-01-26)
184 reads
T-SQL Tuesday is a monthly blog party hosted by a different community member each month. This month, Mike Walsh
(blog) asks us:
Write two short notes to yourself. One to the...
2025-12-29 (first published: 2025-12-09)
258 reads
Thank you for attending my PASS Summit 2025 session Answering the Auditor’s Call with Automation! I will have a more comprehensive post in the coming days. Slides and demo...
2025-11-21
70 reads
I’ve been enjoying Ben Weissmann (Blog | LinkedIn) & Jess Pomfret’s (Blog | LinkedIn ) weekly program Finding Data Friends for a couple years now, getting to know (by...
2025-10-27
47 reads
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...
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
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