Search results matching tags 'Performance', 'People', and 'Conference'http://sqlblog.com/search/SearchResults.aspx?o=DateDescending&tag=Performance,People,Conference&orTags=0Search results matching tags 'Performance', 'People', and 'Conference'en-USCommunityServer 2.1 SP2 (Build: 61129.1)Understanding Execution Planshttp://sqlblog.com/blogs/hugo_kornelis/archive/2013/12/12/understanding-execution-plans.aspxThu, 12 Dec 2013 21:19:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:52126Hugo Kornelis<p>To me, it feels as if 2014 is a long time away. But it isn’t. <a href="http://en.wikipedia.org/wiki/Sinterklaas" mce_href="http://en.wikipedia.org/wiki/Sinterklaas">Sinterklaas</a> has already dropped off his presents and is probably already back in his castle in Spain. Christmas is almost upon us. And before we know it, we’ll be washing <a href="http://en.wikipedia.org/wiki/Oliebol" mce_href="http://en.wikipedia.org/wiki/Oliebol">oliebollen</a> down with <a href="http://en.wikipedia.org/wiki/Champagne" mce_href="http://en.wikipedia.org/wiki/Champagne">Champagne</a>.</p> <p>That also means that I need to get cracking on preparing my precon seminar on execution plans. What precon seminar you say? Oh right – I didn’t tell you yet. The good folks organizing <a href="http://www.sqlsaturday.com/269/eventhome.aspx" mce_href="http://www.sqlsaturday.com/269/eventhome.aspx">SQL Saturday #269 in Exeter (UK)</a> (on March 22) have decided to extend the event with a full training day on Friday March 21. For that purpose, they invited eight of the best SQL Server speakers in the world, and me, to spend a whole day pouring our knowledge into other people’s heads.</p> <p>The full program for this excellent day can be found <a href="http://sqlsouthwest.co.uk/sql-saturday-269-precon-training-day-details/" mce_href="http://sqlsouthwest.co.uk/sql-saturday-269-precon-training-day-details/">here</a> – and believe me, if I was not speaking that day, I would be trying to clone myself and visit at least four of them!</p> <p><a href="http://sqlsouthwest.co.uk/hugo-kornelis-profile-and-session-details/" mce_href="http://sqlsouthwest.co.uk/hugo-kornelis-profile-and-session-details/">My session</a> on that day, as you can see, focuses on execution plans. So what can you expect if you sign up? Here is a short overview.</p> <p>I will start with the bare basics. What is an execution plan, what is its role in a SQL Server database, and most of all – how can you get to see it, how do you start reading it (Left to right? Right to left?), and how do you get to those extremely interesting details that Microsoft has carefully hidden from view? Why is an estimated plan not estimated, why is an actual plan actually mostly an estimated plan? What is an iterator, what does it do, and how does it interact with other operators?</p> <p>After that, we’ll dive into the details. What is a seek, what is a scan? How do you notice when a seek secretly scans, and why should you care? Why do people say scans are bad, and why are they wrong? (Or, maybe even more important, <b>WHEN</b> are they wrong, and when not?)</p> <p>Next up are the joins. Inner, outer, loop, merge, hash – but also semi, and anti semi. Yes, those are all join types, and we will explore them all. How do they work, what are the benefits and what are the costs of all of them? How can you influence the type of join chosen, and why would you want to?</p> <p>All that, and much more, will be included in my seminar. And that’s just what I have planned for <i>before</i> lunch. At the end of the day, you can expect to have a good working knowledge of almost every iterator that you can encounter in an execution plan. I will also explain what has changed in execution plans in SQL Server 2012 and SQL Server 2014. And to ensure that nobody falls asleep from my constant talking, I will give you all some exercises in between, challenging you to immediately apply what you just learned. These exercises may not be the kind of exercises you expect - but trust me, you will find them to be fun and refreshing, and they will also learn you how to apply your knowledge to all kinds of problems.<br></p> <p>Does this sounds interesting or useful at all to you? I hope so – why else are you on a SQL Server blog site? So get cracking – <a href="https://sqlsouthwest.sharepoint.com/_layouts/15/WopiFrame.aspx?guestaccesstoken=Svcf%2b1fS2UNWvqmIo%2b4QMHnQwC3HwFFQumUI8pM%2fpAw%3d&amp;docid=1_1f6ec6454084e4707babeb1ef68201aee&amp;wdFormId=%7b392D80F9-4C85-47F2-B457-D262E005B152%7d&amp;action=formsubmit" mce_href="https://sqlsouthwest.sharepoint.com/_layouts/15/WopiFrame.aspx?guestaccesstoken=Svcf%2b1fS2UNWvqmIo%2b4QMHnQwC3HwFFQumUI8pM%2fpAw%3d&amp;docid=1_1f6ec6454084e4707babeb1ef68201aee&amp;wdFormId=%7b392D80F9-4C85-47F2-B457-D262E005B152%7d&amp;action=formsubmit">click this link</a> and sign up for my precon right now. (Or for one of the other precons – they are all great!) If you do so soon enough, you can still apply for the special “Early Bird” rate of only £150 – which is valid until December 15. But don’t despair if you see this post later – from December 16 until February 28, you still only pay £185 – still a steal for a whole day of training! (Even the £200 last minute rate that applies from March 1<sup>st</sup> is great value – but honestly, why wait?)</p> <p>I am looking forward to visiting Exeter this March. I hope to see all of you there. Either in my precon – or if you choose to attend one of the other precons, then maybe in one of the many sessions that will take place the next day.</p>SQLRally and SQLRally - Session materialhttp://sqlblog.com/blogs/hugo_kornelis/archive/2013/11/09/sqlrally-and-sqlrally-session-material.aspxSat, 09 Nov 2013 12:41:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:51662Hugo Kornelis<p>I had a great week last week. First at <a href="http://www.sqlpass.org/sqlrally/2013/nordic/Home.aspx" mce_href="http://www.sqlpass.org/sqlrally/2013/nordic/Home.aspx">SQLRally Nordic</a>, in Stockholm, where I presented a session on how improvements to the OVER clause can help you simplify queries in SQL Server 2012 enormously. And then I continued straight on into <a href="http://www.sqlpass.org/sqlrally/2013/amsterdam/Home.aspx" mce_href="http://www.sqlpass.org/sqlrally/2013/amsterdam/Home.aspx">SQLRally Amsterdam</a>, where I delivered a session on the performance implications of using user-defined functions in T-SQL.</p> <p>I understand that both events will make my slides and demo code downloadable from their website, but this may take a while. So those who do not want to wait can download the material from this blog post.</p> <p>Both SQLRally events have recorded all their sessions. It will obviously take a while to edit and publish all those recordings – but those who missed my session and want to check it out with my explanations know that if they wait a while, they can watch the recording online on the SQLRally websites.</p> <p>I once more would like to thank all volunteers who organized these events, all the sponsors who helped fund them … and most of all, all attendees who made my time in Stockholm and Amsterdam amazing. You were a great crowd, both during my session and in the many chats I had during the breaks.</p>Decks and demos – Session material for Silicon Valley Code Camphttp://sqlblog.com/blogs/hugo_kornelis/archive/2013/10/05/decks-and-demos-session-material-for-silicon-valley-code-camp.aspxSat, 05 Oct 2013 04:38:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:51219Hugo Kornelis<p>This weekend, I will be presenting two sessions at <a href="http://www.siliconvalley-codecamp.com/" mce_href="http://www.siliconvalley-codecamp.com/">Silicon Valley Code Camp</a>, in Los Altos Hills, CA. On Saturday, I will have an early start – the first time slot of the day, at 9:45 AM, I will present on how <a href="http://www.siliconvalley-codecamp.com/Session/2013/t-sql-user-defined-functions-or-bad-performance-made-easy" mce_href="http://www.siliconvalley-codecamp.com/Session/2013/t-sql-user-defined-functions-or-bad-performance-made-easy">T-SQL user-defined functions</a> can easily wreck your performance – and how you can prevent that.</p> <p>On Sunday afternoon (1:15 PM), I will then present <a href="http://www.siliconvalley-codecamp.com/Session/2013/powerful-t-sql-improvements-that-reduce-query-complexity" mce_href="http://www.siliconvalley-codecamp.com/Session/2013/powerful-t-sql-improvements-that-reduce-query-complexity">a session on the OVER clause</a>, focusing on how both the SQLL Server 2005 version and the enhanced SQL Server 2012 syntax of this feature can help you solve common problems without having to resort to ill-performing and unmaintainable monster queries.</p> <p>Both sessions are quite demo-heavy, so I hope a lot of attendees will download the demo code and play with it for themselves. I have therefor attached the demo code for these sessions to this post. Oh, and the slide deck is included as well.</p>SQLRally Nordic 2012 – session materialhttp://sqlblog.com/blogs/hugo_kornelis/archive/2012/10/05/sqlrally-nordic-2012-session-material.aspxFri, 05 Oct 2012 16:49:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:45456Hugo Kornelis<p>As some of you might know, I have been to <a href="http://www.sqlpass.org/sqlrally/2012/nordic/">SQLRally Nordic 2012</a> in Copenhagen earlier this week. I was able to attend many interesting sessions, I had a great time catching up with old friends and meeting new people, and I was allowed to present a session myself.</p> <p>I understand that the PowerPoint slides and demo code I used in my session will be made available through the SQLRally website – but I don’t know how long it will take the probably very busy volunteers to do so. And I promised my attendees to make them available through my blog as well.</p> <p>So, here they are, for everyone to download, see, and play with. Though, in all honesty, I expect people who were not present at my session to get very little out of this material.</p> <p>(I’m not sure, but I *think* that the SQLRally organization will also make a recording of my session available. If that is true, then once it’s up the slides and demo code should make a lot more sense to anyone who is able to view the recording).</p> <p>I know I’ve said it before, but I can’t repeat this often enough – thanks to everyone involved with the organization of SQLRally for creating a truly wonderful event, and thanks to all the attendees who took the time and energy to come to my session and listen to me.</p>Going to Dublinhttp://sqlblog.com/blogs/hugo_kornelis/archive/2007/06/04/going-to-dublin.aspxMon, 04 Jun 2007 21:38:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:1417Hugo Kornelis<P class=MsoNormal style="MARGIN:0cm 0cm 0pt;"><SPAN style="mso-ansi-language:en-us;"><FONT size=3><FONT face="Times New Roman">I still lack the time to blog about proper hardcore SQL stuff, but I do want to make a quick post to let you all know about a great conference that I’ll be attending and speaking at.<o:p></o:p></FONT></FONT></SPAN></P>
<P class=MsoNormal style="MARGIN:0cm 0cm 0pt;"><SPAN style="mso-ansi-language:en-us;"><o:p><FONT face="Times New Roman" size=3>&nbsp;</FONT></o:p></SPAN></P>
<P class=MsoNormal style="MARGIN:0cm 0cm 0pt;"><SPAN style="mso-ansi-language:en-us;"><FONT face="Times New Roman" size=3>I’m talking about the </FONT><A href="http://imtc.firstport.ie/default.aspx"><FONT face="Times New Roman" color=#800080 size=3>Irish Microsoft Technology Conference</FONT></A><FONT size=3><FONT face="Times New Roman">, to be held in Dublin, Ireland later this week (June 7<SUP>th</SUP>, to be precise). I am particularly excited about this conference, not only because it marks my first speaking engagement outside the Netherlands, but also because (unlike some other conferences I have attended) there is actually a pretty decent number of SQL Server related sessions.<o:p></o:p></FONT></FONT></SPAN></P>
<P class=MsoNormal style="MARGIN:0cm 0cm 0pt;"><SPAN style="mso-ansi-language:en-us;"><o:p><FONT face="Times New Roman" size=3>&nbsp;</FONT></o:p></SPAN></P>
<UL style="MARGIN-TOP:0cm;">
<LI class=MsoNormal style="MARGIN:0cm 0cm 0pt;mso-list:l0 level1 lfo1;tab-stops:list 36.0pt;"><SPAN style="mso-ansi-language:en-us;"><FONT size=3><FONT face="Times New Roman">Simon Sabin (SQL Server MVP) will deliver a talk on using Service Broker to process work asynchronously,<o:p></o:p></FONT></FONT></SPAN></LI>
<LI class=MsoNormal style="MARGIN:0cm 0cm 0pt;mso-list:l0 level1 lfo1;tab-stops:list 36.0pt;"><SPAN style="mso-ansi-language:en-us;"><FONT size=3><FONT face="Times New Roman">Alan Crowley has a presentation on Visual Studio for Database Professionals (The Artist Formerly Known As Datadude)<o:p></o:p></FONT></FONT></SPAN></LI>
<LI class=MsoNormal style="MARGIN:0cm 0cm 0pt;mso-list:l0 level1 lfo1;tab-stops:list 36.0pt;"><SPAN style="mso-ansi-language:en-us;"><FONT size=3><FONT face="Times New Roman">And I even get the stage twice; my first session tries to help you understand how indexes can speed up (or slow down) query execution, and my other sessions explores the possibilities and impossibilities of CLR User-Defined Types.<o:p></o:p></FONT></FONT></SPAN></LI></UL>
<P class=MsoNormal style="MARGIN:0cm 0cm 0pt;"><SPAN style="mso-ansi-language:en-us;"><o:p><FONT face="Times New Roman" size=3>&nbsp;</FONT></o:p></SPAN></P>
<P class=MsoNormal style="MARGIN:0cm 0cm 0pt;"><FONT size=3><SPAN style="mso-ansi-language:en-us;"><FONT face="Times New Roman">The conference will be held in three rooms, so there are plenty of other sessions to choose from. But even if you are only interested in SQL Server, this conference is pretty good value for money – for only € 50, you have the chance to attend no less than four SQL Server oriented sessions (in the preliminary version of the agenda I received, none of them overlap). Plus, you get to experience the great weather of the British Isles! </FONT></SPAN><SPAN style="FONT-FAMILY:wingdings;mso-ansi-language:en-us;mso-ascii-font-family:'Times New Roman';mso-hansi-font-family:'Times New Roman';mso-char-type:symbol;mso-symbol-font-family:wingdings;"><SPAN style="mso-char-type:symbol;mso-symbol-font-family:wingdings;">J</SPAN></SPAN><SPAN style="mso-ansi-language:en-us;"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN:0cm 0cm 0pt;"><SPAN style="mso-ansi-language:en-us;"><o:p><FONT face="Times New Roman" size=3>&nbsp;</FONT></o:p></SPAN></P>
<P class=MsoNormal style="MARGIN:0cm 0cm 0pt;"><SPAN style="mso-ansi-language:en-us;"><FONT face="Times New Roman" size=3>If you want to attend, </FONT><A href="http://imtc.firstport.ie/book.aspx"><FONT face="Times New Roman" color=#800080 size=3>book now</FONT></A><FONT size=3><FONT face="Times New Roman"> – I have no idea how long <SPAN style="FONT-SIZE:12pt;FONT-FAMILY:'Times New Roman';mso-ansi-language:EN-US;mso-fareast-font-family:'Times New Roman';mso-fareast-language:NL;mso-bidi-language:AR-SA;">you have left </SPAN>until they’re sold out!</FONT></FONT></SPAN></P>