SQL Server Performance

SQL 2005 Security Best Practices?

Discussion in 'SQL Server 2005 General DBA Questions' started by biged123456, Sep 30, 2005.

  1. biged123456 New Member

  2. satya Moderator

    I believe the best practices will come into effect once the full product has been used and you may need to wait until end of this year to see such information. As of now there is no information about BPA usage in SQL 2005.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. biged123456 New Member

    Thanks Satya,

    I did dig up some information in the latest books online, but it still wasn't to the level I would have hoped.

    Matt
  4. ghemant Moderator

    hi,<br />a link to refer :<br /><br /><a href='http://msdn.microsoft.com/msdnmag/issues/05/06/SQLServerSecurity/default.aspx' target='_blank' title='http://msdn.microsoft.com/msdnmag/issues/05/06/SQLServerSecurity/default.aspx'<a target="_blank" href=http://msdn.microsoft.com/msdnmag/issues/05/06/SQLServerSecurity/default.aspx>http://msdn.microsoft.com/msdnmag/issues/05/06/SQLServerSecurity/default.aspx</a></a><br /><br /><a href='http://searchsqlserver.techtarget.com/originalContent/0,289142,sid87_gci1102096,00.html' target='_blank' title='http://searchsqlserver.techtarget.com/originalContent/0,289142,sid87_gci1102096,00.html'<a target="_blank" href=http://searchsqlserver.techtarget.com/originalContent/0>http://searchsqlserver.techtarget.com/originalContent/0</a>,289142,sid87_gci1102096,00.html</a><br /><br /><a href='http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=10998' target='_blank' title='http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=10998'<a target="_blank" href=http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=10998>http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=10998</a></a><br /><br /><br />HTH<br /><br />[<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br />Regards<br /><br />Hemantgiri S. Goswami<br />ghemant@gmail.com<br />"Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri Goswami<br />
  5. satya Moderator

    We may need to wait another month to get hold of any news on working with SQL SErver 2005 full product release. I believe Microsoft will not release any affiliated tools until the full product is bug fixed.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  6. FrankKalis Moderator

    <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><br />until the full product is bug fixed<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />Hm, you should have better written "until the full product goes RTM". [<img src='/community/emoticons/emotion-2.gif' alt=':D' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Ich unterstütze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>) <br />
  7. satya Moderator

    Agreed, please read my last words on above post as referred by Frank [<img src='/community/emoticons/emotion-1.gif' alt=':)' />].<br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com/forum>http://www.SQL-Server-Performance.Com/forum</a><br /><center><font color="teal"><font size="1">This posting is provided “AS IS” with no rights for the sake of <i>knowledge sharing.</i></font id="size1"></font id="teal"></center>
  8. biged123456 New Member

    Very interesting. I suppose one thing not in many of the documents is to backup your Service Master Encryption Key after you install SQL. I would guess if you had a disaster and had to reinstall SQL, without your Master Key, you won't be able to get your encrypted data.
  9. satya Moderator

    True and that is the reason better not to use system supplied encryption functions, better to develop them in-house for better troubleshooting.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page