We have an XML schema .xsd file, and I know the structure of the XML file as well (obviously). However, I need to export data from SQL server and drop it into an XML file. The table structure would be ...

I'm trying to put together a DTS package to export data from SQL Server (2k) into a CSV file that I can in turn import into MySQL.<BR><BR>The problem I'm running into is SQL Server exports NULL values ...

If you don’t have a backup of your MS SQL database, then follow the below ways to recover deleted data. Transaction log files record each change made to the ...

My colleague, senior editor, Kathleen Richards was at MIX08 in Las Vegas two weeks ago. Suffice to say she received a brain dump on Silverlight and a number of other big announcements there. When she ...

When it comes to improving the performance of database systems, there are nearly as many approaches as there are DBA (database administrator) teams. That might sound acceptable at first glance. But, ...

Microsoft announced a roadmap shift, indicating that it will focus on supporting Open Database Connectivity for SQL Server application programming interfaces in the near future. The shift is of ...