Category Archives: Databases

Export data from SQL Server as XML

Found this really useful snippet today on www.codeproject.com http://www.codeproject.com/Tips/239156/Export-data-from-SQL-Server-as-XML

SQL Server 2012 RTM has been released

SQL Server 2012 has now been released to manufacturing and is available to try here: http://www.microsoft.com/sqlserver/en/us/get-sql-server/try-it.aspx Microsoft have also kindly release a Microsoft Press Book on the new features here in PDF format (epub and mobi formats to follow next week). I’ll have a quick look and see if there’s anything I can show you… Read More »

Changing the Owner of a MS SQL Database

Have a MS SQL Database that you need to change the owner back to DBO or another user?

Oracle OUI silent install/deinstalls

I’ve been working on this all week and I finally made a breakthrough for this today. The task at hand was to automate the install of the Oracle Data Access Components for OLE DB for 10g. At my work we prefer to script everything so if anyone gets knocked down by a bus, someone else… Read More »