Browse by Tags

SQL Server Lockdown - Step by Step procedure

Published 13 February 8 2:31 AM | SSQA.net

Do you want to lockdown your SQL Server environment? Hope you dont'! Though it is not a good practice or recommendation to perform, but will atleast prove how far your SQL Server environment has securit compliance as per the industry best practices...

Filed under: sql server, microsoft, security, tools, article, sa, procedure, best practice, downloads, bpa, lock down

SQL Server 2005 schema integration changes and use of best practices - use of Schema Qualified Tables/Views

Published 24 January 8 7:19 AM | SSQA.net

You all know that it is a best practice to use the schema qualified tables or views for the better management and performance (sometimes). As the Best Practices Analyzer tool which will be a part of SQL engine from 2008 version onwards confirms that this...

Filed under: sql server, download, version, best practices, 2005, bpa, schemas, tablels, referential integrity, query plans