Search results matching tag 'Community'http://sqlblog.com/search/SearchResults.aspx?o=DateDescending&tag=Community&orTags=0Search results matching tag 'Community'en-USCommunityServer 2.1 SP2 (Build: 61129.1)PASS Summit - Free Thursday NIghthttp://sqlblog.com/blogs/rick_heiges/archive/2016/09/26/pass-summit-free-thursday-night.aspxMon, 26 Sep 2016 21:06:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:61914RickHeiges<p>It was recently pointed out that there is no official event scheduled for Thursday night the week of the PASS Summit this year. I am fine with that. By the time Thursday rolls around, I might want to use that time to catch up on sleep. :-) </p><p>Seriously, the&nbsp;Thursday night party was fun, but it wasn't a necessary thing IMHO.&nbsp;By&nbsp;the time Thursday rolls around,&nbsp;each attendee should&nbsp;already have met enough people to figure out something to do.&nbsp; There are some great spots to eat near the WSCC and some&nbsp;sights to see that aren't too far away.&nbsp;&nbsp;in the early years of the PASS Summit when I first attended, we had a free night, or there was a low key event at the convention center just to have&nbsp;something to do.</p><p>I think this also presents a great opportunity for the&nbsp;exhibitors to perhaps have a private event to connect with those attendees to further discussions on products/services or to just get more familiar with each other.&nbsp; The week long schedule&nbsp;has always been jammed packed with little opportunity&nbsp;for these private events to flourish.&nbsp;My favorite night is Tuesday night at the welcome reception where you reconnect with old friends, meet new people, and feel the anticipation of a great week ahead.</p><p>Once again, I am looking&nbsp;forward to the Summit!&nbsp;</p>PASS Summit is back! Looks inside the 2016 edition #Summit16http://sqlblog.com/blogs/sergio_govoni/archive/2016/08/31/pass-summit-is-back-looks-inside-the-2016-edition-summit16.aspxWed, 31 Aug 2016 10:45:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:61701Sergio Govoni<p>The PASS Summit is back! This year, the most important event around the world for Microsoft Data Platform will be held again in Seattle (WA) from 25 to 28 October 2016 and it will be preceded from two pre-conference days from 24 to 25 October 2016.</p><p>I wrote "the most important event around the world"&nbsp;because numbers of PASS Summit 2015 are self explanatory! Last year 5,000 data-geeks have attended the PASS Summit which has become the landmark event for the entire Microsoft Data Platform. Take a look at numbers of the year 2015, that are shown in the following pictures, they are really impressive, aren't they?</p><p><a href="http://www.sqlpass.org/summit/2016" target="_blank" mce_href="http://www.sqlpass.org/summit/2016"><img width="478" height="424" style="width:478px;height:424px;" src="https://www.ugiss.org/wp-content/uploads/2016/08/PASS_Summit_2016_img1.png" border="0"></a></p><p>Every year more and more IT Professionals, Technicians, Analysts and Data Scientists consider this event as a unique opportunity to: <b>connect</b> to other people that have the same passion you have, <b>share</b> your experience and the problems you face for your job and <b>learn</b> more and more about the Microsoft Data Platform for choose the best technology to win the challenges of the market.</p><p>Don't forget that you also have the opportunity to meet and talk to people like <a href="https://www.linkedin.com/in/conorcunningham" target="_blank" mce_href="https://www.linkedin.com/in/conorcunningham">Conor Cunningham</a> (one of the principal architect of the relational Engine of SQL Server and SQL Azure),&nbsp;<a href="https://www.linkedin.com/in/david-dewitt-30189b50" target="_blank" mce_href="https://www.linkedin.com/in/david-dewitt-30189b50">David DeWitt</a>&nbsp;(one of the biggest expert of Parallel Databases), <a href="https://www.linkedin.com/in/bobwardms" target="_blank" mce_href="https://www.linkedin.com/in/bobwardms">Bob Ward</a> (Chief Technology Officer Microsoft CSS) and <a href="https://www.linkedin.com/in/marksouza" target="_blank" mce_href="https://www.linkedin.com/in/marksouza">Mark Souza</a>&nbsp;(General Manager in the Microsoft Data Platform Group). Are you thinking that people are too busy for a talk with you? Nobody of these big names walks away if you try to meet and talk them!</p><p>If you are undecided about the contents provided at the PASS Summit, you can watch the sessions of the previous year on PASS TV and&nbsp;you will&nbsp;touch with your hands the quality of the&nbsp;sessions provided at PASS Summit!</p><ul><li>PASS Summit 2015 – <a href="http://www.sqlpass.org/summit/2015/PASStv/Community.aspx#tabs-0" target="_blank" mce_href="http://www.sqlpass.org/summit/2015/PASStv/Community.aspx#tabs-0">Day 1</a></li><li>PASS Summit 2015 – <a href="http://www.sqlpass.org/summit/2015/PASStv/Community.aspx?watch=lvABzpTidv0" target="_blank" mce_href="http://www.sqlpass.org/summit/2015/PASStv/Community.aspx?watch=lvABzpTidv0">Keynote Day2</a> (David DeWitt and Rimma Nehme)</li><li>PASS Summit 2015 – <a href="http://www.sqlpass.org/summit/2015/PASStv/Community.aspx#tabs-1" target="_blank" mce_href="http://www.sqlpass.org/summit/2015/PASStv/Community.aspx#tabs-1">Day 2</a></li><li>PASS Summit 2015 – <a href="http://www.sqlpass.org/summit/2015/PASStv/Community.aspx#tabs-2" target="_blank" mce_href="http://www.sqlpass.org/summit/2015/PASStv/Community.aspx#tabs-2">Day 3</a>&nbsp;</li></ul><p>Are you a beginner or&nbsp;a "first timers" at PASS Summit? Don't worry there are lots of sessions of 100 and 200 levels and you can count on the "First Timers Guidebook" that it will arrive soon!</p><p>What kind of sessions can you expect to&nbsp;see at the PASS Summit 2016? Find it out from September 07 to 08, 2016 at the <a href="http://www.sqlpass.org/24hours/2016/summitpreview/Sessions.aspx" target="_blank" mce_href="http://www.sqlpass.org/24hours/2016/summitpreview/Sessions.aspx">24 Hours of PASS: Summit 2016 Preview Edition</a>, register now at this <a href="https://www.sqlpass.org/24hours/2016/summitpreview/Registration.aspx" target="_blank" mce_href="https://www.sqlpass.org/24hours/2016/summitpreview/Registration.aspx">link</a>, thanks to the <a href="http://www.sqlpass.org/24hours/2016/summitpreview/Sponsors.aspx" target="_blank" mce_href="http://www.sqlpass.org/24hours/2016/summitpreview/Sponsors.aspx">sponsors</a>, the 24 Hours of PASS is presented at <b>no cost</b>! This edition of 24 Hours of PASS wants to be a sneak taste of what you can expect from&nbsp;PASS Summit 2016.</p><p>You can find all information you need on <a href="http://www.sqlpass.org/summit/2016/Home.aspx" target="_blank" mce_href="http://www.sqlpass.org/summit/2016/Home.aspx">PASS Summit 2016 website</a> and for your convenience, here some useful links:</p><ul><li><a href="http://www.sqlpass.org/summit/2016/Sessions/GeneralSessions.aspx" target="_blank" mce_href="http://www.sqlpass.org/summit/2016/Sessions/GeneralSessions.aspx">Conference Sessions</a></li><li><a href="http://www.sqlpass.org/summit/2016/RegisterNow.aspx" target="_blank" mce_href="http://www.sqlpass.org/summit/2016/RegisterNow.aspx">Registration</a></li><li><a href="http://www.sqlpass.org/summit/2016/About/Travel.aspx" target="_blank" mce_href="http://www.sqlpass.org/summit/2016/About/Travel.aspx">Travel and Accommodation</a></li></ul><p><br></p><p><a href="http://www.sqlpass.org/summit/2016" target="_blank" mce_href="http://www.sqlpass.org/summit/2016"><img width="940" height="94" style="width:940px;height:94px;" src="https://www.ugiss.org/wp-content/uploads/2016/08/PASS_Summit_2016_banner_940x94.jpg" border="0"></a></p><p>See you there!</p>24 Hours of PASS (September 2016): #SQLSummit Preview Editionhttp://sqlblog.com/blogs/sergio_govoni/archive/2016/08/21/24-hours-of-pass-september-2016-sqlsummit-preview-edition.aspxSun, 21 Aug 2016 20:52:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:61769Sergio Govoni<p>Which sessions can you expect to see at the <a href="http://www.sqlpass.org/summit/2016/Home.aspx" target="_blank" mce_href="http://www.sqlpass.org/summit/2016/Home.aspx">PASS Summit 2016</a>? Find it out from September 07 to 08, 2016 at the <a href="http://www.sqlpass.org/24hours/2016/summitpreview/About.aspx" target="_blank" mce_href="http://www.sqlpass.org/24hours/2016/summitpreview/About.aspx">24 Hours of PASS: Summit 2016 Preview Edition</a>.</p><p><a href="http://www.sqlpass.org/24hours/2016/summitpreview/Sessions.aspx" target="_blank" mce_href="http://www.sqlpass.org/24hours/2016/summitpreview/Sessions.aspx"><img width="689" height="123" style="width:689px;height:123px;" src="https://www.ugiss.org/wp-content/uploads/2016/08/24-Hours-of-PASS-Settembre-2016-Summit-Preview-689x123.png" border="0"></a></p><p>Register now at this <a href="https://www.sqlpass.org/24hours/2016/summitpreview/Registration.aspx" target="_blank" mce_href="https://www.sqlpass.org/24hours/2016/summitpreview/Registration.aspx">link</a>, thanks to the <a href="http://www.sqlpass.org/24hours/2016/summitpreview/Sponsors.aspx" target="_blank" mce_href="http://www.sqlpass.org/24hours/2016/summitpreview/Sponsors.aspx">sponsors</a>, the 24 Hours of PASS is presented at <b>no cost</b>!</p><p>This edition of 24 Hours of PASS wants to be a sneak taste of what you can expect from the <a href="http://www.sqlpass.org/summit/2016/About/WhyAttend.aspx" target="_blank" mce_href="http://www.sqlpass.org/summit/2016/About/WhyAttend.aspx">next PASS Summit</a> that will be in Seattle (WA) from October 25 to 28, 2016.</p><p>No matter from what part of the world you will follow the event, the important thing is to know that they will be 24 hours of continuous training on Microsoft Data Platform... direct on your computer!</p>800http://sqlblog.com/blogs/andy_leonard/archive/2016/08/05/61713.aspxFri, 05 Aug 2016 17:19:10 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:61713andyleonard<p>In May 2015 I wrote <a href="http://sqlblog.com/blogs/andy_leonard/archive/2015/05/22/58707.aspx" target="_blank">700</a> – a post marking my 700th blog post here at <a href="http://SqlBlog.com" target="_blank">SqlBlog.com</a>. Last month I wrote <a href="http://sqlblog.com/blogs/andy_leonard/archive/2016/07/09/nine-years.aspx" target="_blank">Nine Years</a> about another milestone here. Well, here we are in August 2016 and I’ve reached 800 posts! </p> <p>It’s an honor and privilege to write here. Here’s to the next 100 posts!</p> <p>:{&gt;</p>RVA (Richmond) Code Camp is Back!http://sqlblog.com/blogs/andy_leonard/archive/2016/07/25/rva-richmond-code-camp-is-back.aspxMon, 25 Jul 2016 16:17:56 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:61648andyleonard<p>I’m excited to announce Richmond Code Camp is back! We’ve rebranded to <a href="http://rvacodecamp.org/" target="_blank">RVA Code Camp</a> and our next event is scheduled for 22 Oct 2016 at <a href="https://www.ecpi.edu/locations/richmond-va-innsbrook" target="_blank">ECPI in Glen Allen, VA</a>. </p> <p>At the time of this writing: <br /><a href="https://www.eventbrite.com/e/richmond-code-camp-2016-tickets-26708832838" target="_blank">Registration</a> and the <a href="http://rvacodecamp.org/call-for-presentations/" target="_blank">Call for Presentations</a> are both open.</p> <p>We hope to see you there!</p> <p>:{&gt;</p> <p>PS – Are you interested in sponsoring the event? <a href="http://rvacodecamp.org/contact-us/" target="_blank">Contact us</a>!</p>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>Anti-Harassment Policies and Codes of Conducthttp://sqlblog.com/blogs/rob_farley/archive/2015/11/26/anti-harassment-policies-and-codes-of-conduct.aspxThu, 26 Nov 2015 21:56:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:60082rob_farley<p>I was a director on the PASS board back in 2012 when our having a Code of Conduct was first raised. A number of conferences had experienced bad situations, particularly around sexist behaviour, and it was very appropriate for PASS to take a stand and say “We don’t want this kind of thing to happen to PASS members.”</p> <p>We ALL wanted to make sure that the PASS community was a safe community – one which people could be part of without having to worry about whether there would be an “incident”. No one wanted the PASS Summit, or a SQL Saturday, or any PASS-related event, to incur an “incident”. We considered that the only acceptable number of incidents was zero.</p> <p>That said, there was a certain amount of awkwardness – particularly in the days leading up to the official discussion about the proposed Code of Conduct. There was a genuine fear about how a Code of Conduct would affect the tone of PASS events. Nobody wanted to be removed from an event because of a seemingly innocuous comment, but even more, no one wanted there to be an incident of harassment. And this fear expressed itself in awkwardness, bordering on flippancy.</p> <p>As the globalisation committee (a subsection of the board including some advisors – all of whom knew about the proposed Code) sat around to discuss globalisation, the first time there was a double-entendre, instead of raising an eyebrow or saying “Oh really?” or something else, the expression of the day was “There’s a Code of Conduct violation right there...”. It was a reflection of the nervousness that people felt around what the impact would be. People wanted to maintain the informal atmosphere of the meeting, but didn’t know how to react to a double-entendre in light of the future Code of Conduct – remembering that we ALL wanted PASS to become a safer community for our members.</p> <p>We don’t tolerate harassment at all. But at what point do things become harassment? At first it felt like we were trying to define it.</p> <p>As an Australian, I see a certain amount of banter about New Zealanders. It goes both ways, and the jokes are apparently very similar. They joke that we treat our sheep in particular ways, and we say the same about them. In the 1980s, the Kiwi Prime Minister Robert Muldoon said that New Zealanders moving to Australia raised the average IQ of both countries, which I think is a fantastic sledge! To suggest that people leaving New Zealand must be less smart than the average Kiwi, but still smarter than the average Australian, is a beautifully crafted rib. Is it racist? By definition, perhaps – but I doubt anyone felt vilified by it.</p> <p>“By definition, perhaps” was the phrase that worried me.</p> <p>I knew that if we defined the Code of Conduct wrongly, then I, and many others, could easily be in breach of it. I knew that if I reacted to a double-entendre with a raised eyebrow, that could be seen as sexualising a situation. I knew that if I joked that a Tottenham fan in the room was of lower intelligence than an Arsenal fan, then that could be seen as harassment. Maybe not by the Spurs fan, but by someone else watching, who might think that I genuinely insulted them. Even to suggest that a developer has no respect of data (as many PASS presenters might suggest in a session) could be seen as unfairly assigning undesirable attributes to people. It was a concern.</p> <p>So instead of raising an eyebrow, instead of reacting to any situation in my usual way, I reacted with “There’s a Code of Conduct violation right there...”. It still achieved the joke, but in a way that acknowledged my fears of what the Code might imply. It wasn’t appropriate, and I’m sorry. The correct thing to do would have been to have just bitten my tongue and ignore it. I also wasn’t the only one in that situation – I think just about everyone in the room did the same.</p> <p>We all wanted a policy, but we didn’t know how it was going to affect us.</p> <p>As we discussed it, we were able to work out that really what we wanted was not a Code of Conduct that defined what we allowed and what we didn’t allow, because we would never have been able to get that right. What we wanted was to adopt a stance that said “We do not tolerate harassment”, and to have a procedure for what happens if someone feels harassed. What we wanted was an Anti-Harassment Policy.</p> <p>Let me express that again:</p> <p><b>We do not tolerate harassment.</b></p> <p>And I don’t want to define what harassment means for an individual. I don’t want to define that certain types of touching are okay and others are not. I don’t want to define that particularly types of eye-contact count as harassment. I don’t want to define the words that can be used to describe body parts (like if someone falls and says they’ve hurt their backside – do they need to be careful about the word they use?), or what counts as “acceptable swearing” at a party. If we define this, then we run the risk that someone might go right up to the defined line in harassing someone, but we haven’t provided a course of action for the victim because the harasser hasn’t broken the “Code of Conduct”.</p> <p>I do want to have well-documented processes for how to react if someone feels harassed, because I want the person who feels harassed to know they have a course of action open to them.</p> <p>I think a Code of Conduct should be around expected behaviour in particular situations. A Code of Conduct says that a session presenter should wear a collared shirt not a T-shirt. A Code of Conduct says that a sponsor should respect the geographic boundaries of other vendors’ booths. A Code of Conduct shouldn’t say “You must not use someone’s nationality as the subject of a joke” – because when Australia was beaten in the final of the Rugby World Cup, that’s an opportunity to rib them about it, but the principle of standing against racism is incredibly valid. If I suggest that Americans are stupid for considering that “could care less” means the same as “could not care less” – am I crossing the line? It probably depends on a lot of other factors.</p> <p>Let me say it again:</p> <p><b>I do not tolerate harassment.</b></p> <p>I simply recognise that what some people see as harassment, others see as friendly banter. Should Bradley Ball, Joe Sack, and Buck Woody be offended about jokes regarding their names? I don’t know. That’s entirely up to them in the situation, and the context of what’s said. Sometimes they might be fine with it, other times they might not. That’s their right. No one else gets to dictate their reaction. Should Kevin Kline have been upset that I sang Happy Birthday to him loudly, in public situations, repeatedly, for a whole day? I try to monitor those situations, and back off if they seem to be getting upset. Is my detector of people’s personal lines sometimes faulty? Sadly, yes.</p> <p><b>I do not tolerate my own harassment of others.</b></p> <p>If you have ever felt harassed by me, I’m personally sorry and honestly regret it. I know I joke. I know I often joke at other people’s expense. But I never mean to harass. </p> <p>My personal Code of Conduct varies according to the company that I’m keeping – there are times that it’s okay to point out a double-entendre, but a job interview is probably not that time. My personal Anti-Harassment Policy is not variable. I don’t tolerate harassment, and if you ever feel harassed by me, tell me. If I don’t stop (though I hopefully always do stop), then tell me again, or tell a friend of mine and get them to help me stop (because I have probably misinterpreted you – if I say ‘Oi’ to someone who calls me fat, that doesn’t necessarily mean I’m feeling harassed, even though my extra kilos bothers me and I really don’t like it being pointed out).</p> <p>PASS has an Anti-Harassment Policy. As the SQL community, we don’t tolerate it, and we know what to do if someone feels harassed.</p> <p>Defining harassment is tough – it’s subjective, and individual. Making a stance to say “we don’t tolerate it” and “if you harass someone, here’s how we will respond” is a good thing.</p> <p>Let me say that again:</p> <p><b>The PASS community doesn’t tolerate harassment.</b></p> <p><a mce_href="http://twitter.com/rob_farley" target="_blank" href="http://twitter.com/rob_farley">@rob_farley</a></p>Precon - SSIS Design Patterns and BIML: A Day of Intelligent Data Integration–8 Jan 2016, Alpharetta Georgiahttp://sqlblog.com/blogs/andy_leonard/archive/2015/11/12/precon-ssis-design-patterns-and-biml-a-day-of-intelligent-data-integration.aspxThu, 12 Nov 2015 18:29:57 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:60004andyleonard<p align="left"><a href="http://sqlblog.com/blogs/andy_leonard/PackageSVG_3B8DB7AB.jpg"><img title="PackageSVG" 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="PackageSVG" src="http://sqlblog.com/blogs/andy_leonard/PackageSVG_thumb_0F70BABA.jpg" width="150" height="158" /></a>&#160;&#160;&#160;&#160;&#160;&#160;&#160; <a href="http://sqlblog.com/blogs/andy_leonard/BimlWheel_6ADF2D35.jpg"><img title="BimlWheel" 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="BimlWheel" src="http://sqlblog.com/blogs/andy_leonard/BimlWheel_thumb_11411081.jpg" width="190" height="156" /></a></p> <p align="left">I’m excited to announce I will be delivering a precon 8 Jan 2016 in Alpharetta Georgia for <a href="http://www.sqlsaturday.com/477/eventhome.aspx" target="_blank">SQL Saturday 477 – Atlanta BI Edition</a> titled <a href="http://www.eventbrite.com/e/ssis-design-patterns-and-biml-a-day-of-intelligent-data-integration-tickets-19517833365" target="_blank">SSIS Design Patterns and BIML: A Day of Intelligent Data Integration</a>! This precon is all about DILM (Data integration Lifecycle Management). </p> <p align="left"><strong>Abstract:</strong></p> <p align="left"><a href="http://www.eventbrite.com/e/ssis-design-patterns-and-biml-a-day-of-intelligent-data-integration-tickets-19517833365" target="_blank">SSIS Design Patterns and Biml: A Day of Intelligent Data Integration</a></p> <p align="left">Join <a href="http://andyleonardconsulting.com" target="_blank">Andy Leonard</a>, SSIS trainer, <a href="https://varigence.com/Blog/Post/65" target="_blank">BimlHero</a>, co-author of <a href="http://smile.amazon.com/Server-Integration-Services-Design-Patterns/dp/1484200837" target="_blank">SSIS Design Patterns</a>, the <a href="http://www.sqlservercentral.com/stairway/72494/" target="_blank">Stairway to Integration Services</a> and <a href="http://www.sqlservercentral.com/stairway/100550/" target="_blank">Stairway to Biml</a> series at <a href="http://www.sqlservercentral.com" target="_blank">SQL Server Central</a>, and <a href="http://smile.amazon.com/gp/product/1502947609" target="_blank">Managing Geeks</a>, for a day of training focused on intelligent data integration. Andy is an experienced SSIS consultant, but he also led an enterprise team of 40 ETL developers on projects that spanned 2.5 years. And delivered.</p> <p align="left">The target audience for this course is data integration developers and architects who want to learn more about SSIS performance, DevOps, execution, best practices, code reuse, and automation.</p> <p align="left">Attendees will learn: <br />&#160;&#160; - a holistic approach to data integration design. <br />&#160;&#160; - a methodology for enterprise data integration that spans development through operational support. <br />&#160;&#160; - how automation changes everything. Including data integration with SSIS.</p> <p align="left">Topics include:</p> <p align="left">1. SSIS Design Patterns <br />&#160;&#160; Data Flow Performance <br />&#160;&#160; ETL Instrumentation</p> <p align="left">2. Executing SSIS in the Enterprise <br />&#160;&#160; The SSIS Catalog - the good, the bad, and the ugly.</p> <p align="left">3. Custom SSIS Execution Frameworks</p> <p align="left">4. DevOps and SSIS <br />&#160;&#160; A (Condensed) Sprint in the Life of a Data Integration Solution <br />&#160;&#160; Version Control and SSIS</p> <p align="left">5. Business Intelligence Markup Language <br />&#160;&#160; A Brief Introduction to Biml in BimlStudio</p> <p align="left">6. SSIS Design Patterns + Biml <br />&#160;&#160; Putting the pieces together.</p> <p align="left">7. SSIS Design Patterns + Biml + Custom SSIS Execution Frameworks <br />&#160;&#160; Executing the new combinations.</p> <p align="left">8. SSIS Design Patterns + Biml + Custom SSIS Execution Frameworks + DevOps <br />&#160;&#160; Enterprise-class data integration with SSIS. </p> <p align="left">Early-bird pricing is in effect until 30 Nov 2015.</p> <p align="left"><a href="http://www.eventbrite.com/e/ssis-design-patterns-and-biml-a-day-of-intelligent-data-integration-tickets-19517833365" target="_blank">Register here today</a>!</p> <p align="left">I hope to see you there.</p> <p>:{&gt;</p>PASS Summit 2015 presentations I’m givinghttp://sqlblog.com/blogs/rob_farley/archive/2015/10/22/pass-summit-2015-presentations-i-m-giving.aspxThu, 22 Oct 2015 22:57:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:59861rob_farley<p>With only a few days to go until people arrive in Seattle, I should probably explain what my sessions are going to be on. You know, in case you hadn’t thought to go to <a href="http://www.sqlpass.org/summit/2015/Speakers/Details.aspx?spid=302" target="_blank" mce_href="http://www.sqlpass.org/summit/2015/Speakers/Details.aspx?spid=302">the PASS site</a> and read for yourself (and for those who want to hear something that’s a little less ‘abstract’y). A few people told me last year they were disappointed I wasn’t presenting, so if you’re in that situation, maybe this post is of interest.</p> <p>This year, I’m giving three different presentations – two regular Summit sessions that are on the schedule, and a 20-spot that I’m doing (twice!) at the Microsoft booth (Wednesday at 1:45pm and Thursday at 1:15pm).</p> <p>The 20-minute spot is about techniques you can use to avoid data movement in MPP systems such as PDW or SQL DW. It focuses on Query Optimizer things that I do in regular SQL environments, leveraging things like join redundancy, contradiction optimisations, and tuning aggregations. It’s going to be quite fast-paced, as we have three significant things to explore, with heavy use of SQL query plans and showing how those techniques apply to MPP distributed plans. I’ve used these methods to make queries run WAY faster in both MPP and non-MPP environments, and people have said things like “I wish I’d known that before my last client” (someone at Microsoft), and “Oh, that’s cool – I’m so going to use that” (someone at a major US-based PDW partner). So yeah – come along. Both times!</p> <p>The first main session I’m giving is one of my favourite sessions, and is called “<a href="http://www.sqlpass.org/summit/2015/Sessions/Details.aspx?sid=7784" target="_blank" mce_href="http://www.sqlpass.org/summit/2015/Sessions/Details.aspx?sid=7784">A few of my favourite query plan operators</a>”. This talk is going to focus on four Query Plan operators, but also discuss what’s going on in about six others. Or maybe seven – it depends how you count them, and how puzzled the looks on people’s faces go. We’ll explore what’s happening as your query runs, and why sometimes the counter-intuitive option could work out better. Lots of demos, as you’d expect from one of my presentations. Some live typing, and plenty of hand-waving as I describe why a particular plan shape is really what you’re after – even if the estimated cost might suggest otherwise.</p> <p>The new session is one that I wasn’t expecting to give, so that’ll be fun. It’s on “<a href="http://www.sqlpass.org/summit/2015/Sessions/Details.aspx?sid=7936" target="_blank" mce_href="http://www.sqlpass.org/summit/2015/Sessions/Details.aspx?sid=7936">The Power of Composite Indexes</a>”, and already I’m kinda regretting it (no, not really) because Americans say that word differently to how I say it (for me the longest syllable is the “com”, while for Americans it’s the “pos”). But however you say it, the idea is to look at indexes with multiple keys, and look at how powerful that can be. And how you can kill the performance as well. We’ll be looking at issues like sargability v residuality, blocking plan operators (especially for people that came to my first session), partitions, and even helping you use T-SQL to fix one the most frustrating features about the way that queries run.</p> <p>So anyway – those are the sessions that I’m giving at the PASS Summit this year. Hopefully somewhere in all that content there’s something you haven’t heard before.</p> <p><a href="http://twitter.com/rob_farley" target="_blank" mce_href="http://twitter.com/rob_farley">@rob_farley</a></p>Speaking at SQL Sat 452 in Charlotte on Oct 17!http://sqlblog.com/blogs/rick_heiges/archive/2015/10/12/speaking-at-sql-sat-452-in-charlotte-on-oct-17.aspxMon, 12 Oct 2015 19:21:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:59751RickHeiges<div class="BlogPostContent" style="text-align:justify;text-transform:none;text-indent:0px;letter-spacing:normal;margin-left:1px;word-spacing:0px;white-space:normal;widows:1;font-size-adjust:none;font-stretch:normal;-webkit-text-stroke-width:0px;"><p>I am pleased to announce that I will be speaking at SQL Saturday 452 in Charlotte on Oct 17!&nbsp; Last year, this event had a great turnout.&nbsp; Be a part of it this year!&nbsp;Register Now!</p><p> <a href="http://www.sqlsaturday.com/452/eventhome.aspx">http://www.sqlsaturday.com/452/eventhome.aspx</a>&nbsp;</p><p>My topic is "First Look at SQL Server 2016".&nbsp; Microsoft has been busy working on the next version of SQL Server - SQL Server 2016.&nbsp; We will go over some of the new features at a high level and dig deeper on Row Level Security and StretchDB.&nbsp; Row Level Security allows you to add another layer of security to your environment.&nbsp; StretchDB will allow you to transparently place part or all of a table into a SQL Azure DB freeing up your valuable SAN space for data that is COLD.I also plan on being available throughout the day to answer questions on SQL Server 2016 to the best of my ability.</p><p>This should be a great event!&nbsp; Help make great by being part of it!&nbsp; See you there!</p></div><div class="BlogPostFooter" style="margin:10px 0px 10px 1px;text-align:left;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;widows:1;font-size-adjust:none;font-stretch:normal;-webkit-text-stroke-width:0px;">Published Monday, October 05, 2015 4:01 PM by<span class="Apple-converted-space">&nbsp;</span><a id="ctl00___ctl00___ctl00_ctl00_bcr_ctl00___Entry___AuthorLink" href="http://sqlblog.com/user/Profile.aspx?UserID=2106">RickHeiges</a></div>