Choosing the right edition of SQL Server 2008: Enterprise, Standard, Workgroup, Compact and Express, what each is built for, plus feature comparison links.
SQLAuthority Download – Providing Security for Web Applications and Infrastructure: Best Practices for Managing Security Risks
A Microsoft deck on security for web applications and infrastructure from the Windows Live team, plus simple database checks you can use today.
SQLAuthority News – SQL SERVER Database Administrator Job Description
An updated SQL Server Database Administrator Job Description: support for the database environment, new technology, reliability and long-term planning.
SQL SERVER – Ideal TempDB FileGrowth Value
What is a good TempDB FileGrowth value? Here are simple size-based guidelines, from 10 MB growth for small files to 10 percent for large ones.
SQL SERVER – Find Table in Every Database of SQL Server – Part 3
Part 3 of Find Table in Every Database: Greg Steinkuhler shares a stored procedure that also searches servers across the network, where sp_msforeachdb could not.
SQL SERVER – SQL Joke, SQL Humor, SQL Laugh – Silly Mistake
A developer lost a backup, and the forum replies turned into dark SQL humor: write a resignation letter, or make vendors block DELETE without a WHERE clause.
SQL SERVER – Orphaned MS DTC Transaction Information
An orphaned MS DTC transaction kept crashing our IIS application pool. A quick script on sys.syslockinfo shows if you have one, and a Microsoft hotfix solved it.
SQL SERVER – Four Basic SQL Statements – SQL Operations
The four basic SQL statements are SELECT, UPDATE, INSERT and DELETE. A short note on what each one does, with a link to my one page FAQ sheet for full syntax.
SQL SERVER – SQL SERVER – Comparison : Similarity and Difference #TempTable vs @TempVariable – Part 2
Can a temp table have indexes? Yes. In Part 2 of #TempTable vs @TempVariable, I explain how temporary table indexes live in TempDB and when they help.
SQL SERVER 2005 – Microsoft Will Release SP3 Soon
Is Microsoft going to release SP3 for SQL Server 2005? Yes, SP3 is coming very soon. The exact date is not announced yet, but the announcement is out.