-
Notes on analyzing a user minidump with WinDbg
One of my students’ Sql Server 2000 SP4 crashed. I volunteered to see if I could get anything out of it by looking at the dump file with WinDbg. A few notes: 1. The processor or Windows version that the dump file was created on does not need to match the platform on which WinDbg […]
-
TCP Chimney issue on Windows 2003 Service Pack 2
If you are running Sql Server 2005 on Windows Server 2003 SP2, you may get this message from Sql Server native client connection: An existing connection was forcibly closed by the remote host This is most likely caused by a “feature” called TCP Chimney offloading. On the server, run: Netsh int ip set chimney DISABLED […]
-
Migrating from one RDBMS to another
Here is some of my thoughts on migrating MySQL to Sql Server. It came out of an email discussion. I’d love to hear your thoughts on migrating to a different database platform, not just MySQL to Sql Server. I actually thought about writing a white paper or even a course on migrating from MySQL to […]
-
Get the documents out of SharePoint database
I recently helped a client to get the WSS 3.0 documents out, as the client’s SharePoint is broken and we couldn’t get it fixed in short time, but they really want the Word, Excel, and pdf documents out of there. WSS 3.0, Windows SharePoint Services, uses Sql Server for data storage. The Sql Server version […]
-
BCP In automation script
A while ago I wrote an article on code generation using Sql. The script I gave in that article can generate BCP (in and out) scripts automatically. I helped out a friend recently, and thought I would share the WMI/VBScript I cooked up with you. This script assumes that all files within a folder need […]