SQL Server has many different ways (column types) to represent date/time values, and depending on which one is used in the database table, you may have some surprising results when trying to consume ...

Arthur Fuller explores the value of identity columns and the usefulness of their arbitrary values and discusses ways to use SQL Server 2000's IDENTITY_INSERT setting.

This post shows some expressions that we needed to use to consume SQL Server time columns – and it was fairly complex. We have since released a new feature in PowerApps that makes this easier. Take a ...

Title SQL Server bulk insert generates table without specifying varchar column size Functional impact For SQL Server, a runtime exception is thrown and you cannot save changes on a DbContext when t ...