(Brian Moran) I’ve been giving a lot of thought to the business and process side of SQL Server performance tuning over the past few months as I launch a new business. I’ve come up with an interesting observation that I’d like to share with you. I need to lump performance tuning scenarios into two di

(Pinal Dave) Lately I received an interesting question about the abilities of SafePeak for SQL Server acceleration software:

(Greg Larsen) When you are inserting, updating, or deleting records from a table, SQL Server keeps track of the records that are changed in two different pseudo tables: INSERTED, and DELETED.

(Thomas Larock) I know three areas of SQL 2012 that have bright future, and learning these three will serve you well for years to come. I am at the MVP Summit this week and I am soaking up as much information about these three items as I possibly can.

(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.

(Dinesh Asanka) In replication, the standard way of creating a publisher is to create a publication with a snapshot (which is what all the documentation recommends).

(Nakul Vachhrajani) Recently, I was working with a developer colleague of mine to troubleshoot an issue he had with one of his queries. A stored procedure he wrote was consuming data from another procedure and was not functioning as expected. I suspected the issue to be a missing change in the relat

(Daniel Miller) This article describes the steps to re-configure SQL Server so that queries return accent-insensitive results. It includes source code (using Microsoft SQL Server 2008 R2 Shared Management Objects) to automate some of the steps in this procedure.

(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.

(Jean Paul) SharePoint is a web application platform created by Microsoft. It is considered to be one of the most productive frameworks created by Microsoft in the last decade. SharePoint provides us the following feature support.