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 – 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
Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.
Once you learn my business secrets, you will fix the majority of problems in the future.
Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.
Essentially I share my business secrets to optimize SQL Server performance.