Looking for some free SQL Server training? How about 24 hours of free training offered by some of the top SQL Server experts in the world? If so, sign up for the upcoming 24 Hours of PASS live webcasts to be held September 15-16, 2010. It’s your opportunity to continue and broaden your SQL Server education, with your only investment being your time.
Recently, I wrote a review of Red Gate Software’s new SQL Virtual Restore software. SQL Virtual Restore allows you to quickly turn a compressed backup into a live, virtual database, with the advantage that the virtual database is substantially smaller than the original database, while at the same time acting identically to the production database.
Where can you spend $100 and get three full days of technical training? devLINK of course. devLINK 2010 was held this past week in Nashville (August 5-7), and had 800 registered attendees. There were over 150 session in 10 different tracks, with 71 different speakers. While the focus of the event was more towards developers, there was a Database Platforms and Development track that included many prominent speakers, including Kevin Kline, Joe Webb, Jeremiah Peschka, Joe Kuemerle, Jason Follas, Louis Davidson, Dennis Bottjer, Philip Japikse, and Brad McGehee.
If you were unable to attend, or can’t get enough SQL Server training, there will be a SQL Saturday in Nashville on August 21, 2010.
While I have always known that the Windows operating system Power Plan options affect a server’s performance, I had not realized how much until SQL Server MVP Glenn Berry (Blog | Twitter) suggested I try out my new Dell T610 test servers under the three available power savings plans:
Sometimes, its just the smallest of details that can make all the difference. For example, on my test system (see the end of this posting for a description), I created a new 50GB database. The database creation process took about 5 minutes and 50 seconds to complete.
The SQL Server DMV Starter Pack is a free eBook (84 pages) that describes 28 different ways that DMVs can be used with SQL Server. Not only is each way described in detail, but sample code is included so you can begin using the DMVs immediately. The book covers these uses of DMVs.
Brad M McGehee 