DotNetNuke - T-SQL manually update to clear password for known user name

DotNetNuke - T-SQL manually update to clear password for known user name

declare @password as varchar(100)
declare @username as varchar(100)
set @password = 'xxxxx'
set @username = 'yyyyy'
begin tran
update aspnet_Membership set
[Password] = @password,
PasswordFormat = 0
where UserId in
(select top 1 UserId from aspnet_Users where UserName = @username)
commit

DotNetNuke - SiteLog T-SQL for deleting everything except newest 100000 rows

DotNetNuke

Unless you master the art of DotNetNuke logging engine most dreadful feature of DNN is its vast log tables which tends to skyrocket size of DNN databases.
This script is no legit solution you should understand and properly configure DNN logging but until then it does the job...

select * into sitelog100000 from SiteLog s
where s.SiteLogId in (
select top 100000 SiteLogId from SiteLog order by SiteLogId desc)
truncate table sitelog


--select * from sitelog100000
set identity_insert sitelog on
INSERT INTO [dbo].[SiteLog]
           ( SiteLogId, [DateTime]
           ,[PortalId]
           ,[UserId]
           ,[Referrer]
           ,[Url]
           ,[UserAgent]
           ,[UserHostAddress]
           ,[UserHostName]
           ,[TabId]
           ,[AffiliateId])
select * from sitelog100000
set identity_insert sitelog off
drop table sitelog100000

ASP.NET embedded code in markup / inline server tags / ASP.NET expressions

Nice overview of confusing ASP.NET inline code syntax in ASPX / ASCX files;

http://weblogs.asp.net/ahmedmoosa/embedded-code-and-inline-server-tags

http://www.intstrings.com/ramivemula/asp-net/access-code-behind-variables-in-aspx-and-javascript/