Viewing 15 posts - 10,291 through 10,305 (of 39,884 total)
Eric M Russell (1/5/2015)
This is similar to something HP has done, trying to predict if employees might leave and intervene to see if something can be done. I heard an...
January 5, 2015 at 7:47 am
Brian.Klinect (1/5/2015)
Is the first link to AllAnalytics right? It doesn't seem to be about a college, but instead about the writer's last day.
Sorry, somehow the URL got messed up....
January 5, 2015 at 7:45 am
No idea here, but I spoke too soon. I could have sworn I'd seen a Standard Edition demo showing two pools, but perhaps not.
When I check the SSC server,...
January 3, 2015 at 11:13 am
No way I'm aware of. You can specify this in the connection string:
$cstr = "Server=WS12SQL;Database=Northwind;Integrated Security=SSPI;Application
Name=SetupNorthwind";
From Allen White's piece: http://sqlmag.com/scripting/using-adonet-connection-string
If anyone sets this programmatically, including from PoSh or VBScript, they...
January 2, 2015 at 12:53 pm
The service is a better connection between the two systems. You can lease a line at whatever speed, or get faster Internet service and hope it works.
If you have to...
January 2, 2015 at 10:52 am
The master keys are unique to each database. You don't have to have the same ones in the publisher and subscriber.
You do need to have a master key in a...
January 2, 2015 at 9:54 am
If they're all NULL, then it should be column level encryption. If you had a 1, 2, 3 for the database, those would imply TDE.
In terms of encryption, what you...
January 2, 2015 at 9:39 am
Could be either one. You need a master key for TDE or column level stuff.
Do you have a DMK? Run this:
SELECT
db.name,
db.is_encrypted,
...
January 2, 2015 at 9:07 am
If you're feeling the itch and things are slow.....
Looking for good questions of the day and articles on practical topics.
Just got a CDC article that covers setup, but not...
January 2, 2015 at 8:54 am
Encryption as in column level encryption (symmetric/asymmetric keys) or TDE?
January 2, 2015 at 8:40 am
I always want a datetime here so that I can detect latency or potential issues with my process. I'd store this on the destination side, when I pull the data....
January 2, 2015 at 8:38 am
It should be. Perhaps something is broken here, but there should always be two pools on all instances.
January 2, 2015 at 8:35 am
Be aware that anyone can spoof the application name in their connection string. In practice, it probably doesn't happen, but just be aware you have a hole.
January 2, 2015 at 8:34 am
Viewing 15 posts - 10,291 through 10,305 (of 39,884 total)