04May 2020 by Jos Menhart
Reinstall your development laptop, fast

Reinstall your development laptop, fast

Programming, Random stuff, Tools
Today was one of those days again. You know, one of these days when Visual Studio keeps freezing up on you and you decide to finally do something about it. After a few hours disabling extensions to no effect, and comparing with my other laptop where VS is working without issue I decided to do a fresh reinstall of my laptop. Windows, all programs, everything. Cleaning Windows Everything I need is on my secondary disk so I did a windows refresh: just type "reset" in Start and follow the breadcrumbs: Reset this PC Alternatively, you can download the Windows iso manually from your msdn benefits page. Next, we wait.. Waiting... Scripted installation After reinstalling my laptop a few times it became time to do it differently. I now use a…
Read More
27Feb 2020 by Jos Menhart

Customizing SAP PowerDesigner Object Templates

SAP PowerDesigner, Tools
  Last week I ran into an issue when creating a stored procedure in a SAP PowerDesigner Physical Data Model. After creating the stored procedure and viewing it in the preview window I noticed something was looking odd: the create procedure statement was showing a pair of empty brackets after the procedure name. Empty brackets in a create proc statement? After running the create statement in SSMS, SQL Server confirmed my suspicion by throwing a syntax error: SQL Says No Next, I investigated the stored procedure body in the editor and found that apparently, PowerDesigner's default SQL Server template for stored procedures features a pair of brackets around the stored procedure parameters. Procedure parameters parameter, enclosed by brackets.. Of course, I tried manually deleting them but this was no use…
Read More