Muhammad Umair Irshad umair-me

mykeels / RsaKeyService.cs

Last active January 26, 2024 03:47

For IdentityServer4's AddSigningCredentials in production

	using Newtonsoft.Json;
	using System;
	using System.Collections.Generic;
	using System.IO;
	using System.Linq;
	using System.Security.Cryptography;
	using System.Threading.Tasks;
	using Microsoft.AspNetCore.Hosting;
	using Microsoft.IdentityModel.Tokens;

umair-me / get_table_details.sql

Created January 19, 2016 16:09

Query to list number of records and table size in each table in a database

	SELECT
	t.NAME AS TableName,
	i.name as indexName,
	p.[Rows],
	sum(a.total_pages) as TotalPages,
	sum(a.used_pages) as UsedPages,
	sum(a.data_pages) as DataPages,
	(sum(a.total_pages) * 8) / 1024 as TotalSpaceMB,
	(sum(a.used_pages) * 8) / 1024 as UsedSpaceMB,
	(sum(a.data_pages) * 8) / 1024 as DataSpaceMB

hyle / ko.utils.3.3.0.signatures.js

Last active April 9, 2019 13:08

KnockoutJS 3.3.0 utils (ko.utils) signatures

	// knockout 3.3.0

	ko.utils.addOrRemoveItem = function (array, value, included) { /* .. */ }

	ko.utils.anyDomNodeIsAttachedToDocument = function (nodes) { /* .. */ }

	ko.utils.arrayFilter = function (array, predicate) { /* .. */ }

	ko.utils.arrayFirst = function (array, predicate, predicateOwner) { /* .. */ }

hyle / ko.utils.3.1.0.signatures.js

Created March 5, 2014 08:30

KnockoutJS 3.1.0 utils (ko.utils) signatures

	ko.utils.addOrRemoveItem = function (array, value, included) { /* .. */ }

	ko.utils.anyDomNodeIsAttachedToDocument = function (nodes) { /* .. */ }

	ko.utils.arrayFilter = function (array, predicate) { /* .. */ }

	ko.utils.arrayFirst = function (array, predicate, predicateOwner) { /* .. */ }

	ko.utils.arrayForEach = function (array, action) { /* .. */ }

umair-me / close_all_connections.sql

Last active January 19, 2016 16:07

Close all connections SQL server database

	USE master
	GO
	ALTER DATABASE YourDatabaseName
	SET OFFLINE WITH ROLLBACK IMMEDIATE
	GO