Hi William, Maybe could you address the alternatives to components other than just the database engine (eg Reporting Services, Integration Services, Analysis Services, MDM, DQS). Thanks, Alex Alex Thomas | Principal Report Developer Report Development Team | Software Development Unit | Information Management & Technology Department of Human Services | Level 10, Casselden Place, 2 Lonsdale Street, Melbourne, 3000 Department of Human Services | GPO Box 4057, Melbourne, 3001 p. (03) 9096 0687 | f. (03) 9096 9107 | m. 0417 490 594 | e. alex.thomas@xxxxxxxxxxxxxx (Embedded image moved to file: pic03023.jpg) |------------> | From: | |------------> >-----------------------------------------------------------------------------------------------------------------------------------------| |"Rose William" <William.Rose@xxxxxxxxxxxx> | >-----------------------------------------------------------------------------------------------------------------------------------------| |------------> | To: | |------------> >-----------------------------------------------------------------------------------------------------------------------------------------| |<chai-t@xxxxxxxxxxxxx> | >-----------------------------------------------------------------------------------------------------------------------------------------| |------------> | Date: | |------------> >-----------------------------------------------------------------------------------------------------------------------------------------| |14/02/2013 01:47 PM | >-----------------------------------------------------------------------------------------------------------------------------------------| |------------> | Subject: | |------------> >-----------------------------------------------------------------------------------------------------------------------------------------| |[chai-t] Re: February meeting plans | >-----------------------------------------------------------------------------------------------------------------------------------------| |------------> | Sent by: | |------------> >-----------------------------------------------------------------------------------------------------------------------------------------| |chai-t-bounce@xxxxxxxxxxxxx | >-----------------------------------------------------------------------------------------------------------------------------------------| Hi Peter, I think this would be a good topic for a future meeting! I have not really come across people buying MySQL or PostgreSQL enterprise support, mostly because it seems to be people using them for non-critical systems or otherwise as part of an application where the application team manages the DBA work associated with the database. For instance, Business Objects comes bundled with MySQL and it can be used as the report and job repository, and they would support it if we ran into problems (I think). I set up a PostgreSQL server on Linux last year for an application for one of our research teams and developed some scripts to do automated backups, etc. I've done similar things for MySQL on Linux, but less on Windows. To me, there is no great advantage to the "enterprise support" aspect of software licensing for SQL Server / Windows Server: you still end up needing your own IT support people to be DBAs and system administrators, so why not teach them MySQL and PostgreSQL and Linux and pay nothing in licensing? Presumably there's a workforce aspect to consider and perhaps a familiarity aspect, but most of these environments include some kind of GUI development environment now anyway. I am happy to coordinate a session showing off some of the management tools and comparing and contrasting MySQL, PostgreSQL and SQL Server from a developer perspective. Given how closely most of us end up managing our own infrastructure, it probably doesn't matter whether that aligns to an enterprise standard as much. Kind regards, William Rose Business Intelligence Manager Information Management +61 3 9656 5231 | Level 8, St Andrews Place, East Melbourne VIC 3002 (Embedded image moved to file: pic24901.gif) From: chai-t-bounce@xxxxxxxxxxxxx [mailto:chai-t-bounce@xxxxxxxxxxxxx] On Behalf Of DAVEY, Peter Sent: Thursday, 14 February 2013 10:34 AM To: chai-t@xxxxxxxxxxxxx Subject: [chai-t] Re: February meeting plans William, An idea perhaps for a discussion at a future meeting. Last week our IT people were telling us about the changes to MS licencing and SS 2012 in particular and it wasn’t pretty. It led me to wonder about the feasibility of using MySQL or PostgreSQL in organisations like ours and how they could work in a BI environment. The Enterprise version of MySQL costs money but I haven’t been able to find out much about the licencing details and PostgreSQL appears to be free. Does anybody know much about this area? Cheers Peter Davey | Manager Clinical Information Analysis & Reporting | Austin Health PO Box 5555 Heidelberg Vic 3084 ph. +61 3 9496 5517 | fax. +61 3 9496 5856 email. peter.davey@xxxxxxxxxxxxx | www.austin.org.au From: chai-t-bounce@xxxxxxxxxxxxx [mailto:chai-t-bounce@xxxxxxxxxxxxx] On Behalf Of Rose William Sent: Wednesday, 13 February 2013 08:55 To: chai-t@xxxxxxxxxxxxx Subject: [chai-t] February meeting plans Hi all, I think most of you have been forwarded the invitation from Stefan Romiti at Microsoft to the event they are hosting on Thursday 21/02/2013 from 2:30 to 5pm, at their Southbank office. The topic is Tabular & PowerPivot - Analysis Services. We will not be meeting otherwise this month (e.g. not this Friday), so I hope to see you there next week! Kind regards, William Rose Business Intelligence Manager Information Management +61 3 9656 5231 | Level 8, St Andrews Place, East Melbourne VIC 3002 (Embedded image moved to file: pic11938.jpg) This email (including any attachments or links) may contain confidential and/or legally privileged information and is intended only to be read or used by the addressee. If you are not the intended addressee, any use, distribution, disclosure or copying of this email is strictly prohibited. Confidentiality and legal privilege attached to this email (including any attachments) are not waived or lost by reason of its mistaken delivery to you. If you have received this email in error, please delete it and notify us immediately by telephone or email. Peter MacCallum Cancer Centre provides no guarantee that this transmission is free of virus or that it has not been intercepted or altered and will not be liable for any delay in its receipt. ***************************************************************** This email contains confidential information intended only for the person named above and may be subject to legal privilege and confidentiality obligations imposed by legislation or be subject to intellectual property protection or copyright. If you are not the intended recipient, any use, disclosure, copying or distribution of this transmission is prohibited. If you have received this message in error, please notify us immediately by return email and delete the original email and any attachments. Austin Health provides no guarantee that this transmission is free of virus or that it has not been intercepted or altered. ***************************************************************** This email (including any attachments or links) may contain confidential and/or legally privileged information and is intended only to be read or used by the addressee. If you are not the intended addressee, any use, distribution, disclosure or copying of this email is strictly prohibited. Confidentiality and legal privilege attached to this email (including any attachments) are not waived or lost by reason of its mistaken delivery to you. If you have received this email in error, please delete it and notify us immediately by telephone or email. Peter MacCallum Cancer Centre provides no guarantee that this transmission is free of virus or that it has not been intercepted or altered and will not be liable for any delay in its receipt. _________________________________________________________________________________ This email contains confidential information intended only for the person named above and may be subject to legal privilege. If you are not the intended recipient, any disclosure, copying or use of this information is prohibited. The Department provides no guarantee that this communication is free of virus or that it has not been intercepted or interfered with. If you have received this email in error or have any other concerns regarding its transmission, please notify Postmaster@xxxxxxxxxxxxxx _________________________________________________________________________________
Attachment:
pic03023.jpg
Description: JPEG image
Attachment:
pic24901.gif
Description: GIF image
Attachment:
pic11938.jpg
Description: JPEG image