THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web
Browse by Tags
SQL Server 2000
SQL Server 2008
SQL Server Best Practices: Protect CmdExec
In SQL Server, there are times that you need to do things in the operating system, and to allow that there is a feature called CmdExec. This is not always a good thing –whenever you leave the confines of SQL Server and go out to the operating system, you can cause issues, not the least of which are security-related. This best practice is ...
December 3, 2009
After the Upgrade, it runs differently…
I got a question yesterday in the mail that I thought I would just answer here in a broad context. While I can’t troubleshoot or do performance tuning from a distance, there are some interesting concepts and suggestions this e-mail brings up: “I have recently seen a change from SQL Server from 2005 to 2008 in where it handles CASE statements ...
December 1, 2009
Brought to you by