Technology Guruu

  • Home
  • Site Info
    • About Us
    • Disclaimer
    • Privacy Polacy
  • Home
  • Digital Marketing
    • SEO
    • SMM
    • SEM
  • Quotes
  • Technical
  • Java
  • .Net
    • C#.Net
    • ASP.Net
  • Keychains

Tuesday, 12 July 2016

Brief Explanation About Microsoft SQL Server

 Akansha     11:30:00     TechnicalQuestions     No comments   

Here we are placing Microsoft SQL Server brief description and how to work with sql server also give a best explanation about why it came's.For who are not knowing the SQL server Connection follow the below steps connect with sql server start to learn sql server commands easily.
sql server
Sql Server is a Query Language it can be treated as back end,it means we are running the program innerside. For developing Purpose we are using Front end languages like java,c#.net,vn.net etc for storing data in database we are using backend languages like SQL server,oracle,My SQL etc.

Introduction To SQL Server

  • SQL Server is an RDBMS product which was designed and developed by Microsoft Company.
  • SQL Server will provide Graphical User Interface (GUI) facilities it means that user can interact with the database using icons without remember any commands.
  • SQL Server will run only windows operating system i.e. it is a platform dependent.
  • The first version of SQL SERVER is 1.0 was released in 1989 and up to now 11.0 versions are available.

Working with SQL SERVER: 

  • SQL Server is a collection of databases where database is a collection of various objects like Tables, Views, Procedures and Functions etc.
  • To work on SQL Server we use SQL Server Management Studio. It is a tool used for the SQL server. If we connect to server it shows a window with ….
 Server Type
 Server Name
 Server Authentication
 Username & Password

Server Type:

SQL server contains five types of servers those are

 Database Engine: The Database Engine is the core service for storing, processing, and securing data (or) it is used to store, manage and to access the data from the database.
 Analysis Services: It is used for data warehouse it will show the data in three dimensions (Rows, Columns and New dimension).
 Reporting Services: It is a reporting tool used to generate reports in various formats such as creating interactive, tabular, graphical, multidimensional, or XML-based data sources. Reports can include rich data visualization, including charts, maps etc.
 Integration Services: It is used to convert tables from relational database to another relational database for e.g. If we want to convert SQL Server tables to ORACLE tables or My SQL tables then will be used.
 SQL Server Compact Edition: It is used to develop mobile application or mobile software.
Server Authentication:
We have two types of authentications are
  1. Windows Authentication: Windows Authentication work on the user admin and when we work on window authentication there is no required user name and password because operating system will generate User Id and Password by default.
  2. SQL Server Authentication: SQL Server will work on the current user and when we work on SQL Server authentication then user should enter User Id and Password (These User ID and Password will give at the time of SQL Server installation).
Step To Connect To SQL SERVER:
Go to start
Go to programs
Go to Microsoft SQL Server 2008 R2/12
Click on SQL server management studio
Click on connect button.
Object Explorer Window: This window contain Database, Security, Server Objects, Replication and Management options.
SQL Server contains two types of databases these are
1.System Database: The system database include the following four databases
 Master: It is used to manage system level information of SQL server.
 Model: It is used as a template for all new creating databases in SQL Server.
 Msdb: It is used to store the alerts and job information contains the SQL commands which are executed by user.
 Tempdb: When ever SQL server is started tempdb will be created in SQL server. It is used to store temporary tables once we restart the server the tempdb database is destroyed.
2.User Database: These databases are created and manage by the user for storing their objects like tables, views, procedure etc
  • Share This:  
  •  Facebook
  •  Twitter
  •  Google+
  •  Stumble
  •  Digg
Email ThisBlogThis!Share to XShare to Facebook

Related Posts:

  • How Many Members Know Microsoft Office Word Shortcuts? What are the shortcuts available in Microsoft Office Word? Below I Place what are the shortcuts available using Ctrl, Shift, and Alt in Microsof… Read More
  • Best Tutorial of Constructors in OOPS Constructors and Methods are the heart for our programming languages like java,c#.net,vb.net etc Any developer first know the value of constructors… Read More
  • Why Multiple Inheritance Concept Not Applicable In C#.Net Many of us think we have inheritance topic that will solve any problem and we are implement anything in inheritance concept except one i.e Multiple … Read More
  • Updated Keywords in Java And Usage Of Java Keywords What are the Updated Java Keywords in 2016 Keywords are the heart of any programming language they play main role in developing programming.so frie… Read More
  • Download UNLOCK ROOT program to work for all phones How to Root Any Android Phone  The unlock root program is one of the most powerful specialized in the work programs Root. Root of all Mobile… Read More
Newer Post Older Post Home

0 comments:

Post a Comment

Popular Posts

  • Love Failure Quotes and Sad valentines day Quotes
    We Love Someone is a easy process sometime takes long time to love someone love others within short period but anyway always love dependin...
  • Brief Description about Multicast Delegate
    Multicast delegate is an extension of normal delegate. It helps you to point more than one method at a single moment of time. Multicast ...
  • Top 10 valentine's day Quotes and Greetings wishes
    All Lovers have Anxiety in Valentines day because it is a festival to all lovers in these they enjoy a lot and celebrate the Valentine...
  • Missing My Friend Quotes : Friendship Day Quotes 2017
    Friends today my article about missing friends and moments with them. Here you are seen the best friendship quotes and some  feelings when...
  • Brief description about Delegates
    Introduction about delegates and why delegates are came the main purpose of delegates how to useful and what are the advantages and disadv...
  • Wonderful sayings about Life.
    I Believe Follow  Things(Life Quotes) I Believe I believe: ********** Believe in Life ********** That we don't have to chan...
  • swami vivekananda best motivational Quotes
    Some Peoples are always have a negative thinking & bad mood their heart always filled with sadness & they are in depression mood.e...
  • Top 10 Words Of Encouragement and encouraging quotes
    Friends when you are depression mood everyone have some encouragement words that gives boost strength for You i feel these quotes helpful ...
  • Na Tanu Samjhawan Ki Song lyrics
    Na Tanu Samjhawan Ki Song Lyrics With English Translation Movie : Humpty Sharma ki Dulhaniya Song : Samjhawan Song Singer : Arijit ...
  • Detail Introduction about C#.Net
    Brief Introduction about C#.Net  Introduction C#.Net is the one of the Programming Language the .Net Framework also contains ano...

Categories

  • Entertainment (67)
  • TechnicalQuestions (58)
  • Quotes (11)
  • C#.Net (8)
  • Java (8)
  • ValentinesDay (4)
  • SEO (3)
  • Home
  • About Us
  • Disclaimer
  • Privacy Policy
  • Sitemap

Copyright © 2015-2017 Good Friends 5.All Rights Reserved• And Our Sitemap • All Logos and Trademark Belongs To Their Respective Owners•