Date: 01/03/08 (Data Management)    Keywords: database, microsoft

Oracle's database has a reputation for being hard to install. This video might persuade you otherwise. Over to you IBM and Microsoft. Can you do any better? Link courtesy of Justin Kestelyn at OTN by Dennis Howlett

Source: http://blogs.zdnet.com/Howlett/?p=274

Date: 01/04/08 (SQL Server)    Keywords: database, web

Okay, now that the compatibility-level problem has gone the way of the great auk (until someone at the client decides to reset it again, I guess), I can now get to my underlying problem-- PIVOT, which I can't seem to understand from the overly-simplistic exampes I've found on the web.

Here's a small, heavily-edited version of the current crosstab query:

--create the pivot
INSERT INTO @m_tblItemDataPivot (brand, upc, item_desc, category, class, subclass, week_ending, week_1_dol, 
week_2_dol, week_3_dol, week_4_dol, week_5_dol, week_6_dol, week_7_dol, week_8_dol, ... 
SELECT DISTINCT i.brand, i.upc, u.item_desc, i.category, i.class, i.subclass, i.week_ending,
SUM(CASE p.period_sysno WHEN @m_intThisWeekSysno - 51 THEN phg.total_dollars ELSE 0 END) AS week_1_dol,
SUM(CASE p.period_sysno WHEN @m_intThisWeekSysno - 50 THEN phg.total_dollars ELSE 0 END) AS week_2_dol,
SUM(CASE p.period_sysno WHEN @m_intThisWeekSysno - 49 THEN phg.total_dollars ELSE 0 END) AS week_3_dol,
SUM(CASE p.period_sysno WHEN @m_intThisWeekSysno - 48 THEN phg.total_dollars ELSE 0 END) AS week_4_dol,
SUM(CASE p.period_sysno WHEN @m_intThisWeekSysno - 47 THEN phg.total_dollars ELSE 0 END) AS week_5_dol,
SUM(CASE p.period_sysno WHEN @m_intThisWeekSysno - 46 THEN phg.total_dollars ELSE 0 END) AS week_6_dol,
SUM(CASE p.period_sysno WHEN @m_intThisWeekSysno - 45 THEN phg.total_dollars ELSE 0 END) AS week_7_dol,
SUM(CASE p.period_sysno WHEN @m_intThisWeekSysno - 44 THEN phg.total_dollars ELSE 0 END) AS week_8_dol,...
FROM   ia_rep.dbo.pos_history phg (NOLOCK)			
INNER JOIN @m_tblSchickUPC u  ON phg.upc_sysno = u.upc_sysno
INNER JOIN @m_tblItemData i ON u.upc_code = i.upc
INNER JOIN ia_rep.dbo.periods p (NOLOCK) ON phg.period_sysno = p.period_sysno
    AND p.period_sysno BETWEEN @m_intThisWeekSysno-52 AND @m_intThisWeekSysno
	GROUP BY i.brand, i.upc, u.item_desc, i.category, i.class, 
            i.subclass, i.week_ending

Source: http://community.livejournal.com/sqlserver/65797.html

Date: 01/07/08 (Web Development)    Keywords: html, xml, database

I'm trying to create a user-friendly searchable image catalog. Think gettyimages.com, only not as pretty or robust. This is a B2B product only. My company has thousands of images, and we need to get them to creative agencies in the form of searchable galleries and contact sheets.

I'm using Mediapro to catalog and tag images. It makes nice, neat catalogs I can tag, export as contact sheets, etc. It also exports a *Very* simple HTML gallery. An index page, thumbnails, etc. it is not searchable and no meta data is attached to any of the images.

Mediapro also creates .xml files, which DOES have the meta data.

So I have an HTML gallery, an .xml file....how easy/hard would it be to tie these together into a searchable database, ala Getty? It is possible?

TIA

Source: http://community.livejournal.com/webdev/457145.html

Date: 01/08/08 (WebDesign)    Keywords: php, css, html, database, java, web, hosting

First of all, an apology. I'm sorry - I know that this has been asked a million times before, but things change very quickly in cyberspace and I have a rather desperate situation on my hands.

I've been placing clients with an absolutely awesome webhost/domain registrar for 10 years, a one-man operation with unparalleled customer service. He's now closing shop, and coincidentally, I'm also getting out of the webdesign business.

I have about a dozen clients that I need to transfer, with everything from 4 page to 100+ page websites. Some need to host multiple domains, others need space/bandwidth to support a lot of .mp3 and .pdf downloads, some need domain email, etc - all different situations. I've only got a few months to place these people and get them uploaded to a new site, on top of a new workload in another field.

I've been investigating hosting for over a month now, but am still undecided. Also, my clients are people with small budgets (non-mainstream authors, musicians, educational groups, etc) so while they can certainly pay their year of hosting upfront, as well as my time for moving them, moving to a webhost with an enormous set-up fee is simply out of the question.

None of my clients need php or database support or anything fancy; even the most complex site is done in basic CSS/HTML with some javascript. I'm about to get serious about GoDaddy.com - but I can't afford to make a mistake. Has anyone had any bad experiences with them? Can anyone recommend anyplace else? Any and all suggestions gratefully accepted. Thank you for your time!

EDITED TO ADD:
Thank you!! I can't believe the responses I'm getting, and I really appreciate it more than I can say. I have mixed feelings about getting out of webdesign, which is not making this any easier. It really helps to have some clear, concise input. I've always admired the people in this community, and I still do. There is a tremendous amount of talent here, and I've learned so much, even though I was mostly a lurker with little to contribute.

Thank you again. ♥ ♥ ♥

Source: http://community.livejournal.com/webdesign/1350617.html

Date: 01/10/08 (Data Management)    Keywords: database, security, linux

A security researcher has found a remote command execution exploit in SAP's MaxDB database on the Windows, Linux and Solaris platforms. Researcher Luigi Auriemma published the flaw in MaxDB versions 7.6.03 build 007 and below. MaxDB (all ZDNet resources and SAP wiki) is an SAP-certified open source...

Source: http://blogs.zdnet.com/security/?p=795

Date: 01/10/08 (Security)    Keywords: database, security, linux

A security researcher has found a remote command execution exploit in SAP's MaxDB database on the Windows, Linux and Solaris platforms. Researcher Luigi Auriemma published the flaw in MaxDB versions 7.6.03 build 007 and below. MaxDB (all ZDNet resources and SAP wiki) is an SAP-certified open source...

Source: http://blogs.zdnet.com/security/?p=795

Date: 01/10/08 (Data Management)    Keywords: software, database, security

Oracle said Thursday that its latest batch of patches will fix 27 security fixes "across hundreds of Oracle products," including eight for the company's database, seven for its e-business suite and six for its application server. In its advisory, Oracle outlines a laundry list of software affected....

Source: http://blogs.zdnet.com/security/?p=798

Date: 01/10/08 (MySQL Communtiy)    Keywords: mysql, database, sql

What kind of Collation setting should I use for my Comments section in my MySQL database?

It defaulted to:  latin1_swedish_ci

is this right?

Signed:  Frustrated

-------------
Update
------------

It IS right...and indeed I am a lummox!

-------------
/Update
------------

Source: http://community.livejournal.com/mysql/122656.html

Date: 01/11/08 (Data Management)    Keywords: mysql, database, sql

Virgin Mobile's decision to base its SMS database on mySQL is an important milestone for the GPL database. This was not Virgin's first entry into open source. Virgin Mobile also runs Red Hat. Virgin Mobile is a scaled enterprise. Even though SMS messages are...

Source: http://blogs.zdnet.com/open-source/?p=1878

Date: 01/15/08 (Data Management)    Keywords: database, security

Oracle as expected released its quarterly batch of security fixes Tuesday. In a blog post, Oracle said: Oracle today released the January 2008 Critical Patch Update (CPUJan2008).  This Critical Patch Update (CPU) addresses a total of 26 vulnerabilities affecting Oracle Database Server, Oracle Application Server, Oracle...

Source: http://blogs.zdnet.com/security/?p=813

Date: 01/16/08 (Data Management)    Keywords: database

The agency's proposed "server in the sky" database would share biometric data on the world's most-wanted criminals. Police in the U.K. are in talks with the FBI about establishing an international biometric database for tracking down the world's most wanted criminals and terrorists. The so-called "server in...

Source: http://news.zdnet.com/2100-1009_22-6226396.html

Date: 01/16/08 (Data Management)    Keywords: mysql, database, sql

Updated: Sun Microsystems is taking the plunge into the database market with the purchase of open source database developer MySQL for $1 billion ($800 million in cash in exchange for all MySQL stock and assumption of approximately $200 million in options). With the move, announced Wednesday, Sun...

Source: http://blogs.zdnet.com/BTL/?p=7611

Date: 01/16/08 (Data Management)    Keywords: mysql, software, database, sql

Sun announced Wednesday that it is buying MySQL for about $1 billion -- $800 million in cash and $200 million in options. The news comes on the same day that mega proprietary database software giant Oracle announced its intent to buy middleware giant BEA. The deal,...

Source: http://blogs.zdnet.com/open-source/?p=1889

Date: 01/16/08 (Open Source)    Keywords: mysql, software, database, sql

Sun announced Wednesday that it is buying MySQL for about $1 billion — $800 million in cash and $200 million in options. The news comes on the same day that mega proprietary database software giant Oracle announced its intent to buy middleware giant BEA. The deal, which awaits regulatory approval, should allay any talk that [...]

Source: http://feeds.feedburner.com/~r/zdnet/open-source/~3/217643715/

Date: 01/16/08 (Security)    Keywords: database

The agency's proposed "server in the sky" database would share biometric data on the world's most-wanted criminals. Police in the U.K. are in talks with the FBI about establishing an international biometric database for tracking down the world's most wanted criminals and terrorists. The so-called "server in...

Source: http://news.zdnet.com/2100-1009_22-6226396.html

Date: 01/17/08 (Open Source)    Keywords: mysql, database, sql

It's obvious that, if you're running a proprietary database system it's probably going to say Oracle on it sooner-or-later. But is the way to open source now closed with Sun taking over mySQL?

Source: http://feeds.feedburner.com/~r/zdnet/open-source/~3/218367336/

Date: 01/17/08 (Data Management)    Keywords: mysql, database, sql

Two things seem self-evident concerning this week's news about Oracle buying BEA and Sun acquiring mySQL: This is an important turning point for enterprise open source, and the database business generally. Everyone has an opinion on it, but no one really knows anything. I...

Source: http://blogs.zdnet.com/open-source/?p=1899

Date: 01/18/08 (Opera Browser)    Keywords: browser, database, web, yahoo

Ever since I first installed Opera I've used it as my default e-mail client as well as my default browser, but recently I had to switch ISPs to (ick) AT&T Yahoo, and their e-mail service requires e-mail clients to be SSL compliant, while Opera uses TLS instead (oh, the curse of being ahead of the curve!) Ideally, there'd be a way I could continue to use Opera as my e-mail client, but while I've heard that TLS can transform itself into SSL3 if necessary, I'm utterly non-geek and would have no idea how to make it do this.

I could use SSL-compliant Mozilla Thunderbird, but, while it's not the abomination Outlook Express is, I've tried it before and found it a bit clunky, and annoying to configure, so I would only use it as a last resort.

Another alternative I've found would be to try an e-mail client called Courier which, while not SSL compliant itself, can be configured to work with an open source program called Stunnel which, as I understand it (meaning very, very dimly), would punk Yahoo's POP and SMTP servers and make them think I was using an SSL compliant e-mail client. I do like the description Courier gives of itself, but I've not yet tried it so I don't know if I'd really find it usable.

Why, you may be asking, would I not simply use Stunnel with Opera directly instead of going through Courier? Well, I would, but I can't find anything on Opera's website (or on Stunnel's website) saying that Opera is compatible with Stunnel... but there's a nice little section of the Opera database that tells how to configure Opera to work with Courier, and a nice (though not so little) section on Courier's website that tells how to configure Courier for use with Stunnel. In other words, if I run as fast as I can I might be able to stay somewhere in the vicinity of the same place.

Anyway, what I'd like to know is:

1) Has anybody ever used Stunnel (or maybe something like it) with Opera and, if so, did disaster ensue?
2) Has anybody ever used Courier, with or without Opera and, if so, is Courier as good as it looks from its self-description?
3) Has anybody got a suggestion for any other alternatives, so I don't end up having to use Thudderbird?

Source: http://community.livejournal.com/opera_browser/68431.html

Date: 01/18/08 (Open Source)    Keywords: mysql, database, sql, postgresql

In all the media excitement over the week's two database deals, Oracle buying BEA Systems and Sun buying mySQL there's a name we're forgetting. It's PostgreSQL.

Source: http://feeds.feedburner.com/~r/zdnet/open-source/~3/218975502/

Date: 01/18/08 (Data Management)    Keywords: mysql, database, sql, postgresql, security, linux

In all the media excitement over the week's two database deals, Oracle buying BEA Systems and Sun buying mySQL there's a name we're forgetting. It's PostgreSQL. PostgreSQL keeps on keepin' on, getting bugs fixed, upgrading its security, and integrating those fixes with major Linux...

Source: http://blogs.zdnet.com/open-source/?p=1903