The PASS Data Community Summit 2025 Recap
It’s Monday. I’ve been home since Fri night, but with a busy weekend, I’m still recovering from the PASS Data Community Summit. There’s a nice wrap from the crew,...
2025-11-26
38 reads
It’s Monday. I’ve been home since Fri night, but with a busy weekend, I’m still recovering from the PASS Data Community Summit. There’s a nice wrap from the crew,...
2025-11-26
38 reads
This was announced last week at Microsoft Ignite and it's been covered by others such as Brent Ozar, but if you haven't heard, SQL Server 2025 is now generally...
2025-11-25
224 reads
Have you ever added a visual to a Power BI report page and published the updated report only to realize you forgot to adjust a related bookmark? It’s very...
2025-11-24 (first published: 2025-11-05)
237 reads
Redgate has a research arm, called the Foundry, that has been experimenting with AIs and DBA tasks. This post shows how GenAI tech can be helpful to DBAs in...
2025-11-24 (first published: 2025-11-05)
346 reads
The advantage of understanding the make-up of the exam: I can tailor my efforts for best results.
2025-11-24
43 reads
Many organizations are still running SQL Server 2016 in production. Sadly, many are running versions older than 2016 as well, however with SQL Server 2016, the end of extended...
2025-11-24
92 reads
Introduction When you’re running MongoDB at scale with data distributed across multiple Pure Storage FlashArrays, achieving truly consistent backups becomes a critical and interesting technical challenge. In this post,...
2025-11-23
54 reads
2025-11-23
34 reads
dead reckoning– v. intr. finding yourself bothered by somebody’s death more than you would have expected, even if they were only an abstract presence in your life, like a...
2025-11-21
27 reads
Explore methods, tools and best practices for protecting data in databases, memory caches, storage systems and other stateful applications.Featured image by bangoland on Shutterstock.Kubernetes is a very powerful and...
2025-11-21
53 reads
Once upon a time I had a series about some cool stuff in Snowflake:...
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
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