Viewing 15 posts - 2,056 through 2,070 (of 9,244 total)
TDE does not enable Table Data Encryption, it enables Transparent Database Encryption.
Do you understand what it does and why you would enable it would be my initial question?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 9, 2015 at 5:29 am
this is something you'll need to cover with your licensing rep, if you install an instance on a passive node and leave it there it's no longer passive
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 5, 2015 at 10:02 am
BL0B_EATER (6/5/2015)
Or look into VB which we use in our little shop - IO.File.Delete(FileName).
Ooooh that's so yester year, here in the 21st century we use this 😉
$checkdate = (get-date).AddDays(-30)
$checkpath...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 5, 2015 at 5:40 am
so what's your question?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 5, 2015 at 5:35 am
just use Powershell, it's much easier
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 4, 2015 at 11:32 am
Database admin(DBA) (6/3/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 4, 2015 at 5:09 am
it's not a bug it's by design and yes, there is a trace flag to force the engine to behave as sql server 2008 R2. The trace flag is 272,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 3, 2015 at 8:36 am
Arestas (6/3/2015)
Know any documentation about this?Regards,
Arestas
In response to the modification of resources this link states
MSDN
For example:
?Do not change any availability...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 3, 2015 at 7:11 am
Dan121 (6/2/2015)
I know RDP on Prod server is bad which take lots of resources
Erm, no, actually no it doesn't. And just because someone can RDP to the server it doesn't...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 3, 2015 at 6:07 am
Arestas (6/3/2015)
I tough on associating a virtual ip to the AllwaysON cluster resource
That's exactly how you'll need to do this, a shared IP address will be needed. FCIs have...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 3, 2015 at 5:57 am
a further limitation of TDE is the effect on compression, this can be an issue for those who wish to use effective compression in their backups, Things have got better...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 3, 2015 at 5:03 am
JeepHound (6/2/2015)
what load are you expecting to be placed on the systems?
JeepHound (6/2/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 2, 2015 at 9:16 am
Inst1 and 2 are in the same mirror group
Inst3 and 4 are in the same mirror group
That is perfectly valid, what you couldn't have is Inst 1, 2 and 4...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 2, 2015 at 8:11 am
open explorer and find the data folder then right click and select properties. On the security tab you'll see details of permissions applied
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 29, 2015 at 8:16 am
OK, just tested and it seems it does retain the permission when renaming, sorry for the mistake
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 29, 2015 at 6:42 am
Viewing 15 posts - 2,056 through 2,070 (of 9,244 total)