Converting to the SSIS 2012 Project Deployment Model
The new project deployment model in SSIS 2012 is the new standard for how packages are created, configured and deployed. ...
2012-05-22
9,615 reads
The new project deployment model in SSIS 2012 is the new standard for how packages are created, configured and deployed. ...
2012-05-22
9,615 reads
Denali – Day 22: SQL Server Developer Tools SSDT (Aka “Juneau”)
As stated earlier on blog on “LocalDB” discussion, developers are involved...
2012-05-22
912 reads
There are some things that we do in one SQL Server tool, but can't seem to figure out how to do in another. One of those for you might...
2012-05-22
41 reads
I am wrapping up this series by finally considering the rarely used type 3 SCD.
( i.e. in most business scenarios)
Unlike...
2012-05-22
861 reads
I received an email from LinkedIn suggesting that I might find these groups useful:
I’m sure those map back to someone...
2012-05-22
732 reads
There are some things that we do in one SQL Server tool, but can't seem to figure out how to...
2012-05-23 (first published: 2012-05-22)
21,116 reads
Microsoft has released two new Cumulative Updates for SQL Server 2008 today. The first one is SQL Server 2008 SP3...
2012-05-21
2,037 reads
I love SQL Prompt as an add-in for SSMS. The intellisense is very handy for me and I’ve gotten used...
2012-05-25 (first published: 2012-05-21)
2,723 reads
Pragmatic Works has now released version 3.5 of the award-winning BIxPress software! For those not familiar with BIxPress it’s a...
2012-05-21
1,196 reads
If you are using the Tabular model in SSAS, it will use the xVelocity technology to load your entire database...
2012-05-24 (first published: 2012-05-21)
3,799 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...
WhatsApp:0817819444 Jl. Mahendradatta Selatan No. 99 AX, Padangsambian, Kec. Denpasar Bar., Kota Denpasar, Bali...
WhatsApp:0817819444 Jl. Raya Sesetan No.301, Sesetan, Denpasar Selatan, Kota Denpasar, Bali 80223
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