Utility function: dbo.JobName(@job_id)
As often as I have to pull a job’s name based on its job_id in the MSDB system tables, I’m truly...
2016-04-08 (first published: 2016-03-28)
1,493 reads
As often as I have to pull a job’s name based on its job_id in the MSDB system tables, I’m truly...
2016-04-08 (first published: 2016-03-28)
1,493 reads
The Nordic SQLNexus conference is taking place in Copenhagen on May 2-4. I’ve never been to the event, or the...
2016-03-28
601 reads
I answered an interesting question on SE today (ever notice how many posts come from stuff I read on forums?)...
2016-03-28
511 reads
When you look after more than a few SQL Servers you will need to perform the same actions against a...
2016-04-08 (first published: 2016-03-28)
1,708 reads
With SQLPort approaching it’s 6th birthday (21st of April), I have to admit that the works on the user group...
2016-03-27
486 reads
Well, after many late nights I have finally produced a set of podcasts – Bite size style – therefore called SQL Bite...
2016-03-27
286 reads
1. Tell me about yourself.
Answer - Give summary of your past education and work, skills, and achievements and include your strong...
2016-03-27
172 reads
Interview is a three stage process. Before => Interview => After
A. Before Interview -
1. Most important, ready your Resume/CV. Be confident about...
2016-03-26
180 reads
I’m all like:
Because I saw this on an eval:
I’ve been trying to ramp up to take advantage of my MSDN...
2016-03-25
1,154 reads
Recently I have posted a article in SQLServerCentral on Fixing Maintenance Plan Error code 0x534
Read My Article "Here"
For more updates:
Subscribe for...
2016-03-25
161 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