Doing it with the EzAPI
In my last post, I attempted to write a SQL Server Integration Services (SSIS) Package programmatically.
I used the API that...
2014-03-09
4,649 reads
In my last post, I attempted to write a SQL Server Integration Services (SSIS) Package programmatically.
I used the API that...
2014-03-09
4,649 reads
Database Normalization
Theoretical versus real-world
There is not a strong need for developers to know the theoretical definition of 1st thru 5th...
2014-03-17 (first published: 2014-03-09)
6,591 reads
The last twelve months in my certification world have been rather odd. First, Microsoft has terminated their Microsoft Certified SQL...
2014-03-09
738 reads
When you’ve got a SIEM appliance or application, you want actions and events going into it as a central repository....
2014-03-07
1,365 reads
Photo credit – Husso
I’ve always been a fan of the feeling when I find an old blog post that’s got just...
2014-03-07
859 reads
This never gets easier. I was able to attend a bunch of sessions in the last month from a number...
2014-03-07
877 reads
DISABLE und DENY LOGIN, DENY USER & Effekt auf Impersonierung und Berechtigungen
(de)
Ein kurzer Artikel zu den Effekten – oder fehlenden Effekten...
2014-03-07
1,009 reads
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-03-07
469 reads
Today, I received an email from the developer asking if there is a better way instead of the COUNT (*) Transact-SQL...
2014-03-06
1,465 reads
This is part of a series where I set up a virtual lab for testing and misc. work. The other...
2014-03-06
1,076 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