|
What's New with SQLskills?
We've just returned from our Fall conference trip to Europe and back - checkout some of the pictures from my day wandering around Vienna
here. We've also just posted all the scripts and details of the last few
conferences - checkout the revamped past events page for details.
The SQL Server 2008 Internals book we're working on with Kalen Delaney is available for pre-ordering on Amazon.com!
My whitepaper on SQL Server 2008's FILESTREAM feature has been published - see here. My
TechNet Magazine article on SQL Server 2008: Tracking Changes in Your Enterprise Database has been published - see here.
Recent RunAs Radio sessions are available - one from me on FILESTREAM (see here) and one
from Kimberly on indexes (see here).
We're back home now for a some local teaching (well, Kimberly has to pop over to Ireland for a week) and wrapping up 2008 projects before heading off
for a well-deserved vacation over Christmas.
Lastly, if you're in the US, Happy Thanksgiving!
Thanks, Paul (November 23rd 2008)
|
|
|
|
| Welcome to SQLskills! |
|
|
This site is dedicated to providing helpful content, resource links, conference scripts, and all sorts of
tips and tricks related to Microsoft® SQL Server®. For certain content, you must be a subscriber. Subscribe now!
|
|
|
| Meet the team... |
ÞBob Beauchemin
ÞKimberly L. Tripp
ÞLiz Vitt
ÞPaul S. Randal
ÞSimon Sabin
ÞStacia Misner
|
|
|
| Announcements
|
|
|
|
Make sure to subscribe. SQLskills regularly presents around the globe is planning a lot of new and interesting changes for
2008 and 2009. Be sure to subscribe so you'll be the first to hear the exciting news. (And don't worry - we *rarely* send email, we use our blogs
for frequent communications. ) Subscribe now!
|
|
|
|
|
April 2008
Paul Randal named a SQL Server MVP! After leaving the Microsoft and the SQL Server team at the end of August 2007, Paul has
been doing a ton of community work - blogging, teaching, user groups - and that's been recognized with this award.
Of course, Kimberly, Bob, and Simon were all renewed as MVPs too.
|
|
|
| Interviews
|
|
|
Septemer 2008: Kimberly - RunAs Radio
Interview with the RunAs Radio guys (Richard Campbell and Greg Hughes) discussing indexes from every angle. Get it
here.
|
|
|
|
|
August 2008: Paul - RunAs Radio #2
Interview with the RunAs Radio guys (Richard Campbell and Greg Hughes) discussing the FILESTREAM feature of SQL Server 2008. Get it
here.
|
|
|
|
|
August 2008: Paul - RunAs Radio #1
Interview with the RunAs Radio guys (Richard Campbell and Greg Hughes) discussing what it is to be an "involuntary DBA". Get it
here.
|
|
|
|
|
March 2008: Paul & Kimberly - TechNet Radio Part 2
Discussing troubleshooting and manageability in SQL Server 2008. See the March 11th show
here.
|
|
|
|
|
March 2008: Paul & Kimberly - TechNet Radio Part 1
Discussing security and availability in SQL Server 2008. See the March 4th show
here.
|
|
|
|
|
December 2007: Paul & Kimberly - RunAs Radio
Interview with Richard Campbell and Greg Hughes at TechEd ITPro in Barcelona discussing new features in SQL Server 2008. Get it
here.
|
|
|
|
|
November 2007: Paul & Kimberly - SSWUG TV
Video interview from SQL Connections Fall discussing new features in SQL Server 2008. Paul struggles to break away from calling
the SQL team 'we'... Get it
here.
|
|
|
|
|
November 2007: Paul & Kimberly - TechEd TV
Video interview from TechEd ITPro Barcelona -looking very tired and wondering why we signed up for 12 sessions... See
here.
|
|
|
|
|
October 2007: Paul - SQL Down Under
Interview with Greg Low discussing CHECKDB differences between 2000 and 2005, new features in SQL Server 2008, plus Lego. See show #24
here.
|
|
|
|
|
March 2007: Paul - .NET Rocks
Paul's turn finally! Discussing SQL Server 2005 Performance and Recovery (with special guest...) -
here.
|
|
|
|
|
March 2007: Paul & Kimberly - SSWUG TV
Video interview from SQL Connections Spring discussing disaster recovery and Blokus -
here.
|
|
|
|
|
March 2007: Paul & Kimberly - UK NextGen User Group
Podcast interview while in the UK presenting a full day class on Crucial Database Maintenance -
here.
|
|
|
|
|
May 2006: Kimberly - .NET Rocks
DotNetRocks got her again! Download and enjoy the session posted
here.
|
|
|
|
|
April 2005: Kimberly - .NET Rocks
Another great time on DNR. Download and enjoy the session posted
here.
|
|
|
|
|
August 2004: Kimberly - .NET Rocks
It was the first one and definitely NOT her last... What a great time! Download and enjoy the session posted
here.
|
|
|
|
|
|
|
| Upcoming Events
|
|
|
Conferences, Workshops and Seminars around the World...
SQLskills is presenting at:
ÞFebruary 2009: Public classes in Melbourne, Australia (Paul, Kimberly)
ÞMarch 2009: SQL Connections in Orlando (Paul, Kimberly, Bob)
ÞSee the full schedule of Upcoming Events here.
|
|
|
|
|
| *NEW* November 2008 TechNet Magazine Tracking Changes Article
|
The feature article on SQL Server 2008: Tracking Changes in Your Enterprise Database I wrote for the November issue of TechNet Magazine is live on the web. It also includes a
5 minute long screencast I recorded where I demo Change Data Capture. You can get to the article
here. The topics covered are:
- The need for tracking changes
- Tracking changes in SQL Server 2005
- Change tracking in SQL Server 2008
- Change data capture in SQL Server 2008
|
| *NEW* Whitepaper on FILESTREAM
|
The whitepaper I wrote for Microsoft on FILESTREAM Storage in SQL Server 2008 has been published.
You can get it from here. The topics covered are:
- Choices for BLOB Storage
- Configuring Windows for FILESTREAM
- Configuring SQL Server for FILESTREAM
- And more!
|
| *NEW* Whitepaper on Replication and Mirroring
|
The whitepaper I wrote for Microsoft on combining database mirroring with replication has been published.
You can download it here. The topics covered are:
- Configuring replication in a mirrored environment
- Effect of mirroring partnership state changes on replication
- Effect of a mirroring failover on replication
- How to use LSN-based initialization to recover from the failover of a mirrored subscriber database
|
| *NEW* August 2008 TechNet Magazine Database Maintenance Article
|
The feature article on Effective Database Maintenance I wrote for the August issue of TechNet Magazine is live on the web. It also includes a
5 minute long screencast I recorded where I demo the effect of database shrink on index fragmentation. You can get to the article
here. The topics covered are:
- Managing data and transaction log files
- Eliminating index fragmentation
- Ensuring accurate, up-to-date statistics
- Detected corrupted database pages
- Establishing an effective backup strategy
|
| Script to determine the amount of change in a database
|
|
|
Choose between a differential or full backup. See
here for more info!
|
|
|
| Dual Database Monitor
|
|
|
The Dual Database Monitor is now available - click
here for more info!
|
|
|
| Special Events
|
|
|
SQL Immersion Events
After great reviews from our three SQL Immersion Events, be sure that SQLskills is planning more. In early 2009, we will
announce our 2009 Immersion Event Calendar - there will be no Immersion Events in 2008, but we do have some public classes - see
here. Immersion Events are unique and individually planned seminars and workshops, with content
specifically created by database-related industry experts. The training materials are customized to provide deep coverage enabling attendees to
master the content. These RARE, small and intense events are the place to be for high quality SQL Server training.
Subscribers will be the first to know - and the first to be offered special discounts and incentives. Classes are limited to 36
attendees and often event/site specific limitations exist and many courses have a maximum of only 20 to 24. Be sure to register early as these classes have
sold out in the past. Subscribe now!
|
|
|
|
|
|
|
|
| SQLskills Online Resources
|
|
|
Conference Resources
If you're looking for Demo Scripts and other useful conference resources, review the full list of past events with their resources here.
|
|
|
|
|
TechNet Webcast Series for the ITProfessional: Building Robust, Reliable and Available SQL Server Systems
11-part Series, Recorded Mar-May 2006
Read the Event Series Blog Entry for links
|
|
|
MSDN Webcast Series on SQL Server 2005
Effectively Designing a Scalable and Reliable Database
10-part Series, Recorded Aug-Nov 2005
Read the Event Series Blog Entry for links
|
|
|
IT's ShowTime from TechNet
3 Sessions from TechEd Europe
Recorded July 2005
Access Here
|
|
|
MSDN Webcast on SQL Server 2000
Indexing for Performance - Finding the Right Balance
Recorded 11 June 2004
Access Here
|
|
|
|
|
MSDN Webcast on SQL Server 2000
Indexing for Performance - Index Maintenance Best Practices
Recorded 19 July 2004
Access Here
|
|
|
|
|
Database Administrator’s Guide to SQL Server Database Engine .NET CLR Environment
The official version has been released on TechNet, please reference the released paper
here.
|
|
|
SQL Server 2005 Beta II Whitepaper: Partitioned Tables and Indexes
The official version has been released to MSDN, please reference the released paper
here.
|
|
|
|
|
SQL Server 2005 Beta II Whitepaper: Snapshot Isolation
The official version has been released to MSDN, please reference the released paper
here.
|
|
|
|
|
|
|
|
