Article

SQL Server 2008 Clustering Article in SQL Server Magazine

For those of you who haven’t check out this months SQL Server Magazine, the cover article was written by yours truly about Clustering SQL Server 2008 on Windows Server 2008.  This is an updated version of the article I did last December on Clustering SQL Server 2005 on Windows Server 2003.

I hope that you find it handy.  (Subscription is required.)

Denny

Clearing the Windows page file and its effect on server performance

I just published a new article over on SearchSQLServer.com about “Clearing the Windows page file and its effect on server performance“.  In the article I talk about the pros and cons of telling Windows to clear out the page file when the server is rebooted.

Denny

Setting up SQL Server Service Broker for secure communication

Today a new article that I wrote was posted up on SearchSQLServer.com.

The article is about setting up SQL Service Broker to use Certificates to secure the traffic between the instances.

Denny

Article: Testing a SQL Server environment before an upgrade

I just published another article up on SearchSQLServer.com.  This one is entitled Testing a SQL Server environment before an upgrade.  In it I talk about some successes and some failures that I’ve seen when upgrading SQL Server versions and how the failures could have been avoided.

Developing a SQL Server Database Backup Plan

Last week I published a new article on Enterprise IT Planet called “Developing a SQL Server Database Backup Plan” in which I go over some of the techniques which are used to backup databases and why you need to ensure that your databases are backed up.

Denny

Optimal Database Setup Hardware Guide

A little while back I published an article on Enterprise IT Planet called “Optimal Database Setup Hardware Guide“.  In this article I talk about some key points that should be looked at when building a new SQL Server.

Denny

SQL Server virtualization pros and cons: Weigh the performance impact

It’s been a while since I’ve posted about new articles that I’ve published.  Over the next few weeks I’m going to see if I can’t remedy that, and get all caught up.

Over on SearchSQLServer.com I posted an article entitled “SQL Server virtualization pros and cons: Weigh the performance impact“.

Continued »

SQL Clustering Article in SQL Server Magazine

For those of you who are SQL Server Magazine Subscribers you should be getting your copies right about now (if you haven’t already).  When you do be sure to check out the article which I have in the magazine about clustering your SQL Server.

For those without a subscription you can sign up for a digital subscription at SQLMag.com and read the article on the web.

Denny

Does your SQL Server database improve SharePoint performance?

This morning I posted by first article up on SearchWinIT.com called “Does your SQL Server database improve SharePoint performance?“. It is all about getting the most out of your SharePoint environment by getting the most out of your SQL Server.

Denny

Tuning SQL Server performance via memory and CPU processing

Part two of my two part series on hardware tuning of your SQL Server has just been released on SearchSQLServer.com.  This part is titled “Tuning SQL Server performance via memory and CPU processing“.

Denny