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,768 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,768 reads
I had the honor to speak for the first time at this past PASS Summit 2013 in Charlotte, NC. It...
2013-10-27
844 reads
This year I was honored to sponsor and speak at IT Pro Camp Tampa 2013. Like always, it is a...
2013-10-27
881 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,518 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,634 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
676 reads
This past Saturday March 16th, I had the opportunity to speak once again the .Net Orlando Code Camp. I presented...
2013-03-18
775 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
875 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
863 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,507 reads
Here’s how these tools can make Kubernetes security easier and help you avoid common...
By Steve Jones
lackout – n. the sudden awareness that you’re finally over someone, noticing that the...
By Ed Elliott
All Spark Connect Posts I have just finished an update for the spark connect dotnet...
WCOstream is built for people who genuinely love anime and cartoons. The site offers...
In Azure SQL DB, i want to merge records from the staging table to...
Full error message: SSRS error: The Value for the image 'Image1' has a constant...
I have a table, called dbo.logger, in SQL Server 2022. I decide to add two new columns to this table with this code.
ALTER TABLE dbo.logger ADD CreateDate DATETIME CONSTRAINT dfGetDate DEFAULT GETDATE() GO ALTER TABLE dbo.logger ADD ModifyDate DATETIME DEFAULT dfGetDate GOWhat happens when I run these two batches? See possible answers