Search results matching tags 'Conferences' and 'Review'http://sqlblog.com/search/SearchResults.aspx?o=DateDescending&tag=Conferences,Review&orTags=0Search results matching tags 'Conferences' and 'Review'en-USCommunityServer 2.1 SP2 (Build: 61129.1)Rick Review: SQLTeach - SQL345 - 10-Mar-2010 - Kimberly Tripphttp://sqlblog.com/blogs/rick_heiges/archive/2012/02/15/rick-review-sqlteach-sql345-10-mar-2010-kimberly-tripp.aspxWed, 15 Feb 2012 05:17:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:41752RickHeiges<p>SQLTeach (Part of the DevTeach Conferences in Canada) has enjoyed success for many years.&nbsp; I enjoyed the opportunity to speak at&nbsp;and attend SQLTeach at various times over the years.&nbsp; Since SQLTeach is part of DevTeach, the "feel" of the event is very different from PASS or SQLRally or even a SQL Saturday where SQL is the primary focus.&nbsp; It does however afford an opportunity for me to understand the challenges of those who need to work with SQL either in a direct or indirect manner.&nbsp;&nbsp;SQLTeach / DevTeach&nbsp;records&nbsp;sessions and post them on the web for anyone to consume (login required, but&nbsp;a login may be created for FREE).&nbsp; Here is where I found this video: <a href="http://www.devteach.com/DevTeachVideo.aspx?NoVideo=45">http://www.devteach.com/DevTeachVideo.aspx?NoVideo=45</a></p><p>The session that I selected to review is by one of my favorite speakers, Kimberly Tripp.&nbsp; In this session, Kimberly once again simplifies&nbsp;a concept that is often treated as black magic.&nbsp; The session is entitled "Optimizing Procedural Code".&nbsp;&nbsp;This demo-heavy session covers many different options that are available to impact optimization.&nbsp; Do you know&nbsp;the various options&nbsp;to force out a cached plan?&nbsp;Is recompiling bad? What else can I control to help optimization?</p><p>Check this session out and consider attending the next SQLTeach/DevTeach (especially if you are already in Canada).&nbsp; </p><p>Enjoy!</p>Rick Review: Day 3 Keynote PASS Summit 2011 - Big Data-What's the Big Deal?http://sqlblog.com/blogs/rick_heiges/archive/2012/02/10/rick-review-day-3-keynote-pass-summit-2011-big-data-what-s-the-big-deal.aspxFri, 10 Feb 2012 13:40:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:41681RickHeiges<p>I recently did a <a title="2008 Day 3 Keynote" href="http://sqlblog.com/blogs/rick_heiges/archive/2012/02/09/rick-review-day-3-keynote-of-the-2008-pass-community-summit.aspx" target="_blank">Rick Review</a> of the Day 3 Keynote from the 2008 PASS Community Summit that featured Dr. DeWitt speaking on new technology that ended up in the Parallel Data Warehouse (PDW) edition of SQL Server 2008 R2.&nbsp; I decided to also listen again to the Day 3 Keynote from the 2001 PASS Community Summit.&nbsp; While I listened intently to the keynote on Day 3 of this past summit, something seemed to be somewhat familiar.&nbsp; Had I heard some of these concepts before?&nbsp; The keynotes from the most recent PASS Summit may be found <a title="Day 3 Keynote - PASS 2011" href="http://www.sqlpass.org/summit/2011/Live/LiveStreaming/LiveStreamingFriday.aspx" target="_blank">here</a>.&nbsp; The theme of PDW and Map/Reduce seem to be similar (at least at a high level) where data is split up into smaller chunks and selected sets of data are then combined to answer the query.&nbsp; Once again, Dr.DeWitt is entertaining as he simplifies a complex topic for the audience.&nbsp; Having access to this recording is great, but being there first hand was even better with a sense of respectful awe in the audience.&nbsp;It is no wonder that the Day 3 Keynote is a favorite of the PASS attendees.&nbsp; If you haven't had the chance yet, I invite you to view the recording and perhaps learn something new.</p>Rick Review: Day 3 Keynote of the 2008 PASS Community Summithttp://sqlblog.com/blogs/rick_heiges/archive/2012/02/09/rick-review-day-3-keynote-of-the-2008-pass-community-summit.aspxThu, 09 Feb 2012 19:04:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:41664RickHeiges<p>Am I stuck in the past?&nbsp; Not really, but I like to blog about the recordings that I have recently watched.&nbsp; There are a lot of recordings out there on the PASS website and other places.&nbsp;</p><p>Recently I have had the good fortune of exploring some of the neat technology behind the Parallel Data Warehouse (PDW) in SQL Server 2008 R2.&nbsp; In order to get myself grounded in some of the basics around what PDW was all about, I decided to review the Dr. DeWitt keynote (Day 3) from the 2008 PASS Community Summit.&nbsp; The link to the WMV file is near the bottom of this <a title="2008 Recordings" href="http://www.sqlpass.org/LearningCenter/SessionRecordings/PASSSummit2008SessionRecordings.aspx" target="_blank">page</a>.&nbsp; As I watched the recording, I could recall the excitement of learning about this new technology.&nbsp; Whether you were fortunate enough to see this live or not, this recording demonstrates how a very smart person can explain such a new technology in a simple manner.&nbsp; I believe that once you watch this session, you'll want to watch the other keynotes by Dr. DeWitt as well.</p>Rick Review: SQLBits7: Consolidating Data Collection with SQLDIAG and SQLNexushttp://sqlblog.com/blogs/rick_heiges/archive/2012/01/05/rick-review-sqlbits7-consolidating-data-collection-with-sqldiag-and-sqlnexus.aspxFri, 06 Jan 2012 02:54:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:40851RickHeiges<P>I ran across this recording about 3 months ago.&nbsp; It is a recording that is open to everyone.&nbsp; It was recorded at SQLBits 7 with Christian Bolton as the speaker for&nbsp;a session entitled: "Consolidating data collection with SQLDIAG and analysing it all with SQLNexus".&nbsp; I found it very informative and hope that you will too.</P>
<P>SQLBits is a UK based conference that occurs twice a year and I can't wait to attend one personally from the stories that I have heard.&nbsp; They record the sessions and make each one available for FREE access - AMAZING!&nbsp; You can find this session at the following URL: <A href="http://sqlbits.com/Sessions/Event7/Consolidating_data_collection_with_SQLDIAG_and_analysing_it_all_with_SQLNexus">http://sqlbits.com/Sessions/Event7/Consolidating_data_collection_with_SQLDIAG_and_analysing_it_all_with_SQLNexus</A>.&nbsp; The imbedded video has both a video of the speaker speaking to the audience as well as a full screen capture of the presentation to make the replay even more vivid.</P>
<P>Christian walks through the basics of using SQLDIAG for Data Collection initially.&nbsp; He then turns his attention to SQLNEXUS as a tool to analyze the data collected in SQLDIAG.&nbsp; He goes through how to configure SQLDIAG to collect the necessary data (perfmon and SQLTrace data) with the SQLDIAG process in order to discover the items needed for further analysis.&nbsp; If you need to perform a relatively quick analysis of&nbsp;a server, check this video out to discover your "pain points" for a particualr server.</P>
<P>After viewing this webcast, I am positive that you will find that using SQLDIAG along with SQLNEXUS will make your job easier.</P>
<P>&nbsp;</P>Rick Review: PASS Summit 2011 - DBA-104-Shttp://sqlblog.com/blogs/rick_heiges/archive/2012/01/05/rick-review-pass-summit-2011-dba-104-s.aspxThu, 05 Jan 2012 18:34:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:40834RickHeiges<P>I recently got my DVD set from the PASS 2011 Summit and started to look through all of the sessions that I missed.&nbsp; Wow!&nbsp; I can't wait to go through all of these!&nbsp; It will take me a while.</P>
<P>Since this is a new year and many people are often greeted with new challenges (like a new server to manage), I decided that this session would be a good one to review.&nbsp; It is by Brent Ozar and titled "BLITZ! The SQL - More One Hour SQL Server Takeovers".</P>
<P>Essentially, Brent shares with the audience his experience of being handed a SQL Server that someone else managed and being told that it is now his to manage.&nbsp; He went through the thought process of what to do first - what was important to know about this server.&nbsp; In short, he developed scripts that reveal information about the server such as when it was last backed up, had a consistency check, which sp_config settings had been changed from default, etc.&nbsp; In other words, he wants to do a Blitzkrieg on the server to take it over.&nbsp; He encourages the audience to go through the script and learn what is really happening and to not just run it blindly as this script is continually evolving.&nbsp; In fact, he has come up with a way to get the latest script "automatically" from the cloud when you want to run the script.</P>
<P>I watched this session on my fresh DVD set, but you can watch it here if you attended the summit:<A href="http://softconference.com/pass/sessionDetail.asp?SID=274893">http://softconference.com/pass/sessionDetail.asp?SID=274893</A></P>
<P>For more information on the Blitz script and to see a training video, click here: <A href="http://www.brentozar.com/blitz/">http://www.brentozar.com/blitz/</A></P>
<P>&nbsp;</P>
<P>&nbsp;</P>