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 […]

March 4th, 2009 | Tags: , , | Category: Sql Server | Comments are closed

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 […]

January 21st, 2009 | Tags: , , | Category: Sql Server | Comments are closed

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

 

 

January 10th, 2009 | Tags: , , | Category: Sql Server | Comments are closed

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

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

December 13th, 2008 | Tags: , | Category: Sql Server | Comments are closed

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 […]

March 15th, 2008 | Tags: , | Category: Sql Server | Comments are closed