MSDE/SQL Express concurrent user limit

Does MSDE/SQL Express has a 5 concurrent user limit? Euan Garden clarifies this.

SQL Server 2005 Missing Indexes Feature

Very cool feature for SQL Server 2005 - Missing Indexes Feature.  It uses dynamic management objects and Showplan to provide information about missing indexes that could enhance SQL Server query performance. So you can just run a query to find out which indexes are missing. Of course it can't replace developer or DBA, who certainly knows better how to fine tune DB, but can help to do so.

Here a blog post of Russian MVP Alexander Gladchenko, who pointed me to this feature.

Technorati tags: SQL Server, index

WizHook - more undocumented functions

Something what I did not know yet - WizHook is an internal undocumented library for Access wizards in Access 2000 and later. Anyway - not so useful either, most of the functions listed in PDF I have already in VB/VBA.

Update: PDF is now located at http://www.pacificdb.com.au/support/CodeFiles/Access_WizHook.pdf

ActiveX control events

When somebody tries to use ActiveX control events for first time – it looks like ActiveX control has only few events:

But this is just a limitation of Access property sheet, it does not show all events. To get all events you can do the following: open form’s class module in VBE, in left top combo select control name, in right top combo – event you need, and event procedure will be inserted into class module: