The clustered index is the table.

So whatever you insert into the table is stored in the clustered index.

You insert the value 10, the clustered index value is 10

Backup compression is lossless (IIRC) so someone with knowledge of compression could revert the compression algorithm.

Then again encryption is also reversible, you will have backups of your certs / keys...

What do you define as confidential information?

Things like Red-Gate SQL Compare can read a diff backup to get the schema, unsure on Data Compare

http://documentation.red-gate.com/display/SC11/Working+with+backups

SQL Compare can retrieve the schema from...

Whoops, oversight on my part I do appologise.

http://technologycraftsmen.net/blog/2010/10/19/alphanumeric-sorting-in-mssql/ has a function which will do it

SELECT activityName

FROM #Activities

ORDER BY

master.[dbo].[fn_CreateAlphanumericSortValue] (activityName,1)

!!WINNING!! (in my best Charlie Sheen impression)

one armed

Something like this?

SELECT activityName

FROM #Activities

ORDER BY

Case When IsNumeric(activityName) = 1 then Right(Replicate('0',21) + activityName, 20)

When IsNumeric(activityName) = 0 then...

1. has a database about 100gigs ish, but the transaction log file are about 5-10kb, I want to log ship from prime location to secondary, will I run into issues...

villain

otomatopeia

What does the Windows event log say?

Why not use logshipping and set the restore job to run once a day?

Ed Wagner (9/22/2015)

Cane

http://sqlmag.com/blog/alwayson-availability-groups-and-sql-server-jobs-part-7-detecting-primary-replica-ownership

http://sqlmag.com/blog/alwayson-availability-groups-and-sql-server-jobs-part-8-dynamic-detection-gotcha-1

These two links helps me out in scheduled jobs to ensure they only run on the primary

Ed Wagner (9/22/2015)

tootsie