Useful tips for everyday
How to set up a NLS environment in Oracle? Oracle8iNational Language Support Guide Release 2 (8.1.6) A76966-01 Library Product Contents Index 2 Setting Up an…
Does PSQL use SSL? PostgreSQL has native support for using SSL connections to encrypt client/server communications for increased security. What is RDS certificate? RDS –…
What happens when you normalize a database? What is database normalization? Following the creation of a product database, normalization is the next key step, as…
How do you add a startup parameter? In the right pane, right-click SQL Server (), and then click Properties. On the Startup Parameters tab, in…
How do I create a read only access user in Oracle? Creating a read-only database user for Oracle Log in to the Oracle database as…
What is database snapshot mysql? To create a raw data snapshot of MyISAM tables when your MySQL data files exist on a single file system,…
How do I get the hour difference in SQL? These SQL queries computes the time difference using first the seconds (multiplied by one hour in…
What does it mean to take a database offline? I’ve had to do this before. Sometimes a nasty bug is found in your app that,…
Is there way to optimize disk configuration for SQL Server? Assuming that best practices are followed in regards to file locations and tempdb optimizations, you…
How do I add an extended property? Then right click on column “sno” and select Properties and go to the Extended Properties page. The below…