Viewing 15 posts - 9,586 through 9,600 (of 39,769 total)
Apologies. The disable statement is missing in the code.
Points awarded back and the question corrected.
June 10, 2015 at 10:59 am
I would say look at two things
- What you enjoy
- What jobs are available
Please don't take a job for money you don't enjoy, but I do understand taking a job...
June 10, 2015 at 10:02 am
ericpap (6/10/2015)
Jeff Moden (6/10/2015)
Is this a Production Server?yes
Sorry to hear that.
If you can't get someone to admit they did something, I'm not sure you'll find much forensic evidence. You...
June 10, 2015 at 9:57 am
I'm with Eric. You should seriously look at the value of your time. It might be worth it to commute to get experience or start the move to a new...
June 9, 2015 at 1:19 pm
Jeff Moden (6/8/2015)
It's just stupid but they keep making the grease spot of audits larger and larger and with no real guarantee that the information is even accurate. It's...
June 9, 2015 at 10:33 am
Jeff Moden (6/4/2015)
Have any of you ever used a CTP of SQL Server to power your real production databases? Personally, I think such a thing would...
June 9, 2015 at 9:20 am
Eirikur Eiriksson (6/4/2015)
Should be as simple as
..TOP(1)...
WHERE POST.VISIBLE = TRUE;
😎
Nothing is ever simple, and the queries that do this potentially slow way down with a check for banned users....
June 9, 2015 at 9:19 am
I tend to agree with Gail here. The data is stored in the mdf/ldf/ndf files. If someone stops the SQL Service, they can restore those files, just as they'd restore...
June 9, 2015 at 8:53 am
I like the use of the OUTPUT clause there. Much simpler than trying to build a transaction. It would also work with larger volumes if you changed the where clause...
June 9, 2015 at 8:51 am
I've seen some places like this with various models set up, but I don't see surveys there: http://www.databaseanswers.org/data_models/. There is a questionnaire, but it's limited in what it shows: http://www.databaseanswers.org/data_models/student_questionnaires/index.htm
What...
June 9, 2015 at 8:44 am
Couple things.
First, back up your certificate now. Even if you turn off TDE, it doesn't hurt to have a copy and someone might turn it on again.
Second, you might have...
June 9, 2015 at 8:32 am
there isn't a restore that has taken place, so either there's some storage change (possibly a restore of some sort) or a machine level change if you don't see anything...
June 8, 2015 at 2:14 pm
The non-DBA's actions certainly could be an issue, but I'd hope that the person doing the auditing isn't a privileged user that can do something dangerous on the system. If...
June 8, 2015 at 11:58 am
First, I think you need to slow down and carefully post what happened and what you've seen. There are a few items that don't make sense. When you say database...
June 8, 2015 at 11:12 am
Thanks, Peter.
Apologies, Marty. I do try to spell out the acronyms most times, but didn't hear. VCS is Version Control System, also known as Source Control. I'll try to do...
June 8, 2015 at 10:01 am
Viewing 15 posts - 9,586 through 9,600 (of 39,769 total)