SQL server Archives - Page 5 of 7

Creating SQL Server Database Objects Backup using SMO

May 22, 2011

This post explains taking the SQL Server Database Objects backup only schema not data in SQL Server 2008 R2. In an ETL server you may come across the situation where you need to change the database objects schema quite…

Creating Maintenance Plans in SQL Server 2008 R2

March 14, 2011

Kalyan Bandarupalli

SQL server, SQL server 2008

No Comments

One of the repetitive task that DBA need to perform is create maintenance plan for database. Maintenance plans enables you to automate maintenance activities for a database, backups, db integrity checks and index maintenance tasks. We can easily…

Creating Maintenance Plans in SQL Server 2008 R2

March 14, 2011

Kalyan Bandarupalli

SQL server, SQL server 2008

3

One of the repetitive task that DBA need to perform is create maintenance plan for database. Maintenance plans enables you to automate maintenance activities for a database, backups, db integrity checks and index maintenance tasks. We can easily create a…

Monitoring running processes in SQL Server 2008 R2

March 3, 2011

Kalyan Bandarupalli

SQL server, SQL server 2008, SQL Server 2008 R2

No Comments

You can view the current connections and processes that running on a sql server instance in two ways Using Activity Monitor Using T-SQL statements Monitoring Process in Activity Monitor To open the Activity Monitor in SQL Server Management Studio…

SQL Server Reporting with Analysis Services

March 1, 2011

Kalyan Bandarupalli

SQL server, SQL Server 2008 Analysis Services, SQL Server 2008 R2

1

SQL Server Analysis Services is used to present the aggregated data to support analysis, ad-hoc reporting and decision making process. Technically CUBE is used in Analysis Services to build the aggregated data. Once it is build then you…

Installing AdventureWorks Analysis Services Database

February 26, 2011

Kalyan Bandarupalli

SQL Server 2008 Analysis Services, SQL Server 2008 R2

3

This post discuss about configuring the AdventureWorks Analysis Services Database in SQL Server 2008 R2. You can download the sample databases from here. By default when you install the setup you would not see the analysis services database,…

Filtering Techniques for SQL Server 2008 R2 Reports

February 20, 2011

Kalyan Bandarupalli

SQL server, SQL server 2008, SQL server Reporting Services

No Comments

It is important to consider to filter report data based on user’s selection criteria as many databases contain large amounts of data. This post discusses different techniques to filter report data using report parameter concepts. By using the filters on…

Building a CUBE in SQL Server 2008

November 21, 2010

Kalyan Bandarupalli

SQL server 2008, SQL Server 2008 Analysis Services

No Comments

Creating the Project To create a cube, we need to create a Analysis Services Project in Visual Studio. Start Visual Studio, select File, New Project. In project dialogue box, select Business Intelligence Projects from Project Types and select Analysis Services…

Importance of Data Warehousing and its Design

August 22, 2010

Kalyan Bandarupalli

No Comments

This post explains about what Data warehousing is and why we should care about it and then speaks about importance of using in enterprises and its design. It is important to understand the what data warehousing is all about, As…

PIVOT & UNPIVOT Operators in SQL Server 2008

April 19, 2010

Kalyan Bandarupalli

SQL server, SQL server 2008

2

PIVOT is a new T-SQL operator introduced in SQL Server 2008 which can be used to rotate rows into columns and can create a crosstab query. You can specify the PIVOT operator in FROM clause of your query. Using PIVOT…