All posts for Sql Server
Below are various technologies employed by the current site, along with others that I also continue to use.
Here are a few changes I came across migrating a medium sized app from 4.7.2 to Core 2.1.
There are some pretty significant differences, especially with model annotations. Fluent API handles most of the configuration now.
Global changes, such as a default string length, take a bit more effort...
Azure Sql databases do not come with a lot of the adminstration stored procedures that are part of a local instance install.
sp_MSforeachtable is a handy sp that allows you to iterate through specified objects. It is considered an undocumented feature, so may disappear, but can easily be...