Sorean's Virtual Home

Windows Server Convert Eval to Standard/Datacenter

by on Feb.18, 2020, under Tech Stuff

Powershell as Admin

DISM /Online /Set-Edition:ServerStandard /ProductKey:xxxxx-xxxxx-xxxxx-xxxxx-xxxxx /AcceptEula

DISM /Online /Set-Edition:ServerDatacenter /ProductKey:xxxxx-xxxxx-xxxxx-xxxxx-xxxxx /AcceptEula

Leave a Comment more...

Clean up WinSXS folder

by on Feb.03, 2020, under Tech Stuff

See how much data is being used:

dism /Online /Cleanup-Image /AnalyzeComponentStore

Command to clean it up:

dism /online /Cleanup-Image /StartComponentCleanup

Run the first one again to review the difference.

Leave a Comment more...

Search Database for a value

by on Jan.30, 2020, under Database Related

This saved my butt of having to search through almost 2000 tables for a value.


DECLARE @SearchStr nvarchar(100)
SET @SearchStr = ’01-07-079-14 W6M’

— Copyright © 2002 Narayana Vyas Kondreddi. All rights reserved.
— Purpose: To search all columns of all tables for a given search string
— Written by: Narayana Vyas Kondreddi
— Site: http://vyaskn.tripod.com
— Updated and tested by Tim Gaunt
— http://www.thesitedoctor.co.uk
— http://blogs.thesitedoctor.co.uk/tim/2010/02/19/Search
+Every+Table+And+Field+In+A+SQL+Server+Database+Updated.aspx
— Tested on: SQL Server 7.0, SQL Server 2000, SQL Server 2005 and SQL Server 2010
— Date modified: 03rd March 2011 19:00 GMT
CREATE TABLE #Results (ColumnName nvarchar(370), ColumnValue nvarchar(3630))

SET NOCOUNT ON

DECLARE @TableName nvarchar(256), @ColumnName nvarchar(128), @SearchStr2 nvarchar(110)
SET @TableName = ”
SET @SearchStr2 = QUOTENAME(‘%’ + @SearchStr + ‘%’,””)

WHILE @TableName IS NOT NULL

BEGIN
SET @ColumnName = ”
SET @TableName =
(
SELECT MIN(QUOTENAME(TABLE_SCHEMA) + ‘.’ + QUOTENAME(TABLE_NAME))
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = ‘BASE TABLE’
AND QUOTENAME(TABLE_SCHEMA) + ‘.’ + QUOTENAME(TABLE_NAME) > @TableName
AND OBJECTPROPERTY(
OBJECT_ID(
QUOTENAME(TABLE_SCHEMA) + ‘.’ + QUOTENAME(TABLE_NAME)
), ‘IsMSShipped’
) = 0
)

WHILE (@TableName IS NOT NULL) AND (@ColumnName IS NOT NULL)

BEGIN
SET @ColumnName =
(
SELECT MIN(QUOTENAME(COLUMN_NAME))
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = PARSENAME(@TableName, 2)
AND TABLE_NAME = PARSENAME(@TableName, 1)
AND DATA_TYPE IN (‘char’, ‘varchar’, ‘nchar’, ‘nvarchar’, ‘int’, ‘decimal’)
AND QUOTENAME(COLUMN_NAME) > @ColumnName
)

IF @ColumnName IS NOT NULL

BEGIN
INSERT INTO #Results
EXEC
(
‘SELECT ”’ + @TableName + ‘.’ + @ColumnName + ”’, LEFT(‘ + @ColumnName + ‘, 3630) FROM ‘ + @TableName + ‘ (NOLOCK) ‘ +
‘ WHERE ‘ + @ColumnName + ‘ LIKE ‘ + @SearchStr2
)
END
END
END

SELECT ColumnName, ColumnValue FROM #Results

DROP TABLE #Results

 

Leave a Comment more...

Powershell to reinstall windows 10 apps

by on Jan.15, 2020, under Tech Stuff

Powershell as admin

Get-AppxPackage -AllUsers| Foreach {Add-AppxPackage -DisableDevelopmentMode -Register “$($_.InstallLocation)\AppXManifest.xml”}

Leave a Comment more...

AWS Data Lifecycle Manager vs AWS Backup

by on Jan.04, 2020, under Amazon Web Services

My scenario was that I only wanted a backup of my EC2 every 6 months. It hosts this blog and a couple others, but I don’t really need anything beyond that.

Specifically when looking AWS Backup options for EC2(EBS volumes), the Data Lifecycle Manager allows for basic policies and limited options whereas you can specify custom parameters via a Cron task (https://docs.aws.amazon.com/AmazonCloudWatch/latest/events/ScheduledEvents.html) for AWS Backup.

After configuration this is the definition and schedule in my AWS Backup plan:

Custom cron expression: cron(0 5 6 1,7 ? *)
At 05:00 AM UTC, on day 6 of the month, only in January and July

Pricing

DLM uses standard EBS pricing as it creates EBS snapshots (https://aws.amazon.com/ebs/pricing/)
AWS Backup pricing is the same but allows for more services (https://aws.amazon.com/backup/pricing/)

There is no cost difference in my scenario.

Leave a Comment more...

Windows Auto Login Registry

by on Dec.09, 2019, under Tech Stuff

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Winlogon

  • DefaultUserName – Reg_SZ
  • DefaultPassword – Reg_SZ
  • DefaultDomain – Reg_SZ
  • AuotAdminLogon  = 1

Reboot to verify.

Leave a Comment more...

Find Password Policy

by on Sep.16, 2019, under Tech Stuff

net accounts (Local password policy)

net accounts /domain (Domain enforced password policy)

Leave a Comment more...

Looking for something?

Use the form below to search the site:

Still not finding what you're looking for? Drop a comment on a post or contact us so we can take care of it!

Blogroll

A few highly recommended websites...