There Is a Magic Button, a Rant
OK guys. I think it’s way past time. A bunch of us have been keeping a secret from the rest...
2017-08-01
499 reads
OK guys. I think it’s way past time. A bunch of us have been keeping a secret from the rest...
2017-08-01
499 reads
SQL Server Express v SQL Server Developer Edition
Over the weekend I received the following in an email from Ali Ahmad...
2017-08-01
48,630 reads
Hello friends, in this blog we will learn how we can connect to Azure Subscription using PowerShell. As you know...
2017-08-01
500 reads
[read this post on Mr. Fox SQL blog] Extending on my previous post about redirecting SQL CDC changes to Azure Event Hub, I have had a few people ask for details/options...
2017-07-31
47 reads
[read this post on Mr. Fox SQL blog]
Extending on my previous post about redirecting SQL CDC changes to Azure Event Hub, I...
2017-07-31
2,823 reads
This is the ninth part in the series: SQL Server and Continuous Integration. In this post I’ll add some unit tests...
2017-07-31
1,912 reads
In this module you will learn how to use the Beyondsoft Calendar Custom Visual. The Beyondsoft Calendar displays a single...
2017-08-22 (first published: 2017-07-31)
1,594 reads
After reviewing some recent audit results for a couple of our SQL Servers, I noted the audit checked for start up...
2017-07-31
391 reads
After reviewing some recent audit results for a couple of our SQL Servers, I noted the audit checked for start up...
2017-08-21 (first published: 2017-07-31)
1,875 reads
Ever have the need to create a CSV list in SQL Server? Not sure how? Starting in SQL Server 2017...
2017-07-31
423 reads
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...
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
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