Keep it Simple and Smart
We 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 moreNetVideoHunter firefox addon (extension) is a download helper tool that let you easily download videos and music from almost any video-sharing site. For example from: Youtube, Facebook, Metacafe etc… With the new version it’s possible to download Youtube videos in different qualities (360p, 480p, 720p, 1080p) if it’s available. By
» Read moreWhat is difference between Value Type and Reference Type ? or Value Type Vs Reference Type ? Value Type A data type is a value type if it holds the data within its own memory allocation. All value based types are allocated on the stack. When a value type is
» Read moreDear and Respected All, I am pleased to announce that Yesterday (17-June-2011) I have passed the examination of Microsoft Certified Technology Specialist (MCTS): Microsoft SQL Server 2008, Implementation and Maintenance. For more details about this exam 70-432: http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-432&locale=en-us
» Read moreVarinder Sandhu is using WP-Gravatar