I really like to pass my books on, for small price to anyone who could use them, since I no longer need 'em. I've got one , the SQL 2000 Administrator's Companion. Please take a look, I put it on ebay:
http://cgi.ebay.com/ws/eBayISAPI.dll?ViewItem&category=36313&item=3593450436
Thanks
/robWhere in Jersey?
or as they like to say...
What exit?|||Exit 80 :)|||GSP that is :) (Toms River)
Originally posted by robntguy
Exit 80 :)|||http://www.mapquest.com/maps/map.adp?formtype=search&countryid=250&addtohistory=&country=US&address=&city=west+orange&state=nj&zipcode=&historyid=&submit=Get+Map|||That's exit 145...
http://metrocommute.com/LI/exits/GSP.html|||That would be 65 exits from me.|||Yeah...wife has a friend down that way...Forker River I think..
They're building on every square inch...they finish the contruction on 9?|||What parts ? LOL. It's all these god damn Staten Island people taking over down here ... freakin' Sopranos all over again ! :)|||Only $1 ? 2 more days ... come on guys !
Showing posts with label book. Show all posts
Showing posts with label book. Show all posts
Monday, March 19, 2012
Monday, March 12, 2012
Good SQL Server Agent book?
I plan to automate a process using about 20 steps and would
like to use SQL Server Agent. I'm finding it difficult to learn how
Agent works. The help files are skimpy and scattered and
leave many questions unanswered.
One thing I've noticed is that Agent does a lot of things behind
the curtain that the user did not request. If I write a script using
TSQL commands like sp_add_job, sp_add_job_step, etc., and
then invoke it via Agent, Agent does things that aren't in my
script. If I ask Agent to generate a script for my job it spits
out a script that includes most of what I ordered, but with
a lot of other boilerplate that I didn't order and some things
like transaction management, that may not have been what
I wanted.
Is all of this documented somewhere? Has someone written
a good book that covers this and gives recommendations on
the best ways to use Agent?
Thanks.
Alan<ameyer2@.yahoo.com> wrote in message
news:1153251901.175708.34630@.s13g2000cwa.googlegroups.com...
>I plan to automate a process using about 20 steps and would
> like to use SQL Server Agent. I'm finding it difficult to learn how
> Agent works. The help files are skimpy and scattered and
> leave many questions unanswered.
> One thing I've noticed is that Agent does a lot of things behind
> the curtain that the user did not request. If I write a script using
> TSQL commands like sp_add_job, sp_add_job_step, etc., and
> then invoke it via Agent, Agent does things that aren't in my
> script. If I ask Agent to generate a script for my job it spits
> out a script that includes most of what I ordered, but with
> a lot of other boilerplate that I didn't order and some things
> like transaction management, that may not have been what
> I wanted.
> Is all of this documented somewhere? Has someone written
> a good book that covers this and gives recommendations on
> the best ways to use Agent?
>
I would build your 20-step process in an SSIS package. Then deploy that
package as a 1-step SQL Agent job.
SSIS has a graphical workflow designer, integrated debugger, rich logging,
etc.
David|||David Browne wrote:
> ...
> I would build your 20-step process in an SSIS package. Then deploy that
> package as a 1-step SQL Agent job.
> SSIS has a graphical workflow designer, integrated debugger, rich logging,
> etc.
> David
Thanks David.
Unfortunately, we're still running SQLServer 2000, and it looks
like we'd have to upgrade our servers to SQL Server 2005 to
use SSIS. That may be more expensive and time consuming
than management would support just for this task.
Agent also has a graphical user interface, though I'm not sure
I wouldn't prefer submitting a script. The big advantage of a
script over a GUI, in my view, is that you can see everything
that happens in one listing, and if you're running multiple servers
you can easily move it to all of them. You can also document
a script with extensive comments.
However it looks like Microsoft really doesn't want you using
scripts for this purpose, so we'll probably use the GUI and have
it generate a script for us to load on multiple servers and to
store in our documentation safe.
Regards,
Alan|||Its not really documented but you can get some guidance by click on help in
the job help dialog. Right click on your job and select help is a
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
<ameyer2@.yahoo.com> wrote in message
news:1153261730.359715.126050@.i42g2000cwa.googlegroups.com...
> David Browne wrote:
> Thanks David.
> Unfortunately, we're still running SQLServer 2000, and it looks
> like we'd have to upgrade our servers to SQL Server 2005 to
> use SSIS. That may be more expensive and time consuming
> than management would support just for this task.
> Agent also has a graphical user interface, though I'm not sure
> I wouldn't prefer submitting a script. The big advantage of a
> script over a GUI, in my view, is that you can see everything
> that happens in one listing, and if you're running multiple servers
> you can easily move it to all of them. You can also document
> a script with extensive comments.
> However it looks like Microsoft really doesn't want you using
> scripts for this purpose, so we'll probably use the GUI and have
> it generate a script for us to load on multiple servers and to
> store in our documentation safe.
> Regards,
> Alan
>|||Hilary Cotter wrote:
> Its not really documented but you can get some guidance by click on help i
n
> the job help dialog. Right click on your job and select help is a
> ...
Thanks Hilary.
I also just found this:
http://www.microsoft.com/technet/pr...s/c12ppcsq.mspx
It seems to give more information than is in the help file.
Alan|||ameyer2@.yahoo.com wrote:
> David Browne wrote:
>
> Thanks David.
> Unfortunately, we're still running SQLServer 2000, and it looks
> like we'd have to upgrade our servers to SQL Server 2005 to
> use SSIS. That may be more expensive and time consuming
> than management would support just for this task.
> Agent also has a graphical user interface, though I'm not sure
> I wouldn't prefer submitting a script. The big advantage of a
> script over a GUI, in my view, is that you can see everything
> that happens in one listing, and if you're running multiple servers
> you can easily move it to all of them. You can also document
> a script with extensive comments.
> However it looks like Microsoft really doesn't want you using
> scripts for this purpose, so we'll probably use the GUI and have
> it generate a script for us to load on multiple servers and to
> store in our documentation safe.
> Regards,
> Alan
>
Hi Alan
Why don't you just create a DTS package and then run this package from
SQL server agent?
I must admit that I'm not quite sure what your problem is because I've
used SQL agent for years for many different purposes and I haven't
really seen that it add things I haven't asked for.
Regards
Steen Schlter Persson
Databaseadministrator / Systemadministrator|||Hello Steen. Thank you for the reply
Steen Persson (DK) wrote:
> Why don't you just create a DTS package and then run this package from
> SQL server agent?
Thanks for the suggestion. I will look into that.
> I must admit that I'm not quite sure what your problem is because I've
> used SQL agent for years for many different purposes and I haven't
> really seen that it add things I haven't asked for.
I presume you have mainly used the Agent GUI.
To see what I'm talking about, pick one of your Agent jobs
and export it as a text script, e.g.,
Open Agent.
Select any job
Right click on the job and select "All Tasks" / "Generate SQL
Script..."
Then examine what you get.
If you write your own script and submit it to SQL Server without
using the GUI front end, you can get your new job to show up in
the GUI list of jobs. However if you then use the GUI to generate
a script from it and compare what was generated to what you
input, you might be surprised. I was.
Alan|||ameyer2@.yahoo.com wrote:
> Hello Steen. Thank you for the reply
> Steen Persson (DK) wrote:
>
> Thanks for the suggestion. I will look into that.
>
> I presume you have mainly used the Agent GUI.
> To see what I'm talking about, pick one of your Agent jobs
> and export it as a text script, e.g.,
> Open Agent.
> Select any job
> Right click on the job and select "All Tasks" / "Generate SQL
> Script..."
> Then examine what you get.
> If you write your own script and submit it to SQL Server without
> using the GUI front end, you can get your new job to show up in
> the GUI list of jobs. However if you then use the GUI to generate
> a script from it and compare what was generated to what you
> input, you might be surprised. I was.
> Alan
>
Hi Alan
I still don't quite understand what your issue is. It's true that if I
generate a sql script from an existing job, there are more code in it,
but there's nothing I don't expect to be there. There are number of
checks if the job already exist etc. and that's all right for me. If you
don't check for this in your "manual" script you'll get an error if you
try to add a job that already exists so why shouldn't the check be there
when you generate the script?
Regards
Steen Schlter Persson
Databaseadministrator / Systemadministrator|||ameyer2@.yahoo.com wrote:
> Hello Steen. Thank you for the reply
> Steen Persson (DK) wrote:
>
> Thanks for the suggestion. I will look into that.
>
> I presume you have mainly used the Agent GUI.
> To see what I'm talking about, pick one of your Agent jobs
> and export it as a text script, e.g.,
> Open Agent.
> Select any job
> Right click on the job and select "All Tasks" / "Generate SQL
> Script..."
> Then examine what you get.
> If you write your own script and submit it to SQL Server without
> using the GUI front end, you can get your new job to show up in
> the GUI list of jobs. However if you then use the GUI to generate
> a script from it and compare what was generated to what you
> input, you might be surprised. I was.
> Alan
>
Perhaps you should analyze that additional code to determine what it's
doing? Maybe you're missing a step in your own scripts?
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Tracy McKibben wrote:
> Perhaps you should analyze that additional code to determine what it's
> doing? Maybe you're missing a step in your own scripts?
>
I have indeed analyzed it. Some of what is there is stuff that either
I don't need because I've done the same thing another way, or
because I just don't need it.
Some is questionable. I'm not in front of SQL Server right now,
but as I recall, it wraps my entire job step in a transaction. That
may be right in the average case but wrong in particular cases
where it could defeat the intent of the programmer.
I can see why this approach by Microsoft has its fans. I'm
just not one of them.
But I didn't create this thread for the purpose of flaming
Microsoft. I recognize the MS has produced many fine
programs, SQL Server among them. I just wanted to know
if anyone knew of any documentation of the things MS does
under the covers of the Agent GUI.
I did find one source of information. See my first posting on
July 19 for the reference. If anyone knows of any other
documentation I'd love to see it.
Thanks.
Alan
like to use SQL Server Agent. I'm finding it difficult to learn how
Agent works. The help files are skimpy and scattered and
leave many questions unanswered.
One thing I've noticed is that Agent does a lot of things behind
the curtain that the user did not request. If I write a script using
TSQL commands like sp_add_job, sp_add_job_step, etc., and
then invoke it via Agent, Agent does things that aren't in my
script. If I ask Agent to generate a script for my job it spits
out a script that includes most of what I ordered, but with
a lot of other boilerplate that I didn't order and some things
like transaction management, that may not have been what
I wanted.
Is all of this documented somewhere? Has someone written
a good book that covers this and gives recommendations on
the best ways to use Agent?
Thanks.
Alan<ameyer2@.yahoo.com> wrote in message
news:1153251901.175708.34630@.s13g2000cwa.googlegroups.com...
>I plan to automate a process using about 20 steps and would
> like to use SQL Server Agent. I'm finding it difficult to learn how
> Agent works. The help files are skimpy and scattered and
> leave many questions unanswered.
> One thing I've noticed is that Agent does a lot of things behind
> the curtain that the user did not request. If I write a script using
> TSQL commands like sp_add_job, sp_add_job_step, etc., and
> then invoke it via Agent, Agent does things that aren't in my
> script. If I ask Agent to generate a script for my job it spits
> out a script that includes most of what I ordered, but with
> a lot of other boilerplate that I didn't order and some things
> like transaction management, that may not have been what
> I wanted.
> Is all of this documented somewhere? Has someone written
> a good book that covers this and gives recommendations on
> the best ways to use Agent?
>
I would build your 20-step process in an SSIS package. Then deploy that
package as a 1-step SQL Agent job.
SSIS has a graphical workflow designer, integrated debugger, rich logging,
etc.
David|||David Browne wrote:
> ...
> I would build your 20-step process in an SSIS package. Then deploy that
> package as a 1-step SQL Agent job.
> SSIS has a graphical workflow designer, integrated debugger, rich logging,
> etc.
> David
Thanks David.
Unfortunately, we're still running SQLServer 2000, and it looks
like we'd have to upgrade our servers to SQL Server 2005 to
use SSIS. That may be more expensive and time consuming
than management would support just for this task.
Agent also has a graphical user interface, though I'm not sure
I wouldn't prefer submitting a script. The big advantage of a
script over a GUI, in my view, is that you can see everything
that happens in one listing, and if you're running multiple servers
you can easily move it to all of them. You can also document
a script with extensive comments.
However it looks like Microsoft really doesn't want you using
scripts for this purpose, so we'll probably use the GUI and have
it generate a script for us to load on multiple servers and to
store in our documentation safe.
Regards,
Alan|||Its not really documented but you can get some guidance by click on help in
the job help dialog. Right click on your job and select help is a
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
<ameyer2@.yahoo.com> wrote in message
news:1153261730.359715.126050@.i42g2000cwa.googlegroups.com...
> David Browne wrote:
> Thanks David.
> Unfortunately, we're still running SQLServer 2000, and it looks
> like we'd have to upgrade our servers to SQL Server 2005 to
> use SSIS. That may be more expensive and time consuming
> than management would support just for this task.
> Agent also has a graphical user interface, though I'm not sure
> I wouldn't prefer submitting a script. The big advantage of a
> script over a GUI, in my view, is that you can see everything
> that happens in one listing, and if you're running multiple servers
> you can easily move it to all of them. You can also document
> a script with extensive comments.
> However it looks like Microsoft really doesn't want you using
> scripts for this purpose, so we'll probably use the GUI and have
> it generate a script for us to load on multiple servers and to
> store in our documentation safe.
> Regards,
> Alan
>|||Hilary Cotter wrote:
> Its not really documented but you can get some guidance by click on help i
n
> the job help dialog. Right click on your job and select help is a
> ...
Thanks Hilary.
I also just found this:
http://www.microsoft.com/technet/pr...s/c12ppcsq.mspx
It seems to give more information than is in the help file.
Alan|||ameyer2@.yahoo.com wrote:
> David Browne wrote:
>
> Thanks David.
> Unfortunately, we're still running SQLServer 2000, and it looks
> like we'd have to upgrade our servers to SQL Server 2005 to
> use SSIS. That may be more expensive and time consuming
> than management would support just for this task.
> Agent also has a graphical user interface, though I'm not sure
> I wouldn't prefer submitting a script. The big advantage of a
> script over a GUI, in my view, is that you can see everything
> that happens in one listing, and if you're running multiple servers
> you can easily move it to all of them. You can also document
> a script with extensive comments.
> However it looks like Microsoft really doesn't want you using
> scripts for this purpose, so we'll probably use the GUI and have
> it generate a script for us to load on multiple servers and to
> store in our documentation safe.
> Regards,
> Alan
>
Hi Alan
Why don't you just create a DTS package and then run this package from
SQL server agent?
I must admit that I'm not quite sure what your problem is because I've
used SQL agent for years for many different purposes and I haven't
really seen that it add things I haven't asked for.
Regards
Steen Schlter Persson
Databaseadministrator / Systemadministrator|||Hello Steen. Thank you for the reply
Steen Persson (DK) wrote:
> Why don't you just create a DTS package and then run this package from
> SQL server agent?
Thanks for the suggestion. I will look into that.
> I must admit that I'm not quite sure what your problem is because I've
> used SQL agent for years for many different purposes and I haven't
> really seen that it add things I haven't asked for.
I presume you have mainly used the Agent GUI.
To see what I'm talking about, pick one of your Agent jobs
and export it as a text script, e.g.,
Open Agent.
Select any job
Right click on the job and select "All Tasks" / "Generate SQL
Script..."
Then examine what you get.
If you write your own script and submit it to SQL Server without
using the GUI front end, you can get your new job to show up in
the GUI list of jobs. However if you then use the GUI to generate
a script from it and compare what was generated to what you
input, you might be surprised. I was.
Alan|||ameyer2@.yahoo.com wrote:
> Hello Steen. Thank you for the reply
> Steen Persson (DK) wrote:
>
> Thanks for the suggestion. I will look into that.
>
> I presume you have mainly used the Agent GUI.
> To see what I'm talking about, pick one of your Agent jobs
> and export it as a text script, e.g.,
> Open Agent.
> Select any job
> Right click on the job and select "All Tasks" / "Generate SQL
> Script..."
> Then examine what you get.
> If you write your own script and submit it to SQL Server without
> using the GUI front end, you can get your new job to show up in
> the GUI list of jobs. However if you then use the GUI to generate
> a script from it and compare what was generated to what you
> input, you might be surprised. I was.
> Alan
>
Hi Alan
I still don't quite understand what your issue is. It's true that if I
generate a sql script from an existing job, there are more code in it,
but there's nothing I don't expect to be there. There are number of
checks if the job already exist etc. and that's all right for me. If you
don't check for this in your "manual" script you'll get an error if you
try to add a job that already exists so why shouldn't the check be there
when you generate the script?
Regards
Steen Schlter Persson
Databaseadministrator / Systemadministrator|||ameyer2@.yahoo.com wrote:
> Hello Steen. Thank you for the reply
> Steen Persson (DK) wrote:
>
> Thanks for the suggestion. I will look into that.
>
> I presume you have mainly used the Agent GUI.
> To see what I'm talking about, pick one of your Agent jobs
> and export it as a text script, e.g.,
> Open Agent.
> Select any job
> Right click on the job and select "All Tasks" / "Generate SQL
> Script..."
> Then examine what you get.
> If you write your own script and submit it to SQL Server without
> using the GUI front end, you can get your new job to show up in
> the GUI list of jobs. However if you then use the GUI to generate
> a script from it and compare what was generated to what you
> input, you might be surprised. I was.
> Alan
>
Perhaps you should analyze that additional code to determine what it's
doing? Maybe you're missing a step in your own scripts?
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Tracy McKibben wrote:
> Perhaps you should analyze that additional code to determine what it's
> doing? Maybe you're missing a step in your own scripts?
>
I have indeed analyzed it. Some of what is there is stuff that either
I don't need because I've done the same thing another way, or
because I just don't need it.
Some is questionable. I'm not in front of SQL Server right now,
but as I recall, it wraps my entire job step in a transaction. That
may be right in the average case but wrong in particular cases
where it could defeat the intent of the programmer.
I can see why this approach by Microsoft has its fans. I'm
just not one of them.
But I didn't create this thread for the purpose of flaming
Microsoft. I recognize the MS has produced many fine
programs, SQL Server among them. I just wanted to know
if anyone knew of any documentation of the things MS does
under the covers of the Agent GUI.
I did find one source of information. See my first posting on
July 19 for the reference. If anyone knows of any other
documentation I'd love to see it.
Thanks.
Alan
Good SQL Server Agent book?
I plan to automate a process using about 20 steps and would
like to use SQL Server Agent. I'm finding it difficult to learn how
Agent works. The help files are skimpy and scattered and
leave many questions unanswered.
One thing I've noticed is that Agent does a lot of things behind
the curtain that the user did not request. If I write a script using
TSQL commands like sp_add_job, sp_add_job_step, etc., and
then invoke it via Agent, Agent does things that aren't in my
script. If I ask Agent to generate a script for my job it spits
out a script that includes most of what I ordered, but with
a lot of other boilerplate that I didn't order and some things
like transaction management, that may not have been what
I wanted.
Is all of this documented somewhere? Has someone written
a good book that covers this and gives recommendations on
the best ways to use Agent?
Thanks.
Alan<ameyer2@.yahoo.com> wrote in message
news:1153251901.175708.34630@.s13g2000cwa.googlegroups.com...
>I plan to automate a process using about 20 steps and would
> like to use SQL Server Agent. I'm finding it difficult to learn how
> Agent works. The help files are skimpy and scattered and
> leave many questions unanswered.
> One thing I've noticed is that Agent does a lot of things behind
> the curtain that the user did not request. If I write a script using
> TSQL commands like sp_add_job, sp_add_job_step, etc., and
> then invoke it via Agent, Agent does things that aren't in my
> script. If I ask Agent to generate a script for my job it spits
> out a script that includes most of what I ordered, but with
> a lot of other boilerplate that I didn't order and some things
> like transaction management, that may not have been what
> I wanted.
> Is all of this documented somewhere? Has someone written
> a good book that covers this and gives recommendations on
> the best ways to use Agent?
>
I would build your 20-step process in an SSIS package. Then deploy that
package as a 1-step SQL Agent job.
SSIS has a graphical workflow designer, integrated debugger, rich logging,
etc.
David|||David Browne wrote:
> ...
> I would build your 20-step process in an SSIS package. Then deploy that
> package as a 1-step SQL Agent job.
> SSIS has a graphical workflow designer, integrated debugger, rich logging,
> etc.
> David
Thanks David.
Unfortunately, we're still running SQLServer 2000, and it looks
like we'd have to upgrade our servers to SQL Server 2005 to
use SSIS. That may be more expensive and time consuming
than management would support just for this task.
Agent also has a graphical user interface, though I'm not sure
I wouldn't prefer submitting a script. The big advantage of a
script over a GUI, in my view, is that you can see everything
that happens in one listing, and if you're running multiple servers
you can easily move it to all of them. You can also document
a script with extensive comments.
However it looks like Microsoft really doesn't want you using
scripts for this purpose, so we'll probably use the GUI and have
it generate a script for us to load on multiple servers and to
store in our documentation safe.
Regards,
Alan|||Its not really documented but you can get some guidance by click on help in
the job help dialog. Right click on your job and select help is a
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
<ameyer2@.yahoo.com> wrote in message
news:1153261730.359715.126050@.i42g2000cwa.googlegroups.com...
> David Browne wrote:
>> ...
>> I would build your 20-step process in an SSIS package. Then deploy that
>> package as a 1-step SQL Agent job.
>> SSIS has a graphical workflow designer, integrated debugger, rich
>> logging,
>> etc.
>> David
> Thanks David.
> Unfortunately, we're still running SQLServer 2000, and it looks
> like we'd have to upgrade our servers to SQL Server 2005 to
> use SSIS. That may be more expensive and time consuming
> than management would support just for this task.
> Agent also has a graphical user interface, though I'm not sure
> I wouldn't prefer submitting a script. The big advantage of a
> script over a GUI, in my view, is that you can see everything
> that happens in one listing, and if you're running multiple servers
> you can easily move it to all of them. You can also document
> a script with extensive comments.
> However it looks like Microsoft really doesn't want you using
> scripts for this purpose, so we'll probably use the GUI and have
> it generate a script for us to load on multiple servers and to
> store in our documentation safe.
> Regards,
> Alan
>|||Hilary Cotter wrote:
> Its not really documented but you can get some guidance by click on help in
> the job help dialog. Right click on your job and select help is a
> ...
Thanks Hilary.
I also just found this:
http://www.microsoft.com/technet/prodtechnol/sql/2000/books/c12ppcsq.mspx
It seems to give more information than is in the help file.
Alan|||This is a multi-part message in MIME format.
--000609000409020907060701
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
ameyer2@.yahoo.com wrote:
> David Browne wrote:
>> ...
>> I would build your 20-step process in an SSIS package. Then deploy that
>> package as a 1-step SQL Agent job.
>> SSIS has a graphical workflow designer, integrated debugger, rich logging,
>> etc.
>> David
> Thanks David.
> Unfortunately, we're still running SQLServer 2000, and it looks
> like we'd have to upgrade our servers to SQL Server 2005 to
> use SSIS. That may be more expensive and time consuming
> than management would support just for this task.
> Agent also has a graphical user interface, though I'm not sure
> I wouldn't prefer submitting a script. The big advantage of a
> script over a GUI, in my view, is that you can see everything
> that happens in one listing, and if you're running multiple servers
> you can easily move it to all of them. You can also document
> a script with extensive comments.
> However it looks like Microsoft really doesn't want you using
> scripts for this purpose, so we'll probably use the GUI and have
> it generate a script for us to load on multiple servers and to
> store in our documentation safe.
> Regards,
> Alan
>
Hi Alan
Why don't you just create a DTS package and then run this package from
SQL server agent?
I must admit that I'm not quite sure what your problem is because I've
used SQL agent for years for many different purposes and I haven't
really seen that it add things I haven't asked for.
Regards
Steen Schlüter Persson
Databaseadministrator / Systemadministrator
--000609000409020907060701
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<a class="moz-txt-link-abbreviated" href="http://links.10026.com/?link=mailto:ameyer2@.yahoo.com">ameyer2@.yahoo.com</a> wrote:
<blockquote
cite="mid1153261730.359715.126050@.i42g2000cwa.googlegroups.com"
type="cite">
<pre wrap="">David Browne wrote:
</pre>
<blockquote type="cite">
<pre wrap="">...
I would build your 20-step process in an SSIS package. Then deploy that
package as a 1-step SQL Agent job.
SSIS has a graphical workflow designer, integrated debugger, rich logging,
etc.
David
</pre>
</blockquote>
<pre wrap=""><!-->
Thanks David.
Unfortunately, we're still running SQLServer 2000, and it looks
like we'd have to upgrade our servers to SQL Server 2005 to
use SSIS. That may be more expensive and time consuming
than management would support just for this task.
Agent also has a graphical user interface, though I'm not sure
I wouldn't prefer submitting a script. The big advantage of a
script over a GUI, in my view, is that you can see everything
that happens in one listing, and if you're running multiple servers
you can easily move it to all of them. You can also document
a script with extensive comments.
However it looks like Microsoft really doesn't want you using
scripts for this purpose, so we'll probably use the GUI and have
it generate a script for us to load on multiple servers and to
store in our documentation safe.
Regards,
Alan
</pre>
</blockquote>
<font size="-1"><font face="Arial">Hi Alan<br>
<br>
Why don't you just create a DTS package and then run this package from
SQL server agent? <br>
I must admit that I'm not quite sure what your problem is because I've
used SQL agent for years for many different purposes and I haven't
really seen that it add things I haven't asked for.<br>
<br>
<br>
-- <br>
Regards<br>
Steen Schlüter Persson<br>
Databaseadministrator / Systemadministrator<br>
</font></font>
</body>
</html>
--000609000409020907060701--|||Hello Steen. Thank you for the reply
Steen Persson (DK) wrote:
> Why don't you just create a DTS package and then run this package from
> SQL server agent?
Thanks for the suggestion. I will look into that.
> I must admit that I'm not quite sure what your problem is because I've
> used SQL agent for years for many different purposes and I haven't
> really seen that it add things I haven't asked for.
I presume you have mainly used the Agent GUI.
To see what I'm talking about, pick one of your Agent jobs
and export it as a text script, e.g.,
Open Agent.
Select any job
Right click on the job and select "All Tasks" / "Generate SQL
Script..."
Then examine what you get.
If you write your own script and submit it to SQL Server without
using the GUI front end, you can get your new job to show up in
the GUI list of jobs. However if you then use the GUI to generate
a script from it and compare what was generated to what you
input, you might be surprised. I was.
Alan|||This is a multi-part message in MIME format.
--090000090502030800020104
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
ameyer2@.yahoo.com wrote:
> Hello Steen. Thank you for the reply
> Steen Persson (DK) wrote:
>
>> Why don't you just create a DTS package and then run this package from
>> SQL server agent?
> Thanks for the suggestion. I will look into that.
>
>> I must admit that I'm not quite sure what your problem is because I've
>> used SQL agent for years for many different purposes and I haven't
>> really seen that it add things I haven't asked for.
> I presume you have mainly used the Agent GUI.
> To see what I'm talking about, pick one of your Agent jobs
> and export it as a text script, e.g.,
> Open Agent.
> Select any job
> Right click on the job and select "All Tasks" / "Generate SQL
> Script..."
> Then examine what you get.
> If you write your own script and submit it to SQL Server without
> using the GUI front end, you can get your new job to show up in
> the GUI list of jobs. However if you then use the GUI to generate
> a script from it and compare what was generated to what you
> input, you might be surprised. I was.
> Alan
>
Hi Alan
I still don't quite understand what your issue is. It's true that if I
generate a sql script from an existing job, there are more code in it,
but there's nothing I don't expect to be there. There are number of
checks if the job already exist etc. and that's all right for me. If you
don't check for this in your "manual" script you'll get an error if you
try to add a job that already exists so why shouldn't the check be there
when you generate the script?
Regards
Steen Schlüter Persson
Databaseadministrator / Systemadministrator
--090000090502030800020104
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<a class="moz-txt-link-abbreviated" href="http://links.10026.com/?link=mailto:ameyer2@.yahoo.com">ameyer2@.yahoo.com</a> wrote:
<blockquote
cite="mid1153434437.302932.299920@.i42g2000cwa.googlegroups.com"
type="cite">
<pre wrap="">Hello Steen. Thank you for the reply
Steen Persson (DK) wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Why don't you just create a DTS package and then run this package from
SQL server agent?
</pre>
</blockquote>
<pre wrap=""><!-->
Thanks for the suggestion. I will look into that.
</pre>
<blockquote type="cite">
<pre wrap="">I must admit that I'm not quite sure what your problem is because I've
used SQL agent for years for many different purposes and I haven't
really seen that it add things I haven't asked for.
</pre>
</blockquote>
<pre wrap=""><!-->
I presume you have mainly used the Agent GUI.
To see what I'm talking about, pick one of your Agent jobs
and export it as a text script, e.g.,
Open Agent.
Select any job
Right click on the job and select "All Tasks" / "Generate SQL
Script..."
Then examine what you get.
If you write your own script and submit it to SQL Server without
using the GUI front end, you can get your new job to show up in
the GUI list of jobs. However if you then use the GUI to generate
a script from it and compare what was generated to what you
input, you might be surprised. I was.
Alan
</pre>
</blockquote>
<font size="-1"><font face="Arial">Hi Alan<br>
<br>
I still don't quite understand what your issue is. It's true that if I
generate a sql script from an existing job, there are more code in it,
but there's nothing I don't expect to be there. There are number of
checks if the job already exist etc. and that's all right for me. If
you don't check for this in your "manual" script you'll get an error if
you try to add a job that already exists so why shouldn't the check be
there when you generate the script?<br>
<br>
<br>
-- <br>
Regards<br>
Steen Schlüter Persson<br>
Databaseadministrator / Systemadministrator<br>
</font></font>
</body>
</html>
--090000090502030800020104--|||ameyer2@.yahoo.com wrote:
> Hello Steen. Thank you for the reply
> Steen Persson (DK) wrote:
>> Why don't you just create a DTS package and then run this package from
>> SQL server agent?
> Thanks for the suggestion. I will look into that.
>> I must admit that I'm not quite sure what your problem is because I've
>> used SQL agent for years for many different purposes and I haven't
>> really seen that it add things I haven't asked for.
> I presume you have mainly used the Agent GUI.
> To see what I'm talking about, pick one of your Agent jobs
> and export it as a text script, e.g.,
> Open Agent.
> Select any job
> Right click on the job and select "All Tasks" / "Generate SQL
> Script..."
> Then examine what you get.
> If you write your own script and submit it to SQL Server without
> using the GUI front end, you can get your new job to show up in
> the GUI list of jobs. However if you then use the GUI to generate
> a script from it and compare what was generated to what you
> input, you might be surprised. I was.
> Alan
>
Perhaps you should analyze that additional code to determine what it's
doing? Maybe you're missing a step in your own scripts?
--
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Tracy McKibben wrote:
> Perhaps you should analyze that additional code to determine what it's
> doing? Maybe you're missing a step in your own scripts?
>
I have indeed analyzed it. Some of what is there is stuff that either
I don't need because I've done the same thing another way, or
because I just don't need it.
Some is questionable. I'm not in front of SQL Server right now,
but as I recall, it wraps my entire job step in a transaction. That
may be right in the average case but wrong in particular cases
where it could defeat the intent of the programmer.
I can see why this approach by Microsoft has its fans. I'm
just not one of them.
But I didn't create this thread for the purpose of flaming
Microsoft. I recognize the MS has produced many fine
programs, SQL Server among them. I just wanted to know
if anyone knew of any documentation of the things MS does
under the covers of the Agent GUI.
I did find one source of information. See my first posting on
July 19 for the reference. If anyone knows of any other
documentation I'd love to see it.
Thanks.
Alan|||This is a multi-part message in MIME format.
--060304080400040803020408
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
ameyer2@.yahoo.com wrote:
> Tracy McKibben wrote:
>
>> Perhaps you should analyze that additional code to determine what it's
>> doing? Maybe you're missing a step in your own scripts?
>>
> I have indeed analyzed it. Some of what is there is stuff that either
> I don't need because I've done the same thing another way, or
> because I just don't need it.
> Some is questionable. I'm not in front of SQL Server right now,
> but as I recall, it wraps my entire job step in a transaction. That
> may be right in the average case but wrong in particular cases
> where it could defeat the intent of the programmer.
> I can see why this approach by Microsoft has its fans. I'm
> just not one of them.
> But I didn't create this thread for the purpose of flaming
> Microsoft. I recognize the MS has produced many fine
> programs, SQL Server among them. I just wanted to know
> if anyone knew of any documentation of the things MS does
> under the covers of the Agent GUI.
> I did find one source of information. See my first posting on
> July 19 for the reference. If anyone knows of any other
> documentation I'd love to see it.
> Thanks.
> Alan
>
You don't honestly expect that SQL server will produce a script that you
can just dump into some of you own code where you already has done a lot
of the checking that the script include?
When you right click on a job and script it out, SQL server can't do
anything else than produce a "stand-alone" script that can be run like
it is on it's own and then create the job you're asking for. For that
purpose I think it do the job very well and it include the code
necessary to do the job. This will (of course) also include a number of
checks and therefore also wrap it into a transaction that can be rolled
back in case of a failure.
Regards
Steen Schlüter Persson
Databaseadministrator / Systemadministrator
--060304080400040803020408
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<a class="moz-txt-link-abbreviated" href="http://links.10026.com/?link=mailto:ameyer2@.yahoo.com">ameyer2@.yahoo.com</a> wrote:
<blockquote
cite="mid1153622611.152439.140660@.75g2000cwc.googlegroups.com"
type="cite">
<pre wrap="">Tracy McKibben wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Perhaps you should analyze that additional code to determine what it's
doing? Maybe you're missing a step in your own scripts?
</pre>
</blockquote>
<pre wrap=""><!-->I have indeed analyzed it. Some of what is there is stuff that either
I don't need because I've done the same thing another way, or
because I just don't need it.
Some is questionable. I'm not in front of SQL Server right now,
but as I recall, it wraps my entire job step in a transaction. That
may be right in the average case but wrong in particular cases
where it could defeat the intent of the programmer.
I can see why this approach by Microsoft has its fans. I'm
just not one of them.
But I didn't create this thread for the purpose of flaming
Microsoft. I recognize the MS has produced many fine
programs, SQL Server among them. I just wanted to know
if anyone knew of any documentation of the things MS does
under the covers of the Agent GUI.
I did find one source of information. See my first posting on
July 19 for the reference. If anyone knows of any other
documentation I'd love to see it.
Thanks.
Alan
</pre>
</blockquote>
<font size="-1"><font face="Arial">You don't honestly expect that SQL
server will produce a script that you can just dump into some of you
own code where you already has done a lot of the checking that the
script include? <br>
When you right click on a job and script it out, SQL server can't do
anything else than produce a "stand-alone" script that can be run like
it is on it's own and then create the job you're asking for. For that
purpose I think it do the job very well and it include the code
necessary to do the job. This will (of course) also include a number of
checks and therefore also wrap it into a transaction that can be rolled
back in case of a failure.<br>
<br>
<br>
-- <br>
Regards<br>
Steen Schlüter Persson<br>
Databaseadministrator / Systemadministrator<br>
<br>
</font></font>
</body>
</html>
--060304080400040803020408--|||Steen Persson (DK) wrote:
...
> You don't honestly expect that SQL server will produce a script that you
> can just dump into some of you own code where you already has done a lot
> of the checking that the script include?
...
Well, like I say, I'm not here to flame Microsoft or say that what
they've done doesn't meet most people's needs.
For myself, I would like to be able to submit a script to Agent and
have some assurance that what I submitted is exactly what gets
done. If the script has detectable errors, I'd like Agent to report
them to me rather than modify the script.
It may be that Agent does exactly what I tell it to do. Or it may be
that it reads my script, extracts things from it, adds whatever it
wants, and throws my original script away.
Even though I wouldn't like that behavior, it would be fine if
it were documented. My problem, the one that I posted
to start this thread, is that I couldn't find any documentation.
I don't even know whether the script Agent
generates is what it executes, or whether it executes my
script just as I submitted it and generates the script it
generates just for my benefit if I want to use it as the basis
for some other job.
I'm just looking for serious documentation - something beyond
"to do this - click that".
Alan
like to use SQL Server Agent. I'm finding it difficult to learn how
Agent works. The help files are skimpy and scattered and
leave many questions unanswered.
One thing I've noticed is that Agent does a lot of things behind
the curtain that the user did not request. If I write a script using
TSQL commands like sp_add_job, sp_add_job_step, etc., and
then invoke it via Agent, Agent does things that aren't in my
script. If I ask Agent to generate a script for my job it spits
out a script that includes most of what I ordered, but with
a lot of other boilerplate that I didn't order and some things
like transaction management, that may not have been what
I wanted.
Is all of this documented somewhere? Has someone written
a good book that covers this and gives recommendations on
the best ways to use Agent?
Thanks.
Alan<ameyer2@.yahoo.com> wrote in message
news:1153251901.175708.34630@.s13g2000cwa.googlegroups.com...
>I plan to automate a process using about 20 steps and would
> like to use SQL Server Agent. I'm finding it difficult to learn how
> Agent works. The help files are skimpy and scattered and
> leave many questions unanswered.
> One thing I've noticed is that Agent does a lot of things behind
> the curtain that the user did not request. If I write a script using
> TSQL commands like sp_add_job, sp_add_job_step, etc., and
> then invoke it via Agent, Agent does things that aren't in my
> script. If I ask Agent to generate a script for my job it spits
> out a script that includes most of what I ordered, but with
> a lot of other boilerplate that I didn't order and some things
> like transaction management, that may not have been what
> I wanted.
> Is all of this documented somewhere? Has someone written
> a good book that covers this and gives recommendations on
> the best ways to use Agent?
>
I would build your 20-step process in an SSIS package. Then deploy that
package as a 1-step SQL Agent job.
SSIS has a graphical workflow designer, integrated debugger, rich logging,
etc.
David|||David Browne wrote:
> ...
> I would build your 20-step process in an SSIS package. Then deploy that
> package as a 1-step SQL Agent job.
> SSIS has a graphical workflow designer, integrated debugger, rich logging,
> etc.
> David
Thanks David.
Unfortunately, we're still running SQLServer 2000, and it looks
like we'd have to upgrade our servers to SQL Server 2005 to
use SSIS. That may be more expensive and time consuming
than management would support just for this task.
Agent also has a graphical user interface, though I'm not sure
I wouldn't prefer submitting a script. The big advantage of a
script over a GUI, in my view, is that you can see everything
that happens in one listing, and if you're running multiple servers
you can easily move it to all of them. You can also document
a script with extensive comments.
However it looks like Microsoft really doesn't want you using
scripts for this purpose, so we'll probably use the GUI and have
it generate a script for us to load on multiple servers and to
store in our documentation safe.
Regards,
Alan|||Its not really documented but you can get some guidance by click on help in
the job help dialog. Right click on your job and select help is a
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
<ameyer2@.yahoo.com> wrote in message
news:1153261730.359715.126050@.i42g2000cwa.googlegroups.com...
> David Browne wrote:
>> ...
>> I would build your 20-step process in an SSIS package. Then deploy that
>> package as a 1-step SQL Agent job.
>> SSIS has a graphical workflow designer, integrated debugger, rich
>> logging,
>> etc.
>> David
> Thanks David.
> Unfortunately, we're still running SQLServer 2000, and it looks
> like we'd have to upgrade our servers to SQL Server 2005 to
> use SSIS. That may be more expensive and time consuming
> than management would support just for this task.
> Agent also has a graphical user interface, though I'm not sure
> I wouldn't prefer submitting a script. The big advantage of a
> script over a GUI, in my view, is that you can see everything
> that happens in one listing, and if you're running multiple servers
> you can easily move it to all of them. You can also document
> a script with extensive comments.
> However it looks like Microsoft really doesn't want you using
> scripts for this purpose, so we'll probably use the GUI and have
> it generate a script for us to load on multiple servers and to
> store in our documentation safe.
> Regards,
> Alan
>|||Hilary Cotter wrote:
> Its not really documented but you can get some guidance by click on help in
> the job help dialog. Right click on your job and select help is a
> ...
Thanks Hilary.
I also just found this:
http://www.microsoft.com/technet/prodtechnol/sql/2000/books/c12ppcsq.mspx
It seems to give more information than is in the help file.
Alan|||This is a multi-part message in MIME format.
--000609000409020907060701
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
ameyer2@.yahoo.com wrote:
> David Browne wrote:
>> ...
>> I would build your 20-step process in an SSIS package. Then deploy that
>> package as a 1-step SQL Agent job.
>> SSIS has a graphical workflow designer, integrated debugger, rich logging,
>> etc.
>> David
> Thanks David.
> Unfortunately, we're still running SQLServer 2000, and it looks
> like we'd have to upgrade our servers to SQL Server 2005 to
> use SSIS. That may be more expensive and time consuming
> than management would support just for this task.
> Agent also has a graphical user interface, though I'm not sure
> I wouldn't prefer submitting a script. The big advantage of a
> script over a GUI, in my view, is that you can see everything
> that happens in one listing, and if you're running multiple servers
> you can easily move it to all of them. You can also document
> a script with extensive comments.
> However it looks like Microsoft really doesn't want you using
> scripts for this purpose, so we'll probably use the GUI and have
> it generate a script for us to load on multiple servers and to
> store in our documentation safe.
> Regards,
> Alan
>
Hi Alan
Why don't you just create a DTS package and then run this package from
SQL server agent?
I must admit that I'm not quite sure what your problem is because I've
used SQL agent for years for many different purposes and I haven't
really seen that it add things I haven't asked for.
Regards
Steen Schlüter Persson
Databaseadministrator / Systemadministrator
--000609000409020907060701
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<a class="moz-txt-link-abbreviated" href="http://links.10026.com/?link=mailto:ameyer2@.yahoo.com">ameyer2@.yahoo.com</a> wrote:
<blockquote
cite="mid1153261730.359715.126050@.i42g2000cwa.googlegroups.com"
type="cite">
<pre wrap="">David Browne wrote:
</pre>
<blockquote type="cite">
<pre wrap="">...
I would build your 20-step process in an SSIS package. Then deploy that
package as a 1-step SQL Agent job.
SSIS has a graphical workflow designer, integrated debugger, rich logging,
etc.
David
</pre>
</blockquote>
<pre wrap=""><!-->
Thanks David.
Unfortunately, we're still running SQLServer 2000, and it looks
like we'd have to upgrade our servers to SQL Server 2005 to
use SSIS. That may be more expensive and time consuming
than management would support just for this task.
Agent also has a graphical user interface, though I'm not sure
I wouldn't prefer submitting a script. The big advantage of a
script over a GUI, in my view, is that you can see everything
that happens in one listing, and if you're running multiple servers
you can easily move it to all of them. You can also document
a script with extensive comments.
However it looks like Microsoft really doesn't want you using
scripts for this purpose, so we'll probably use the GUI and have
it generate a script for us to load on multiple servers and to
store in our documentation safe.
Regards,
Alan
</pre>
</blockquote>
<font size="-1"><font face="Arial">Hi Alan<br>
<br>
Why don't you just create a DTS package and then run this package from
SQL server agent? <br>
I must admit that I'm not quite sure what your problem is because I've
used SQL agent for years for many different purposes and I haven't
really seen that it add things I haven't asked for.<br>
<br>
<br>
-- <br>
Regards<br>
Steen Schlüter Persson<br>
Databaseadministrator / Systemadministrator<br>
</font></font>
</body>
</html>
--000609000409020907060701--|||Hello Steen. Thank you for the reply
Steen Persson (DK) wrote:
> Why don't you just create a DTS package and then run this package from
> SQL server agent?
Thanks for the suggestion. I will look into that.
> I must admit that I'm not quite sure what your problem is because I've
> used SQL agent for years for many different purposes and I haven't
> really seen that it add things I haven't asked for.
I presume you have mainly used the Agent GUI.
To see what I'm talking about, pick one of your Agent jobs
and export it as a text script, e.g.,
Open Agent.
Select any job
Right click on the job and select "All Tasks" / "Generate SQL
Script..."
Then examine what you get.
If you write your own script and submit it to SQL Server without
using the GUI front end, you can get your new job to show up in
the GUI list of jobs. However if you then use the GUI to generate
a script from it and compare what was generated to what you
input, you might be surprised. I was.
Alan|||This is a multi-part message in MIME format.
--090000090502030800020104
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
ameyer2@.yahoo.com wrote:
> Hello Steen. Thank you for the reply
> Steen Persson (DK) wrote:
>
>> Why don't you just create a DTS package and then run this package from
>> SQL server agent?
> Thanks for the suggestion. I will look into that.
>
>> I must admit that I'm not quite sure what your problem is because I've
>> used SQL agent for years for many different purposes and I haven't
>> really seen that it add things I haven't asked for.
> I presume you have mainly used the Agent GUI.
> To see what I'm talking about, pick one of your Agent jobs
> and export it as a text script, e.g.,
> Open Agent.
> Select any job
> Right click on the job and select "All Tasks" / "Generate SQL
> Script..."
> Then examine what you get.
> If you write your own script and submit it to SQL Server without
> using the GUI front end, you can get your new job to show up in
> the GUI list of jobs. However if you then use the GUI to generate
> a script from it and compare what was generated to what you
> input, you might be surprised. I was.
> Alan
>
Hi Alan
I still don't quite understand what your issue is. It's true that if I
generate a sql script from an existing job, there are more code in it,
but there's nothing I don't expect to be there. There are number of
checks if the job already exist etc. and that's all right for me. If you
don't check for this in your "manual" script you'll get an error if you
try to add a job that already exists so why shouldn't the check be there
when you generate the script?
Regards
Steen Schlüter Persson
Databaseadministrator / Systemadministrator
--090000090502030800020104
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<a class="moz-txt-link-abbreviated" href="http://links.10026.com/?link=mailto:ameyer2@.yahoo.com">ameyer2@.yahoo.com</a> wrote:
<blockquote
cite="mid1153434437.302932.299920@.i42g2000cwa.googlegroups.com"
type="cite">
<pre wrap="">Hello Steen. Thank you for the reply
Steen Persson (DK) wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Why don't you just create a DTS package and then run this package from
SQL server agent?
</pre>
</blockquote>
<pre wrap=""><!-->
Thanks for the suggestion. I will look into that.
</pre>
<blockquote type="cite">
<pre wrap="">I must admit that I'm not quite sure what your problem is because I've
used SQL agent for years for many different purposes and I haven't
really seen that it add things I haven't asked for.
</pre>
</blockquote>
<pre wrap=""><!-->
I presume you have mainly used the Agent GUI.
To see what I'm talking about, pick one of your Agent jobs
and export it as a text script, e.g.,
Open Agent.
Select any job
Right click on the job and select "All Tasks" / "Generate SQL
Script..."
Then examine what you get.
If you write your own script and submit it to SQL Server without
using the GUI front end, you can get your new job to show up in
the GUI list of jobs. However if you then use the GUI to generate
a script from it and compare what was generated to what you
input, you might be surprised. I was.
Alan
</pre>
</blockquote>
<font size="-1"><font face="Arial">Hi Alan<br>
<br>
I still don't quite understand what your issue is. It's true that if I
generate a sql script from an existing job, there are more code in it,
but there's nothing I don't expect to be there. There are number of
checks if the job already exist etc. and that's all right for me. If
you don't check for this in your "manual" script you'll get an error if
you try to add a job that already exists so why shouldn't the check be
there when you generate the script?<br>
<br>
<br>
-- <br>
Regards<br>
Steen Schlüter Persson<br>
Databaseadministrator / Systemadministrator<br>
</font></font>
</body>
</html>
--090000090502030800020104--|||ameyer2@.yahoo.com wrote:
> Hello Steen. Thank you for the reply
> Steen Persson (DK) wrote:
>> Why don't you just create a DTS package and then run this package from
>> SQL server agent?
> Thanks for the suggestion. I will look into that.
>> I must admit that I'm not quite sure what your problem is because I've
>> used SQL agent for years for many different purposes and I haven't
>> really seen that it add things I haven't asked for.
> I presume you have mainly used the Agent GUI.
> To see what I'm talking about, pick one of your Agent jobs
> and export it as a text script, e.g.,
> Open Agent.
> Select any job
> Right click on the job and select "All Tasks" / "Generate SQL
> Script..."
> Then examine what you get.
> If you write your own script and submit it to SQL Server without
> using the GUI front end, you can get your new job to show up in
> the GUI list of jobs. However if you then use the GUI to generate
> a script from it and compare what was generated to what you
> input, you might be surprised. I was.
> Alan
>
Perhaps you should analyze that additional code to determine what it's
doing? Maybe you're missing a step in your own scripts?
--
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Tracy McKibben wrote:
> Perhaps you should analyze that additional code to determine what it's
> doing? Maybe you're missing a step in your own scripts?
>
I have indeed analyzed it. Some of what is there is stuff that either
I don't need because I've done the same thing another way, or
because I just don't need it.
Some is questionable. I'm not in front of SQL Server right now,
but as I recall, it wraps my entire job step in a transaction. That
may be right in the average case but wrong in particular cases
where it could defeat the intent of the programmer.
I can see why this approach by Microsoft has its fans. I'm
just not one of them.
But I didn't create this thread for the purpose of flaming
Microsoft. I recognize the MS has produced many fine
programs, SQL Server among them. I just wanted to know
if anyone knew of any documentation of the things MS does
under the covers of the Agent GUI.
I did find one source of information. See my first posting on
July 19 for the reference. If anyone knows of any other
documentation I'd love to see it.
Thanks.
Alan|||This is a multi-part message in MIME format.
--060304080400040803020408
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
ameyer2@.yahoo.com wrote:
> Tracy McKibben wrote:
>
>> Perhaps you should analyze that additional code to determine what it's
>> doing? Maybe you're missing a step in your own scripts?
>>
> I have indeed analyzed it. Some of what is there is stuff that either
> I don't need because I've done the same thing another way, or
> because I just don't need it.
> Some is questionable. I'm not in front of SQL Server right now,
> but as I recall, it wraps my entire job step in a transaction. That
> may be right in the average case but wrong in particular cases
> where it could defeat the intent of the programmer.
> I can see why this approach by Microsoft has its fans. I'm
> just not one of them.
> But I didn't create this thread for the purpose of flaming
> Microsoft. I recognize the MS has produced many fine
> programs, SQL Server among them. I just wanted to know
> if anyone knew of any documentation of the things MS does
> under the covers of the Agent GUI.
> I did find one source of information. See my first posting on
> July 19 for the reference. If anyone knows of any other
> documentation I'd love to see it.
> Thanks.
> Alan
>
You don't honestly expect that SQL server will produce a script that you
can just dump into some of you own code where you already has done a lot
of the checking that the script include?
When you right click on a job and script it out, SQL server can't do
anything else than produce a "stand-alone" script that can be run like
it is on it's own and then create the job you're asking for. For that
purpose I think it do the job very well and it include the code
necessary to do the job. This will (of course) also include a number of
checks and therefore also wrap it into a transaction that can be rolled
back in case of a failure.
Regards
Steen Schlüter Persson
Databaseadministrator / Systemadministrator
--060304080400040803020408
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<a class="moz-txt-link-abbreviated" href="http://links.10026.com/?link=mailto:ameyer2@.yahoo.com">ameyer2@.yahoo.com</a> wrote:
<blockquote
cite="mid1153622611.152439.140660@.75g2000cwc.googlegroups.com"
type="cite">
<pre wrap="">Tracy McKibben wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Perhaps you should analyze that additional code to determine what it's
doing? Maybe you're missing a step in your own scripts?
</pre>
</blockquote>
<pre wrap=""><!-->I have indeed analyzed it. Some of what is there is stuff that either
I don't need because I've done the same thing another way, or
because I just don't need it.
Some is questionable. I'm not in front of SQL Server right now,
but as I recall, it wraps my entire job step in a transaction. That
may be right in the average case but wrong in particular cases
where it could defeat the intent of the programmer.
I can see why this approach by Microsoft has its fans. I'm
just not one of them.
But I didn't create this thread for the purpose of flaming
Microsoft. I recognize the MS has produced many fine
programs, SQL Server among them. I just wanted to know
if anyone knew of any documentation of the things MS does
under the covers of the Agent GUI.
I did find one source of information. See my first posting on
July 19 for the reference. If anyone knows of any other
documentation I'd love to see it.
Thanks.
Alan
</pre>
</blockquote>
<font size="-1"><font face="Arial">You don't honestly expect that SQL
server will produce a script that you can just dump into some of you
own code where you already has done a lot of the checking that the
script include? <br>
When you right click on a job and script it out, SQL server can't do
anything else than produce a "stand-alone" script that can be run like
it is on it's own and then create the job you're asking for. For that
purpose I think it do the job very well and it include the code
necessary to do the job. This will (of course) also include a number of
checks and therefore also wrap it into a transaction that can be rolled
back in case of a failure.<br>
<br>
<br>
-- <br>
Regards<br>
Steen Schlüter Persson<br>
Databaseadministrator / Systemadministrator<br>
<br>
</font></font>
</body>
</html>
--060304080400040803020408--|||Steen Persson (DK) wrote:
...
> You don't honestly expect that SQL server will produce a script that you
> can just dump into some of you own code where you already has done a lot
> of the checking that the script include?
...
Well, like I say, I'm not here to flame Microsoft or say that what
they've done doesn't meet most people's needs.
For myself, I would like to be able to submit a script to Agent and
have some assurance that what I submitted is exactly what gets
done. If the script has detectable errors, I'd like Agent to report
them to me rather than modify the script.
It may be that Agent does exactly what I tell it to do. Or it may be
that it reads my script, extracts things from it, adds whatever it
wants, and throws my original script away.
Even though I wouldn't like that behavior, it would be fine if
it were documented. My problem, the one that I posted
to start this thread, is that I couldn't find any documentation.
I don't even know whether the script Agent
generates is what it executes, or whether it executes my
script just as I submitted it and generates the script it
generates just for my benefit if I want to use it as the basis
for some other job.
I'm just looking for serious documentation - something beyond
"to do this - click that".
Alan
Good SQL Developer Book.
Hi all,
Can anyone recommend a good SQL Development book (ANSI SQL). I have around 5+ years SQL Development experience.
Thanks in advance.
For beginners:
http://www.amazon.com/Beginning-Transact-SQL-Server-2000-2005/dp/076457955X/ref=pd_bbs_sr_1/102-0659498-3035303?ie=UTF8&s=books&qid=1182949526&sr=1-1
http://www.amazon.com/Professional-Server-2000-Database-Design/dp/1861004761/ref=sr_1_8/102-0659498-3035303?ie=UTF8&s=books&qid=1182949526&sr=1-8
http://www.amazon.com/Programming-Microsoft-SQL-Server-2005/dp/0735619239/ref=pd_sim_b_2_img/102-0659498-3035303?ie=UTF8&coliid=I3JDMGYD5CNWPW&colid=1MIKFZCG52WCA
For more advanced:
http://www.amazon.com/Inside-Microsoft-SQL-Server-2005/dp/0735623139/ref=pd_bxgy_b_img_b/102-0659498-3035303?ie=UTF8&coliid=I3JDMGYD5CNWPW&colid=1MIKFZCG52WCA
http://www.amazon.com/gp/product/0735621977/ref=wl_itt_dp/102-0659498-3035303?ie=UTF8&coliid=I3JDMGYD5CNWPW&colid=1MIKFZCG52WCA
http://www.amazon.com/Inside-Microsoft-SQL-Server-2005/dp/0735621055/ref=pd_sim_b_3_img/102-0659498-3035303?ie=UTF8&coliid=I3JDMGYD5CNWPW&colid=1MIKFZCG52WCA
|||From the perspective of a developer, this is a good book:
A Developer's Guide to SQL Server 2005
(Microsoft .Net Development) (Paperback)
Bob Beauchemin, Dan Sullivan
Addison-Wesley, ISBN: 0321382188
good SQL book?
hello, for a new job i might have to learn SQL. i've never
worked with databases or SQL, so i'll need to learn. can
anybody advice me on what would be a good book to learn
from? i'm quite an experienced programmer, so it doesn't
have to be a dummies guide, and preferably not a bulky book
like the "SQL bible" or something.
worked with databases or SQL, so i'll need to learn. can
anybody advice me on what would be a good book to learn
from? i'm quite an experienced programmer, so it doesn't
have to be a dummies guide, and preferably not a bulky book
like the "SQL bible" or something.
oh, one of my 'favourite' computer books of all times is
"thinking in Java" by bruce eckel, to give you an idea.
mike
--
not sure if there's a better group to ask these questionsmichael nieuwenhuizen wrote:
> hello, for a new job i might have to learn SQL. i've never
> worked with databases or SQL, so i'll need to learn. can
> anybody advice me on what would be a good book to learn
> from? i'm quite an experienced programmer, so it doesn't
> have to be a dummies guide, and preferably not a bulky book
> like the "SQL bible" or something.
> oh, one of my 'favourite' computer books of all times is
> "thinking in Java" by bruce eckel, to give you an idea.
> mike
> --
> not sure if there's a better group to ask these questions
Probably the best of breed is Joe Celko's "SQL For Smarties" but I
wouldn't call it a beginner's book by any stretch of the imagination.
Put it on your list for book number 2 or 3.
Also, remember that TransactSQL is no more generic than is Oracle's
PL/SQL or any other vendor's implementation. So make sure the SQL book
you get is one that is oriented toward the RDBMS on which you will be
working.
--
Daniel Morgan
http://www.outreach.washington.edu/...oad/oad_crs.asp
http://www.outreach.washington.edu/...aoa/aoa_crs.asp
damorgan@.x.washington.edu
(replace 'x' with a 'u' to reply)|||"Daniel Morgan" <damorgan@.x.washington.edu> wrote
> Probably the best of breed is Joe Celko's "SQL For Smarties" but I
> wouldn't call it a beginner's book by any stretch of the imagination.
i actually browsed through that one and it looked pretty impressive ...
and then i saw it wasn;t for the beginner ...
> Put it on your list for book number 2 or 3.
will do. thanks.
> Also, remember that TransactSQL is no more generic than is Oracle's
> PL/SQL or any other vendor's implementation.
i really don't have a clue about SQL. aren't all the SQL's based on
one version?
> So make sure the SQL book you get is one that is oriented toward the
> RDBMS on which you will be working.
it would probably be Oracle.
mike
--
and i have no experience with that either|||michael nieuwenhuizen wrote:
> i really don't have a clue about SQL. aren't all the SQL's based on
> one version?
SQL is an ANSI standard language. But the ANSI standard is not one thing
... it is at least three. And within that standard every vendor has lots
of room to implement that standard by any means they wish. Then they all
add proprietary language extensions to differentiate their product from
the others (more cynical minds would say to lock in their customers).
>>So make sure the SQL book you get is one that is oriented toward the
>>RDBMS on which you will be working.
>
> it would probably be Oracle.
> mike
Then I'd suggest reposting your question in an Oracle usenet group (such
as comp.databases.oracle.server) so that we don't offend our hosts by
being off-topic. But you can find all of the Oracle SQL you could
possibly hope to find at http://tahiti.oracle.com.
--
Daniel Morgan
http://www.outreach.washington.edu/...oad/oad_crs.asp
http://www.outreach.washington.edu/...aoa/aoa_crs.asp
damorgan@.x.washington.edu
(replace 'x' with a 'u' to reply)|||The Guru's Guide to Transact-SQL by Ken Henderson
http://www.amazon.com/exec/obidos/t...536720?v=glance
Good SQL Book
hello
i am just starting to learn sql and know the basics, but now im looking for a good book to learn some more. A book that covers stored procedure would be very useful. If possible a book with q and a would be very good because i feel this tests if u understand what was just explaned. but if there is a good book without this it is ok. All sugestions welcome
NubNub
I'd just go on amazon and search for "T-SQL". Most books will be the same because the underlying concepts are all very similar. Personally I go to the W3's tutorial websites for everything but then again I am too cheap for books.
good performance tuning book
Can someone please recommend a good SQL2k performance tuning book?
sql2k sp3
TIA, ChrisR
_Microsoft SQL Server 2000 Performance Optimization and Tuning Handbook_
by Ken England, Digital Press
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
"ChrisR" <ChrisR@.NoEmails.com> wrote in message
news:eHwfCmGwEHA.536@.TK2MSFTNGP11.phx.gbl...
> Can someone please recommend a good SQL2k performance tuning book?
>
> --
> sql2k sp3
> TIA, ChrisR
>
|||On Mon, 1 Nov 2004 15:21:43 -0800, "ChrisR" <ChrisR@.NoEmails.com>
wrote:
>Can someone please recommend a good SQL2k performance tuning book?
I believe this is the book I was browsing the other day, that seemed
to have some excellent chapters on tuning, not just BOL reprints.
http://search.barnesandnoble.com/Boo...sbn=0672324679
Microsoft SQL Server 2000 Unleashed, 2nd Edition
Ray Rankins, Paul F. Bertucci, Paul Jensen
Pub. Date: December 2002
ISBN: 0672324679
Format: Paperback, 1513pp
Publisher: Pearson Education
Edition Number: 2
J.
sql2k sp3
TIA, ChrisR
_Microsoft SQL Server 2000 Performance Optimization and Tuning Handbook_
by Ken England, Digital Press
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
"ChrisR" <ChrisR@.NoEmails.com> wrote in message
news:eHwfCmGwEHA.536@.TK2MSFTNGP11.phx.gbl...
> Can someone please recommend a good SQL2k performance tuning book?
>
> --
> sql2k sp3
> TIA, ChrisR
>
|||On Mon, 1 Nov 2004 15:21:43 -0800, "ChrisR" <ChrisR@.NoEmails.com>
wrote:
>Can someone please recommend a good SQL2k performance tuning book?
I believe this is the book I was browsing the other day, that seemed
to have some excellent chapters on tuning, not just BOL reprints.
http://search.barnesandnoble.com/Boo...sbn=0672324679
Microsoft SQL Server 2000 Unleashed, 2nd Edition
Ray Rankins, Paul F. Bertucci, Paul Jensen
Pub. Date: December 2002
ISBN: 0672324679
Format: Paperback, 1513pp
Publisher: Pearson Education
Edition Number: 2
J.
good performance tuning book
Can someone please recommend a good SQL2k performance tuning book?
--
sql2k sp3
TIA, ChrisR_Microsoft SQL Server 2000 Performance Optimization and Tuning Handbook_
by Ken England, Digital Press
--
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"ChrisR" <ChrisR@.NoEmails.com> wrote in message
news:eHwfCmGwEHA.536@.TK2MSFTNGP11.phx.gbl...
> Can someone please recommend a good SQL2k performance tuning book?
>
> --
> sql2k sp3
> TIA, ChrisR
>|||On Mon, 1 Nov 2004 15:21:43 -0800, "ChrisR" <ChrisR@.NoEmails.com>
wrote:
>Can someone please recommend a good SQL2k performance tuning book?
I believe this is the book I was browsing the other day, that seemed
to have some excellent chapters on tuning, not just BOL reprints.
http://search.barnesandnoble.com/BookSearch/isbnInquiry.asp?isbn=0672324679
Microsoft SQL Server 2000 Unleashed, 2nd Edition
Ray Rankins, Paul F. Bertucci, Paul Jensen
Pub. Date: December 2002
ISBN: 0672324679
Format: Paperback, 1513pp
Publisher: Pearson Education
Edition Number: 2
J.
--
sql2k sp3
TIA, ChrisR_Microsoft SQL Server 2000 Performance Optimization and Tuning Handbook_
by Ken England, Digital Press
--
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"ChrisR" <ChrisR@.NoEmails.com> wrote in message
news:eHwfCmGwEHA.536@.TK2MSFTNGP11.phx.gbl...
> Can someone please recommend a good SQL2k performance tuning book?
>
> --
> sql2k sp3
> TIA, ChrisR
>|||On Mon, 1 Nov 2004 15:21:43 -0800, "ChrisR" <ChrisR@.NoEmails.com>
wrote:
>Can someone please recommend a good SQL2k performance tuning book?
I believe this is the book I was browsing the other day, that seemed
to have some excellent chapters on tuning, not just BOL reprints.
http://search.barnesandnoble.com/BookSearch/isbnInquiry.asp?isbn=0672324679
Microsoft SQL Server 2000 Unleashed, 2nd Edition
Ray Rankins, Paul F. Bertucci, Paul Jensen
Pub. Date: December 2002
ISBN: 0672324679
Format: Paperback, 1513pp
Publisher: Pearson Education
Edition Number: 2
J.
good performance tuning book
Can someone please recommend a good SQL2k performance tuning book?
sql2k sp3
TIA, ChrisR_Microsoft SQL Server 2000 Performance Optimization and Tuning Handbook_
by Ken England, Digital Press
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"ChrisR" <ChrisR@.NoEmails.com> wrote in message
news:eHwfCmGwEHA.536@.TK2MSFTNGP11.phx.gbl...
> Can someone please recommend a good SQL2k performance tuning book?
>
> --
> sql2k sp3
> TIA, ChrisR
>|||On Mon, 1 Nov 2004 15:21:43 -0800, "ChrisR" <ChrisR@.NoEmails.com>
wrote:
>Can someone please recommend a good SQL2k performance tuning book?
I believe this is the book I was browsing the other day, that seemed
to have some excellent chapters on tuning, not just BOL reprints.
http://search.barnesandnoble.com/Bo...isbn=0672324679
Microsoft SQL Server 2000 Unleashed, 2nd Edition
Ray Rankins, Paul F. Bertucci, Paul Jensen
Pub. Date: December 2002
ISBN: 0672324679
Format: Paperback, 1513pp
Publisher: Pearson Education
Edition Number: 2
J.
sql2k sp3
TIA, ChrisR_Microsoft SQL Server 2000 Performance Optimization and Tuning Handbook_
by Ken England, Digital Press
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"ChrisR" <ChrisR@.NoEmails.com> wrote in message
news:eHwfCmGwEHA.536@.TK2MSFTNGP11.phx.gbl...
> Can someone please recommend a good SQL2k performance tuning book?
>
> --
> sql2k sp3
> TIA, ChrisR
>|||On Mon, 1 Nov 2004 15:21:43 -0800, "ChrisR" <ChrisR@.NoEmails.com>
wrote:
>Can someone please recommend a good SQL2k performance tuning book?
I believe this is the book I was browsing the other day, that seemed
to have some excellent chapters on tuning, not just BOL reprints.
http://search.barnesandnoble.com/Bo...isbn=0672324679
Microsoft SQL Server 2000 Unleashed, 2nd Edition
Ray Rankins, Paul F. Bertucci, Paul Jensen
Pub. Date: December 2002
ISBN: 0672324679
Format: Paperback, 1513pp
Publisher: Pearson Education
Edition Number: 2
J.
Friday, March 9, 2012
good online resources for teaching SQL for SQL server 2000
my freind asked me to look for him for online book or something very good that teach SQL for SQL server 2000 ... what i need is something like hands on examples that will take user from level 1 to level * ... i have seen alot of stuff in google but i think some of you might know what i need and can direct me to better resources as i could not find someting specail !!!Try this link and check the side bar but the best remains download the eval version and use the BOL (books online). Hope this helps.
http://www.mssqlserver.com/tsql/|||thanks Caddre!!
when i see you reply ... i got a feeling that you will meet the expectation ... the link is really great !!
thanks again!
http://www.mssqlserver.com/tsql/|||thanks Caddre!!
when i see you reply ... i got a feeling that you will meet the expectation ... the link is really great !!
thanks again!
good integration services book
ive been learning through books online, but i just find learning from a book is better for me. have any of you bought books on integration services and if so , would you recommend them?
Well, if you did not like it also send me an email.
http://www.packtpub.com/sql-server-integration-services-visual-studio-2005/book
I have "Professional SQL Server 2005 Integration Services". I have not used the book extensively as I am currently extracting from an Oracle source into SQL 2005 and then using stored procs to carry out the ETL.
Most of my advanced work is in SSAS and I would recommend "Applied Microsoft Analysis Services 2005" by Teo Lachev.
|||I agree both books listed previously are excellent. You should also look at "The Microsoft Data Warehouse Toolkit" from Wiley. Much of the book is devoted to SSIS.
Frank
|||I agree that all three books are must haves.
The MS Data Warehouse toolkit is particularly good if you haven't built a warehouse before, because it concentrates much more on the WHATS rather than the HOWS.
You may also want to consider "The Rational Guide to Scripting SQL Server 2005 Integration Services'.
Its not a must have, but can come in handy and is a quick read.
|||The book is great and just attended the class taught by the authors of the MS Datawarehous Toolkit.
Highly recommended.
Mark
spaces.msn.com/mgarnerbi
|||Well you can try my book. It's really for the beginners. If you are an advanced user or trying to do some serious stuff this is not for you. However, you may still find some parts usufl. What else I can say I am the author and I have the most sanguine expectations that it is a helpful book. If you liked it send an email: jkrishnaswamy@.comcast.net.Well, if you did not like it also send me an email.
http://www.packtpub.com/sql-server-integration-services-visual-studio-2005/book
Good Data Modeling Book
I'm looking for a data modeling book for one of the developers on my team.
There are tons of them out there, so I'm hoping for a recommendation. Has
anyone come across a book that does a particularly good job of teaching the
principles of data modeling? The book should cover the basics
(normalization, referential integrity etc.) with examples if possible.
Thank you!
"Web Developer" <WebDeveloper@.discussions.microsoft.com> wrote in message
news:02B5865C-8DCB-46B9-BEC9-FCEB5E5B0088@.microsoft.com...
> I'm looking for a data modeling book for one of the developers on my team.
> There are tons of them out there, so I'm hoping for a recommendation. Has
> anyone come across a book that does a particularly good job of teaching
the
> principles of data modeling? The book should cover the basics
> (normalization, referential integrity etc.) with examples if possible.
> Thank you!
I have always liked:
Database Design For Mere Mortals
ISBN: 0201752840
HTH
Rick Sawtell
MCT, MCSD, MCDBA
|||http://www.amazon.com/exec/obidos/tg...95833?v=glance
Greg Jackson
PDX, Oregon
|||I recommend that as well as a book that explains the basics of databases and
data modelling well. IMO ideal to teach programmers the fundamental
relational ideas and data modelling.
Jacco Schalkwijk
SQL Server MVP
"Rick Sawtell" <r_sawtell@.hotmail.com> wrote in message
news:eQJ%23ybmVFHA.1044@.TK2MSFTNGP10.phx.gbl...
> "Web Developer" <WebDeveloper@.discussions.microsoft.com> wrote in message
> news:02B5865C-8DCB-46B9-BEC9-FCEB5E5B0088@.microsoft.com...
> the
> I have always liked:
> Database Design For Mere Mortals
> ISBN: 0201752840
>
> HTH
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
>
|||Thank you all for your input! That book looks like it will work well.
"pdxJaxon" wrote:
> http://www.amazon.com/exec/obidos/tg...95833?v=glance
>
> Greg Jackson
> PDX, Oregon
>
>
There are tons of them out there, so I'm hoping for a recommendation. Has
anyone come across a book that does a particularly good job of teaching the
principles of data modeling? The book should cover the basics
(normalization, referential integrity etc.) with examples if possible.
Thank you!
"Web Developer" <WebDeveloper@.discussions.microsoft.com> wrote in message
news:02B5865C-8DCB-46B9-BEC9-FCEB5E5B0088@.microsoft.com...
> I'm looking for a data modeling book for one of the developers on my team.
> There are tons of them out there, so I'm hoping for a recommendation. Has
> anyone come across a book that does a particularly good job of teaching
the
> principles of data modeling? The book should cover the basics
> (normalization, referential integrity etc.) with examples if possible.
> Thank you!
I have always liked:
Database Design For Mere Mortals
ISBN: 0201752840
HTH
Rick Sawtell
MCT, MCSD, MCDBA
|||http://www.amazon.com/exec/obidos/tg...95833?v=glance
Greg Jackson
PDX, Oregon
|||I recommend that as well as a book that explains the basics of databases and
data modelling well. IMO ideal to teach programmers the fundamental
relational ideas and data modelling.
Jacco Schalkwijk
SQL Server MVP
"Rick Sawtell" <r_sawtell@.hotmail.com> wrote in message
news:eQJ%23ybmVFHA.1044@.TK2MSFTNGP10.phx.gbl...
> "Web Developer" <WebDeveloper@.discussions.microsoft.com> wrote in message
> news:02B5865C-8DCB-46B9-BEC9-FCEB5E5B0088@.microsoft.com...
> the
> I have always liked:
> Database Design For Mere Mortals
> ISBN: 0201752840
>
> HTH
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
>
|||Thank you all for your input! That book looks like it will work well.
"pdxJaxon" wrote:
> http://www.amazon.com/exec/obidos/tg...95833?v=glance
>
> Greg Jackson
> PDX, Oregon
>
>
Good Data Modeling Book
I'm looking for a data modeling book for one of the developers on my team.
There are tons of them out there, so I'm hoping for a recommendation. Has
anyone come across a book that does a particularly good job of teaching the
principles of data modeling? The book should cover the basics
(normalization, referential integrity etc.) with examples if possible.
Thank you!"Web Developer" <WebDeveloper@.discussions.microsoft.com> wrote in message
news:02B5865C-8DCB-46B9-BEC9-FCEB5E5B0088@.microsoft.com...
> I'm looking for a data modeling book for one of the developers on my team.
> There are tons of them out there, so I'm hoping for a recommendation. Has
> anyone come across a book that does a particularly good job of teaching
the
> principles of data modeling? The book should cover the basics
> (normalization, referential integrity etc.) with examples if possible.
> Thank you!
I have always liked:
Database Design For Mere Mortals
ISBN: 0201752840
HTH
Rick Sawtell
MCT, MCSD, MCDBA|||http://www.amazon.com/exec/obidos/t...=gla
nce
Greg Jackson
PDX, Oregon|||I recommend that as well as a book that explains the basics of databases and
data modelling well. IMO ideal to teach programmers the fundamental
relational ideas and data modelling.
Jacco Schalkwijk
SQL Server MVP
"Rick Sawtell" <r_sawtell@.hotmail.com> wrote in message
news:eQJ%23ybmVFHA.1044@.TK2MSFTNGP10.phx.gbl...
> "Web Developer" <WebDeveloper@.discussions.microsoft.com> wrote in message
> news:02B5865C-8DCB-46B9-BEC9-FCEB5E5B0088@.microsoft.com...
> the
> I have always liked:
> Database Design For Mere Mortals
> ISBN: 0201752840
>
> HTH
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
>|||Thank you all for your input! That book looks like it will work well.
"pdxJaxon" wrote:
> http://www.amazon.com/exec/obidos/t...=g
lance
>
> Greg Jackson
> PDX, Oregon
>
>
There are tons of them out there, so I'm hoping for a recommendation. Has
anyone come across a book that does a particularly good job of teaching the
principles of data modeling? The book should cover the basics
(normalization, referential integrity etc.) with examples if possible.
Thank you!"Web Developer" <WebDeveloper@.discussions.microsoft.com> wrote in message
news:02B5865C-8DCB-46B9-BEC9-FCEB5E5B0088@.microsoft.com...
> I'm looking for a data modeling book for one of the developers on my team.
> There are tons of them out there, so I'm hoping for a recommendation. Has
> anyone come across a book that does a particularly good job of teaching
the
> principles of data modeling? The book should cover the basics
> (normalization, referential integrity etc.) with examples if possible.
> Thank you!
I have always liked:
Database Design For Mere Mortals
ISBN: 0201752840
HTH
Rick Sawtell
MCT, MCSD, MCDBA|||http://www.amazon.com/exec/obidos/t...=gla
nce
Greg Jackson
PDX, Oregon|||I recommend that as well as a book that explains the basics of databases and
data modelling well. IMO ideal to teach programmers the fundamental
relational ideas and data modelling.
Jacco Schalkwijk
SQL Server MVP
"Rick Sawtell" <r_sawtell@.hotmail.com> wrote in message
news:eQJ%23ybmVFHA.1044@.TK2MSFTNGP10.phx.gbl...
> "Web Developer" <WebDeveloper@.discussions.microsoft.com> wrote in message
> news:02B5865C-8DCB-46B9-BEC9-FCEB5E5B0088@.microsoft.com...
> the
> I have always liked:
> Database Design For Mere Mortals
> ISBN: 0201752840
>
> HTH
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
>|||Thank you all for your input! That book looks like it will work well.
"pdxJaxon" wrote:
> http://www.amazon.com/exec/obidos/t...=g
lance
>
> Greg Jackson
> PDX, Oregon
>
>
Good Data Modeling Book
I'm looking for a data modeling book for one of the developers on my team.
There are tons of them out there, so I'm hoping for a recommendation. Has
anyone come across a book that does a particularly good job of teaching the
principles of data modeling? The book should cover the basics
(normalization, referential integrity etc.) with examples if possible.
Thank you!"Web Developer" <WebDeveloper@.discussions.microsoft.com> wrote in message
news:02B5865C-8DCB-46B9-BEC9-FCEB5E5B0088@.microsoft.com...
> I'm looking for a data modeling book for one of the developers on my team.
> There are tons of them out there, so I'm hoping for a recommendation. Has
> anyone come across a book that does a particularly good job of teaching
the
> principles of data modeling? The book should cover the basics
> (normalization, referential integrity etc.) with examples if possible.
> Thank you!
I have always liked:
Database Design For Mere Mortals
ISBN: 0201752840
HTH
Rick Sawtell
MCT, MCSD, MCDBA|||http://www.amazon.com/exec/obidos/tg/detail/-/0201694719/103-1555449-1395833?v=glance
Greg Jackson
PDX, Oregon|||I recommend that as well as a book that explains the basics of databases and
data modelling well. IMO ideal to teach programmers the fundamental
relational ideas and data modelling.
--
Jacco Schalkwijk
SQL Server MVP
"Rick Sawtell" <r_sawtell@.hotmail.com> wrote in message
news:eQJ%23ybmVFHA.1044@.TK2MSFTNGP10.phx.gbl...
> "Web Developer" <WebDeveloper@.discussions.microsoft.com> wrote in message
> news:02B5865C-8DCB-46B9-BEC9-FCEB5E5B0088@.microsoft.com...
>> I'm looking for a data modeling book for one of the developers on my
>> team.
>> There are tons of them out there, so I'm hoping for a recommendation.
>> Has
>> anyone come across a book that does a particularly good job of teaching
> the
>> principles of data modeling? The book should cover the basics
>> (normalization, referential integrity etc.) with examples if possible.
>> Thank you!
> I have always liked:
> Database Design For Mere Mortals
> ISBN: 0201752840
>
> HTH
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
>|||Thank you all for your input! That book looks like it will work well.
"pdxJaxon" wrote:
> http://www.amazon.com/exec/obidos/tg/detail/-/0201694719/103-1555449-1395833?v=glance
>
> Greg Jackson
> PDX, Oregon
>
>
There are tons of them out there, so I'm hoping for a recommendation. Has
anyone come across a book that does a particularly good job of teaching the
principles of data modeling? The book should cover the basics
(normalization, referential integrity etc.) with examples if possible.
Thank you!"Web Developer" <WebDeveloper@.discussions.microsoft.com> wrote in message
news:02B5865C-8DCB-46B9-BEC9-FCEB5E5B0088@.microsoft.com...
> I'm looking for a data modeling book for one of the developers on my team.
> There are tons of them out there, so I'm hoping for a recommendation. Has
> anyone come across a book that does a particularly good job of teaching
the
> principles of data modeling? The book should cover the basics
> (normalization, referential integrity etc.) with examples if possible.
> Thank you!
I have always liked:
Database Design For Mere Mortals
ISBN: 0201752840
HTH
Rick Sawtell
MCT, MCSD, MCDBA|||http://www.amazon.com/exec/obidos/tg/detail/-/0201694719/103-1555449-1395833?v=glance
Greg Jackson
PDX, Oregon|||I recommend that as well as a book that explains the basics of databases and
data modelling well. IMO ideal to teach programmers the fundamental
relational ideas and data modelling.
--
Jacco Schalkwijk
SQL Server MVP
"Rick Sawtell" <r_sawtell@.hotmail.com> wrote in message
news:eQJ%23ybmVFHA.1044@.TK2MSFTNGP10.phx.gbl...
> "Web Developer" <WebDeveloper@.discussions.microsoft.com> wrote in message
> news:02B5865C-8DCB-46B9-BEC9-FCEB5E5B0088@.microsoft.com...
>> I'm looking for a data modeling book for one of the developers on my
>> team.
>> There are tons of them out there, so I'm hoping for a recommendation.
>> Has
>> anyone come across a book that does a particularly good job of teaching
> the
>> principles of data modeling? The book should cover the basics
>> (normalization, referential integrity etc.) with examples if possible.
>> Thank you!
> I have always liked:
> Database Design For Mere Mortals
> ISBN: 0201752840
>
> HTH
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
>|||Thank you all for your input! That book looks like it will work well.
"pdxJaxon" wrote:
> http://www.amazon.com/exec/obidos/tg/detail/-/0201694719/103-1555449-1395833?v=glance
>
> Greg Jackson
> PDX, Oregon
>
>
Good Book on SQL Server Reporting Services Script
Hello, I recently discovered the rs.exe utility and .rss files. I have
looked at and enjoyed the sample scripts, but was wondering if there were any
books on this subject that anyone has found useful?
Thanks in advance!
TimTim,
That is a hard one, as all of the books out there do not talk much to the
rs.exe utility, but there is one site www.sqldbatips.com has a tool that can
help out a ton: Reporting Services Scripter.
I also have a method to debug rss scripts.
In Visual Studio
1. Create a new Visual Basic Console Application Project: name it RSDebug
2. In the Soultion Explorer window - right click on the RSDebug Project and
select the Add Web Reference option.
3. In the URL text box add:
http://servername/reportserver/reportservice2005.asmx
4. Click Go Command Button (This step takes a while)
5. In the Web Reference Name text box add SSRSWebService
6. Click Add Reference Command Button
7. In the Code Window above the Module Module1 add:
Imports RSDebug.SSRSWebService
Imports System.Web.Services.Protocols
8. Below the Module Module1 add: Public rs As New ReportingService2005
9. Paste your script code in the Sub Main() procedure
10. Set your breakpoint and go.
Example: (In this example System.IO is needed due to the use of the
MemoryStream object)
Imports RSDebug.SSRSWebService
Imports System.Web.Services.Protocols
Imports System.IO ' This was added because MemoryStream was used
Module Module1
Public rs As New ReportingService2005
Sub Main()
Dim strObjectName As String = "Report Name"
Dim strObjectPath As String = "/Application"
Dim strObjectFullPath As String = strObjectPath & "/" & strObjectName
Dim strLocalFile As String = "Report Name.rdl"
Dim strLocalPath As String = "C:\"
Dim strLocalFullPath As String = strLocalPath & strLocalFile
Dim objReportDefinition As Byte()
Dim objMemoryStream As MemoryStream
Dim objDocument As New System.Xml.XmlDocument()
Try
rs.Credentials = System.Net.CredentialCache.DefaultCredentials
objReportDefinition = rs.GetReportDefinition(strObjectFullPath)
objMemoryStream = New MemoryStream(objReportDefinition)
objDocument.Load(objMemoryStream)
objDocument.Save(strLocalFullPath)
Console.WriteLine("Standard: Report downloaded successfully.")
Catch e As SoapException
Console.WriteLine("Error: " +
e.Detail.Item("ErrorCode").InnerText + " (" +
e.Detail.Item("Message").InnerText + ")")
End Try
End Sub
End Module|||Thanks very much Reeves, this is great information.
Tim
"Reeves Smith" wrote:
> Tim,
> That is a hard one, as all of the books out there do not talk much to the
> rs.exe utility, but there is one site www.sqldbatips.com has a tool that can
> help out a ton: Reporting Services Scripter.
> I also have a method to debug rss scripts.
> In Visual Studio
> 1. Create a new Visual Basic Console Application Project: name it RSDebug
> 2. In the Soultion Explorer window - right click on the RSDebug Project and
> select the Add Web Reference option.
> 3. In the URL text box add:
> http://servername/reportserver/reportservice2005.asmx
> 4. Click Go Command Button (This step takes a while)
> 5. In the Web Reference Name text box add SSRSWebService
> 6. Click Add Reference Command Button
> 7. In the Code Window above the Module Module1 add:
> Imports RSDebug.SSRSWebService
> Imports System.Web.Services.Protocols
> 8. Below the Module Module1 add: Public rs As New ReportingService2005
> 9. Paste your script code in the Sub Main() procedure
> 10. Set your breakpoint and go.
>
> Example: (In this example System.IO is needed due to the use of the
> MemoryStream object)
>
> Imports RSDebug.SSRSWebService
> Imports System.Web.Services.Protocols
>
> Imports System.IO ' This was added because MemoryStream was used
>
> Module Module1
> Public rs As New ReportingService2005
>
> Sub Main()
> Dim strObjectName As String = "Report Name"
> Dim strObjectPath As String = "/Application"
> Dim strObjectFullPath As String = strObjectPath & "/" & strObjectName
> Dim strLocalFile As String = "Report Name.rdl"
> Dim strLocalPath As String = "C:\"
> Dim strLocalFullPath As String = strLocalPath & strLocalFile
> Dim objReportDefinition As Byte()
> Dim objMemoryStream As MemoryStream
> Dim objDocument As New System.Xml.XmlDocument()
>
> Try
> rs.Credentials = System.Net.CredentialCache.DefaultCredentials
> objReportDefinition = rs.GetReportDefinition(strObjectFullPath)
> objMemoryStream = New MemoryStream(objReportDefinition)
> objDocument.Load(objMemoryStream)
> objDocument.Save(strLocalFullPath)
> Console.WriteLine("Standard: Report downloaded successfully.")
> Catch e As SoapException
> Console.WriteLine("Error: " +
> e.Detail.Item("ErrorCode").InnerText + " (" +
> e.Detail.Item("Message").InnerText + ")")
> End Try
> End Sub
> End Module|||On Aug 7, 7:58 pm, TimS <timsts...@.msn.com(donotspam)> wrote:
> Thanks very much Reeves, this is great information.
> Tim
> "Reeves Smith" wrote:
> > Tim,
> > That is a hard one, as all of the books out there do not talk much to the
> > rs.exe utility, but there is one sitewww.sqldbatips.comhas a tool that can
> > help out a ton: Reporting Services Scripter.
> > I also have a method to debug rss scripts.
> > In Visual Studio
> > 1. Create a new Visual Basic Console Application Project: name it RSDebug
> > 2. In the Soultion Explorer window - right click on the RSDebug Project and
> > select the Add Web Reference option.
> > 3. In the URL text box add:
> >http://servername/reportserver/reportservice2005.asmx
> > 4. Click Go Command Button (This step takes a while)
> > 5. In the Web Reference Name text box add SSRSWebService
> > 6. Click Add Reference Command Button
> > 7. In the Code Window above the Module Module1 add:
> > Imports RSDebug.SSRSWebService
> > Imports System.Web.Services.Protocols
> > 8. Below the Module Module1 add: Public rs As New ReportingService2005
> > 9. Paste your script code in the Sub Main() procedure
> > 10. Set your breakpoint and go.
> > Example: (In this example System.IO is needed due to the use of the
> > MemoryStream object)
> > Imports RSDebug.SSRSWebService
> > Imports System.Web.Services.Protocols
> > Imports System.IO ' This was added because MemoryStream was used
> > Module Module1
> > Public rs As New ReportingService2005
> > Sub Main()
> > Dim strObjectName As String = "Report Name"
> > Dim strObjectPath As String = "/Application"
> > Dim strObjectFullPath As String = strObjectPath & "/" & strObjectName
> > Dim strLocalFile As String = "Report Name.rdl"
> > Dim strLocalPath As String = "C:\"
> > Dim strLocalFullPath As String = strLocalPath & strLocalFile
> > Dim objReportDefinition As Byte()
> > Dim objMemoryStream As MemoryStream
> > Dim objDocument As New System.Xml.XmlDocument()
> > Try
> > rs.Credentials = System.Net.CredentialCache.DefaultCredentials
> > objReportDefinition = rs.GetReportDefinition(strObjectFullPath)
> > objMemoryStream = New MemoryStream(objReportDefinition)
> > objDocument.Load(objMemoryStream)
> > objDocument.Save(strLocalFullPath)
> > Console.WriteLine("Standard: Report downloaded successfully.")
> > Catch e As SoapException
> > Console.WriteLine("Error: " +
> > e.Detail.Item("ErrorCode").InnerText + " (" +
> > e.Detail.Item("Message").InnerText + ")")
> > End Try
> > End Sub
> > End Module
I ordered Microsoft's new books for the MCITP certification program in
Business Intelligence. One covers the 70-445 exam and the other one
the 70-446 exam. I'm sure you'll find them very useful (once they're
published anyways!).
http://www.amazon.com/MCTS-Self-Paced-Training-Exam-70-445/dp/0735623414/ref=pd_bbs_1/102-9922975-8902553?ie=UTF8&s=books&qid=1186575878&sr=8-1
http://www.amazon.com/MCITP-Self-Paced-Training-Exam-70-446/dp/0735623848/ref=pd_bbs_2/102-9922975-8902553?ie=UTF8&s=books&qid=1186575878&sr=8-2
looked at and enjoyed the sample scripts, but was wondering if there were any
books on this subject that anyone has found useful?
Thanks in advance!
TimTim,
That is a hard one, as all of the books out there do not talk much to the
rs.exe utility, but there is one site www.sqldbatips.com has a tool that can
help out a ton: Reporting Services Scripter.
I also have a method to debug rss scripts.
In Visual Studio
1. Create a new Visual Basic Console Application Project: name it RSDebug
2. In the Soultion Explorer window - right click on the RSDebug Project and
select the Add Web Reference option.
3. In the URL text box add:
http://servername/reportserver/reportservice2005.asmx
4. Click Go Command Button (This step takes a while)
5. In the Web Reference Name text box add SSRSWebService
6. Click Add Reference Command Button
7. In the Code Window above the Module Module1 add:
Imports RSDebug.SSRSWebService
Imports System.Web.Services.Protocols
8. Below the Module Module1 add: Public rs As New ReportingService2005
9. Paste your script code in the Sub Main() procedure
10. Set your breakpoint and go.
Example: (In this example System.IO is needed due to the use of the
MemoryStream object)
Imports RSDebug.SSRSWebService
Imports System.Web.Services.Protocols
Imports System.IO ' This was added because MemoryStream was used
Module Module1
Public rs As New ReportingService2005
Sub Main()
Dim strObjectName As String = "Report Name"
Dim strObjectPath As String = "/Application"
Dim strObjectFullPath As String = strObjectPath & "/" & strObjectName
Dim strLocalFile As String = "Report Name.rdl"
Dim strLocalPath As String = "C:\"
Dim strLocalFullPath As String = strLocalPath & strLocalFile
Dim objReportDefinition As Byte()
Dim objMemoryStream As MemoryStream
Dim objDocument As New System.Xml.XmlDocument()
Try
rs.Credentials = System.Net.CredentialCache.DefaultCredentials
objReportDefinition = rs.GetReportDefinition(strObjectFullPath)
objMemoryStream = New MemoryStream(objReportDefinition)
objDocument.Load(objMemoryStream)
objDocument.Save(strLocalFullPath)
Console.WriteLine("Standard: Report downloaded successfully.")
Catch e As SoapException
Console.WriteLine("Error: " +
e.Detail.Item("ErrorCode").InnerText + " (" +
e.Detail.Item("Message").InnerText + ")")
End Try
End Sub
End Module|||Thanks very much Reeves, this is great information.
Tim
"Reeves Smith" wrote:
> Tim,
> That is a hard one, as all of the books out there do not talk much to the
> rs.exe utility, but there is one site www.sqldbatips.com has a tool that can
> help out a ton: Reporting Services Scripter.
> I also have a method to debug rss scripts.
> In Visual Studio
> 1. Create a new Visual Basic Console Application Project: name it RSDebug
> 2. In the Soultion Explorer window - right click on the RSDebug Project and
> select the Add Web Reference option.
> 3. In the URL text box add:
> http://servername/reportserver/reportservice2005.asmx
> 4. Click Go Command Button (This step takes a while)
> 5. In the Web Reference Name text box add SSRSWebService
> 6. Click Add Reference Command Button
> 7. In the Code Window above the Module Module1 add:
> Imports RSDebug.SSRSWebService
> Imports System.Web.Services.Protocols
> 8. Below the Module Module1 add: Public rs As New ReportingService2005
> 9. Paste your script code in the Sub Main() procedure
> 10. Set your breakpoint and go.
>
> Example: (In this example System.IO is needed due to the use of the
> MemoryStream object)
>
> Imports RSDebug.SSRSWebService
> Imports System.Web.Services.Protocols
>
> Imports System.IO ' This was added because MemoryStream was used
>
> Module Module1
> Public rs As New ReportingService2005
>
> Sub Main()
> Dim strObjectName As String = "Report Name"
> Dim strObjectPath As String = "/Application"
> Dim strObjectFullPath As String = strObjectPath & "/" & strObjectName
> Dim strLocalFile As String = "Report Name.rdl"
> Dim strLocalPath As String = "C:\"
> Dim strLocalFullPath As String = strLocalPath & strLocalFile
> Dim objReportDefinition As Byte()
> Dim objMemoryStream As MemoryStream
> Dim objDocument As New System.Xml.XmlDocument()
>
> Try
> rs.Credentials = System.Net.CredentialCache.DefaultCredentials
> objReportDefinition = rs.GetReportDefinition(strObjectFullPath)
> objMemoryStream = New MemoryStream(objReportDefinition)
> objDocument.Load(objMemoryStream)
> objDocument.Save(strLocalFullPath)
> Console.WriteLine("Standard: Report downloaded successfully.")
> Catch e As SoapException
> Console.WriteLine("Error: " +
> e.Detail.Item("ErrorCode").InnerText + " (" +
> e.Detail.Item("Message").InnerText + ")")
> End Try
> End Sub
> End Module|||On Aug 7, 7:58 pm, TimS <timsts...@.msn.com(donotspam)> wrote:
> Thanks very much Reeves, this is great information.
> Tim
> "Reeves Smith" wrote:
> > Tim,
> > That is a hard one, as all of the books out there do not talk much to the
> > rs.exe utility, but there is one sitewww.sqldbatips.comhas a tool that can
> > help out a ton: Reporting Services Scripter.
> > I also have a method to debug rss scripts.
> > In Visual Studio
> > 1. Create a new Visual Basic Console Application Project: name it RSDebug
> > 2. In the Soultion Explorer window - right click on the RSDebug Project and
> > select the Add Web Reference option.
> > 3. In the URL text box add:
> >http://servername/reportserver/reportservice2005.asmx
> > 4. Click Go Command Button (This step takes a while)
> > 5. In the Web Reference Name text box add SSRSWebService
> > 6. Click Add Reference Command Button
> > 7. In the Code Window above the Module Module1 add:
> > Imports RSDebug.SSRSWebService
> > Imports System.Web.Services.Protocols
> > 8. Below the Module Module1 add: Public rs As New ReportingService2005
> > 9. Paste your script code in the Sub Main() procedure
> > 10. Set your breakpoint and go.
> > Example: (In this example System.IO is needed due to the use of the
> > MemoryStream object)
> > Imports RSDebug.SSRSWebService
> > Imports System.Web.Services.Protocols
> > Imports System.IO ' This was added because MemoryStream was used
> > Module Module1
> > Public rs As New ReportingService2005
> > Sub Main()
> > Dim strObjectName As String = "Report Name"
> > Dim strObjectPath As String = "/Application"
> > Dim strObjectFullPath As String = strObjectPath & "/" & strObjectName
> > Dim strLocalFile As String = "Report Name.rdl"
> > Dim strLocalPath As String = "C:\"
> > Dim strLocalFullPath As String = strLocalPath & strLocalFile
> > Dim objReportDefinition As Byte()
> > Dim objMemoryStream As MemoryStream
> > Dim objDocument As New System.Xml.XmlDocument()
> > Try
> > rs.Credentials = System.Net.CredentialCache.DefaultCredentials
> > objReportDefinition = rs.GetReportDefinition(strObjectFullPath)
> > objMemoryStream = New MemoryStream(objReportDefinition)
> > objDocument.Load(objMemoryStream)
> > objDocument.Save(strLocalFullPath)
> > Console.WriteLine("Standard: Report downloaded successfully.")
> > Catch e As SoapException
> > Console.WriteLine("Error: " +
> > e.Detail.Item("ErrorCode").InnerText + " (" +
> > e.Detail.Item("Message").InnerText + ")")
> > End Try
> > End Sub
> > End Module
I ordered Microsoft's new books for the MCITP certification program in
Business Intelligence. One covers the 70-445 exam and the other one
the 70-446 exam. I'm sure you'll find them very useful (once they're
published anyways!).
http://www.amazon.com/MCTS-Self-Paced-Training-Exam-70-445/dp/0735623414/ref=pd_bbs_1/102-9922975-8902553?ie=UTF8&s=books&qid=1186575878&sr=8-1
http://www.amazon.com/MCITP-Self-Paced-Training-Exam-70-446/dp/0735623848/ref=pd_bbs_2/102-9922975-8902553?ie=UTF8&s=books&qid=1186575878&sr=8-2
good book on sql server
Hope to be in the right newsgroup for this post. Can someone recommend a
good book on sql server programming (2000 and +)? I had a very bad
experience w/ one MS Press series book, so I would rather stay away from
them, but any suggestions are welcome. The ideal candidate would be
intermediate to advanced level, w/ many practical examples on T-SQL, DDL,
DML.
TIAAlto,
Question:
Which SQL Server book should I buy?
Answer:
Consider the following:
The Guru's Guide to Transact-SQL
by Ken Henderson
http://www.amazon.com/exec/obidos/t...=glance&s=books
Professional SQL Server 2000 Programming
by Robert Vieira
http://www.amazon.com/exec/obidos/t...=glance&s=books
Inside Microsoft SQL Server 2000
by Kalen Delaney
http://www.amazon.com/exec/obidos/t...=glance&s=books
Microsoft SQL Server 2000 Unleashed (2nd Edition)
by Ray Rankins, Paul Jensen, Paul Bertucci
http://www.amazon.com/exec/obidos/t...=glance&s=books
Microsoft SQL Server 2000 Bible
by Paul Nielsen
http://www.amazon.com/exec/obidos/t...=gla
nce
For absolute beginners, also consider:
Sams Teach Yourself Microsoft SQL Server 2000 in 21 Days
by Richard Waymire
http://www.amazon.com/exec/obidos/t...=books&n=507846
Database Design for Mere Mortals
by Michael Hernandez
http://www.amazon.com/exec/obidos/t...=books&n=507846
HTH
Jerry
"alto" <altodorov@.hotmail.com> wrote in message
news:%231uivCpzFHA.2792@.tk2msftngp13.phx.gbl...
> Hope to be in the right newsgroup for this post. Can someone recommend a
> good book on sql server programming (2000 and +)? I had a very bad
> experience w/ one MS Press series book, so I would rather stay away from
> them, but any suggestions are welcome. The ideal candidate would be
> intermediate to advanced level, w/ many practical examples on T-SQL, DDL,
> DML.
> TIA
>|||1b46b6e12524e645" target="_blank">http://groups.google.com/group/micr...b46b6e12524e645
----
--
“I sense many useless updates in you... Useless updates lead to
defragmentation... Defragmentation leads to downtime...Downtime leads to
suffering..Defragmentation is the path to the darkside.. DBCC INDEXDEFRAG an
d
DBCC DBREINDEX are the force...May the force be with you" --
http://sqlservercode.blogspot.com/
"alto" wrote:
> Hope to be in the right newsgroup for this post. Can someone recommend a
> good book on sql server programming (2000 and +)? I had a very bad
> experience w/ one MS Press series book, so I would rather stay away from
> them, but any suggestions are welcome. The ideal candidate would be
> intermediate to advanced level, w/ many practical examples on T-SQL, DDL,
> DML.
> TIA
>
>|||http://vyaskn.tripod.com/sqlbooks.htm
AMB
"alto" wrote:
> Hope to be in the right newsgroup for this post. Can someone recommend a
> good book on sql server programming (2000 and +)? I had a very bad
> experience w/ one MS Press series book, so I would rather stay away from
> them, but any suggestions are welcome. The ideal candidate would be
> intermediate to advanced level, w/ many practical examples on T-SQL, DDL,
> DML.
> TIA
>
>
good book on sql server programming (2000 and +)? I had a very bad
experience w/ one MS Press series book, so I would rather stay away from
them, but any suggestions are welcome. The ideal candidate would be
intermediate to advanced level, w/ many practical examples on T-SQL, DDL,
DML.
TIAAlto,
Question:
Which SQL Server book should I buy?
Answer:
Consider the following:
The Guru's Guide to Transact-SQL
by Ken Henderson
http://www.amazon.com/exec/obidos/t...=glance&s=books
Professional SQL Server 2000 Programming
by Robert Vieira
http://www.amazon.com/exec/obidos/t...=glance&s=books
Inside Microsoft SQL Server 2000
by Kalen Delaney
http://www.amazon.com/exec/obidos/t...=glance&s=books
Microsoft SQL Server 2000 Unleashed (2nd Edition)
by Ray Rankins, Paul Jensen, Paul Bertucci
http://www.amazon.com/exec/obidos/t...=glance&s=books
Microsoft SQL Server 2000 Bible
by Paul Nielsen
http://www.amazon.com/exec/obidos/t...=gla
nce
For absolute beginners, also consider:
Sams Teach Yourself Microsoft SQL Server 2000 in 21 Days
by Richard Waymire
http://www.amazon.com/exec/obidos/t...=books&n=507846
Database Design for Mere Mortals
by Michael Hernandez
http://www.amazon.com/exec/obidos/t...=books&n=507846
HTH
Jerry
"alto" <altodorov@.hotmail.com> wrote in message
news:%231uivCpzFHA.2792@.tk2msftngp13.phx.gbl...
> Hope to be in the right newsgroup for this post. Can someone recommend a
> good book on sql server programming (2000 and +)? I had a very bad
> experience w/ one MS Press series book, so I would rather stay away from
> them, but any suggestions are welcome. The ideal candidate would be
> intermediate to advanced level, w/ many practical examples on T-SQL, DDL,
> DML.
> TIA
>|||1b46b6e12524e645" target="_blank">http://groups.google.com/group/micr...b46b6e12524e645
----
--
“I sense many useless updates in you... Useless updates lead to
defragmentation... Defragmentation leads to downtime...Downtime leads to
suffering..Defragmentation is the path to the darkside.. DBCC INDEXDEFRAG an
d
DBCC DBREINDEX are the force...May the force be with you" --
http://sqlservercode.blogspot.com/
"alto" wrote:
> Hope to be in the right newsgroup for this post. Can someone recommend a
> good book on sql server programming (2000 and +)? I had a very bad
> experience w/ one MS Press series book, so I would rather stay away from
> them, but any suggestions are welcome. The ideal candidate would be
> intermediate to advanced level, w/ many practical examples on T-SQL, DDL,
> DML.
> TIA
>
>|||http://vyaskn.tripod.com/sqlbooks.htm
AMB
"alto" wrote:
> Hope to be in the right newsgroup for this post. Can someone recommend a
> good book on sql server programming (2000 and +)? I had a very bad
> experience w/ one MS Press series book, so I would rather stay away from
> them, but any suggestions are welcome. The ideal candidate would be
> intermediate to advanced level, w/ many practical examples on T-SQL, DDL,
> DML.
> TIA
>
>
good book on SQL Serever 2000 administration
Hi admins,
Could you guys pls recommend very good book on administration which goes
deeply into details, covers all aspects, and would be useful from practical
point of view.
Thanks a lot in advance.
Alex
The SQL Server 2000 Resource Kit is a good admin type book. Unfortunately I
think it's out of print so the CD ROM isn't available anymore. But the
chapters are online.
http://www.microsoft.com/resources/d...s/default.mspx
Alex wrote:
> Hi admins,
> Could you guys pls recommend very good book on administration which
> goes deeply into details, covers all aspects, and would be useful
> from practical point of view.
>
> Thanks a lot in advance.
> Alex
|||SQL Server 2000 Fast Answers for SQL Server DBA and Developer is a good book
for novice DBAs. You can find more info about this book at:
Book review: SQL Server 2000 Fast Answers for DBAs and Developers
http://vyaskn.tripod.com/sql_server_...st_answers.htm
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Alex" <alex_removethis_@.healthmetrx.com> wrote in message
news:10l3eisi7289hf3@.corp.supernews.com...
> Hi admins,
> Could you guys pls recommend very good book on administration which goes
> deeply into details, covers all aspects, and would be useful from
practical
> point of view.
>
> Thanks a lot in advance.
> Alex
>
|||Thaks a lor for reference
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:u6lzcOOoEHA.132@.TK2MSFTNGP14.phx.gbl...
> SQL Server 2000 Fast Answers for SQL Server DBA and Developer is a good
book
> for novice DBAs. You can find more info about this book at:
> Book review: SQL Server 2000 Fast Answers for DBAs and Developers
> http://vyaskn.tripod.com/sql_server_...st_answers.htm
> --
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Alex" <alex_removethis_@.healthmetrx.com> wrote in message
> news:10l3eisi7289hf3@.corp.supernews.com...
> practical
>
Could you guys pls recommend very good book on administration which goes
deeply into details, covers all aspects, and would be useful from practical
point of view.
Thanks a lot in advance.
Alex
The SQL Server 2000 Resource Kit is a good admin type book. Unfortunately I
think it's out of print so the CD ROM isn't available anymore. But the
chapters are online.
http://www.microsoft.com/resources/d...s/default.mspx
Alex wrote:
> Hi admins,
> Could you guys pls recommend very good book on administration which
> goes deeply into details, covers all aspects, and would be useful
> from practical point of view.
>
> Thanks a lot in advance.
> Alex
|||SQL Server 2000 Fast Answers for SQL Server DBA and Developer is a good book
for novice DBAs. You can find more info about this book at:
Book review: SQL Server 2000 Fast Answers for DBAs and Developers
http://vyaskn.tripod.com/sql_server_...st_answers.htm
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Alex" <alex_removethis_@.healthmetrx.com> wrote in message
news:10l3eisi7289hf3@.corp.supernews.com...
> Hi admins,
> Could you guys pls recommend very good book on administration which goes
> deeply into details, covers all aspects, and would be useful from
practical
> point of view.
>
> Thanks a lot in advance.
> Alex
>
|||Thaks a lor for reference
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:u6lzcOOoEHA.132@.TK2MSFTNGP14.phx.gbl...
> SQL Server 2000 Fast Answers for SQL Server DBA and Developer is a good
book
> for novice DBAs. You can find more info about this book at:
> Book review: SQL Server 2000 Fast Answers for DBAs and Developers
> http://vyaskn.tripod.com/sql_server_...st_answers.htm
> --
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Alex" <alex_removethis_@.healthmetrx.com> wrote in message
> news:10l3eisi7289hf3@.corp.supernews.com...
> practical
>
Wednesday, March 7, 2012
good book on SQL Serever 2000 administration
Hi admins,
Could you guys pls recommend very good book on administration which goes
deeply into details, covers all aspects, and would be useful from practical
point of view.
Thanks a lot in advance.
AlexThe SQL Server 2000 Resource Kit is a good admin type book. Unfortunately I
think it's out of print so the CD ROM isn't available anymore. But the
chapters are online.
http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/default.mspx
Alex wrote:
> Hi admins,
> Could you guys pls recommend very good book on administration which
> goes deeply into details, covers all aspects, and would be useful
> from practical point of view.
>
> Thanks a lot in advance.
> Alex|||SQL Server 2000 Fast Answers for SQL Server DBA and Developer is a good book
for novice DBAs. You can find more info about this book at:
Book review: SQL Server 2000 Fast Answers for DBAs and Developers
http://vyaskn.tripod.com/sql_server_2000_fast_answers.htm
--
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Alex" <alex_removethis_@.healthmetrx.com> wrote in message
news:10l3eisi7289hf3@.corp.supernews.com...
> Hi admins,
> Could you guys pls recommend very good book on administration which goes
> deeply into details, covers all aspects, and would be useful from
practical
> point of view.
>
> Thanks a lot in advance.
> Alex
>|||Thaks a lor for reference
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:u6lzcOOoEHA.132@.TK2MSFTNGP14.phx.gbl...
> SQL Server 2000 Fast Answers for SQL Server DBA and Developer is a good
book
> for novice DBAs. You can find more info about this book at:
> Book review: SQL Server 2000 Fast Answers for DBAs and Developers
> http://vyaskn.tripod.com/sql_server_2000_fast_answers.htm
> --
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Alex" <alex_removethis_@.healthmetrx.com> wrote in message
> news:10l3eisi7289hf3@.corp.supernews.com...
> > Hi admins,
> >
> > Could you guys pls recommend very good book on administration which goes
> > deeply into details, covers all aspects, and would be useful from
> practical
> > point of view.
> >
> >
> > Thanks a lot in advance.
> >
> > Alex
> >
> >
>
Could you guys pls recommend very good book on administration which goes
deeply into details, covers all aspects, and would be useful from practical
point of view.
Thanks a lot in advance.
AlexThe SQL Server 2000 Resource Kit is a good admin type book. Unfortunately I
think it's out of print so the CD ROM isn't available anymore. But the
chapters are online.
http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/default.mspx
Alex wrote:
> Hi admins,
> Could you guys pls recommend very good book on administration which
> goes deeply into details, covers all aspects, and would be useful
> from practical point of view.
>
> Thanks a lot in advance.
> Alex|||SQL Server 2000 Fast Answers for SQL Server DBA and Developer is a good book
for novice DBAs. You can find more info about this book at:
Book review: SQL Server 2000 Fast Answers for DBAs and Developers
http://vyaskn.tripod.com/sql_server_2000_fast_answers.htm
--
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Alex" <alex_removethis_@.healthmetrx.com> wrote in message
news:10l3eisi7289hf3@.corp.supernews.com...
> Hi admins,
> Could you guys pls recommend very good book on administration which goes
> deeply into details, covers all aspects, and would be useful from
practical
> point of view.
>
> Thanks a lot in advance.
> Alex
>|||Thaks a lor for reference
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:u6lzcOOoEHA.132@.TK2MSFTNGP14.phx.gbl...
> SQL Server 2000 Fast Answers for SQL Server DBA and Developer is a good
book
> for novice DBAs. You can find more info about this book at:
> Book review: SQL Server 2000 Fast Answers for DBAs and Developers
> http://vyaskn.tripod.com/sql_server_2000_fast_answers.htm
> --
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Alex" <alex_removethis_@.healthmetrx.com> wrote in message
> news:10l3eisi7289hf3@.corp.supernews.com...
> > Hi admins,
> >
> > Could you guys pls recommend very good book on administration which goes
> > deeply into details, covers all aspects, and would be useful from
> practical
> > point of view.
> >
> >
> > Thanks a lot in advance.
> >
> > Alex
> >
> >
>
Good Book on Datawarehousing with SqlServer?
Can anyone recommend a good book on designing and implementing a data
warehouse using sql server specifically? Not just one in your library, but
one that stands-out?
Thanks,
Michael
The Good Books that can be refered are
1)OLAP Analysis services 2000 By WROX Press
2)MDX solutions with Microsoft SQL server Analysis Services By George
spofford -Wiley press
3)Microsoft OLAP solutions by George spofford ,Erik Thomsen & Dick chase
-Wiley Press
Regards,
SriniPeela
"Snake" wrote:
> Can anyone recommend a good book on designing and implementing a data
> warehouse using sql server specifically? Not just one in your library, but
> one that stands-out?
> Thanks,
> Michael
warehouse using sql server specifically? Not just one in your library, but
one that stands-out?
Thanks,
Michael
The Good Books that can be refered are
1)OLAP Analysis services 2000 By WROX Press
2)MDX solutions with Microsoft SQL server Analysis Services By George
spofford -Wiley press
3)Microsoft OLAP solutions by George spofford ,Erik Thomsen & Dick chase
-Wiley Press
Regards,
SriniPeela
"Snake" wrote:
> Can anyone recommend a good book on designing and implementing a data
> warehouse using sql server specifically? Not just one in your library, but
> one that stands-out?
> Thanks,
> Michael
Good Book for Reporting Services
Hi,
Is there any good book for learning reporting services or as a reporting
services refrence?
Thanks,
AlanHow about ours? See www.sqlreportingervices.net. It's in the final
stages--we expect to have copies on the shelf in September. According to the
reviewers, it's worth the wait.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"A.M" <nospam1@.online.nospam> wrote in message
news:elLm0LQaEHA.3112@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Is there any good book for learning reporting services or as a reporting
> services refrence?
> Thanks,
> Alan
>|||I recommend "Reporting Services in Action."
--RJ
"A.M" <nospam1@.online.nospam> wrote in message
news:elLm0LQaEHA.3112@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Is there any good book for learning reporting services or as a reporting
> services refrence?
> Thanks,
> Alan
>
Is there any good book for learning reporting services or as a reporting
services refrence?
Thanks,
AlanHow about ours? See www.sqlreportingervices.net. It's in the final
stages--we expect to have copies on the shelf in September. According to the
reviewers, it's worth the wait.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"A.M" <nospam1@.online.nospam> wrote in message
news:elLm0LQaEHA.3112@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Is there any good book for learning reporting services or as a reporting
> services refrence?
> Thanks,
> Alan
>|||I recommend "Reporting Services in Action."
--RJ
"A.M" <nospam1@.online.nospam> wrote in message
news:elLm0LQaEHA.3112@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Is there any good book for learning reporting services or as a reporting
> services refrence?
> Thanks,
> Alan
>
Subscribe to:
Posts (Atom)