In addition to creating backups, there are a variety of tasks and functions SQL Server makes available which can both improve the performance and reliability of your databases. We have previously showed you how to backup SQL Server databases with a simple command line script so in the same fashion we are providing a script which will allow you to easily perform common maintenance tasks.
Sometimes working in tech support can be stressful, so a little humor can go a long way towards putting a smile back on your face.
When you get down to it, batch files and executable files work pretty much the same way. Both are simply a set of instructions and logic for Windows execute. So why would you want to convert a batch file to an executable if they essentially work the same? Here are a few reasons:
Are you a blogger? Want to get more out of your WordPress install? Our own writer Matthew is giving away two copies of this ebook at his personal blog.
Outside of email, probably the most common way to send files to a remote party is via FTP. While there are a plethora of FTP clients you can choose from, Windows has an little known and under utilized command line FTP utility built in. The beauty of this tool lies in it’s ability to be scripted which we have harnessed in the batch script below.
Many services and programs out there produce log files as an audit trail for everything they are doing, however few have a function which removes these files as they outlive their usefulness. As a result, these log files sit on your system eating up space (sometimes more than you know) and cluttering directories for those times you need to access them.
Backups are something which, usually, run on a very frequent schedule. If left unmanaged, a direct result of this is a large number files eating up a potentially large amount of hard drive space. Remembering to manually go in and remove backup files certainly is one method of management but shouldn’t be a long term strategy, especially when there are easy to implement automated procedures available.
Virtually all linux distributions include sendmail as the default MTA. Which is okay – it has been around for a long time, is stable and it works great (although the postfix afficionados might disagree!). But it has nothing built in for spam control which is good; it was not designed for that. So you’ve installed spamassassin and it works good but you still are getting unflagged spam emails through. Perhaps you need to try greylisting.
When you’re running production servers, the one thing you don’t want to do is upgrade the kernel every time a new update comes out. Why? Because that’s the only Linux update operation that requires a reboot once it’s done—and in a production environment you often can’t have downtime.
Would you like to make your blog look great on all devices, not just computers? Smartphones and other mobile devices are increasing in popularity, so here’s how you can make sure your blog looks great no matter what people are reading it on.
If you’ve worked in the admin world for any length of time, you’ve probably run into an instance where you needed to change the hostnames on your server to match some corporate naming standard, but you can’t have downtime either. So how do you change the hostname without rebooting?
If you have been an admin for any length of time, you have certainly discovered situations where a server spikes in CPU use or memory utilization and/or load levels. Running `top` won’t always give you the answer, either. So how do you find those sneaky processes that are chewing up your system resources to be able to kill ’em?
A very useful function which is missing from the Windows library of command line tools is the ability to replace text in plain text files. A function like this can be used for a variety of practical tasks which many system admin’s perform, such as:
Ubuntu has an easy way to keep your system clock synchronized with the internet time servers, but sadly it’s not enabled by default. Here’s the quick steps required to enable it for your system.
Common system and/or environmental events such as resuming from standby or losing network connection can cause problems for certain applications which expect to be always on and connected. So if you have a certain application which crashes or goes into “not responding” mode somewhat frequently and a restart is the only fix for it, we have a simple fix for you in the form of a customizable batch script to simply kill the application and restart it.
With any active database, disk storage requirements are going to grow over time. While you can easily view the disk space used by an entire database by either look in the Files page of the database properties in SQL Management Studio or simply viewing the underlying files in Windows Explorer, what if you want to dig a bit deeper and see the parts that comprise the sum of the whole?
If you run a Windows Server which takes advantage of the built in DNS Server, you have a nice graphical interface for viewing and managing your DNS records. However, the vast majority of the time you probably just look at these records as opposed to updating them. This process is not difficult, but can be a hassle as you have to connect to the DNS Server machine through remote desktop, open DNS controls and locate the record. Wouldn’t it be easier if you could simply see this information over the web?
When you have a bunch of end user computers on a network, it is important to be sure files stored locally on the respective computers are backed up in the event of hard drive failure. Maintaining backup programs, configurations and, possibly, support costs on each machine can be a real pain, so as an alternative we have a simple solution: a script which, when run, mirrors local data to a common network location.
Sometimes when your making tweaks to WHS or installing certain Add-Ins, it can make the system unstable. Here we take a look at how to backup the WHS System State and / or Registry so you can restore it if something goes wrong.
There’s a fun trend out there with system administrators setting up funny pages whenever you go to a page on their site that doesn’t exist. This one has a scrolling text that whines and complains.
While there are a myriad of useful applications and utilities which are available via portable distributions, many tools still remain in their “install only” format. This limitation, however, should not discourage you from using the respective program as a portable application. With a few tricks we are going to show you here, you may be able to add these programs to your collection of portable tools yet.
If you’ve ever wanted to adjust the context menu for a file so that you can launch the application as administrator with another utility, here’s the quick registry hack that you can use to do so.
Virtualization has become an incredibly powerful and flexible way to deploy environments. So much in fact that Microsoft has integrated the ability to attach virtual hard drive (VHD) files as physical disks in the Windows Disk Management tool. This process is easy enough to do manually but if you attach VHD files often then we have a solution which enables you to mount and unmount VHD files with a single click.
If you don’t have an extra machine or are an early adopter who wants to test out Vail, creating a VM is a good choice. To complete our series of installing WHS “Vail” Beta virtually, we look at installing it on Oracle’s VirtualBox.
If you try to update certain Windows files (such as programs or word documents) while they are in use, you get the the standard “access denied, file is in use” error. While the reasoning behind this is obvious, it can be quite annoying if you need to update a small executable which is currently in use by another user. In these situations, you have, among others, the following choices, all of which take up your valuable time: