Friday , December 15 2017
Home / pappu

pappu

Oracle Linux OS Installation Step by Step on Vmware

Place the Software in Vmware, Browse and Go Next 1) installation of Linux Using Vmware 2) It Will Automatically Will start Booting and Press Enter 3) Select Language and Create Custom Layout 4) Creating Custom layout / root – 15 gb, swap – 4gb , remaining for allocated for /u01 …

Read More »

BASIC UNIX COMMANDS

Basic Unix Commands Command Example Description 1. ls ls -alF Lists files in current directory List in long format 2. cd tempdir cd .. cd ~sarath/web-docs Change directory to tempdir Move back one directory Move into sarath’s web-docs directory 3. mkdir mkdir graphics Make a directory called graphics 4. rmdir …

Read More »

Feedback from Kartheek

SQL DBA @ Hewlett Packard (HP)   Feedback from Kartheek --------------------------------------------------------------------------------------------- Respected sir, As of now I am doing good. I am applying the concepts that u thought to me. Practically also gaining some knowledge. I am Thank full for ur wonderful support. Also I am suggesting ur name for …

Read More »

PIVOT & UN PIVOT Tables in SQL Server

PIVOT & UN PIVOT Tables in SQL Server The PIVOT operator, which was introduced in SQL Server 2005. A pivot table is a frequently used method of summarizing and displaying especially report data by means of grouping and aggregating values.Pivot tables are easily created by MSOffice users using in Excel.The Pivot table …

Read More »

feedback from Kotieshwar SQL DBA

I am feeling very happy to be having dedicated teacher. you are  teaching theoritically and practically at a time so every one is understanding easily . your response is very good. i completely satisfied with your training . you are maintaing very clarity while you are teaching to us so …

Read More »

About Transaction Log with Example

about Transaction Log File

A database can have one or more log file. In general there will be only one log file as there is no performance improvement by having multiple log file. SQL server uses the transaction log in sequential manner.As the data file divided into pages,log files are divided into virtual log …

Read More »

Setting Database Options

Setting Database Options A number of database-level options that determine the characteristics of the database can be set for each database. Only the SA, database owner, db creator fixed server roles and db_owner fixed database roles can modify these options. These options are unique to each database and do not …

Read More »

SQL Server 2012 Installation Step by Step with Screenshots

SQL Server 2012 Installation Step by Step with Screenshots

SQL Server 2012 Installation. Steps to install SQL Server 2012, with complete screenshots. Click on the Setup, you will get this menu. Choose Installation, you will get Key menu, Enter the Key, then Next. We go Normal/ Standalone Instance then next. Select the features, what needs to be install. Then …

Read More »
DON’T MISS OUT!
Subscribe To Newsletter
Be the first to get latest updates and exclusive content straight to your email inbox.
Stay Updated
Give it a try, you can unsubscribe anytime.
close-link
GET OUR LATEST CONTENT IN YOUR INBOX

SUBSCRIBE 
Your information will never be shared
close-link
Sign-up for exclusive content. Be the first to hear about DBA Centre Blogs.
Subscribe