March 17, 2012 at 12:25 pm
Hi,
Can someone help me with an overview regarding the sql server microsoft? What it is used for? Stocking datas regarding databases (why not stocking that datas on our own pc?)
Manipulating excel files?
I need from someone helping me with a explanatiom...
March 17, 2012 at 12:43 pm
take a help of google. your will find all the basics of sql server.
March 17, 2012 at 1:21 pm
Best quick and be no means complete explanation .. but think of a data base as say a book with an index. If you want to find something in the volume of the book, you would look in the book's index to find the page or pages the subject is discussed. In some way (now this is very simplistic) a database is like a book with an index, but with a significant improved method of locating information (data). Say I have information concerning sales people and customers ... how in a book would I find which sales person is associated with each customer. Look up the sales persons name, and there you could have a list of all those sales persons customers. But now to find a list of ALL the companies customers, I would have to look up each sales person ... write down their customers and do this for each and every sales person to complete my list of all customers. In a relational database I can do this very, very simply by having 2 tables, one listing all sales people the other listing all the company's customers. With simple statements I can find all the customers with one question, and yet I also have the ability to find all the customers of a individual sales person with a single question. Now I know this is too simplistic, but hopefully you can get an idea of the use of a database and why it is used. It allows me to find data that is related to other items of data.
And I can do this for hundreds or thousands of customers and sales people, something that would be difficult to do using EXCEL and even harder if I could create the EXCEL pages, in reading through all the data to find say the customers of a particular sales person, without having to list the sales person multiple times on multiple Excel sheets.
March 17, 2012 at 1:38 pm
Thanks now is more clear!
March 19, 2012 at 1:10 am
pacioaga.alisia (3/17/2012)
(why not stocking that datas on our own pc?)
Because enterprise data usually takes more then just a few gigabytes.
And it needs to be available 24/7. If you store it on your own PC, the data will be unavailable the second you turn it off or when you restart it.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 19, 2012 at 1:20 am
Koen Verbeeck (3/19/2012)
pacioaga.alisia (3/17/2012)
(why not stocking that datas on our own pc?)Because enterprise data usually takes more then just a few gigabytes.
And it needs to be available 24/7. If you store it on your own PC, the data will be unavailable the second you turn it off or when you restart it.
And it needs to be fast, secure, reliable and resistant to disaster.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 19, 2012 at 3:54 am
So to understand correctly sql server is to store important companies info for do not loose it.
March 19, 2012 at 3:56 am
pacioaga.alisia (3/19/2012)
So to understand correctly sql server is to store important companies info for do not loose it.
In a nutshell, yes.
But as Gail mentioned, there are other reasons as well.
You can also store data in an Access database, but SQL Server will be much faster, more reliable and more scalable.
You can use SQL Server as well to do reporting and analysis on your data.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply