Article

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

Get SQL Server log shipping functionality without Enterprise Edition

A new tip of mine has just been published on SearchSQLServer.com.  This tip, “Get SQL Server log shipping functionality without Enterprise Edition” is all about writing your own Log Shipping code without using Microsoft’s, allowing you to use Log Shipping on editions of SQL Server other than Enterprise Edition.

Denny

Tuning SQL Server performance via disk arrays and disk partitioning

I’ve published another tips on SearchSQLServer.com called “Tuning SQL Server performance via disk arrays and disk partitioning“.  This is sort of a part one of a two part series of tips on tuning the database server at the hardware level.  In this tip I’m focusing on getting the disks setup just right.  I also show how to use diskpart.exe to see if the disks are correctly aligned.

Denny

SQL Server Experts: MS SQL beats the “ACID” test for Database Technology in Features, Ease & Cost

I was asked to be interviewed for an article on Microsoft SQL Server by OdenJobs.com.  They have just posted the interview of myself and Christian Lefter, Andew Fyer, Namwar Rizvi, Brent Ozar, Brian Kelly, Chris Shaw, and Pinal Dave.

Part 1: MS SQL beats the “ACID” test for Database Technology in Features, Ease & Cost

Part 2: Stress, Pet Peeves, Roles and Responsibilities of a SQL Server DBA/Developer

Part 3: Becoming a SQL Server MVP and other Career Choices

Thanks,

Denny