Sql Server 2005 Installation Issues…

If installation of Sql Server 2005 fails on XP because of MSXML6Then check the following threadhttp://www.windows-tech.info/15/62c4c7d22384e2f6.php

Windows Installer CleanUp Utilityhttp://www.softpedia.com/get/Security/Secure-cleaning/Windows-Installer-CleanUp-Utility.shtml

When you try to install SQL Server 2005 you may get the following error message during setup: “Shared Memory Provider: No process is on the other end of the pipe”http://social.msdn.microsoft.com/Forums/en-US/vssetup/thread/968cd292-5a3f-4c48-9347-4604a6fa9872/http://blogs.msdn.com/sql_protocols/archive/2005/10/22/483684.aspx

…finaly found the problem to […]

Deep dive to Sql Server 2005 system tables!

WARNING: These kind of system table modification activities are NOT SUPPORTED by Microsoft! So if you try these activities that means you accept not to get support for your Sql Server 2005 installation from Microsoft. You are left alone with the circumstances of your activities. Use at your own risk!

Here is a great trick […]

Sql Server 2005 Performance Articles

Tips for Using SQL Server Performance Monitor Counters

Measuring Database Performance by Using Microsoft® SQL Server™ 2005

The .Net Developer And SQL Server: Working On Locks

 

Free Tool: SQL Sentry’s Plan Explorer http://sqlmag.com/database-administration/free-tool-sql-sentrys-plan-explorer http://www.sqlsentry.com/products/plan-explorer/sql-server-query-view

 

 

SQL Server 2005: CLR Integration ..::.. Working with Regular Expressions

http://blogs.msdn.com/sqlclr/archive/2005/06/29/regex.aspx

Sql Server 2005 DML Auditing

I was curious if i could log SELECT queries to a table, i started to search over the net and found a post that is exactly describing this situation:http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1949822&SiteID=17 (*)

The Audit DB tool may be used to achieve this goal.http://lumigent.com/products/auditdb.html

Also i want to mention the existance of various products are listed at the […]