Volunteer for PASS!
This week, I had the opportunity to be the moderator for Joseph Barth’s (blog|twitter) 24 Hours of PASS Summit Preview session about Azure Data Factory V2. It was fun,...
2018-06-15
15 reads
This week, I had the opportunity to be the moderator for Joseph Barth’s (blog|twitter) 24 Hours of PASS Summit Preview session about Azure Data Factory V2. It was fun,...
2018-06-15
15 reads
Hello!
Concluding this weeks work on PoshSSDTBuildDeploy is adding one of the features I spoke about yesterday, which was joining the OperationSummary and Alerts objects to produce a new table...
2018-06-15
39 reads
By Steve Bolton
…………This informal series of tutorials on how to implement a hodgepodge of information metrics in SQL Server is...
2018-06-25 (first published: 2018-06-14)
2,205 reads
I am so excited to announce that I will be giving my Data Types Do Matter session for the SalemSQL...
2018-06-14
262 reads
Your transaction log is full. Both Microsoft, and about 100 articles and blogs have covered this topic, but let's take...
2018-06-14
376 reads
In the previous articles, we discussed several ways of taking backup and testing the restore process to ensure the integrity...
2018-06-14
1,042 reads
I typically don’t write opinion posts, but given recent events I thought it was important to follow up on one of my tweets....
2018-06-29 (first published: 2018-06-14)
2,285 reads
I’ve been trying to get time to play with Docker more. I had it setup on my old laptop and...
2018-06-14
1,125 reads
tl;dr; When doing an insert across a linked server you have to include the list of fields to be inserted...
2018-06-14
566 reads
Hello!
Continuing on with my efforts to make the SSDT Deployment Report more useful, I’m pleased to say that I’ve added reporting on any alerts that appear in the Deployment...
2018-06-14
37 reads
Once upon a time I had a series about some cool stuff in Snowflake:...
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
Telp/Wa 62817825533 Jl. Cempaka No.17, Sukorejo, Kec. Sukorejo, Kota Blitar, Jawa Timur 66111
Telp/Wa 628217555651 Jl. Gajah Mada No.14-18, Kelurahan Jember Kidu, Jember Kidul, Kec. Kaliwates, Kabupaten...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
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