Harsh Shah's Blog

Here is the quickest way to know the list tables in SQL Server which doesn't have Indexes. This will be very useful when we have large number of tables in our SQL Server database. SELECT DISTINCT so.object_id,                 so.NAME FROM   sys.indexes si        INNER JOIN sys.objects SO                ON SO.object_id = si.object_id WHERE  SO.type = 'U'        AND si.index_id = 0 Happy Learning !!!

As you all know, Microsoft has just released full featured Visual Studio 2013 Community Edition. This allows developers to use fully loaded Visual Studio Development Environment. So the questions arises is , what is the difference between Visual Studio Community Edition and Express Edition ?

Try Microsoft Products for Free in Virtual Lab Environment Ever thought of trying Microsoft Product for Free before installing it ? Or just wanted to learn about a new feature Microsoft recently introduced i.e. even before installing it? Like this there are various reasons we wanted to try or to just learn something new. If your answer is yes to above questions, then Microsoft is offering a complete Virtual Environment - with Hands-On-Lab for testing various product features which you can't do it considering various limitations like - Can't install on a production Environment, Don't have enough infrastructure ready to setup the data etc.. etc.. Microsoft is offering HOL (Hands On Lab) for various products and you can check it out here https://technet.microsoft.com/en-us/virtuallabs?id=J+avMPtWlXk There are system requirements needs to be followed to run the Hands on Lab which you can find it here Check System Requirement : https://vlabs.holsystems...