When you try to connect to SQL Server from PowerShell script and you get following message:

Unable to find type [Microsoft.SqlServer.Management.Smo.Server]

then you have to download and install following components:

• Microsoft System CLR Types for SQL Server 2008 R2
• Microsoft SQL Server 2008 R2 Shared Management Objects
• Microsoft Windows PowerShell Extensions for SQL Server 2008 R2

From here.

Handy information during pre-deployment checks/validations.

When you get a message “Your organization’s policies are preventing us from completing this action for you. For more info, please contact your help desk.” it means that you might want to apply this fix to be able to open links in emails:

http://support.microsoft.com/default.aspx?scid=kb;en-us;310049

Same fix applies also to other Office applications (they all might be affected along with Outlook).

By default on Raspberry PI with Raspbian you can enable SSH and connect via text terminal connection.

However, Raspberry PI offers also graphical environment.

How to access Raspberry PI graphical desktop remotely?

Here is how to install RDP server on Raspberry PI with Raspbian…

(more…)

In Skyrim there is room created by Developers which contains all possible items you can find in the game 🙂

To teleport your character to that room use command:

• coc qasmoke from game console

Once you want to leave that place use command:

• coc whiterun from game console

That will teleport you to Whiterun and you can continue game 🙂

Sometimes when you start machine with BitLocker enabled and same time some storage device was connected to USB port, BitLocker might request Recovery Key. This happens because USB ports is listed on boot device search list. To avoid this type of event best idea is to remove USB from boot search list. However, changing list of boot devices might also trigger BitLocker.

How to deal with this type of situation? Follow steps below:

1. Suspend BitLocker  – command: manage-bde -protectors -disable c:
2. Reboot machine
3. Go to BIOS and remove all USB devices from available boot devices list
4. Boot up to Windows
5. Resume BitLocker – command: manage-bde -protectors -enable c:

After that no more issues with BitLocker during startup when USB storage devices are connected.

Sometimes i thappens that SmartConde VNC Manager fails to activate. In that case follow steps below to fix issue with licensing:

1. Open cmd.exe and change directory to:
   • Enterprise Edition: C:\Program Files\SmartCode Solutions\VNC Manager (Enterprise Edition)\
   • Standard Edition: C:\Program Files\SmartCode Solutions\VNC Manager (Standard Edition)\
2. Run the following command: vncmanager.exe /licdev
3. You will be prompted to enter a serial number. You must complete this step. After that the application will close.
4. Start SmartCode VNC Manager normally via the start menu shortcut.

Source: SmartCode Knowledgebase

As there is no GUI in Windows Server 2012 Core, we have to use command line and script in order to acivate system.

slmgr.vbs is a VBscript which allows to set product key and activate operating system. Below most common use of slmgr.vbs.

Set product key

slmgr.vbs /ipk XXXXX-XXXXX-XXXXX-XXXXX

Activate Windows

slmgr.vbs /ato

Display information about licenses

slmgr.vbs /dli
slmgr.vbs /dlv

By default remote management on Windows Server 2012 Core can be blocked by firewall.

In order to enable this functionality, issue following command from Command Prompt window:

Netsh.exe firewall set service remoteadmin enable ALL

Once it’s done you should be able to manage server remotely.