The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

  • Twitter Updates

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 1,839 other subscribers

Archive for the ‘Development’ Category

Git: Push a new or existing repo to Github · GitHub

Posted by jpluimers on 2019/11/27

Since I tend to forget the exact statements for starting a fresh repository and push it to a git hoster like GitHub or GitLab: [WayBack] Git: Push a new or existing repo to Github · GitHub

–jeroen

Posted in Development, DVCS - Distributed Version Control, git, GitHub, GitLab, Software Development, Source Code Management | Leave a Comment »

Delphi: IOTASourceEditor uses UTF8, so conversions are needed to/from regular strings

Posted by jpluimers on 2019/11/27

Some important points from [WayBackGo straight to JAIL! DO NOT Pass GO! DO NOT Collect £200 – Dave’s Development Blog.

The most important one is that the IOTASourceEditor (which is hardly documented in the docwiki) uses UTF8, so conversions are needed to/from regular strings.

The other is that by now any Unicode letter can be used as part of an Object Pascal identifiers so if you match, you need to take that into account.

Note that in practice using non-ASCII Unicode letters still fails with a lot of tooling (not just limited to Object Pascal), so be careful with those.

–jeroen

via: [WayBack] Go straight to JAIL! DO NOT Pass GO! DO NOT Collect £200  – David Hoyle – Google+

Posted in Delphi, Development, Software Development | Leave a Comment »

How to Send Emails with Gmail using Python

Posted by jpluimers on 2019/11/27

The cool thing about [WayBack] How to Send Emails with Gmail using Python is that it covers a broad range of email sending topics:

  • regular connections
  • secure connections
  • authenticating
  • rate limits
  • Google disallowing SMTP by default

Well wordt reading it, and the references:

–jeroen

Posted in Development, Python, Scripting, Software Development | Leave a Comment »

windows – How do I limit MS SQL Server memory usage? – Server Fault

Posted by jpluimers on 2019/11/26

Sometimes you need this so it easier to run other services on the same system: [WayBack] windows – How do I limit MS SQL Server memory usage? – Server Fault.

Thanks wfaulk.

From How to configure memory options using SQL Server Management Studio:

Use the two server memory options, min server memory and max server memory, to reconfigure the amount of memory (in megabytes) managed by the SQL Server Memory Manager for an instance of SQL Server.

  1. In Object Explorer, right-click a server and select Properties.
  2. Click the Memory node.
  3. Under Server Memory Options, enter the amount that you want for Minimum server memory and Maximum server memory.

You can also do it in T-SQL using the following commands (example):

exec sp_configure 'max server memory', 1024
reconfigure

Related:

–jeroen

Posted in Database Development, Development, SQL Server | Leave a Comment »

some links on bash and optional parameters

Posted by jpluimers on 2019/11/26

Hopefully I’ve been able to integrate some of the ideas in the links below in github.com/jpluimers/btrfs-du/blob/master/btrfs-du

One of the features I wanted there was to be able to add optional switches like --raw, --iec or --si to it similar to what as the btrfs qgroup show subcommand has.

It seems possible with bash, but it is not trivial, at least not for me as a non-frequent bash user, so here are some links to get me started:

In retrospect, other languages than bash might have been a better choice for a script like that (:

–jeroen

PS, some btrfs references:

Posted in *nix, *nix-tools, bash, bash, Development, Power User, Scripting, Software Development | Leave a Comment »

GitHub – NickRing/Delphi-Shortcut-Finder: Shows/find keyboard short-cuts have be assigned, that may be conflicting.

Posted by jpluimers on 2019/11/26

Cool tool: [WayBackGitHub – NickRing/Delphi-Shortcut-Finder: Shows/find keyboard short-cuts have be assigned, that may be conflicting.

Via: [WayBack] I need some help from anyone who knows RTTI better than me. I’m writing an OTA tool to list all the actions or keybindings that are associated with a s… – David Hoyle – Google+

David has an excellent series of blog posts on writing experts around his tool [WayBack] IDE Explorer – Dave’s Development Blog.

–jeroen

Posted in Delphi, Development, Software Development | Leave a Comment »

ALTER DATABASE Compatibility Level (Transact-SQL) | Microsoft Docs

Posted by jpluimers on 2019/11/21

Since I keep forgetting which numeric value can correspond to what kind of server: [WayBack] ALTER DATABASE Compatibility Level (Transact-SQL) | Microsoft Docs

Product Database Engine Version Compatibility Level Designation Supported Compatibility Level Values
SQL Server 2019 15 150 150, 140, 130, 120, 110, 100
SQL Server 2017 (14.x) 14 140 140, 130, 120, 110, 100
Azure SQL Database logical server 12 130 150, 140, 130, 120, 110, 100
Azure SQL Database Managed Instance 12 130 150, 140, 130, 120, 110, 100
SQL Server 2016 (13.x) 13 130 130, 120, 110, 100
SQL Server 2014 (12.x) 12 120 120, 110, 100
SQL Server 2012 (11.x) 11 110 110, 100, 90
SQL Server 2008 R2 10.5 100 100, 90, 80
SQL Server 2008 10 100 100, 90, 80
SQL Server 2005 (9.x) 9 90 90, 80
SQL Server 2000 8 80 80

–jeroen

Posted in Database Development, Development, SQL Server | Leave a Comment »

Unorthodocs: Abandon your DVCS and Return to Sanity – bitquabit

Posted by jpluimers on 2019/11/21

Some interesting thoughts on DVCS: [WayBackUnorthodocs: Abandon your DVCS and Return to Sanity – bitquabit

Besides the very good point it raises about DVCS (Git, Mercurial and most other DVCSes treat the whole state of the repository as the atom) it also indicates quite a few shortcomings:

  • most people hardly ever need the full history to be off-line
  • having the full history means repositories get huge in size, including your off-line clone
  • pseudo-solutions for huge repository sizes – like git-LFS or git-annex – are a no-go because now you loose atomicity
  • huge repositories in file or commit counts make them slow, especially when the trees are deep
  • splitting up repositories isn’t a good idea either because again: you loose atomicity
  • all DVCS are hard, not just git, because they are distributed and full of features
  • the workflow for submitting pull requests is quite a bit longer than submitting a patch, even though merging in a DVCS can be hard too (despite atomicity which does help a lot for DVCS systems)

I see many other advantages of DVCS systems (for instance that you only need to locally have the branches you are interested in, way better tooling for DVCS systems, ditto for sites hosting DVCS), but it always a good thing to know the weak spots of what you are working with.

–jeroen

Posted in Development, DVCS - Distributed Version Control, git, Mercurial/Hg, Software Development, Source Code Management | Leave a Comment »

Scopes and names can really be deceiving. A classes in a hierarchy can have members with identical names…

Posted by jpluimers on 2019/11/21

Examples like the one below from [WayBack] Scopes and names can really be deceiving. A root class and a descendant class can both have public fields, properties and methods with the same name… – Lars Fosdal – Google+ used to be part of the “language day” during my 5 day Delphi introductory courses.

Maybe I should find back more of those from the days, brush them up a little, then post them in a repository.

The thread has some nice references to tools that give better warnings and comparisons with other languages.

Anyone wanting to assist with that?

Example code

Read the rest of this entry »

Posted in Delphi, Development, Software Development | Leave a Comment »

Any idea what exactly mean …licensed to test ??? My Delphi is…

Posted by jpluimers on 2019/11/20

Your Delphi “licensed to” might be totally different from what it is actually licensed to.

From [WayBack] Hello people, any idea what exactly mean …licensed to test ??? My Delphi is registered with a valid account, subscription, serial number and so on. – Dobrin Petkov – Google+, at least these sources might be used different from the actual licensee name:

  • the VLAN name
  • the Windows username of the one that installed it
  • the Windows licensee

–jeroen

Posted in Delphi, Development, Software Development | Leave a Comment »