juanonsoftware

begin tran

declare @c uniqueidentifier
while(1=1)
begin
    select top 1 @c = conversation_handle from dto.YourQueueName
    if (@@ROWCOUNT = 0)
    break
    end conversation @c with cleanup
end

juanonsoftware

declare @dbName varchar(255);

set @dbName = 'TestDB';

SELECT          m.physical_device_name,
                b.backup_start_date,
                b.backup_finish_date,
                b.type,
                b.backup_size/1024/1024 AS BackupSizeMB,
                b.compressed_backup_size/1024/1024 as CompressedBackupSizeMB

juanonsoftware

SELECT
    ja.job_id,
    j.name AS job_name,
    ja.start_execution_date,      
    ISNULL(last_executed_step_id,0)+1 AS current_executed_step_id,
    Js.step_name
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

-- https://myadventuresincoding.wordpress.com/2013/05/27/sql-server-check-index-fragmentation-on-all-indexes-in-a-database/
SELECT dbschemas.[name] as 'Schema', 
dbtables.[name] as 'Table', 
dbindexes.[name] as 'Index',
indexstats.alloc_unit_type_desc,
indexstats.avg_fragmentation_in_percent,
indexstats.page_count
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

-- NOTE
-- 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

--- 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

-- With SQL

select handle.text as sql, * from
(
	select DB_NAME(dbid) as dbname, *
	from master.dbo.sysprocesses
	where blocked <> 0

	union

juanonsoftware

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

WebAPI
        
        // 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

namespace ConsoleApplication1
{
    public class Context
    {
        public IList<Product> Products { get; set; }
        public IList<Company> Companies { get; set; }
    }

    public class Product
    {