Query for SQL Server Information

by | Oct 1, 2013 | SQL

Have you ever wanted to know basic information about your SQL server?  You can use the SERVERPROPERTY command to retrieve that information with a query. Note that SERVERPROPERTY(ComputerNamePhysicalNetBIOS) will return the Physical Name of the active server.  If you...
Turn off ScreenSaver with Powershell

Turn off ScreenSaver with Powershell

by | Sep 9, 2013 | PowerShell, Windows

Turning off the screensaver can be done by using PowerShell to change three registry settings. You can check your current settings in your registry at this location: HKEY Current User\Software\Policies\Microsoft\Windows\Control Panel\Desktop  Run this code in...

PowerShell Group Membership to CSV file

by | Aug 21, 2013 | PowerShell

I love the new PowerShell 3.0 Active Directory commands.  I find that I rarely need to use 3rd party cmdlets anymore. Today I was tasked with pulling group membership from a specific group in Active Directory and exporting specific data on each group member to a CSV...
Restart Windows 8 from your Desktop

Restart Windows 8 from your Desktop

by | Aug 13, 2013 | Windows

You can make Windows 8 logoff, shutdown or restart as easily as did other versions of windows in the past.  All you need are shortcuts that run the shutdown.exe command with the right parameters. Right-click your desktop and select New Shortcut.       Either type or...