Hot answers tagged

14

Is there any reason NOT to use the approach you've defined? Absolutely. Imagine you had bought a car - a car that when you hit 50MPH the engine starts to overheat. Would your reaction to this situation be to artificially limit the car to 49MPH, or to find out what the fault is with the engine? Why should you limit your car to 49MPH? The manufacturer stated ...


11

Erik Darling mentioned the biggest practical reason for not using WSRM in a comment on your question: ...there's no reciprocal limiting of CPU use in other processes. SQL Server may not use those two cores, but other things may use the other 30 SQL Server is using. It's a crapshoot, really. If this is working for you, then stick with it - we're all busy, ...


3

In newer version of PGAdmin4 you can configure SSH-tunnel (there is a tab for this there, but you need to use key in PEM format, not in RFC4716 that is now generated by default with ssh-keygen. Use ssh-keygen -m PEM -t rsa -b 4096 More information here


3

Express Edition [XE] is available for usage by small businesses. You get no upgrades or patches. Support is only available by internet like Google and DBA SE. You are limited to 1 CPU Core, 1 GB of RAM, and 11GB of user data. Current version of XE is 11.2.0.2. Version 18 XE is due out soon (October 2018). I've read Oracle will then release newer ...


3

You need to open the network ports & firewall ports between your desktop running SSMS, and the remote computer. Just generally speaking, though, I'd highly recommend against running the debugger on a live server. You're going to force SQL Server to hold your locks open for longer periods of time, and you can easily cause a blocking storm. Instead, I'd ...


2

why when I log as a normal user it asks for a password and doesn't when i log as superuser? it just doesn't seem safe at all. The small but important detail that you're missing is that nobody but you (or your DBA Team) should be allowed anywhere near the database server and absolutely should not have the postgres account credentials. Without these, "...


2

I figured it out. The problem was we mounted and unmounted the drives initially and that share is only created once automatically. You have to create it manually after the fact.


2

Some sort of benevolent magic occurred after doing the following: Remove MongoDB Community Edition as a Windows Service, see here. sc.exe delete MongoDB Then when I went into my favourite MongoDB GUI (Robo3T), the databases were just there! So i ran: mongodump To get a "proper" dump of all my databases. I'm confused how this could happen ...


2

Do you also need the Datacenter or Enterprise Edition of Windows Server 2012 or 2016 for Always on, or can you set this up properly on Windows Server Standard 2012 or 2016? Windows Server Standard Edition is fine. Starting with Windows Server 2012 every feature of Windows Server is available in Standard Edition. In particular Standard Edition supports ...


1

You can't copy a data directory (which is what pg_basebackup does) between two different operating systems. The missing locale is just one symptom. If you need to replicate between Linux and Windows use logical replication – a_horse_with_no_name


1

Will it automatically take away 1 vote from either one of the nodes? If yes, remaining vote will be 33% not majority and single point of failure. Yes correct. Dynamic witness works in such a way that it tires to keep total number of votes odd. In your case when the FS witness is down the Dynamic quorum will toggle one vote from one of the node such that its ...


1

Performance of SQL Server using shares to host data files is almost always poor, regardless of the underlying storage subsystem. You should be mounting a host directory as a volume in your docker container to get better performance. See this link for more information.


1

As per MongoDB articles blog here The Connection Manager in Studio 3T makes it easy to connect to MongoDB, whether it is cloud-hosted or on-premise, or through a direct connection or a replica set. Create a new connection Open Studio 3T. Click on the Connect button either in the global toolbar or under the Recent Connections tab. This will open the ...


1

Simply right-click over pgadmin.exe and select "Pin to start".


1

On SQL Server, physical users are database-specific per se. If you want a logical user (a specific person) to only have access to one database, create a login for them, create a user for that login in that database, and grant them whatever minimal rights they need within the database. For example, earlier today I created a service account for Tableau, to ...


1

I need to create a login which can only view databases it has access, DISABLE access to stop the server. Contained Databases is what you need. How it works. It's nomore a server to authenticate you, but a database. You create users bypassing logins, and all what they "see" is limited to databases where they are created. A contained database basically ...


1

Those values are just fine. They are just truncated in the tkprof output and displayed as seconds instead of microseconds. Time for SQL executions is typically measured in microseconds. See V$SQL for example: ELAPSED_TIME NUMBER Elapsed time (in microseconds) used by this cursor for parsing, executing, and fetching. If the cursor uses ...


1

The equivalent: Login in postgresql, connect on the database you are having problem then issue: create extension pgcrypto; Is that.


1

I ran into the same problem. The database did not start with the service. First I checked the setting for the service using the Oracle Administration Assistant for Windows and configured the DB to start with the service start (by the way, I prefer the database to shut down immediately when the service is shut down). But enabling the database to open at ...


1

I had the same problem as you. I had installed python 2.7 version as mentioned at Prerequisites and the error no longer appears


1

Create a bat file with the following content and execute it: c:\path\to\postgresql\bin\psql.exe -f C:\path\to\db_create.sql postgresql://user:password@localhost:port/postgres This is what worked for me.


1

As per @a_horse_with_no_name's comment, have a look in your pgpass.conf (.pgpass on Linux) file if you have one, and see if there's an entry for the postgres user: The file .pgpass in a user's home directory or the file referenced by PGPASSFILE can contain passwords to be used if the connection requires a password (and no password has been specified ...


1

Edit the connection and be sure to select the version of mysql installed on your PC in the "Local Client" section


1

There is a simpler way, if you have access to the file system. MySQL generates a .TMD file; you can watch the size of the file growing; it should reach more or less the size of your existing MYD when it is done. For instance, if you cd to your datadir, and simply watch "ls -lah|grep table_name" which will return something like this (on Linux). In my case, ...


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