You can determine if any SQL Enterprise version features are in use in a database by checking the sku features table. This query lists all edition-specific features that are enabled in the current database SELECT feature_name FROM sys.dm_db_persisted_sku_features ; … Continue reading
PowerShell makes it easy to check if a string is null or empty. You use if (string) else. Setting your string variable to $null gives you an empty string: $mystringvar = $null if ($mystringvar) { “It is empty” } else { … Continue reading
These tasks I do for every Windows 2012 server that I setup. 1) Change the time zone 2) Enable remote management 3) Enable remote desktop 4) Turn off Windows Firewall 5) Verify the time is correct 6) Give server a descriptive name … Continue reading
You can add Active Directory commands to PowerShell on a Windows 7 or Windows 8 workstation by adding the Remote Management Tools. Use one of these links to install the PowerShell Active Directory module for your client. Remote server administration … Continue reading