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 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 »
Have a MS SQL Database that you need to change the owner back to DBO or another user?
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 »