Archive for the ‘Databases’ Category

Export data from SQL Server as XML

Friday, August 31st, 2012

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

Friday, March 16th, 2012

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 soon 🙂

http://blogs.msdn.com/b/microsoft_press/archive/2012/03/15/free-ebook-introducing-microsoft-sql-server-2012.aspx

Changing the Owner of a MS SQL Database

Wednesday, November 5th, 2008

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

(more…)

Oracle OUI silent install/deinstalls

Friday, October 17th, 2008

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 should be able to just run the script (good best practice in my opinion). We also want scripted uninstalls, so that if it all goes wrong, we just run the backout script.

The Oracle Universal Installer is a java based application and when invoked in the right way, it can record what’s called a response file. It basically contains everything that you tick, configure and puts it into a text file. The Oracle documentation describe the process very easily…see this link

(By the way this is a Windows tutorial, I haven’t messed about with the unix side).

To summarise the docs, you download whatever Oracle software involved, in my case, ODAC for OLE 10g. Decompress it into a directory on a test server and run the setup with the following switches: (more…)