SQL Server Management Studio may not include all important parts of your table when you let it write the CREATE TABLE script. For instance, the full-text index for a table is omitted by default. If you use the full-text search feature, you should make sure that SQL Server Management Studio includes them in the create …
Blazor Train is a free, extensive course on Microsoft Blazor created by Carl Franklin. You may know Carl from the podcast .Net Rocks or from Music to Code By. Blazor is Microsoft’s implementation of WebAssembly, that lets you write your interactive web applications in C# instead of JavaScript. We use Blazor successfully at work to …
SQL Server offers an integrated alarming system that informs you by email when something goes wrong. In the past this helped us find problems early on and react quickly – before we lost data. Let us look how we can activate this feature in SQL Server. Activate Database Mail Open up SQL Server Management …
A quick demo on how schema migrations works in DbUp took an interesting turn as we tried to insert some values into our database:
|
1 2 3 4 5 6 |
Beginning database upgrade Fetching list of already executed scripts. Executing SQL Server script 'DBMigration.Scripts.Script0004.sql' Upgrade failed due to an unexpected exception: System.InvalidOperationException: Variable a4 has no value defined at DbUp.Engine.Preprocessors.VariableSubstitutionPreprocessor.ReplaceToken(Match match, IDictionary`2 variables, Match commentMatch) in C:\projects\dbup\src\DbUp\Engine\Preprocessors\VariableSubstitutionPreprocessor.cs:line 62 |
Until now I never had such a problem and we were a bit puzzled. Where is the variable a4 coming from? All we wanted to do is to run this …