| Author |
Topic |
|
SamC
White Water Yakist
3467 Posts |
 Posted - 2003-06-23 : 13:49:12
|
| Has anyone used Ken Henderson's Sqeuen? What are the Pros & Cons?Sam |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2003-06-23 : 15:45:34
|
| Here's the URL if anyone's interested. I haven't tried it. I'm trolling for feedback before diving into an unknown. There must be some reason I've never seen SEQUIN mentioned in this forum?Samhttp://www.khen.com/soft01.htm |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-06-23 : 16:25:55
|
| What's this site you're trying to send us too Sam?My company blocks it.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2003-06-23 : 16:50:00
|
| It's Ken Henderson's website. I don't think he's done much to it since Q2, 2002 judging from his events calandar.If you're interested, here's the description..Sequin, a SQL development environment for Windows.Sequin (SQL Editor for Windows) is a code editor for SQL, specifically Microsoft Transact-SQL, the SQL dialect that's built into Microsoft SQL Server. Sequin is a replacement for the popular Query Analyzer facility that ships with SQL Server. It offers numerous features not found in Query Analyzer and provides a full-featured integrated programming environment for Transact-SQL, similar to mainstream development tools such as Visual Basic and Delphi.Key FeaturesUnlimited file size/number of filesUnlimited undo/redoBackground query processing with KILL supportSyntax highlighting for all Transact-SQL keywordsSISETM (Syntax Independent Scripting Engine) scripting facility that allows the environment to be extended using ActiveScript compatible languages (e.g, VBScript, PerlScript, etc.)Complete block command support (e.g., indention, commenting, casing, execution, etc.)Speedy Enterprise Manager-like facilityCode hints for Transact-SQL syntax, databases, database objects, etc.SQL Profiler-like Transact-SQL trace facilityPowerful search engine (block searches, regular expressions, etc.)Open table command that allows a table or view to be opened in a grid and optionally editedCode template supportAutoScript and AutoOpen facilities that make scripting and opening database objects as easy as clicking a mouseFull-blown keyboard/mouse macro facilityExport query results to XML, HTML, Excel, and ASCII textAutomatic spell checking of code comments if Microsoft Word is installedPricingSequin is free of charge for non-commercial use. If you would like to distribute Sequin or bundle it with a commercial product, contact us.DownloadingClick here to download the latest release of Sequin.SamEdited by - SamC on 06/23/2003 16:52:08 |
|
|
|
byrmol
Shed Building SQL Farmer
1591 Posts |
Posted - 2003-06-23 : 18:32:22
|
Let me say I have never seen it..quote:
Unlimited file size/number of filesUnlimited undo/redo
QA has 20 actions with up to 1000 lines each. Never have I exceeded this..quote:
Background query processing with KILL support
Open another connection to simulate this...quote:
Syntax highlighting for all Transact-SQL keywords
QA all ready has this...quote:
Complete block command support (e.g., indention, commenting, casing, execution, etc.)
QA all ready has this...quote:
Code hints for Transact-SQL syntax, databases, database objects, etc.
That would be nice..quote:
Powerful search engine (block searches, regular expressions, etc.)
That would be nice..quote:
Code template support
QA all ready has this...quote:
AutoScript and AutoOpen facilities that make scripting and opening database objects as easy as clicking a mouse
QA all ready has this...quote:
Full-blown keyboard/mouse macro facility
QA all ready has limited (TSQL) keyboard macros...quote:
Export query results to XML, HTML, Excel, and ASCII text
That would be niceDavidM"SQL-3 is an abomination.." |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-06-23 : 18:50:21
|
quote:
There must be some reason I've never seen SEQUIN mentioned in this forum?
You didn't search for it maybe?http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=24912Granted, it wasn't in THIS forum, it was in General SQL Server.  I tried it out, it's nice, I agree with David though that a lot of features are already in Query Analyzer. It feels a little more "nimble" to me than QA does. It's really a matter of personal preference which one you like better. |
|
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2003-06-23 : 20:24:19
|
quote:
You didn't search for it maybe?
I have an unlimited capacity for overlooking the obvious.Sam |
|
|
|
simondeutsch
Aged Yak Warrior
547 Posts |
Posted - 2003-06-23 : 23:11:18
|
| I have done some work with Sequin 2. I tried to use it as a query tool for MSDE, to skirt licensing issues with QA. But Sequin, while it sounds very nifty, is difficult to get along with... Or maybe it's me...1. It seems to have dependency issues. Sequin has an explorer-type window for viewing database objects similar to Enterprise Managers, except it's much faster and not so graphical. But to use it, you must have MMC installed, or you get files missing errors.2. It is just plain flukey sometimes. You might enter a typo like "Slect * From Table", try to run it, get a syntax error, fix it, try to run it again, and get an error saying "Invalid Descriptor Index", which actually sounds like a code error, NOT a T-SQL error, and that's it. You can't get any further, whatever you type in and run just gives this error.3. Sometimes, results will show up in another window than the one you ran the query in, even when your preference is set to use the same window. I haven't been able to detect a pattern.4. Couldn't figure out the highlighting. Sometimes a line gets highlighted brown, and I can't figure out how to get rid of it, or what it means. QA has no highlighting except for the blue selection highlight.You might want to look into it, and maybe I'm the one with the problems, but give it a good test drive before relying on it to substitute for QA.Sarah Berger MCSDEdited by - simondeutsch on 06/23/2003 23:12:26 |
|
|
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
Posted - 2003-06-24 : 03:04:58
|
What is this site??!! Our proxy server states "...denies access to site"...blocked!!"So Mr. Owais, I hear from the network admin that you are spending your time surfing (ahem) inappropriate sites. Are you not aware that we condemn everything that stands in the way of Micro$oft, including competition, substitutes and everything LIKE 'O%' OR 'L%' ?" wais |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-06-24 : 09:03:24
|
OK Sam, you want feedback...1.quote:
My company blocks it.
2. My company is defenitley NOT going to go with this...they've got to be afraid enough with MS (see slammer virus)3. Why do you need it? I'm a command line junkie kind of guy anyway4. Didn't even know all the new features in QA until Tara pointed them out (still don't use them though...It's nice to have a mainframe background where everuthing is painful, Makes QA look like heaven)5. Try working with PL/SQL if you want to know what pain is like...the only time I explored for a "tool" that does what Kens does...PL/SQL developer I think it was called...couldn't get an exception from the company..6. oh, I don't know...a bovive MOO for Mr. Mist7. It's FINALLY Sunny in NJBrett8-) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-06-26 : 12:49:32
|
| Why are some companies blocking access to the khen.com site? It's just Ken Henderson's site.Tara |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-06-30 : 19:43:34
|
| Maybe it was something else...I got in today...going to give it a whirl...But I would imagine putting Sequin on the resume may not do to much..And I'm sure my company would frown on it depending on it during a development life of a projectLook pretty cool though..Brett8-) |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2003-07-01 : 02:57:18
|
quote:
6. oh, I don't know...a bovive MOO for Mr. Mist
*moos appreciatingly*I've not used this program, but it does seem like replacing query analyzer for the sake of replacing it.-------Moo. |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-07-25 : 16:27:51
|
| I wonder if Ken Would comment on it for us? Is he registered here?Brett8-) |
|
|
|
|
Sequin