Viewing 15 posts - 1 through 15 (of 224 total)
David.Poole (3/25/2016)
March 25, 2016 at 5:55 am
David's new comment made me go back and look. It seems right after I'd last replied two years ago I hadn't worked anywhere large enough to have VMs and clustering....
March 25, 2016 at 4:48 am
Indianrock (12/23/2015)I think somebody said "disable SA" earlier in this thread. But best practice is ( was? ) to assign job ownership to SA.
Jobs which are assigned to a...
December 23, 2015 at 7:07 am
andrew gothard (12/21/2015)In fact, using a highly privileged single account for app access is nothing more than deliberate incompetence.
The last time I heard something like this said the person saying...
December 21, 2015 at 6:44 am
n.ryan (12/21/2015) The sa user was used by a web application to access the database and the credentials were stored in plain text in the web.config file.
Nice. That's about as...
December 21, 2015 at 1:31 am
Jeff Moden (11/30/2015)
Cody K (11/30/2015)
That being said, if the database goes corrupt, what's your recovery plan?
Restore from backup with a few day outage and losing up to a day of...
November 30, 2015 at 4:34 pm
Thanks Mad & Stefan. I had tried to look at the query plans for the bulk insert before but SQL Sentry said they weren't generated.
I'll try again. I'll also set...
November 30, 2015 at 5:45 am
MadAdmin, yes literally Bulk Insert statements straight from a file with no further joins or filtering or sorting.
It has a bigint identity which is populated automatically, plus one index on...
November 30, 2015 at 4:38 am
By default packages store passwords encrypted based on the user who built it.
See https://support.microsoft.com/en-us/kb/918760 and specifically the ProtectionLevel item. They need to edit the package to do one...
September 3, 2015 at 4:47 am
Are you overriding any of the package variables in the agent job? That's known to cause a slew of problems.
September 3, 2015 at 12:48 am
Jesus this article is downright dangerous. Follow at your own peril and only after making sure you have an updated resume.
To start by claiming that shrinkfile magically causes contention correlated...
August 19, 2015 at 8:52 am
I wish there was a FineBuild presentation video. Apparently it has been demonstrated at user groups a lot in the past and yet there's nothing recorded and viewable online that...
August 6, 2015 at 8:04 am
I looked and also couldn't find the answer, and I feel stupid suggesting anything because you've made 3000 posts.
But if it was me, and I didn't know the answer, I...
August 6, 2015 at 7:48 am
You can iterate your database list with a cursor or procedure or however else you want and use that query to list out the queues. Any row that is returned...
August 3, 2015 at 11:52 pm
Viewing 15 posts - 1 through 15 (of 224 total)