Search results matching tags 'PASS' and 'Review'

Rick Review: Day 3 Keynote PASS Summit 2011 - Big Data-What's the Big Deal?

RickHeiges — Fri, 10 Feb 2012 13:40:00 GMT

I recently did a Rick Review 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. I decided to also listen again to the Day 3 Keynote from the 2001 PASS Community Summit. While I listened intently to the keynote on Day 3 of this past summit, something seemed to be somewhat familiar. Had I heard some of these concepts before? The keynotes from the most recent PASS Summit may be found here. 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. Once again, Dr.DeWitt is entertaining as he simplifies a complex topic for the audience. Having access to this recording is great, but being there first hand was even better with a sense of respectful awe in the audience. It is no wonder that the Day 3 Keynote is a favorite of the PASS attendees. If you haven't had the chance yet, I invite you to view the recording and perhaps learn something new.

Rick Review: Day 3 Keynote of the 2008 PASS Community Summit

RickHeiges — Thu, 09 Feb 2012 19:04:00 GMT

Am I stuck in the past? Not really, but I like to blog about the recordings that I have recently watched. There are a lot of recordings out there on the PASS website and other places.

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. 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. The link to the WMV file is near the bottom of this page. As I watched the recording, I could recall the excitement of learning about this new technology. 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. I believe that once you watch this session, you'll want to watch the other keynotes by Dr. DeWitt as well.

Rick Review: PASS Summit 2011 - DBA-104-S

RickHeiges — Thu, 05 Jan 2012 18:34:00 GMT

I recently got my DVD set from the PASS 2011 Summit and started to look through all of the sessions that I missed. Wow! I can't wait to go through all of these! It will take me a while.

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. It is by Brent Ozar and titled "BLITZ! The SQL - More One Hour SQL Server Takeovers".

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. He went through the thought process of what to do first - what was important to know about this server. 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. In other words, he wants to do a Blitzkrieg on the server to take it over. 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. 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.

I watched this session on my fresh DVD set, but you can watch it here if you attended the summit:http://softconference.com/pass/sessionDetail.asp?SID=274893

For more information on the Blitz script and to see a training video, click here: http://www.brentozar.com/blitz/