This was a good question. Thanks!

Thanks for sharing! This is an interesting question to start the week. For those starting work after the holidays - Have a Happy New Year 2020!

Reading the documentation and some...

• This reply was modified 4 years, 10 months ago by  Nakul Vachhrajani.

Wouldn't '2019-01-18 20:23:10' print as Sep 1 2019 8:23 PM? 🙂

Learnt something new today. Thank-you for the QotD.

Have a great week ahead!

Learnt something new today. Thank-you!

Is there any particular reason to use SHA1 instead of MD5? I would recommend changing the algorithm and then validating if the changes are being detected correctly or not. SQL...

The problem is scalability. Aggregations are blocking transforms. Hence, they block the data flow in the pipeline and start bloating the memory (as they keep the entire result set in...

If my source is a SQL Server, I generally prefer using CAST/CONVERT for the appropriate data-type conversion. For non-relational sources (e.g. an Excel File), I use the Data Conversion Transform.

Thank-you, all for taking the time to read my article and share your valuable feedback. I have made to the article since the original publication:

- Added a new section –...

h.tobisch (8/24/2016)

---

It is not true that ANSI WARNINGS OFF generates a result of NULL on zero divide.

Moreover - there is no result generated at all.

What happens is that...

ebouras (8/23/2016)

---

Did I miss in the article exactly why your developers needed the warnings set off? The implication is that they were trying to account for bad data. ...

Whatever value we supply is taken by SQL Server as the value to be set.

For example, the following turns ANSI_WARNINGS (8), QUOTED_IDENTIFIER (256) and XACT_ABORT (16384) to ON. The value...

Exactly. That's why I was concerned when the development team asked me whether it would be okay...