Keep it Simple and Smart
Prior to SQL server 2005, the only way of performing the error handling was to test vale of @@ERROR global variable. Once the SQL Server completes the execution of a Transact-SQL statement, it records the status of result in @@ERROR. If the error occurred, @@ERROR contains the error number. If
» Read moreMy friend wants to restore the SQL 2008 full backup to SQL Server 2005. He faced an issue while restore the SQL 2008 full backup to SQL Server 2005. He has a question from me as: Can we restore the SQL 2008 full database backup to SQL Server 2005? Answer:
» Read moreLike all client-server applications, web applications have two distinct components: Client Client also known as the front-end interface, the web browser presents the user interface, accepts user input, and sends data to the server for processing. Server Server also known as the back end, the web server responds to requests from clients for specific
» Read moreWe all know about the security concepts, Authentication and Authorization. However, it is really important to know the difference between Authentication and Authorization.  Lot of detailed stuff is available over the internet but here sharing with you the brief information about the difference between Authentication and Authorization, so that we can
» Read moreI had requirement to get the Comma Separated Values from the table for specific column. So here sharing with you example how i handle this situation. USE tempdb GO CREATE TABLE test1 ( column1 INT, column2 VARCHAR(6) ) INSERT INTO test1 VALUES (1,'Test1'), (1,'Test2'), (2,'Test3'), (2,'Test4'), (3,'Test5') Now see the
» Read moreIt is very common practice to create an exact copy of the database backup and store it to different places so that in case any emergency or misfortune, DBA should have the alternative location to find the backup of databases. Â Once a full backup is accomplished DBAs generally copy the
» Read moreI had requirement to find list of all the SQL Server installed on local network then I found few very useful commands. Here sharing with you all. You can use sqlcmd, osql and isql with the -L option as shown below. Using sqlcmd -L Servers: SQLServer1 SQLServer2\DBServer SQLServer3\ReportServer SQLServer4\SQLExpress SQLServer5
» Read moreDear and Respected All, I am pleased to announce that today (06-July-2011) I have passed the examination of Microsoft Certified Technology Specialist (MCTS): Microsoft .NET Framework – Application Development Foundation. For more details about this exam 70-536: http://www.microsoft.com/learning/en/us/exam.aspx?id=70-536
» Read moreI have faced an issue during SQL Server Migration. Here sharing with you. As I need to move some databases from SQL Server 2000 to SQL Server 2008 then I faced a problem because TSEQUAL and JOIN syntax such as *= or =* not supported in SQL Server 2008. Some of
» Read moreI have tried the Utility SnagIt; it is really helpful for me… Thought it will be handy to all of us, that’s why sharing with you all SnagIt is a screenshot ( Screenshot Utility ) program. It is created and distributed by TechSmith. SnagIt replaces the native Print Screen function with additional features. It contains most
» Read moreVarinder Sandhu is using WP-Gravatar