RE: SQL Server 2008 R2 ManagerStudio

  • From: "Rodney Haynie" <rhaynie@xxxxxxxxxxx>
  • To: <programmingblind@xxxxxxxxxxxxx>
  • Date: Thu, 4 Aug 2011 11:38:14 -0400

Well I guess I can best describe my work as being focused on application
development, more than database administration.

I do not use command line at all with SQL Server.

The SSMS GUI is pretty good, and manageable with JAWS. I cannot make much
use of the execution plans, since they are mostly graphical. But I can
easily create databases, tables, users, and manage access rights all from
within SSMS.
Most of my time is consumed in stored procedure and script development. And
when I have to write long sprocs, I tend to do most of the work in Ultra
Edit, and copy/paste into SSMS. This is purely because I have been using
UltraEdit for so long.

Now with those two sentences off of my fingertips, I will say a contrasting
statement. I do like the auto completion of TSQL from within SSMS very much.
I am finally starting to use it, because I received a new box recently and
UltraEdit license had to be purchased. So I was not using UE for a month or
so. So I was forced into the SSMS interface for writing code, and to my
surprise it worked very well, and saved on a bunch of typos on field names
and table names.

This old dog still needs to learn some more tricks because I am still
finding myself jumping back and forth between UE and SSMS.

So, I am sorry I cannot comment at all on the command line client.

-Rodney



-----Original Message-----
From: Jamal Mazrui [mailto:empower@xxxxxxxxx] 
Sent: Thursday, August 04, 2011 8:29 AM
To: programmingblind@xxxxxxxxxxxxx
Cc: Rodney Haynie
Subject: Re: SQL Server 2008 R2 ManagerStudio

Hi Rodney,
I am curious which aspects of database administration you find more 
productive with a GUI client, and which with a command-line client.

Jamal


On 8/4/2011 7:17 AM, Rodney Haynie wrote:
> Well I guess people will have different experiences on different
> computers. That is often the case with so many hardware configurations.
> I know with VS2010 I was experiencing issues that other people were not.
>
> I say this because for what I use SSMS (2008 r2) for, I have no
> problems. I am not a DBA, but I use it for creating editing, deleting
> stored procedures, databases, tables, triggers, etc.
>
> I am in SSMS for multiple hours a day, mostly doing things like writing
> and executing SQL statements to query data.
>
> There are some small work-around I have found, but the tree view is not
> an issue at all for me. I can drill down through the server name, and go
> through databases, and tables, and columns within the tables, etc. I can
> then drill back upwards with no problems in the tree view. This is all
> with JAWS 12. I think I started using SSMS in SQL Server 2005 with JAWS
> 10. Before that I was using SQL Server 2000 mostly.
>
> My current computer is Windows 7 64 bit with JAWS 12.
>
> Take care.
>
> Rodney
>
> *From:*programmingblind-bounce@xxxxxxxxxxxxx
> [mailto:programmingblind-bounce@xxxxxxxxxxxxx] *On Behalf Of *Katherine
Moss
> *Sent:* Wednesday, August 03, 2011 10:28 PM
> *To:* programmingblind@xxxxxxxxxxxxx
> *Subject:* RE: SQL Server 2008 R2 ManagerStudio
>
>  From the experience I have with it, it's relatively accessible. The
> only pain in the neck you'll run into is that it has issues keeping you
> in the correct level of the tree view, and whenever you open a node, you
> can close it, but you have to log out of it and back in to see the node
> above it. Don't ask me why that is. It's a royal pain,but, it's
> workable. Maybe a few of us at once should report it considering it's
> been ignored for the past few years now.
>
> *From:*programmingblind-bounce@xxxxxxxxxxxxx
> [mailto:programmingblind-bounce@xxxxxxxxxxxxx] *On Behalf Of *Mike Freeman
> *Sent:* Wednesday, August 03, 2011 10:21 PM
> *To:* programmingblind@xxxxxxxxxxxxx
> *Subject:* SQL Server 2008 R2 ManagerStudio
>
> Any thoughts on accessibility of same with JAWS Version 12.x?
>
> T I A!
>
> Mike Freeman
>

__________
View the list's information and change your settings at 
//www.freelists.org/list/programmingblind

Other related posts:

  1. Home
  2. programmingblind
  3. Archive
  4. 08-2011