Did you Experience the NEW SQL Server 2008 R2 [Kilimanjaro]

Kilimanjaro is now SQL Server 2008 R2. This is the next version of SQL Server 2008 that will give your organization a power steering to drive the Business Intelligence efforts much faster & focused in your organization. Why I say that it is the next version of SQL Server 2008 instead of “SQL Server” is…

0

Performance Boost for SQL Queries – Filtered Index in SQL Server 2008

SQL Server 2008 introduces an enhancement to the way the indexes are created which helps to get better performance from the same queries. This new little guy is known as ‘Filtered Index’. This is actually an Optimized Non-Clustered index which is well suited to cover the subset of data with in a table. Every organization…

0

How to get the current time of any TimeZone in SQL Server 2008

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 call the function GetDate() the SQL Server will take the server time…

0

Love @ First sight, The Visual Studio Team Test 2010

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 and samples but this time I could not resist myself from telling my first hand experience…

0

Microsoft Tech-Ed @ Hyderabad [INDIA] – May 2009

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.   The Rock Band – Agnee http://www.agneelive.com started the session with Rock…

0

Easy Table Partitions with SQL Server 2008

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 you to please visit my blog at http://blogs.msdn.com/manisblog…

0