On Being Disruptive
Being disruptive is a powerful way to conduct business. Steve Jobs and Bill Gates insisted that computers belonged not just...
2016-12-20 (first published: 2016-12-05)
1,738 reads
Being disruptive is a powerful way to conduct business. Steve Jobs and Bill Gates insisted that computers belonged not just...
2016-12-20 (first published: 2016-12-05)
1,738 reads
So far I’ve worked on simple analytical techniques using one or two variables in a dataset. This article is a...
2016-12-05
1,002 reads
I created this small snippet to allow a list of values from a json file be turned into variables to...
2016-12-05
308 reads
You are the DBA your company makes you. Aren’t you?
SQL Server has such a wide range of features that no...
2016-12-05
310 reads
I recently needed to replicate all of the reports on one report server to a different server. I started downloading...
2016-12-04
1,453 reads
I work on a few projects and have a bunch of demos setup, but I don’t work on them all...
2016-12-04
566 reads
Dear all,
Welcome to the first ever interview of DataChannel. I am honored to have Mr.Andreas Wolter, a German MVP, MCM, MCSM...
2016-12-03
743 reads
More dbatools experimentation for me. This is a great set of Powershell cmdlets that solve simple, handy problems. In this...
2016-12-02
1,041 reads
People who have been working for a while with Integration Services probably know the legendary blog post by SQL Server...
2016-12-13 (first published: 2016-12-02)
5,440 reads
Another week almost over so here’s a random selection of articles that I’ve been reading…
Changing the SQL Server port on...
2016-12-02
382 reads
By James Serra
(This is the third post in a three-part series on how AI is changing...
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
Comments posted to this topic are about the item Pay for Performance, which is...
Comments posted to this topic are about the item Helping an English Student with...
Comments posted to this topic are about the item Adding Bits I
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