A trusty old friend – The BCP utility
One of the requirements that springs up around data stores – regardless of if they are relational, not relational, cloud based or some other variety is (unsurprisingly) the need...
2020-03-08
302 reads
One of the requirements that springs up around data stores – regardless of if they are relational, not relational, cloud based or some other variety is (unsurprisingly) the need...
2020-03-08
302 reads
Every ETL pipeline is only ever as reliable as the data that the upstream system provides. It is inevitable that assumptions you make about the data you are provided...
2020-03-06
19 reads
Every ETL pipeline is only ever as reliable as the data that the upstream system provides. It is inevitable that assumptions you make about the data you are provided...
2020-03-06
36 reads
Sometimes a swift kick in the rear is needed to become motivated. Recently, I was the recipient of the business end of a boot and it drove me to...
2020-03-06
22 reads
Last week (as I write this), Kevin Hill (blog | twitter) released the first episode of his new podcast Data Bits. I enjoyed listening to it and said “hey...
2020-03-05
23 reads
I recently spoke at a conference and was asked what is the easiest way to import databases to Azure SQL Database. Therefore, I wanted to share how I do...
2020-03-04
32 reads
I recently spoke at a conference and was asked what is the easiest way to import databases to Azure SQL Database. Therefore, I wanted to share how I do...
2020-03-12 (first published: 2020-03-04)
771 reads
I’m proud to announce that I’ve been awarded the VMware vExpert community award for the calendar year 2020. I’m absolutely thrilled to be awarded this title for the eighth...
2020-03-04
22 reads
My co-authors and I recently wrapped up the book SQL Server 2019 Administration Inside Out, which should be hitting the shelves in the next week or two. At the...
2020-03-04
103 reads
After my post last month about configuring your tools I’ve been on a make my life easier kick and one ... Continue reading
2020-03-13 (first published: 2020-03-04)
2,714 reads
Recently, in an attempt to thwart leechers (1990s kids will know), I added some...
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...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
Comments posted to this topic are about the item Adding Bits II
Comments posted to this topic are about the item An Unlimited Token Budget
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