MS SQL Server Solutions

The experienced SQL Server team at CORE consists of architects, developers and database administrators who have real world experience in creating the best possible solutions for our clients. We will ensure that the solutions we deliver exceed your expectations and help you achieve maximum gains from your investments.

About MS SQL Server

Microsoft™ SQL Server is a relational database management system (RDBMS) that offers various tools to perform tasks such as database development, maintenance and administration. They are designed to run on platforms ranging from laptops to large multiprocessor servers. MS SQL Server is commonly used as the back end system for various websites and corporate CRMs and can support thousands of multiple users.

Some of the tools provided by MS SQL Server include SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services), an OLAP and data mining server (Analysis Services), and several messaging technologies, specifically Service Broker and Notification Services.

There have 4 version releases of the MS SQL Server: MS SQL Server 2000, MS SQL Server 2005, MS SQL Server 2008 and the latest one being the MS SQL Server 2012 version.

We will talk about a few tools in detail below:

SSIS(SQL Server Integration Services)

Microsoft™ SQL Server 2008 Integration Services provides a way to build solutions for data integration and data transformations. SQL Server Integration Services (SSIS) is a tool that we use to perform ETL operations; i.e. extract, transform and load data.

SSIS is a replacement for Data Transformation Services (DTS) which was available with SQL Server 7.0 and SQL Server 2000.

SQL Server Management Studio (SSMS) provides Import and Export Wizard which can be used to create SSIS packages. They can also be used to copy data from one data source to another. The user can choose from a range of source and destination data source types, select tables to copy or specify your own query to extract data, and finally save your work as an SSIS package.

Business Intelligence Development Studio(BIDS) is the tool that we use to develop SSIS packages. It provides an intuitive interface based on Microsoft’s™ Visual Studio product which has been used by developers for many years. It allows users to edit SSIS packages using a drag-and-drop user interface.

An example of an SSIS package would be similar to a program that designed to do a specific task. Suppose we wanted to copy the contents of a table in a database to an Excel spreadsheet, we can create a SSIS package using the Export Wizard task in SSMS to do this.

SSRS (SQL Server Reporting Services)

Microsoft™ SQL Server 2008 Reporting Services (SSRS) can be used to prepare and deliver a range of reports for your organization. These reports can be either in an interactive or printed format. It comes with a full range of ready-to-use tools and services that can be administered via a web interface. It also provides various features that can help you to customize and design your reports. It consists of the following tools: