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.

sets new column values in your DB2 table by using the SAS variable values that are indicated in your map. When you execute the DB2UTIL procedure, you specify an input SAS data set, an output DB2 table ...

Using default values on database columns helps to insulate database design issues from application code. Find out how to change a column's default value at a later date using a single command.

How do you retrieve a row based on values in the properties of a JSON object in a text column? This is where the next part of the SQL Server 2016 support for JSON comes into play.

With SQL Server 2016, you can store JSON objects in your rows. Here’s how to work with JSON objects, including how to update them once you’ve found them. In a previous Practical .NET column I showed ...