Enable TCP/IP Protocol in SQL Server Configuration Manager Using Command Prompt

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

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

How to install Oracle 11g in Windows 7

How to install Oracle 11g in Windows 7 In this tutorial i will explain you How to install Oracle 11g in Windows 7. Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is an object-relational database management system produced and marketed by Oracle Corporation. An Oracle database system—identified by an alphanumeric system identifier or SID—comprises

Forgot Oracle 11g Username and Password

Forgot Oracle 11g Username and Password In this post we will learn how to recover Forgot Oracle 11g Username and Password. Recently i have installed Oracle 11g on my system, after installation finish. When i try to login credentials i remember, i found that i have forgotten my credentials. In my case i do not remember

Find Fragmentation Level by using Command Prompt SQL Server

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