Tag Archives: sql server

How to generate ids programmatically using SQL Server and Entity Framework

TL;DR: create a sequence and execute stored proc to read from it Generating ids in the database is used to be the default and near to the only one approach but now days this trend is fading away. Here’s some … Continue reading

Posted in Programming | Tagged , | Leave a comment

Could not load file or assembly ‘Microsoft.AnalysisServices, Version=

If you’re getting the following error upgrading TFS 2012 RTM to ver. 2012.3: TF255356: The following error occurred when configuring the Team Foundation databases: TF400711: Error occurred while executing servicing step Upgrade Warehouse for component UpdateWarehouseVersion during FinishInstallUpdates: Could not … Continue reading

Posted in Infrastructure | Tagged , , | Leave a comment