Adding compression to a table at row or page level

It is possible to add compression to a table at row or page level. At row level, any row values that can be stored in a smaller data type, will be. At page level, row level compression is used, and any duplicate data is rolled up within the page, creating more space in each page. The gain in disk space (and therefore fewer reads / writes) is to the detriment of CPU utilisation when reading / writing the data. You can check how much space you can save by using row or page compression by using the following stored procedure:

EXEC sp_estimate_data_compression_savings [Schema], [TableName], NULL, NULL, 'ROW'

You can then add the desired compression type to a table as follows:

ALTER TABLE [TableName]

REBUILD WITH (DATA_COMPRESSION = PAGE)

DBA listed as 8th best career for 2014 - Forbes

Database Administrator has been listed as 8th on the Forbes list for best careers in 2014: 
http://www.forbes.com/sites/jacquelynsmith/2013/12/12/the-top-jobs-for-2014/