SQL SERVER – Top 10 SQL Server 2008 Features for Independent Software Vendor Applications

Microsoft SQL Server 2008 has hundreds of new and improved features, many of which are specifically designed for large scale independent software vendor (ISV) applications, which need to leverage the power of the underlying database while keeping their code database agnostic. This article presents details of the top 10 features that we believe are most applicable to such applications based on our work with strategic ISV partners. Along with the description of each feature, the main pain-points the feature helps resolve and some of the important limitations that need to be considered are also presented.

Read More

SQL SERVER – Find Table Row Count Without Using T-SQL and Without Opening Table

Recently I have been busy with interviewing many candidates for my organization. We are looking for some smart and experienced developers for some senior positions. I have wrote this previously SQL SERVER – Interesting Interview Questions. This blog post is about finding a table row count without using T-SQL.

Read More

SQL SERVER – 2008 – Install SQL Server 2008 – How to Upgrade to SQL Server 2008 – Installation Tutorial

SQL SERVER 2008 RTM has been released for some time and I have got numerous request about how to install SQL Server 2008. I have created this step by step guide Installation Guide. Images are used to explain the process easier. I had previously written the same article earlier. It seemed necessary to re post it again as request of me posting Step by Step tutorial has increased for quite some time.

Read More