Sep 28, 2025

Azure DTU

 In Azure SQL Database, DTU stands for Database Transaction Unit — it’s a performance metric that combines CPU, memory, reads, and writes into a single measure.


Think of it as a “power level” — the higher the DTU, the more workload the database can handle.




How to Check DTU Usage

You can monitor DTU utilization via:

Azure Portal → SQL Database → Monitoring → DTU usage (%)

Query via T-SQL

SELECT * FROM sys.dm_db_resource_stats ORDER BY end_time DESC;

You can estimate your DTU requirement using Microsoft’s DTU Calculator:

https://dtucalculator.azurewebsites.net


Jul 10, 2025

fn_my_permissions

 fn_my_permissions ( securable , 'securable_class' )

Value Description
DATABASE   Permissions on the current database
OBJECT Table, View, Stored Procedure, etc.
SCHEMA Database schema
SERVER Server-level permissions

SELECT * FROM fn_my_permissions(NULL, 'DATABASE');

SELECT * FROM fn_my_permissions(NULL, 'SERVER');

SELECT * FROM fn_my_permissions('dbo.YourTableName', 'OBJECT');

Jul 3, 2025

PackageNameSource Table NameDestination Table Name
ETL_ARCHIVE_FIN10_HTD_LOAD
ETL_ARCHIVE_FIN10_LFM_LOAD
ETL_ARCHIVE_FIN10_RTH_LOAD
ETL_ARCHIVE_FIN10_IDT_LOAD
ETL_ARCHIVE_FIN10_LDA_LOAD
ETL_ARCHIVE_FIN10_RTL_LOAD
ETL_ARCHIVE_FIN10_UPR_LOAD
ETL_ARCHIVE_FIN10_GET_LOAD
ETL_ARCHIVE_FIN10_RCT_LOAD
ETL_ARCHIVE_FIN10_SDRH_LOAD
ETL_ARCHIVE_FIN10_ATD_LOAD
ETL_ARCHIVE_FIN10_EAB_LOAD
ETL_ARCHIVE_FIN10_ALR_LOAD
ETL_ARCHIVE_FIN10_CMG_LOAD
ETL_ARCHIVE_FIN10_LRH_LOAD
ETL_ARCHIVE_FIN10_LRSH_LOAD
ETL_ARCHIVE_FIN10_ACPART_LOAD
ETL_ARCHIVE_FIN10_GAM_LOAD
ETL_ARCHIVE_FIN10_LRHH_LOAD
ETL_ARCHIVE_FIN10_LRS_LOAD
ETL_ARCHIVE_FIN10_ADT_LOAD
ETL_ARCHIVE_FIN10_ATO_LOAD
ETL_ARCHIVE_FIN10_COT_LOAD
ETL_ARCHIVE_FIN10_GAC_LOAD
ETL_ARCHIVE_FIN10_LDAH_LOAD
ETL_ARCHIVE_FIN10_LTDH_LOAD
ETL_ARCHIVE_FIN10_AED_LOAD
ETL_ARCHIVE_FIN10_ITC_LOAD
ETL_ARCHIVE_FIN10_LDTH_LOAD
ETL_ARCHIVE_FIN10_SMT_LOAD
ETL_ARCHIVE_FIN10_AAS_LOAD
ETL_ARCHIVE_FIN10_ACH_LOAD
ETL_ARCHIVE_FIN10_LAM_LOAD
ETL_ARCHIVE_FIN10_LDT_LOAD
ETL_ARCHIVE_FIN10_FBM_LOAD_ARCHIVE
ETL_ARCHIVE_FIN10_FAE_LOAD_ARCHIVE
ETL_ARCHIVE_FIN10_RTT_LOAD_ARCHIVE
ETL_ARCHIVE_FIN10_DDC_LOAD_ARCHIVE
ETL_ARCHIVE_FIN10_C_CRLIFE_LOAD_ARCHIVE
ETL_ARCHIVE_FIN10_OTC_LOAD_ARCHIVE
ETL_ARCHIVE_FIN10_RPT_LOAD
ETL_ARCHIVE_FIN10_CGM_LOAD
ETL_ARCHIVE_FIN10_FCI_LOAD
ETL_ARCHIVE_FIN10_HTH_LOAD
ETL_ARCHIVE_FIN10_SOL_LOAD