Showing posts with label advices. Show all posts
Showing posts with label advices. Show all posts

Friday, February 24, 2012

Is installation secure ?

We can find a lot of recommandations about how to secure a SQL*Server configuration.

Does anyone have scripts to do it ?
Any advices or links are welcomeHi

Have you checked out
http://www.microsoft.com/sql/techin...ity/default.asp

and the baseline security analyser
http://www.microsoft.com/technet/tr...ls/mbsahome.asp

John

"Kona" <kona_iron@.yahoo.fr> wrote in message
news:a1de658a.0402261821.4e275230@.posting.google.c om...
> We can find a lot of recommandations about how to secure a SQL*Server
configuration.
> Does anyone have scripts to do it ?
> Any advices or links are welcome|||kona_iron@.yahoo.fr (Kona) wrote in message news:<a1de658a.0402261821.4e275230@.posting.google.com>...
> We can find a lot of recommandations about how to secure a SQL*Server configuration.
> Does anyone have scripts to do it ?
> Any advices or links are welcome

You can download the Microsoft Security Baseline Analyzer, and the
Microsoft SQL Best Practices Analyzer - both will highlight common
security issues. You might also find this link helpful:

http://www.sqlsecurity.com/DesktopDefault.aspx

Simon

Monday, February 20, 2012

Is B-Tree the only Index structure within SQL Server 2005 database?

Hi, All,

Is B-Tree the only Index structure used within SQL Server 2005 database?

Thanks a lot in advance for any guidance and advices for that.

With best regards,

Yours sincerely,

Yes, B-trees are the only index structure available. These are used for nonclustered indexes, and for clustered indexes. An unordered "heap" structure is used to store the data in tables with no clustered index.

Thanks,
--R

|||

Hi, Ryan, thanks a lot for your guidance.

With best regards,

Yours sincerely,

Is B-Tree the only Index structure within SQL Server 2005 database?

Hi, All,

Is B-Tree the only Index structure used within SQL Server 2005 database?

Thanks a lot in advance for any guidance and advices for that.

With best regards,

Yours sincerely,

Yes, B-trees are the only index structure available. These are used for nonclustered indexes, and for clustered indexes. An unordered "heap" structure is used to store the data in tables with no clustered index.

Thanks,
--R

|||

Hi, Ryan, thanks a lot for your guidance.

With best regards,

Yours sincerely,