Walking with SQL Server

To understand the security feature of SQL Server you need to understand the levels of security. So what happens at windows level, you need to user and password. As soon as you are inside windows you need to enter inside instance and for that you need a login. After entering into an instance you need to have users for each database. There will be mapping of users and login. So the main points are:  To enter into an instance we need a login.  To enter into database we need a user.  Users and logins must be mapped. When a machine is on a network, it can be:  Workgroup or   Domain Workgroup is a standalone machine which may or may not be connected to a network and all the machines will be independent of each other while domain is a centralised machine where Active Domain(AD) is installed therefore it is called a Domain Controller(DC). So it is not needed in this case to go on each machine separately. But while installing windows...

When we say databases, the first thing that comes into mind is data. It means it is something that deals with the data. So, basically what is a database? Database is a collection of tables, stored procedures, functions, triggers, indexes and jobs. So this definition uses a lot of new words that you may not be knowing. Nothing to worry about. We will come to know about all these terms in my next coming posts. To work on databases, we need an environment that could be either SQL Server environment, oracle, DB2 or any other environment. We are going to focus on SQL Server 2008 R2. The installation of the environment can be found here.  When we install the environment, some folders get generated automatically. The folders are listed here:  80 folder - For SQL Server 2000  90 folder - For SQL Server 2005  100 folder - For SQL Server 2008  MSAS_10_50 - Analysis Services  MSRS_10_50 - Reporting Services  MSSQL_10_50.MSSQLSERVER - ...

T o learn SQL Server the first most important thing is to learn about Windows Operating System. Here is a basic overview of what you should know about windows to learn SQL Server. Client and server: First of all we need to understand what are Clients and Servers. As the name suggests, clients are meant for requesting services and servers for providing services. It is not necessary to have separate hardware for residing client and server, it can be on the same hardware. When they are on different hardware they communicate with the help of network which can be either cable or wireless media. Components of Computer: Among the different components of a computer there are four components which you need to know before learning SQL Server as these are components that play a great role in the working of SQL Server. These components are: CPU RAM Hard disk Network CPU:  In CPU we basically mean processor whose speed is measured in GHz(Giga Hertz). If we talk about pr...