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?”
SQL SERVER – Email from Blog Reader – Not a Potential Bug in SQL – Puzzle
Few days ago, I received wonderful email from blog reader and it was like good puzzle. I enjoyed solving this puzzle. I did not write the name of the blog reader because I am not sure if he wants his name here or not. Please read this article and run…
Read MoreSQLAuthority 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 – 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 MoreSQLAuthority News – Download Microsoft SQL Server Management Pack for Operations Manager 2007
Note: Download Microsoft SQL Server Management Pack for Operations Manager 2007 by Microsoft The SQL Server Management Pack provides the capabilities for Operations Manager 2007 to discover SQL Server 2000, 2005 and 2008 installations and components and to monitor them, primarily from the perspective of availability and performance. The…
Read More