Blog – Page 3 – Jos Menhart SQL Consultancy

24Apr 2020 by Jos Menhart

Learning Web Development (1)

C# Development, Learning web development

Introduction After having worked as a database professional for years I decided it is time to look ahead and think what I would like to be doing in the future. Of course I still love databases but I have always been a little jealous of my programmer friends who are able to create beautifully designed and functional websites from scratch. So, it is time for me to start learning on this new track: and to make sure what I am learning also stays around in my head I am creating this next series of blog posts in which I will document my learnings. Of course, I will be needing some homework exercises. Or.. Cryptocurrency The past years I have been watching the Bitcoin/Altcoin market on and off, and I own…

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…

Logging with NLog. Just trying it out

C# Development, Programming

I was just trying out the log4net framework when I came to a better and more usable alternative. https://nlog-project.org/ is easier to use and configure and has more options, like structured logging. I dabbled with it a bit, and you can find my little project on github: https://github.com/Josbourne2/TestNlog