Problem: Many a times DBA/Developer needs to identify the blocking in SQL server. Following queries will help you out. Solution:[…]
Read moreLatest Posts
SSAS-Find blocking onSSAS Tabular server
Problem: How to find blocking on SSAS Tabular server? Solution: Option1: select *from $system.discover_locks where lock_status=0 Option2: SELECT [SESSION_COMMAND_COUNT], [SESSION_CONNECTION_ID], [SESSION_CPU_TIME_MS],[…]
Read moreHadoop: Check version
Problem: How to check the version of the Hadoop installed in your environment? Solution: ps -ef |grep Hadoop
Read moreSpark: Check version of Spark on CDH
Problem: How to check the version of the spark installed in your environment? Solution: Search for “spark-shell” in file system. in[…]
Read moreSSIS 2012 (SSISDB)- Check execution status of SSIS Package
Problem Statement: How to check the execution status of a SSIS package, deployed in SSISDB, using system tables? Solution: DECLARE @status INT=2/*Running The possible values are created (1), running […]
Read moreSQL Server-Check Data difference between two tables
Problem: How to compare tables and/or data to identify data changes between them? Solution: In data migration, we often have to compare two[…]
Read morePowerShell – Do Not use Write-Host!!!!!
Problem Statement: People often use Write-Host in their script, but it is considered harmful. Use other options instead. Solution: Write-Host is always[…]
Read more
