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.
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.
SQL SERVER – Interview Questions – Difficult SQL Puzzle
Today at my organization, we had nearly 30 interviews scheduled of DBA and .NET developers. Let us see a difficult SQL puzzle.
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.
SQL Server – Switch Between Result Pan and Query Pan – SQL Shortcut
Many times when I am writing query I have to scroll the result displayed in the result set. Let us learn about the shortcut today.
SQL SERVER – 2008 – Download and Install Sample Database AdventureWorks 2008
The following sample database is currently available for Microsoft SQL Server 2005 and Microsoft SQL Server 2008:
SQLAuthority News – Author Visit – South Asia MVP Open Day 2008 – Goa – Group Photo
MVP Open day 2008 is one of the best event happened so far. I have previously written about this event in detail on this blog.