Customers like to have have personalization in the aplications they use. In ASP.Net we have master pages, themes etc. that does the job for us but the question for personalizing the reports still holds back. Most companies will like to add their logo...

We can render the SQL Server 2000 Reporting/ 2005 Services (SSRS 2000) Reports in Excel/ PDF or any other format that is supported by SSRS by calling the web services exposed by SSRS 2000/ 2005. The SSRS 2000 will use .Net 1.1 at the server end and SSRS...

In reference to my earlier post regarding - How to dynamically add the images to the SQL Server 2005 Reporting Services – Reports, I received a few queries so I decided to write a small code sample myself just in order to demonstrate how we can...

http://www.microsoft.com/technet/traincert/virtuallab/bi.mspx The following labs are available on this page: Business Intelligence: Excel 2007 PivotTables and Analysis Services Business Intelligence: Using Business Scorecard Manager 2005 and ProClarity...

It is very exciting to know that people are widely using SQL Server 2005 Reporting Services. I am always happy to answer their questions. A couple of days back a gentleman requested for some help on the project that I have posted on this blog –...

Excited about SQL Server 2008 ! so I am. "Your Data, Any Place, Any Time" It is highly exciting to know about the features in SQL Server 2008. The mission of SQL Server 2008 is to provide your data on your demand at your place, isn't it exciting...

One of the very useful feature introduced in SQL Server 2005 SP2 and SQL Server 2008 is vardecimal data type. When the databases are growing every day it is a significant concern for the DBAs to use the storage space efficiently. Bigger the row size then...

I am excited by the cool new features that SQL Server 2008 is binging up ! SQL Server 2008 is bringing some commendable new features one of the nice feature is HierarchyID . This a new data type that is available in the in the latest July CTP of the SQL...

Hi ! are you interested to know more about the HierarchyID then grab a bag of chips for yourself and read on. If you haven't read about the HierarchyID then it is recommended that go to my last post SQL Server 2008 - HierarchyID - Part I and read that...

I am finding SQL Server 2008 very exciting. Every day it's a new learning for me and my eyes glitter seeing the sweet surprises that SQL Server 2008 is bringing in for efficient data management. I like SQL Server because I realize that data is like the...

This article is related to the NUMA (Non Uniform Memory Access) feature available with SQL Server. NUMA is a very useful feature to scale up the Server. Even before we discuss how SQL Server 2005 supports NUMA we have a few questions that needs to be...

Hi... here is one more article on SQL Server 2008 Enhancements. In past we should have found it a bit difficult to pass numerous parameters to the T-SQL Statements or Functions or Stored Procedures. The approach we used to take is creating a Temporary...

I am loving the enthusiasm that people have for SQL Server 2008. Everyday I come across many questions on SQL Server 2008, this shows that people are curious and I am pretty sure that people are regularly reading and learning SQL Server 2008 to know more...

NOTE: Declarative Management Framework has been renamed to Policy-Based Management so I just changed the Title of the article, the contents are unchanged. Hi, I am writing this post after somewhat long time … I hope you all are continuing with your...

Discover SQL Server 2008 through a variety of solution and technology-focused white papers.   General SQL Server 2008 Product Overview Microsoft SQL Server provides a policy-based system for managing one or more instances of SQL Server along with...

Hello everyone .. It's been a long time since I haven't blogged. So today being a weekend again I have some time for jotting down this blog. Writing gives me a great pleasure and since last few months I didn't get this pleasure to get in touch with you...

Hi ! It's been a long time since I last updated my blog. To continue with the Change Data Capture feature of SQL Server 2008, this is new post that helps you to know how you can write your own stored procedures / functions to get the required data in...

Hi Friends, I am back again with one more blog post on SQL Server 2008 Auditing. As we all know that SQL Server 2008 is coming up with *Cool* enhancements that will help the End Users, DBAs, Developers in improving their productivity. Today I am going...

Hi Friends, I am back with one more blog post on an interesting feature in SQL Server 2008. Today I was discussing about run away situations with my colleagues and I found that only few people read about this excellent feature available in SQL Server...

Hi Friends, I was a bit caught up during these days so I could not update my blogs since a long time. Today again it is a weekend and I have some time so I am writing the article on Resource Governor Part II which is overdue since a long time. In my...

People often ask me how to deploy SQL Server 2008 Express with applications as a prerequisite with Visual Studio 2008. Most often this situation is encountered when people want to deploy applications using the ClickOnce or they want to build a MSI package...

I am glad to see people realizing the value of SQL Server 2008 platform and they are happily migrating to the SQL Server 2008 platform. Thank you very much for visiting this article. In case if you are not on the MSDN blogs then I would request...

I attended the Microsoft Tech-Ed event @ Hyderabad (India) on 13,14,15th of May 2009 i.e. the last week. There were a lot of exiting sessions for Developers, Architects and IT Pros. The podium was setup in a large hall with all vibrant colors.  ...

Recently, I attended the Tech-Ed 2009 at Hyderabad (India). In the Application Lifecycle Management track the Visual Studio Team Test team showcased the new features of Visual Studio 2010 Team Test features. Usually, I write my blogs with screenshots...

We create ASP.Net applications which is hosted at a Central Location say Seattle (USA) but the customers using the application are located all around the world and when they enter the transaction they want their local time to be considered but when we...