Thursday, February 15, 2018
Wednesday, February 14, 2018
You need to encrypt and compress your backups before replicating them off site. Which is best practice, compress then encrypt, or encrypt then compress?
You need to encrypt and compress your backups before replicating them off site. Which is best practice, compress then encrypt, or encrypt then compress?
- Neither!
- Encrypt first!
- Doesn't matter!
- Compress first!
EXPLANATION
If you encrypt the data first, it will be randomized and unintelligible by your compression application which need to compress the data in a logical format.
Compressing then encrypting is the way to go.
SOURCE
https://stackoverflow.com/questions/4676095/when-compressing-and-encrypting-should-i-compress-first-or-encrypt-firstTuesday, February 13, 2018
For every unique constraint on a column, SQL server will create which of the following?
For every unique constraint on a column, SQL server will create which of the following?
- An entry for that column
- A non-clustered index for that column
- A clustered index for that column
- A filtered index
EXPLANATION
For every unique constraint on a column, SQL server creates a non-clustered index. A non-clustered index has a structure separate from the data rows. It contains non-clustered index key values and each key value entry has a pointer to the data row that contains the key value.Unix time is the number of seconds that have elapsed since 00:00:00 Coordinated Universal Time (UTC) on what date?
Unix time is the number of seconds that have elapsed since 00:00:00 Coordinated Universal Time (UTC) on what date?
- Saturday, January 1, 2000
- Sunday, December 28, 1969
- Thursday, January 1, 1970
- Monday, January 1, 1900
EXPLANATION
Unix time counts the number of seconds that have elapsed since 00:00:00 UTC on January 1, 1970. It is used in Unix-like operating systems and file formats. Because it doesn't deal with leap seconds, it is not a true representation of UTC. Check out Unix time for yourself by typing "date +%s" on the command line.Fun fact: December 28, 1969, is Linus Torvalds' birthday, which makes him older than Unix.
Saturday, February 10, 2018
Which are Fax over IP Protocols?
Which are Fax over IP Protocols?
- k.30 and k.38
- M.16 and M.204
- H.323 and H.404
- t.30 and t.38

