Article

New Article: Configure SQL Server Service Broker for sending stored procedure data

I’ve just published a new tip on SearchSQLServer.com called Configure SQL Server Service Broker for sending stored procedure data.  In it I’m going over SQL Service Broker and how to configure all the objects.

As a followup to this I’ll be going over all these objects as part of the Back To Basics series over the next several weeks.

 Denny

New Article: Tips for scheduling and testing SQL Server backups

I’ve just published a new tip on SearchSQLServer.com called Tips for scheduling and testing SQL Server backups.  In it I’m talking about server backups including how to schedule those backups on SQL Server Express edition which doesn’t have the SQL Server Agent.

Denny

New Article: SQL Server tempdb best practices increase performance

I’ve recently published a new tip on SearchSQLServer.com called “SQL Server tempdb best practices increase performance“.

Denny

New Paper Published: Bullet-proof Change Management – Don’t just Cross your Fingers and Hope

I’ve written a technical brief on how my company, Awareness Technologies, uses the Quest Software Change Director for SQL Server product to monitor for and track unauthorised changes to our environments.

Denny

New Article: Configuring SQL Server memory settings

I’ve recently published a new tip on SearchSQLServer.com called “Configuring SQL Server memory settings“.

Denny

New Article: Create an upgrade plan for your move to SQL Server 2005

I’ve published a new tip over on SearchSQLServer.com entitled “Create an upgrade plan for your move to SQL Server 2005“.

While it’s based on upgrading to SQL Server 2005 it can be used to upgrade to SQL Server 2008 as well.

Denny

New Article: Configuring SQL Server memory settings

I’ve published a new tip over on SearchSQLServer.com entitled “Configuring SQL Server memory settings“.  In it I talk about how to correctly setup the memory settings for SQL Server to get SQL setup correctly.

Denny

New Paper Published: Picking the Right Instrument for SQL Server Performance Management

The folks at Quest Software asked me to write a paper for them discussing the differences between managing a SQL Server using just the Microsoft provided tools and their Spotlight on SQL Server Enterprise product.  That paper has just been released and can be downloaded here.  We’ll also be discussing this paper (among other things) at a web cast Thursday 2/7/2008 at 8am which you can read about here and here.

Denny

MS KB Article with all the hot fixes listed

I found this great little MS KB article today.  It’s got all the SQL Server 2005 post SP2 host fixes including bug numbers and descriptions of the bug.  The MS KB article ID is 937137.

Denny

New Article: Determining SQL Server database storage requirements

I’ve published a new tip over on SearchSQLServer.com entitled “Determining SQL Server database storage requirements“.

Denny