Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQLServerCentral.com
»
Editorials
»
Smart Energy Doesn't Seem So Smart
Smart Energy Doesn't Seem So Smart
Rate Topic
Display Mode
Topic Options
Author
Message
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Saturday, April 09, 2011 7:01 PM
SSC-Dedicated
Group: Administrators
Last Login: Today @ 1:14 AM
Points: 31,433,
Visits: 13,746
Comments posted to this topic are about the item
Smart Energy Doesn't Seem So Smart
Follow me on Twitter:
@way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
Post #1091137
bradmcgehee@hotmail.com
bradmcgehee@hotmail.com
Posted Sunday, April 10, 2011 2:10 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Tuesday, May 14, 2013 1:08 PM
Points: 175,
Visits: 719
Just recently, as I was speaking at SQLBits, I spoke to a DBA who said that about 5-6 years ago he went to work for a bank that had over 1000 SQL Server instances. He said the first thing he did was to review SA security, he was dismayed to find that about 500 of the instances had no SA password, or a very weak SA password, and that many of the bank's applications had the SA and blank password coded into their applications. He said he had to fight management to get this changed, as they didn't want to spend the money to modify the hard-coded applications to use a more secure password or to use Windows authentication. Unbelievable.
Brad M. McGehee
Microsoft SQL Server MVP
Director of DBA Education, Red Gate Software
www.bradmcgehee.com
Post #1091190
Scott.A.baron
Scott.A.baron
Posted Monday, April 11, 2011 7:59 AM
Forum Newbie
Group: General Forum Members
Last Login: Thursday, May 09, 2013 6:24 AM
Points: 2,
Visits: 53
A great article.
Summarizes many ongoing problems in the industry. The very word O&M, including security, is treated poorly in many organizations. Seems everyone wants to work on new stuff, and the existing infrastructure that pays the bills is considered non value work. Anyone with experience in the field has dealt with ongoing support and costs.
Rule 1: Support work has many risks and failure is unacceptable.
Rule 2: Preventative maintenance is rarely in budget
Rule 3: O&M is just overhead that should be reduced.
Seems like a great topic for a book.
Post #1091438
JJ B
JJ B
Posted Monday, April 11, 2011 9:37 AM
SSC Veteran
Group: General Forum Members
Last Login: Tuesday, May 21, 2013 3:08 PM
Points: 255,
Visits: 2,407
You raise a very good point and one of big personal concern. I recently put solar panels on my house, but I'm not free of the grid. Instead, my solar panels have become part of the overall grid system. When I generate more electricity than my house needs, the electric company feeds the extra electricity to my closest neighbors and gives me a credit. At night and in the winter, I can use those credits as my house draws electricity from the grid. (If all goes according to the projections, I won't have to pay for electricity in the future because it will all balance out.)
For this to work, I will be relying on the electric company having accurate numbers about how much I use, how much I generate, and when it all happens. It seems like this nice system contains just that much more that can go wrong - that much more which is controlled by software. If the software is not secure...
Post #1091539
chrisn-585491
chrisn-585491
Posted Monday, April 11, 2011 11:23 AM
SSC-Addicted
Group: General Forum Members
Last Login: 2 days ago @ 7:32 AM
Points: 479,
Visits: 1,263
He said he had to fight management to get this changed, as they didn't want to spend the money to modify the hard-coded applications to use a more secure password or to use Windows authentication. Unbelievable.
It's more common than you think. I'm currently having to explain PKI to one of these institutions that should know better, but they keep chasing off all their qualified technical people.
Post #1091608
Bill Kline-270970
Bill Kline-270970
Posted Wednesday, April 20, 2011 2:20 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Tuesday, May 21, 2013 9:08 AM
Points: 168,
Visits: 672
Overbilling and underbilling are indeed potential problems, but I'm worried about bigger stuff, like terrorists or another country (think the big C) hacking into the grid system and turning off the power at will. Think of the impact on our economy.
Post #1096625
bitbucket-25253
bitbucket-25253
Posted Wednesday, April 20, 2011 3:25 PM
SSCertifiable
Group: General Forum Members
Last Login: Yesterday @ 9:12 PM
Points: 5,103,
Visits: 20,208
There will often be someone held accountable, even if the issue isn't publicized, and that person could easily be you. Follow best practices for security, raise awareness where you can, and document the exceptions with your objections noted. It might not make the company more secure, but it likely will help you keep your job.
Let me add the following, keep copies of documents with your objections noted,
off site
... it can be strange how at times those memos that could make a manager look less than able, just seem to disappear.
If everything seems to be going well, you have obviously overlooked something.
Ron
Please help us, help you -before posting a question please
read
Before posting a performance problem please
read
Post #1096660
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.