SQL Server Interview Question

SQL Server DBA Interview Questions and Answers – SQL Server System Databases and Recovery Model

System databases are very important part of the Database Management system. It plays a vital role in Database Administration as SQL Server functionality is based on the system database. This blog is about the SQL Server DBA interview Questions on the System databases, Important activities with the system databases and Recovery models. 1) What are system […]

SQL Server DBA Interview Questions and Answers – SQL Server Services

This blog is all about the SQL Server Services which are required for the functionality of SQL Server components. It also contains Questions answers about the important parameters and SQL Server start process. SQL Server DBA Interview Questions and Answers 1) List out various services which are important for SQL Server and its components functionality? […]

Powershell Automation SQL Server

Windows Powershell

Introduction to PowerShell Windows PowerShell is a Windows commandline shell scriptining mechanism particularly designed for System Admins. Windows PowerShell providex an inteactive command prompt and a scripting tool that can be utilized or integrated with other progmaming languages or can be used individualistically. Unlike most of the shell scripting languages, which acknowledge and return text, […]

SQL Server

SQL Server 2016 dynamic data masking – a preface

Dynamic data masking is one of best security attribute introduced in SQL Server 2016 Community Technology Preview 3. This is a security mechanism which covers the sensitive piece of information in the output of a user query over a set of defined column. This feature is very easy to implement with Existing code as this […]

Lifestyle Healthy Life

10 Healthy Habits of Healthy People

  • March 6, 2016
  • 0 Comments

10 Habits of Healthy People: Despite the fact that health is often connected with an individual’s physical state, it incorporates a lot more. A true wellbeing is a mixture of mental, emotional, and spiritual health. Definitely, the last thing you would want to do is add more to-do’s on your daily list. But guess what? […]

SQL Server DBA Interview Questions and Answers-Data File and Transaction Log File Architecture

This Blog illustrates about the most frequent questions which are asked about the Data file and Transaction Log file architecture. Intentionally I did not add any troubleshooting questionnaire in this blog because I will post a separate Questions\Answers blog for the same. 1) Explain the SQL Server Database Data File structure? SQL server divides the […]