New Pluralsight Course – LFCE: Linux Service Management – Advanced HTTP Services
My new course “LFCE: Linux Service Management – Advanced HTTP Services” in now available on Pluralsight here! If you want to learn about the...
2018-02-17
531 reads
My new course “LFCE: Linux Service Management – Advanced HTTP Services” in now available on Pluralsight here! If you want to learn about the...
2018-02-17
531 reads
Overview of SQL Server Error 3013
One of the most frustrating situations that a user experiences while working with SQL Server...
2018-02-17
17,593 reads
My son, who wishes to be known as “Pigeon” for the duration of this blog, was mixing the names of Hogwarts...
2018-02-17
1,121 reads
I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and...
2018-02-16
808 reads
Hello Dear Reader! Sorry it has been so long, I've been blogging over on the MSDN site about technology. I'll have a Twitter Sentiment update for Black Panther later...
2018-02-16
17 reads
Hello Dear Reader! Sorry it has been so long, I've been blogging over on the MSDN site about technology. I'll...
2018-02-16
420 reads
Ok, I’ll admit it. I like scripts that are handy and do things. Especially if the scripts make my life...
2018-03-01 (first published: 2018-02-16)
2,367 reads
Until SQL 2016 if you used TDE (Transparent Data Encryption) you couldn’t use backup compression.
In 2016 Microsoft changed this, but...
2018-03-01 (first published: 2018-02-16)
2,405 reads
Overview
The SQL Server 2005 and SQL Server 2008 provide a new feature for encrypting data to protect it from...
2018-02-28 (first published: 2018-02-16)
4,706 reads
We had a great joint meeting tonight of the Baton Rouge SQL and .NET User Groups at the Louisiana Tech...
2018-02-15
558 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