Viewing 15 posts - 736 through 750 (of 49,571 total)
September 26, 2017 at 1:04 pm
Agreed. Full database encryption protects against theft of the DB file or backups. For preventing the admin from seeing sensitive data, you should identify the sensitive data and encrypt just...
September 26, 2017 at 10:43 am
The main factor is why you're fiddling with it at all.
September 26, 2017 at 10:40 am
If you can find that log backup that was taken, you can restore that and then log shipping will resume. If you can't however, you'll have to rebuild the log...
September 26, 2017 at 10:38 am
From the previous thread:
Then, restore the full backup WITH NORECOVERY, restore any log backups taken since the full backup followed by the one you took from the...
September 26, 2017 at 10:36 am
Always Encrypted is not intended to be entire DB encryption, but to encrypt the data so that the admins can't read it. The idea is that you encrypt the sensitive...
September 26, 2017 at 6:32 am
Depends.
What do you need them for, and what are your audit needs?
If you don't care about changes to rows, don't use them.
If you need to...
September 26, 2017 at 6:27 am
September 26, 2017 at 6:22 am
coolchaitu - Monday, September 25, 2017 9:00 AMDo the sleeping SPIDs consume CPU and memory while they are in sleeping state?
No. Sleeping...
September 26, 2017 at 6:19 am
CheckPoint - Monday, September 25, 2017 12:25 PMAm I missing something?
Yup, another log backup (or multiple log backups) that happened...
September 26, 2017 at 1:51 am
In fact, just about the only way you can have the DBA not see the data (without rewriting the app and bringing it to its knees with performance problems) is...
September 26, 2017 at 1:48 am
Is there any gain to be had at all by disabling the nonclustered Indexes?
. ...
September 25, 2017 at 9:00 am
Homework? Exam? Interview?
Yes, you can get the minimum loan payment date using Group By.
September 24, 2017 at 5:10 pm
There's a semicolon in the middle of that statement.
September 24, 2017 at 4:55 pm
spuyear - Sunday, September 24, 2017 7:43 AMIs this the correct method?
No, that will not work. You can't replace database files...
September 24, 2017 at 7:58 am
Viewing 15 posts - 736 through 750 (of 49,571 total)