SQL Server with Mr. Denny:

Article

Apr 17 2008   10:00PM GMT

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



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

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

Apr 1 2008   6:43PM GMT

New Article: Tips for scheduling and testing SQL Server backups



Posted by: mrdenny
Article, Backup and Recovery

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


Mar 27 2008   6:54PM GMT

New Article: SQL Server tempdb best practices increase performance



Posted by: mrdenny
Article, System Configuration, DataManagement

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

Denny


Mar 6 2008   2:26AM GMT

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



Posted by: mrdenny
Article, Compliance, SQL, Quest Software

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


Mar 2 2008   11:45AM GMT

New Article: Configuring SQL Server memory settings



Posted by: mrdenny
Article, SQL, RAM

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

Denny


Mar 2 2008   4:43AM GMT

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



Posted by: mrdenny
Article, Config, SQL, SQL Server 2005, Installation, SQL Server 2008

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


Feb 13 2008   10:37AM GMT

New Article: Configuring SQL Server memory settings



Posted by: mrdenny
SQL, Article, Cache, RAM

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


Feb 7 2008   12:20AM GMT

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



Posted by: mrdenny
Article, SoSSE, Quest Software, In Person Events, SQL, SQL Server 2005, SSMS

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


Jan 17 2008   12:00PM GMT

MS KB Article with all the hot fixes listed



Posted by: mrdenny
Article, Bug, SQL, SQL Server 2005, Support

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


Jan 11 2008   6:40PM GMT

New Article: Determining SQL Server database storage requirements



Posted by: mrdenny
Article, Config, DataManagement, SQL, SQL Server 2005, SQL Server 2008

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

Denny