Best Practices Analyzer

Hello,

I found in marketing materials, than Best Practices Analyzer is included in installation of SQL 2005. Is it right ? I could not found it.

Any ideas ?

You could get it from link

http://www.microsoft.com/downloads/details.aspx?displayla%20ng=en&familyid=B352EB1F-D3CA-44EE-893E-9E07339C1F22&displaylang=en

|||But it is for SQL2000 server. I need analyzer for SQL2005 .|||

I'm a program manager heading up the next version of Best Practices Analyzer for SQL Server 2005. We are pretty early in the development cycle right now... we'll probably ship second half of this year. Check out this blog post for more information: http://blogs.msdn.com/sqlrem/archive/2006/04/06/570292.aspx.

Thanks,

Paul A. Mestemaker II
Program Manager
Microsoft Corporation
SQL Server Relational Engine Manageability Team

Best Practices Analyzer

Hello,

I found in marketing materials, than Best Practices Analyzer is included in installation of SQL 2005. Is it right ? I could not found it.

Any ideas ?

You could get it from link

http://www.microsoft.com/downloads/details.aspx?displayla%20ng=en&familyid=B352EB1F-D3CA-44EE-893E-9E07339C1F22&displaylang=en

|||But it is for SQL2000 server. I need analyzer for SQL2005 .|||

I'm a program manager heading up the next version of Best Practices Analyzer for SQL Server 2005. We are pretty early in the development cycle right now... we'll probably ship second half of this year. Check out this blog post for more information: http://blogs.msdn.com/sqlrem/archive/2006/04/06/570292.aspx.

Thanks,

Paul A. Mestemaker II
Program Manager
Microsoft Corporation
SQL Server Relational Engine Manageability Team

Best DataType for content system

Hello,
On our corporate website, we will be using email notifications for
various things. I would like for our marketing guy to be able to edit
the email templates over the web so that I don't have to keep updating
them myself for every little change. I want to store the templates
within the database (since they will be small). The templates will be
HTML based and not more than a few thousand bytes in length. Should I
use a VARCHAR or VARBINARY, or what? I would assume VARCHAR, but I'm
not sure.

Thanks,
WillFoehammer (foehammer@.hotmail.com) writes:
> On our corporate website, we will be using email notifications for
> various things. I would like for our marketing guy to be able to edit
> the email templates over the web so that I don't have to keep updating
> them myself for every little change. I want to store the templates
> within the database (since they will be small). The templates will be
> HTML based and not more than a few thousand bytes in length. Should I
> use a VARCHAR or VARBINARY, or what? I would assume VARCHAR, but I'm
> not sure.

Unless you intend to compress the templates to be able handle case
that the marketing guys enters more than 8000 characters, there is
no reason to use VARBINARY, use VARCHAR.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp