24小时过得飞快!

好吧，上周我尽我所能参加了“24小时的PASS”虚拟会议。整个星期，我都是上午9点半到下午5点半教虚拟课堂，我确实需要睡眠，但我成功地赶上了10节课，这让我非常自豪。会议非常棒。这个想法是为了刺激我们对11月在西雅图举行的PASS峰会的兴趣。它确实做到了。我认为这是一次非常成功的公关活动，有其自身的好处。我参加了格林尼治时间00:00，由Paul Nielsen和Louis Davidson主持的“数据库设计的10大想法”的第一个会议。这很有趣。“娱乐”并不是我在自己的虚拟课程评价中看到的第一个词。我在做笔记，相信我。 First of all, Paul and Louis took on the co-host challenge very well. Both were connecting from different locations. (I don't remember where they were and it really doesn't matter does it?) They traded off effortlessly and with good humor when the video was on the wrong person so they created a very relaxed friendly atmosphere. I must admit, I was surprised by the value of the video which I rate as a luxury, based on the bandwidth it usually costs, but it did add to the friendliness of the session. Here were these guys taking time out of their evening to chat to us about SQL Server for free. And the slides were awesome! They must have scoured the internet for amusing photographs that enhanced their 10 Big Ideas. For instance, "Denormalization is for wimps!" backed up by a comic strip with a DBA getting sand kicked in his face. Very funny. The audio and video quality was very good and the guys were saying that Office Live Meeting was switching the video based on who was talking. Hard to believe but they made the result very amusing. Another session I really enjoyed was at 11am GMT "Reporting Services Inside Out the Things You Should Know" with Simon Sabin. Simon made his demos very entertaining. That word again. (Note to self: must do better). He is a real wizard with Report Builder and showed his expertise by making everything look very easy. Each of the sessions I attended had that element of watching a real expert in action. I took note of his preference of the latest version of Report Builder over Report Designer. Very interesting. At 8pm GMT I made sure I attended "What's Simple about Simple Recovery Model" with Kalen Delaney. She always reveals undocumented features of SQL Server which are incredibly useful. This time it was DBCC LOGINFO. Kalen explained how to use this utility to find out what really is going on when your database is in SIMPLE Recovery Model. This was a great pre-cursor to her pre-Conference session in Seattle "Care and Feeding of the Transaction Log" where presumably she'll talk more about FULL and BULK_LOGGED. She already touched on some key differences but I am looking forward to even more detail when I am in Seattle. One thing I learned was that a database with FULL Recovery Model behaves the same as one in SIMPLE, if you have never ever performed a Full Backup on that database. You learn something every day. All in all, the 24 hours of PASS was a great success. I am hoping the future of the PASS Summit will continue with this direction of Virtual sessions in tandem with the live in-person sessions. I would prefer to be there in person but if I cannot be, I would love to be a fly on the wall. And I would gladly pay for it this time. cheers Brian See: http://www.sqlpass.org