MySQL TinyInt treated as Boolean
When working with a MySQL database as a source you may experience some unexpected results in your data extracts. Most of the...
2015-04-29
2,906 reads
When working with a MySQL database as a source you may experience some unexpected results in your data extracts. Most of the...
2015-04-29
2,906 reads
This year I was honored to sponsor and speak at IT Pro Camp Tampa 2013. Like always, it is a...
2013-10-27
913 reads
I had the honor to speak for the first time at this past PASS Summit 2013 in Charlotte, NC. It...
2013-10-27
883 reads
Working with the SSIS, SSAS, and SSRS Business Intelligence projects along with Database projects in the same Visual Studio 2008...
2013-08-14
2,714 reads
I recently downloaded the Hortonworks Sandbox v1.3 Hyper-V VM and had a hard time connecting to the included web interface...
2013-08-08
1,677 reads
I’m truly honored to be chosen to speak at PASS Summit 2013. The honor is compounded as I have been...
2013-05-22
716 reads
This past Saturday March 16th, I had the opportunity to speak once again the .Net Orlando Code Camp. I presented...
2013-03-18
812 reads
I have been appointed as PASS Regional Mentor for the Greater Southeast by PASS (http://www.sqlpass.org). I am truly honored to...
2012-08-21
921 reads
Everyone heard about Facebook’s recent purchase of Instagram for $1 billion dollars. No one can imagine how they came with such...
2012-04-11
899 reads
On a recent project I was asked to “upgrade” a licensed SQL Server 2008R2 Standard Edition to SQL Server 2008R2 Enterprise Edition....
2012-03-30
6,964 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