Last night I attended the CbusPASS (that’s the Columbus chapter of the Professional Association for SQL Server, aka the Columbus SQL Server Users Group) meeting. I’m not using SQL Server much these days so the take home value isn’t immediate for me. I’m interested in databases in general, I have used SQL Server in the past, and I expect I will use it even more in the future so I do enjoy these meetings. The remote presentation almost failed due to audio problems but fortunately a member of the group had a notebook PC that worked for both audio and video. Tim Ford presented on SQL Server Dynamic Management Views and Dynamic Management Functions. What follows is basically a link dump from my notes:
Group leader: Jeremiah Peschka, SQL Server Developer
Jeremiah Peschka (peschkaj) on Twitter
Tim Ford’s web site SQLAgentMan
Tim Ford (sqlagentman) on Twitter
Tim writes for MSSQLTips.com, among other things.
Tim said he will post the slides and examples from the presentation at SpeakerRate.
MSDN: Dynamic Management Views and Functions
SQLTeam: Dynamic Management Views
SQLTeam: SQL Server – Find missing and unused indexes
MSDN: Reorganizing and Rebuilding Indexes
Backup your Resource Database.
There was discussion after the meeting about PowerPivot, previously code named Project Gemini, and the PowerPivotPro site.