[chai-t] Re: February meeting plans

  • From: "Rose William" <William.Rose@xxxxxxxxxxxx>
  • To: <chai-t@xxxxxxxxxxxxx>
  • Date: Thu, 14 Feb 2013 15:44:55 +1100

Hi Alex,
 
I got a strange notification from the mailing list because the Peter Mac
email filter ate your response, so I've had to copy your email in here
rather than replying directly, sorry.
 
> Maybe could you address the alternatives to components other
> than just the database engine (eg Reporting Services,
> Integration Services, Analysis Services, MDM, DQS).
 
This is also a good topic: there are a few open source projects that I
have looked at in more-or-less detail at different times. The ones that
provide the most coverage are Pentaho and Jaspersoft, with Talend doing
a lot of the data work too (eg. SSIS, MDM, DQS) but not so much of the
reporting.
 
Considering the broader platform is important in that there is not a lot
of licence benefit in moving the database engine on its own if you still
need SQL Server licences for SSRS, SSAS, SSIS and Sharepoint. However,
from the perspective of gradually acclimatising your IT department to
open source software, though, picking off something like the database
engine might be best.
 
A topic for March?
 
Kind regards,
 
William Rose
Business Intelligence Manager
Information Management
 
+61 3 9656 5231   |   Level 8, St Andrews Place, East Melbourne VIC 3002

  <http://www.hisa.org.au/page/bigdata2013> 
 

________________________________

From: chai-t-bounce@xxxxxxxxxxxxx [mailto:chai-t-bounce@xxxxxxxxxxxxx]
On Behalf Of Rose William
Sent: Thursday, 14 February 2013 1:42 PM
To: chai-t@xxxxxxxxxxxxx
Subject: [chai-t] Re: February meeting plans


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

  <http://www.hisa.org.au/page/bigdata2013> 
 

________________________________

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
<http://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

 

  <http://www.hisa.org.au/page/bigdata2013> 

 

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. 

 <http://webmail.austin.org.au/2012-Health-Award-signature.gif> 

*****************************************************************

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 (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.

GIF image

GIF image

JPEG image

Other related posts: