Useful tips for everyday
Which of the following can be limited using resource Governor? This release of Resource Governor has the following constraints: Resource management is limited to the…
How do I give access to a specific database in MySQL? To GRANT ALL privileges to a user , allowing that user full control over…
How to combine multiple rows into one row? CREATE VIEW [dbo]. [ret_vwSalariedForReport] AS WITH temp1 AS (SELECT salaried.*, operationalUnits.Title as OperationalUnitTitle FROM ret_vwSalaried salaried LEFT…
How to calculate quarter and year from date? Convert date to quarter only with formula If you just want to get the quarter from the…
Which type of backup below is not applicable for a database in simple recovery mode? Transaction log backups SIMPLE. The SIMPLE recovery model is the…
Why are there no 10g passwords in Oracle? The database then generates only the 11G and 12C password versions for their accounts. Because the database…
How to setup asynchronous replication between Galera clusters? Once the Galera Cluster is deployed, simply pick one node on each site to set up the…
How do you set a dynamic port range? You adjust this range by using the netsh command, as follows: netsh int set dynamic start= number…
How can upload bulk data in SQL Server? SQL Server import and export wizard Connect to a source database via the Choose a data source…
When would you use a dynamic port? Dynamic-port meaning A port that can be used by any computer application program to communicate with any other…