Basic Introduction

-

Introduction to SQL Server

What is SQL Server RDBMS?

As you most likely know, SQL Server is primarily thought of as a Relational Database
Management System (RDBMS). It is certainly that, but it is also much more.

SQL Server can be more accurately described as an Enterprise Data Platform. It offers many new features in every new version i.e. even more enhanced or improved features from previous versions of the product. In addition to traditional RDBMS duty, SQL Server also provides rich reporting capabilities, powerful data analysis, and data mining, as well as features that support asynchronous data applications, data-driven event notification, and more.

The components of SQL Server are




Database Engine
The Database Engine is the primary component of SQL Server. It is the Online Transaction Processing (OLTP) engine for SQL Server. The Database Engine is a high-performance component responsible for the efficient storage, retrieval, and manipulation of relational and Extensible Markup Language (XML) formatted data.

SQL Server’s Database Engine is highly optimized for transaction processing, but offers exceptional performance in complex data retrieval operations. The Database Engine is also responsible for the controlled access and modification of data through its security subsystem.



Analysis Services

Analysis Services delivers Online Analytical Processing (OLAP) and Data Mining functionality for business intelligence applications. As its name suggests, Analysis Services provides a very robust environment for the detailed analysis of data. It does this through user-created, multidimensional data structures that contain de-normalized and aggregated data from diverse data sources (such as relational databases, spreadsheets, flat files, and even other multidimensional sources).
Reporting Services
Reporting Services is a Web service–based solution for designing, deploying, and managing flexible, dynamic Web-based reports, as well as traditional paper reports. These reports can contain information from virtually any data source. Because Reporting Services is
implemented as a Web service, it must be installed on a server with Internet Information
Services (IIS). However, IIS does not have to be installed on a SQL Server. The Reporting Services databases are hosted on SQL Server, but the Web service itself can be configured on a separate server.

Integration Services
SQL Server Integration Services (SSIS) is Microsoft’s new enterprise class data Extract, Transform, and Load (ETL) tool. SSIS is a completely new product built from the ashes of SQL Server 2000’s Data Transformation Services (DTS). SSIS offers a much richer feature set and the ability to create much more powerful and flexible data transformations than its predecessor. This huge improvement, however, is not without a cost. SSIS is a fairly complex tool and offers a completely different design paradigm than DTS. Database administrators adept at the former tool are very often intimidated and frustrated by the new SSIS. Their biggest mistake is in thinking that Integration Services would just be an
upgrade of Data Transformation Services.

Comments

Post a Comment

Popular posts from this blog

AlwaysOn Overview

-
Image
OVERVIEW An availability group supports a failover environment for a discrete set of user databases, known as availability databases, that fail over together. An availability group supports a set of primary databases and one to eight sets of corresponding secondary databases. Secondary databases are not backups. Continue to back up your databases and their transaction logs on a regular basis. Each set of availability database is hosted by an availability replica. Two types of availability replicas exist: a single primary replica. which hosts the primary databases, and one to eight secondary replicas, each of which hosts a set of secondary databases and serves as a potential failover targets for the availability group. The primary replica makes the primary databases available for read-write connections from clients. Also, in a process known as data synchronization, which occurs at the database level. The primary replica sends transaction log records of each primary databa...
Read more

Database Developer vs Database Administrator

-
Image
Hi Geeks, Hope you're all doing good!! Have you ever asked someone or yourself to know who is a database developer and database administrator ? Or Have you ever been confused as to the difference between a DBA and a SQL Developer? Well, then you are not alone. There are number of blurred lines about exactly what is a DBA role, what is a SQL developer role. And thousands of people are still looking for the exact definitions. In this post, I will try my level best to clear all of your doubts about these two simple yet complicated things.  On a lighter note, The database administrator performs the day-to-day task(s) of maintaining the database environment to ensure its availability. Make sure it runs smoothly using database  tools to monitor, fix and maintain the database software, also the hardware on which it runs. On the other hand, the database developer designs and creates new ways of using a software  application. The database developer does this b...
Read more

Long Running queries

-
How do I find a long running query with process ID, process name , login time, user , start time and duration? Long running queries have been found in the plan cache. These may be ETL, reports, or other queries that should run long. Or it could be that someone is searching for all users whose names are LIKE '%%'. Either way, these queries bear investigating. In some cases, this is the total clock time that the query took to execute and in others this is the total CPU time that the query took to execute. Queries with a high max_elapsed_time just take a lot of time to run – they could be slow single threaded queries. Queries with a high max_worker_time (CPU time) may be highly parallel queries. CODE: SELECT  creation_time         ,last_execution_time         ,total_physical_reads         ,total_logical_reads         ,total_logi...
Read more