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

iamspeaking_damian-widera

#DPS10 – preconfs

I have delivered a preconf on the biggest conference in Asia. The preconf was about Supervised and Unsupervised Machine Learning with bonus track about Semi-supervised solutions. This was really...

2019-08-21

18 reads

Coffee poured into mug from machine

Weekly reading #24

Hello #SQLFamily! We are packing for the longest trip this year. Next week we will start in Shanghai, then will move to Bangalore for #DPS10 and the last week...

2019-08-06

29 reads

Cup of Coffee

Weekly reading #23

New week has started and apart from the usual information from the data world I would like to share one more. The Machine Learning topic published last week has...

2019-07-29

32 reads

Award

Weekly reading #22

A little bit late but it is here! It is Wednesday already and we are preparing for #DPS2019 which will be in August in Bangalore. Meanhwile I received another...

2019-07-24

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