Restore a Replaced Document in SharePoint Server 2007

A few weeks ago I had someone ask me about restoring a single Excel spreadsheet in Microsoft Office SharePoint Server 2007 (MOSS).  The spreadsheet had been overwritten by uploading another one in its place with the same file name. Versioning was not turned on in this document library. The spreadsheet that needed to be restored was not in the user's or admin's recycle bin. I guess that's because it wasn't actually deleted. I decided that if the data is saved in the SharePoint content database Read more [...]

Installation of the Windows 8 Developer Preview

The Windows 8 Developer Preview was publicly released this past Tuesday evening via the new Windows Dev Center. I actually thought I was going to miss out on the opportunity to try out this preview version since I’m not currently a MSDN subscriber. I was happy to learn that it was made available for anyone to download. Since this is a preview version, I decided to load it as a virtual machine on a Hyper-V server. This kept me from tying up any of my machines that I need to work properly on a Read more [...]

Resolving SharePoint 2010 PDF Issues with PowerShell

PDF’s that have been uploaded to your SharePoint 2010 document libraries do not show the correct icon and only give you the option of saving instead of opening them: The following PowerShell script downloads a 17x17 GIF image from Adobe.com named pdficon_small.gif, places it in the images folder under the 14 hive, associates it in the DOCICON.XML file, sets Browser File Handling to Permissive, and then runs IISReset:   The first part of the script downloads Read more [...]

Dell EqualLogic PS4000 – Creating a Volume with PowerShell

Download the EqualLogic Host Integration Toolkit (HIT Kit) for Microsoft from the EqualLogic support site. Install the PowerShell Tools portion of the HIT Kit on the computer you want to manage the SAN from. For a PS4000, this computer doesn't need access to the iSCSI network as long as it has connectivity to the management network. The following PowerShell script creates a 36GB thin provisioned volume named mikefrobbins with a snapshot reserve of 100%, sets a description for the volume, allows Read more [...]

The Easy Way to Create a Bootable Windows 7 USB Flash Drive

I recently loaded Windows 7 on my netbook computer and ran across a tool named "Windows 7 USB/DVD Download Tool" which makes creating a Windows 7 bootable USB flash drive much easier. Download and install this tool. Open the program and select the ISO you want to copy to your USB flash drive. Select "USB device": Select the USB flash drive you want to copy the Windows 7 installation media to. Warning: This process erases all data that currently exists on the USB flash drive you Read more [...]

Restoring a Microsoft SQL Server Database

This blog article is a scenario that I sent a coworker a while back about recovering a SQL Server database up to the point in time where a catastrophic hard disk drive failure occurs for the hard drive containing a SQL Server database. The transaction log for this database is on a separate physical disk and is still accessible. I added the Northwind database to SQL Express on my machine, changed the recovery model to full, and then backed up the database and transaction log: Processed Read more [...]

Set SharePoint 2010 Outgoing E-Mail Settings with PowerShell

Configure the outgoing email settings in a SharePoint 2010 Farm with PowerShell. Launch the PowerShell ISE. Import the SharePoint PowerShell Snap-in, modify the script below using your specific email server settings and then run the script. The outgoing email settings are now configured. µ Read more [...]

Slipstream SP1 into Microsoft SharePoint Foundation 2010

This blog article will guide you through the process of slipstreaming SP1 into Microsoft SharePoint Foundation 2010. The process for the non-foundation edition is identical with the exception of the file names and the actual service pack file. You’ve downloaded SharePoint Foundation 2010 and SP1 for that specific version to D:tmp. You've created a folder (D:\sp2010) to house the installation files once they're slipstreamed. Extract the SharePoint installation files into the D:\sp2010 folder:: Extract Read more [...]

Microsoft SharePoint Foundation 2010 Installation – Part 3

This blog is a continuation from last weeks blog (Part 2). We’ll jump right in where we left off. Verify you are logged into the server that you want to install SharePoint on as the spNameInstall account. Right click the PowerShell ISE and select "Run as administrator": Load the SharePoint PowerShell Snap-in: You will receive "The local farm is not accessible. Cmdlets with FeatureDependencyId are not registered." This is normal since we have not configured Read more [...]

Microsoft SharePoint Foundation 2010 Installation – Part 2

This blog is a continuation from last weeks blog (Part 1). We'll jump right in where we left off. Verify you are logged into the server that you want to install SharePoint on as the spNameInstall account. Run the SharePoint executable (SharePointFoundation.exe) that you previously downloaded. Select "Install software prerequisites": With SharePoint 2010, there's no need to manually install any of the prerequisites as in previous versions of SharePoint. It installs all of them for you: The SharePoint Read more [...]

Microsoft SharePoint Foundation 2010 Installation – Part 1

You're ready to introduce SharePoint 2010 into your SMB and you've chosen to install the "free with Windows Server" version called "Foundation". Details about this version can be found on the SharePoint Foundation 2010 Production Information webpage. You'll need a minimum of two servers, virtual or physical with the specifications listed below to get started. While it is possible to run SharePoint 2010 on a single server, it's definitely not recommended for a production environment. Depending on Read more [...]

Create an Active Directory User Account with PowerShell

I’m in the process of installing SQL Denali and need a couple of users accounts created. If you are creating the Active Directory user on a machine other than a domain controller, you’ll need to install the Active Directory module for Windows PowerShell. Then import the Active Directory module. To see the syntax and available options for creating an Active Directory user using PowerShell, type "Get-Help New-ADUser" inside the PowerShell console. Store Read more [...]

Install the PowerShell ISE & Enable PowerShell Scripts

PowerShell 2.0 is installed by default on Windows 7 and Windows Server 2008 R2. The PowerShell ISE (Integrated Scripting Environment) is installed by default on Windows 7, but not Windows Server 2008 R2. You can use the following information to install the ISE on your 2008 R2 server (as long as it’s running the full GUI and not the Core installation). Launch PowerShell and execute the following: If you attempted to run this on the Core (no GUI) installation Read more [...]

EqualLogic PS Series SAN Password Recovery

Problem: You're unable to login to your EqualLogic PS Series Storage Area Network (SAN) to perform administrative functions. When you attempt to login, you receive a login exception message stating "Invalid username or password". Solution: The grpadmin account password can be reset by connecting a computer to the serial port of the active controller on your EqualLogic SAN. You’ll need one of the serial cables that shipped with your SAN which is a standard 9 pin female to female serial cable. Read more [...]

Enabling Dynamic Memory for a Guest VM on Hyper-V

You've loaded SP1 on your Windows Server 2008 R2 Hyper-V virtualization host server and you're ready to begin using Dynamic Memory for your virtualization guest machines (VM's). Listed below is the minimum amount of changes required for your virtualization guest machines (VM’s) to be able to use dynamic memory: Set the VM to use Dynamic Memory by specifying a minimum and maximum amount of memory. The VM will need to be shutdown in order to change this setting and the settings will only Read more [...]