Eric Z Beard

Eric Z Beard has asked 38 questions and find answers to 72 problems.

Stats

About

I recently moved from Florida to Seattle, Washington, where I am working for Amazon as a solutions architect in the AWS partner network.

Eric Z Beard questions

Anyone have experience with Sphinx speech recognition?
How do you minimize the number of threads used in a tcp server application?
base64 to guid to base64
What's a good way to encapsulate data access with PHP/MySQL?
Why does the SqlServer optimizer get so confused with parameters?
How do you convert the number you get from datepart to the name of the day?
What are best practices for using thread local storage in .NET?
Which ORM framework can best handle an MVCC database design?
What's a good design pattern for web method return values?
What are some good strategies to allow deployed applications to be hotfixable?

Eric Z Beard answers

What's the best way to insert/update/delete multiple records in a database from an application?
Deleting Database Rows and their References-Best Practices
HashBytes() Function T-SQL
Is there ever any reason not to take the advice of the Database Engine Tuning Advisor?
What is the best method for checking if a file exists from a SQL Server 2005 stored procedure?
Create object from database row
Profiling SQL Server and/or ASP.NET
send e-mail and check status
Determine Time Zone Offset in T-SQL
How can I print a binary value as hex in TSQL?