Posts by Edwin Sarmiento

Building a SQL Server Failover Cluster on Windows Server ’08 Pt 1

As I’ve already gone thru building a Windows Server 2008 cluster in this blog post, let’s have a look at installing SQL Server 2008. Whether you’re looking at R2 or non-R2 versions of both Windows Server 2008 and SQL Server 2008, the steps are almost the same except for some PowerShell support for Windows Server 2008 on the Clustering side and whether or not you’re dealing with Hyper-V LiveMigration as part of your cluster (this, however is beyond the scope of this blog post).

Installing SQL Server 2005 Reporting Services 32-bit on a Windows Server 2003 64-bit

To be able to install ASP.NET 32-bit on a 64-bit IIS, you need to configure IIS to run 32-bit web applications. With Windows Server 2003 Service Pack 1, IIS can be enabled to run 32-bit applications on a 64-bit Windows using the Windows32-On-Windows64(WoW64) compatibility layer. This makes it possible to run ASP.NET 32-bit and other 32-bit web applications as well as allow creation of 32-bit worker processes. Here’s how to complete the install.

Windows PowerShell for the SQL Server DBA

Most people think Windows administrators make a living with their right-hand—you know, right-clicking and left-clicking the user interface to get things done. I’ve spent a fair amount of time writing VBScript scripts to administer Windows servers and workstations and automating repetitive tasks. One reason for me moving into Windows PowerShell is its roots in the Microsoft .NET Framework, as I have done a fair amount of .NET programming. But what is Windows PowerShell anyway?

Building a Windows Server 2008 Cluster, Part 3

In Part 1 of this series, we prepared our Windows Server 2008 servers to be a part of a cluster. Part 2 showed us how we can add the shared disks, install the Failover Cluster Feature, and run the Validate Cluster Configuration Wizard. In this post, we will complete the process by creating a Windows Server 2008 cluster.

Building a Windows Server 2008 Cluster, Part 1

This happens to be my very first blog post with Pythian, and to kick this thing off, I would like to talk about building a Windows Server 2008 cluster. The goal of this series of posts is to be able to help DBAs who may be charged with installing SQL Server on a Windows Server 2008 cluster. The best approach is to always have an environment on which to run these tests. In my case, I run VMware Workstation 6.5 on my Windows XP laptop. Here are the steps that you need to take.

Page 2 of 212