Category Archives: What is SQL Server

There are different types of database available in the market which is developed by different companies such as oracle, Microsoft, IBM etc. Database designed by Microsoft is known as SQL Server Database.  SQL Server Database server incudes 1.      Database Engine. … Continue reading →

SQL Server Agent provides the database administrator provision of security by enabling the jobs by role wise. Roles of agent remains in MSDB.

SQL Server Browser is the windows service which provides the information about the instance of SQL server running on the current computer. SQL Server Browser provides the list of available server and helps to connect to the correct instance of … Continue reading →

SQL Azure is cloud base database platform provided by Microsoft. You can query database, access it. Your database will be hosted online and its DBA tasks will be taken care by Microsoft. I.e. you don’t need to bother about administration … Continue reading →

As per the word Authentication, it’s the process of verification whether someone using the particular utility or thing is the actual user or not. This verification is called as authentication. There are different mechanism exists for authentication, for applications generally … Continue reading →

Analysis service is Microsoft analytics tool which is used for OLAP and also popular as SSAS (SQL Server Analysis Service). Using Analysis services user can design multidimensional data structure which can be used for generating the reports. Analysis service takes … Continue reading →

SQL Server Agent is a SQL Server Service which runs job. It runs the scheduled jobs and creates other related information. While expanding management section in SQL Server management studio you can see SQL Server Agent. You have to start … Continue reading →

What is SQL: SQL Vs TSQL? Is SQL already exist what is TSQL and what is difference between SQL and TSQL.   As specified already in the previous post SQL is structured query language which is the set of rules defined … Continue reading →

When I was in engineering I heard the word SQL in my curriculum. Every engineers or people who have done any computer course or have done some sort of computer programming may have heard the word SQL or have tried … Continue reading →