(Erin Stellato) A couple weeks ago I was asked to look at system performance for a customer, and as part of my investigation I found a high read query. I had run a trace and filtered for anything over 10,000 reads and saw a query that required around 32,000 reads, and it was running at least once a

(Robert Sheldon) If you’ve decided to use SQL Azure to host your databases, you might need to migrate some of your SQL Server on-premises databases to the new environment. Doing a successful SQL Azure migration means picking the right tool, loading data into SQL Azure properly, and assessing your mi

(Pinal Dave) “I do not know where my windows went!” “I just closed my object explorer and now I cannot find it.”

(Feodor Georgiev) My previous article on SSIS was focused on the architecture and the functioning of the product. I had also provided a few essential T-SQL scripts which provide certain ways for documenting the SSIS environment.

(Guillaume Fourrat) We’re going to take a close look at how SSAS and SQL Server implement execution timeout and user cancellation, and we’ll discover a few noticeable differences.

A junior team member ran into this issue so thought it was worth a post. While installing SQL Server 2012 RC0 on a new VM of Windows Server 2008 R2, it complained about installing or enabling .Net Framework 3.5 SP1 which is a pre-requisite for the SQL Server install. Here are the steps to validate

(Atif Shehzad) Due to a recent rebuild of the master database for a SQL Server instance, I now need to restore the msdb and model databases. In this tip we walk through the process that you need to follow to restore the model and msdb databases successfully.

(Pinal Dave) On the subject of guest account I have written few article earlier. Here are the quick list of the same.

(Scott Shaw) We have discussed different aspects of virtualization in these previous tips tip 1, tip 2, tip 3, tip 4. In this tip we look at additional reading and resources you can use to make the most of your virtualized SQL Server enviornment.

(Robert Sheldon) SQL Server 2012, known for more than a year as Microsoft Denali, its towering code name, is on its way. Whether you plan to upgrade an existing SQL Server instance to 2012 or implement a new instance, you should know what to expect in terms of prerequisite software, changes to the e