Anthony Bloesch's Web Log

A WebLog about SQL Server development.

Browse by Tags

Tagged Content List
  • Blog Post: Finding and stopping rogue SQL traces

    Introduction A common cause of mysterious performance issues are traces that have been left running. Naïve use of traces can leave many traces running—traces that are slowing down the application by consuming critical resources. This happens because the SQL Server Performance Analyzer process...
  • Blog Post: SQL Server performance investigation

    Introduction I frequently help teams inside and outside of Microsoft investigate SQL Server database performance issues. As well, I monitor some large internal SharePoint databases to understand their performance characteristics and to make sure we are improving our overall performance. Here are some...
  • Blog Post: Top 25 most dangerous programming errors

    The paper “ Top 25 Most Dangerous Programming Errors ” ( http://cwe.mitre.org/top25 ) is an interesting study of the families of programming errors that lead to security issues. The paper is based on input from a wide variety of security experts and is worth reading. The complete list of errors is at...
  • Blog Post: T-SQL casing conventions feedback

    Thanks everyone for the great blog and email comments on how we should deal with T-SQL casing conventions. There was a lot of interesting feedback on casing conventions for T-SQL. In summary, the main feedback was Default capitalization should follow the documentation Capitalization has...
Page 1 of 1 (4 items)