{"id":998,"date":"2014-04-04T14:37:32","date_gmt":"2014-04-04T19:37:32","guid":{"rendered":"https:\/\/anildesai.net\/?p=998"},"modified":"2014-04-16T08:34:53","modified_gmt":"2014-04-16T13:34:53","slug":"sql-server-optimization-for-developers-presentation-in-austin-tx","status":"publish","type":"post","link":"https:\/\/anildesai.net\/index.php\/2014\/04\/sql-server-optimization-for-developers-presentation-in-austin-tx\/","title":{"rendered":"SQL Server Optimization for Developers Presentation in Austin, TX"},"content":{"rendered":"<p><a href=\"https:\/\/anildesai.net\/wp-content\/uploads\/2014\/04\/image.png\"><img loading=\"lazy\" decoding=\"async\" title=\"image\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; float: left; padding-top: 0px; padding-left: 0px; margin: 4px 10px; display: inline; padding-right: 0px; border-top-width: 0px\" border=\"0\" alt=\"image\" src=\"https:\/\/anildesai.net\/wp-content\/uploads\/2014\/04\/image_thumb.png\" width=\"244\" align=\"left\" height=\"58\" \/><\/a>On April 14th, 2014, I\u2019ll be presenting a session titled, \u201cSQL Server Optimization for Developers\u201d to the Austin .NET User Group.&#160; The free event will opportunities for networking, food and drinks, and (of course) a presentation. <\/p>\n<p>Here\u2019s a brief overview of the topic and the presentation:<\/p>\n<blockquote>\n<p>Database optimization is a critical component of overall application performance, and sub-optimal configurations can limit reliability, scalability, and the user experience. Unfortunately, many developers see database monitoring and optimization as a black art \u2013 something that\u2019s better left to production and operations specialists. This presentation will focus on practical, real-world methods for monitoring and optimizing performance for SQL Server-based applications. Demonstrations will include understanding index types, capturing query data with SQL Profiler, analyzing indexes and using the Database Engine Tuning Advisor. In addition to live demos the content will focus on managing locking, managing schema changes, and application design best practices for developers.<\/p>\n<\/blockquote>\n<p>If you\u2019re in the Austin area, I hope to see you there!<\/p>\n<p><strong><u>Update<\/u><\/strong>: You can download the slides from the presentation from my <a href=\"https:\/\/anildesai.net\/index.php\/presentations\/sql-server-presentations\/\">SQL Server Presentations<\/a> page.&#160; And, coming soon: A full recording of the session, courtesy of <a href=\"http:\/\/usergroup.tv\/?s=anil+desai&amp;x=0&amp;y=0\">UserGroup.tv<\/a> (thanks, Shawn!).&#160; Thanks to everyone for attending!<\/p>\n<p><strong><u>Update 2<\/u><\/strong>: The entire recorded presentation has been posted on UserGroup.tv: <a href=\"http:\/\/usergroup.tv\/videos\/sql-server-optimization-for-developers\">SQL Server Optimization for Developers<\/a>, along with <a href=\"http:\/\/usergroup.tv\/videos\/category\/speaker\/anil-desai\">my previous videos<\/a>.&#160; Thanks, as always, to Shawn for recording the session.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>On April 14th, 2014, I\u2019ll be presenting a session titled, \u201cSQL Server Optimization for Developers\u201d to the Austin .NET User Group.&#160; The free event will opportunities for networking, food and drinks, and (of course) a presentation. Here\u2019s a brief overview of the topic and the presentation: Database optimization is a critical component of overall application [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[29,28,26,36],"tags":[],"class_list":["post-998","post","type-post","status-publish","format-standard","hentry","category-databases-sql-server","category-development","category-general","category-presentations"],"_links":{"self":[{"href":"https:\/\/anildesai.net\/index.php\/wp-json\/wp\/v2\/posts\/998","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/anildesai.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/anildesai.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/anildesai.net\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/anildesai.net\/index.php\/wp-json\/wp\/v2\/comments?post=998"}],"version-history":[{"count":4,"href":"https:\/\/anildesai.net\/index.php\/wp-json\/wp\/v2\/posts\/998\/revisions"}],"predecessor-version":[{"id":1006,"href":"https:\/\/anildesai.net\/index.php\/wp-json\/wp\/v2\/posts\/998\/revisions\/1006"}],"wp:attachment":[{"href":"https:\/\/anildesai.net\/index.php\/wp-json\/wp\/v2\/media?parent=998"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/anildesai.net\/index.php\/wp-json\/wp\/v2\/categories?post=998"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/anildesai.net\/index.php\/wp-json\/wp\/v2\/tags?post=998"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}