Cloudopszone
All About Microsoft Azure & Power Platform services
Recent Posts
List Heap Tables
Heap table are the tables which they don’t have any clustered index. : -- List all heap tables SELECT SCH.name + '.' + TBL.name AS TableName FROM sys.tables AS TBL INNER JOIN sys.schemas AS SCH ON TBL.schema_id = SCH.schema_id INNER JOIN sys.indexes AS IDX ON...
Check remaining days of Remote Desktop Services
By using the following command you can check the remaining days of RDS. Open CMD, and run the following command : wmic /namespace:\\root\CIMV2\TerminalServices PATH Win32_TerminalServiceSetting WHERE (__CLASS !="") CALL GetGracePeriodDays
Storage Pools For SQL Server
By following the next steps you are able to create storage pools for a SQL Server installation. Storage Pool Best Practices Column Size = Number Of Disks In The Storage Pool, example 2 Disks = Column Size 2 Interleave = For OLTP Best is 256KB , For TSQL Best is 64K...
How to merge multiple vmdk’s into single vmdk
In order to merge split vmdk files into one, you need to use the vmware-vdiskmanager command. However, this is only available if you have VMware Fusion or VMware Workstation installed. VMware Player doesn’t have this. There is a utility which it can be downloaded...
Massive Endpoints Creation & Deletion on Windows Azure
Bellow a script which helps you to create || delete massive endpoints on Azure. {Applies on ASM} #Enter Azure Account Add-AzureAccount #Choose Subscription Select-AzureSubscription -SubscriptionName "MySubscripiton" #Massive EndPoint creation from Port 6100 to 6120...
Check RDP Connection using PowerShell
As a Windows Admin, there are several cases, that some users facing connectivity problems with RDP connection. It's easy to check RDP connection by executing the following powershell script. New-Object System.Net.Sockets.TCPClient -ArgumentList "ip address",RDP port...
Enable IP Forwarding On Azure VM
You can enable IP Forwarding on an Azure VM (ASM), with the following command. $vmname = "MyVM" $servicename = "MyCloudService" $vm = Get-AzureVM -ServiceName $servicename -Name $vmname Set-AzureIPForwarding -ServiceName $ServiceName -VM $VM -Enable
Remote PowerShell To Windows Azure VM
Firstly, to be able to run Remote PowerShell commands you will need to create rules on Azure and Windows Firewall that allow access to RM port. Secondly, you must download and install PowerShell And final, execute the following command, Enter-PSSession -ComputerName...
SEARCH
Search my blog
George Grammatikos
George Chrysovalantis Grammatikos is an Azure Cloud Architect. He has more than 10 years experience in different technologies like BI & SQL Server Professional level solutions, Azure technologies, networking, security etc. He writes technical blogs for his blog “cloudopszone.com”, MS wiki articles and participates in discussions on Microsoft Wiki and other technical blogs.