Kalyan

My name is Kalyan Bandarupalli and I currently live and work in London, UK. I am graduate in Computer Applications and my masters degree in Information Systems. My Professional career started as software engineer and then senior software developer and Software Architect. I am Microsoft Tetchier use .NET technologies to develop the applications. Since 2003 I am working as .NET Developer. I was far more concern about technical implementation of software, but in the past few years focus has changed to more architectural implementation of software. I recently (June 2008) started this blog because I want to share my learning’s and to help other people about new technologies in Microsoft .NET. This BLOG helps IT professionals around the world to develop applications using Microsoft .NET Technologies. This BLOG only speaks about Microsoft Technologies.

PIVOT & UNPIVOT Operators in SQL Server 2008

Kalyan (www.techbubbles.com)

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...

Date & Time Data Types in SQL Server 2008

Kalyan (www.techbubbles.com)

The four new data types for storing dates and times in SQL Server 2008 are Date Time DateTime2 DateTimeoffset This post discuss about new date...

T-SQL TIP in SQL Server 2008

Kalyan (www.techbubbles.com)

You love this if you write a lot of T-SQL code. This tip I can say as T-SQL language syntax enhancement. The following are the enhancements in T-SQL...

Introducing DotnetSizzler.com

Kalyan (www.techbubbles.com)

Dear Readers, I have come up with a new BLOG DotnetSizzler that serves as a center that offers my services and is a platform for discussion and sharing of...

MERGE Statement in SQL Server 2008

Kalyan (www.techbubbles.com)

There has been significant T-SQL improvements in SQL Server 2008. This post explores the most notable changes in T-SQL introduced in SQL Server 2008. The...

Creating an Analysis Services Project in Visual Studio 2008

Kalyan (www.techbubbles.com)

Microsoft SQL Server Analysis Services allows the developers to provide a unified access of data for analytical analysis and reporting. Developers can manage...

Silverlight sample in Visual Studio 2008

Kalyan (www.techbubbles.com)

This post explains the tools required to start working with the Silverlight 3 in VS 2008. Also explains the sample Silverlight application building in Visual...

Table Expressions in SQL server

Kalyan (www.techbubbles.com)

Table Expressions are sub-queries where a table is expected. There are two types of table expressions. This post explains how to use the Table expressions and...

SQL server Joins or Subqueries?

Kalyan (www.techbubbles.com)

Select statements that use join operator and join statements can be written in Subqueries and similarly Subqueries can be written in Joins. Writing the Select...

SQL Server Reports Integration with SharePoint 2007

Kalyan (www.techbubbles.com)

This post explains how to Deploy the SQL server Reports to Office SharePoint Server 2007. SQL Server Reporting Services can operate in two modes, either in...