Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Review - Apex SQL Edit Expand / Collapse
Author
Message
Posted Friday, October 15, 2004 11:52 AM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Friday, November 14, 2014 7:14 AM
Points: 6,625, Visits: 1,876
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/bkelley/review

K. Brian Kelley, CISA, MCSE, Security+, MVP - SQL Server
Regular Columnist (Security), SQLServerCentral.com
Author of
Introduction to SQL Server: Basic Skills for Any SQL Server User
| Professional Development blog | Technical Blog | LinkedIn | Twitter
Post #142041
Posted Monday, November 8, 2004 7:31 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, October 28, 2014 12:11 PM
Points: 2,006, Visits: 6,081

I've been using this since it was SQLEd, prior to Apex purchasing it, and was fortunate enough to get it for under $50 back then. They've improved the product immensely since then.
One of the biggest pluses with the product is their tech support staff, any errors automatically create dump files which you can send to their tech support email address. The longest I've had to wait for a response is 2 hours, and that was with a link to a fix for my problem. A lot of companies could take note of this.

Upside, it works really well and is great for developmental work. Downside, it's a bit slow and cumbersome and has a habit of occassionally bombing out, so remember to save your work frequently. Also sourcesafe intergration is something you have to be careful with, if you pull an object from sourcesafe then someone else makes changes and you pull it again from sourcesafe you will not see the changes unless you delete the file that was placed in your workfolder.

Other than that, buy it.





Shamless self promotion - read my blog http://sirsql.net
Post #145183
Posted Tuesday, November 9, 2004 7:35 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, November 10, 2014 3:22 AM
Points: 310, Visits: 411

I've just used Apex SQL Edit for the first time.

Pasting in a stored procedure from one of our development DB's I was a bit surprised to find that the Parse feature does not pick up on invalid column names. It's not until you atually execute a CREATE procedure that this comes to light.

"Check Syntax" when editing in Enterprise Manager detects this fundamental error - am I doing something wrong?




Post #145413
Posted Tuesday, November 9, 2004 1:27 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, October 4, 2007 10:09 AM
Points: 198, Visits: 2
Nicholas,

thx for post. We're continuing to crank out fix/feature releases and should have support for SCC compliant version control systems like Vault soon.

Pls check back often for new releases.



Brian Lockwood
President
ApexSQL - SQL Developer Essentials

http://www.apexsql.com/blog

Stand up for an Independent SQL Community - be Informed
Post #145499
Posted Tuesday, November 9, 2004 1:30 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, October 4, 2007 10:09 AM
Points: 198, Visits: 2
... and I forgot. pls vote Edit for best SQL IDE and support low priced / free support / free upgrade software product

http://www.sqlservercentral.com/survey/TakeSurvey.asp?SurveyID=l41m63KHl66KG



Brian Lockwood
President
ApexSQL - SQL Developer Essentials

http://www.apexsql.com/blog

Stand up for an Independent SQL Community - be Informed
Post #145500
Posted Tuesday, November 9, 2004 2:14 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, August 26, 2009 7:04 AM
Points: 5, Visits: 16

First of all, the product has far more features than discussed in the article. For instance, it can create from a query a standalone client viewer executable that can be emailed to someone as a quick report.

Another feature: you can double-click on a value in a column of the query results and lookup this value in another table you will select from the popup prompt.

There are tons of other features as well. What's bad, however, is that little of them work satisfactory. On overall, the product would be good as beta, but in my opinion, it's quality is far from the release.

It's slow. Thing as trivial as opening new query window takes 20 seconds or so on 2GHz/1GB machine.

Every now and then, it bombs out. Must save your work every 5 minutes.

Visual Query fails to parse anything non-trivial. Worse yet, after such failure, it erases the query completely. Say, you work on a query, then you add more to it, then you try to switch to the visual mode - oops, already can't do that, bad luck, your query text is now gone.

By the way, speaking of the article - indeed, there's no query diagram in Query Analyzer; but there's one in Enterprise Manager, and, unlike Apex, it does not take one minute to initialize.

The above are just few examples; in fact, working with this product, I hit things like those every 5 minutes - things that are maybe OK in alpha or beta, but that should not be happening in released products.

From experience of working with this product for several weeks, I came to the conclusion that it's an interesting and impressive toy to play with, but it's definitely not a tool that might be reliably used by a developer in "production mode".

Post #145509
Posted Tuesday, November 9, 2004 3:31 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, February 15, 2012 9:18 AM
Points: 415, Visits: 4

"By the way, speaking of the article - indeed, there's no query diagram in Query Analyzer; but there's one in Enterprise Manager, and, unlike Apex, it does not take one minute to initialize."

Excellent point...  However, in Enterprise Manager, you can not perform INSERT FROM, INSERT INTO, UPDATE, or DELETE queries that involves joins (refer to my article at http://www.sqlservercentral.com/columnists/dcorey/buildingjoinstheeasyway.asp).  You can do this with ApexSQL Edit.  However, I did have difficulties deleting tables from the Visual Query window once they were added.  Also, to change the catalog, I had to exit the software and start over.  Maybe I missed something there.




All the best,

Dale

Author: An Introduction to SQL Server 2005 Management Studio
Post #145529
Posted Wednesday, November 10, 2004 9:24 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, August 26, 2009 7:04 AM
Points: 5, Visits: 16

FROM, INSERT INTO, UPDATE, or DELETE queries that involves joins <snip> You can do this with ApexSQL Edit. 

well... let's try.

UPDATE PART SET WEIGHT=USER_1 FROM WORK_ORDER INNER JOIN PART ON PART.ID=WORK_ORDER.BASE_ID

press "visual query"

15 seconds wait; then exactly what I said before: it can't parse it. Unpress "visual query" - alas, even the text is now gone.

Retype with a minor change; another try; now it crashes with unhandled exception.

Things like this on every step. I mentioned before that it can create a standalone viewer. Indeed, but when I emailed it to a coworker, he called and began to read the message about the missing dll. Ended up with sending him excel file, as usual.

By the way, speaking of unhandled exceptions: one of the real benefits of visual studio.net is much better handling and encapsulation of exceptions. Enclose everything in try...catch, and exceptions will go. Too much work?

Also, to change the catalog, I had to exit the software and start over.  Maybe I missed something there

ctrl-shift-G , or shortcut menu/change catalog in query window (the menu erronsouly says it's ctrl-G)

As I understand, this product does not have a beta phase. Big mistake. Too eager to sell?

Post #145668
Posted Thursday, November 11, 2004 5:47 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, November 8, 2007 3:19 PM
Points: 3, Visits: 3
Vadim,

The client executable uses no external DLLs other than those in the .NET framework so the coworker probably didn't have .NET installed on their PC which is why the client viewer didn't work.

Also, I think Undo will bring back Visual Query statements (maybe, I haven't checked it).

Ashton
Post #145945
Posted Thursday, November 11, 2004 6:04 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, February 15, 2012 9:18 AM
Points: 415, Visits: 4

"press 'visual query'

15 seconds wait; then exactly what I said before: it can't parse it. Unpress 'visual query' - alas, even the text is now gone.

Retype with a minor change; another try; now it crashes with unhandled exception."

In all fairness Vadim, I did not experience this problem.  In fact, it parsed just fine over and over.  Were you using the latest version?




All the best,

Dale

Author: An Introduction to SQL Server 2005 Management Studio
Post #145947
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse