By default, it is not possible to specify passwords (the SecureString type) directly as a plain-text cmdlet parameter because it is unsecure to do so (and they are right). But sometimes, there's no other way to run a cmdlet without specifying the password as plain text as a cmdlet parameter. Luckily, there's an easy workaround by performing a conversion from plain text and store the password in a SecureString object.
$pw = ConvertTo-SecureString -String "your-pw" -AsPlainText -Force
You can then use the $pw object to specify the password in a cmdlet.
For example: resetting the password of an AD account:
Set-ADAccountPassword -Identity my-account -NewPassword $pw
If, when attempting to start SQL Server instance, you get an error 1814, this means there's a problem with the tempdb database. Either it can't be created because the disk or volume is not accessible for writing (i.e. a security permission problem), or the volume on which the tempdb resides does not have enough space available. If the latter is the problem, you'll need at least 2 MB of free space for tempdb to be created.
You can retrieve a list of stored procedures in a SQL Server database through T-SQL by querying the built-in information_schema partition.
SELECT * FROM db_name.information_schema.routines WHERE routine_type = 'PROCEDURE'
Replace db_name with the name of the database you wish to retrieve the list of stored procedures. You can adjust the WHERE-clause even more to get a more narrow list.
You can also do this with the master database which will return all (system and non-system) stored procedures.
You can hide user accounts from the Windows Welcome (log on) screen through the registry. This works with Vista and all later versions.
Probably MSSQL 101, but this is how to quickly retrieve the structure of a table:
EXEC sp_help tbl_name GO
tbl_name is the name of the table.
If you accidentally have misplaced or forgotten your Bitlocker Recovery key, but still have access to the system (with an elevated account), you can retrieve the recovery key quite easily through the command line:
Open an elevated command prompt and type:
manage-bde -protectors -get C:
Replace C: with any drive that has Bitlocker enabled. Note that if it's not the system volume but some other drive that's encrypted, you need to unlock it first before you can retrieve the recovery key.
You may have noticed that running the VMWare vSphere client on a display with higher DPI settings causes problems with the mouse cursor alignment when working inside a VM. This is because of a mismatch between the DPI settings of the VM and the DPI settings of your computer.
To resolve, right-click the shortcut to the client, go to the Compatibility tab, and enable Disable display scaling on high DPI settings.
The downside of this method is that there will be misalignment of some parts in the client, but it is still workable and moreover, it solves the mouse issue in a VM.
If Windows Update (or Microsoft Update) produces error code 0x80072EFD, you are most likely blocked by a firewall or a proxy.