Month: October 2006

Response to an article about Microsoft Forefront

 http://articles.techrepublic.com.com/5100-1009_11-6127915.html

I still don’t get what it is …

Client software that you can install on a central machine and then distribute as your organisation grows – that makes no sense? A set of filters you put on your incoming streams that looks for malware? A (mere) virus scanner? What is it? All of the above plus whatever? An LDAP server? Does it actually do authorisation and have a bunch of other stuff to keep viruses and so on at bay, hence confusing authorisation with protection? Or is it just a load of acronyms hiding a hodge-podge of things under the Microsoft banner so you can buy them all together in one package?

I also did’t like the word “integrated” there – that’s one of the huge problems with Windows as it is, compromise one thing, you’ve compromised everything – all part of the fundamentally flawed architecture in the first place. Everything uses the IE DLL’s – compromise them and everything is compromised. It’s not like modular software and interfaces are a new idea, but what do I know?

Migrating Access to SQL Server tool

http://www.regdeveloper.co.uk/2006/10/13/access_migration/

I was demoing Oracle’s migration product that does exactly the same thing (without the dumb bits) the best part of 10 years ago. The access app quite happily now talking to an Oracle back end.

I never realised that Microsoft did’t do this themselves!

Probably easier to migrate to Oracle and back again. At least it can sort out the types properly.

If memory serves Oracle’s tool is also free.

How to find out what schema a PL/SQL package is running from

  —————————————————————————————————————
  — This private function will return who owns the package
  — used for any call backs to prevent the use of synoynms picking up the
  — wrong guy…
  — Needs to get it from dual to get what permissions we are running with
  – not who we are running it as – confused? You will be …
  –

  —————————————————————————————————————
  function get_callback_schema( p_object_name in varchar2 default null ) return varchar2
  is
  q varchar2(200);
  begin
    select sys_context( ‘userenv’, ‘current_schema’) || ‘.’ || p_object_name
    into q from dual ;
    return q ;
  end get_callback_schema ;