I received the following email from Mike Bikinis. about enterprise manager. “How can I connect to SQL Server 2005 or SQL Server 2008 using SQL Server 2000’s Enterprise Manager?”
SQLAuthority News – Wedding Day of Author – 800th Article of Blog
Today is big day for me. I am getting married today. Wedding is just one hour away and I am writing this article. I will post more information tomorrow about this event of my life. While assigning categories to this article, I laughed when I selected “SQLAuthority Author Visit” tag.…
Read MoreSQL SERVER – Interesting Interview Questions – Part 2 – Puzzle – Solution
Yesterday we looked at Puzzle and I did got great response to this question. Very interestingly not many got it right. First go through the puzzle first and then come back here and read answer. Read Original Interview Question and Puzzle. Question: Select all the person from table PersonColor who…
Read MoreSQLAuthority News – SQL SERVER 2008 Upgrade Technical Reference Guide Download
Note: SQL SERVER 2008 Upgrade Technical Reference Guide Download by Microsoft This 490-page document covers the essential phases and steps to upgrade existing instances of SQL Server 2000 and 2005 to SQL Server 2008 by using best practices. These include preparation tasks, upgrade tasks, and post-upgrade tasks. It is intended…
Read MoreSQL 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.
SQL SERVER – Interesting Interview Questions – Part 2 – Puzzle
In the recent time of recession my company is able to continue its progress and we are hiring. It is very surprising to me that many developers who have experience with SQL Server could not get following simple question right. There were nearly 40 candidates I interviewed but none of…
Read More

