Jan 4

Using Netstat to see which service is using which port

Posted in Microsoft

As you might have already know that we use netstat for locating ports that was used by executable files or services. Normally we need to use this for debugging or even to learn more about the service. A help request for the netstat command would look identical to the following:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Now issue the command “netstat -p UDP -ab” which would show us exactly what we need; the port usage for various services. So the issued command would show similar output like the below image:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

netstat -s” would show you more info like the following:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Well, if you require more info please click HERE that will take you to a link to the Microsoft site where more guided tour is provided for netstat.

comments: 0 » tags:
Dec 28

Re-Initialize BitLocker Encryption After Changing BIOS Information

Posted in Microsoft

I believe some of you already gone through this but this small workaround is for the people who is looking for a quick relief. When a computer BIOS is updated or the switches changed in the BIOS config; the BitLocker would realize that the signature has been changed and it would not boot. Rather BitLocker would present you to enter the recovery key every time you boot. The Screenshot would look like this:

 

 

 

 

 

 

 

 

 

 

 

We can get rid of this annoying problem by forcing BitLocker to suspend. And then turn it back on again, and Wa La problem solved. The new signature from the BIOS will be registered and the BitLocker would reinstate it’s state.  Go to the control panel and suspend bitlocker just like the picture below:

comments: 0 »
Dec 21

FREE SQL Server 2008 R2 eBook from Microsoft Press

Posted in Microsoft

Introducing Microsoft SQL Server 2008 R2, by Ross Mistry and Stacia Misner

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

The good thing is that the book is free and distributed by MIcrosoft itself. And can be found HERE

The TOC is like below:

PART I   Database Administration

CHAPTER 1   SQL Server 2008 R2 Editions and Enhancements
CHAPTER 2   Multi-Server Administration
CHAPTER 3   Data-Tier Applications
CHAPTER 4   High Availability and Virtualization Enhancements
CHAPTER 5   Consolidation and Monitoring

PART II   Business Intelligence Development

CHAPTER 6   Scalable Data Warehousing
CHAPTER 7   Master Data Services
CHAPTER 8   Complex Event Processing with StreamInsight
CHAPTER 9   Reporting Services Enhancements
CHAPTER 10   Self-Service Analysis with PowerPivot

The first part focuses on the DBA track, and the second part in BI. Beautiful composition, and packed with moderate techy how-to’s. Good for standard end-user. Not a pro guide. It does not focus on DB performance tuning or designing.

Dec 18

Windows 7 and BitLocker Command Line

Posted in Microsoft

This is a quick post relating to Microsoft BitLocker command-line operations. Just showing how to re-initiate the encryption/decryption from a command line.

comments: 0 » tags:
Dec 11

Hyper-V Management with PowerShell

Posted in Microsoft

Windows PowerShell Owner’s Manual can be found HERE

PowerShell Management Library for Hyper-V can be downloaded from HERE

The PowerShell management module for Hyper-V: The EDGE video would be available HERE

Although the PS does not need any intro, but still; the PS is a command line tool which enables you to configure Microsoft software’s. As the PS2 is released many months back; the Hyper-V module updated significantly since it’s first release. The following process walkthrough will show you how to import the module successfully.

1. Now first of all download and extract to an empty directory. Run the “bat” file, install the file and follow the process to import the Hyper-V module in the server manager.

 

 

 

 

 

 

2. Now open up the PS and run the following command into it : “Import-Module hyperv”

But you will be presented with an error stating that the module isn’t available in the module directory

3. And after receiving the error run the following commands:

Set-ExecutionPolicy unrestricted

and after that run the following command:

Import-Module hyperv

and since the hyperv module is imported; now you will be able to issue commands related to managing Hyper-V. Issue the following commands for getting the switches:

Get-Command -Module hyperv

The switches would look like the following picture:

4. The new vm command would be like this:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Some more examples:

Connecting to a VM
New-VMConnectSession

Discovering and manipulating Machine states
Get-VMState , Set-VMState , Convert-VmState, Ping-VM , Test-VMHeartBeat, Shutdown-VM , Start-VM, Stop-VM, Suspend-VM, Get-VMKVP, Add-KVP, Remove-KVP, Get-VMJPEG

Backing up, exporting and snapshotting VMs
Export-VM , Import-VM, Get-VMSnapshot, Choose-VMSnapshot , Apply-VMSnapshot , New-VMSnapshot ,Remove-VMSnapshot, Rename-VMSnapShot, Update-VMSnapshot, Get-VMSnapshotTree, Get-VmBackupScript

Adding and removing VMs, configuring motherboard settings.
New-VM , Remove-VM , Set-VM , Get-VMCPUCount, Set-VMCPUCount, Get-VMMemory, Set-VMMemory, Set-VMSerialPort

Manipulating Disk controllers, drives and disk images
Get-VMDiskController
Add-VMSCSIController , Remove-VMSCSIcontroller
Get-VMDriveByController , Add-VMDRIVE , Remove-VMdrive
Get-VMDiskByDrive, Add-VMDisk , Set-VMDisk, Get-VMDisk
Get-VMFloppyDisk , Add-VMFloppyDisk
Add-VMNewHardDisk

Manipluating Network Interface Cards
Get-VMNic , List-VMNic , Choose-VMNIC, Add-VMNIC, Remove-VMNIC , Set-VMNICAddress , Set-VMNICConnection , Get-VMNicport,
Get-VMNicSwitch, Choose-VMSwitch, New-VMSwitchPort, Get-VMByMACaddress, Choose-VMExternalEthernet,
New-VMExternalSwitch, New-VMInternalSwitch, New-VmPrivateSwitch

Working with VHD files
Get-VHDDefaultPath, Get-VHDInfo, New-VHD, Compact-VHD, Test-VHD,Convert-VHD,Merge-VHD,Mount-VHD, Unmount-VHD

 

Now enjoy!!! and do NOT forget to test these in an R&D environment. NEVER TEST in the production server unless you know what you are doing :D