Reputation
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
4 20 46
Newest
 Caucus
Impact
~424k people reached

Jul
24
revised How to find where an unauthenticated user connects from
Tags added and improved formatting.
Jul
22
revised How to log custom messages from inside a PostgreSQL transaction?
added 13 characters in body
Jul
22
comment How to log custom messages from inside a PostgreSQL transaction?
That array construction is unnecessary complicated, why not simply use a ARRAY[my_dblink_name]?
Jul
22
revised How to log custom messages from inside a PostgreSQL transaction?
narrowing code block to avoid horizontal scrolling
Jul
22
revised Concatenate columns uniquely on the same table in MS ACCESS
edited tags
Jul
22
reviewed Leave Closed PostgreSQL - what do tms and mt mean in a SELECT query?
Jul
22
comment Setting shared_buffers over 320 MB prevents Postgres from restarting
Yeah, @CraigRinger is right - that system is so old it already has grandchildren... Other than that, do you get an error message of some sort?
Jul
21
comment How to log custom messages from inside a PostgreSQL transaction?
This is in an interesting contrast to what I saw while using psql interactively: dba.stackexchange.com/a/23618/6219
Jul
21
reviewed Close what is other way of use Limit function in MSSQL server
Jul
21
reviewed Close cannot delete db table
Jul
21
reviewed Reject optimizing paging in a stored procedure
Jul
21
reviewed Reviewed Can I use OpenLDAP to authenticate users in Oracle?
Jul
21
comment Can I use OpenLDAP to authenticate users in Oracle?
@FredPetillot and when that page moves somewhere else or just stops being there, your answer will contain zero bits of information.
Jul
21
comment What is the best way to take backup for Remote DB Server
Please define what you exactly mean by backup here. Depending on the RDBMS, there might be several options, some are not doable via JDBC.
Jul
21
reviewed Close Database Noob: Transfer Data from Windows Server to Web Server Hosted Online
Jul
21
comment Database Noob: Transfer Data from Windows Server to Web Server Hosted Online
scp, sftp, remote bulk load and some less secure options.
Jul
21
reviewed Close Database vs private Blockchain - any strong use cases for the latter?
Jul
21
reviewed Close Replace part of URL only if doesn't contain a given part
Jul
21
revised PostgreSQL - what do tms and mt mean in a SELECT query?
added 200 characters in body; edited title
Jul
21
comment DB design for employee working hours constraints
These decisions are usually a function of how much data (eg how many employees) you have, how (often) you access this data, how fast the response should be and so on. Building the availability table shouldn't be that difficult - why not try it yourself?