November 28, 2003 at 12:00 am
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/sjones/navigatingyukonafirstlook.asp
December 9, 2003 at 7:10 am
Thanks Steve! I've been dying for a peek at Yukon.
The question I have about the SQL Workbench interface is how does it perform compared to MMC. I've noticed that MMC seems to be a bit of a hog. I'm not sure if it's memory or what but I've always disliked MMC's tendency to lock up a pc if it's not happy or if it's waiting for something.
I don't know if it was mentioned in the article but I'm excited about what I've heard regarding SQL Workbench's ability to record scripts. I don't know what sounds better to me, the ability for the GUI to script everything I do or just being able to easily see what T-SQL commands it uses for the various tasks.
"I met Larry Niven at ConClave 27...AND I fixed his computer. How cool is that?"
(Memoirs of a geek)
"I met Larry Niven at ConClave 27...AND I fixed his computer. How cool is that?"
(Memoirs of a geek)
December 9, 2003 at 8:18 am
Boy, I don't have Yukon handy (on the road), but it seems to me that it performs pretty well. If you've used Visual Studio, it performs like that, pretty well. Not sure it's locked up on me yet.
As far as scripts, haven't dug in there. Was just poking around when I thought others might be interested, so I started making notes and looking around at various areas. Since so many things are turned off, I'll have to check on that.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 9, 2003 at 2:51 pm
The scripting is kind of nice. I noticed, at least for logins, it uses the old syntax (sp_addlogin for SQL Server login rather than CREATE LOGIN), probably so you can manage older SQL Servers. You will be able to see exactly what the Workbench would execute. Then again, for most operations you can do the same thing with Profiler in SQL Server 7.0 and 2000, it just isn't as convenient.
K. Brian Kelley, GSEC
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
K. Brian Kelley
@kbriankelley
December 9, 2004 at 8:10 am
You mentioned Query Analyzer in your story yet I do not believe that Yukon (SQL Server 2K5) includes QA or anything like it. Sure the workbench allows you to connect and execute commands just like QA but the workbench can be over kill for many tasks. AT my company there are many times where one needs to lookup a quick value in a table and QA provides fast access to do this without a lot of over head. Under Yukon this same process would require using the bulky workbench.
I have been unable to locate QA in Yukon (Beta 2) and I have not been able to get QA for SQL Server 2000 to work with Yukon. I too like the workbench and its ability to build projects but there needs to also be a way to quickly connect to and lookup simple pieces of data without having to create a project to do so.
Ed Carden
Kindest Regards,
Just say No to Facebook!December 9, 2004 at 12:19 pm
A couple of things I have noticed, some may just be due to the fact that it is in Beta. The first is that the results grid is not editable, I haven't seen a way within the tool to make it so. This is a very handy feature in Enterprise Manager, being able to just pull up a table and edit some values. Apparently we'll have to write update queries for every single thing (a real pain in the nether regions) or adopt some other tool.
Also, in the stored procedure editor the having the checkboxes and what-not at the top is handy, maybe too much so. A lot of people didn't know that you could encrypt stored procedures in 2000, but now it's right there staring you in the face, just check the box. I see a lot of folks scrambling for a way to unencrypt their procs when they realize after the fact that they no longer have access to the source.
SQLExpress looks to be an good option for standalone apps, just wondering if it will match Sybase for security.
Marbry Hardin
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply