In a previous article, I talked about getting started with managing SQL server using PowerShell and the Server Management Objects (SMO). While that was mostly spent making the connection and doing ...

However, having the sequence restart at 1 for each unique value of A (a new UPC) allows us to store F in a smallint, which saves us almost 10% of space per observation over forcing F to be unique.

When you need a SQL database fast, the cloud is the best way to go. Azure provides a SQL database as a PaaS that eliminates the need to get an entire SQL Server deployment up and running.