All Articles

by Categories

• Database (70)
  • Microsoft SQL Server (64)
• DB Articles (18)
• IIS (1)
• MySQL (9)
• Networking (6)
• Oracle (4)
• SQL Server 2008 (5)
• Windows OS (3)

by Month

• November 2009
• October 2009
• September 2009
• August 2009
• July 2009
• June 2009
• April 2009
• March 2009
• January 2009
• December 2008
• November 2008
• September 2008
• August 2008
• May 2008
• April 2008
• March 2008

Last 50 Posts

• Msg 7391, Level 16, State 2, Line 23 – Error while running Linked Server

• Script – Generate DBCC ShrinkFile for each datbase files

• Login failed for user ‘(null)’. Reason: Not associated with a trusted SQL Server connection.

• DBCC PAGE

• Shrink Log File

• An error has occurred while establishing a connection to the server

• What are the features we can enable using Surface Area Configuration Tool?

• SQL Server Security Interview Questions

• How to change Min/Max Memory in SQL Server?

• SQL Server 2008 Active-Passive/Active-Active Cluster Installation

• How to move Cluster Resource/Services to proper node using command prompt?

• How to check cluster resources are running on proper node using command prompt?

• Login Issue

• Shrink the log to as small a size as possible (truncateonly)

• Happy Birthday to Me (It’s 1-Sept)

• SQL Server 2005 Backup Error Messages

• Server: Msg 7391, Level 16, State 1, Line 2

• Error: 18456, Severity: 14, State: 16

• Insert Extended Character using OSQL Utility

• Msg 15410, Level 11, State 1

• Msg 15063, Level 16, State 1

• Troubleshoot Blocking

• kernel udopen: operating system error 2 in SQL Server 6.5

• How to find database restore history from MSDB?

• How to improve communication skills & Support Service

• Save Water, Save Life and Save the Workl

• How to improve TempDB performance?

• Troubleshoot Suspect Database Issue

• DRBD, Heartbeat and MySQL

• Memcached & MySQL

• How to search error from SQL Server error log or SQL Server Agent Log?

• Error 18456, Severity 14: Login Failed States

• How to Alter a SQL Server Database as Single User Mode and as Multi User Mode

• Happy Republic Day

• Find the SQL Server Service Startup Time

• Execute As in SQL Server 2005

• How to recover root password in MySQL?

• Oralce Interview Questions – Year 2009 Part – II

• Oracle Interview Questions – Year 2009 – Part I

• MySQL and Linux commands

• How to decide Primary Key column data type in MySQL? Expectation with the Primary Key column

• SQL Server Execution Context and Security

• SQL Server Interview Questions 2K9 – Part – I

• SQL Server 2005 Schema, Schema Properties, Schema T-SQL

• Download SQL Sever 2005/SQL Server 2008 Samples

• Sqlcmd: Error: Microsoft SQL Native Client: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.

• Wishing you all Very happy and prosperous new year

• How do I install the Service Pack?

• SQL Server Service Packs and Hotfixes

• How do we see the SQL Plan in textual format?