How to find dependencies of stored procedures in SQL Server
Manually reviewing hundreds of stored procedures is time consuming. The sp_depends system stored procedure doesn’t always give proper / correct results when the object creation order is different or following deferred name resolution. The output below for the stored procedure…
Read more »Determine free space for MS SQL Server databases
There isn’t a single command that gives you all the information. sp_helpdb This procedure will give you the total size of the database and associate files. It doesn’t tell you how much free space there is sp_spaceused This…
Read more »How to find your WordPress version
It’s essential to keep your WordPress site secure. How do you check which version of WordPress you are using? There are a couple of methods. 1) WordPress Admin Dashboard Log in to your WordPress admin area and go…
Read more »Connecting to a Dell server via iDRAC 6
Due to increased security in browsers and Java this isn’t trivial. Java only provide version 8. Java 7 is no longer available to the public (old installers can be found). I find it’s useful to keep a machine…
Read more »How to manually uninstall LogMeIn
Uninstalling LogMeIn using “Control Panel > Add or Remove Programs” prompted the Windows installer to ask for LMI23020.msi. Before trying a manual uninstall, try uninstalling via the command line. Command Line Uninstall Open the command prompt (run as…
Read more »Find all files modified after specified date
PowerShell is a powerful scripting tool included in Windows 7 / Windows Server 2008 R2 and all other subsequent Windows operating systems. Why? You can’t do everything from the GUI. For example, the Exchange GUI is designed to be used…
Read more »Windows Path Length Limitation (260 characters)
Windows defines the maximum length for a path at 260 characters. You can mount a folder as a drive, or use symbolic links, to create a shorter path length, although I prefer to identify all offending file names…
Read more »