Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««4,0984,0994,1004,1014,102»»»

Are the posted questions getting worse? Expand / Collapse
Author
Message
Posted Tuesday, August 20, 2013 1:03 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 12:08 PM
Points: 987, Visits: 5,168
Another fun fun day...

Was asked to see if there's a way to prevent an executable (which is a Windows service) from running, and still be able to restart it later...
The exe is for an AV application (controlled by our NOC team) that the NOC pushes updates to when they want / need to. Even in the middle of the day. This causes problems with some servers, notably the Sharepoint farm. I think I've found a way to do it (we have no control over GPOs, or this would be easy-peasy) but some of the things in the setup are rather scary ("Do you want to create the default rules for system files?" Wait, you mean this could completely block the OS from working? CANCEL!) And, just going to the forums most likely to provide an answer (Technet) is also likely to get people yelling about trying to "hack" the system...

Sigh.
Jason
Post #1486405
Posted Tuesday, August 20, 2013 1:56 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 12:57 PM
Points: 2,677, Visits: 19,270
OCTom (8/12/2013)
wolfkillj (8/12/2013)
Brandie Tarvin (8/12/2013)
Jeff Moden (8/10/2013)
Brandie Tarvin (8/2/2013)
How many people (besides Jeff and myself) have written SQL Spackle articles?

How many SQL Spackle articles are there?

Yes, I have a reason for asking. But I want to share it with the Spackle authors first before I say anything else.


Waiting with worms on my tongue ("baited" breath ), what's up with this?


There you go, old bait breath. (Thanks for the reminder. GenCon prep has me insane with work and I forgot about this).


Hi there, it's your Monday Morning Pedant here. I more than half suspect that Jeff and Brandie know this and are just being ironic, but the phrase is "bated breath", with "bated" as the adjectival form of "bate", meaning "to moderate or restrain." So waiting with bated breath means one is holding one's breath in anticipation, while waiting with baited breath suggests one needs some Tic Tacs or something because one's breath STINKS!


My take is that everone knows the difference and it is used for a humorous effect; not to be confused with a humeris effect. Though, that might be funny, too.
Your hubris effect is showing


---------------------------------------------------------
How best to post your question
How to post performance problems
Tally Table:What it is and how it replaces a loop

"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
Post #1486424
Posted Wednesday, August 21, 2013 6:02 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 1:28 PM
Points: 1,248, Visits: 6,689
jasona.work (8/20/2013)
Another fun fun day...

Was asked to see if there's a way to prevent an executable (which is a Windows service) from running, and still be able to restart it later...
The exe is for an AV application (controlled by our NOC team) that the NOC pushes updates to when they want / need to. Even in the middle of the day. This causes problems with some servers, notably the Sharepoint farm. I think I've found a way to do it (we have no control over GPOs, or this would be easy-peasy) but some of the things in the setup are rather scary ("Do you want to create the default rules for system files?" Wait, you mean this could completely block the OS from working? CANCEL!) And, just going to the forums most likely to provide an answer (Technet) is also likely to get people yelling about trying to "hack" the system...

Sigh.
Jason


We were forced to run this on our servers which were not exposed outside the network.
Fortunately those in control let me have input into exclusions that made sense, so impact was minimal.
Usually they control AV with GPO's, which will be reapplied - can't remeber if this was 15 minutes or 2 hours in our case.
Hope they work with you on this, otherwise you might create some attention you do not want.
Likewise, they probably don't want the attention that your servers are real slow.
Post #1486650
Posted Wednesday, August 21, 2013 6:58 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 12:08 PM
Points: 987, Visits: 5,168
Well, so far (knocks on wood) my SQL boxes aren't being impacted too bad by this. It's the Sharepoint guys who are having headaches. I think I got asked to look at blocking this AV because I've probably got the most "general" server knowledge.

I thought I had found a way, using Application Restriction Policies, but when I tried it out at home, it didn't work...

Ah well, at least I tried.
Post #1486677
Posted Wednesday, August 21, 2013 7:40 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 1:28 PM
Points: 1,248, Visits: 6,689
Have the one who manage the sharepoint farm truly proved AV is the issue?
SharePoint has many other services that can consume a lot of CPU and slow things down.
Some of the crawler / search indexing services and timing can be invasive.
Not sure what your setup is, but we used separate VM's for some of this.
Also depending on how you use if, some of the history / revision can lead to a lot of other bloat.

Tread carefully - many places too much creativity can get you pushed out the door.
Even if the intentions are white hat type activity.
Once when we were working on an application, I proved the corporate firewall was dropping our packets.
Only thing that saved me was a few of those who were having me figure it out.
I'm sure the head guy still remembers that discussion.
Post #1486711
Posted Wednesday, August 21, 2013 7:45 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 12:08 PM
Points: 987, Visits: 5,168
I think maybe not 100%, but close. They've found that everytime an update is pushed out for this AV, Sharepoint starts having problems.

We are set up in a "farm" config, I think there's around 4 Sharepoint servers plus my SQL back-end server (which is exclusive to Sharepoint)

As for actually doing anything about this, well, I don't have any rights on the Sharepoint servers (Yay!,) and was requested to look into finding a way to disable the AV by one of our departments security guys, so I'm pretty well covered.
Post #1486715
Posted Wednesday, August 21, 2013 2:39 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:15 PM
Points: 13,731, Visits: 10,692
In the category of "Are the posted answers getting worse?"

http://www.sqlservercentral.com/Forums/Topic1485861-1063-1.aspx

From now on I shall answers questions in the following manner:
"I have no flipping clue. Please post the solution once you found it."

It will save me a whole bunch of time!




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1486939
Posted Wednesday, August 21, 2013 2:42 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:32 PM
Points: 13,455, Visits: 12,318
Koen Verbeeck (8/21/2013)
In the category of "Are the posted answers getting worse?"

http://www.sqlservercentral.com/Forums/Topic1485861-1063-1.aspx

From now on I shall answers questions in the following manner:
"I have no flipping clue. Please post the solution once you found it."

It will save me a whole bunch of time!


I would have to say that falls in the category of the answers getting worse.


_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1486941
Posted Wednesday, August 21, 2013 2:45 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:15 PM
Points: 13,731, Visits: 10,692
Sean Lange (8/21/2013)
Koen Verbeeck (8/21/2013)
In the category of "Are the posted answers getting worse?"

http://www.sqlservercentral.com/Forums/Topic1485861-1063-1.aspx

From now on I shall answers questions in the following manner:
"I have no flipping clue. Please post the solution once you found it."

It will save me a whole bunch of time!


I would have to say that falls in the category of the answers getting worse.


That's what I said




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1486947
Posted Wednesday, August 21, 2013 2:48 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:32 PM
Points: 13,455, Visits: 12,318
Koen Verbeeck (8/21/2013)
Sean Lange (8/21/2013)
Koen Verbeeck (8/21/2013)
In the category of "Are the posted answers getting worse?"

http://www.sqlservercentral.com/Forums/Topic1485861-1063-1.aspx

From now on I shall answers questions in the following manner:
"I have no flipping clue. Please post the solution once you found it."

It will save me a whole bunch of time!


I would have to say that falls in the category of the answers getting worse.


That's what I said


Ahh yes you did...I need to have my eyes checked and get thicker coke bottles I think.


_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1486948
« Prev Topic | Next Topic »

Add to briefcase «««4,0984,0994,1004,1014,102»»»

Permissions Expand / Collapse