So, What Will The Next SQL Server Look Like?
Definitely interesting reading here. Its code name is "Yukon" and MS calls it their "Next-Generation" Database Management.
MS has a page on their website where they go into a little more
detail, and provide a sneak peak of future functionality. It
starts with the usual MS PR, but then it gets interesting. I quote:
[PR HYPE ON] "Yukon will provide organizations with next-generation
capabilities across database development and management, availability,
scalability, security, and business intelligence while enabling
them to control costs." [PR HYPE OFF]
The rest of the article provides an overview of major feature
enhancements in three key areas: enterprise data management,
developer productivity, and business intelligence. If you use
SQL now, I suggest you read up on where you will live a few
years from now:
How To Tweak The iHateSpam Server Filters
This is an interesting little exchange between Sunbelt people
and a customer that was fine tuning the spam filters. We do
this by sending 880 known spams to their machine. Bob is the
Sunbelt guy who is the List Moderator of our spam forum. Here
is the start:
Bob: 880 on the way... You might want to clear your quarantine
Daniel: 598 messages were caught by iHSSE, 26 passed through - I thought you said there were 880 total messages? My account
is set to what we're calling "Medium Tolerance"; the same
settings as the old default policy (120 threshold).
Bob: Drop the threshold to 60, it's where ours are set. Other
emails may have been blocked by any rules or filters or DNS
blocking you may have. If you feel funny about 60 on the
Quarantine Threshold, well no worries, you won't lose anything.
But have you tweaked the default delete threshold? Some of those
spam are pretty offensive.
Daniel: I checked the reporting and it says for my account 860
messages were caught so far today. I may have had a couple (less
than 10, I don't remember exactly) messages in the Quarantine
when I arrived this morning, so it looks like I technically
"received" the messages, but they didn't arrive in the Quarantine
folder. I have my Delete Threshold at 600 and No Action Threshold
Bob: So here is what happened: over 300 of those spams were so
offensive that their points went way above your 600 delete
threshold and they were deleted. (6,000 THOUSAND is default)
Daniel: Ah, yes...that makes sense. After I hit send on my last
message, I thought about the delete threshold setting of 600 and
figured that's where the extra messages went. Those messages must
have been pretty offensive!
Bob: Seeing as how your delete threshold is so low you might be
getting false positives and not know it since they are deleted, see?
I think we saw that earlier. Let's lower the threshold on your mailbox
policy to 60, put the delete threshold back at 6000, hit update,
update the smart cache and let's do it again? This way we KNOW we
are not deleting legit email.
Daniel: The second attempt yielded the following results:
Quarantined - 814, Misses - 3, Total - 817. I feel rather confident
that I didn't receive any other spam during this period. So I can
only concluded that the 38 messages not appearing in my quarantine
were above the 6000 delete threshold. As for the 35 messages of the
880 that are missing, I have no idea where they are. Would it be too
much trouble to ask for another attempt? This time I want to try
it on a fresh mailbox. Are there some other settings I should tweak?
Bob: Cool! That's a lot better huh? Watch for false positives.
Some are getting blocked, some other guys are getting all 880
spams. If you have Delete Blacklisted emails checked (In the Policy)
and your users have some of those spams blacklisted that could account
for the missing emails :) Not a bad thing in any case.
Daniel: Let's try again to a fresh account? The account is established
and ready to go. And this account is in the policy with a quarantine
threshold of 100 and a delete threshold of 6000.
Bob: Ok...880 On the way...
Daniel: Hits - 876, Misses - 4 (2 of which were red-herring legit
emails to see if we went too far) Total - 880
Bob: Wow, great percentages. Does not get much better than this.
OK to publish results?
Daniel: YES! Thanks for all your help and a great product.
Want to do this yourself and see if you can get over 98% spam
trapping hit rates? Get a full function 30-day demo here:
Different Ways Admins Utilize LanHound
LanHound has become very popular very fast. It's a great packet
sniffer at extremely low cost. We asked system- and network
admins who bought it what they are using it for:
Slow response times: See traffic congestion quickly.
Broadcast or multicast storms: Set an alarm for unusually high
traffic of these types.
Traffic by station: View traffic generated by each station and
server to see which stations are consuming the most bandwidth.
Hanging network sessions: Find who sent the last packet, and
which system failed to respond.
User can't logon: Capture login negotiations, retransmits and
response times to determine where the problem is, and where
to focus your attention.
Security Lapses: Find out if users are checking POP3 email or
going to FTP sites using unencrypted passwords.
Duplicate IP numbers: See if there are duplicate IP addresses
on a monitored segment.
Try it out for yourself over here: