Wednesday, February 1, 2006

Useful Knowledge Bases and Links

Remove -How to uninstall SQL Server Management Studio
http://support.microsoft.com/default.aspx?scid=kb;EN-US;909953

Moving SQL Server 2005 Databases to SQL Server 2000
http://www.codeproject.com/cs/database/MovingSQLServer2005to2000.asp

BLOGs of SQL Server 2005 Product Team
http://blogs.msdn.com/sqlserverstorageengine/archive/2007/02/14/wow-lots-of-blogs-from-the-sql-product-team.aspx

Configure SQL Server for Remote Connection
http://blogs.msdn.com/sql_protocols/archive/2006/09/30/SQL-Server-2005-Remote-Connectivity-Issue-TroubleShooting.aspx

Connecting to SQL Express User Instances in Management Studio
http://blogs.msdn.com/sqlexpress/archive/2006/11/22/connecting-to-sql-express-user-instances-in-management-studio.aspx

Best Practices in SQL Server
http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/default.mspx

Performance Tuning - How to monitor blocking in SQL Server :
http://support.microsoft.com/kb/271509

Reading Execution Plan :
http://support.microsoft.com/default.aspx?scid=%2Fservicedesks%2Fwebcasts%2Fen%2Ftranscripts%2Fwct032703.asp&SD=GN

Statistics in SQL --http://support.microsoft.com/default.aspx/kb/195565

How to recover user databases from a “Suspect” status : http://www.myitforum.com/articles/18/view.asp?id=7381

Table and index partition in SQL Server 2005
http://www.sqlskills.com/resources/Whitepapers/Partitioning%20in%20SQL%20Server%202005%20Beta%20II.htm

Compare the feature of SQL Server different editions
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

SQL Server Stored Procedure Basics
http://www.awprofessional.com/articles/article.asp?p=25288&seqNum=4&rl=1

Grant Permission to run Profiler for a General user
http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=18962


SQL Server 2000 Security Information page
http://www.microsoft.com/sql/security
Best Practices Analyzer Tool for Microsoft SQL Server
http://www.microsoft.com/downloads/details.aspx?displayla%20ng=en&familyid=B352EB1F-D3CA-44EE-893E-9E07339C1F22&displaylang=en
Microsoft Baseline Security Analyzer
http://www.microsoft.com/technet/security/tools/
Tools/mbsahome.asp
Software Update Services 1.0 with Service Pack 1
http://www.microsoft.com/downloads/details.aspx?FamilyID=a7aa96e4-6e41-4f54-972c-ae66a4e4bf6c&DisplayLang=en



SQL Server Security
􀁺Chip Andrews, David Litchfield, Bill Grindlay
http://www.amazon.com/exec/obidos/tg/detail/-/0072225157/qid=1067276265
􀂄SQL Server Security Distilled
􀁺Morris Lewis
http://www.amazon.com/exec/obidos/tg/detail/-/1590591925/qid=1067276265
􀂄Mastering SQL Server 2000 Security
􀁺Mike Young, Curtis Young
http://www.amazon.com/exec/obidos/tg/detail/-/0471219703/qid=1067276265
􀂄Writing Secure Code Second Edition
􀁺Michael Howard & David LeBlanc
http://www.amazon.com/exec/obidos/tg/detail/-/0735617228/qid=1067276203

SQL Server 2000 SP3 Security Features and Best Practices: Implementation of Server Level Security and Object Level Security
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sp3sec02.mspx

SQL Server 2005 Deployment Guidance for Web Hosting Environments - byAlex DeNeui http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/SQL2005DGWHE.mspxResolving Common Connectivity Issues in SQL Server 2005 AnalysisServices Connectivity Scenarios - by Carl Rabeler http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/CISQL2005ASCS.mspxImplementing Application Failover with Database Mirroring - by MichaelThomassy, Sanjay Mishra http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/implappfailover.mspx

How to dynamically number rows in a SELECT Transact-SQL statement
http://support.microsoft.com/kb/q186133/

How to Delete Duplicate Rows
(a) http://support.microsoft.com/kb/70956
(b) SQL 2005 :http://msdn2.microsoft.com/en-us/library/ms345415.aspx
(c) SQL 2000 :http://msdn2.microsoft.com/en-us/library/aa176798(SQL.80).aspx

Scheduling Backups for SQL Server 2005 Express
http://www.mssqltips.com/tip.asp?tip=1174

Different Options for Importing Data into SQL Server
http://www.mssqltips.com/tip.asp?tip=1207

Security, SQL Server : Current topics: Security, SQL Server
http://blogs.msdn.com/lcris/archive/2007/03/23/basic-sql-server-security-concepts-logins-users-and-principals.aspx


SQL Server White Papers: Migration from Oracle or Sybase to Microsoft SQL Server
http://www.microsoft.com/downloads/details.aspx?FamilyID=3F0F2A3F-DFF9-49CD-8EA7-581AA7A303A4&displaylang=en

restore database after deleted transaction log
http://www.dbforums.com/archive/index.php/t-333340.html


Connection to Sql server being lost after a period of inactivity
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2282563&SiteID=1
http://www.microsoft.com/downloads/details.aspx?FamilyID=10CC340B-F857-4A14-83F5-25634C3BF043&displaylang=en
 
Locations of visitors to this page