http://www.sqlpower.ca/forum/forums/show/221.page JForum - http://www.jforum.net

[url=http://medicalbillingcodingtraining.com/]Medical Billing and Coding Jobs[/url]
]]> http://www.sqlpower.ca/forum/posts/preList/2742/6225.page http://www.sqlpower.ca/forum/posts/preList/2742/6225.page GMT We developed an application that uses sybase. Now we're subjecting them to performance testing, and our DBAs have noticed the apps doing inordinate amounts of this stored procedure call. whenevery our stored procedure call is happened thru code the below stored proc also calling along with my stored proc.
sp_jdbc_getschemas.
I am very sure this is totally sybase internal stored procedure. Can anyone give me an idea about how to avoid this stored procedure call for every time.


Thanks,
Prasad.]]> http://www.sqlpower.ca/forum/posts/preList/2736/6213.page http://www.sqlpower.ca/forum/posts/preList/2736/6213.page GMT
I was finally able to get the forum search index working again so that older posts can be searched. So you can use the search feature again to find old posts.]]> http://www.sqlpower.ca/forum/posts/preList/2305/4825.page http://www.sqlpower.ca/forum/posts/preList/2305/4825.page GMT http://www.sqlpower.ca/forum/posts/preList/2192/4427.page http://www.sqlpower.ca/forum/posts/preList/2192/4427.page GMT
Premium Production Support gives you direct access to SQL Power Software Developers for 1-on-1 help with production issues, feature requests, bug fixes and more.

• Help with any Architect/MatchMaker production issues
• Quick response
• 1st-priority feature requests & bug fixes
• Contact by email or phone

Power*Architect
Open Source Data Modeling & Data Profiling Tool
Full Production Support starting at $199/year
[url]http://www.sqlpower.ca/page/architect_support[/url]

Power*MatchMaker
Open Source Data Cleansing & De-duping Tool
Full Production Support starting at $399/year
[url]http://www.sqlpower.ca/page/matchmaker_support[/url]

Bullet-proof your SQL Power Toolset with
Premium Production Support today!
]]> http://www.sqlpower.ca/forum/posts/preList/1910/2798.page http://www.sqlpower.ca/forum/posts/preList/1910/2798.page GMT
You may have noticed that the 'Login' link at the top of the forum now brings you to our SQL Power Account login page. Your old forum username and password will still work with this system, so you don't have to sign up again.]]> http://www.sqlpower.ca/forum/posts/preList/1886/2666.page http://www.sqlpower.ca/forum/posts/preList/1886/2666.page GMT
http://www.sqlpower.ca/page/areyousmarter

Special thanks to Xuan & Jonathan for helping out, and to everyone who submitted questions for the game. Please continue to submit questions (and correct answers -- I ain't no consultant!) so I can keep the game fresh and challenging.]]> http://www.sqlpower.ca/forum/posts/preList/1785/2257.page http://www.sqlpower.ca/forum/posts/preList/1785/2257.page GMT [url]http://www.sqlpower.ca/page/makeitorbreakit[/url]

SQL Power is proud to present the [b]Power*MatchMaker: Make it or Break it Contest[/b], an opportunity for developers and database users across the globe to win cool prizes by helping us make the best Open Source Data Cleansing Tool available even better.

Prizes include [b]limited edition Power*MatchMaker T-shirts, USB Flash Drives,[/b] and of course [b]bragging rights![/b]

To win, just be one of the first to [b]submit accepted additions to the Power*MatchMaker source code or documentation[/b], or one of the first to [b]submit 3 validated bugs[/b]. (Refer to the contest page for full contest rules and regulations.)

[b]Don't delay... submission deadline is midnight Jan 1 2008![/b]]]> http://www.sqlpower.ca/forum/posts/preList/1776/2226.page http://www.sqlpower.ca/forum/posts/preList/1776/2226.page GMT
The forum looks a little different now that I've updated the graphics, but don't worry, it's still the same forum behind the scenes.

gQ
]]> http://www.sqlpower.ca/forum/posts/preList/1722/2013.page http://www.sqlpower.ca/forum/posts/preList/1722/2013.page GMT Join us for a Free Breakfast Seminar and learn
how to lower your BI software costs using Open Source BI Tools!

Thursday, Sept. 20th at 8:30am
at SQL Power's office located at
4950 Yonge St., Suite 2110 • Toronto, Ontario • M2N 6K1
Continental Breakfast at 8:30, Seminar from 9:00am-11:00am

Featuring guest speaker
André Boisvert
One of the leading authorities on Business Intelligence and Open Source Software in North America. Former president and COO of SAS, Chairman and CEO of Sagent, SVP at IBM and Cognos. Now Chairman of Pentaho Corporation - the world's most popular Open Source Business Intelligence platform.

Discussion Topics:

* Are you a victim of your Business Intelligence success?
* Learn how to avoid the escalating costs of BI software
* Discover the advantages of using Open Source Tools
* Tips on how to introduce Open Source Tools to your organization
* View live demos of popular Open Source BI tools, including: SQL Power's gDashboard (powered by Google Maps & Pentaho) and Kettle (Pentaho ETL Tool)
* Open discussion (Q & A)


Your attendance entitles you to a
FREE 1/2 Day Assessment of your BI environment
to see how Open Source Tools can help recover your BI budget!

Reserve your spot today at:
http://www.sqlpower.ca/page/breakfreeseminar

We look forward to seeing you there!]]> http://www.sqlpower.ca/forum/posts/preList/1703/1937.page http://www.sqlpower.ca/forum/posts/preList/1703/1937.page GMT
We've just released Power*Architect 0.9.7! This release fixes a number
of major bugs, so everybody should upgrade as soon as possible.

Major changes include:

*Fixed a bug with handling of automatic cascading primary keys in
multi-level
identifying relationships.
*Fixed a bug which was causing the Architect to save corrupt project
files.
This bug was triggered by adding and removing a column from the
primary key.
*Further enhanced the profile manager so it is possible to run
profiles
multiple times per session.
*Made it possible to add new database connection types from within the
GUI.
*Corrected the JDBC URL template for IBM DB2. If upgrading, to obtain
this fix,
you have to remove the DB2 database type from the user preferences
dialog,
then restart the Architect.
*Corrected an error in the user guide relating to the creation of FK
relationships.
*And more!

You can download the latest release here:
http://download.sqlpower.ca/architect/current.html

Enjoy!

Jeff ]]> http://www.sqlpower.ca/forum/posts/preList/1679/1866.page http://www.sqlpower.ca/forum/posts/preList/1679/1866.page GMT
The main features of the new & improved site:
- better navigation via a consitent navigation bar at the top
- new friendlier SQL Power graphics
- the SQL Side (structured query laughter)

I am now in the process of making sure all the content is updated to the new format, but if you see anything that looks "fishy", feel free to post it here.

Special thanks to the SQL Power dev team & co-ops for patiently helping me dig thru the java code!]]> http://www.sqlpower.ca/forum/posts/preList/1659/1766.page http://www.sqlpower.ca/forum/posts/preList/1659/1766.page GMT http://www.sqlpower.ca/page/architect

Toronto, Canada, July 11 - Is Open Source software the way of the future? The Data Warehousing experts at Toronto-based SQL Power Group are betting on it. On 7/7/07, SQL Power published the source code of the popular Power*Architect Data Modeling Tool on their web site. This release makes them the first-to-market with a cross-platform, Open Source data modeling tool with ETL integration.

Since 2003, SQL Power has been using the Power*Architect internally as a powerful data modeling tool, giving them the edge over their competition. So why are they giving it away for free as Open Source software?

"We believe that database productivity tools are becoming a commodity these days, with several good open source alternatives to most proprietary database tools. In support of the Open Source community and in order to provide companies with a low cost (Free) alternative to ERwin and other proprietary database design tools, SQL Power has decided to distribute the Power*Architect for free to all database designers and data modelers around the world. Also, by embracing the open source model, we are leveraging the efforts of the world-wide Java community." said Sam Selim, president of SQL Power.

Selim believes that Open Source software is the future for Data Warehouse & Business Intelligence projects, because clients can take the money they used to spend on license fees and use it towards value-adding development. Is this strategy working? The 4000-and-counting Power*Architect downloads over the first week of the Open Source release suggest that it is.

Established in 1988 and privately held, SQL Power is a leading Canadian software consulting firm specializing in Data Migration, Data Warehousing, and Business Intelligence.

For further information or to schedule an interview, contact:
Jonathan Fuerth
fuerth@sqlpower.ca
(416) 221-4220 ext. 252
SQL Power Group Inc.
2110-4950 Yonge St., Toronto ON M2N 6K1[url][/url][b][/b][b][/b][b]]]> http://www.sqlpower.ca/forum/posts/preList/1650/1746.page http://www.sqlpower.ca/forum/posts/preList/1650/1746.page GMT
- reverse engineering existing databases
- performing data profiling on source databases
- auto-generating ETL metadata
- taking snapshots of database structures for off-line work

For more information and to download the Power*Architect, please visit us at [url]http://www.sqlpower.ca/page/architect[/url]

If you are interested in joining us to celebrate the release, please see the Socialite section for the release party details.]]> http://www.sqlpower.ca/forum/posts/preList/1643/1680.page http://www.sqlpower.ca/forum/posts/preList/1643/1680.page GMT
We'd like to invite you to our upcoming Breakfast Seminar on June 20th, on [b][color=red]How to Reduce your Dependency on Proprietary BI Tools![/color] [/b] Here are the details .. Hope to see you then!

Join us at [b]SQL Power Head Office [/b]for a Free Continental Breakfast & Seminar on the benefits of Open Source BI Software

[b]Wednesday June 20th 2007 at 8:30 am[/b]
[b]SQL POWER Boardroom · 4950 Yonge St. Suite 2110 · Toronto[/b]

continental breakfast at 8:30 · seminar from 9 am to 10:30 am

[b]TOPICS OF DISCUSSION:[/b]
- Advantages of using Open Source BI Tools
- Escalating BI Software Costs & how to avoid them
- Are you a victim of your Business Intelligence success?
- How to Introduce Open Source BI Tools in your organization
- SQL Power gDashboard Demo (powered by Google Maps & Pentaho)
- Demos of popular Open Source BI tools
- Open discussion (Q & A)[/list]

Register online today at www.sqlpower.ca/page/lowerBIcost_seminar
or contact us at 1-866-SQL-POWR or info@sqlpower.ca to find out more.]]> http://www.sqlpower.ca/forum/posts/preList/1621/1645.page http://www.sqlpower.ca/forum/posts/preList/1621/1645.page GMT