T-SQL–Converting Seconds to Time
I was working on a small piece of code the other day that was calculating the seconds for an event....
2014-07-23
1,500 reads
SQL Server 2012 with SP2 Slipstream ISO images fixed
Microsoft fixed SQL Server 2012 with SP2 Slipstream ISO images do not install SP2 issue. The new ISOs have been posted on their respective release channels (MSDN…) and are...
2014-07-23
40 reads
Cumulative Update – 11 for SQL Server 2012 Service Pack 1 Is Now Available !
The 11th cumulative update release for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft Support site. Cumulative Update 11 contains all the hotfixes...
2014-07-23
20 reads
Challenge Accepted
There seemed to be some question whether my comfort level with my own masculinity would prevent me from wearing these:
Oh...
2014-07-23
709 reads
Find Users Logged Into Remote Computer
Have you ever wanted to find out if someone is logged into a computer or maybe who is logged into...
2014-07-29 (first published: 2014-07-23)
10,215 reads
My Visit to Redmond
Last week, I had the pleasure of attending the EBC in Redmond. If you don’t know what EBC is, that’s...
2014-07-23
562 reads
Why am I getting a primary/unique key violation?
This may seem like a question with a simple answer but there is a bit more to it than you...
2014-07-23
1,759 reads
SQL Server 2012 with SP2 Slipstream ISO images fixed
Microsoft fixed SQL Server 2012 with SP2 Slipstream ISO images do not install SP2 issue. The new ISOs have been...
2014-07-23
1,643 reads
Cumulative Update – 11 for SQL Server 2012 Service Pack 1 Is Now Available !
The 11th cumulative update release for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft...
2014-07-23
720 reads
Building the SQLSaturday Orlando Marketing Plan-Part 24
We’re at 180 registered so far and we haven’t published the schedule yet! So far so good. We’re on track...
2014-07-22
600 reads
Blogs
A New Word: Semaphorism
By Steve Jones
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
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 James Serra
(This is the third post in a three-part series on how AI is changing...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Layanan BCA KCP Rembang Hub/Wa. 0817-819-444
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
WhatsApp:0817819444 Jl. Pemuda No.57B, Blora, Tempelan, Kec. Blora, Kabupaten Blora, Jawa Tengah 58211
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] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, 'true')
GO
See possible answers