Article archives - SQL Server with Mr. Denny

SQL Server with Mr. Denny:

Article

Sep 1 2009   6:31PM GMT

SQL Server 2008 Clustering Article in SQL Server Magazine



Posted by: mrdenny
Article, SQL Server Magazine, Clustering, SQL Server 2008, Windows 2008

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

Aug 26 2009   3:34PM GMT

Clearing the Windows page file and its effect on server performance



Posted by: mrdenny
SearchSQLServer.com, Article, Page File, Microsoft Windows

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


Jul 9 2009   1:27AM GMT

Setting up SQL Server Service Broker for secure communication



Posted by: mrdenny
Article, Service Broker, SQL Server 2008, SQL Server 2005, SearchSQLServer.com

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


Mar 30 2009   5:27PM GMT

Article: Testing a SQL Server environment before an upgrade



Posted by: mrdenny
SearchSQLServer.com, Testing, Upgrading, Article

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.


Mar 8 2009   3:20AM GMT

Developing a SQL Server Database Backup Plan



Posted by: mrdenny
Article, Backup & recovery

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


Feb 16 2009   8:58AM GMT

Optimal Database Setup Hardware Guide



Posted by: mrdenny
Server Hardware, Article, enterpriseitplanet.com

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


Jan 2 2009   8:56AM GMT

SQL Server virtualization pros and cons: Weigh the performance impact



Posted by: mrdenny
Virtualization, Article

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 »


Dec 1 2008   11:00AM GMT

SQL Clustering Article in SQL Server Magazine



Posted by: mrdenny
Clustering, SQL Server 2005, Article, SQL Server 2008

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


Nov 4 2008   9:50PM GMT

Does your SQL Server database improve SharePoint performance?



Posted by: mrdenny
SharePoint, Article, Performance Problems, SearchWinIT.com

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


Sep 9 2008   11:52AM GMT

Tuning SQL Server performance via memory and CPU processing



Posted by: mrdenny
Article

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