MVP Data Platform
Holy Cow! I still can’t believe it, I was awarded the Microsoft MVP – Data Platform today. I guess I really...
2018-01-04
621 reads
Holy Cow! I still can’t believe it, I was awarded the Microsoft MVP – Data Platform today. I guess I really...
2018-01-04
621 reads
Azure SQL Analytics is currently in preview mode, still it is very impressive. The goal of this feature is to...
2018-01-04
1,039 reads
In this article I have introduced you to a quick session setup that comes from using the SPDiag tool that could plausibly be useful in the troubleshooting of various...
2018-01-04
67 reads
One of the all-time greatest and most beloved applications among DBAs happens to be Sharepoint. Most of us would be...
2018-01-04
1,672 reads
TDE is commonly described as “at-rest” encryption, i.e. it protects your data wherever it is stored on disk. This includes...
2018-01-15 (first published: 2018-01-03)
3,207 reads
As a follow up to my tweet, I stand by my belief that DevOps does not make administrators obsolete. I...
2018-01-11 (first published: 2018-01-03)
1,060 reads
Back in 2015, I said would think about speaking in my #TSQL2sday #61 post. Well here it is 2018 and...
2018-01-03
395 reads
Have you ever wanted to have two different queries open up at the same time where you could see them,...
2018-01-03
341 reads
In the second part of our series on creating a SQL Server test lab on your workstation, I’m going to...
2018-01-12 (first published: 2018-01-03)
2,341 reads
I have been working on a new information session, which I’m hoping to deliver this year. It’s about one of...
2018-01-03
318 reads
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
This is my late response to T-SQL Tuesday #204. I almost always forget about...
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
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