Debian 8 initial server setup (SSH, users & firewall)
When you create a new Debian 8 server, there are a few steps required as part of the basic setup. 1) Install SSH (if not already configured) You can use the package manager for Debian / Ubuntu via…
Read more »Visual Studio Windows desktop application (Visual C++) LNK2019 error
How to replicate. Work through Microsoft’s walk-through to create a traditional Windows Desktop application (C++) Go to File –> New –> Project Select Visual C++ –> Windows Desktop –> Windows Desktop Wizard Give the project a suitable name,…
Read more »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 »Using the Virtual Media function on a Dell iDRAC 6
The virtual media function of the integrated Dell Remote Access Controller is a useful feature. It gives you the option to mount ISOs and boot to them during the POST. ISO files can be used for installing operating systems…
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 »Linux (Debian) network configuration
This post covers configuration changes required to set a static IP address on a server / desktop. First get information about all the interfaces in the system with the command ifconfig -a . Network configuration. Assign an address, netmask, gateway…
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 determine RAID controller type in Linux
Most servers are equipped with RAID. There are two main types of RAID: software or hardware. Software RAID If you’re not sure what configuration is used, check in the /proc/mdstat file. The /proc is area used by the kernel for keeping various…
Read more »Kali Linux from USB installtion fails to find CD-ROM
ISO: Kali Linux Light 2018.3 i386 (32 bit) When booting from USB the installer starts (live works) but then prompts for the CD with the error “can’t mount and detect CD-ROM drives” If using Rufus to burn the…
Read more »