Search results matching tags 'Performance' and 'PASS'http://sqlblog.com/search/SearchResults.aspx?o=DateDescending&tag=Performance,PASS&orTags=0Search results matching tags 'Performance' and 'PASS'en-USCommunityServer 2.1 SP2 (Build: 61129.1)24 Hours of PASS - Evolution of the Data Platform - The Grand Finale - Schedule Changehttp://sqlblog.com/blogs/rick_heiges/archive/2016/05/22/24-hours-of-pass-evolution-of-the-data-platform-the-grand-finale-schedule-change.aspxSun, 22 May 2016 20:02:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:61262RickHeiges<p>I was originally schedule in the 24th slot of the upcoming 24 Hours of PASS which was to begin at 7am ET on May 26. &nbsp;I called it the Grand Finale.</p><p>As with many events, schedule conflicts arise. So, the Grand Finale session will now be referred to me as the Grant Finale session. &nbsp;Grant Fritchey will now be speaking at 7am ET on May 26. &nbsp;My session will be where Grant's was before the change - May 25 @7pm ET.. &nbsp;See the entire schedule here: http://www.sqlpass.org/24hours/2016/edp/Schedule.aspx </p><p>My original post about this incarnation of 24 Hours of PASS<span style="font-size:10pt;">&nbsp;is here:&nbsp;</span>http://sqlblog.com/blogs/rick_heiges/archive/2016/05/18/24-hours-of-pass-evolution-of-the-data-platform.aspx&nbsp;</p><p>Register Today!</p>Heading to SQL Sat NYC!http://sqlblog.com/blogs/rick_heiges/archive/2015/05/21/heading-to-sql-sat-nyc.aspxThu, 21 May 2015 13:24:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:58714RickHeiges<p>I will be speaking at SQL Sat 380 in NYC on the topic of Basic Performance Monitoring with Perfmon.&nbsp; I have delivered this session many times and is usually well attended.&nbsp; The session is geared for the person who has heard of Perfmon but not used it.&nbsp; This is very much a 100 level offering.</p><p>The last time that I was in NYC for a large SQL Server event was just about 10 years ago.&nbsp; It was the "Get Ready for SQL Server 2005 Roadshow" that was sponsored by Microsoft, PASS, and SQL Server Magazine.&nbsp; The cost was $99 for a whole day; about 450 people attended.&nbsp; There were 3 tracks - DBA, Dev, and BI.&nbsp; Scalability Experts did the DBA track, Solid Quality Learning (as it was known back then) had the BI Track, and Dev Mentor had the Dev track. </p><p>Although I attended many of these Road Shows and eventually presented the DBA track at some locations, I learned a lot from the audience.&nbsp; I still do.&nbsp; The questions that are asked really provide an opportunity for learning.&nbsp; You can also see patterns start to emerge over time from questions.&nbsp; For example, one question that was asked often was "Can I&nbsp;mirror a&nbsp;database to another instance on the same box?".&nbsp; The first couple of times that I heard the question, my instinct was "Yes, but why? You are defeating the purpose when you do this.".&nbsp; When so many people ask this question, you have to dig deeper.&nbsp; In essence, what a lot of people were saying was this - "I trust my hardware a lot more than I trust your software in terms of uptime".&nbsp; Servers were becoming more and more fault tolerant with spare power supplies, fans, hard drives, etc.&nbsp; This increased reliability.&nbsp; From one point of view, being able to mirror to another instance on the same box was just another level of redundancy.</p><p>When you attend a SQL Saturday or other event, please don't hesitate to ask a question.&nbsp; It just might be the same question that others have and it helps everyone learn more.&nbsp;</p><p>Also, the speakers at SQL Saturday events are giving up their Saturday too.&nbsp;&nbsp;A great way&nbsp;to thank the speaker is to&nbsp;provide written feedback on the evaluation forms.&nbsp; This is almost like gold to the speakers.</p><p>If you are in the NYC area on May 30th, I encourage you to attend.&nbsp; The event is almost "Sold Out". so be sure to register today!&nbsp; <a href="http://www.sqlsaturday.com/380/eventhome.aspx">http://www.sqlsaturday.com/380/eventhome.aspx</a>&nbsp;</p><p>See you there!</p><p>&nbsp;</p>SQL Konferenz 2015 Slide &amp; Demohttp://sqlblog.com/blogs/davide_mauri/archive/2015/02/09/sql-konferenz-2015-slide-demo.aspxMon, 09 Feb 2015 16:47:51 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:57822manowar<p>Last week I spoke at the <a href="http://www.sqlkonferenz.de/default.aspx">SQL Konferenz</a> in Darmstad near Frankfurt. The conference was great and I meet a lot of good SQL friends over there. For anyone interested here you can find slide &amp; demos of the session I delivered:</p> <p><strong>(Near) Real-Time Data Integration with SQL Server, On-Premises &amp; Cloud</strong> <br /><a title="http://www.slideshare.net/davidemauri/real-time-data-integration" href="http://www.slideshare.net/davidemauri/real-time-data-integration">http://www.slideshare.net/davidemauri/real-time-data-integration</a></p> <p><strong>Schema-Less Table &amp; Dynamic Schema</strong> <br /><a title="http://www.slideshare.net/davidemauri/schema-less-table-dynamic-schema-44295422" href="http://www.slideshare.net/davidemauri/schema-less-table-dynamic-schema-44295422">http://www.slideshare.net/davidemauri/schema-less-table-dynamic-schema-44295422</a></p> <p>You’ll find a link to evaluated the session on SpeakerScore and to download the slides in the last slide of each deck.</p> <p>Enjoy!</p>SQLRally Nordic and SQLRally Amsterdam: Wrap Up and Demoshttp://sqlblog.com/blogs/adam_machanic/archive/2013/11/11/sqlrally-nordic-and-sqlrally-amsterdam-wrap-up-and-demos.aspxTue, 12 Nov 2013 00:56:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:51688Adam Machanic<p><b>First and foremost</b>: Huge thanks, and huge apologies, to everyone who attended my sessions at these events. I promised to post materials last week, and there is no good excuse for tardiness. My dog did not eat my computer. I don't have a dog. And if I did, she would far prefer a nice rib eye to a hard chunk of plastic.</p><p>Now, on to the purpose of this post...</p><p><b>Last week I was lucky enough</b> to have a first visit to each of two amazing cities, Stockholm and Amsterdam. Both cities, <a href="http://sqlblog.com/blogs/adam_machanic/archive/2013/10/04/query-performance-sessions-in-stockholm-and-amsterdam.aspx" mce_href="http://sqlblog.com/blogs/adam_machanic/archive/2013/10/04/query-performance-sessions-in-stockholm-and-amsterdam.aspx">as mentioned previously on my blog</a>, hosted SQLRally events, and I did a precon plus two talks at each event.</p><p>The events in both cities were well done and the audiences seemed quite sharp. Very nice events at which to be a speaker! <b>I hope to return to both areas very, very soon. </b>(Hint, hint, event organizers!)<br></p><p>Precon attendees: You should already know where to get your slides and demos.</p><p><b>Breakout session attendees</b>: Find the demos for both of my talks attached here.</p><p>Thanks again to everyone who I met and/or taught. It was really a fantastic week. Skål and/or proost -- depending on your disposition!<br></p>Query Performance Sessions in Stockholm and Amsterdamhttp://sqlblog.com/blogs/adam_machanic/archive/2013/10/04/query-performance-sessions-in-stockholm-and-amsterdam.aspxFri, 04 Oct 2013 13:15:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:51210Adam Machanic<p>As <a href="http://sqlblog.com/blogs/adam_machanic/archive/2013/09/20/hey-amsterdam-and-stockholm-just-say-no-to-guessing-about-performance.aspx" mce_href="http://sqlblog.com/blogs/adam_machanic/archive/2013/09/20/hey-amsterdam-and-stockholm-just-say-no-to-guessing-about-performance.aspx">previously mentioned</a>, I'll be delivering my full-day "No More Guessing" performance troubleshooting seminar at both the <a href="http://www.sqlpass.org/sqlrally/2013/nordic/" mce_href="http://www.sqlpass.org/sqlrally/2013/nordic/">Stockholm</a> and <a href="http://www.sqlpass.org/sqlrally/2013/amsterdam/" mce_href="http://www.sqlpass.org/sqlrally/2013/amsterdam/">Amsterdam</a> SQLRally events. In addition to the seminar, I'll be doing two breakout sessions at each event. <br></p><p>It's going to be a busy week! But luckily for me, I'm doing the same things in each city:</p><p>&nbsp;</p><p><b>Using Your Brain to Beat SQL Server</b></p><p>This session is a joint effort with one of the world's greatest SQL superheroes, <a href="http://blog.kejser.org/" mce_href="http://blog.kejser.org/">Thomas Kejser</a>. The session is all about query optimizer deficiencies and how to win the battle for excellent performance by applying your own intelligence instead of blindly trusting that SQL Server will do the right thing. I think this is going to be a really fun and useful session.</p><p>&nbsp;</p><p><b>Data, Faster: SQL Server Performance Techniques with SQLCLR</b> </p><p>Remember when SQLCLR was first put into SQL Server and everyone was wondering what they should use it for? I found my answer: raw performance. In this session I'll teach you a SQLCLR pattern that can help reduce the run time of your heaviest and most logic-filled queries, often by an order of magnitude or more.</p><p>&nbsp;</p><p><b>Looking forward to seeing you in Europe next month!</b> <br></p>Query Tuning Mastery at PASS Summit 2012: The Videohttp://sqlblog.com/blogs/adam_machanic/archive/2012/11/13/query-tuning-mastery-at-pass-summit-2012-the-video.aspxTue, 13 Nov 2012 14:49:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:46135Adam Machanic<p>An especially clever community member was kind enough to reverse-engineer the video stream for me, and came up with a <b>direct link to the PASS TV video stream</b> for my <a href="http://sqlblog.com/blogs/adam_machanic/archive/2012/11/12/query-tuning-mastery-at-pass-summit-2012-the-demos.aspx">Query Tuning Mastery: The Art and Science of Manhandling Parallelism</a> talk, delivered at the PASS Summit last Thursday. I'm <b>not sure how long this link will work</b>, but I'd like to share it for my readers who were unable to see it in person or live on the stream.<br></p><p><b><a href="http://pass.bethereglobal.com/demand/day2p1.mp4">Start here.</a></b></p><p><b>Skip past the keynote, to the 149 minute mark.</b><br></p><p>Enjoy!<br></p>Query Tuning Mastery at PASS Summit 2012: The Demoshttp://sqlblog.com/blogs/adam_machanic/archive/2012/11/11/query-tuning-mastery-at-pass-summit-2012-the-demos.aspxMon, 12 Nov 2012 04:00:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:46095Adam Machanic<p>For the second year in a row, I was asked to deliver a <b>500-level "Query Tuning Mastery"</b> talk in room 6E of the Washington State Convention Center, for the PASS Summit. (<a href="http://sqlblog.com/blogs/adam_machanic/archive/2011/10/16/pass-summit-2011-zen-and-the-art-of-workspace-memory-demos.aspx">Here's some information about last year's talk, on workspace memory.</a>) And for the second year in a row, I had to deliver said talk at 10:15 in the morning, in a room used as overflow for the keynote, following a keynote speaker that didn't stop speaking on time. Frustrating!</p><p>Last Thursday, after very, very quickly setting up and getting sound and video checks, the rest of the talk went surprisingly smoothly. My deck--a brand new version created specifically for PASS--helped me get across the message I wanted to communicate, my demos ran without any failure, and my jokes didn't drive too many people out of the room before the end of the talk. <b>I even received a round of applause when I managed to take a 26 minute query plan and, using a few query rewrites, deliver the same exact data in 9 seconds</b>. That, I have to say, was pretty cool.</p><p>Here's the abstract for the session:</p><blockquote><p><b>Query Tuning Mastery: The Art and Science of Manhandling Parallelism</b> <br></p><p><span>As a database developer, your job boils down to one word:
performance. 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
clock tick, or are they lagging behind? And if your queries are already
parallel, can they be rewritten for even greater speed?
<br>
<br>In this session, you'll learn to take full advantage of SQL Server
query parallelism. After a 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. You'll see
when and why the optimizer makes a parallel plan choice and how to
impact the decision. Along the way, you’ll manipulate costs and row
goals, challenge generally accepted tuning practices, and take complete
control of your parallel queries.</span> <br></p></blockquote><p>Since the talk was being broadcast live on "PASS TV," I had <a href="http://sqlblog.com/blogs/paul_white/">Paul White</a> join me at the front of the room to moderate questions delivered via Twitter. This worked out reasonably well and I hope to do something similar in the future. <b>Huge thanks to Paul for helping out -- and for giving me a really ugly scowl when one of my jokes fell totally flat</b>.<br></p><p><b>Demos for the talk are attached.</b> Let me know if you have any questions.</p><p><b>Thanks again to everyone who watched, either in person or at home. I had a blast. Hope you enjoyed it even half as much as I did!</b> <br></p>Two New Slide Decks. Plus, the Week in Colorado.http://sqlblog.com/blogs/kevin_kline/archive/2012/08/20/two-new-slide-decks-plus-the-week-in-colorado.aspxMon, 20 Aug 2012 15:03:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:44792KKline<p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;"><a href="http://kevinekline.com/wp-content/uploads/2012/08/IMAG2488.jpg"><img class="alignright wp-image-2027" title="Kevin and the SpringSQL Leadership" alt="" width="240" height="143" style="border:0px;cursor:default;float:right;" src="http://kevinekline.com/wp-content/uploads/2012/08/IMAG2488-300x179.jpg"></a>I had the honor of traveling the great state of Colorado last week, speaking at the PASS chapters in&nbsp;<a title="Boulder, CO SQL Server Users Group" href="https://groups.google.com/forum/?fromgroups#!forum/boulder-sql-server-users-group">Boulder</a>,&nbsp;<a title="Colorado Springs, CO SQL Server Users Group" href="http://www.springssql.sqlpass.org/">Colorado Springs</a>, and&nbsp;<a title="Denver, CO SQL Server Users Group" href="http://denver.sqlpass.org/">Denver</a>. &nbsp;At all three events, we had a stellar attendance and, at least&nbsp;<a title="A Huge Crowd for the Denver SQL Server User Group!" href="http://img.ly/m6ZG">in Denver, broke all the records</a>&nbsp;in recent memory both in terms of overall attendance and in first-timers. &nbsp;Denver, in fact, was standing room only and had nearly 30 first time attendees. &nbsp;Great news! &nbsp;I also want to give a special shout-out of thanks and appreciation to&nbsp;Chris Shaw (<a href="https://twitter.com/#!/SQLShaw">Twitter</a>&nbsp;|&nbsp;<a href="http://chrisshaw.wordpress.com/feed/">Blog</a>) whose hard work and tenacity ensured that all of Colorado got to see me speak. From left to right, Gabriel Villa (<a title="Gabriel Villa on Twitter" href="http://twitter.com/extofer">Twitter</a>), me, Chris Shaw, and Rebecca Mitchell (<a title="Rebecca Mitchell on Twitter" href="http://twitter.com/sqlprincess">Twitter</a>). &nbsp;If it weren't for Chris, I wouldn't have been there. &nbsp;Thanks for putting in the time, amigo!</p><h2 style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;">New Slide Decks!</h2><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;">During the 3-day jaunt, I presented two of my more popular sessions. &nbsp;These are updated slide decks, in case you want to download them here:</p><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;"><a title="End-to-End Troubleshooting for Microsoft SQL Server" href="http://kevinekline.com/wp-content/uploads/2012/08/UG-End-to-End-Troubleshooting.zip">UG - End-to-End Troubleshooting</a></p><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;">and</p><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;"><a title="Top 10 DBA Blunders on Microsoft SQL Server" href="http://kevinekline.com/wp-content/uploads/2012/08/UG-Top-10-SQL-Server-Administration-Mistakes.zip">UG - Top 10 SQL Server Administration Mistakes</a></p><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;"><a href="http://kevinekline.com/wp-content/uploads/2012/08/IMAG2492.jpg"><img class="alignright wp-image-2033" title="Kevin &amp; Steve Murchie" alt="" width="125" height="210" style="border:0px;cursor:default;float:right;" src="http://kevinekline.com/wp-content/uploads/2012/08/IMAG2492-179x300.jpg"></a>Be sure to check in the Slides area of the website, if you want to see the links for SpeakerRate, and in the case of several of my presentations, white papers, video recordings, etc. It's the People that Matter</p><h2 style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;">A Blast from the SQLPASS Past!</h2><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;">I've always tried to maintain the relationships I built with the founding members of the&nbsp;<a title="The Professional Association for SQL Server" href="http://www.sqlpass.org/">PASS</a>&nbsp;board of directors. &nbsp;After their time on the PASS board, almost all of them have moved on from SQL Server to other adventures. &nbsp;Pam Smith, the first president of the organization, is now a professor. &nbsp;Guy Brown, the second president, is now the director of IT at his same employer, rather than just SQL Server as when he was on the PASS board. &nbsp;A few, such as Kurt Windisch, a former VP of PASS, and my good friend&nbsp;Joe Webb (<a href="https://twitter.com/#!/joewebb">Twitter</a>&nbsp;|&nbsp;<a target="_blank" href="http://www.webbtechsolutions.com/blog">Blog</a>), are still active in the SQL Server space. &nbsp;One relationship that I've enjoyed over the years is with PASS' original Microsoft liaison and now a Denver-area software entrepreneur Steve Murchie (at right) running his own healthcare IT outfit. &nbsp;Steve has been a source of inspiration to me and also of great advice for all things startup-related. &nbsp;It was great to connect with Steve and catch up on his latest doings.</p><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;">I also got to enjoy an evening out with the local attendees after the Denver user group meeting. &nbsp;It was great to hang out with folks there. &nbsp;I got to meet&nbsp;<a title="Kevin Cox on deck for 24HOP of SQLPASS.ORG" href="http://www.sqlpass.org/24hours/fall2012/SessionsbySchedule/SpeakerDetails.aspx?spid=480">Kevin Cox</a>&nbsp;(<a title="Kevin Cox's Twitter Feed" href="http://twitter.com/KevinCoxSQL">twitter</a>), a member of Microsoft's incredibly talented&nbsp;<a title="The Microsoft SQL Server Customer Advisory Team" href="http://www.sqlcat.com/">SQLCAT</a>&nbsp;group, and for whom I was a technical editor on a SQL Server v6.5 book back in the Neanderthal era. &nbsp;That shows just how old both Kevin and I actually are. &nbsp;Other cool folks that I got to meet included&nbsp;<a href="http://twitter.com/stevewake">Steve Wake</a>,&nbsp;<a href="http://twitter.com/mike_fal">Mike Fal</a>,&nbsp;<a href="http://twitter.com/marcbeacom">Marc Beacom</a>,&nbsp;<a href="http://twitter.com/jasonkassay">Jason Kassay</a>,&nbsp;<a href="http://twitter.com/jasonhorner">Jason Horner</a>&nbsp;and my ol' buddy,&nbsp;<a href="http://twitter.com/greeleygeek">Kelly the Greeley Geek</a>.</p><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;">On top of that, long-time SQL Server MVP and all-around awesome guy&nbsp;Steve Jones (<a href="https://twitter.com/#!/way0utwest">Twitter</a>&nbsp;|&nbsp;<a href="http://feeds.feedburner.com/sqlmusings">Blog</a>) visited. &nbsp;I kept him out way too late that night which, to be honest, isn't usually my style. &nbsp;But the good conversation propelled us on past midnight.</p><h2 style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;">The Good Folks at SQL Server Professional and Windows IT Professional Magazines</h2><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;"><a href="http://kevinekline.com/wp-content/uploads/2012/08/IMAG2486.jpg"><img class="alignright wp-image-2036" title="Kevin and the Ladies of SQLMag" alt="" width="240" height="143" style="border:0px;cursor:default;float:right;" src="http://kevinekline.com/wp-content/uploads/2012/08/IMAG2486-300x179.jpg"></a>I've written for SQL Server Professional (formerly the artist known as "SQLMag") in some form or another starting from my first cover article for them way back in the mid 1990's. &nbsp;My&nbsp;<a title="Kevin Kline's Tool Time column at SQL Server Professional Magazine" href="http://www.sqlmag.com/blogcontent/seriespath/tool-time-blog-16">Tool Time column</a>&nbsp;has been going strong there since, oh, around 2006 iirc. &nbsp;For most of the time I've known the folks at SQLMag, they were located in Loveland, CO but they were able to move to some incredibly nice digs just up the road in Fort Collins. &nbsp;In all the many years, I've written for them, I'd never been to their offices - until now. &nbsp;It was great to visit and break bread with Megan (to my right), Blair (across), and Jaylee (across and to my right)!</p><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;">I've always supported SQLMag and encourage you to subscribe. &nbsp;On top of the goodness already in the digital magazine, there are some neat developments coming down the pipeline with SQLMag which I think we'll all enjoy. &nbsp;Be sure to subscribe today! &nbsp;(You can click the badge on the left or simply go to&nbsp;<a title="SQL Server Professional Magazine" href="http://www.sqlmag.com/">http://www.sqlmag.com</a>).</p><h2 style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;">&nbsp;What's Next?</h2><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;">My current travel schedule is pinned up on&nbsp;<a title="Kevin Kline's appearance schedule" href="http://kevinekline.com/2012/07/31/come-see-me-ill-probably-be-just-down-the-street-soon/">this blog post HERE</a>. &nbsp;However, I also know of a couple on-line appearances and probably a trip between the long gap between now and my next in-person appearance at the&nbsp;<a title="Orlando SQL Saturday 151" href="http://www.sqlsaturday.com/151/eventhome.aspx">Orlando SQL Saturday</a>&nbsp;at the end of&nbsp;September, where I'll also be teaching a pre-conference seminar (<a title="SQL Server Configuration and Tuning Seminar" href="http://www.eventbrite.com/event/3895236758?ref=ebtn">register HERE for the seminar</a>).</p><h3 style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;">SSWUG</h3><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;">The first on-line event to note is my a presentation by&nbsp;<a title="SQL Server Worldwide User Group" href="http://www.sswug.org/">SSWUG</a>&nbsp;of my&nbsp;<a title="Kevin Kline and SSWUG bring you &quot;Leadership Skills for IT Professionals&quot;" href="http://www.vconferenceonline.com/event/home.aspx?id=769">Leadership Skills for IT Professionals video series</a>, starting on August 24th. &nbsp;Sign up using the hyperlink (note that a video plays immediately upon loading the webpage, in case you want to be ready to pause or stop it). &nbsp;You can also buy a DVD set of the 14 hours of leadership training content.</p><h3 style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;">24HOP - The 24 Hours of PASS Event</h3><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;">I'll also be speaking on the topic of influence in the next&nbsp;<a title="The 2012 24 Hours of PASS session schedule" href="http://www.sqlpass.org/24hours/fall2012/SessionsbySchedule.aspx">24 Hours of PASS coming up on September 20th and 21st</a>. &nbsp;Registration for the twenty-four hours of around the clock presentations is completely free and well worth your time. &nbsp;Check the schedule for the event and register! &nbsp;Even if you can only watch one or two sessions (or even zero sessions), be sure to register so that you'll automatically be notified when the sessions become available as streaming media.</p><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;">&nbsp;</p><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;">Enjoy!</p><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;">-Kev</p><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;">-Follow me on&nbsp;<a title="Kevin Kline on Twitter" href="http://twitter.com/kekline">Twitter</a>,&nbsp;<a title="Kevin Kline on LinkedIn" href="http://linkedin.com/kekline">LinkedIn</a>, and&nbsp;<a title="Kevin Kline on Facebook" href="http://facebook.com/kekline">Facebook</a></p><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;">&nbsp;</p>PASS Summit 2011 - Zen and the Art of Workspace Memory - Demoshttp://sqlblog.com/blogs/adam_machanic/archive/2011/10/16/pass-summit-2011-zen-and-the-art-of-workspace-memory-demos.aspxMon, 17 Oct 2011 00:23:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:39085Adam Machanic<p><b>What a rush</b>. Standing on the stage in an almost-full 1,000-person room, I (very) momentarily wondered what I'd been thinking when I submitted a 500-level talk for the biggest SQL Server conference in the world. But despite a rough start--my laptop crashed and I had to reboot it two minutes into the talk--I found my rhythm and the entire 90 minutes went by in a flash. I wish I'd been able to take 90 more!</p><p>The scene? <span style="font-weight:bold;">PASS Summit 2011</span>. Friday, October 14, 10:15 a.m. (Room 6E, to be exact.) The last day of one of the best PASS Summits I've had the pleasure of attending.</p><p>The topic? A fairly obscure area of SQL Server, called <b>workspace memory</b>. Here's the abstract for the talk:</p><blockquote><p><b>Query Tuning Mastery: Zen and the Art of Workspace Memory</b></p><p>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 teach you how to guide the query processor to grant enough memory for top performance, while also keeping things balanced for the sake of concurrency. You will learn advanced monitoring techniques, expert-level application of specialized query hints, and the memory internals needed to put it all together. 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. </p></blockquote><p>If you were in the audience,<b> I thank you for choosing my session </b>over the many others that were running concurrently. I had a great time, and I hope you did too.</p><p>The <b>demos </b>for the talk are attached to this post. Apologies, but I am not sharing the deck at this time as I'm going to be integrating it into a larger course that I hope to start delivering next year. (Through <a href="http://dataeducation.com/">Data Education</a>, naturally!)<br></p><p><b>Enjoy!</b> And as always, let me know in the comments if you have any questions.<br></p>Where Can You Find Me the Rest of This Year?http://sqlblog.com/blogs/adam_machanic/archive/2011/08/21/where-can-you-find-me-the-rest-of-this-year.aspxMon, 22 Aug 2011 00:28:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:37983Adam Machanic<p>Autumn is creeping inevitably closer here in the US, and that means that speaking season is about to kick into high gear. Here's my current schedule for the remainder of the year:</p><p>&nbsp;</p><p><b>September 8, 17:00 GMT (online)</b> - <a href="http://www.sqlpass.org/24hours/fall2011/SessionsbySchedule/BaselineBasicsorWhoBroketheDatabase.aspx">24 Hours of PASS webcast: "Baseline Basics or: Who Broke the Database?"</a></p><blockquote><p>In this session, excerpted from my PASS Summit precon, I'll explain the whys and hows of using baselines to assist with performance tuning. <b>If you find yourself more often than not tuning <i>reactively </i>rather than <i>proactively</i></b>, this session is for you. This is a free webcast, so why not join in?<br></p></blockquote><p>&nbsp;</p><p><b>September 8, 18:30 EDT (Waltham, MA)</b> - <a href="http://nesql.org/">New England SQL Server Users Group: "Windowing Functions in SQL Server 2008, Denali, and Beyond"</a></p><blockquote><p>Two in one day! This session will kick off the 2011/2012 New England SQL Server season, and will cover what are (in my ever-so-humble opinion) <b>the most important T-SQL enhancements in the past three versions of SQL Server</b>: windowing function enhancements. I'll discuss what's there in today's shipping versions, and the new and incredibly powerful functionality that Denali brings to the table. If you're in the Boston area, don't miss it!</p><p>&nbsp;</p></blockquote><p><b>September 17 (Atlanta, GA)</b> - <a href="http://sqlsaturday.com/89/schedule.aspx">SQL Saturday #89: (Two Talks) </a></p><blockquote><p>After the great time I had at this year's TechEd show in Atlanta I could hardly wait to get back. Luckily,<b> the fantastic SQL Server community in the Atlanta area</b> scheduled this event, which gave me the perfect excuse to pack my bags for a return trip. The speaker lineup for this event is rock-solid, and I'll be contributing with two talks: my introductory dive into SQL Server parallelism, and an overview of my 15 favorite activity monitoring dynamic management objects. This should be a great event by anyone's standards, and it's <i>free</i>, so if you live nearby you have literally no excuse not to attend.<br></p></blockquote><blockquote><p>&nbsp;</p></blockquote><p><b>October 11,&nbsp; 08:30 PDT (Seattle, WA) -</b> <a href="http://www.sqlpass.org/summit/2011/Speakers/CallForSpeakers/SessionDetail.aspx?sid=1627">PASS Community Summit Pre-Conference Seminar: No More Guessing! An Enlightened Approach to Performance Troubleshooting</a></p><blockquote><p><b>No more guessing! It's not just a catchphrase; it's a way of life</b>. When faced with performance problems we have a choice: we can either run around panicking, wasting everyone's time (including our own), or we can use the huge amount of information at our disposal to figure out what's <i>actually</i> wrong and fix it. As the calm and collected type, I prefer the second option, and so should you. If you'll be attending the PASS conference, join me on Tuesday to learn how you, too, can quickly and accurately pinpoint the root cause of your performance issues.</p></blockquote><p>&nbsp;</p><p><b>October 12-14 (Seattle, WA)</b> - <a href="http://www.sqlpass.org/summit/2011/Speakers/CallForSpeakers/SessionDetail.aspx?sid=1256">PASS Community Summit Spotlight Session: Query Tuning Mastery: Zen and the Art of Workspace Memory</a></p><blockquote><p>Your query is running, and it needs to sort some data. Or to hash some data. Or to perform a parallel operation. These things take memory, and as any SQL Server professional knows, <b>in the world of SQL Server memory is worth much, much more than its weight in gold</b> (even given today's hugely-inflated prices). Attend this session to learn the ins and outs of workspace memory: what it is, why it's needed, where the memory comes from, and most importantly, how to control it to make certain queries faster and other queries not have to wait as long. Workspace memory tuning is a mostly untapped performance opportunity that many DBAs can heavily benefit from learning how to leverage. <br></p><p>&nbsp;</p></blockquote><p>&nbsp;<b>November 1-3 (Las Vegas, NV)</b> - <a href="http://www.devconnections.com/shows/fall2011/sessions.aspx?s=179">SQL Server Connections: (Three Talks)</a></p><blockquote><p>My final speaking engagement of the year will be <b>at the always-fun SQL Server Connections show in Vegas</b>. (It's in Vegas! How could it not be fun?!) I'll be doing three talks during the course of the show: An introductory talk on my favorite topic the past couple of years, parallelism in SQL Server; a much more advanced parallelism talk to build on that one; and a talk on the various dynamic management objects that can be used in the quest for ultimate SQL Server performance. Save a spot for me at the poker table!</p></blockquote><p>&nbsp;</p><p><b>I'm really looking forward to these events.</b> If you're going to be there let me know in the comments, and/or feel free to find me at any of the shows and say hi. (Buying me a drink or two wouldn't hurt either.) See you there! <br></p>