Keep it Simple and Smart
Dear 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 scripts are using the function and syntax as Example: TSEQUAL (TxnStatus, @ciTxnSts) JOIN syntax which has *= and =* to specify the OUTER JOIN. Solution: TxnStatus = @ciTxnSts instead 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 of the features needed by technical writers (Scrolling page screenshots and automatic ‘trim edges’ function) Before start to take screenshot with SnagIt, you can set output file for screenshot (eg. SnagIt editor
» 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 default it downloads in the best available quality. For more help check out the homepage: http://netvideohunter.com/ Related Video: http://www.youtube.com/watch?v=NprtpqPaHvQ&playnext=1&list=PL4ED22C52A5DCBF70 http://www.youtube.com/watch?v=dQOIUh13vs4&feature=related
» 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 assigned to another value type, it is copied. Reference Type A reference type contains a pointer to another memory location that holds the data or we can say reference type
» 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 moreYouSendIt is popular online file sharing software that allows you to easily send large files and email attachments. The sender can enter the recipients’ e-mail addresses, attach the file and send it; the recipients receive an e-mail notification with a URL that lets them download the file. I am using YouSendIt Express from couple of months, it is really useful software that helps to share files. With the help YouSendIt Express you can send file up to 100 MB and paid accounts
» Read moreTable-valued parameters are a new parameter type introduced in SQL Server 2008. With the help of table-valued parameters, you can send multiple rows of data to a stored procedure or function, without creating a temporary table or many parameters. Steps to create Table-Valued Parameters Create a table type and define the table structure. Declare a stored procedure or function that has a parameter of the table type. Declare a variable of the table type, and reference the table type. Fill
» Read moreToday I have attended the webcast topic “Inside of Next Generation SQL Server – Denali” at Zeollar.com. This session presented by Pinal Dave (http://blog.sqlauthority.com) It was really a nice presentation about features of SQL Server 2011 – Denali. You can get the details of this session at here You can watch or download the video at http://zeollar.cloudapp.net/Session/234
» Read moreTemporary tables are a useful feature provided by SQL Server. Temporary tables created at runtime and can do all kinds of operations that one normal table can do. Because this is available at runtime, that’s why the scope of temporary tables is limited. These tables are created inside the tempdb database. There are two types of Temporary tables. Local Temporary table Global Temporary table Local temporary table: Local temporary tables are available to the current connection or sessions to the
» Read moreSQL Server user-defined functions and stored procedures have almost similar functionality. Both allow you to create a batch of SQL statements to execute on SQL server. Benefits: We can reuse the code from one program to another, this way we can increase the productivity. Centralize control, to make business logic changes in a single place that automatically affect all dependent applications. Difference between User Defined Functions and Stored Procedures Stored procedures are called independently, using the EXEC command. Example: EXEC dbo.procedure_name ‘Parameter1’Functions are
» Read moreBlog – News You can get update of this blog (www.varindersandhu.in) using social media Get update by Twitter Twitter: @varinder_sandhu Get update by Facebook Facebook Page: Varinder Sandhu You can subscribe to www.varindersandhu.in by FEED or EMAIL
» Read more