Community Techday | Surat | 28th November 2010

We are very pleased to announce Community Techday at Surat on 28th November 2010. We try to bring you the new products  SQL Server is very popular and widely used RDBMS system in the SME and large Enterprises segment around the world for storing and managing their business critical data. Numerous applications are developed today with n-tier technologies, but they can be never be without database behind it. Recently Microsoft has announced the new version of SQL Server - SQL Server 2008 R2. SharePoint 2010 is the business...

Read More

What is new in SQL Server - Denali

Dear Readers, I have a great news to share with you all!!  A much awaited future version of SQL Server is announced - "Denali". This version has some new salient features like: SQL Server AlwaysOn -  A new feature that will provide maximum uptime with simplify HA deployment, this feature will also supports new availability group option to improve availability of mission critical databases by supporting multiple secondary servers. Column-Based Query Accelerator -  Increase query performance by ~10x  IT Administration...

Read More

How to Upgrade SQL Server

Couple of days back I have wrote an article on common issues we face while upgrading, and two methods to follow while upgrading SQL Server, this article also gives you some basic steps we need to follow post upgrades.  Here is an excerpts of the article: Upgrading the SQL Server version can have a major impact the applications using the databses. For example, from SQL Server 2005 onwards you are required to use  col IS NULL instead of Col = NULL and so any applications using the later will break. Using ...

Read More