One Paragraph of project description goes here
These instructions will get you a copy of the project up and running on your local machine for development and testing purposes. See deployment for notes on how to deploy the project on a live system.
IF OBJECT_ID (N'dbo.parseJSON') IS NOT NULL | |
DROP FUNCTION dbo.parseJSON | |
GO | |
CREATE FUNCTION dbo.parseJSON( @JSON NVARCHAR(MAX)) | |
RETURNS @hierarchy TABLE | |
( | |
element_id INT IDENTITY(1, 1) NOT NULL, /* internal surrogate primary key gives the order of parsing and the list order */ | |
parent_ID INT,/* if the element has a parent then it is in this column. The document is the ultimate parent, so you can get the structure from recursing from the document */ | |
Object_ID INT,/* each list or object has an object id. This ties all elements to a parent. Lists are treated as objects here */ |
// this is the background code... | |
// listen for our browerAction to be clicked | |
chrome.browserAction.onClicked.addListener(function (tab) { | |
// for the current tab, inject the "inject.js" file & execute it | |
chrome.tabs.executeScript(tab.ib, { | |
file: 'inject.js' | |
}); | |
}); |
CREATE FUNCTION [dbo].[udf_HTMLDecode] (@text NVARCHAR(MAX)) | |
RETURNS NVARCHAR(MAX) AS | |
BEGIN | |
DECLARE @vcResult NVARCHAR(MAX) | |
DECLARE @vcCrLf NVARCHAR(2) | |
DECLARE @siPos SMALLINT | |
DECLARE @vcEncoded NVARCHAR(7) | |
DECLARE @siChar SMALLINT | |
SET @vcCrLF = CHAR(13) + CHAR(10) |
## | |
## Windows 10 cleanup script. | |
## Remove dodgy tracking settings, unneeded services, all apps, and optional features that come with Windows 10. Make it more like Windows 7. | |
## NOTE: this was tested on Creators Update (1703) and Fall Creators Update (1709). Some of this may not work as expected on newer versions. | |
## | |
## Instructions | |
## 1. Run this script (under Powershell as Administrator): | |
## powershell -ExectionPolicy Bypass .\cleanup-win10.ps1 | |
## 2. Let it run through, you may see a few errors, this is normal | |
## 3. Reboot |
How to fix a USB drive showing up as two drives (fragmented into multiple partitions) on Windows:
diskpart
to enter the disk partition tool.list disk
to see all disks listed.select disk [NUMBER]
. Be careful to select the correct drive.clean
. An error will occur if you have the drive folder open, close the window and repeat the command if this happens.create partition primary
.format fs=ntfs quick
to format the drive (you can also choose to set fs=fat32
).active
.