Category Archives: Windows

Windows & Microsoft related topics

Quickly test Windows-auth logon to a SQL DB as a different user

If you need to make a test connection to a MS SQL DB as a different Windows user, and you’re not using SQL authentication, you can do the following: runas /user:domain\sqluser “C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe” You’ll then see the following … Continue reading

Posted in SysAdmin, Windows | Leave a comment

Self-sign your Powershell scripts

Creating my first Powershell script, I came up against code execution issues. Rather than take the easy (sketchy) way out and simply enable execution of unsigned code, I went and figured out how to sign my scripts using my internal … Continue reading

Posted in Scripting, SysAdmin | Leave a comment

Managing Local Admins using GPP

This is a brain dump of something Alan Burchill and Lilia Gutnik presented at TechEd Australia 2009. It covers managing local administrators on your workstations using the power of Group Policy Preferences. Create a new GPO if necessary, link it … Continue reading

Posted in SysAdmin, Windows | Leave a comment

Enabling Remote Desktop (RDP) on Windows Vista Home Premium

Thanks to the guys at The Green Button forums, Vista Home Premium users can now also enjoy an oft-missed feature; RDP. This currently works with SP1, but SP2 isn’t far off so expect Microsoft to close this loophole again. Below … Continue reading

Posted in Windows | Leave a comment

Mini Brain Dump: IP Subnet Change Considerations

I’ve been sitting on this post for a long time, and intended to write a more detailed description. Here are some things you may need to consider (outside of the obvious like DHCP scopes, DNS server settings, Firewall settings & … Continue reading

Posted in SysAdmin, Windows | Leave a comment