Top Articles

Migrate Small Business Server 2003 to Exchange 2010 and Windows 2008 R2

demazter04/16/2010, 12:00 AM

This guide is intended to provide step by step instructions on how to migrate from Small Business Server 2003 to Windows 2008 R2 with Exchange 2010. For this migration to work you will need the following software: Windows Small Business Server

Topic: Exchange Email ServerTags: Exchange 2010 Migration, SBS2003, Small Business Server 2003, migration to Exchange 2010

Views: 84328Comments: 249

SCCM OSD Basic troubleshooting

HayesJupe07/30/2009, 12:00 AM

SCCM 2007 OSD is a fantastic way to deploy operating systems, however, like most things SCCM issues can sometimes be difficult to resolve due to the sheer volume of logs to sift through and the dispersed nature of the blog posts that deal with some

Topic: MS System CenterTags: SCCM, OSD, Task Sequence, Operating System Deployment

Views: 69086Comments: 17

Outlook continually prompting for username and password

demazter01/20/2010, 12:00 AM

There have been a lot of questions recently regarding Outlook prompting for a username and password whilst using Exchange 2007. There are a few reasons why this would happen and I will try to cover the most common ones here. Exchange 2007 Service

Topic: Exchange Email ServerTags: Outlook prompting, autodiscover, exchange, autodiscover.domainname.com

Views: 67063Comments: 67

Backup Exchange 2010 Information Store using Windows Backup

demazter02/12/2010, 12:00 AM

There seems to be quite a lot of confusion around the ability to backup Exchange 2010 using the built in Windows Backup feature.  This stems from the omission of this feature prior to Exchange 2007 service Pack 2 Exchange 2010 includes a plug-in

Topic: Exchange Email ServerTags: Exchange 2010, backup

Views: 50552Comments: 42

Exchange 2003 - Activesync Connection Problems FAQ

alanhardisty10/19/2009, 12:00 AM

On numerous occasions I was seeing questions pop up that involved Exchange 2003 and problems getting iPhones / Windows Mobile phones and now more recently, iPads, to work with Activesync, so after answering several questions, I decided to write the

Topic: Exchange Email ServerTags: Exchange 2003, Activesync, iPhone, Windows Mobile

Views: 44570Comments: 232

Windows 7 Sysprep

ivanoviola05/15/2010, 12:00 AM

I've spent numerous hours getting the sysprep right for Windows 7 images for my organization. I'll share what I've learned to make the process easier. Files you will need: WAIK for Windows (Windows Automated Installation Kit) installed on a co

Topic: Windows 7Tags: Windows 7, Sysprep, Unattend.xml

Views: 35303Comments: 128

Exchange 2007/2010 Web services and Autodiscover Ultimate Troubleshooting Guide

busbar04/30/2010, 12:00 AM

Hi, during my online activities I can see that Exchange 2007/2010 web services are causing a lot of issues to people, and lots are suffering from it. I decided to put this ultimate guide to spare the hustle and allow smoother and nicer web services

Topic: Exchange Email ServerTags:

Views: 29119Comments: 6

Configure Exchange 2007 or 2010 to relay email for an additional domain.

demazter02/26/2010, 12:00 AM

The most common request is how to configure Exchange Server to receive and deliver mail for an additional domain name.  This could be because of a company merger, a change in name or you could simply be hosting multiple domains within a single Excha

Topic: Exchange Email ServerTags: Exchange 2007, Exchange 2010, addtitional domain, relay

Views: 28556Comments: 14

Configure a shared mailbox in Exchange 2010

demazter06/07/2010, 12:00 AM

We see 3 or 4 requests every day for how to configure a shared mailbox.  Now that Exchange 2010 is growing in uptake, more of those requests are for this facility in Exchange 2010.  With Exchange 2010 the process has slightly changed, for the better

Topic: Exchange Email ServerTags: exchange 2010, shared mailbox

Views: 26671Comments: 16

Add a Delete Button to the Windows 7 Explorer Toolbar

DanRollins12/30/2009, 12:00 AM

This article describes how to add a Delete button to the Windows 7 Explorer toolbar.  In the followup article, we'll see how to add your own custom buttons to that Win7 toolbar. With Win7, if you want to delete a file, you can drag it to the Recy

Topic: Windows 7Tags: Win7, Explorer toolbar, FolderTypes, command bar, Delete button, RegEdit, registry, 5c4f28b5, Dan Rollins

Views: 26489Comments: 7

Windows 7 and the Samsung NC10 netbook

tigermatt10/25/2009, 12:00 AM

by Matt Huxtable (tigermatt) As part of the hype surrounding the Windows 7 release last Thursday, one of the lesser promoted aspects of the new Operating System is the improved support for netbooks. These machines are becoming increasingly popula

Topic: Windows 7Tags: Microsoft, Windows 7, Samsung, NC10, netbook, drivers, performance

Views: 25164Comments: 9

How to DELETE Windows Local & Domain Cached Credentials

ashwynr02/08/2009, 12:00 AM

Hallo! I guess almost every Windows Administrator must have got stumped with this question "Where does WINDOWS store a users cached credentials? Every user who had once logged onto a Server/Desktop while it was connected to the domain could sti

Topic: Microsoft Operating SystemsTags: Cached, Credentials, Windows, Registry, NL$, Domain Cached Credentials

Views: 24422Comments: 3

Activesync Working But Only For Some Users On Exchange 2007 / 2010

alanhardisty04/13/2010, 12:00 AM

There are some issues with ActiveSync for both Exchange 2007 and Exchange 2010 users whereby some users can connect their Mobile Devices (Windows Mobile Phones / iPhones / Motorola Droid etc) quite happily and ActiveSync pushes mail to the devices,

Topic: Exchange Email ServerTags: Activesync, Exchange, 2007, 2010, Exchange 2007, Exchange 2010, iphone, droid, AdminSDHolder, SDPROP, EAS

Views: 22157Comments: 36

Pie Chart Techniques

ValentinoV10/29/2009, 12:00 AM

Written by Valentino Vranken. A while ago I wrote an article called Chart Optimization Tips.  This article explained how to optimize a Column Chart.  Today I have returned to show you some Pie Chart implementation techniques. As usual, I will

Topic: MS SQL ReportingTags: SSRS, SQL Server Reporting Services 2008, pie chart, reporting services, charting

Views: 21870Comments: 12

Reset HP servers ILO password remotely WITHOUT rebooting the server (Windows 2003 / 2008)

ashwynr06/02/2009, 12:00 AM

The HP utility "HP Lights-Out Online Configuration Utility for Windows Server 2003/2008" could be of great use when it comes to remotely configure a HP servers ILO WITHOUT rebooting the server. We would only need to create and run scripts using thi

Topic: Windows 2003 ServerTags: Reset, ILO, Password, HP Server, Windows 2003, Windows 2008, HPONCFG

Views: 21450Comments: 9

Importing PST files in to Exchange 2010

demazter03/22/2010, 12:00 AM

Importing PST’s in to Exchange 2010 is a lot easier than it was in 2007 due to the Role Based Access Control (RBAC) feature. Before we can import PST’s to Exchange 2010 there are a few pre-requisites and they are: You must have the x64 version

Topic: Exchange Email ServerTags: import-mailbox, get-mailbox, exchange 2010 mailbox import, import pst

Views: 20393Comments: 30

Mailbox Recovery Exchange 2010

demazter04/27/2010, 12:00 AM

In previous versions of Exchange Server, we had the recovery storage group, or RSG, which allowed us to restore a copy of the EDB file associated with the Mailbox Database and recover individual mailboxes or mail/calendar/contact items. In Exchan

Topic: Exchange Email ServerTags: recovery database, RSG, Exchange 2010, recover mailbox, restore-mailbox, backup, restore

Views: 19567Comments: 11

Hyper-V Network Card not working

dariusg05/14/2009, 12:00 AM

Hyper-v Network Card not working There are two common mistakes that people make when they setup a Hyper-V VM. First problem is that they don't install the integration components before they start troubleshooting problems with the Hyper-V VM fu

Topic: Hyper-VTags:

Views: 18598Comments: 2

Why you shouldn't use PST files

tigermatt10/24/2009, 12:00 AM

by Matt Huxtable (tigermatt) They have been around for years and for thousands of Microsoft Outlook users and email administrators out there, they'd be lost without them: Personal Storage Table (PST) files. If you've worked with Outlook for very

Topic: Exchange Email ServerTags: Microsoft, Outlook, Exchange, PST, database, personal folders file, personal storage table

Views: 17963Comments: 64

Understanding Group Policy Loopback Processing

Arenar10/28/2009, 12:00 AM

A Little on Standard Group policy Processing Before we look at how loopback processing works it may be beneficial to have a quick refresh on how standard group policy processing works. Group Policy Objects (GPO) are a collection of configurable

Topic: Active DirectoryTags: AD, Active Directory, GPO, Group Policy, Loopback

Views: 17070Comments: 11

Migrate Small Business Server 2003 to Small Business Server 2011

demazter12/19/2010, 12:00 AM

This guide is intended to provide step by step instructions on how to migrate from Small Business Server 2003 to Small Business Server 2011. NOTE: This guide has been written using the preview version of SBS2011 therefore some of the screens may

Topic: SBS Small Business ServerTags: SBS, migrate, SBS2003, SBS2011, SBS7

Views: 17017Comments: 67

Windows Server Backup in Windows Server 2008 R2

tigermatt07/26/2009, 12:00 AM

The upcoming Windows Server 2008 R2 has a wealth of new features and improvements over the original 2008 release. One such improvement is in the built-in backup tool, Windows Server Backup. Some History of Server Backup In the early Windows 2

Topic: Windows Server 2008Tags: Windows Server Backup, Server 2008 R2, Backup Technology

Views: 16631Comments: 6

Forward Email to External Email Address - Exchange 2003

tigermatt11/21/2008, 12:00 AM

Sometimes, having the ability for a user to forward their email to another user in the organization, or indeed outside the network, is important. Ignoring the legal issues of having company information immediately forwarded to another user, the proc

Topic: Exchange Email ServerTags: Microsoft, Exchange 2003, email forwarding

Views: 16309Comments: 30

Using the Dictionary Class in VBA

matthewspatrick07/13/2010, 12:00 AM

Introduction Perhaps more familiar to developers who primarily use VBScript than to developers who tend to work only with Microsoft Office and Visual Basic for Applications (VBA), the Dictionary is a powerful and versatile class, and is useful

Topic: Microsoft Office SuiteTags: Dictionary, Scripting, Microsoft, Visual Basic, Visual Basic for Applications, VB, VBA, Scripting Runtime, Excel, Access, Word, Office

Views: 15784Comments: 26

How To Resolve "An attempt was made to reference a token that does not exist" on an IIS 5 server

Tray89606/21/2009, 12:00 AM

Here are the symptoms: You start receiving calls from users that one of your legacy web apps isn't coming up, so you log into your IIS 5 server to check it out.  When you pull up the services, you notice that the WWW Publishing service isn't runn

Topic: Microsoft IIS Web ServerTags: IIS

Views: 15765Comments: 2

Median, Mode, Skewness, and Kurtosis in MS Access

matthewspatrick02/24/2010, 12:00 AM

by Patrick G. Matthews Introduction Like other database applications, Access provides support for computing basic descriptive statistics for a data set, offering such aggregate functions as Count, Sum, Min, Max, standard deviation and variance

Topic: Microsoft Access DatabaseTags: Microsoft, Access, Statistics, Mean, Median, Mode, Standard Deviation, Skewness, Kurtosis, Sampling, Visual Basic, Visual Basic for Applications, VBA

Views: 15728Comments: 23

Replace a Windows Server 2003 Domain Controller

tigermatt11/21/2008, 12:00 AM

It is a known fact that servers reach the end of their lives. Some get there quicker than others, based on age, manufacturer, usage and several other factors. However, if your organization has spent time deploying Microsoft's Active Directory server

Topic: Windows 2003 ServerTags: Microsoft, Windows, Server 2003, R2, non-R2, domain controller, active directory, replace

Views: 15693Comments: 9

Your First OLAP Report

ValentinoV01/24/2010, 12:00 AM

This article is aimed at report developers who are used to developing reports using relational databases and have gotten a first-time assignment to develop reports on OLAP cubes. It demonstrates how to build a report using SQL Server Reporting

Topic: MS SQL ReportingTags: SSRS, SQL Server, Reporting Services, mdx, olap, SSAS, Analysis Services, cube

Views: 15583Comments: 12

Retrieving Data From Excel Using OPENROWSET()

ValentinoV05/04/2010, 12:00 AM

The purpose of this article is to demonstrate how to retrieve data from an Excel sheet and put it in a table in a SQL Server database. Introduction Anyone who's ever used a computer for a significant amount of time has probably come into contact

Topic: MS SQL ServerTags: import Excel, openrowset, SQL Server, SQL

Views: 15468Comments: 6

QuickLaunch Toolbar for Windows 7

DanRollins01/25/2010, 12:00 AM

Coming to Win7 from XP, you might wonder where the QuickLaunch toolbar went.  This article describes how to get back that "QuickLaunch" functionality. First, be aware of the Win7 idea of pinning programs to the Taskbar; that feature provides some

Topic: Windows 7Tags: Win7, Taskbar, quicklaunch, Explorer toolbar, New Toolbar, Explorer bar, Dan Rollins

Views: 15341Comments: 15

Extending Outlook Rules via Scripting

BlueDevilFan01/18/2009, 12:00 AM

Scenario.  Outlook rules are a great way to automate message processing.  Using rules you can organize your messages, forward or reply to messages automatically, display custom message alerts, set reminders, and more.  Unfortunately, rules have two

Topic: Outlook Groupware SoftwareTags: Microsoft, Office, Outlook, VBA, Macro, Rules

Views: 15193Comments: 2

MFC Feature Pack for VS 2008 and 2010

DanRollins12/19/2009, 12:00 AM

In this article, I'll describe -- and show pictures of -- some of the significant additions that have been made available to programmers in the MFC Feature Pack for Visual C++ 2008.  These same feature are in the MFC libraries that come with Visual

Topic: Windows MFC ProgrammingTags: VC++, Visual Studio, MFC Feature Pack, Win7, CMFCMaskedEdit, CMFCMenubar, CMFCButton, CMFCFontComboBox, Tear-off menus, Dan Rollins

Views: 15030Comments: 7

Keyboard Remapping: CAPSLOCK to Ctrl and Beyond

DanRollins12/27/2009, 12:00 AM

In this article, I'll describe how to make registry changes that will remap low-level keyboard scancodes and I'll also show you how to set/change the functions of the extended-function buttons and controls that may be on your keyboard. Background

Topic: Microsoft Windows Operating SystemsTags: Scancode Map, registry, keyboard, WM_APPCOMMAND, Flip3D, 3dFlip, Win7, Vista, dwmApi

Views: 14957Comments: 28

Step by Step guide on how to install Exchange Server 2010 - Part 1: Install

adiloadilo04/05/2010, 12:00 AM

Step by Step guide on how to install Exchange Server 2010- Part 1: Install April 8, 2010 by adiloadilo Introduction It has been a long time since; I wrote an article or a tutorial for any Microsoft products. I noticed that exchange 2010 is out

Topic: Exchange Email ServerTags: Single Exchange 2010 install

Views: 14620Comments: 25

Free Up Disk Space On Your C: Drive

ValentinoV02/10/2010, 12:00 AM

Introduction Running out of space on the C: drive of your Windows XP machine and no budget for a new PC?  Then this article is for you! Even though this article was written for Windows XP, I believe the tips should also be applicable to any othe

Topic: Windows XP Operating SystemTags: cleanup, disk space, free up, windows, out of space

Views: 14542Comments: 23

AjaxControlToolkit’ TabContainer control’ Javascript functions.

sand198002/25/2010, 12:00 AM

In this blog we will start with a common requirement for the tab container control i.e. setting focus to a tab using javascript and later at the end of this blog we will also see some important javascript functions available with ASP.NET AJAX Tab Co

Topic: Programming for ASP.NETTags: ASP.NET AJAX, TabConainer, ASP.NET

Views: 14411Comments: 0

Solution for Windows 7RC - Remote Server Admin Tools and Exchange Management Tools

WC_TSA06/09/2009, 12:00 AM

  With the introduction and testing of the newest Windows OS from Microsoft, system administrators are actively seeking ways to remotely manage their servers and networks.  In order for this to take place administrators have to resort to several dif

Topic: Windows 7Tags: Windows 7, Server 2003, Exchange Server 2003

Views: 14367Comments: 12

Outlook 2007 error in EMSMDB32.DLL when performing search

BrainPicker01/13/2011, 12:00 AM

Today I have discovered the solution to a problem that began yesterday. Some of our client computers running Office Outlook 2007 (connecting to Exchange 2007) started crashing, when performing a search on any folder. The error would crash Outl

Topic: Outlook Groupware SoftwareTags: KB2412171 Outlook 2007 EMSMDB32.DLL error crash Windows XP

Views: 13921Comments: 26

Exchange DNS Configuration

demazter02/01/2010, 12:00 AM

I have seen a number of questions over the past few months regarding DNS configuration for an Exchange Server. Incorrectly configured DNS can cause your server to be rejected by receiving servers that are performing certain types of checks on the ma

Topic: Exchange Email ServerTags: MX, Exchange, DNS

Views: 13842Comments: 27

Dual Monitor and Remote Desktop

tigermatt11/22/2008, 12:00 AM

Having a dual- or triple-monitor configuration does a lot to boost your productivity, but what about when you want to connect to a Terminal Services session? By default, a Terminal Services screen can either be configured to fill your screen, or to

Topic: Remote Desktop/Terminal ServicesTags: Microsoft, Remote Desktop Connection, Terminal Services, Dual Monitor Configuration, Multiple Monitors

Views: 13536Comments: 11

Calculating Distinct Counts in Access

matthewspatrick02/08/2010, 12:00 AM

by Patrick G. Matthews All major SQL dialects allow for a Count aggregate function, and Access's native Jet SQL is no exception.  As in other database platforms, Access's Count() (as well as the "domain aggregate" DCount()) function returns t

Topic: Microsoft Access DatabaseTags: Access, Query, Queries, SQL, Distinct, Count, Distinct Count, VBA, Visual Basic, Aggregate, Domain Aggregate

Views: 13412Comments: 18

How to Split a String with Multiple Delimiters in VBA

alainbryden09/08/2009, 12:00 AM

This Article This Article discusses tips for extending the functionality of the VB 6.0 and VBA Split() function, described here. We will introduce a quick and easy enhancement function, as well as a more extensive function which provides some much

Topic: Microsoft Office SuiteTags: VB, VBA, Split, Multiple, Consecutive, Delimiters, String, Array, Formula, Excel, Access, Word, Microsoft

Views: 12973Comments: 35

A VBA Progress Bar for Excel and Other Microsoft Apps.

alainbryden10/13/2009, 12:00 AM

Keeping the user informed is important If you have written some VBA code for Excel (or Word, or Access), and it takes a long time to execute, it is important to keep the user informed that the code is progressing. Psychologically, it can also have

Topic: Microsoft Excel Spreadsheet SoftwareTags: Excel, VBA, Automation, Progress Bar, Cancel Button, Time Elapsed

Views: 12894Comments: 19

Six Reasons Why Your VLOOKUP or HLOOKUP Formula Does Not Work

matthewspatrick03/09/2010, 12:00 AM

by Patrick G. Matthews Introduction VLOOKUP is a tremendously useful function that allows you to "fetch" data from a specified rectangular range (the "lookup table"); this range can be on the same worksheet, a different worksheet in the sa

Topic: Microsoft Excel Spreadsheet SoftwareTags: Microsoft, Excel, VLOOKUP, HLOOKUP, function, formula, #N/A, N/A, error

Views: 12724Comments: 35

How to Remove a Failed Domain Controller

mkbean05/22/2009, 12:00 AM

One of the tasks that every Active Directory administrator has to learn is how to remove a failed or offline Domain Controller (DC) from the environment.  The easiest method is to use DCPROMO, however if the DC is already offline or had a catastro

Topic: Active DirectoryTags: Active Directory, DCPROMO, NTDSUTIL, Domain Controller

Views: 12557Comments: 6

Migrating Printers from Server 2003 x32 to Server 2008 R2 x64

jjdurrant07/01/2010, 12:00 AM

This article is the step-by-step process from migrating printers from Windows Server 2003 to Windows Server 2008 R2 x64 using the Printer Migration Wizard. If you are migrating Windows 2000 Server to Windows Server 2003, you must use Print Migrator

Topic: Windows Server 2008Tags: Printer, Server, Migrate, 2003, 2008, R2

Views: 12515Comments: 5

Automatically Printing/Saving Emails/Attachments in Outlook

BlueDevilFan04/22/2010, 12:00 AM

Automatically Printing/Saving Emails/Attachments in Outlook Issue.  One of the more frequent Outlook questions I see here on EE is "How can I automatically save or print an email and/or its attachments?"  There are a number of variations to the b

Topic: Outlook Groupware SoftwareTags: Outlook, macro, message, attachment, print, save

Views: 11997Comments: 50

ASP.NET : Mobile Device Detection and Redirection

amimpat01/19/2010, 12:00 AM

This article explains approaches for ASP.NET mobile development to determine if an HTTP request is coming from a mobile phone and then redirecting the request to a page optimized for a mobile browser. Examples in below article are in c#.net Me

Topic: Programming for ASP.NETTags: ASP.NET, Device Detection, Browser Detection, ASP.NET Mobile, Mobile Web

Views: 11867Comments: 34

Importing and Exporting Outlook 2007 Categories

BlueDevilFan05/31/2009, 12:00 AM

Issue.  "How do I copy my categories to another computer?" and "How can I share a set of categories with a group?" are two of the more frequent category related questions I see here on Experts-Exchange.  The answer is that Microsoft, unfortunately,

Topic: Outlook Groupware SoftwareTags: Outlook 2007, Categories, Import, Export, Share

Views: 11850Comments: 34

Unable to remove Exchange 2007 because of Public Folder Replica.

Exchange_Geek11/21/2008, 12:00 AM

1) While uninstalling Exchange server, an error was shown in Exchange setup logs.  Checking whether the public folder database "Server Name\Storage Group Name\Public Folder Database" has local replicas.   Unexpected Error  The public folder dat

Topic: Exchange Email ServerTags: Microsoft Exchange 2007, Setup

Views: 11706Comments: 2

Use AJAX ModalPopupExtender in GridView or other data controls

prairiedog04/08/2009, 12:00 AM

AJAX ModalPopupExtender has a required property "TargetControlID" which may seem to be very confusing to new users. It means the server control that will be extended by the ModalPopup, for instance, if when you click a button, a ModalPopup displays,

Topic: Programming for ASP.NETTags: ASP.NET, AJAX ModalPopupExtender

Views: 11657Comments: 2

Migrate Windows 2003 with Exchange to Small Business Server 2008

demazter02/16/2010, 12:00 AM

This guide is intended for migrating Windows 2003 Standard with Exchange 2003 to Windows Small Business Server 2008. You will need the following: Exchange Best Practice Analyzer: ...

Topic: SBS Small Business ServerTags: Exchange 2003, Migrate, SBS 2008

Views: 11550Comments: 29

Playing with Time Conversion in Excel

saurabh72611/20/2008, 12:00 AM

Lot of times in Excel we have to do quick time conversion that is...The time is given in Time format which is -->12:00:00 and we need to convert it into a number format that is -->12 A quick multipication of same by 24 will convert it to the

Topic: Microsoft Excel Spreadsheet SoftwareTags: Excel Time Conversion

Views: 10393Comments: 7

Export mailboxes using Exmerge and Exchange 2003

demazter03/22/2010, 12:00 AM

There could be many reasons why you would want to export mail directly from the Exchange Mailbox Store.  You may be migrating to a hosted solution, you could be moving to a different Exchange organisation or you may simply be using Exmerge as a way

Topic: Exchange Email ServerTags: exmerge, export mailbox, import mailbox, exchange 2003

Views: 10390Comments: 15

Adding an Else to your Switch

ValentinoV01/16/2010, 12:00 AM

In this short article I will be talking about two functions in the SQL Server Reporting Services (SSRS) function stack.  Those functions are IIF() and Switch().  And I'll be showing you how easy it is to add an Else part to the Switch function. T

Topic: MS SQL ReportingTags: Reporting Services, SSRS, IIF, Switch, if, switch else, sql server

Views: 10288Comments: 7

Resetting the Exchange 2000/2003 Log Sequence

jjdurrant04/14/2010, 12:00 AM

Unlike Exchange 2007, which supports a logs sequence of 2,000,000,000, the largest transaction log number for Exchange 2000 and 2003 is FFFF0. That number in decimal is 1,048,560. (Which is the maximum number of log files that can be written sequent

Topic: Exchange Email ServerTags: Reset Exchange Log Sequence

Views: 10232Comments: 31

Installing ADMX Administrative Templates in Windows Server 2008 Group Policy

KTN-IT09/25/2010, 12:00 AM

When I went to try to install Office 2007 and Office 2010 ADMX Group Policy administrative templates on my new Windows Server 2008 R2, I couldn't find any straightforward guidance on how to do it.  I muddled my way through it, but I thought I'd shar

Topic: Windows Server 2008Tags: ADMX, Group Policy, Windows Sever 2008

Views: 9877Comments: 7

How to Mimic the T-SQL IsNumeric() Function in MySQL

mwvisa111/21/2008, 12:00 AM

In database programming, custom sort order seems to be necessary quite often, at least in my experience and time here at EE. Within the realm of custom sorting is the sorting of numbers and text independently (i.e., treating the numbers as number

Topic: SQL Query SyntaxTags: MySQL, IsNumeric, RegExp, Regular Expression, Sorting Text and Numbers Separately, SQL, RegExp_Like

Views: 9737Comments: 28

Excel Tips & Tricks: The Camera Tool

harfang10/17/2009, 12:00 AM

Introduction Back in the years when I was teaching Excel 4 (yes, version 4, when .xls meant "worksheet" and not "workbook"), I had a couple of recreational exercises to use when the class was getting tired, after the afternoon break. One of them

Topic: Microsoft Excel Spreadsheet SoftwareTags: Excel Camera Picture Link layout dashboard report traffic light semaphore

Views: 9723Comments: 55

Hide/Show Validator Callout Control Using Javascript

sand198004/06/2010, 12:00 AM

In this article we will see how to show and hide a ASP.NET AJAX’ (AJAXControlToolkit) ValidatorCalloutExtender control using Javascript.  Below is an .aspx page with a validator callout control. <%@ Page Language="C#" AutoEventWireup="true" CodeF

Topic: Programming for ASP.NETTags: ASP.NET AJAX, ValidatorCalloutExtender, ASP.NET

Views: 9706Comments: 16

Dynamic Pivot Procedure for SQL Server

mark_wills05/15/2009, 12:00 AM

by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively

Topic: SQL Server 2005Tags: SQL2005 sql2008 PIVOT

Views: 9595Comments: 16

Import mailboxes from PST into Exchange 2007 using Powershell

shauncroucher09/05/2009, 12:00 AM

In Exchange 2003, one of the simplest ways to move mailboxes from one Exchange organisation to another was using exmerge. It was particularly useful for sites using 'Small Business Server' where the level of data and requirements were low. In Exc

Topic: Exchange Email ServerTags: Import-Mailbox, Exchange 2007 PST, Exchange 2007 Mailbox Import

Views: 9212Comments: 13

Internet Explorer 9 Crash Restart Loop

PeteLong09/21/2010, 12:00 AM

Problem I downloaded the Microsoft Internet Explorer 9 Beta, today, to give it a test drive and maybe write a review for the site, and it failed miserably and got stuck in a crash restart loop. The error message given is as illustrated below i

Topic: Internet Explorer Web BrowserTags: IE9, Crash, Event ID 1000

Views: 9056Comments: 20

Diagnosing and repairing Events 1030 and 1058

ChiefIT06/28/2009, 12:00 AM

Let's say you are going through your server's event viewer logs, under START>>Control Pannel>>Administrative Tools>>Event Viewer>>system logs and you see a lot of errors saying: --Event ID 1030- Windows cannot query for the list of Group Policy o

Topic: Windows 2003 ServerTags: Group Policy, event 1030, event 1058

Views: 8995Comments: 15

Getting Started with Server Core - Networking Commands

mkbean10/08/2008, 12:00 AM

The purpose of this article is not to give you every last detail to Server Core but to provide you with what you need to know it get it up and running in your environment in particular to networking commands.  I will be writing other articles that g

Topic: Windows Server 2008Tags: Microsoft, Server 2008, Server Core, Configuration

Views: 8781Comments: 1

DOS: ECHO text to previous line - by Paul Tomasi

t0t007/23/2009, 12:00 AM

One of my most closely kept secrets is revealed in this discussion How to output text on the same line This question was recently posted in EE by Simon336697 Consider the problem: ECHO Hello ECHO World ...

Topic: MS DOSTags: DOS ECHO "previous line" "same line" "batch file" "Paul Tomasi"

Views: 8777Comments: 33

Getting Started with Server Core - Installing Roles and Features

mkbean10/08/2008, 12:00 AM

Server Core is a version of Windows Server 2008 that has a minimal Graphical User Interface (GUI).  I say minimal when most say command-line only because there are GUI tools available such as Notepad and Task Manager.  One thing that definitely does

Topic: Windows Server 2008Tags: Microsoft, Server 2008, Server Core, Configuration, Roles and Features

Views: 8710Comments: 1

Expanding a Hierarchical Data Structure

mbizup06/20/2008, 12:00 AM

Introduction One of the earliest concepts learned by database developers is parent-child (one-to-many) relationships.  These relationships are integral in countless database applications.  A purchase request containing one or more items ordered i

Topic: Microsoft Access DatabaseTags: Databases, MS Access, Bill of Materials, BOM, Parts Lists, heirarchical, recursion

Views: 8689Comments: 42

How to Remove a Vista Partition from a Vista/Windows 7 Dual Boot Installation

BitsBytesandMore08/12/2009, 12:00 AM

This is the scenario: You've been using Vista for some time and have a lot of applications and data; you don't want to delete your Vista install just yet so you decide to create a dual boot system with your RTM of Windows 7. After a while you get

Topic: Windows 7Tags: Windows Vista, Windows 7, Dual Boot, Partitions, Acronis

Views: 8666Comments: 19

Chart Optimization Tips

ValentinoV09/26/2009, 12:00 AM

Here are some optimization techniques that can be used when creating charts in SQL Server 2008 Reporting Services.  These tips will probably be already known to experienced chart developers, but freshmen charters may spent some time searching how to

Topic: MS SQL ReportingTags: SQL Server Reporting Services 2008, chart, SSRS, Reporting Services

Views: 8659Comments: 14

How to get into safe mode

andrew_aj111/20/2008, 12:00 AM

One question I get asked a lot is how do you get into safe mode. This is actually quite easy. When you boot your computer you usually see a splash screen or a screen with information about your computer. After this you usually here a beep from your

Topic: Microsoft Operating SystemsTags: Windows XP, Windows 2000, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2000

Views: 8658Comments: 6

Top 10 Must have Windows Applications.

bromy200403/04/2010, 12:00 AM

by Nathan Brom/Bromy2004 Introduction There are numerous websites out there for any different type of program you can imagine.  Of those, you'll need to decide which ones are legitimate and aren't trying to steal your money or infect your comput

Topic: Microsoft Operating SystemsTags:

Views: 8633Comments: 5

Windows Mobile Barcode Readers

carlo_vanorsouw04/21/2010, 12:00 AM

Windows Mobile Barcode Scanning These days almost every product has a barcode in some way... amongst there are 1D barcodes en 2D barcodes.. From http://www.barcodeman.com/faq/2d.php I found some handy definitions and insights. 1D barcodes

Topic: Windows Mobile (Pocket PC / Win CE) Operating SystemsTags: Windows Mobile Barcode Readers 1D 2D

Views: 8495Comments: 4

Manually remove a Hardware Device and its Drivers from Windows

johnb676706/09/2009, 12:00 AM

I wanted to pass this along in case anyone has a problem removing a device from the Device Manager, or if you suspect a corrupted Driver that you want to remove in its entirety. I know it is kinda lengthy and very basic in its format, but I figured

Topic: Windows XP Operating SystemTags: Windows XP

Views: 8477Comments: 15

Simple Linear Regression in MS Access

matthewspatrick04/03/2010, 12:00 AM

by Patrick G. Matthews Introduction Linear regression analysis is a common statistical technique used to infer the possible relationships between a dependent variable and one or more independent variables.  While Microsoft Access does not

Topic: Microsoft Access DatabaseTags: Access, Microsoft, regression, regression analysis, linear regression, statistics, VBA, VB, Visual Basic, coefficients, r squared, standard error

Views: 8189Comments: 13

Working with Modal Popup extender control.

sand198008/08/2010, 12:00 AM

This article discusses the ASP.NET AJAX ModalPopupExtender control. In this article we will show how to use the ModalPopupExtender control, how to display/show/call the ASP.NET AJAX ModalPopupExtender control from javascript, how to show/display/cal

Topic: Programming for ASP.NETTags: ASP.NET, ASP.NET AJAX, Modal Popup Extender

Views: 8168Comments: 24

Never Again Forget to Add that Attachment to your Outlook Email

BlueDevilFan04/25/2010, 12:00 AM

Issue.  Have you ever sent an email and forgotten to add the attachment?  How embarrassing!!!!  Here's a short Outlook macro to make sure this never happens again. As I’ve gotten older I’ve noticed that my memory and attention to detail have both

Topic: Outlook Groupware SoftwareTags: outlook, attachment, vba, script, macro

Views: 8136Comments: 56

Building a Formless WinForms Application with a NotifyIcon in VB.Net 2008

Idle_Mind03/24/2010, 12:00 AM

This tutorial demonstrates one way to create an application that runs without any Forms but still has a GUI presence via an Icon in the System Tray. The magic lies in Inheriting from the ApplicationContext Class and passing that to Application.Ru

Topic: Microsoft Visual Basic.NetTags: ApplicationContext, NotifyIcon, WinForms, Visual Basic.Net

Views: 8133Comments: 20

Word 2010 Review: Improving Collaboration and Navigation

BMilneSLO03/04/2010, 12:00 AM

When I first made the jump from Microsoft Word 97 to Word 2007, it was just that … a giant leap. Going a decade between software updates is as dumb as it sounds, but when you’re used to a solid word processor like Word 97, you tend to stick with

Topic: Microsoft Office SuiteTags: Microsoft Office 2010, Word 2010

Views: 8130Comments: 7

Modify Distribution Group Members

endital109709/08/2010, 12:00 AM

Managing distribution groups always seems to be changing from one version of Exchange to the next. In Exchange 2003 you would modify the properties of the group by updating the Managed By tab and enabling the Manager can update membership list. To a

Topic: Exchange Email ServerTags: Exchange Server, Powershell, Active Directory, Outlook

Views: 8101Comments: 7

"Domain Aggregate" for Concatenating Values by Group in Microsoft Access

matthewspatrick02/02/2010, 12:00 AM

by Patrick G. Matthews A common request in the various database zones at Experts Exchange involves returning a concatenated list of the various items in ColumnB for each distinct value in ColumnA from a particular table or query.  For example

Topic: Microsoft Access DatabaseTags: Access, VBA, SQL, query, domain aggregate, concatenate

Views: 7941Comments: 21

Fixing drive problems after installing or upgrading iTunes on Windows

franked_it06/16/2009, 12:00 AM

iTunes uses a third party component from  GEAR Software for accessing the CD/DVD drives in Windows computers.  This component is registered as a filter driver for all CD/DVD drives.  Sometimes the iTunes installation or upgrade process can cause thi

Topic: Windows XP Operating SystemTags: Windows, itunes, drives, gearaspi, upperfilter, registry, vista, x64, missing, burning

Views: 7846Comments: 15

Registry Cleaners - Good or harmful to your PC?

rpggamergirl10/01/2011, 12:00 AM

It is only natural that we all want our PCs to be in good working order, improved system performance, so that is exactly how programs are advertised to entice. They say things like:            •      PC crashes? Get registry cleaner to repair it!    

Topic: Windows XP Operating SystemTags:

Views: 7739Comments: 22

Radio Buttons in MFC Dialogs

DanRollins09/12/2009, 12:00 AM

Here is how to use MFC's automatic Radio Button handling in your dialog boxes and forms.  Beginner programmers usually start with a OnClick handler for each radio button and that's just not the right way to go.  MFC has a very cool system for handli

Topic: Windows MFC ProgrammingTags: MFC, DDX_Radio, C++, DoDataExchange, RadioButton group, enabling dilaog items, Dan Rollins

Views: 7727Comments: 1

Avoiding Blank Subject Lines in Outlook

BlueDevilFan04/24/2010, 12:00 AM

Issue.  Have you ever received an email with a blank subject line?  Have you ever clicked "Send" only to realize that you forgot to add a subject?  It’s frustrating to receive a message with no subject.  You’ve no idea what the message is about, how

Topic: Outlook Groupware SoftwareTags: outlook, macro, script, blank, subject

Views: 7725Comments: 22

Exchange 2007 / 2010 Backpressure – Quick Fix

alanhardisty12/20/2010, 12:00 AM

What is Backpressure? Backpressure is a new ‘feature’ in Exchange 2007 / 2010 where Exchange actually monitors resources such as Free Disk Space on the disk where the Exchange Message Queue / Message Queue Transaction Logs live and the Memory that

Topic: Exchange Email ServerTags: Exchange 2007, Exchange 2010, Backpressure

Views: 7625Comments: 22

Steps to solve SSRS SQL 2008 R2 User Access Control (UAC) Permission Error

aelliso307/07/2010, 12:00 AM

Steps to solve SSRS SQL 2008 R2 User Access Control (UAC) Permission Error With the introduction of SQL Server 2008 R2 and Vista (Windows 7 as well) came new enhanced security features. One of the features included was User Access Control (UAC) t

Topic: MS SQL ReportingTags: SSRS 2008 SQL Server R2 User Access Control UAC Permission Error

Views: 7595Comments: 6

Eliminating duplicate data with Duplicate Master V2

brettdj12/17/2009, 12:00 AM

Introduction - The Problem Many people use or inherit spreadsheets built with database functionality.  A frequent problem with such spreadsheets is duplicate data, either of entire records, or in specific fields.  Duplicate data in your spreadshe

Topic: Microsoft Excel Spreadsheet SoftwareTags: excel, duplicates, vba, regular expressions, fuzzy match, addin, unique, brettdj

Views: 7573Comments: 100

Using Variant Arrays in Excel VBA for Large Scale Data Manipulation

brettdj03/17/2010, 12:00 AM

Introduction One of the most common VBA techniques is the use of a For .. Next loop to iterate through all the cells in a range.  The syntax is straightforward and easily applied.  Unfortunately, for large data sets it can also be the programming e

Topic: Microsoft Excel Spreadsheet SoftwareTags: Variant Arrays VBA, For Next Loops, Code optimisation, leading zero replacement, regular expression

Views: 7543Comments: 34

Notify External Recipient of email arrival

demazter03/02/2010, 12:00 AM

N.B. This process will work with Exchange 2007 running on Windows 2008, Small Business Server 2008, Essential Business Server 2008 & Exchange 2010 only. You may have reason to send a notification to an external recipient informing them that they

Topic: Exchange Email ServerTags: external recipient, exchange, transport rule

Views: 7463Comments: 10

Output an XML type attribute using DataContract

williamcampbell08/31/2009, 12:00 AM

This tutorial will show you how to add an attribute to an XML stream returned from a Windows Communication Foundation (WCF) Web Service.  Some knowledge of WCF and XML is required; the code is in C#.  Below is an XML sample of an attributed XML stre

Topic: Web Services and WCFTags: DataContract Attribute, XML, C#, WCF

Views: 7372Comments: 39

Demystifying the Active Directory FSMO Roles

tigermatt04/02/2010, 12:00 AM

By Matt Huxtable (tigermatt) If you've spent any time administering Active Directory, you've probably come across the concept of Flexible Single Master Operations (FSMO) roles. Their introduction is arguably one of the most important but misunder

Topic: Active DirectoryTags: Microsoft, Windows Server System, Active Directory, Directory Services, FSMO Roles, Multi Master, Operations Roles

Views: 7159Comments: 49

How to navigate your computer without your mouse

masmus08/05/2009, 12:00 AM

There are plenty of situations when you need know how to operate your computer without your mouse: like that time you kept putting off replacing the batteries on your wireless mouse until that day there was no more juice and you were out of AA's or

Topic: Windows XP Operating SystemTags: without your mouse, without mouse, Windows XP, vista, mouse broken

Views: 7150Comments: 16

Configure iPhone for use with Exchange Server

demazter06/04/2010, 12:00 AM

With more and more people using iPhones and iPads for email collection we are seeing more problems arising from misconfiguration. Preparation The first thing to be aware of is that for ActiveSync to work correctly you must be using Exchange 2003

Topic: Exchange Email ServerTags: iphone, activesync, Exchange server

Views: 7101Comments: 14

Encrypt your Thumb Drive at Work and Use it at Home -- PART ONE

DanRollins08/09/2009, 12:00 AM

USB "Thumb Drives" are convenient and cheap.  They are great for making quick backups and for transferring data from one place to another.  But if you lose a portable flash disk, anything it contains is easily read by whoever finds it.  It turns out

Topic: Microsoft Operating SystemsTags: encrypt thumb drive, EFS, Encrypting File System, USB Drive, thumb drive, NTFS

Views: 7049Comments: 25

Option to open excel 2007 documents in a new instance

alainbryden06/22/2009, 12:00 AM

Problems we all know excel has Many people are tired of the way excel workbooks are affected by every other workbook you have opened. When you calculate one, they all calculate.  Excel acts as though they are inter-dependent when they really aren't

Topic: Microsoft Excel Spreadsheet SoftwareTags: Excel, Excel 2007, Windows XP, Shell

Views: 7041Comments: 8

PIVOT Transformation - SSIS - Complete Tutorial

reza_rad02/15/2010, 12:00 AM

Sometimes, you need to use PIVOT in SSIS to ensure your data matches the output requirements of your users. So, what is PIVOT and what is SSIS and how can that help ? Firstly a quick explanation of those acronyms as described by Microsoft : Mi

Topic: SSISTags: PIVOT, PIVOT Transformation, SSIS, Tutorial

Views: 6922Comments: 9

Export or Strip Email Attachments in Outlook

alainbryden08/12/2010, 12:00 AM

Intro I've seen a few requests floating around for scripts that will export or strip attachments out of emails, and so far have never encountered any high quality implementations of this feature, so I created this method with a little flavor. Whe

Topic: Outlook Groupware SoftwareTags: Outlook, Attachment, Strip, Archive, Save, Button, Manage, Email, VBA, Macro

Views: 6897Comments: 29

Windows 7 Review: Seven Reasons Windows 7 Could be a Success/Failure

BMilneSLO10/15/2009, 12:00 AM

I got my first look at Windows 7 this week and my initial reaction was "so far, so good." "So far" being the key phrase of that statement. New operating systems (Microsoft officially releases Windows 7 on Oct. 22) are almost always an improve

Topic: Windows 7Tags: Windows 7, Microsoft, Windows, OS, Vista, Windows XP

Views: 6853Comments: 16

Delimited String Parsing in SQL Server 2005 and later

BrandonGalderisi11/20/2008, 12:00 AM

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa

Topic: SQL Server 2005Tags: parse, string parsing, delimited string, user defined function, sql server 2005, sql server 2008

Views: 6771Comments: 8

Loading Advertisement...

Top Microsoft Experts

  1. CodeCruiser

    1,429,555

    Genius

    5,910 points yesterday

    Profile
    Rank: Genius
  2. dlmille

    1,335,221

    Genius

    6,876 points yesterday

    Profile
    Rank: Genius
  3. demazter

    987,197

    Sage

    392 points yesterday

    Profile
    Rank: Genius
  4. alanhardisty

    828,999

    Sage

    7,430 points yesterday

    Profile
    Rank: Genius
  5. mbizup

    793,142

    Sage

    4,520 points yesterday

    Profile
    Rank: Genius
  6. capricorn1

    745,894

    Sage

    10,500 points yesterday

    Profile
    Rank: Savant
  7. apache09

    647,624

    Sage

    6,650 points yesterday

    Profile
    Rank: Genius
  8. boag2000

    629,541

    Sage

    6,500 points yesterday

    Profile
    Rank: Genius
  9. dariusg

    563,817

    Sage

    1,568 points yesterday

    Profile
    Rank: Genius
  10. matthewspatrick

    540,447

    Sage

    9,810 points yesterday

    Profile
    Rank: Savant
  11. ssaqibh

    531,655

    Sage

    1,500 points yesterday

    Profile
    Rank: Genius
  12. kaufmed

    516,680

    Sage

    3,030 points yesterday

    Profile
    Rank: Genius
  13. ve3ofa

    499,684

    Wizard

    30 points yesterday

    Profile
    Rank: Genius
  14. teylyn

    481,766

    Wizard

    1,900 points yesterday

    Profile
    Rank: Genius
  15. imnorie

    466,155

    Wizard

    6,364 points yesterday

    Profile
    Rank: Genius
  16. Run5k

    458,130

    Wizard

    5,332 points yesterday

    Profile
    Rank: Genius
  17. fyed

    447,709

    Wizard

    1,510 points yesterday

    Profile
    Rank: Genius
  18. jogos

    447,581

    Wizard

    1,668 points yesterday

    Profile
    Rank: Sage
  19. LSMConsulting

    439,022

    Wizard

    1,000 points yesterday

    Profile
    Rank: Savant
  20. BuggyCoder

    429,173

    Wizard

    3,600 points yesterday

    Profile
    Rank: Sage
  21. motnahp00

    411,340

    Wizard

    19,000 points yesterday

    Profile
    Rank: Sage
  22. arnold

    408,480

    Wizard

    4,000 points yesterday

    Profile
    Rank: Genius
  23. ScottPletcher

    389,248

    Wizard

    10,100 points yesterday

    Profile
    Rank: Genius
  24. thinkpads_user

    386,681

    Wizard

    3,164 points yesterday

    Profile
    Rank: Genius
  25. acperkins

    385,644

    Wizard

    1,000 points yesterday

    Profile
    Rank: Genius

Hall Of Fame