Microsoft SQL Server 2008: Resetting a SQL User Password

Sometimes, you might run into a situation where you need to reset the password for a SQL user account. The process is quite simple and is described below. Step 1: Open an elevated command prompt and run the following command to stop SQL services: NET STOP MSSQLSERVER Step 2: Next, we will need to start [...]

How to set up a transactional replication pull subscription in Windows SQL Server 2008 R2 using SQL commands

In SQL server, replication allows data to be synchronized between two or more databases.  One server acts as a publisher which has a publication subscribed to by servers; the publication specifies what data is to be distributed to the subscriber servers.  In transactional replication, a snapshot of the publication is created on a subscriber server; [...]

How To Configure MISDivision Hosted Lync

Configuring your hosted MISDivision Lync account is easy, simply follow these steps. From your Lync client, click the gear icon and then navigate to tools –> options From here you will see the options menu. Next, click the “Personal” tab on the left and then the “Advanced…” button. This will pop-up Advanced Connection Settings. From [...]

How To Automatically Login to External SharePoint Site

The following steps will allow you to automatically log in to a SharePoint site which does not share your work stations Active Directory domain.

How to set mailboxes to forward and save a copy in Exchange 2010

As an Exchange 2010 administrator a common request is for a mailbox to exist for forwarding purposes, but also to reserve a copy of any received email in the mailbox.

How to manage Usage Quotes in SharePoint 2010

Sharepoint 2010 site collections are assigned Usage Quotas in order to dictate how much disk space and processing power is allocated to a given site. This is useful to allow multiple sites to co-exist on the same server without negatively impacting other sites due to excessive usage.

How to rename a Domain Controller

Today I’m going to show you how to rename a Domain Controller. Before we can rename the DC, we must prepare the server first. You can use this checklist as a guide to make sure your server is ready or copy and paste this link into your browser http://technet.microsoft.com/en-us/library/cc816631(WS.10).aspx. The actual command to rename it [...]

Why does allocating large databases take so long by default with Microsoft SQL?

A common problem which occurs when going to allocate a new database in Microsoft SQL is an extremely long operation which will occur by default due to a disk zeroing operation that is performed when creating a new database. By default this will take a very long time even on the most powerful of database servers.

Run a log purge in Opalis

If you’ve setup Opalis for the first time, after a while, you may notice a slowdown in performance when looking at the policies in the Opalis client.  You may notice, that the process OISClient.exe in the Task Manager takes up an unusually large portion of the CPU when you try to view a policy.  Something [...]