Where is SAC tool? Surface Area Configuration (SAC) tool will be removed in SQL 2008 release. This tool exposed two major functionalities. Surface Area Configuration for Services and Connections Surface Area Configuration for Features A...

In contrast to earlier versions of the Maintenance Cleanup task, the SQL Server 2005 version of the task does not automatically delete files in the subdirectories of the specified directory. To delete the files under first-level subfolders, you must explicitly...

This has been a very common question I have seen in several forums, related to using database mailprofile for SQL Agent jobs, and I thought will post here. If you run into this issue, it could be due to one of the following and I have also have mentioned...

My team keeps emphasizing the importance of community participation and value all the feedback posted in the groups, forums and all possible channels to communicate with you all, the customers; and loop the feedback provided to improve the quality of...

With SQL 2005 released and customers upgrading from SQL2000, it was great to see Newsgroups/Blogs/Forums filled with appreciation feedback on the improvements made in tools. There were concern mails on few areas in the tools domain that lacked some funtionality...

I am Gops Dwarak, member of SQL Server Tools team. "Blog....I should create one', this thought has been for a while and here it is finally. Nearing 5 years of completion with Microsoft what more to say, it has been great pleasure to work for THE...