Skip to main content

Posts

Different ways to create Azure Virtual Machines

Today   I am going to summarize various ways by which you an create Windows Virtual Machine in Microsoft Azure. [This article applies to Windows Virtual Machines] By Using Azure Portal If you are a beginner then this is the right place to start with for creating virtual machines in an easy to use portal. Please follow the below guided information to create your first Virtual Machine on windows. Follow the below link for more detailed explanation https://docs.microsoft.com/en-us/azure/virtual-machines/windows/quick-create-portal By Using Resource Manager Template When you create a Virtual Machine you may require to setup multiple things like setting up storage, Deployment and other required resources. These settings may require to perform separate actions during the setup. Hence in order to manage all of these resources in a single coordinated operation templates are used. Follow the below link for more detailed explanation https://azure.mi...

SQL Server - Get the list of tables without Indexes

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 !!!
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...