Eric Z Beard

Eric Z Beard has asked 37 questions and find answers to 70 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

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?
How can I copy a large file on Windows without CopyFile or CopyFileEx?

Eric Z Beard answers

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?
What is the "< >" syntax within C#
Why should events in C# take (sender, EventArgs)?