Jeremiah Peschka helps developers, DBAs, and engineers build faster, robust, and scalable solutions; Microsoft SQL Server is frequently a part of that solution, but he is familiar with more than just the database. Throughout his career Jeremiah has focused on combining the best tools and technology to solve the task at hand, no matter what those tools and technologies are. Jeremiah has been a system administrator, developer, and DBA on more systems than he'd care to admit. Jeremiah has a history of applying new tools to old problems, explaining the solution in a fun way, and getting everyone working together to solve the problem. He can be contacted through his blog (http://www.brentozar.com/consultants/jeremiah-peschka/) or on Twitter (http://twitter.com/#!/peschkaj).
SQL Server's functions are a valuable addition to TSQL when used wisely. Jeremiah provides a complete and comprehensive guide to scalar functions and table-valued functions, and shows how and where they are best used.… Read more