Economies of Speed Whitepaper

• by Additional Articles

• Other

• Administration

Seagate has a white paper out that discusses how faster (15k rpm) drives can lead to lower cost of ownership. Interesting, and worth looking into.

Handling The Text Data Type

• by Robert Marda

• SQLServerCentral.com

• Miscellaneous

Robert is back this week with a look at the text data type. Not the easiest thing to work with, but sometimes a varchar just doesn't give you the range you need.

An Automated Solution for Migrating Database Structures

• by Additional Articles

• DevX

• Administration

This article by Simon Galbraith (from Red Gate software, maker of SQL Compare) discusses migrating changes from development to staging, QA, and on to production. If you've never seen the need for a schema compare tool (Steve Jones!), this is worth reading.

Auto Close and Auto Shrink - Just Don't

• by Mike Pearson

• SQLServerCentral.com

• Administration

New author! Mike Pearson discusses how auto close was at the root of a performance problem he was troubleshooting, how you can check your servers easily, and discusses why both auto close and auto shrink are bad ideas in a production environment.

Sneak peak at Log Navigator II

• by Additional Articles

• Other

• Miscellaneous

As LockwoodTech Log Navigator Beta releases approaches we have released a bunch of new screen shots on product features. Log Navigator reads the MS SQL Server Transaction Log to allow you to passively audit data changes (inserts, updates and deletes) made to your database.

Creating a Script from a Stored Procedure

• by Ryan Randall

• SQLServerCentral.com

• Miscellaneous

Ryan demonstrates how he arrived at a solution that allows you to create scripts from a stored procedure using SQL-DMO. If you get interested in DMO, we've got quite a bit of additional content here on the site to help you get going! Ryan is a new author here on the site, please take a minute to read his article, add a comment, maybe just say hello.

New MDX Book Published

• by Additional Articles

• Other

• Miscellaneous

Fast Track to MDX gives readers all the necessary background information needed to write useful, powerful MDX expressions and introduces the most frequently used MDX functions and constructs. No prior knowledge is assumed and examples are used throughout the book to rapidly develop MDX skills to the point where a reader can solve real business problems. A CD containing examples from within the book, and a time-limited version of ProClarity, is included

Getting Certified

• by Brian Kelley

• SQLServerCentral.com

• Certifications

Brian spends a lot of time in our forums helping out. Based on a recent question from a reader he put together some tips he used when he was preparing for the MCSE exams. Interesting reading!

SecureWave's SecureStack 3.0 Release

• by Additional Articles

• Other

• Security

SecureWave forwarded us this link to some info about their product - they claim to be the only product capable of protecting SQL Server from buffer overflow attacks. You can download a free eval from their site. We have not reviewed this product.

Using Query Analyzer Templates

• by Gregory Larsen

• SQLServerCentral.com

• Administration

Greg returns with an article based on some practical experience using QA templates to save time and work. Good examples, good work through, good idea!