Nieuwste berichten
-
SQL project flag Invalid objects when run from Azure Pipelines
For most of my .Net solutions, I define the database in a database project (SQL Server Data Tools or SSDT) in the solution and use that to deploy to database server(s). For additional QA, using Azure Pipelines, I often spin up a localdb instance and deploy the database to it, after which I can run […]
—
-
Angular: main.ts is missing from the typescript compilation
After upgrading an existing project from Angular 14 to 15 yesterday, the project would no longer run (with ng serve). The error message was rather confusing: Well, the file was obviously there and present in tsconfig(.app).json. Spent half a day googling and upgrading and downgrading packages to try and fix it to no avail. Even […]
—
in General -
Clear user objects from master db in Microsoft SQL Server
Earlier this week I ran a script that inserted a lot of objects into a (new) database on my local machine, but forgot the USE newdatabase statement at the top. You guessed it… all my objects were created in the master database, and there were a lot of them. Deleting them by hand would be […]
—
in SQL Server -
Modify the message of an unpushed commit with git (and not only the last)
I am still learning my way around git, which I mostly use from within Visual Studio. Today I had to change a commit message because I noticed later that I had mentioned an incorrect ticket number. Fortunately I had not yet pushed the commits to origin. If you need to change the latest commit’s message, […]
—
in General -
Delphi: this version does not support command-line compiling (yes, it does)
There are a couple of rare cases where I do an automatic build of a Delphi application from a batch file. This uses the dcc32.exe command-line compiler. This worked great on one machine, but today it failed on another machine that had an identical setup. The error message was: _PasCoreCompile: This version of the product […]
—
in Delphi -
A (more) concise way to test a SQL MERGE for differences if there are nulls involved
In SQL, if you need to compare two columns that are both nullable, your compare statements can quickly get out of hand (and a lot less readable along the way). While fixing a bug in my code, I found out about a way to keep the comparison short and readable using the EXCEPT (or INTERSECT) […]
—
in SQL Server -
If you publish a WCF service using EF to IIS, do not forget to distribute sqlserver.dll manually
I’ve spent several hours this week debugging a WCF application using Entity Framework, that was published to an IIS server, only to have every call to the service fill with the error message “The type initializer for [My]DbContext has caused an exception”. Of course, on the dev machine everything was working fine. Short answer: as […]
—
-
Outlook 2016 latest update clears POP mailbox
I’m still investigating, but it appears as if Outlook 2016 is clearing my POP mailboxes, despite the accounts having been set to keep the mail for 14 days. This always worked flawlessly, but this morning (29 feb…) Outlook started deleting all emails after reception, not only those older than 14 days. Is it a coincidence […]
—
in General -
Quickly connect to a VPN on Windows 10 (revisited)
Update (June ’17): it has taken more than 1,5 years since I posted this, but the Windows 10 “Creators Update” finally contains a Connect button right in the Network Connections flyout… 🙂 Earlier I wrote about a trick to make Windows 10 connect to a VPN with a single action (double-click) instead of three or […]
—
in General -
You cannot use a null propagating operator in an expression tree lambda
One of the features I like about the new C# 6.0 is the null conditional operator, and I tend to use it everywhere I can (and should). Until yesterday, when at a statement I wasn’t expecting it, the compiler bit me with error CS8072, An expression tree lambda may not contain a null propagating operator. […]
—