Viewing 15 posts - 8,401 through 8,415 (of 49,552 total)
Welsh Corgi (7/15/2014)
One that has an example of encrypting and decrypting the same column.
You don't encrypt columns. Get that idea out of your head, it's probably causing your confusion. There...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 15, 2014 at 4:42 pm
Jeff Moden (7/15/2014)
Lynn Pettis (7/15/2014)
Whose turn with the silver...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 15, 2014 at 3:32 pm
Lynn Pettis (7/15/2014)
Whose turn with the silver spoon??
Sorry, mine's already packed.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 15, 2014 at 2:12 pm
That's the exact article I would have given you as an example. See the other examples that it links to.
Bear in mind this isn't something you implement without a fair...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 15, 2014 at 1:57 pm
Why all the DISTINCTs Aspirant?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 15, 2014 at 1:49 pm
No. T-SQL, with the T-SQL encryption functions like EncrypByKey and DecryptByKey, or whichever of the similar functions you identify as meeting your requirements for protection, key management and all the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 15, 2014 at 1:47 pm
They probably test on two rows.
Good luck. This isn't a technical problem, maybe get management involved. Yours and theirs.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 15, 2014 at 1:16 pm
There's nothing about the column which makes it encrypted. You would need to encrypt the values when you insert (eg with EncryptByKey) and decrypt the values when you select then...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 15, 2014 at 1:12 pm
Little better in some ways in 2014. Still should probably be avoided.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 15, 2014 at 12:58 pm
TDE is entire database encryption. Transparent encryption, data encrypted on disk, decrypted in memory. It protects against the theft of the data files or the backups. It doesn't protect columns....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 15, 2014 at 12:55 pm
Don't use the import/export wizard.
Script the objects, some will probably fail. Query the data bit by bit (filter on the clustered index of each table), some will probably fail. Recreate...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 15, 2014 at 11:44 am
Might drop into the pub quiz briefly, but I won't be staying late. Will be way too tired (don't sleep on planes)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 15, 2014 at 11:04 am
This is not repairable. You need to restore from backup....
Did the DB correctly switch into Emergency Mode?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 15, 2014 at 10:41 am
There will be a message in the error log saying who did it (what login). And it probably is 'who'. SQL doesn't automatically switch databases to single user, either someone...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 15, 2014 at 10:39 am
I'm on a plane. 🙁 Company wouldn't pay for the pre-con and wouldn't give me an extra day off to attend it.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 15, 2014 at 10:35 am
Viewing 15 posts - 8,401 through 8,415 (of 49,552 total)