How to backup virtual machine with Hyper-V

Backing up servers has never been easy, but at least in the past you could say that the process was trivial. These days though, with the introduction of virtualization into server environments, ...

SQL Azure Performance – Query Optimization

SQL Azure Performance Tuning is a much tougher task than SQL Server, – SQL Azure lacks some of the basic tools available to SQL Server DBA’s. There really isn’t too much to do ...

SQL Server Index Maintenance Performance Tuning for Large Tables

Problem When using transactional replication to replicate data in a one way topology from a publisher to a read-only subscriber(s) there is no need to manage identity ranges. However, ...

How to Use Policy Based Management to Implement Database Settings

Introduction Database Administrators have always had a tough time to ensuring that all the SQL Servers administered by them are configured according to the policies and standards of ...

How to add a Column to a SQL Server Table

Adding a column to a table is  common task for  DBAs. You can add a column to a table which is a nullable column or which has default values. But are these two operations are similar ...

How to troubleshoot non-delivery reports in the Exchange Queue

Your Exchange Server mail queue contains all outgoing email messages that are intended for delivery outside of your server. All messages are held as files in a directory as configured ...

How to Optimize Windows 7 Performance

Microsoft Windows 7 comes with a significant performance improvement than his predecessor Windows Vista, but if you want to get from it the best performance you should tweak it a bit ...