Brendan Tompkins [MVP]

Blog First. Ask Questions Later.

Microsoft SQL Server Best Practices Analyzer

This is pretty cool. I'd suppose that any one writing .net/SQL apps will find this tool helpful for identifying potential problems in their database design and deployments... Get your copy here.

“Microsoft SQL Server Best Practices Analyzer is a database management tool that lets you verify the implementation of common Best Practices. These best practices typically relate to the usage and administration aspects of SQL Server databases and ensure that your SQL Servers are managed and operated well.”

-B

Published Jun 14 2004, 12:28 PM by Brendan Tompkins

Comments

Brendan Tompkins said:

This is interesting, I got this message:

A future version of SQL Server will disallow usage of '*' in functions and views.

Cool.

# June 14, 2004 8:33 AM

Grant said:

Dude, SQL Server 2000 is soooo last century. Just the same, I'll try this tool out. Thanks.

Good finally meeting you at the cric-nic this weekend!

# June 14, 2004 9:27 AM

Brendan Tompkins said:

He he... Didn't you notice my hair? I'm waay last century.

# June 14, 2004 9:28 AM

Andrew Whitten said:

Definately cheaper than hiring a Sql Server consultant ;)
I am using this on the schema that sits as the the core in my company's product. It highlighted many interesting points.
If there is a similer tool for IIS 6, my setup would be complete!

# June 14, 2004 10:17 AM

Paul Laudeman said:

Don't forget to check out the latest MSDN TV epsiode on this tool!

http://msdn.microsoft.com/msdntv/episode.aspx?xml=episodes/en/20040610sqlserverck/manifest.xml

# June 14, 2004 11:37 AM

Name (required)

Your URL (optional)

Comments (required)

Remember Me?

Enter the numbers above:

Add

About Brendan Tompkins

Brendan has been programming with .NET since the first public beta and is owner and operator of Port Technology Services, a consultancy company providing .NET application development services to the Maritime industry. In July, 2007, he was awarded the Microsoft MVP award for ASP.NET. He's also a proud co-founder of failed .COM startup Intrinsigo, and has had a hand in the failure of numerous other businesses. He currently runs CodeBetter.Com and Devlicio.us, and lives in Norfolk, Virgina with his wife Tiara and son Ian.