Blog Post

Murder in Raleigh

I am about to set sail on a new venture with my next official whistle stop.  This year has been plenty full of whistle stops and I plan on...

2014-08-04

13 reads

Blog Post

Murder in Raleigh

I am about to set sail on a new venture with my next official whistle stop.  This year has been...

2014-08-15 (first published: )

7,932 reads

Blog Post

Deny vs Revoke

Quick quiz. Which of these two commands is the opposite of GRANT?
DENYREVOKE 

Well lets start with some definitions
GRANT – Grants permissions on...

2014-08-12 (first published: )

8,569 reads

Blog Post

ExpressProfiler - new release

Just released new build of ExpressProfiler.
No major changes, just cosmetic improvements - shortcut here, confirmation dialog there, new captured events (SQL:StmtStarting/Completed,...

2014-08-11 (first published: )

8,835 reads

Blogs

A New Word: Semaphorism

By

semaphorism – n. a conversational hint that you have something personal to say on...

SQL Server Linux Container Images Got Smaller: Image Size and Startup Time Across Cumulative Updates

By

This week I was at PASS Data Community Summit in Seattle, and I attended...

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...

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...

Layanan BCA KCP Rembang Hub/Wa. 0817-819-444

By Halo_BCA

WhatsApp:0817819444 Jl. Pemuda No.3 C, Tawangsari, Leteh, Kec. Rembang, Kabupaten Rembang, Jawa Tengah 59217

Layanan BCA KCP Blora Hub/Wa. 0817-819-444

By layanan 24jam BCA

WhatsApp:0817819444 Jl. Pemuda No.57B, Blora, Tempelan, Kec. Blora, Kabupaten Blora, Jawa Tengah 58211

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