RE: Microsoft SQL Server 2008
- From: Katherine Moss <Katherine.Moss@xxxxxxxxxx>
- To: "programmingblind@xxxxxxxxxxxxx" <programmingblind@xxxxxxxxxxxxx>
- Date: Wed, 18 May 2011 21:30:25 +0000
That's why I so wish I could have standard edition running on my PowerEdge
T110. Technically I could afford it, but I don't because I haven't found a
need for it.
From: programmingblind-bounce@xxxxxxxxxxxxx
[mailto:programmingblind-bounce@xxxxxxxxxxxxx] On Behalf Of Jacques Bosch
Sent: Wednesday, May 18, 2011 5:13 PM
To: programmingblind@xxxxxxxxxxxxx
Subject: Re: Microsoft SQL Server 2008
Hi Rodney.
>I don't like the tracing tool so much... it is a battle to get the information
>I need from it.
In SQL Server 2008, the tracing tool is called SQL Profiler. Not sure what it
was called before.
But it has the very useful option of tracing directly into a table. That way
you can interrogate the trace table with standard SQL selects and filter with
WHERE clauses and it makes consumption of the trace data a whole lot more
palatable.
When you start a new trace, just look for the checkbox that is called something
like "Trace to table". Then you must specify a target database and table into
which the trace should be written.
Jacques
On Wed, May 18, 2011 at 3:40 PM, Rodney Haynie
<rhaynie@xxxxxxxxxxx<mailto:rhaynie@xxxxxxxxxxx>> wrote:
Tony,
I connect to MS SQL databases from 2000 up to 2008, using SSMS (SQL Server
Management Studio). I have the Developer version of SQL Server installed on my
local PC. SSMS is the replacement for Query Analyzer and Enterprise Manager.
I am a Developer, not a DBA... with that said, the things I do every day are
the following:
Create and modify stored procedures.
Review database schemas
Write and execute TSQL.
I am currently using JAWS 12, but was using JAWS 11 with the same SSMS before.
I don't like the tracing tool so much... it is a battle to get the information
I need from it.
The query analyzer is a bit cumbersome as well.
Regards.
Rodney
From:
programmingblind-bounce@xxxxxxxxxxxxx<mailto:programmingblind-bounce@xxxxxxxxxxxxx>
[mailto:programmingblind-bounce@xxxxxxxxxxxxx<mailto:programmingblind-bounce@xxxxxxxxxxxxx>]
On Behalf Of Anthony P Schnurr
Sent: Wednesday, May 18, 2011 8:56 AM
To: programmingblind@xxxxxxxxxxxxx<mailto:programmingblind@xxxxxxxxxxxxx>
Subject: MicroSoft SQL Server 2008
Hello,
I have been asked to check into doing some work with Transact SQL and MS SQL
Server since we are going to be moving from Oracle to SQL server for future
development.
I would like to hear from anyone who has successfully worked in this
environment using a screen reader. What tools worked for you?
I once tried Enterprise Manager with SQL Analyzer on an older computer which I
had some good luck with; however, I was told I could not use that tool on my
newer machine.
I currently have MS SQL Studio Manager on this Windows 7 64-bit machine.
I am currently using latest build of JAWS 11 and trying to convince management
to purchase upgrade to 12. Though we have some SQL Server 2000 DBs; we are
also going to be adding some SQL Server 2008 or newer DBs.
Any thoughts?
Tony Schnurr
Programmer Analyst Sr Professional
CSC
6125 E. 21st Street MS 32 Indianapolis IN, USA 46219-2058
Global Outsourcing Services | p; +1-317.306.3608<tel:%2B1-317.306.3608> | f:
+1-317.306.4253<tel:%2B1-317.306.4253> |
aschnurr@xxxxxxx<mailto:aschnurr@xxxxxxx> | www.csc.com<http://www.csc.com>
This is a PRIVATE message. If you are not the intended recipient, please delete
without copying and kindly advise us by e-mail of the mistake in delivery.
NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any
order or other contract unless pursuant to explicit written agreement or
government initiative expressly permitting the use of e-mail for such purpose.
--
Jacques Bosch
Software Architecture and Development
Independent Contractor
Cell: +27 824711807 Fax: +27 86 504 4726
E-Mail: jfbosch@xxxxxxxxx<mailto:jfbosch@xxxxxxxxx>
Other related posts:
