Helpful Scripts for marketing website development
select count(*) as 'Pages With Skin', skinsrc from tabs
group by skinsrc order by count(*) desc
select 'https://www.clarity-ventures.com/' + baseurl, SkinSrc from tabs where isdeleted = 0 order by skinsrc desc
======================================================
Run via Cmd prompt with admin privileges
======================================================
rd /s c:\$Recycle.Bin
==========================================================
Run via PShell in Projects folder(s)
==========================================================
Get-ChildItem *.pdb -Recurse -erroraction SilentlyContinue | foreach { Remove-Item -Path $_.FullName }
Get-ChildItem *.log.resources -Recurse -erroraction SilentlyContinue | foreach { Remove-Item -Path $_.FullName }
Get-ChildItem *.log -Recurse -erroraction SilentlyContinue | foreach { Remove-Item -Path $_.FullName }
==========================================================
Run via PShell in Projects folder(s) - MORE
NOTE: check before running these to confirm
as this removes media files typically not
needed for dev but would not be okay to remove
in production
!!!! PLEASE DO NOT RUN IN NORMAL CIRCUMSTANCES !!!!
==========================================================
#CHECKFIRST! Get-ChildItem *.mp4 -Recurse | foreach { Remove-Item -Path $_.FullName }
#CHECKFIRST! Get-ChildItem *.mp3 -Recurse | foreach { Remove-Item -Path $_.FullName }
#CHECKFIRST! Get-ChildItem *.pdf -Recurse | foreach { Remove-Item -Path $_.FullName }
--======================================================
-- Run on SQL Server(s)
--======================================================
USE MASTER
GO
SET QUOTED_IDENTIFIER ON
GO
SET ARITHABORT ON
GO
DECLARE @DBName NVARCHAR(255),@LogicalFileName NVARCHAR(255),@LogicalDBFileName NVARCHAR(255),@DBRecoveryDesc Varchar(200)
DECLARE DatabaseList CURSOR
FOR
SELECT name,recovery_model_desc
FROM sys.databases
WHERE state_desc = 'ONLINE'
AND is_read_only = 0
and database_id > 4
ORDER BY name
OPEN DatabaseList
FETCH NEXT FROM DatabaseList INTO @DBName,@DBRecoveryDesc
WHILE @@FETCH_STATUS = 0
BEGIN
SET @LogicalFileName=(SELECT top 1 name FROM sys.master_files AS mf WHERE DB_NAME(database_id)=@DBName and type_desc='LOG')
SET @LogicalDBFileName = (SELECT top 1 name FROM sys.master_files AS mf WHERE DB_NAME(database_id)=@DBName)
If @DBName like '%DNN%'
Begin
Print('Use ['+@DBName+']
GO
TRUNCATE TABLE Exceptions
GO
DELETE FROM Eventlog
GO
-----------------------------------------------------------')
END
If @DBName like '%CEF%'
Begin
Print('Use ['+@DBName+']
GO
TRUNCATE TABLE System.SystemLog
GO
-----------------------------------------------------------')
END
If @DBRecoveryDesc='Full'
Begin
Print('Use ['+@DBName+']
GO
ALTER DATABASE ['+@DBName+'] SET RECOVERY SIMPLE WITH NO_WAIT
GO
DBCC SHRINKFILE ('''+@LogicalFileName+''',10)
GO
DBCC SHRINKFILE ('''+@LogicalDBFileName+''',10)
GO
-----------------------------------------------------------')
END
If @DBRecoveryDesc='Simple'
Begin
Print('Use ['+@DBName+']
GO
DBCC SHRINKFILE ('''+@LogicalFileName+''',10)
GO
DBCC SHRINKFILE ('''+@LogicalDBFileName+''',10)
GO
-----------------------------------------------------------')
END
FETCH NEXT FROM DatabaseList INTO @DBName,@DBRecoveryDesc
END
CLOSE DatabaseList
DEALLOCATE DatabaseList