Andy Mepham AndyMeps

## Mirkwood Footsteps Uploaded Media By Size.sql
/* SELECT * FROM sys.views WHERE name LIKE '%BySize%' */

DECLARE @Grouping AS TABLE (
	 BusinessId INT
	,SizeInBytes BIGINT
)

INSERT INTO @Grouping
(BusinessId, SizeInBytes)
SELECT

## LocalHost IE10
If you can't get Edge to access localhost websites, run command prompt as administrator and run the following command

CheckNetIsolation LoopbackExempt -a -n=Microsoft.MicrosoftEdge_8wekyb3d8bbwe

## create_log_file_usage_table.sql
CREATE TABLE [master].[dbo].[LogFileUsage] (
   [Id]             [int]           IDENTITY(1,1) PRIMARY KEY NOT NULL
  ,[DatabaseName]   [nvarchar](100) NOT NULL
  ,[LogSize]        [real]          NOT NULL
  ,[PercentageUsed] [real]          NOT NULL
  ,[LogDateTime]    [datetime]      NOT NULL DEFAULT GETDATE()
)
	/* SELECT * FROM sys.views WHERE name LIKE '%BySize%' */

	DECLARE @Grouping AS TABLE (
	BusinessId INT
	,SizeInBytes BIGINT
	)

	INSERT INTO @Grouping
	(BusinessId, SizeInBytes)
	SELECT
	If you can't get Edge to access localhost websites, run command prompt as administrator and run the following command

	CheckNetIsolation LoopbackExempt -a -n=Microsoft.MicrosoftEdge_8wekyb3d8bbwe
	CREATE TABLE [master].[dbo].[LogFileUsage] (
	[Id] [int] IDENTITY(1,1) PRIMARY KEY NOT NULL
	,[DatabaseName] [nvarchar](100) NOT NULL
	,[LogSize] [real] NOT NULL
	,[PercentageUsed] [real] NOT NULL
	,[LogDateTime] [datetime] NOT NULL DEFAULT GETDATE()
	)