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 moreCategory: Uncategorized
Hadoop: Check version
Problem: How to check the version of the Hadoop installed in your environment? Solution: ps -ef |grep Hadoop
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 moreSQL Server – Check whether the SQL server is configured for case sensitivity or not
Problem: How to check whether the SQL server is configured for case sensitivity or not? Solution: Case sensitivity: By Case Sensitive, we mean[…]
Read moreSQL Server Services installed by SQL Server 2012
List of Services Installed by SQL Server 2012 Depending on the components that you decide to install, SQL Server Setup[…]
Read moreSQL Server -Window XP useful commands for DBA
run>msinfo32 It gets the system information like OS, version name, components and many more. run>sqlservermanager11.msc Opens the SQL server configuration[…]
Read more