TechBubbles Microsoft Technology BLOG

CategorySQL server

Creating SQL Server Database Objects Backup using SMO

  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 frequently especially when data source changes. In this case we may need maintain our schema or take the backup our database objects script some place where we can restore...

Creating Maintenance Plans in SQL Server 2008 R2

    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 maintenance plan using a wizard in sql server 2008 R2.   You can use the following steps to create a maintenance plan 1...

Creating Maintenance Plans in SQL Server 2008 R2

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 maintenance plan using a wizard in sql server 2008 R2.   You can use the following steps to create a maintenance plan 1. Select the...

SQL Server Reporting with Analysis Services

    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 can easily navigate and produce reports for business analysis. This post discusses using analysis services in SQL Server Reporting with MDX query...

Installing AdventureWorks Analysis Services Database

    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, you need to do some configurations to get it appear in analysis services database.   To deploy the analysis services database perform the...

Filtering Techniques for SQL Server 2008 R2 Reports

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 reports, it greatly reduces the network traffic and helps the report to render efficiently.   We are using same data source and query that...

Importance of Data Warehousing and its Design

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 a database developer you are likely to be involved with Data warehousing in one way or the other. Data Warehousing Defined: Data warehousing is a methodological approach...

PIVOT & UNPIVOT Operators in SQL Server 2008

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
Specify the desired values that you want to see in SELECT statement and FROM clause contains the PIVOT statement. Let us take an example

TechBubbles Microsoft Technology BLOG

Follow me

Archives

Tag Cloud