In the move to DotNetNuke 3.x, the core team has decided to support the new membership provider API that Microsoft is introducing in ASP 2.0. The new model brings enhanced functionality and extensibility to DotNetNuke, but it also removes much of the profile data from the Users table to a new table named aspnet_Profile. This has essentially removed access to this data from SQL queries and joins because it is no longer stored in individual fields like in DNN 2, but now resides in a blob type field instead. This article will show you how to get it back !