“It’s Alive” – SSIS Design Patterns
I’m happy to announce that the book I’ve been working on for the past two years is complete and has...
2012-09-05
573 reads
I’m happy to announce that the book I’ve been working on for the past two years is complete and has...
2012-09-05
573 reads
Error: ACCESS DENIED on installation Generally you would get error on: >> During installation >> when try to start the sql services....
2012-09-05
911 reads
SSMS reports are one of the best ways to pull some great deal of Server level or Database level information...
2012-09-04
4,736 reads
Let’s pretend we’ve never met. Depending on who you are, maybe we haven’t. It’s beside the point, really.
So hi, I’m...
2012-09-04
933 reads
Wow, I can’t believe it is already September of 2012. Labor day has come and gone, school is in session and the SQL Community is still busy. With that,...
2012-09-04
15 reads
Wow, I can’t believe it is already September of 2012. Labor day has come and gone, school is in session...
2012-09-04
897 reads
I once rowed in the Head of the Charles Regatta. I had the 3d seat, starboard, in a 4 man...
2012-09-07 (first published: 2012-09-04)
2,254 reads
Not long ago I wrote about how to write well about SQL Server, and one major point was that jargon...
2012-09-04
1,142 reads
PASS DBA Fundamentals Virtual Chapter
fundamentals.sqlpass.org / Twitter: @DBAFundVC
September 4, 2012 - 11:00 a.m. CST
Introduction to SQL Server Service Broker
Speaker: Adam Belebczuk
In this...
2012-09-04
1,074 reads
PASS SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Please note that in...
2012-09-04
646 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