RE: SQL Server 2008 R2 ManagerStudio

  • From: Katherine Moss <Katherine.Moss@xxxxxxxxxx>
  • To: "programmingblind@xxxxxxxxxxxxx" <programmingblind@xxxxxxxxxxxxx>
  • Date: Sat, 6 Aug 2011 15:45:17 +0000

I'm looking for a command in powershell that will more like change the 
perrmissions on a number of files and folders at once to thee specified 
security permission  rather than doing it manually from explorer.

From: programmingblind-bounce@xxxxxxxxxxxxx 
[mailto:programmingblind-bounce@xxxxxxxxxxxxx] On Behalf Of Don Marang
Sent: Friday, August 05, 2011 8:29 PM
To: programmingblind@xxxxxxxxxxxxx
Subject: Re: SQL Server 2008 R2 ManagerStudio

I believe you are looking at the wrong command.  The 'ps' command will give you 
the Process Status.  What you probably want is the 'ls -l' command to list 
files and directories in the long format.  This will show the execute (x), 
write (w), and read (r) for the user, group, and world.

Don Marang
Vinux Software Development Coordinator - 
vinuxproject.org<http://www.vinuxproject.org/>
There is just so much stuff in the world that, to me, is devoid of any real 
substance, value, and content that I just try to make sure that I am working on 
things that matter.
-- Dean Kamen

On 8/5/2011 5:38 PM, Katherine Moss wrote:

Thanks.  I think it's because the pure image of having only a command line 
option (why when I get acquainted with Linux in the future I'll never use 
distributions such as Rhel, Cent OS, or Ubuntu server edition if I can help 
it), scares me to death.  My goal eventually is to rely heavily on Powershell, 
but not to the point that I don't use gui at all.  I think it really depends on 
what's going on.  Like when I have a whole bunch of repetitive tasks to 
complete, (such as the fact that I have 40 insecure folders that are writeable 
by IIS' web process on my server, I wouldn't want to change them all by hand 
via explorer), I'd use the command line to get a batch job out of it.  And by 
the way, I could use a hand getting the PS command for editing folder 
permissions.  Does anybody know it?  (I've searched for it via bing and got 
nothing direct or useful).



-----Original Message-----

From: 
programmingblind-bounce@xxxxxxxxxxxxx<mailto:programmingblind-bounce@xxxxxxxxxxxxx>
 [mailto:programmingblind-bounce@xxxxxxxxxxxxx] On Behalf Of Homme, James

Sent: Friday, August 05, 2011 2:03 PM

To: programmingblind@xxxxxxxxxxxxx<mailto:programmingblind@xxxxxxxxxxxxx>

Subject: RE: SQL Server 2008 R2 ManagerStudio



Hi Katherine,

That's a wise statement.



Jim



-----Original Message-----

From: 
programmingblind-bounce@xxxxxxxxxxxxx<mailto:programmingblind-bounce@xxxxxxxxxxxxx>
 [mailto:programmingblind-bounce@xxxxxxxxxxxxx] On Behalf Of Katherine Moss

Sent: Friday, August 05, 2011 10:26 AM

To: programmingblind@xxxxxxxxxxxxx<mailto:programmingblind@xxxxxxxxxxxxx>

Subject: RE: SQL Server 2008 R2 ManagerStudio



I'm just saying that if I had both, I prefer to use both when the time is 
right, versus having no gui options at all.



-----Original Message-----

From: 
programmingblind-bounce@xxxxxxxxxxxxx<mailto:programmingblind-bounce@xxxxxxxxxxxxx>
 [mailto:programmingblind-bounce@xxxxxxxxxxxxx] On Behalf Of Homme, James

Sent: Friday, August 05, 2011 7:57 AM

To: programmingblind@xxxxxxxxxxxxx<mailto:programmingblind@xxxxxxxxxxxxx>

Subject: RE: SQL Server 2008 R2 ManagerStudio



Hi Katherine,

With a text file, you get total accessibility. When you have to set some 
parameters yourself, you know exactly what you are doing to the server. And 
most of the time with a web server, once you set it, you are done for a while, 
so it's really a small thing. The Linux/UNIX people on this list use lots of 
command line stuff. Old dudes like I am started out with no GUI stuff to speak 
of. It's partly a preference thing, and partly a generational thing. And I 
honestly think that memorizing a few commands, if you have to use them a lot, 
makes you more efficient than plodding your way through a GUI interface. That 
said, I like GUI's. All of this stuff has its place. I feel that it's good to 
have an open mind and except things for what they are. That didn't sound quite 
right.



Oh well.



Jim



-----Original Message-----

From: 
programmingblind-bounce@xxxxxxxxxxxxx<mailto:programmingblind-bounce@xxxxxxxxxxxxx>
 [mailto:programmingblind-bounce@xxxxxxxxxxxxx] On Behalf Of Katherine Moss

Sent: Thursday, August 04, 2011 3:35 PM

To: programmingblind@xxxxxxxxxxxxx<mailto:programmingblind@xxxxxxxxxxxxx>

Subject: RE: SQL Server 2008 R2 ManagerStudio



Well I don't like Apache because it lacks a point-and-click interface.  I think 
that Command line's nice, but I feel that you should be given a choice which 
you prefer, which Microsoft does that very well by offering either command 
line, GUI, or direct XML editing.  I've had to edit XML in iis, and I just 
don't feel comfortable with configuring things via files.  I'll do it if that's 
the only way to do it for a quick thing, but that's it.



-----Original Message-----

From: 
programmingblind-bounce@xxxxxxxxxxxxx<mailto:programmingblind-bounce@xxxxxxxxxxxxx>
 [mailto:programmingblind-bounce@xxxxxxxxxxxxx] On Behalf Of Littlefield, Tyler

Sent: Thursday, August 04, 2011 3:31 PM

To: programmingblind@xxxxxxxxxxxxx<mailto:programmingblind@xxxxxxxxxxxxx>

Subject: Re: SQL Server 2008 R2 ManagerStudio



loyalty and complexity? So the more complex the better I guess? I can have 
mysql up and running in minutes. Apache can be up and running in a similar 
amount of time. You know how long, with docs it took me to jump through the IIS 
hoops to do -anything-, with docs?

On 8/4/2011 9:44 AM, Katherine Moss wrote:

I think it's due to both loyalty and complexity.



-----Original Message-----

From: 
programmingblind-bounce@xxxxxxxxxxxxx<mailto:programmingblind-bounce@xxxxxxxxxxxxx>

[mailto:programmingblind-bounce@xxxxxxxxxxxxx] On Behalf Of Homme,

James

Sent: Thursday, August 04, 2011 12:31 PM

To: programmingblind@xxxxxxxxxxxxx<mailto:programmingblind@xxxxxxxxxxxxx>

Subject: RE: SQL Server 2008 R2 ManagerStudio



Hi Katherine,

You probably know that it's possible to run PHP with Internet Information 
Server, right? I hope you are not preferring Microsoft over other solutions 
because of brand loyalty. This, even though I know that Cobol is the best 
language on earth, even better than English.



Jim





-----Original Message-----

From: 
programmingblind-bounce@xxxxxxxxxxxxx<mailto:programmingblind-bounce@xxxxxxxxxxxxx>

[mailto:programmingblind-bounce@xxxxxxxxxxxxx] On Behalf Of Katherine

Moss

Sent: Thursday, August 04, 2011 9:53 AM

To: programmingblind@xxxxxxxxxxxxx<mailto:programmingblind@xxxxxxxxxxxxx>

Subject: RE: SQL Server 2008 R2 ManagerStudio



I'd definitely probably do that if it wasn't for my preference for Microsoft 
products over others, and my preference for SQL Server's more vast set of 
features built in.  That's the only reason why I don't use PHP my admin.



-----Original Message-----

From: 
programmingblind-bounce@xxxxxxxxxxxxx<mailto:programmingblind-bounce@xxxxxxxxxxxxx>

[mailto:programmingblind-bounce@xxxxxxxxxxxxx] On Behalf Of Homme,

James

Sent: Thursday, August 04, 2011 9:39 AM

To: programmingblind@xxxxxxxxxxxxx<mailto:programmingblind@xxxxxxxxxxxxx>

Subject: RE: SQL Server 2008 R2 ManagerStudio



Hi Katherine,

For MySQL, you would totally love PHPMyAdmin. You can do all kinds of neeto 
stuff in your web browser and it's all accessible.



Jim



-----Original Message-----

From: 
programmingblind-bounce@xxxxxxxxxxxxx<mailto:programmingblind-bounce@xxxxxxxxxxxxx>

[mailto:programmingblind-bounce@xxxxxxxxxxxxx] On Behalf Of Katherine

Moss

Sent: Thursday, August 04, 2011 8:52 AM

To: programmingblind@xxxxxxxxxxxxx<mailto:programmingblind@xxxxxxxxxxxxx>

Subject: RE: SQL Server 2008 R2 ManagerStudio



I was curious about that too, for I could never seem to manage to get the 
command line client for SQL server working.  MySQL, I could get it working 
partially, but nothing more than that.  Like viewing logs, and stuff like that, 
I could never figure out which commands go where, so I just said screw it and 
moved to microsoft's database.



-----Original Message-----

From: 
programmingblind-bounce@xxxxxxxxxxxxx<mailto:programmingblind-bounce@xxxxxxxxxxxxx>

[mailto:programmingblind-bounce@xxxxxxxxxxxxx] On Behalf Of Jamal

Mazrui

Sent: Thursday, August 04, 2011 8:29 AM

To: programmingblind@xxxxxxxxxxxxx<mailto: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<mailto: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<mailto: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



__________

View the list's information and change your settings at

//www.freelists.org/list/programmingblind





This e-mail and any attachments to it are confidential and are intended solely 
for use of the individual or entity to whom they are addressed.  If you have 
received this e-mail in error, please notify the sender immediately and then 
delete it.  If you are not the intended recipient, you must not keep, use, 
disclose, copy or distribute this e-mail without the author's prior permission. 
 The views expressed in this e-mail message do not necessarily represent the 
views of Highmark Inc., its subsidiaries, or affiliates.

__________

View the list's information and change your settings at

//www.freelists.org/list/programmingblind



__________

View the list's information and change your settings at

//www.freelists.org/list/programmingblind



__________

View the list's information and change your settings at

//www.freelists.org/list/programmingblind



__________

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