Skip to content

Data World

Drive Into Data

  • Home
  • About Me
Data World

Category: Uncategorized

SSAS-Find blocking onSSAS Tabular server

December 16, 2015 parmsingla Uncategorized

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 more

Hadoop: Check version

December 11, 2015 parmsingla Uncategorized

Problem: How to check the version of the Hadoop installed in your environment? Solution: ps -ef |grep Hadoop

Read more

SQL Server-Check Data difference between two tables

November 25, 2015 parmsingla Uncategorized

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 more

PowerShell – Do Not use Write-Host!!!!!

November 20, 2015 parmsingla Uncategorized

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

SQL Server – Check whether the SQL server is configured for case sensitivity or not

June 10, 2015 parmsingla Uncategorized

Problem: How to check whether the SQL server is configured for case sensitivity or not? Solution: Case sensitivity: By Case Sensitive, we mean[…]

Read more

SQL Server Services installed by SQL Server 2012

January 9, 2013 parmsingla Uncategorized

List of Services Installed by SQL Server 2012 Depending on the components that you decide to install, SQL Server Setup[…]

Read more

SQL Server -Window XP useful commands for DBA

October 10, 2012 parmsingla Uncategorized

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

Posts navigation

«Previous Posts 1 2 3 Next Posts»
Categories
  • Artificial Intelligence
  • Azure
  • Big Data
  • Books
  • Certifications
  • Databricks
  • DP-203
  • Finance
  • Interview Questions
  • Leadership
  • LLMs
  • Machine Learning
  • Motivational
  • Performance Tuning
  • Python
  • Scripts
  • Spark
  • SQL Server
  • SSIS
  • Synapse
  • Top 10 Takeaways
  • Uncategorized
Archives
  • August 2023
  • March 2023
  • July 2022
  • September 2018
  • May 2018
  • January 2018
  • October 2017
  • August 2017
  • March 2017
  • December 2016
  • August 2016
  • May 2016
  • December 2015
  • November 2015
  • June 2015
  • August 2014
  • August 2013
  • January 2013
  • October 2012
  • June 2012
  • February 2012
  • May 2011
WordPress Theme: Poseidon by ThemeZee.
Follow by Email
Facebook
fb-share-icon
LinkedIn
LinkedIn
Share
Data World
Proudly powered by WordPress Theme: Poseidon.