Search results matching tag 'SQLBits'http://www2.sqlblog.com/search/SearchResults.aspx?o=DateDescending&tag=SQLBits&orTags=0Search results matching tag 'SQLBits'en-USCommunityServer 2.1 SP2 (Build: 61129.1)SQL Sentry Grows in the UK and Beyondhttp://www2.sqlblog.com/blogs/kevin_kline/archive/2015/08/07/sql-sentry-grows-in-the-uk-and-beyond.aspxFri, 07 Aug 2015 19:27:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:59295KKline<p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;font-size:16px;line-height:24px;"><em style="font-family:Arial, Helvetica, sans-serif;font-size:10pt;"><span style="font-size:11pt;font-family:Georgia, serif;background-image:initial;background-attachment:initial;background-size:initial;background-origin:initial;background-clip:initial;background-position:initial;background-repeat:initial;">Originally
appearing at </span></em><span style="font-size:11pt;font-family:Calibri, sans-serif;"><a href="http://blogs.sqlsentry.com/"><i><span style="font-family:Georgia, serif;background-image:initial;background-attachment:initial;background-size:initial;background-origin:initial;background-clip:initial;background-position:initial;background-repeat:initial;">Blogs.SQLSentry.com</span></i></a></span><em style="font-family:Arial, Helvetica, sans-serif;font-size:10pt;"><span style="font-size:11pt;font-family:Georgia, serif;background-image:initial;background-attachment:initial;background-size:initial;background-origin:initial;background-clip:initial;background-position:initial;background-repeat:initial;">.&nbsp;</span></em><em><span style="font-size:11pt;font-family:Georgia, serif;background-image:initial;background-attachment:initial;background-size:initial;background-origin:initial;background-clip:initial;background-position:initial;background-repeat:initial;">Read
the full post&nbsp;<a href="http://blogs.sqlsentry.com/kevinkline/sql-sentry-adds-two-powerhouse-technology-evangelists-in-the-uk/">HERE</a>.</span></em><br>- - -</p><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;font-size:16px;line-height:24px;">I am pleased to announce we are hiring TWO new sales engineers residing in Great Britain to start on Monday, August 10th:&nbsp;John Martin (<a href="http://twitter.com/sqlservermonkey">@sqlservermonkey</a>) and Richard Douglas (<a href="http://twitter.com/sqlrich">@sqlrich</a>). (See Richard's post&nbsp;<a href="http://sql.richarddouglas.co.uk/archive/2015/08/career-progression.html#axzz3i8g8SFzX">HERE</a>).</p><div class="mceTemp" style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;font-size:16px;line-height:24px;"><a style="-webkit-user-drag:none;" href="https://www.linkedin.com/profile/view?id=14926054&amp;authType=NAME_SEARCH&amp;authToken=QryE&amp;locale=en_US&amp;trk=tyah&amp;trkInfo=clickedVertical%3Amynetwork%2CclickedEntityId%3A14926054%2CauthType%3ANAME_SEARCH%2Cidx%3A1-1-1%2CtarId%3A1438958069799%2Ctas%3Ajohn%20mar"><img class="" alt="" width="140" height="140" style="margin:0px;padding:0px;border:0px none;-webkit-user-drag:none;" src="https://media.licdn.com/media/p/2/000/025/281/09e9ab2.jpg"></a>John Martin</div><div class="mceTemp" style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;font-size:16px;line-height:24px;"><a style="-webkit-user-drag:none;" href="https://www.linkedin.com/profile/view?id=21837191&amp;authType=NAME_SEARCH&amp;authToken=w6Nx&amp;locale=en_US&amp;trk=tyah&amp;trkInfo=clickedVertical%3Amynetwork%2CclickedEntityId%3A21837191%2CauthType%3ANAME_SEARCH%2Cidx%3A1-1-1%2CtarId%3A1438958367871%2Ctas%3ARichard"><img class="" alt="" width="139" height="139" style="margin:0px;padding:0px;border:0px none;-webkit-user-drag:none;" src="https://media.licdn.com/mpr/mpr/shrinknp_400_400/p/1/000/114/0a0/3d58255.jpg"></a>Richard Douglas</div><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;font-size:16px;line-height:24px;">John and Richard come to us with impeccable credentials, outstanding technology skills, a long history of community activism and unimpeachable ethics. These gentlemen are among the best of the best.</p><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;font-size:16px;line-height:24px;">Their list of achievements and accolades are long (click on their pictures to see their LinkedIn profiles). But here are a handful that come immediately to mind:</p><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;font-size:16px;line-height:24px;padding-left:30px;">- They are literally masters of SQL Server, with long careers as database administrators.<br>- They actively support, from their own time, local user groups in the UK, SQL Saturday events, and large UK-wide events like&nbsp;<a href="http://www.sqlrelay.co.uk/">SQLRelay</a>&nbsp;and&nbsp;<a href="http://www.sqlbits.com/">SQLBits</a>.<br>- They are internationally recognition as speakers at events like&nbsp;<a href="http://www.sqlbits.com/">SQLBits</a>,&nbsp;<a href="http://www.sqlcruise.com/">SQLCruise</a>,&nbsp;<a href="http://www.sqlrelay.co.uk/">SQLRelay</a>, SQL Rally, and&nbsp;<a href="http://www.sqlsaturday.com/">SQL Saturday</a>.<br>- They have sterling reputations as talented customer-facing staff at Microsoft and Dell Software, respectively.<br>- Wicked senses of humor.</p><h2 style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;"></h2><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;font-size:16px;line-height:24px;">John and Richard are the foundation for the dynamic growth we’re experiencing in the UK, Europe and beyond. While our past growth has been explosive, our future&nbsp;<em>global</em>&nbsp;growth is entirely dependent on the quality of our team on the ground. We are incredibly excited to have such talent joining&nbsp;<a href="http://www.sqlsentry.com/">SQL Sentry</a>.</p><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;font-size:16px;line-height:24px;">Their skills and enthusiasm will make a measurable difference for our customers, our community, and our company&nbsp;every day. And, as we continue to grow around the world, John and Richard will act as our vanguard and flag-bearers, sharing their knowledge at more community events than ever before, connecting more often with our global community than ever before, and driving&nbsp;more value back into our products than ever before.</p><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;font-size:16px;line-height:24px;">Please join me in welcoming them to the SQL Sentry family! Thanks,</p><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;font-size:16px;line-height:24px;">-Kevin</p><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;font-size:16px;line-height:24px;"><em>Connect with me online!&nbsp;</em><a href="http://www.facebook.com/kekline"><em>Facebook</em></a><em>&nbsp;|&nbsp;</em><a href="http://twitter.com/kekline"><em>Twitter</em></a><em>&nbsp;|&nbsp;</em><a href="http://www.linkedin.com/in/kekline"><em>LinkedIn</em></a><em>&nbsp;|&nbsp;</em><a href="http://kevinekline.com/"><em>Blog</em></a><em>&nbsp;|&nbsp;</em><a href="http://www.slideshare.net/kkline84"><em>SlideShare</em></a><em>&nbsp;|&nbsp;</em><a href="http://www.youtube.com/user/KevinEKline"><em>YouTube</em></a>&nbsp;|&nbsp;<a href="https://plus.google.com/u/1/113032055249023350257?rel=author"><em>Google Author</em></a></p>SQLBits 2015 - Query Tuning Mastery: Clash of the Row Goals - Demoshttp://www2.sqlblog.com/blogs/adam_machanic/archive/2015/03/07/sqlbits-2015-query-tuning-mastery-clash-of-the-row-goals-demos.aspxSat, 07 Mar 2015 11:19:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:58131Adam Machanic<p>Thanks to everyone who attended my talk yesterday! The demos are attached to this post. Let me know if you have any questions.</p><p>Until next time... <br></p>Parallel Performance in London: SQLbits XIV, Superheros Edition!http://www2.sqlblog.com/blogs/adam_machanic/archive/2014/12/18/parallel-performance-in-london-sqlbits-xiv-superheros-edition.aspxThu, 18 Dec 2014 15:03:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:57443Adam Machanic<p>I'm happy to announce that I'll be returning again this year to the UK's premier SQL Server conference, SQLbits. This year's show is in London, and has a Superheros theme; it should be a great time.</p>
<p>On <b>Wednesday March 4th, I'll be delivering "Better Performance Through Parallelism"</b> as a full-day preconference seminar. This seminar teaches you how to properly leverage SQL Server's parallel processing capabilities to greatly improve performance of your biggest queries. It includes a large amount of internals and background information, detailed query plan and tuning guidelines, a discussion on server configuration, as well as information on how to properly monitor parallel queries in your environment.</p><p>&nbsp;</p>
<p>I delivered this seminar at this year's PASS Summit in Seattle, and <b>here is what some of the attendees had to say</b>:</p>
<blockquote>
<p><span id="dnn_ctr23709_PASS_Orator_SpeakerPortal_SessionEval_Individual_ReportViewer_Main_ReportViewer">"this
presentation was awesome. it was packed with information and delivered
in a clear, concise and easily understood manner. there just wasn't
enough time which was a bummer since i found the entire day truly
fascinating and didn't want to stop soaking in"</span> </p>
<p>"<span id="dnn_ctr23709_PASS_Orator_SpeakerPortal_SessionEval_Individual_ReportViewer_Main_ReportViewer">My
favorite presentation of the conference. Very organized, detailed and
full of useful information. I found the demos to be absolutely
revealing."</span></p>
<p>"<span id="dnn_ctr23709_PASS_Orator_SpeakerPortal_SessionEval_Individual_ReportViewer_Main_ReportViewer">Extremely
knowledgeable speaker, with quite a lot of material. Handled the room
well. Will definitely recommend any session that he presents."</span></p>
<p>"<span id="dnn_ctr23709_PASS_Orator_SpeakerPortal_SessionEval_Individual_ReportViewer_Main_ReportViewer">This
was in the top 3 best sessions I attended at PASS or at a PASS related
event. Everything from the background of parallelism to performing
analysis of a parallel query execution plan was great."</span> <br></p></blockquote><p>&nbsp;</p><p>The SQLbits marketing committee came up with the great idea of having preconference speakers create videos to help promote our sessions. <b><a href="https://www.youtube.com/watch?v=E-qhIxNMa1s" mce_href="https://www.youtube.com/watch?v=E-qhIxNMa1s">I had a bit of fun with mine</a>...</b></p>Hope to see many of you in London!Reflections on SQLBits XIhttp://www2.sqlblog.com/blogs/jamie_thomson/archive/2013/05/16/reflections-on-sqlbits-xi.aspxThu, 16 May 2013 22:03:50 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:49089jamiet<p>Its been a couple of weeks since SQLBits XI happened in Nottingham and I thought I’d jot down a few thoughts for posterity.</p> <p>First the venue. I think its fair to say that the overall consensus was that the <a href="http://www.nottinghamconferences.co.uk/emcc/" target="_blank">East Midlands Conference Centre</a> was the best SQLBits venue these has been so far – I’ve been to more than half of them and based on my experience I would agree with that sentiment. The hotel especially was top quality – I was pleased with my room and the breakfasts were way better than the Travelodge standards I’ve become accustomed to at such events. Perhaps the great weather over the weekend helped lift the spirits but I’d say the bar has been set high, I hope future SQLBits conferences are at similar standard venues.</p> <p>You may have noticed that many of my blog posts over the past year have been related to SSDT and my SQLBits sessions this time around followed that trend. I delivered a session on the Friday, jointly with <a href="http://twitter.com/Craig_Ottley" target="_blank">Craig Ottley-Thistlethwaite</a>, entitled “Real World SDDT” and also delivered my first ever day-long pre-conference seminar on the Thursday entitled “SSDT Database Projects from the ground up”. Delivering a pre-con was slightly petrifying and I spent a large part of the three months previous preparing for it; I hope it was worth it. I had 30 attendees which I was delighted with (especially given this was my first pre-con) and we established that the furthest anyone travelled was from Romania, though I’ll assume it wasn’t just so he could come to my pre-con <img class="wlEmoticon wlEmoticon-smile" style="border-top-style:none;border-left-style:none;border-bottom-style:none;border-right-style:none;" alt="Smile" src="http://sqlblog.com/blogs/jamie_thomson/wlEmoticon-smile_597D8138.png" />. I had some pleasant feedback via Twitter afterwards from some of the attendees and I’m crossing my fingers that the official feedback is in a similar vein.</p> <p>The session I did with Craig went fairly well I thought. I did the first 30minutes where I covered the basics of SSDT deployment from a high level before Craig ratcheted the complexity up a few notches by demoing some interaction between SSDT, MSBuild &amp; Git – really great stuff for those who like to get into the nuts and bolts of this stuff. I was delighted that Craig was willing to do the session with me (in fact it was his idea) as this was his debut public speaking gig and I’m hoping its given him the desire to do more in the future.</p> <p>On the Saturday my wife’s uncle, John Milne, came to the conference. John has been working in customer service for years but of late has decided that he wants a change of career and to that end has been studying an Open University course in IT. He told me he had particularly enjoyed the database-focused modules of his course and hence I suggested he come to the free Saturday of SQLBits to try and get a flavour of what the industry is all about and perhaps learn about some real-world experiences to add to his academic travails. By the end of the day John told me he’s had a fantastic time, learned a lot, and was hooked. Mission accomplished I’d say. John lives in Leeds so I introduced him to Chris Testa-O’Neill who helps to run the Leeds user group and John should be going along to some user group events in the near future – if you happen to meet him there please welcome him into the fold!</p> <p>All that remains for me to say is a massive thank you to the SQLBits committee who do such an amazing job, all voluntarily, in putting this all together. Thank you Simon Sabin, James Rowland-Jones, Chris Webb, Darren Green, Allan Mitchell, Tim Kent, Chris Testa-O’Neill &amp; Martin Bell. I also want to thank all of the volunteer SQLBits helpers that worked tirelessly on the weekend to make sure the whole thing ran smoothly.</p> <p>Bring on SQLBits XII!</p> <p><a href="http://twitter.com/jamiet" target="_blank">@Jamiet</a></p>SQLBits XI : Bad Habits &amp; Best Practices in T-SQLhttp://www2.sqlblog.com/blogs/aaron_bertrand/archive/2013/05/04/sqlbits-xi-bad-habits-best-practices-in-t-sql.aspxSat, 04 May 2013 14:01:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:48965AaronBertrand<p>Yesterday I gave my session to the fine folks in Nottingham, UK. Below is a zip file containing the deck and samples:</p><p><a target="_blank" href="http://sqlblog.com/files/folders/48964/download.aspx">Bertrand_BitsXI_BadHabits.zip</a></p>Get the SQLBits agenda on your phone, now and foreverhttp://www2.sqlblog.com/blogs/jamie_thomson/archive/2013/04/25/get-the-sqlbits-agenda-on-your-phone-now-and-forever.aspxThu, 25 Apr 2013 20:02:33 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:48873jamiet<p>Regular readers of my blog might have realised that I am a huge advocate of subscribable calendars and the data format that underpins them – <a href="http://sqlblog.com/blogs/jamie_thomson/archive/tags/iCalendar/default.aspx" target="_blank">iCalendar</a>. On 8th Feb 2012 I wrote a blog post entitled <a title="http://sqlblog.com/blogs/jamie_thomson/archive/2012/02/08/sqlbits-now-publishing-the-sqlbits-agenda-as-an-icalendar.aspx" href="http://sqlblog.com/blogs/jamie_thomson/archive/2012/02/08/sqlbits-now-publishing-the-sqlbits-agenda-as-an-icalendar.aspx" target="_blank">SQLBits now publishing all SQLBits agendas as an iCalendar</a> where I told how the SQLBits committee had published the agenda of the forthcoming SQLBits conference in iCalendar format allow with instructions of how one could view the agenda on their phone. Back then I said:</p> <blockquote> <p><em>…any changes to the SQLBits agenda (e.g. a room change) will automatically flow to your own calendar service and if you have that calendar service (e.g. Hotmail Calendar, Google Calendar) synced to your phone then the changes will automatically show up there too … That new SQLBits subscribable calendar lives at </em><a href="http://sqlbits.com/information/SQLBitsCalendar.ashx"><em>http://sqlbits.com/information/SQLBitsCalendar.ashx</em></a><em>; note how it is not specific to a particular conference - subscribe to (don't import) that calendar and the agenda for future SQLBits conferences will automatically flow to you too.</em></p> </blockquote> <p>Sure enough I took a look at the calendar on my phone today and saw this:</p> <blockquote> <p><a href="http://sqlblog.com/blogs/jamie_thomson/image_52062B4A.png"><img title="image" style="border-top:0px;border-right:0px;background-image:none;border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;display:inline;padding-right:0px;" border="0" alt="image" src="http://sqlblog.com/blogs/jamie_thomson/image_thumb_7D6A4C44.png" width="288" height="508" /></a></p> <p><em>(That “Real world SSDT” session at 14:40 is being presented by <a href="http://www.sqlbits.com/Speakers/Craig_Ottley-Thistlethwaite" target="_blank">Craig Ottley-Thistlethwaite</a> and myself by the way. Hope to see you there!)</em></p> </blockquote> <p>This is the value of <em>subscribing </em>as opposed to <em>importing</em>. The agenda for next week’s conference has already flowed to my phone without my having to do anything. This isn’t the same phone that I had a year ago either, by subscribing to it in my Outlook.com (nee Hotmail) Calendar those subscriptions are stored and flow onto any new phone as soon as I type in my credentials.</p> <p>I have stated before that I believe subscribable calendars to be a transformative technology and this is why, I only had to subscribe to the calendar once and data that didn’t even exist back then simply flows into my calendar and thus onto my phone. If this interests you then maybe read how I think the same technology could be used to deliver BI data too at <a title="http://sqlblog.com/blogs/jamie_thomson/archive/2010/06/03/thinking-differently-about-bi-delivery.aspx" href="http://sqlblog.com/blogs/jamie_thomson/archive/2010/06/03/thinking-differently-about-bi-delivery.aspx" target="_blank">Thinking differently about BI delivery</a>. And if you want to subscribe to the calendar yourself go and read the aforementioned blog post, that link again: <a title="http://sqlblog.com/blogs/jamie_thomson/archive/2012/02/08/sqlbits-now-publishing-the-sqlbits-agenda-as-an-icalendar.aspx" href="http://sqlblog.com/blogs/jamie_thomson/archive/2012/02/08/sqlbits-now-publishing-the-sqlbits-agenda-as-an-icalendar.aspx" target="_blank">SQLBits now publishing all SQLBits agendas as an iCalendar</a>.</p> <p><a href="http://twitter.com/jamiet" target="_blank">@Jamiet</a></p>My SQLBits Pre Conference Seminar - SSDT Database projects from the ground-uphttp://www2.sqlblog.com/blogs/jamie_thomson/archive/2013/01/15/my-sqlbits-pre-conference-seminar-ssdt-database-projects-from-the-ground-up.aspxTue, 15 Jan 2013 21:44:52 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:47170jamiet<p>Over the last year or so it will not have escaped my regular readers’ attention that much of my blogging has centred around <a href="http://sqlblog.com/blogs/jamie_thomson/archive/tags/SSDT/default.aspx" target="_blank">SSDT database projects</a>. SSDT (and its variously named forebears) is a tool that I have been using in some way, shape or form since 2007 and in that time I have built up what I feel is a sound body of knowledge and experience; I shall soon be sharing that knowledge in my first ever day-long seminar as part of the <a href="http://sqlbits.com/(S(ckin5tat3ut34q55gkgc32eo))/information/TrainingDay.aspx" target="_blank">SQL Bits 11 Training Day</a> on 2nd May 2013. I have titled the seminar <a href="http://sqlbits.com/information/Event11/SSDT_Database_projects_from_the_ground-up1/TrainingDetails.aspx" target="_blank">SSDT Database projects from the ground-up</a>; here is the abstract:</p> <blockquote> <p><em>SQL Server Data Tools (SSDT) database projects bring SQL Server development into the modern era. Come along and learn how SSDT database projects can accelerate your SQL Server development and deployments. You will learn about declarative database development, code navigation, refactoring, automated builds, database unit testing and, most importantly, how you can make these tools work to your advantage. </em></p> </blockquote> <p>If you come to my seminar you can expect lots of interactive demos for which I will share all the source code prior to the event; this means that you can go through the demos as I present them live – that’s a great way of learning new techniques.</p> <p>As stated this is my first day-long seminar however I have been presenting publicly for some years now and have previously <a href="http://sqlblog.com/blogs/jamie_thomson/archive/2011/01/15/analysing-sqlbits-feedback.aspx" target="_blank">shared my speakers scores for public analysis</a>. My most recent speaking engagement was at SQLBits 10 where my speaker scores were well above average:</p> <blockquote> <p><a href="http://sqlblog.com/blogs/jamie_thomson/image_42517114.png"><img title="image" style="border-top:0px;border-right:0px;background-image:none;border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;display:inline;padding-right:0px;" border="0" alt="image" src="http://sqlblog.com/blogs/jamie_thomson/image_thumb_79B78242.png" width="566" height="508" /></a></p> </blockquote> <p>The qualitative feedback included these comments:</p> <ul> <li>The hour passed very quickly. Very good, interesting speaker.</li> <li>This was a great session – I really like Jamie’s laid back presentation style</li> <li>Informative session. Nicely showed off the new features and ways of working</li> </ul> <p>That’s my short sales pitch over. I hope this piques your interest and if it does please sign up for my seminar when you register for SQLBits and I look forward to seeing you on the day.</p> <p><a href="http://twitter.com/jamiet" target="_blank">@Jamiet</a></p>SQLPeople at SQLBitshttp://www2.sqlblog.com/blogs/jamie_thomson/archive/2012/04/26/sqlpeople-at-sqlbits.aspxThu, 26 Apr 2012 15:05:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:43008jamiet<p>Ever heard of <a href="http://sqlpeople.net/" target="_blank">SQLPeople.net</a>? It is a website set up by Andy Leonard to showcase members of the SQL Server community by asking them the following questions:</p>
<ol>
<li><span class="question">Everyone’s an accidental DBA (or database professional) – what’s your story? How’d you become a SQLPerson?</span></li>
<li><span class="question"></span><span class="question">What’s your favorite part of your current gig?</span></li>
<li><span class="question"></span><span class="question">Complete this sentence: “If I could do anything else, I would…”&nbsp; <br></span></li>
<li><span class="question">Complete this sentence: “When I’m not working I enjoy…” </span></li>
<li><span class="question">Complete this sentence: “I think the coolest thing in technology today is…” </span></li>
<li><span class="question">Complete this sentence: “I look forward to the day when I can use technology to…” </span></li>
<li><span class="question">Share something different about yourself. (Remember, it’s a family blog!)</span></li>
</ol>
<p>Prior to the recent <a href="http://sqlbits.com/content/event10" target="_blank">SQLBits X</a> conference I asked Andy if I could extend the idea by posing the same questions to some of the conference attendees under the auspices of SQLPeople and film their responses, he graciously agreed. I managed to capture thirteen such videos and you can view them all online right now at <a href="http://vimeo.com/user3251268/videos/search:sqlpeople/" target="_blank">http://vimeo.com/user3251268/videos/search:sqlpeople/</a>.</p>
<p>You can find all of these people online at <a href="https://twitter.com/#%21/troublewithdata">@troublewithdata</a> <a href="https://twitter.com/#%21/mattmasson">@mattmasson</a> <a href="https://twitter.com/#%21/john_welch">@john_welch</a> <a href="https://twitter.com/#%21/ctesta_oneill">@ctesta_oneill</a> <a href="https://twitter.com/#%21/workerthread">@workerthread</a> <a href="https://twitter.com/#%21/al_eardley">@al_eardley</a> <a href="https://twitter.com/#%21/Varigence">@Varigence</a> <a href="https://twitter.com/#%21/davebally">@davebally</a> <a href="https://twitter.com/#%21/gavinpayneuk">@gavinpayneuk</a> <a href="https://twitter.com/#%21/JimmyBoo">@JimmyBoo</a> <a href="https://twitter.com/#%21/sqlsophist">@sqlsophist</a> <a href="https://twitter.com/#%21/Technitrain">@Technitrain</a> </p>
<a href="http://vimeo.com/user3251268/videos/search:sqlpeople/"><img src="http://jamiekt.files.wordpress.com/2012/04/vimeo1.png"></a><br>
<a href="http://vimeo.com/user3251268/videos/search:sqlpeople/"><img src="http://jamiekt.files.wordpress.com/2012/04/vimeo2.png"></a>SQLbits London 2012 - Demoshttp://www2.sqlblog.com/blogs/adam_machanic/archive/2012/04/03/sqlbits-london-2012-demos.aspxWed, 04 Apr 2012 00:50:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:42676Adam Machanic<p>Thanks to everyone who attended my sessions last Friday and Saturday at SQLbits! It was great to meet many new people, not to mention spending some time exploring one of my favorite cities, London.<br></p><p>Attached are the demos for each of the two talks I delivered:</p><p><b>Query Tuning Mastery: The Art of and Science of Manhandling Parallelism</b><br>As a database developer, your job boils down to one word: performance. And in today's multi-core-driven world, query performance is very much determined by how well you're taking advantage of the processing power at your disposal. Are your big queries using every available clock tick, or are they lagging behind? And if your queries are already going parallel, can they be rewritten for even greater speed? In this session you will learn how to take full advantage of parallelism, from a developer's point of view. After a quick terminology review and technology refresher the session will go deep, covering T-SQL patterns that allow certain queries to scale almost linearly across your multi-core CPUs. Alas, not all T-SQL queries can go parallel, so you will also learn to watch for those things that can restrict the query optimizer's decisions. Along the way you’ll learn to manipulate costs and row goals, challenge generally accepted tuning practices, and take complete control of your parallel queries.<br></p><p>... and ...</p><p><b>Query Tuning Mastery: Workspace Memory Internals</b><br>As SQL Server professionals, we often think of memory in vague, instance-level terms: buffer pool, procedure cache, Virtual Address Space, and so on. But certain tasks require a more in-depth focus, and query tuning is one of them. Large, complex queries need memory in which to work--workspace memory--and understanding the how's, when's, and why's of this memory can help you create queries that run in seconds rather than minutes. This session will give you an in-depth understanding of how the optimizer makes its query memory decisions, with lots of tips and tricks along the way to help you guide the process for top performance. If you work with large queries and are serious about achieving scalability and consistently great performance, you owe it to yourself to attend this session.<br></p><p>&nbsp;</p><p>Enjoy!</p>SQLBits now publishing all SQLBits agendas as an iCalendarhttp://www2.sqlblog.com/blogs/jamie_thomson/archive/2012/02/08/sqlbits-now-publishing-the-sqlbits-agenda-as-an-icalendar.aspxWed, 08 Feb 2012 08:36:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:41613jamiet<p>Three weeks ago I published a blog post <a href="http://sqlblog.com/blogs/jamie_thomson/archive/2012/01/18/sqlbits-agenda-available-on-your-phone.aspx" target="_blank">Get the SQLBits agenda in your phone's calendar</a> where I said:</p>
<blockquote>
<p><i>If you want to get the SQLBits calendar onto your smartphone then the
easiest way to do it is add my calendar [containing all SQLBits sessions] to whichever calendar service
(i.e. Hotmail or Google) you have got synced to your phone and let
technology do its thing.<br>I will keep the calendar updated with any changes to the agenda so,
assuming you have subscribed, changes will just propogate to you without
you having to do anything.</i></p>
</blockquote>
<p>This is not the first time I have published a subscribable calendar (<a href="http://sqlblog.com/blogs/jamie_thomson/archive/2010/05/25/subscribable-world-cup-2010-calendar.aspx" target="_blank">I did it for the 2010 World Cup</a> for example, I also <a href="http://jamiekt.wordpress.com/2010/10/14/announcing-the-sunbury-on-thames-hub-on-elmcity/" target="_blank">curate a calendar for my home town</a>) nor the first time I have <a href="http://sqlblog.com/blogs/jamie_thomson/archive/tags/iCalendar/default.aspx" target="_blank">opined</a> <a href="http://sqlblog.com/blogs/jamie_thomson/archive/2010/06/03/thinking-differently-about-bi-delivery.aspx" target="_blank">about</a> <a href="http://sqlblog.com/blogs/jamie_thomson/archive/2010/06/03/thinking-differently-about-bi-delivery.aspx" target="_blank">them</a>. The reason I bang on about subscribable calendars (aka iCalendars) all the time is that I truly believe that they are a transformative technology. In my humble opinion <b>the world would be a better place if it ran on iCalendar </b>and I'm not the only one who thinks so, Scott Adams (yes, <a href="http://dilbert.com/about" target="_blank">THAT Scott Adams</a>) says the same (but in a much more coherent way) in his blog post <a href="http://dilbert.com/blog/entry/calendar_as_filter/" target="_blank">Calendar as Filter</a>.</p>
<p>My super-smart former colleague Howard van Rooijen is fond of saying <a href="http://blog.endjin.com/2010/10/work-smarter-not-harder/" target="_blank">work smarter, not harder</a> and, to me, subscribable calendars are the epitome of that mantra. Why should many people do the same work of downloading .ics files and importing them to their own calendar service when the content owner can simply make that information available to anyone? That is my motivation for publishing these subscribable calendars - I want to motivate the content owners to publish this information for themselves. </p>
<p>With that in mind I am delighted to tell you that the SQLBits organising committee have taken this on board and published the SQLBits agenda as an iCalendar. One benefit of that is I don't have to go through the rigmarole of keeping my own calendar up to date but more importantly any changes to the SQLBits agenda (e.g. a room change) will <i>automatically flow to your own calendar service</i> and if you have that calendar service (e.g. Hotmail Calendar, Google Calendar) synced to your phone then the changes will automatically show up there too. Very cool!<br></p>
<p>That new SQLBits subscribable calendar lives at <a href="http://sqlbits.com/information/SQLBitsCalendar.ashx" target="_blank"><font face="Calibri,sans-serif" size="2"><span style="font-size:11pt;">http://sqlbits.com/information/SQLBitsCalendar.ashx</span></font></a>; note how it is not specific to a particular conference - subscribe to (don't import) that calendar and the agenda for future SQLBits conferences will automatically flow to you too. Want to subscribe to that calendar yourself? Click one of the following links:</p>
<ul>
<li>If you use Hotmail, click <a href="http://calendar.live.com/calendar/calendar.aspx?rru=addsubscription&amp;url=webcals://sqlbits.com/information/SQLBitsCalendar.ashx&amp;name=SQLBits" target="_blank">here</a></li>
<li>If you use GMail/Google Calendar, click <a href="http://www.google.com/calendar/render?cid=http://sqlbits.com/information/SQLBitsCalendar.ashx" target="_blank">here</a></li>
</ul>
<blockquote>
<p><i>N.B. I am assuming that Hotmail &amp; Google Calendar covers the majority of folks that are going to be reading this. If you use a different service (e.g. Yahoo) then perhaps you could find out what the appropriate link should be and it as a comment below.</i><br></p>
</blockquote>
<p>You may also want to unsubscribe from <a href="http://sqlblog.com/blogs/jamie_thomson/archive/2012/01/18/sqlbits-agenda-available-on-your-phone.aspx" target="_blank">my calendar</a> because I am no longer going to keep it updated.<br></p>
<p>My thanks go to the SQLBits committee for doing this; more accurately the thanks should go to <a href="http://sqlblogcasts.com/blogs/simons/" target="_blank">Simon Sabin</a> because it was he that made this happen.</p>
<p><a href="http://twitter.com/jamiet" target="_blank">@jamiet</a> </p>
<p>P.S. If you agree with me that iCalendar is a transformative technology and would like to get involved then take a look at Jon Udell's <a href="http://blog.jonudell.net/elmcity-project-faq/" target="_blank">Elmcity project</a> (<a href="http://blog.jonudell.net/elmcity-project-faq/" target="_blank">FAQ</a>) to curate your own calendar for your home town.</p><p>UPDATE: Some folks are saying that the link to Google Calendar produces the message: "<i>You do not have access to &lt;the calendar&gt;</i>". The exact same problem was reported with the calendar that I produced three weeks ago so I am assuming that the problem is at Google's end. The workaround is to subscribe to URL&nbsp; <a href="http://sqlbits.com/information/SQLBitsCalendar.ashx" target="_blank"><font face="Calibri,sans-serif" size="2"><span style="font-size:11pt;">http://sqlbits.com/information/SQLBitsCalendar.ashx</span></font></a> in Google Calendar by clicking Other calendars-&gt;Add by URL.</p>
<a href="http://sqlblog.com/blogs/jamie_thomson/archive/2012/01/18/sqlbits-agenda-available-on-your-phone.aspx" target="_blank"></a>