Useful tips for everyday
Can SQL Express be upgraded? You can upgrade a Microsoft SQL Server Express instance using the SQL Server Express installation wizard. The version of SQL…
Is it worth it to use barman for PostgreSQL? Barman is way beyond what we can capture in this blog and must be explored further…
How do I clear the SQL Server error log? 1 Answer In Object Explorer, expand the instance of SQL Server, expand Management, right-click SQL Server…
How do I increase temp tablespace? ALTER TABLESPACE temp ADD TEMPFILE ‘+DATA/ORCL/DATAFILE/temp02. dbf’ SIZE 2048M REUSE; After that SELECT * FROM dba_temp_free_space; command showed me…
What is it called when 2 people are thinking the same thing at the same time? it is called synchronicity. when two people come up…
What is encryption testing? Encryption Algorithm Testing. Since AES-256 is a standard, there must be a defined methodology to ensure an implementation meets the published…
Can you upgrade MySQL from 5.0 to 5.5? This can include important tips and information about running the upgrade: upgrading to 5.1 , upgrading to…
How do you failover in AlwaysOn availability groups? Use SQL Server Management Studio In Object Explorer, connect to a server instance that hosts a secondary…
How does a single PostgreSQL config change improved slow query performance? To see the alternative query plans PostgreSQL considered before picking Hash Join, I disabled…
Is there a logical replication feature in PostgreSQL 10? PostgreSQL 10 came with the welcome addition of the logical replication feature. This provides a more…