Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lvirden
Starting Member
4 Posts |
 Posted - 2011-01-07 : 14:47:00
|
| In my current position, I am doing admin and some development work with HP Service Manager. It was installed using SQL Server 2005 as its database.There are in-house admins for the SQL Server environment - so I don't need to learn that.I don't plan on writing code that talks to the database.However, what is planned is for me to learn about SQL Server 2005 Reporting Services, so that I, along with a couple of other people, can answer questions and write reports for the data that resides in the underlying database.In the class that I'm looking at taking, it lists pre-requisits as:Microsoft SQL Server, including: SQL Server Agent, SQL Server query language, SQL Server System tables, SQL Server accounts (users and permissions)In previous assignments, I have used ORACLE Sql, and written c, perl, and tcl code to perform inserts, deletes, updates, selects, etc.I have never directly interacted with SQL Server, and have not had any training relating to it.So, I am trying to figure out what a SQL Server Agent is, and what kind of things I could (or should) be reading to learn enough about the query language, tables, and accounts to at least recognize the topics when they come up in class.Does anyone have some gentle introductions to SQL server itself- not installing or maintaining the servers, and not writing SQL code, but specifics about using SQL Server 2005 environment, that would be useful for someone who is going to be becoming familar with making use of SQL Server Reporting Services? |
|
|
RobertKaucher
Posting Yak Master
169 Posts |
Posted - 2011-01-07 : 15:12:36
|
quote:
Originally posted by lvirden
Does anyone have some gentle introductions to SQL server itself- not installing or maintaining the servers, and not writing SQL code, but specifics about using SQL Server 2005 environment, that would be useful for someone who is going to be becoming familar with making use of SQL Server Reporting Services?
Read these:Microsoft SQL Server 2008 For DummiesMicrosoft SQL Server 2008 Reporting Services Step by Step Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes Those will give you about as gentle an intro to these topics as you could possibly get.Also, I think you have some misunderstandings about what you do and don't want to do. You said you don't want to write code that talks to the database - how do you intend on qurying the database for your reports? You don't want to learn about the SQL Server environment - yet you need to know about SQL Server Agent...Not installing, not maintenance, not querying - what exactly do you expect to do if you are not going to do any of those? I think all that is left is staring at it... ;-)Here is an article that explains the function of the Agent.http://msdn.microsoft.com/en-us/library/ms189237.aspx===http://www.ElementalSQL.com/ |
 |
|
|
|
|
|
|
|
Trying to find a useful place to start learning