SQL Server Everywhere Microsoft SQL Server 2005 Everywhere Edition CTP available :
http://www.microsoft.com/downloads/details.aspx?FamilyID=85E0C3CE-3FA1-453A-8CE9-AF6CA20946C3&displaylang=en
SQL Server security best practice
Security! This is the word comes in mind of every concerned person when it come...
Change the Collation Settings in MS SQL Server
This post will show you how to change the collation settings in MS SQL Server for specific database...
Resolve collation conflict
In this post I will show you how you can resolve collation conflict error...
Book: SQL Server 2008 High Availability
In this book I have tried to cover every single piece of information that might requires for installing and configuring SQL Server HA option like Clustering, Replication, Log Shipping and Database Mirroring...
Why to recompile Stored Procedure
Generally, we create views and stored procedures (proc here after) ...
7/06/2006
MS Released SQL 2005 Everywhere Edition CTP
http://www.microsoft.com/downloads/details.aspx?FamilyID=85E0C3CE-3FA1-453A-8CE9-AF6CA20946C3&displaylang=en
7/05/2006
Securing Microsoft SQL Server
Hi,
their are several ways to secure your SQL Server
1). Strengthen Password Mechanism
2). Using NTFS File System
3). Change the Port of SQL Server other than default
4). Use named instance
5). Set firewall
6). Using Windows Authentication
7). Using EFS
i would suggest to refer below links for more :
http://vyaskn.tripod.com/sql_server_security_best_practices.htm
www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlc2.mspx -- C2 Audit
http://www.sql-server-performance.com/ck_database_encryption.asp
http://www.sqlservercentral.com/columnists/bkelley/implementing_efs.asp
http://www.microsoft.com/sql/prodinfo/previousversions/securingsqlserver.mspx
Regards
7/01/2006
Login fail for user %s
Hi,
if you get an error message like "Login fail for User %s , not associated with trusted connection"
here is a KB for your reference.
http://support.microsoft.com/kb/889615
http://support.microsoft.com/kb/555332/en-us
This posting provided AS IS
Upgrade help to SQL Server 2005
Hi,
here is a reference article for those who wants to upgrade to SQL Server 2005
http://www.microsoft.com/technet/prodtechnol/sql/themes/default.mspx
Microsoft SQL Server 2005 SP 1.0
Hi,
MS released Service Pack Version 1.0 for SQL Server 2005 ,
here is download link
http://www.microsoft.com/downloads/details.aspx?FamilyID=CB6C71EA-D649-47FF-9176-E7CAC58FD4BC&displaylang=en
Download BPA for Microsoft SQL Server 2000
Hi,
here is a download link for Best Practices Analyzer Tool for Microsoft SQL Server 2000 1.0
http://www.microsoft.com/downloads/details.aspx?displayla%20ng=en&familyid=B352EB1F-D3CA-44EE-893E-9E07339C1F22&displaylang=en
Handling Deadlock in Microsoft SQL Server
Hi,
I have found wonderfull KB for handling deadlock conditions in SQL Server
http://support.microsoft.com/kb/118552/en-us just FYR
Not associated with a trusted SQL Server connection
You may receive a "Not associated with a trusted SQL Server connection" error message when you try to connect to SQL Server 2000 or SQL Server 2005
http://support.microsoft.com/kb/889615/en-us
Microsoft SQL Server doesn't exists or access denied
Hi,
whenever you get an error like "SQL Server does not exists or access denied"
refer below KB
http://support.microsoft.com/kb/328306/en-us
Troubleshoot Microsoft SQL Linked Server
Hi,
this is a KB for How to troubleshoot error 7391 that occurs when you use a linked server in SQL Server http://support.microsoft.com/kb/306212/en-us
Authentication Method Troubleshooting in ASP / SQL
Dear all,
here is a KB link FYI for Authentication methods for connections to SQL Server in ASP
http://support.microsoft.com/kb/247931/en-us
