Search results matching tags 'PASS' and 'TechEd'http://sqlblog.com/search/SearchResults.aspx?o=DateDescending&tag=PASS,TechEd&orTags=0Search results matching tags 'PASS' and 'TechEd'en-USCommunityServer 2.1 SP2 (Build: 61129.1)Upcoming conference speeches and workshops #ssas #tabular #dax #powerpivothttp://sqlblog.com/blogs/marco_russo/archive/2014/04/28/upcoming-conference-speeches-and-workshops-ssas-tabular-dax-powerpivot.aspxMon, 28 Apr 2014 09:39:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:53761sqlbi<p>Between May and July I and Alberto will be speaker at several conferences, and I think it could be useful to write a single blog post with a recap:</p><ul><li><a href="http://www.sqlpass.org/bac/2014/Home.aspx" mce_href="http://www.sqlpass.org/bac/2014/Home.aspx"><b>PASS Business Analytics Conference&nbsp;2014</b></a><b> - May 7-9, 2014 - San Jose, California</b></li><ul><li><a href="http://www.sqlpass.org/bac/2014/Sessions/Details.aspx?sid=5590" mce_href="http://www.sqlpass.org/bac/2014/Sessions/Details.aspx?sid=5590">Querying in DAX</a> (Marco Russo)</li><li><a href="http://www.sqlpass.org/bac/2014/Sessions/Details.aspx?sid=5902" mce_href="http://www.sqlpass.org/bac/2014/Sessions/Details.aspx?sid=5902">DAX from the Field: Real-World Case Studies</a> (Alberto Ferrari)</li></ul><li><a href="http://northamerica.msteched.com" mce_href="http://northamerica.msteched.com"><b>Microsoft TechEd North America 2014</b></a><b> - May 12-15, 2014&nbsp;- Houston, Texas</b></li><ul><li>DBI-B322 Improving Power Pivot Data Models for Microsoft Power BI (Marco Russo)</li><li>DBI-B323 Power Query in Modern Corporate BI&nbsp;(Marco Russo)</li><li>DBI-B325 Querying in DAX (Alberto Ferrari)</li></ul><li><a href="https://www.sqlbits.com/" mce_href="https://www.sqlbits.com/"><b>SQLBits XII</b></a><b> -&nbsp;&nbsp;July </b><b>17-19</b><b>, 2014 - Telford, United Kingdom</b></li><ul><li><a href="https://www.sqlbits.com/information/Event12/Creating_a_Power_BI_Solution_in_one_day/TrainingDetails.aspx" mce_href="https://www.sqlbits.com/information/Event12/Creating_a_Power_BI_Solution_in_one_day/TrainingDetails.aspx">Creating a Power BI Solution in one day </a>(Marco Russo - training day 17 Jul 2014)</li><li>Advanced Modeling with Analysis Services Tabular (Alberto Ferrari)</li><li>Optimizing &amp; Analyzing DAX Query Plans (Alberto Ferrari)</li><li>Power Query in Modern Corporate BI (Marco Russo)</li><li>DAX Patterns (Marco Russo)</li></ul></ul><p>We will also deliver&nbsp;several courses:</p><ul><li><b>SSAS Tabular Workshop</b> - 3 days including hands-on-lab</li><ul><li><a href="http://www.sqlbi.com/courses/ssas-tabular-workshop-zurich-may2014" mce_href="http://www.sqlbi.com/courses/ssas-tabular-workshop-zurich-may2014">Zurich, Switzerland - May 28-30, 2014</a></li><li><a href="http://www.sqlbi.com/courses/ssas-tabular-workshop-copenhagen-jun2014" mce_href="http://www.sqlbi.com/courses/ssas-tabular-workshop-copenhagen-jun2014">Copenhagen, Denmark - June 2-4, 2014</a></li><li><a href="http://www.sqlbi.com/courses/ssas-tabular-workshop-basel-jun2014" mce_href="http://www.sqlbi.com/courses/ssas-tabular-workshop-basel-jun2014">Basel, Switzerland - June 30 - July 2, 2014</a></li><li><a href="http://www.sqlbi.com/courses/ssas-tabular-workshop-online-jul2014" mce_href="http://www.sqlbi.com/courses/ssas-tabular-workshop-online-jul2014">Online - July 9-11, 2014</a> (optimized for USA and Canada time zones)</li></ul><li><b>Advanced DAX Workshop</b> - 3 days including hands-on-lab&nbsp;</li><ul><li><a href="http://www.sqlbi.com/courses/advanced-dax-workshop-milan-may2014" mce_href="http://www.sqlbi.com/courses/advanced-dax-workshop-milan-may2014">Milano, Italy - May 21-23, 2014</a>&nbsp;(only this is in Italian - Others are in English!)</li><li><a href="http://www.sqlbi.com/courses/advanced-dax-workshop-dublin-jun2014" mce_href="http://www.sqlbi.com/courses/advanced-dax-workshop-dublin-jun2014">Dublin, Ireland - June 4-6, 2014</a></li><li><a href="http://www.sqlbi.com/courses/advanced-dax-workshop-stockholm-jun2014" mce_href="http://www.sqlbi.com/courses/advanced-dax-workshop-stockholm-jun2014">Stockholm, Sweden - June 10-12, 2014</a></li><li><a href="http://www.sqlbi.com/courses/advanced-dax-workshop-london-jun2014" mce_href="http://www.sqlbi.com/courses/advanced-dax-workshop-london-jun2014">London, United Kingdom - June 11-13, 2014</a></li></ul><li><b>PowerPivot Workshop</b> - 2/3 days including exercises</li><ul><li><a href="http://www.sqlbi.com/courses/powerpivot-workshop-basic-online-jun2014" mce_href="http://www.sqlbi.com/courses/powerpivot-workshop-basic-online-jun2014">Basic Online&nbsp;- June 16-17, 2014</a> (optimized for USA and Canada time zones)</li><li><a href="http://www.sqlbi.com/courses/powerpivot-workshop-full-online-jun2014" mce_href="http://www.sqlbi.com/courses/powerpivot-workshop-full-online-jun2014">Full Online - June 16-18, 2014</a> (optimized for USA and Canada time zones)</li></ul></ul><p>See you around the world!&nbsp;</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>TechEd 2011 - Performance Tuning and Optimization in SQL Server 2008 R2 and SQL Server Code Named &quot;Denali&quot;http://sqlblog.com/blogs/adam_machanic/archive/2011/05/18/teched-2011-performance-tuning-and-optimization-in-sql-server-2008-r2-and-sql-server-code-named-denali.aspxWed, 18 May 2011 16:05:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:35708Adam Machanic<p>Thanks to everyone who took the time out of their conference experience to join Mike Wachal and me for yesterday's session on SQL Server performance tuning!</p><p>For those who weren't there, we focused in on troubleshooting techniques, highlighting some of the key DMVs and new Extended Events features that will help with proactive diagnosis of problems. <b>My section, in particular, was a bit of a taste of some of the sessions I've submitted for this fall's PASS summit</b>: I showed a brief demo of troubleshooting using my No More Guessing methodology, and applied it to the problem of workspace memory contention. The sessions for PASS cover these topics in detail, so if you find this area interesting <a href="http://www.sqlpass.org/summit/2011/Speakers/SessionPreferencing.aspx?spid=314">please vote here</a>.</p><p>The demo script I showed yesterday is attached, along with a copy of the latest versions of my <a href="http://sqlblog.com/blogs/adam_machanic/archive/tags/who+is+active/default.aspx">Who is Active</a> stored procedure and the <a href="http://www.datamanipulation.net/sqlquerystress/">SQLQueryStress</a> tool. Feel free to leave a comment below or drop me a line via e-mail if you have any questions.<br></p>2 cents: Thoughts on TechEd, PASS and the role of the DBAhttp://sqlblog.com/blogs/james_luetkehoelter/archive/2007/12/03/2-cents-thoughts-on-teched-pass-and-the-role-of-the-dba.aspxMon, 03 Dec 2007 18:14:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:3644James Luetkehoelter<P>I recently saw a post on one of the MCT forums asking which conference should be attended - TechEd IT Pro, TechEd Dev or PASS when it comes to SQL education. I posted a reply there favoring TechEd (either). I need to defend that a bit better.</P>
<P>One reply to that post pointed out that SQL Server is considered ITPro by MS when it come to certifications (MCITP: DBA, Developer, BI). A reply pointed out that even though that was the case, there is still a certification with "developer" in the name. As usual, it seems no one knows how to categorize the database. What a surprise.</P>
<P>The simplicity of the situation is that the database is the intersection point between development, IT management and the business. It isn't that a DBA or database professional or whatever you call the role is more important than anyone else - it's just that the DBA ends up with the unenviable job of having to work with just about every group.</P>
<P>There have been some that have argued that there shouldn't be a DBA, a distinct job from development or from normal server systems management. I don't agree with that - I think we need a job role that is an intersection point. Without it, chaos or apathy invariably ensue.</P>
<P>So in my answer on the post I gave the nod to TechEd, even though I'm a speaker at PASS (stupid James...). My reasoning is that a SQL Server professional needs to learn as much about other technologies out there as he does about SQL Server. That won't happen at PASS (which is an excellent source of SQL Server knowledge - but that's it). To be an effective SQL Server...person...one must almost be a sponge for information on intersecting technologies.</P>
<P>At least that's my 2 cents.</P>