<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://sqlblog.com/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>Search results matching tags 'SQL Server 2005' and 'New England'</title><link>http://sqlblog.com/search/SearchResults.aspx?o=DateDescending&amp;tag=SQL+Server+2005,New+England&amp;orTags=0</link><description>Search results matching tags 'SQL Server 2005' and 'New England'</description><dc:language>en-US</dc:language><generator>CommunityServer 2.1 SP2 (Build: 61129.1)</generator><item><title>[New England] Kalen Delaney Internals and Query Tuning - in the Boston area October 12-16</title><link>http://sqlblog.com/blogs/adam_machanic/archive/2009/07/23/new-england-kalen-delaney-internals-and-query-tuning-in-the-boston-area-october-12-16.aspx</link><pubDate>Thu, 23 Jul 2009 14:16:00 GMT</pubDate><guid isPermaLink="false">21093a07-8b3d-42db-8cbf-3350fcbf5496:15439</guid><dc:creator>Adam Machanic</dc:creator><description>&lt;p&gt;In case you missed&lt;a href="http://sqlblog.com/blogs/kalen_delaney/archive/2009/05/19/public-course-in-boston.aspx"&gt; Kalen's post&lt;/a&gt;, we're excited to announce that she will be joining us here on the East Coast in October to deliver her &lt;a href="http://bostonsqltraining.com/course.aspx"&gt;SQL Server 2005/2008 Internals and Query Tuning&lt;/a&gt; seminar. This is, to my knowledge, the most advanced public SQL Server course to be offered in the Boston area in the last 5 years, and this is the first time that Kalen has ever taught in the area. I hope that some of you will be able to take advantage of this rare opportunity to really take your SQL Server skills to the next level.&lt;/p&gt;&lt;p&gt;The course location is the &lt;a href="http://bostonsqltraining.com/location.aspx"&gt;Microsoft Technology Center in Waltham, MA&lt;/a&gt;, and the course will run from Monday October 12 through Friday October 16. You can get more information about the course &lt;a href="http://bostonsqltraining.com/course.aspx"&gt;from the Web site&lt;/a&gt;, but following is an overview:&lt;/p&gt;&lt;blockquote&gt;&lt;p&gt;&lt;font size="2"&gt;&lt;span style="color:black;"&gt;This is an advanced 5-day
course designed for advanced SQL Server professionals. The course
includes extensive demonstrations that illustrate the details of SQL
Server internals as well as tuning techniques. This course will be
presented on SQL Server 2008 and cover features specific to that
version, but most of the information is relevant to SQL Server 2005 as
well. &lt;/span&gt;&lt;/font&gt;&lt;/p&gt;
&lt;p&gt;&lt;font size="2"&gt;&lt;span style="color:black;"&gt;This 5-day intensive
seminar was developed by one of the world's leading experts in SQL
Server internals. Topics to be covered include the following: &lt;/span&gt;&lt;/font&gt;&lt;/p&gt;
&lt;ul&gt;&lt;li class="MsoNormal" style="color:black;"&gt;&lt;font size="2"&gt;SQL Server Architecture and Metadata &lt;/font&gt;
&lt;/li&gt;&lt;li class="MsoNormal" style="color:black;"&gt;&lt;font size="2"&gt;Physical Storage Structures &lt;/font&gt;
&lt;/li&gt;&lt;li class="MsoNormal" style="color:black;"&gt;&lt;font size="2"&gt;Index Design and Tuning &lt;/font&gt;
&lt;/li&gt;&lt;li class="MsoNormal" style="color:black;"&gt;&lt;font size="2"&gt;Query Processing and Query Plans &lt;/font&gt;
&lt;/li&gt;&lt;li class="MsoNormal" style="color:black;"&gt;&lt;font size="2"&gt;Optimization and Recompilation &lt;/font&gt;
&lt;/li&gt;&lt;li class="MsoNormal" style="color:black;"&gt;&lt;font size="2"&gt;Concurrency Control: Locking, Blocking and Row Level Versioning &lt;/font&gt;
&lt;/li&gt;&lt;li class="MsoNormal" style="color:black;"&gt;&lt;font size="2"&gt;Query Tips and Techniques &lt;/font&gt;
&lt;/li&gt;&lt;li class="MsoNormal" style="color:black;"&gt;&lt;font size="2"&gt;Troubleshooting Tools &lt;/font&gt;&lt;/li&gt;&lt;/ul&gt;
&lt;p&gt;&lt;font size="2"&gt;&lt;span style="color:black;"&gt;The course includes
extensive demonstrations that illustrate the details of SQL Server
internals as well as performance tuning techniques. A reference CD
including all of the demonstration scripts as well as dozens of
whitepapers and useful tools will be distributed at the end of the week.&lt;/span&gt;&lt;/font&gt;&lt;/p&gt;&lt;/blockquote&gt;&lt;p&gt;If you would like to register, you can do so &lt;a href="http://bostonsqltraining.com/register.aspx"&gt;on the registration page&lt;/a&gt;. If you have any questions, feel free to write a message here, contact me via my blog, or via the&amp;nbsp; e-mail address on the &lt;a href="http://bostonsqltraining.com/default.aspx"&gt;Boston SQL Training front page&lt;/a&gt;. &lt;br&gt;&lt;/p&gt;</description></item></channel></rss>