73 votes

How can I protect an SQL connection string in a client-side application?

You don't. You put your SQL Server behind some sort of (probably web) API and use any of the numerous methods for securing an API. Anything which exists on a client's machine is not secure.
Philip Kendall's user avatar
31 votes
Accepted

How can I protect an SQL connection string in a client-side application?

There are two options I can see: The "modern" option: As Philip Kendall explains, don't. Do not directly connect to the database from the client. Instead, have a dedicated backend service ...
sleske's user avatar
  • 10.2k
16 votes
Accepted

What is the "yield" functionality in Windows 3.11?

It was done in the GetMessage call. The heart of a windows application is something like: while(GetMessage(&Msg, NULL, 0, 0) > 0) { TranslateMessage(&Msg); DispatchMessage(&Msg);...
Winston Ewert's user avatar
13 votes
Accepted

Deploy C#/C++ binaries incrementally by patching the difference

You are looking for a tool that can calculate, transfer, and apply binary diffs. You cannot transfer just modified files, since all files will be modified. However, most parts within the files will ...
amon's user avatar
  • 134k
11 votes
Accepted

What happens to multiple parallel tasks running on a server when CPU hits 100% usage?

My question is if the CPU hits 100% usage, are the 10 instances still being parallel processed? Yes. Or Does the CPU start sequencing them instead of parallel processing them? Your processor ...
Erik Eidt's user avatar
  • 33.8k
11 votes
Accepted

Easy Licensing enforcement techniques for C++ Program in Windows

Realistically, there are none. If you make a hash based on the user's hardware, then when they upgrade a hard drive or CPU or network card, or heaven forbid buy a new computer, the software stops ...
user1118321's user avatar
  • 4,993
10 votes

Deploy C#/C++ binaries incrementally by patching the difference

I suggest rsync. Using rsync you don't need to correctly reimplement vast majority of fuctionality like diff algorithm, working with files, network protocol to transfer data and so on. Currently we ...
gapsf's user avatar
  • 216
9 votes

Will Windows handle any memory not freed as well as threads not closed?

Terminating a process has the following results: Any remaining threads in the process are marked for termination. Any resources allocated by the process (including malloc'd memory) are freed. All ...
Robert Harvey's user avatar
8 votes
Accepted

Low latency TCP sockets in .NET

For example, while searching for low-latency open source apps I found this OpenPDC application on Github which seems to be the de-facto standard application for "high-performance data collection" used ...
MaulingMonkey's user avatar
8 votes
Accepted

Fastest way to generate (machine wide) unique 64 bit timestamps on Windows

You mentioned in the comments you're OK to compress the timestamp to 52 bits. Few other people mentioned you can negotiate smaller process Ids. I'm expanding on these ideas with one way to generate ...
nokola's user avatar
  • 196
8 votes

Would it be possible to abstract multi-threading ability for programs not originaly designed for such?

For programs written in an imperative/procedural style, this is next to impossible because the separate threads may access shared data, and correct semantics for larger-grained parallelism can't be ...
Hans-Martin Mosner's user avatar
6 votes

Windows batch files (.bat) coding style standard

When I am writing batch files, they usually rely on the following template: @cls @title Optional Title @echo off setlocal EnableExtensions DisableDelayedExpansion ::Comment that describes purpose and ...
aschipfl's user avatar
  • 173
6 votes

When does gcc not work on Windows

This is quite possibly a calling convention issue as the Linux and Windows differ despite using the same x86 CPU. Even with code generated for the same instruction set, two pieces of code compiled ...
Erik Eidt's user avatar
  • 33.8k
6 votes
Accepted

When does gcc not work on Windows

There are many variations between UNIX-like operating systems and Windows. GCC is most commonly used on UNIX-like operating systems. There are situations where defaults are chosen in tools or code ...
Eric Evans's user avatar
5 votes

SBCL development on Windows, including CFFI

This is a little late, but as of about 2 months ago (05/2018) I found this project called Portacle which bundles SBCL, Emacs, Quicklisp, and more into a single package for Windows 10. All you have to ...
λ Jonas Gorauskas's user avatar
5 votes

Difference between '\n' and '\r\n'

Here is an answer from the best source - Microsoft. Why is the line terminator CR+LF? This protocol dates back to the days of teletypewriters. CR stands for "carriage return" - the CR ...
Ondra Žižka's user avatar
5 votes
Accepted

Could someone write an opensource version of the Windows API?

Could someone write an opensource version of the Windows API? Yes, but you are asking the wrong question! Okay, after that teaser ;-) let's step back a bit. The answer to the question "can someone ...
Jörg W Mittag's user avatar
5 votes
Accepted

Are there system calls like posix in assembly level using int number for windows

Yes. The Windows NT kernel API (which is traditionally accessed by using the functions defined in ntdll.dll) can be accessed directly by use of the int 2e instruction. However this is not a ...
Jules's user avatar
  • 17.8k
5 votes
Accepted

Why would anyone want to build a file system for windows?

There are two aspects to that question: why would one want to develop a filesystem interface to data, and the other, why would one want to do that in userspace? Let's answer the second one first, ...
Jörg W Mittag's user avatar
5 votes
Accepted

Windows batch files (.bat) coding style standard

Naming, the file the variables, the functions. Comments, what the script do, what that complicated portion of code do. Isolate portion of code in functions Consistency in the coding style, whatever ...
Walfrat's user avatar
  • 3,486
5 votes

Why would anyone want to build a file system for windows?

More specifically, why would anyone want to build a User Space file system? Easier semantics. No obscure system calls. Better isolation. A User Space file system crash doesn't bring down the whole ...
Robert Harvey's user avatar
5 votes

Is it a bad idea to use ProgramData to allow non-admin users to update our program?

Presumably these companies have "locked down" their user desktops for [what they consider to be] Good Reasons. By implementing a mechanism that circumvents their Policy, you are opening up a whole ...
Phill  W.'s user avatar
  • 12.2k
5 votes

What happens to multiple parallel tasks running on a server when CPU hits 100% usage?

What a weird question. "Parallel processing" does not imply that threads execute in any particular order, or at any particular rate of completion, or in lockstep with regards to their individual ...
John Wu's user avatar
  • 26.5k
5 votes

Best Practices for constantly checking a table

As with all 'do something when x happens' questions the key is to capture the incoming event, rather than to watch for its effects. Hide your database behind an API, in the Update methods of the api, ...
Ewan's user avatar
  • 75.6k
5 votes

Installation process for a modern complex Windows Software Installation?

From my experience of over more than 10 years of Windows product development, I would recommend to put almost everything above into an MSI based installer, if you want to make it easy for the admins ...
Doc Brown's user avatar
  • 207k
5 votes

Design Unstoppable Service

If the users of those "client PCs" have full administrative rights over their computer, then there is no technological way to prevent them from disabling or removing your service. And if there were, ...
Bart van Ingen Schenau's user avatar
4 votes

Windows Failover Clustering from a Programmer's perspective

I'm pretty familiar with Windows Failover Clustering. It is a large chunk of admin work and budget (if actually fault tolerant. i.e. no using a single SMB3 file server for shared storage). It ...
Kasey Speakman's user avatar
4 votes

Supporting development for older OS

I think this is more of an issue about getting virtualbox or vmware to provide access to the hosts serial port than it is about virtualization OS or even the guest OS. I would start with a host system ...
Thomas Carlisle's user avatar
4 votes

Supporting development for older OS

drivers for some of the custom hardware belonging to the solution are not compatible with later Windows This is the crux of the matter. You can recompile your legacy C program with a newer Visual ...
gbjbaanb's user avatar
  • 48.6k
4 votes
Accepted

Multiple windows

Background While several windows for one application is perfectly possible in Windows (see GIMP implementation), it is not commonly used. One of the reason may be related to technical background. ...
Christophe's user avatar
  • 77.2k

Only top scored, non community-wiki answers of a minimum length are eligible