<?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' and 'community'</title><link>http://sqlblog.com/search/SearchResults.aspx?o=DateDescending&amp;tag=SQL,community&amp;orTags=0</link><description>Search results matching tags 'SQL' and 'community'</description><dc:language>en-US</dc:language><generator>CommunityServer 2.1 SP2 (Build: 61129.1)</generator><item><title>“Fabulous”</title><link>http://sqlblog.com/blogs/rob_farley/archive/2012/04/19/fabulous.aspx</link><pubDate>Thu, 19 Apr 2012 22:46:04 GMT</pubDate><guid isPermaLink="false">21093a07-8b3d-42db-8cbf-3350fcbf5496:42904</guid><dc:creator>rob_farley</dc:creator><description>&lt;p&gt;I don’t tend to find that anything about me gets described as “Fabulous”. It’s not a word I ever use myself, so I was slightly amused to see it &lt;a href="http://www.sqlsaturday.com/119/eventhome.aspx" target="_blank"&gt;here&lt;/a&gt;.&lt;/p&gt;  &lt;p&gt;&lt;a href="http://www.sqlsaturday.com/119/eventhome.aspx" target="_blank"&gt;&lt;img style="background-image:none;border-bottom:0px;border-left:0px;padding-left:0px;padding-right:0px;display:inline;border-top:0px;border-right:0px;padding-top:0px;" title="image" border="0" alt="image" src="http://sqlblog.com/blogs/rob_farley/image_255B4ED9.png" width="417" height="287" /&gt;&lt;/a&gt;&lt;/p&gt;  &lt;p&gt;It’s going to be an interesting week (in May, Monday 14th to Saturday 19th), in which I have two stints in classrooms (the &lt;a href="http://dataeducation.com/sqltraining/advanced-t-sql-querying-and-reporting-building-effectiveness" target="_blank"&gt;three day course in downtown Chicago&lt;/a&gt; and this pre-con), plus two presentations at the &lt;a href="http://www.sqlsaturday.com/119/schedule.aspx" target="_blank"&gt;main SQLSaturday event&lt;/a&gt;. I’ll be in a room freshly vacated by &lt;a href="http://www.sqlsaturday.com/viewsession.aspx?sat=119&amp;amp;sessionid=6495" target="_blank"&gt;Jes Borland&lt;/a&gt; (I suspect you'll probably be still able to smell the ‘squee’), and from the look of things, I’ll be delivering a solid 2.5 hours of material, with an intermission of 15 minutes. Mind you, with people in the other rooms like &lt;a href="http://www.sqlsaturday.com/viewsession.aspx?sat=119&amp;amp;sessionid=6516" target="_blank"&gt;Argenis&lt;/a&gt;, &lt;a href="http://www.sqlsaturday.com/viewsession.aspx?sat=119&amp;amp;sessionid=6483" target="_blank"&gt;Ted&lt;/a&gt; and &lt;a href="http://www.sqlsaturday.com/viewsession.aspx?sat=119&amp;amp;sessionid=8069" target="_blank"&gt;Erin&lt;/a&gt;, I’m not sure I’ll have much of a crowd. It might be more like “An Intimate Afternoon with Rob Farley” with whoever’s left.&lt;/p&gt;  &lt;p&gt;&lt;a href="http://dataeducation.com/sqltraining/advanced-t-sql-querying-and-reporting-building-effectiveness" target="_blank"&gt;The course&lt;/a&gt; will be the highlight of my week. I love teaching this course – it’s a great time to be able to get people in a room for a few days and go through ways to make queries better. More effective. It has “Advanced T-SQL” in the title, but I really try to focus on the “Effectiveness” aspect. Yes, we’ll look at a bunch of advanced features, and your T-SQL arsenal will grow, but the idea is to arm you with the information you need to be able to have more effective T-SQL. Advanced is only better when it’s more effective. It’s going to be a really fun few days, as I stretch your thinking and make you look at T-SQL in a new way.&lt;/p&gt;  &lt;p&gt;&lt;a href="http://dataeducation.com/sqltraining/advanced-t-sql-querying-and-reporting-building-effectiveness" target="_blank"&gt;&lt;img style="background-image:none;border-bottom:0px;border-left:0px;padding-left:0px;padding-right:0px;display:inline;border-top:0px;border-right:0px;padding-top:0px;" title="image" border="0" alt="image" src="http://sqlblog.com/blogs/rob_farley/image_47CF1BED.png" width="397" height="213" /&gt;&lt;/a&gt;&lt;/p&gt;  &lt;p&gt;The pre-con is going to be very different. We’ll be going through the &lt;a href="http://www.microsoft.com/learning/en/us/exam.aspx?id=70-461#tab2" target="_blank"&gt;syllabus of the new 70-461 exam&lt;/a&gt;, teaching you about all the ins and outs of the various features, leaving you in a position to be able to confidently take the exam. I’ve sat this exam in beta, but of course I can’t use any inside knowledge I gained from that to teach this. There’s a lot of stuff to get through. Each of the four sections has four or five bullet points underneath, and even more sub-points under that. We’ll be pushing through a lot of things, and a lot of the more basic stuff will certainly be skimmed through – but we’ll be looking deeper into a lot of the new things, and making sure that you get all the concepts on the exam. I can’t offer a proper guarantee that you’ll pass – some people just take exams badly. But as we’ll also be looking at a bunch of exam technique aspects, I think you'll be fine.&lt;/p&gt;  &lt;p&gt;The two sessions that I’m doing at the SQLSaturday #119 are two of my favourite talks. &lt;/p&gt;  &lt;p&gt;One of them is on &lt;a href="http://www.sqlsaturday.com/viewsession.aspx?sat=119&amp;amp;sessionid=8484" target="_blank"&gt;SARGability&lt;/a&gt;. I remember doing this talk with a bunch of MVPs in the room (and a certain cloudy Microsoft employee), and even they said “Ooh – I didn’t know that” afterwards. SARGability – the ability to use indexes effectively – is such a significant aspect of querying, and a pet topic of mine (as regular readers will realise). SQL Server even provides a bunch of methods you can use to improve the SARGability, even if you can’t tweak the queries themselves. Very cool stuff. And did I mention I won’t have slides?&lt;/p&gt;  &lt;p&gt;The other is on &lt;a href="http://www.sqlsaturday.com/viewsession.aspx?sat=119&amp;amp;sessionid=8486" target="_blank"&gt;Analytic Functions&lt;/a&gt; (a talk which I’m currently doing around Australia and New Zealand at SQLSaturday &lt;a href="http://sqlsaturday.com/135/eventhome.aspx" target="_blank"&gt;135&lt;/a&gt;, &lt;a href="http://sqlsaturday.com/136/eventhome.aspx" target="_blank"&gt;136&lt;/a&gt;, &lt;a href="http://sqlsaturday.com/138/eventhome.aspx" target="_blank"&gt;138&lt;/a&gt;, &lt;a href="http://sqlsaturday.com/139/eventhome.aspx" target="_blank"&gt;139&lt;/a&gt; and &lt;a href="http://sqlsaturday.com/140/eventhome.aspx" target="_blank"&gt;140&lt;/a&gt;). There are eight new Analytic Functions in SQL 2012, plus some new enhancements to the OVER clause. I’ll be running through these, and I’m sure you’ll leave the room with new ideas to try to enhance your reporting and data analysis.&lt;/p&gt;  &lt;p&gt;See you there?&lt;/p&gt;</description></item><item><title>Adelaide's SQL Tuesday</title><link>http://sqlblog.com/blogs/rob_farley/archive/2012/04/18/adelaide-s-sql-tuesday.aspx</link><pubDate>Wed, 18 Apr 2012 08:36:42 GMT</pubDate><guid isPermaLink="false">21093a07-8b3d-42db-8cbf-3350fcbf5496:42866</guid><dc:creator>rob_farley</dc:creator><description>&lt;p&gt;This coming Tuesday sees a midweek &lt;a href="http://sqlsaturday.com/139/eventhome.aspx" target="_blank"&gt;SQL Saturday hit Adelaide&lt;/a&gt;. LobsterPot’s a sponsor, as are a &lt;a href="http://sqlsaturday.com/139/sponsors.aspx" target="_blank"&gt;bunch of other companies&lt;/a&gt;.&lt;img style="margin:5px;display:inline;float:right;" align="right" src="http://www.sqlsaturday.com/images/sqlsat139_web.png" /&gt;&lt;/p&gt;  &lt;p&gt;An all day event, with two tracks featuring &lt;a href="http://sqlsaturday.com/139/schedule.aspx" target="_blank"&gt;some of the best material you’ve ever seen presented&lt;/a&gt;. I’m presenting too.&lt;/p&gt;  &lt;p&gt;The thing I really want to draw your attention to is that we have two sessions from &lt;a href="http://sqlblog.com/blogs/paul_white" target="_blank"&gt;Paul White&lt;/a&gt;. If you haven’t heard of Paul, click the link to have a look at his blog. When you’ve picked your jaw up and some of the mind-blowing information he likes to write about, imagine yourself sitting in sessions by him. I’ve just got back from Wellington where &lt;a href="http://sqlsaturday.com/viewsession.aspx?sat=136&amp;amp;sessionid=8411" target="_blank"&gt;I heard him for an hour&lt;/a&gt;, and knew that giving him two sessions was completely the right choice. Everyone left the room wishing that he could’ve gone on longer, and I suspect Paul will be somewhat caught up for questions for the rest of the day, as people try to pick his brain about some of the Query Optimizer things he can teach. He’s been scheduled for the morning so that attendees can have plenty of opportunity to see him around for the rest of the day. It’s his first time ever to Australia, so it’s completely brilliant to have him come to Adelaide for this event.&lt;/p&gt;  &lt;p&gt;I shouldn’t suggest that the other sessions won’t be excellent though. &lt;a href="http://sqlsaturday.com/viewsession.aspx?sat=139&amp;amp;sessionid=8197" target="_blank"&gt;Peter Ward’s session about the $10000 question&lt;/a&gt; has been very well received at SQLSaturday events so far, as have the sessions by &lt;a href="http://sqlsaturday.com/viewsession.aspx?sat=139&amp;amp;sessionid=8388" target="_blank"&gt;Roger Noble&lt;/a&gt; and &lt;a href="http://sqlsaturday.com/viewsession.aspx?sat=139&amp;amp;sessionid=8092" target="_blank"&gt;Paul te Braak&lt;/a&gt;. Combining these with &lt;a href="http://sqlsaturday.com/viewsession.aspx?sat=139&amp;amp;sessionid=8709" target="_blank"&gt;Microsoft’s Raja N presenting about the Database Consolidation Appliance&lt;/a&gt;, some excellent &lt;a href="http://sqlsaturday.com/viewsession.aspx?sat=139&amp;amp;sessionid=8039" target="_blank"&gt;local&lt;/a&gt; &lt;a href="http://sqlsaturday.com/viewsession.aspx?sat=139&amp;amp;sessionid=8087" target="_blank"&gt;speakers&lt;/a&gt;, a terrific &lt;a href="http://sqlsaturday.com/viewsession.aspx?sat=139&amp;amp;sessionid=7932" target="_blank"&gt;sponsor-session from Fusion-io&lt;/a&gt; (and a couple of spots from me), and I’m sure you’ll agree that this event is definitely worth getting to.&lt;/p&gt;  &lt;p&gt;Numbers are limited and being a free event it may well sell out. So &lt;a href="http://sqlsaturday.com/139/register.aspx" target="_blank"&gt;get yourself registered&lt;/a&gt; (but I’d recommend &lt;a href="http://sqlsaturday.com/registeruser.aspx" target="_blank"&gt;joining PASS first&lt;/a&gt;, which gives you a bunch of extra benefits and there’s no extra effort involved), and I’ll see you there.&lt;/p&gt;  &lt;p&gt;It’s in less than a week!&lt;/p&gt;</description></item><item><title>24 Hours of PASS – first reflections</title><link>http://sqlblog.com/blogs/rob_farley/archive/2012/03/25/24-hours-of-pass-first-reflections.aspx</link><pubDate>Mon, 26 Mar 2012 02:03:21 GMT</pubDate><guid isPermaLink="false">21093a07-8b3d-42db-8cbf-3350fcbf5496:42480</guid><dc:creator>rob_farley</dc:creator><description>&lt;p&gt;A few days after the end of 24HOP, I find myself reflecting on it.&lt;/p&gt;  &lt;p&gt;I’m still waiting on most of the information. I want to be able to discover things like where the countries represented on each of the sessions, and things like that. So far, I have the feedback scores and the numbers of attendees. The data was provided in a PDF, so while I wait for it to appear in a more flexible format, I’ve pushed the 24 attendee numbers into Excel.&lt;/p&gt;  &lt;p&gt;&lt;img style="background-image:none;border-bottom:0px;border-left:0px;padding-left:0px;padding-right:0px;display:inline;border-top:0px;border-right:0px;padding-top:0px;" title="24hop_attendees" border="0" alt="24hop_attendees" src="http://sqlblog.com/blogs/rob_farley/24hop_attendees_7ECBD202.png" width="517" height="175" /&gt;&lt;/p&gt;  &lt;p&gt;This chart shows the numbers by time. Remember that we started at midnight GMT, which was 10:30am in my part of the world and 8pm in New York. It’s probably no surprise that numbers drooped a bit at the start, stayed comparatively low, and then grew as the larger populations of the English-speaking world woke up. &lt;/p&gt;  &lt;p&gt;I remember last time 24HOP ran for 24 hours straight, there were quite a few sessions with less than 100 attendees. None this time though. We got close, but even when it was 4am in New York, 8am in London and 7pm in Sydney (which would have to be the worst slot for attracting people), we still had over 100 people tuning in.&lt;/p&gt;  &lt;p&gt;As expected numbers grew as the UK woke up, and even more so as the US did, with numbers peaking at 755 for the “3pm in New York” session on SQL Server Data Tools. Kendra Little almost reached those numbers too, and certainly contributed the biggest ‘spike’ on the chart with her session five hours earlier. Of all the sessions, Kendra had the highest proportion of ‘Excellent’s for the “Overall Evaluation of the session” question, and those of you who saw her probably won’t be surprised by that. Kendra had one of the best ranked sessions from the 24HOP event this time last year (narrowly missing out on being top 3), and she has produced a lot of good video content since then.&lt;/p&gt;  &lt;p&gt;The reports indicate that there were nearly 8.5 thousand attendees across the 24 sessions, averaging over 350 at each one. I’m looking forward to seeing how many different people that was, although I do know that Wil Sisney managed to attend every single one (if you did too, please let me know). Wil even moderated one of the sessions, which made his feat even greater. Thanks Wil.&lt;/p&gt;  &lt;p&gt;I also want to send massive thanks to Dave Dustin. Dave probably would have attended all of the sessions, if it weren’t for a power outage that forced him to take a break. He was also a moderator, and it was during this session that he earned special praise. Part way into the session he was moderating, the speaker lost connectivity and couldn’t get back for about fifteen minutes. That’s an incredibly long time when you’re in a live presentation. There were over 200 people tuned in at the time, and I’m sure Dave was as stressed as I was to have a speaker disappear. I started chasing down a phone number for the speaker, while Dave spoke to the audience. And he did brilliantly. He started answering questions, and kept doing that until the speaker came back. Bear in mind that Dave hadn’t expected to give a presentation on that topic (or any other), and was simply drawing on his SQL expertise to get him through. Also consider that this was between midnight at 1am in Dave’s part of the world (Auckland, NZ). I would’ve been expecting just to welcome people, monitor questions, probably read some out, and in general, help make things run smoothly. He went far beyond the call of duty, and if I had a medal to give him, he’d definitely be getting one.&lt;/p&gt;  &lt;p&gt;On the whole, I think this 24HOP was a success. We tried a different platform, and I think for the most part it was a popular move. We didn’t ask the question “Was this better than LiveMeeting?”, but we did get a number of people telling us that they thought the platform was very good.&lt;/p&gt;  &lt;p&gt;Some people have told me I get a chance to put my feet up now that this is over. As I’m also co-ordinating a tour of SQLSaturday events across the Australia/New Zealand region, I don’t quite get to take that much of a break (plus, there’s the little thing of squeezing in seven SQL 2012 exams over the next 2.5 weeks). But I am pleased to be reflecting on this event rather than anticipating it. There were a number of factors that could have gone badly, but on the whole I’m pleased about how it went. A massive thanks to everyone involved.&lt;/p&gt;  &lt;p&gt;If you’re reading this and thinking you wish you could’ve tuned in more, don’t worry – they were all recorded and you’ll be able to watch them on demand very soon. But as well as that, PASS has a stream of content produced by the Virtual Chapters, so you can keep learning from the comfort of your desk all year round. More info on them at sqlpass.org, of course.&lt;/p&gt;</description></item><item><title>24 hours to pass until 24 Hours of PASS</title><link>http://sqlblog.com/blogs/rob_farley/archive/2012/03/19/24-hours-to-pass-until-24-hours-of-pass.aspx</link><pubDate>Tue, 20 Mar 2012 00:03:18 GMT</pubDate><guid isPermaLink="false">21093a07-8b3d-42db-8cbf-3350fcbf5496:42401</guid><dc:creator>rob_farley</dc:creator><description>&lt;p&gt;There’s a bunch of stuff going on at the moment in the SQL world, so if you’ve missed this particular piece of news, let me tell you a bit about it.&lt;/p&gt;  &lt;p&gt;Twice a year, the SQL community puts on its biggest virtual event – 24 Hours of PASS. And the next one is tomorrow – March 21&lt;sup&gt;st&lt;/sup&gt;, 2012. Twenty-four sessions, back-to-back, featuring a selection of some of the best presenters in the SQL world, speakers from all over the world, coming together in an online collaboration that so far has well over thirty thousand registrations across the presentations. Some people are signed up for all 24 sessions, some only one.&lt;/p&gt;  &lt;p&gt;Traditionally, LiveMeeting has been used as the platform for this event, but this year we’re going with a new platform – IBTalk. It promises big, and we’re hoping it won’t let us down. LiveMeeting has been great, and we thank Microsoft for providing it as a platform for the past few years. However, as the event has grown, we’ve found that a new idea is necessary. Last year a search was done for a new platform, and IBTalk ticked the right boxes. The feedback from the presenters and moderators so far has been overwhelmingly positive, and we’re hoping that this is going to really enhance the user experience.&lt;/p&gt;  &lt;p&gt;One of my favourite features of the platform is the language side. It provides a pretty good translation service. Users who join a session will see a flag on the left of the screen. If they click it, they can change the language to one of 15 on offer. Picking this changes all the labels on everything. It even translates the text in the Q&amp;amp;A window. &lt;/p&gt;  &lt;p&gt;&lt;img style="background-image:none;border-bottom:0px;border-left:0px;padding-left:0px;padding-right:0px;display:inline;border-top:0px;border-right:0px;padding-top:0px;" title="" border="0" alt="" src="http://sqlblog.com/blogs/rob_farley/clip_image002_48599812.jpg" width="470" height="341" /&gt;&lt;/p&gt;  &lt;p&gt;What this means is that someone from Brazil can ask their question in Portuguese, and the presenter will see it in English. Then if the answer is typed in English, the questioner will be able to see the answer, also in Portuguese. Or they can switch to English to see it as the answerer typed it. I know there’s always the risk of bad translations going on, but I’ve heard good things about this translation service. &lt;/p&gt;  &lt;p&gt;But there’s more – IBTalk are providing staff to type up closed captioning live during the event. So if English isn’t your first language, don’t worry!&lt;/p&gt;  &lt;p&gt;Picking your language will also let you see subtitles in your chosen language. I’m hoping that this event is the start of PASS being able to reach people from all corners of the world. Wouldn’t it be great to find that this event is successful, and that the next 24HOP (later in the year, our Summit Preview event) has just as many non-English speakers tuning in as English speakers?&lt;/p&gt;  &lt;p&gt;If you haven’t been planning which sessions you’re going to attend, you really should get over to &lt;a href="http://www.sqlpass.org/24hours"&gt;sqlpass.org/24hours&lt;/a&gt; and have a look through what’s on offer. There’s some amazing material from some of the industry’s brightest, covering a wide range of topics, from classic SQL areas to the brand new SQL 2012 features. There really should be something for every SQL professional. Check the time zones though – if you’re in the US you might be on Summer time, and an hour closer to GMT than normal.&lt;/p&gt;  &lt;p&gt;Massive thanks must go to Microsoft, SQL Sentry and Idera for sponsoring this event. Without sponsors we wouldn’t be able to put any of this on. These companies are helping 24HOP continue to grow into an event for the whole world.&lt;/p&gt;  &lt;p&gt;See you tomorrow!&lt;/p&gt;  &lt;p&gt;&lt;a href="http://twitter.com/rob_farley"&gt;@rob_farley&lt;/a&gt; | &lt;a href="https://twitter.com/search/24hop"&gt;#24hop&lt;/a&gt; | &lt;a href="https://twitter.com/search/sqlpass"&gt;#sqlpass&lt;/a&gt;&lt;/p&gt;</description></item><item><title>SQLRally Nordic gets underway</title><link>http://sqlblog.com/blogs/rob_farley/archive/2011/11/08/sqlrally-nordic-gets-underway.aspx</link><pubDate>Tue, 08 Nov 2011 10:56:01 GMT</pubDate><guid isPermaLink="false">21093a07-8b3d-42db-8cbf-3350fcbf5496:39699</guid><dc:creator>rob_farley</dc:creator><description>&lt;p&gt;&lt;a href="http://sqlpass.org" target="_blank"&gt;PASS&lt;/a&gt; is becoming more international, which is great.&lt;a href="http://www.sqlpass.org/sqlrally/2011/nordic/" target="_blank"&gt;&lt;img style="background-image:none;border-bottom:0px;border-left:0px;margin:5px;padding-left:0px;padding-right:0px;display:inline;float:right;border-top:0px;border-right:0px;padding-top:0px;" title="" border="0" alt="" align="right" src="http://sqlblog.com/blogs/rob_farley/image_016CE92D.png" width="311" height="441" /&gt;&lt;/a&gt;&lt;/p&gt;  &lt;p&gt;The SQL Community has always been international – it’s not as if data is only generated in North America. And while it’s easy for organisations to have a North American focus, PASS is taking steps to become international. Regular readers will be aware that I’m one of three advisors to the &lt;a target="_blank"&gt;PASS Board of Directors&lt;/a&gt;, with a focus on developing PASS as a more global organisation. &lt;/p&gt;  &lt;p&gt;With this in mind, it’s great that today is Day 1 of &lt;a href="http://www.sqlpass.org/sqlrally/2011/nordic/" target="_blank"&gt;SQLRally Nordic&lt;/a&gt;, being hosted in in Sweden – not only a non-American country, but one that doesn’t have English as its major language.&lt;/p&gt;  &lt;p&gt;The event has been hosted by the amazing Johan Åhlén and Raoul Illyés, two guys who I met earlier this year, but the thing that amazes me is the incredible support that this event has from the SQL Community.&lt;/p&gt;  &lt;p&gt;It’s been sold out for a long time, and when you see the &lt;a href="http://www.sqlpass.org/sqlrally/2011/nordic/Speakers.aspx" target="_blank"&gt;list of speakers&lt;/a&gt;, it’s not surprising.&lt;/p&gt;  &lt;p&gt;Some of the industry’s biggest names from Microsoft have turned up, including Mark Souza (who is also a PASS Director), Thomas Kejser and Tobias Thernström. Business Intelligence experts such as Jen Stirrup, Chris Webb, Peter Myers, Marco Russo and Alberto Ferrari are there, as are some of the most awarded SQL MVPs such as Itzik Ben-Gan, Aaron Bertrand and Kevin Kline. The &lt;a href="http://www.sqlpass.org/sqlrally/2011/nordic/Sponsors.aspx" target="_blank"&gt;sponsor list&lt;/a&gt; is also brilliant, with names such as HP, FusionIO, SQL Sentry, Quest and SolidQ complimented by Swedish companies like Cornerstone, Informator, B3IT and Addskills. &lt;/p&gt;  &lt;p&gt;As someone who is interested in PASS becoming global, I’m really excited to see this event happening, and I hope it’s a launch-pad into many other international events hosted by the SQL community. &lt;/p&gt;  &lt;p&gt;If you have the opportunity, thank Johan and Raoul for putting this event on, and the speakers and sponsors for helping support it. The noise from Twitter is that everything is going fantastically well, and everyone involved should be thoroughly congratulated!&lt;/p&gt;  &lt;p&gt;&lt;a href="http://twitter.com/rob_farley" target="_blank"&gt;@rob_farley&lt;/a&gt;&lt;/p&gt;</description></item><item><title>Highlights and Lowlights of PASS Summit 2011</title><link>http://sqlblog.com/blogs/rob_farley/archive/2011/10/18/highlights-and-lowlights-of-pass-summit-2011.aspx</link><pubDate>Tue, 18 Oct 2011 13:23:07 GMT</pubDate><guid isPermaLink="false">21093a07-8b3d-42db-8cbf-3350fcbf5496:39152</guid><dc:creator>rob_farley</dc:creator><description>&lt;p&gt;This was a proper big week.&lt;/p&gt;  &lt;p&gt;The PASS Summit ran from Tuesday night to Friday, but I’d arrived in America the Friday before. So by the time it actually started, I had that strange feeling that things were wrapping up. My calendar was ridiculously full. The stuff that I was aware of ahead of time looked like this:&lt;/p&gt;  &lt;p&gt;Friday 7th: Arrive in America. Travel to Portland. Speaker Dinner.&lt;/p&gt;  &lt;p&gt;Saturday 8th: SQL Saturday #92 (two sessions to give, plus a song performance with Buck during the morning break). Charity dinner for The Leukemia &amp;amp; Lymphoma Society (whom LobsterPot sponsor).&lt;/p&gt;  &lt;p&gt;Sunday 9th: Walk the Portland Half Marathon. Travel to Seattle. Collect my kilt. Register for the Summit.&lt;/p&gt;  &lt;p&gt;Monday 10th: Early morning prayer meeting. Deliver a pre-conference seminar. Insiders Dinner in evening.&lt;/p&gt;  &lt;p&gt;Tuesday 11th: Early morning prayer meeting. Meeting about SQL Saturday. PASS Board Meeting. Insiders Day at the Microsoft Campus. Opening Night Party, including being a Quiz Bowl contestant. Speaker/Volunteer Dinner.&lt;/p&gt;  &lt;p&gt;Wednesday 12th: Early morning prayer meeting. Chapter leaders’ meeting. Chapter lunch. Book signing. Lightning Talk to deliver (my song). Global Growth meeting. Exhibitors’ party. Parties for SQL People, SQL Sentry, SolidQ and SQLKaraoke.&lt;/p&gt;  &lt;p&gt;Thursday 13th: Early morning prayer meeting. WIT Lunch. Spotlight session to deliver. Redgate Dinner. Party at Gameworks.&lt;/p&gt;  &lt;p&gt;Friday 14th: Early morning prayer meeting. More book signing. Board Q&amp;amp;A session. Board photos.&lt;/p&gt;  &lt;p&gt;Saturday 15th: Sleep in and fly home.&lt;/p&gt;  &lt;p&gt;That’s the short version. Really. There were a lot of other things that were squeezed in – in particular, the fact that I had promised Audrey Hammonds about six months ago that I would run through her presentation with her, and one other thing that became somewhat significant: THE FACT THAT ALLEN KINSEL ARRANGED FOR ME TO PERFORM MY SONG DURING THE FRIDAY KEYNOTE.&lt;/p&gt;  &lt;p&gt;Readers of my blog (and plenty of other blogs) will know by now that I played my guitar and sang at the start of the Friday Keynote. Buck Woody accompanying me with his guitar and backing vocals. What you might not know is that this only got arranged late on Wednesday night. Allen had seen me perform it (again with Buck) during the Lightning Talks on Wednesday afternoon, and by the time the night was over, Buck and I were booked in to perform it in front of the &lt;strong&gt;three and a half thousand&lt;/strong&gt; delegates at the biggest keynote of the week. I’ve played and sang before a couple of hundred before, but never even close to that many. To say I had mixed emotions would’ve been an understatement. I didn’t hesitate to say yes, and was excited, but was also phenomenally nervous. &lt;/p&gt;  &lt;p&gt;As a late entry to a tight schedule, we got two minutes only and had to cut the song short. We didn’t sing the bridge section, so stopped after just Verse Chorus Verse Chorus. It was tremendous fun, and I loved seeing faint glows of phones being waved around in the crowd. I desperately wanted to look into the crowd as I was walking off stage, but my nerves and the fear of tripping on the guitar lead froze me completely and I didn’t turn my head at all. I was told later that there was a standing ovation – but I was just full of emotion, and so tired. So tired. It was my own fault – I’d gone out with Microsoft people after the various parties, and when they’d all gone to bed for a couple of hours around 5:30am, I’d got myself ready to lead a quick song at the 6am prayer meeting head off to my 6:15am sound check, prior to the 7:15am book signing. I got through the day (although I fell asleep for a few minutes during Audrey’s session, which I will need to watch to see how she did). I eventually got to bed around 10:30pm Friday night, and about twelve hours later managed to get up with just enough time to pack and check out of the hotel for noon.&lt;/p&gt;  &lt;p&gt;But this wasn’t the highlight for me. &lt;/p&gt;  &lt;p&gt;Nor was the highlight the fact that my level of involvement was so much greater, now that I’m a Board Member. I have to admit that I always get so much more out of events like this if I’m involved. I appreciate that I can get to more sessions if I’m not already laden with other entries on my calendar, but I would rather serve others wherever possible. I’m still new on the board, but as an advisor, I’m hoping to be able to influence things like the Summit more and more next year, and maybe there will be a few areas in which we can find opportunity to improve it still.&lt;/p&gt;  &lt;p&gt;Serving is great – but wasn’t the highlight.&lt;/p&gt;  &lt;p&gt;The highlight was the people. It always is, and it always will be. Right from the moment I arrived in America and tracked down John &amp;amp; Yanni Robel and Jes Borland. Arriving in Portland and seeing Jeremiah &amp;amp; Kendra, Buck Woody, Tim Ford, Erin Stellato and many more at the SQLSaturday events. Participating in the Portland Half Marathon with Erin, Jes, Yanni, Brent Ozar, Karen Lopez, Doug Lane (who did 10km) and Allen White (who did the full marathon), and a lots of people wearing the LobsterPot logo on their shirts. And despite not being able to run (I physically can’t run because of an old back injury, so I just walked it), I didn’t even finish last of the half marathoners! For all the extra pain I felt because my back isn’t really up to walking 21km in 3 hours, it was worth it. I’m especially proud of Yanni, who has achieved amazing things despite having a nasty blood cancer.&lt;/p&gt;  &lt;p&gt;Despite Sunday being a ridiculously early start and a very long day, each day started with 6am prayer meetings. But this gave the opportunity to start each day on a good note, meet even more people (like Matt “Mrs” Slocum), and to figure out some of why I always click so well with friends like Stacia Misner. &lt;/p&gt;  &lt;p&gt;Even the time I spent moving from one spot to another was a chance to see people and grow friendships deeper. I think of the night I was heading back to my hotel after the walk back from one of the parties had gone past the other hotels, and I bumped into the “Damn Strates” (Jason &amp;amp; Sarah), only to spend an hour talking with them about a number of different things. Or the time spent talking with one of the industry’s newest and brightest lights Jes Borland, who thinks she can out-talk me. Or the time with fellow board members JRJ, MarkS &amp;amp; Lara, which is time I can’t help but enjoy as the conversations switch over and over from flippant to serious and back again.&lt;/p&gt;  &lt;p&gt;Oh, and the lowlight was losing my prescription sunglasses. That’s a real pain.&lt;/p&gt;  &lt;p&gt;The SQL community has something very special, that other communities should be jealous of. These people genuinely love each other, and it’s really good to see and to be part of it. I’ve seen the same at SQLBits, but not in many other contexts.&lt;/p&gt;  &lt;p&gt;&lt;a href="http://twitter.com/rob_farley" target="_blank"&gt;@rob_farley&lt;/a&gt;&lt;/p&gt;  &lt;p&gt;PS: Apologies to everyone for not having links on your names. I wrote this on a plane without connectivity.&lt;/p&gt;</description></item><item><title>I should've looked the other way</title><link>http://sqlblog.com/blogs/rob_farley/archive/2011/10/15/i-should-ve-looked-the-other-way.aspx</link><pubDate>Sat, 15 Oct 2011 18:08:00 GMT</pubDate><guid isPermaLink="false">21093a07-8b3d-42db-8cbf-3350fcbf5496:39062</guid><dc:creator>rob_farley</dc:creator><description>&lt;p&gt;The words for that song I did at the PASS Summit 2011 are as follows. On the Friday, I stopped where the bridge starts. Various recordings of it are making it to YouTube, such as &lt;a href="http://youtu.be/ST-JmMc7R9U" target="_blank"&gt;here&lt;/a&gt;, where the song starts around 2:20 in.&lt;/p&gt;
  
&lt;p&gt;&lt;strong&gt;I should've looked the other way     &lt;br&gt;&lt;/strong&gt;     &lt;br&gt;Verse 1:    &lt;br&gt;My query sucks - it takes too long    &lt;br&gt;So long I wrote this song    &lt;br&gt;The plan's not big - it ain't a giant    &lt;br&gt;And yet I have an angry client    &lt;br&gt;Performance now has made her weary    &lt;br&gt;So I've come in to fix her query    &lt;br&gt;I promise I won't ever fail her    &lt;br&gt;Say "Trust me, love, I'm from Australia!"    &lt;br&gt;     &lt;br&gt;Chorus:    &lt;br&gt;I need to find you    &lt;br&gt;But I don't want to search every row    &lt;br&gt;My predicate's residual    &lt;br&gt;My seek just runs too slow    &lt;br&gt;I thought I'd caught a glimpse of you    &lt;br&gt;Been searching for all day    &lt;br&gt;But all along, I'd done it wrong    &lt;br&gt;I should've looked the other way    &lt;br&gt;     &lt;br&gt;Verse 2:    &lt;br&gt;A trace is on, I know the reads    &lt;br&gt;That fetch the bytes the query needs    &lt;br&gt;There's spooling from a CTE    &lt;br&gt;They've got recursion needlessly    &lt;br&gt;I need to dig a little further    &lt;br&gt;I worry there might be a cursor    &lt;br&gt;The DBA has the plan_handle    &lt;br&gt;He says it's not corrupt, he knows Paul Randal!    &lt;br&gt;     &lt;br&gt;Repeat chorus    &lt;br&gt;     &lt;br&gt;Bridge:    &lt;br&gt;There is an index covering predicates with keys    &lt;br&gt;But my developer has used inequalities     &lt;br&gt;There is a range scan     &lt;br&gt;Hiding truth     &lt;br&gt;Hiding cost    &lt;br&gt;Hiding you...    &lt;br&gt;     &lt;br&gt;Repeat chorus x2&lt;/p&gt;
  
&lt;p&gt;I should've looked the other way&lt;/p&gt;
  
&lt;p&gt;© 2011 Rob Farley ;)&lt;/p&gt;
  
&lt;p&gt;&lt;a href="http://twitter.com/rob_farley" target="_blank"&gt;@rob_farley&lt;/a&gt;&lt;/p&gt;</description></item><item><title>Data, Information and Knowledge</title><link>http://sqlblog.com/blogs/rob_farley/archive/2011/10/13/data-information-and-knowledge.aspx</link><pubDate>Thu, 13 Oct 2011 16:50:43 GMT</pubDate><guid isPermaLink="false">21093a07-8b3d-42db-8cbf-3350fcbf5496:39033</guid><dc:creator>rob_farley</dc:creator><description>&lt;p&gt;Hopefully my connection is slightly better during today’s keynote than it was during yesterday’s, when “Live Blogging” didn’t really cut it. The PASS staff saw the problem and have resolved it (thanks guys!).&lt;/p&gt;  &lt;p&gt;Quentin Clark has jumped on stage to talk some more about SQL Server 2012, and he started with the expression “Data, Information and Knowledge”. I love this – I see Business Intelligence about extracting information from data, and it’s good to have Microsoft see this priority across the whole SQL platform.&lt;/p&gt;  &lt;p&gt;He’s also talking about the 12 biggest features of SQL Server 2012, which he says has more new features than any release of SQL Server yet.&lt;/p&gt;  &lt;p&gt;&lt;strong&gt;1. Required 9s&lt;/strong&gt;&lt;/p&gt;  &lt;ul&gt;   &lt;li&gt;Integration Services as a Server&lt;/li&gt;    &lt;li&gt;HA for StreamInsight&lt;/li&gt;    &lt;li&gt;SQL Server AlwaysOn.&lt;/li&gt; &lt;/ul&gt;  &lt;p&gt;SQL Server has seen uptime as a key component for a long time, but to provide High Availability for StreamInsight is particularly significant. StreamInsight involves being able to consume data at significant rates, being able to run queries against that data while it’s still on the move – before it’s even reached the relational database. High Availability for StreamInsight should be able to better provide strategies to ensure that streaming data need not be lost. Businesses suffer badly when they lose data. SQL Server 2012 should be able to reduce this problem almost completely.&lt;/p&gt;  &lt;p&gt;&lt;strong&gt;2. Blazing-Fast Performance&lt;/strong&gt;&lt;/p&gt;  &lt;ul&gt;   &lt;li&gt;Performance Enhancements – RDBMS, SSAS, SSIS&lt;/li&gt;    &lt;li&gt;ColumnStore Index&lt;/li&gt; &lt;/ul&gt;  &lt;p&gt;&lt;strong&gt;3. Rapid Data Exploration     &lt;br /&gt;4. Managed Self-Service BI&lt;/strong&gt;&lt;/p&gt;  &lt;ul&gt;   &lt;li&gt;Power View + PowerPivot&lt;/li&gt;    &lt;li&gt;Administration from SharePoint&lt;/li&gt;    &lt;li&gt;Reporting Alerts&lt;/li&gt; &lt;/ul&gt;  &lt;p&gt;Yes, “Power View” has a space in it. It’s the new name for Crescent, which is about self-service reporting using a Silverlight experience. I’m all for allowing users to interact with the data in powerful ways, but I’m also concerned about how to manage this. SharePoint seems to continue as the main platform for this, and although I’d love to see the administration of these reports be done inside SQL itself (instead of SharePoint), I get that SharePoint is currently the platform of choice. &lt;/p&gt;  &lt;p&gt;&lt;strong&gt;5. Credible, Consistent Data&lt;/strong&gt;&lt;/p&gt;  &lt;ul&gt;   &lt;li&gt;BI Semantic Model&lt;/li&gt;    &lt;li&gt;Data Quality Services&lt;/li&gt;    &lt;li&gt;Master Data Services&lt;/li&gt; &lt;/ul&gt;  &lt;p&gt;I’m not going to comment on this stuff right now – it’s been talked about plenty already, but the enhancements definitely look good. The new stuff around DQS lets you fix up data at a number of extra points and have it pushed back into the underlying warehouse.&lt;/p&gt;  &lt;p&gt;&lt;strong&gt;6. Organisational Compliance&lt;/strong&gt;&lt;/p&gt;  &lt;ul&gt;   &lt;li&gt;Expanded Audit – User-defined, Filtering&lt;/li&gt;    &lt;li&gt;User-defined Server Roles&lt;/li&gt; &lt;/ul&gt;  &lt;p&gt;This is useful. Audit is one of the massive things, and yet an administrator has always been able to turn it off. With the ability to have user-defined server roles, auditing turns into a much more real option.&lt;/p&gt;  &lt;p&gt;&lt;strong&gt;7. Peace of Mind&lt;/strong&gt;&lt;/p&gt;  &lt;ul&gt;   &lt;li&gt;Production-simulated Application Testing&lt;/li&gt;    &lt;li&gt;System Center Advisor &amp;amp; Management Packs&lt;/li&gt;    &lt;li&gt;Expanded Support – Premier Mission Critical&lt;/li&gt; &lt;/ul&gt;  &lt;p&gt;The Replay tools have become Distributed Replay, which is introduces a ton of really good options.&lt;/p&gt;  &lt;p&gt;&lt;strong&gt;8. Scalable Data Warehousing     &lt;br /&gt;9. Fast Time to Solution&lt;/strong&gt;&lt;/p&gt;  &lt;ul&gt;   &lt;li&gt;SQL Server Appliances – Optimised and Pre-tuned&lt;/li&gt;    &lt;li&gt;HW + SW + Support – Just Add Power&lt;/li&gt;    &lt;li&gt;Choice of Hardware&lt;/li&gt; &lt;/ul&gt;  &lt;p&gt;Appliances are stepping up. Buying an appliance, adding the network connection and electricity, and it’s ready to accept data in twenty minutes. The number of new options available suggests that the future of hardware buying will be even more focused on the appliance concept.&lt;/p&gt;  &lt;p&gt;&lt;strong&gt;10. Extend Any Data, Anywhere&lt;/strong&gt;&lt;/p&gt;  &lt;ul&gt;   &lt;li&gt;Greater Interoperability – new drivers for PHP, Java &amp;amp; Hadoop&lt;/li&gt;    &lt;li&gt;ODBC Drivers for Linux &amp;amp; Change Data Capture for SSIS &amp;amp; Oracle&lt;/li&gt;    &lt;li&gt;Beyond Relational: FileTable, 2D Spatial, Semantic Search&lt;/li&gt; &lt;/ul&gt;  &lt;p&gt;I really like the idea of CDC for Oracle, although I doubt there will be any &lt;/p&gt;  &lt;p&gt;&lt;strong&gt;11. Optimised Productivity&lt;/strong&gt;&lt;/p&gt;  &lt;ul&gt;   &lt;li&gt;SQL Server Data Tools (formerly “Juneau”)&lt;/li&gt;    &lt;li&gt;Unified Across Database &amp;amp; BI&lt;/li&gt;    &lt;li&gt;Deployment &amp;amp; Targeting Freedom&lt;/li&gt; &lt;/ul&gt;  &lt;p&gt;&lt;strong&gt;12. Scale on Demand&lt;/strong&gt;&lt;/p&gt;  &lt;ul&gt;   &lt;li&gt;AlwaysOn&lt;/li&gt;    &lt;li&gt;Deployment Across Public &amp;amp; Private&lt;/li&gt;    &lt;li&gt;Elastic Scale&lt;/li&gt; &lt;/ul&gt;  &lt;p&gt;And of course, many of these items contribute to make a much more cloud-ready platform. Cloud isn’t for everyone, but Microsoft are certainly making steps to make it a more feasible option.&lt;/p&gt;  &lt;p&gt;And we’re over – hitting publish now.&lt;/p&gt;  &lt;p&gt;&lt;a href="http://twitter.com/rob_farley" target="_blank"&gt;@rob_farley&lt;/a&gt;&lt;/p&gt;</description></item><item><title>SQL + Hadoop news</title><link>http://sqlblog.com/blogs/rob_farley/archive/2011/10/12/sql-hadoop-news.aspx</link><pubDate>Wed, 12 Oct 2011 16:07:38 GMT</pubDate><guid isPermaLink="false">21093a07-8b3d-42db-8cbf-3350fcbf5496:39010</guid><dc:creator>rob_farley</dc:creator><description>&lt;p&gt;I’m at the PASS Summit, and announcements are coming out nice and fast. One of the big ones that has just been made is that SQL Server will work much more closely with Apache Hadoop. Amazing stuff, that I think helps people realise that Microsoft is very much about providing platforms, and isn’t trying to stop you from using your other platforms either.&lt;/p&gt;  &lt;p&gt;So in the “coming soon”, there were: &lt;/p&gt;  &lt;ul&gt;   &lt;li&gt;Apache Hadoop-based distribution for Windows Server and Windows Azure&lt;/li&gt;    &lt;li&gt;ODBC Driver and Add-in for Excel, both for Apache Hive&lt;/li&gt;    &lt;li&gt;JavaScript Framework for Hadoop&lt;/li&gt; &lt;/ul&gt;  &lt;p&gt;I’m not doing anything with Hadoop myself, but I know plenty of people do, and this is really good news!&lt;/p&gt;</description></item><item><title>PASS Summit 2011 – Day 1 Keynote</title><link>http://sqlblog.com/blogs/rob_farley/archive/2011/10/12/pass-summit-2011-day-1-keynote.aspx</link><pubDate>Wed, 12 Oct 2011 15:54:27 GMT</pubDate><guid isPermaLink="false">21093a07-8b3d-42db-8cbf-3350fcbf5496:39009</guid><dc:creator>rob_farley</dc:creator><description>&lt;p&gt;I’m a guest blogger again!&lt;/p&gt;  &lt;p&gt;This trip is already several days old for me. I arrived in America on Friday, delivered two sessions at Portland SQL Saturday event, walked (on Sunday) the Portland Half Marathon as a sponsor of Leukemia and Lymphoma Society’s Team in Training program, delivered a full-day summit precon seminar on Monday, and was in PASS Board meetings yesterday. Finally we’ve reached Day 1, and I could use a weekend!&lt;/p&gt;  &lt;p&gt;But it’s now that things really kick off properly.&lt;/p&gt;  &lt;p&gt;As I write this, Rushabh Mehta is on stage, talking about some of the numbers that apply to this summit. There are over attendees at the Summit this year, demonstrating the amazing reach that the PASS Summit has. And they also just talked about my involvement as an advisor in reaching the rest of the world better too. Every year, the Summit gets bigger, and PASS runs more events in more places. It’s an exciting time to be part of this community.&lt;/p&gt;  &lt;p&gt;Microsoft’s Ted Kummert (Senior VP, Business Platform Division) is on stage now, and has announced that SQL Server Denali will officially be named SQL Server 2012.&lt;/p&gt;</description></item></channel></rss>