As promised, here are my slides and the demo code.

I had a great time in Brighton and I’m looking forward to the next one, can’t wait to find out where it will take place !

Don’t just load the demo code and run it. I used a table with real data at the end which is obviously not in the demo script. But you should be able to read through it and use my code.

The script and the powerpoint can be dowloaded here :

Powerpivot for DBA's

Virtual File Stats Demo

If you have any questions, just let me know.
If you were in my session, please fill out the eval !

I’ve submitted my session for SQLBits IV.

This time I’m bringing a guest. Henk van der Valk runs the Unisys test centre and we all wish we had his test box at home. Probably until we get the first electricity bill

The picture is from the European PASS Conference in Dusseldorf 2009, Henk van der Valk presenting together with Thomas Kejser from the SQLCAT team. Look at the task manager on the screen….

It’s a 96 core box with 1/2 Terabyte of memory (!)
During the demo in this picture it was attached to a DSI RAMSAN which can do around 600.000 IOPS….

This will be my 4th SQLBits and I’m looking forward to it again, it’s a great conference. This year they have even expanded the concept and besides  a free Community Day on the Saturday, there is also a Training Day on Thursday and a not-free-but-also-not-expensive conference day on the Friday.

Check it out at www.sqlbits.com