Damian is Microsoft MVP and Certified Trainer with 20 years of experience. Now trying to share the passion and knowledge among others. He runs the blog with his daughter as she is really passionate about technology

Person Stirring Coffee with a Spoon

Weekly reading #21

Hello, hello! We have just started new week! We missed the weekly reading last time due to travelling across the Europe over the weekend. There is however a lot...

2019-07-15

55 reads

Weekly reading #20

Being MVP for the #11 straight year is something unique! Thank you! The first week of July has just started. So oficially we have started vacations and the team...

2019-07-01

30 reads

Coffee

Weekly reading #19

Good afternoon folks! It is Monday Tuesday already after a long weekend in Poland. I do not know what temperature you have but here we are like in a...

2019-06-25

33 reads

Breakfast by the sea image

Weekly reading #18

Ready for vacations? The CodingFamily team is almost ready – we have some vacations plans including great conferences during summer and in the autumn. T-SQL bugs, pitfalls, and best...

2019-06-17

32 reads

Round Table of Coffee

Weekly reading #0x10

This is the blog anniversary! 16th Weekly reading has come into the light! For great articles and a video wait for you! Report Parameter Support for Paginated Report E-Mail...

2019-06-03

33 reads

Cup and Saucer

Weekly reading #15

SQLDay 2019 is gone. The Data Community.PL has now a new goal – it is the SQL Saturday #914 in Torun. The speakers will be announced after July 30th....

2019-05-27

37 reads

Blogs

Using AI to Build Semantic Models, Ontologies, and Fabric Data Agents

By

(This is the third post in a three-part series on how AI is changing...

SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL

By

Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...

Yippee-Kai-Yay 2027 Summit in Denver

By

Next year the PASS Data Community Summit is in DENVER! and London, but Denver...

Read the latest Blogs

Forums

Pay for Performance

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Pay for Performance, which is...

Helping an English Student with R

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Helping an English Student with...

Adding Bits I

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Adding Bits I

Visit the forum

Question of the Day

Adding Bits I

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]
GO
My application runs this code:
INSERT dbo.BitTest
(
    insertdate,
    a
)
VALUES
(DEFAULT, 'true')
GO

See possible answers