My 2024 in Data: Speaking
This is my last week of the year working (I guess I come back on the 30th for a minute), so I decided to do some analysis of my...
2024-12-17
39 reads
This is my last week of the year working (I guess I come back on the 30th for a minute), so I decided to do some analysis of my...
2024-12-17
39 reads
Want to seriously boost your data skills? Mastering advanced SQL is the key, whether you're in data analysis, data science, or any field that uses data. Trust me, it's...
2024-12-17
92 reads
The post How to Build Data Management for Unstructured Data appeared first on Joyful Craftsmen.
2024-12-16 (first published: 2024-12-10)
470 reads
One of the things that I think is neat is that Redgate Monitor helps you track patching on your systems. This is something that has been challenging in every...
2024-12-16 (first published: 2024-12-09)
301 reads
This is my last week of the year working (I guess I come back on the 30th for a minute), so I decided to do some analysis of my...
2024-12-16
24 reads
Want to learn SQL and get some real practice this December? Check out the Basic SQL Practice: A Store course – it's totally free for the entire month! This...
2024-12-14
56 reads
dolonia – n. a state of unease prompted by people who seem to like you too much, which makes you wonder if they must have you confused with someone...
2024-12-13
141 reads
You can find the slides for the session Building the €100 data warehouse with the Azure Data Platform in this GitHub repo.
The post Cloudbrew 2024 – Slides first appeared...
2024-12-13
41 reads
I had mentioned some new T-SQL functions for SQL Server 2022 and a commenter asked about the difference between Min() and First_value. This post looks at a few cases....
2024-12-13 (first published: 2024-12-04)
740 reads
Several months ago, I discussed my customer’s intention to enable trace flag 3625. Since that time, we have observed an intriguing phenomenon when encountering a login failure. To demonstrate...
2024-12-13 (first published: 2024-12-10)
569 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