Once in awhile I meet an sql based program that won’t work or stop respond to client requests until I flush the SQL database log file.
I wanted to create a script so I can run it through the scheduled tasks and get rid of this annoying task.

This is what I needed to do:
To shrink SQL log file on a scheduled base I did the following:
create a text file and change the extension to sql (Example: Shrink_log.sql)
add this lines to the script file: READ MORE »

Over the years, computers are replaced or decommissioned from the network but computers accounts in active directory are not deleted automatically and become obsolete.

Tracing these accounts in the past wasn’t an easy task.

To trace these accounts in the directory the easyest way is to search the computers that have not been logged in to the network in a given time interval. READ MORE »

Here is a script, to log user logins in the local network trough the logon script.

The output is saved in a CSV file format and stored in a network share.

It’s a simple batch file with basic functions. It can be used in various situations to keep track of the computers the user’s login to and work with, or just to gather information and create statistics about the login behavior of the users. READ MORE »

When we need to relocate a DHCP service on to a new server with a lot of IP reservation and scopes, the easiest way to achieve it is by using the netsh command to export the DHCP settings to a txt file and than import them to the new server. READ MORE »

There are times when I need to “terminate” a process on one of my servers.

Usually the simple way is to do RDP to the server and “kill” the process in the task manager.

The problem begins when I need to perform this task again and again, which can be very annoying, so then I start to look for shortcuts. READ MORE »