SQL Server worst practices

0 pts.
Tags:
Administration
Availability
Backup & recovery
CE/Mobile
Database Management Systems
Development
Hardware
Migration
Modeling
Normalization
Performance/Tuning
Security
SQL Server
Standard Edition 2000
Version 7 and earlier
Hello, My name is Nick Bellistri and I am the assistant site editor for SearchSQLServer.com. Jeremy Kadlec, a performance and tuning expert at SearchSQLServer.com, recently wrote up what he considers some of the worst SQL Server practices and offered recommended fixes. You can see the list here: http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1071463,00.html. In response to this tip, several readers submitted their own worst practices ? and now we?d like to hear from you. Whether you left system performance out of your requirements analysis or you know someone who has no dedicated development and test environments, send us your worst practice and you will be eligible to win a TiVo Series 2 40-hour DVR. Please submit your tips here: http://searchsqlserver.techtarget.com/tips/0,289484,sid87,00.html Thanks for your time. Nicholas Bellistri Assistant Editor SearchSQLServer.com
ASKED: July 25, 2005  12:16 PM
UPDATED: July 26, 2005  8:30 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

#1 – default install while attached to the network – you can lose the system before entering a password for the SA.

#2 – The multiple applications that install MSDE without a password on SA or don’t require that step during install.
(Two parties at fault – the app maker for not telling you and helping make it secure. And the user for not knowing what the application is installing, especially on a production machine.)

#3 – Applications with a default user & default password. Some apps give security control to this ‘superuser’. With SQL set to be a transparent service, a hacker with user/password can troll for your server using odbc connections.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following