SQL Server DBA Interview Question Accenture In this post we will provide some SQL Server DBA Interview Question Accenture, these questions asked from one of friend recently go for interview in accenture for SQL Server DBA position. Qus: Difference between Log Shipping and Database Mirroring? Ans: Log shipping DB Mirroring Primary server, secondary server and monitor […]
Category: Sql Server
SQL Server Tutorials, SQL Server Tutorials for Beginners, SQL Server Online Course, Microsoft SQL Server Learning, Microsoft Online Learing
Enable TCP/IP Protocol in SQL Server Configuration Manager Using Command Prompt Hi friends, in this tutorial we will explain how to Enable TCP/IP Protocol in SQL Server Configuration Manager Using Command Prompt. Here we are not using GUI. This question is asked by one of my friend in a interview. First of all open command prompt […]
How to Configure User to Create and Manage SQL Server Agent Jobs Hi friends, in this tutorial I will explain you How to Configure User to Create and Manage SQL Server Agent Jobs. Sometime it is required to provide a user permission only for managing SQL SERVER AGENT. To manage SQL server agent you must […]
Find Fragmentation Level by using Command Prompt SQL Server In this post we will learn how to Find Fragmentation Level by using Command Prompt SQL Server. Find fragmentation in SQL Server is so easy, and that much in command prompt too. Query: —–Find database id with this query—- select * from sys.sysdatabases —-Find Fragmentation Level by […]