SQL Web Sites

---

SQL Server Important Web SITE

SQL Server 2005 Architecture http://www.mssqltips.com/categorylist.asp?ns http://www.microsoft.com/Sqlserver/2005/en/us/compare-features.aspx http://www.programmersheaven.com/2/SQL-server-2005-school http://www.programmersheaven.com/2/SQL-server-2005-school-lesson-2

Mail Send Related http://www.databasejournal.com/features/mssql/article.php/3626056/Database-Mail-in-SQL-Server-2005.htm http://www.sql-server-performance.com/articles/dba/email_functionality_p1.aspx http://social.msdn.microsoft.com/forums/en-US/sqltools/thread/81b8a864-6823-41ec-8166-e1b7537c3867/ http://articles.techrepublic.com.com/5100-10878_11-6164310.html?tag=leftCol;post-248 http://articles.techrepublic.com.com/5100-10878_11-5094201.html http://articles.techrepublic.com.com/5100-10878_11-6161839.html http://www.datasprings.com/Resources/ArticlesInformation/CreatingEmailTriggersinSQLServer2005.aspx

Naming Standards Related Web Sites http://technet.microsoft.com/en-us/library/ms124438.aspx http://www.cms.hhs.gov/dbadmin/downloads/sqlserverstandardsandguildelines.pdf http://www.arc.sci.eg/NARIMS_upload/NARIMSdocs/73391/Appendix%20A_%20DatabaseObjectNamingStandardsSQLServer.pdf http://blogs.msdn.com/steven_bates/archive/2006/03/20/Database-Object-Naming-Rules.aspx http://blog.sqlauthority.com/2008/09/25/sql-server-guidelines-and-coding-standards/

SQL Security & User & Login Rights Related Web Sites http://msdn.microsoft.com/en-us/library/bb510589.aspx http://msdn.microsoft.com/en-us/library/bb283235.aspx http://msdn.microsoft.com/en-us/library/aa337562.aspx http://blog.sqlauthority.com/2009/04/28/sql-server-introduction-to-sql-server-encryption-and-symmetric-key-encryption-tutorial-with-script/ http://www.databasejournal.com/features/mssql/article.php/3357861/SQL-Server-2000-Security---Part-4-Authorization.htm http://anasoft.wordpress.com/2007/06/17/sql-server-2005-security-architecture/

Disaster Recovery http://support.microsoft.com/kb/822400 http://technet.microsoft.com/en-us/library/cc917680.aspx http://www.mssqltips.com/tip.asp?tip=1595 http://www.exforsys.com/tutorials/sql-server-2005/sql-server-disaster-recovery.html

Installation of SQL Server 2005 Related Web Sites http://www.exforsys.com/tutorials/sql-server-2005/getting-started-with-sql-server-2005.html

Log Shipping Related Web Sites http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1309728,00.html http://www.informit.com/articles/article.aspx?p=331402&seqNum=4 http://www.mssqltips.com/tip.asp?tip=1158

Maintenance Plan http://msdn.microsoft.com/en-us/library/ms189036(SQL.90).aspx http://cherupally.blogspot.com/2009/04/schedule-daily-backup-for-sql-server_27.html http://www.sql-server-performance.com/articles/dba/creating_backup_jobs_p1.aspx http://www.mssqltips.com/tip.asp?tip=1094 http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1168448,00.html http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1225990_mem1,00.html http://blogs.techrepublic.com.com/datacenter/?p=248 http://www.mssqltips.com/tip.asp?tip=1016 http://www.exforsys.com/tutorials/sql-server-2005/sql-server-2005-maintenance-plan-using-wizard.html

SSIS http://www.accelebrate.com/sql_training/ssis_tutorial.htm http://www.sql-server-performance.com/articles/dba/package_configuration_2005_p1.aspx

Data modeling http://www.learndatamodeling.com/ http://www.datamodeling.info/index.jsp

Excel to SQL Server 2005 http://blogs.techrepublic.com.com/datacenter/?p=205

Backup and Restore http://articles.techrepublic.com.com/5100-10878_11-1041267.html