I recently purchased and read the book Deciphering Data Architectures – Choosing Between a Modern Data Warehouse, Data Fabric, Data Lakehouse, and Data Mesh by James Serra. James –...
2024-04-24 (first published: 2024-04-08)
923 reads
Search and Export Script for SQL Server Databases
Plainly speaking, this article is about searching for a specific value inside all tables and their columns of a SQL database and...
2024-04-24 (first published: 2024-04-09)
771 reads
The bottom line here is this: the idea that a CSP takes care of everything for you is a fallacy that really needs to die. Thompson, Graham. All-in-One CCSK...
2024-04-24
96 reads
For a lot of us data professional types, this seems like a silly topic, however I constantly hear of companies that aren’t testing their backups by restoring them, or...
2024-04-23
28 reads
In today’s fast-paced digital world, keeping your data safe and accessible is more important than ever. That’s where Azure SQL Database steps in, offering a suite of tools to...
2024-04-22 (first published: 2024-04-05)
454 reads
I leave tonight for Australia. I was in London 3 days ago, so this will complete my halfway around the world trip when I time travel tomorrow and skip...
2024-04-22
32 reads
I was working with a customer and discussing how to do error handling. This is a short post that looks at how you can start adding TRY.. CATCH blocks...
2024-04-22 (first published: 2024-03-27)
653 reads
apolytus– n. the moment you realize you are changing as a person, finally outgrowing your old problems like a reptile shedding its skin, already able to twist back around...
2024-04-19
114 reads
I was approached by Manning Publications and asked to review 100 SQL Server Mistakes and How to Avoid Them. They gave me a free copy of the book (and...
2024-04-19 (first published: 2024-03-25)
540 reads
Over the past couple of months, I have started losing my ability to talk without a mask. One of the effects of a disease, ALS, is that I am...
2024-04-19
46 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