SQL Query – Find numbers with more than two decimal places
As a database administrator one simple health check you can perform on the information in the database is that dollars are being saved correctly to two decimal places. Quite often…
Server Side Tips
Server 2008 – Export Active Directory users to excel
The following command can be used to extract a complete list of users objects in your Active Directory environment. csvde -f C:\ADUsers.csv -r objectClass=user To run open the PowerShell…
SQL Management Studio – How to create read only users
The following steps detail how to create a read-only user for an SQL database using Microsoft SQL Server Management Studio. This may be helpful if you need to give access…
SQL Management Studio – Change ‘Select Rows’ and ‘Edit Rows’ Amount
When using SQL Management Studio you can right-click on a database table or view and select or edit, however by default it restricts the number of records. This would be…
Server 2008 – Delegate Print Management Role
The following steps detail how to delegate the print server management role on Microsoft Windows Server 2008 R2. This process is only necessary when the user is not an administrator…
Server 2008 – Files missing inherited security permissions
Problem: When attempting to move or edit an existing document from a shared directory you get an 'File Access Denied' message. When you check the security permissions for the file…
Server 2008 – Find users with expired passwords
Previous versions of Active Directory allowed administrators to check if a user account had an expired password.This was done by installing a non-standard dll called acctinfo.dll which gave you an…
VMware ESXi 5 – How to add a new storage datastore
This article will go through the process of adding a new storage datastore to a VMWare ESXi 5 host using VMware vSphere. Please note: In this example the VMWare ESXi…
VMware ESXi 5 – How to install, configure network and license
This article will go through the process of doing the initial VMWARE ESXi 5 installation. System Requirements: A computer system with a 64-bit processor 2GB RAM or more Storage area…