Skip to content

Instantly share code, notes, and snippets.


Juan on Software juanonsoftware

  • Rabbit Software
  • Vietnam
View GitHub Profile
juanonsoftware / gist:7067ce53813201abbdae
Last active Aug 29, 2015
C# Convert null property to Empty JSON object by property's type
View gist:7067ce53813201abbdae
namespace JsonConvertNullToEmpty
public class Main
public Child First
juanonsoftware / gist:b55bcf15923f3f9cd2f4
Created Jun 29, 2015
C# LINQ with join on multiple properties
View gist:b55bcf15923f3f9cd2f4
namespace ConsoleApplication1
public class Context
public IList<Product> Products { get; set; }
public IList<Company> Companies { get; set; }
public class Product
juanonsoftware / gist:103fec4fa9c5b9e2ab14
Last active Aug 29, 2015
Displaying image from webapi using javascript base64
View gist:103fec4fa9c5b9e2ab14
// GET api/values
public dynamic Get()
var root = AppDomain.CurrentDomain.SetupInformation.ApplicationBase;
var path = Path.Combine(root, "App_Data/Koala.jpg");
var bytes = File.ReadAllBytes(path);
var base64 = Convert.ToBase64String(bytes);
juanonsoftware / gist:f4b3e85415ccdcab2161
Created Jul 3, 2015
NHiberate - Code to make SchemaExport generate database for entities mapping class
View gist:f4b3e85415ccdcab2161
using System;
using NHibernate.Cfg;
using NHibernate.Dialect;
using NHibernate.Driver;
using NHibernate.Mapping.ByCode;
using NHibernate.Mapping.ByCode.Conformist;
using NHibernate.Tool.hbm2ddl;
namespace ConsoleApplication1
juanonsoftware / sql-get-all-locks.sql
Last active Dec 21, 2018
A script to list all current locks in SQL server
View sql-get-all-locks.sql
-- With SQL
select handle.text as sql, * from
select DB_NAME(dbid) as dbname, *
from master.dbo.sysprocesses
where blocked <> 0
juanonsoftware / Kill-sql-locks
Created Apr 12, 2018
Kill blocking processes on a database
View Kill-sql-locks
--- Kill blocked processes on a database
DECLARE @databasename nvarchar(50)
SET @databasename = N'Datbase_Name'
-- SET @databasename = DB_NAME()
DECLARE @Sql varchar(max)
SET @Sql = ''
SELECT @Sql = @Sql + 'Kill ' + Convert(varchar, SPId) + ';'
FROM master.dbo.sysprocesses
juanonsoftware / sql-backup-database-diff
Last active Apr 12, 2018
Script to backup an SQL Server database
View sql-backup-database-diff
-- Must update dbName & Folder
declare @dbName nvarchar(150);
declare @folder nvarchar(100);
set @dbName = 'TestDB';
set @folder = 'D:\Mega\Wip\SQL\TestDB\Backup\';
declare @path nvarchar(255);
juanonsoftware / sql-check-index-fragmentation.sql
Last active Apr 12, 2018
Check Fragmentation of ALL Indexes in a Database
View sql-check-index-fragmentation.sql
SELECT dbschemas.[name] as 'Schema',
dbtables.[name] as 'Table',
dbindexes.[name] as 'Index',
FROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL, NULL, NULL) AS indexstats
INNER JOIN sys.tables dbtables on dbtables.[object_id] = indexstats.[object_id]
INNER JOIN sys.schemas dbschemas on dbtables.[schema_id] = dbschemas.[schema_id]
juanonsoftware / sql-get-running-jobs.sql
Last active Apr 12, 2018
To get all jobs that are running on an instance
View sql-get-running-jobs.sql
ja.job_id, AS job_name,
ISNULL(last_executed_step_id,0)+1 AS current_executed_step_id,
FROM msdb.dbo.sysjobactivity ja
LEFT JOIN msdb.dbo.sysjobhistory jh
ON ja.job_history_id = jh.instance_id
JOIN msdb.dbo.sysjobs j
juanonsoftware / sql-get-db-backups.sql
Last active Apr 12, 2018
Script to get all backup of a SQL Server database
View sql-get-db-backups.sql
declare @dbName varchar(255);
set @dbName = 'TestDB';
SELECT m.physical_device_name,
b.backup_size/1024/1024 AS BackupSizeMB,
b.compressed_backup_size/1024/1024 as CompressedBackupSizeMB