Welcome to MSDN Blogs Sign in | Join | Help

January 2008 - Posts

Monday, January 28, 2008 4:08 PM

How It Works: SQL Server Backup Buffer Exchange (a VDI Focus)

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
Posted by psssql | 0 Comments
Filed under: ,
Thursday, January 24, 2008 6:38 PM

How It Works: SQL Server 2005 NUMA Basics

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.
Posted by psssql | 1 Comments
Filed under: , , ,
Thursday, January 24, 2008 3:30 PM

How It Works: Conversion of a Varchar, RPC Parameter to Text from a Trace (.TRC) Capture

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 data
Posted by psssql | 1 Comments
Wednesday, January 23, 2008 3:28 PM

How It Works: What is Restore/Backup Doing?

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
Posted by psssql | 2 Comments
Tuesday, January 15, 2008 7:35 PM

How It Works: File Stream the Before and After Image of a File

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 and
Posted by psssql | 1 Comments
Monday, January 14, 2008 7:19 PM

SQLIOSim - Error Request Could Not Be Performed - Unable to get disk cache info

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
Posted by psssql | 1 Comments
Filed under: , ,
Friday, January 11, 2008 9:52 PM

RML Utilities Install Fails with MSI (Windows Installer) Error #2755

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*.msi
Posted by psssql | 0 Comments
Filed under: ,
Thursday, January 10, 2008 2:58 PM

How It Works: SQL Server Engine Error Messages

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
Posted by psssql | 1 Comments
Filed under: ,
Thursday, January 10, 2008 2:57 PM

How It Works: System Sessions

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
Posted by psssql | 1 Comments
Filed under: ,
Thursday, January 10, 2008 8:59 AM

SQL Server 2008 - Resource Governor Questions

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
Posted by psssql | 1 Comments
Filed under: , ,
 
Page view tracker