SQL Server Troubleshooting

All about SQL Server Error logs

SQL Server error logs are one of the important stuff to check whenever DBA face issues in the SQL Server instance. It contains lot of information about the Issues, Errors, Backup related information and Database consistency check occurrences based on the Trace Flag configuration of SQL Server instance. SQL Server error log file is recycled […]

Permission & Security SQL Server

SQL DBA Interview Questions and Answers – Security Permissions

1) What is Authentication and Authorization? What is the difference between both? Authentication is the process of verifying who you are. Logging on to a PC with a username and password is authentication. Authorization is the process of verifying that you have access to something. Authorization is gaining access to a resource (e.g. directory on […]

SQL Server Installations & Configuration Interview Question

SQL Server DBA Interview Questions and Answers-Installation

I have been thinking since long time to pen down a comprehensive series on most commonly asked DBA Interview questions. I have planned to segregate the entire questions series, topic wise to make it easier to explore. So in this post I am writing about the most commonly asked SQL Server Questions  on SQL Server installation […]

Technology

What is Big data Analytics – a buzzing career path?

  • February 28, 2016
  • 0 Comments

Big data analytic has become a necessity with the augmentation in the size and a simultaneous increase in the complexity of business data set thus providing a great perception through them in businesses. Big data means a large amount of data or too fast data which are difficult for existing tools. Database management systems have […]

Lifestyle Featured

How to manage your Work Life balance – Quick Tips

  • February 28, 2016
  • 0 Comments

Juggling between work life and personal life can be highly taxing for a career oriented individual. On the off chance that you have a corporate employment you cherish, it’s easy to pour your heart, soul, and each waking hour into it. It might also constrain you to work late evenings not only on weekdays but also […]

Installations & Configuration SQL Server Technology Virtualisation

How to use Microsoft Virtual Labs for Practical implementation

One of the important questions often asked by my fellow mates is how we can implement practical scenarios without configuring anything on Desktop or Laptop. This is a common problem for every IT guy as they may not be allowed to install anything on the Company laptops due to resource crunch, Performance aspects or may […]