CSS SQL Server Engineers

The Senior Escalation Engineers do various training and mentoring activities. As I do this I thought I would try to propagate some of this information on the blog. The virtual device interface (VDI) backups allow 3rd party back-up solutions to integrate...

The Senior Escalation Engineers do various training and mentoring activities.  As I do this I thought I would try to propagate some of this information on the blog. I have received several questions on the SQL Server NUMA implementation this week...

The Senior Escalation Engineers do various training and mentoring activities. As I do this I thought I would try to propagate some of this information on the blog. This was an interesting issue I ran into this week. The reported problem was that the...

The Senior Escalation Engineers do various training and mentoring activities.  As I do this I thought I would try to propagate some of this information on the blog. A customer asked: "Why does it take me 7 hours to backup my database but 21...

The Senior Escalation Engineers do various training and mentoring activities. As I do this I thought I would try to propagate some of this information on the blog. The question that spawned this entry was: "I am performing updates of a specific row...

Both SQLIOSim and SQLIOStress use DeviceIOControl to determine information about the target.   On disk caches are typically not battery backed and when enabled can lead to data loss during a power outage. The utilities attempt to warn the user...

It is possible to encounter error 2755 when installing the RML Utilities package.   The most common cause is an encrypted file.  This is generally from storing the download in an encrypted folder. Reproduction Steps Store the RMLSetup*...

The Senior Escalation Engineers do various training and mentoring activities. As I do this I thought I would try to propagate some of this information on the blog. The majority of SQL Server errors are handled by a central routine named ex_raise ....

The Senior Escalation Engineers do various training and mentoring activities. As I do this I thought I would try to propagate some of this information on the blog. Looking at a SQL Server error log it is formatted with the date , time and session identifier...

A couple of common questions have surfaced related to the SQL Server 2008 Resource Governor feature. The SQL Server 2008 BOL has a lot of good information so start don't forget to review that as well. Metadata and Runtime Data A set of DMVs exist for...