Difference Between Query Parameters and Report Parameters

Hi Guys,
Can somebody explain me cleraly the difference between Query and Report
Parameters.
Report Parameters r automatically created when u put some variable in a
query.
2)
One more thing is there a way we can hide query string in the IE as I dont
want the users to see the report URL.
3)
My Stored Proc expects 2 parameters but I dont want to pass them in the URL
string is there any other way I can pass parameters to the report from the
front end other than URL strings
Many Many Thanks
Chandra
--
Message posted via http://www.sqlmonster.comwell report parameters r used to get input from the user for the report
and report parameters got attached with query parameters to pass on
input from the user to query in order to build query at run time when u
define query parameter in ur query report automatically generates a
report parameter and attach that report parameter to the specific query
parameter to see further details click EDIT DATASET option n click
parameters tab u ll c how report parameters r getting associated to
query parameters
as far as ur question of hiding parameters is concerned u got to use
reporting services class (SOAP API) n make ur own application to access
the reports instead of accessing reports through URL or u got to set
any property of Ineternet explorers in the registery to hide the
address bar and status bar as well
hope this answers
take care
regards|||Go here:
http://msdn.microsoft.com/library/en-us/RSCREATE/htm/rcr_creating_interactive_v1_50fn.asp?frame=true
It will tell you all you need to know about parameters.
"Chandra Kotha via SQLMonster.com" wrote:
> Hi Guys,
> Can somebody explain me cleraly the difference between Query and Report
> Parameters.
> Report Parameters r automatically created when u put some variable in a
> query.
> 2)
> One more thing is there a way we can hide query string in the IE as I dont
> want the users to see the report URL.
> 3)
> My Stored Proc expects 2 parameters but I dont want to pass them in the URL
> string is there any other way I can pass parameters to the report from the
> front end other than URL strings
> Many Many Thanks
> Chandra
> --
> Message posted via http://www.sqlmonster.com
>|||Others have answered most of your questions. Just a little bit more about
query parameters versus report parameters. RS does automatically create a
report parameter when you put in a query parameter. However, you do not have
to use it. You can set the query parameter to a different report parameter,
you can set it to an expression (which means that if you want you can first
have some custom code massage the report parameter first). A very common
scenario where there is not a one to one relationship between report and
query parameters is when you have several datasets in a report. Let's say I
have several datasets that all use a fromdate and todate. I sure don't want
the user to have to put in the same date multiple times. So, I delete the
extra report parameters and have all the datasets query parameters point to
the same set of report parameters.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Chandra Kotha via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:698d0fc48f2b42f69c5c9fdc8632204a@.SQLMonster.com...
> Hi Guys,
> Can somebody explain me cleraly the difference between Query and Report
> Parameters.
> Report Parameters r automatically created when u put some variable in a
> query.
> 2)
> One more thing is there a way we can hide query string in the IE as I dont
> want the users to see the report URL.
> 3)
> My Stored Proc expects 2 parameters but I dont want to pass them in the
URL
> string is there any other way I can pass parameters to the report from the
> front end other than URL strings
> Many Many Thanks
> Chandra
> --
> Message posted via http://www.sqlmonster.com|||Thanks Guys for ur responses
--
Message posted via http://www.sqlmonster.com

Difference between .rdl and .rdlc files

What is the difference between reports created using Business Intelligence Projects Template and the reports created using .rdlc file which is present in the various file types displayed. Why SSRS needs to be installed when you can create reports using .rdlc file.

The way I understand it, .rdl is a server controlled report and .rdlc is a client-side controlled report. You have to deploy an .rdl file to a report server and access it using that server. With a .rdlc report, you can create the report and use a ReportViewer control to run the report in your application.

|||

RDL files are created by the SQL Server 2005 version of Report Designer. RDLC files are created by the Visual Studio 2005 version of Report Designer.

RDL and RDLC formats have the same XML schema. However, in RDLC files, some values (such as query text) are allowed to be empty, which means that they are not immediately ready to be published to a Report Server. The missing values can be entered by opening the RDLC file using the SQL Server 2005 version of Report Designer. (You have to rename .rdlc to .rdl first.)

RDL files are fully compatible with the ReportViewer control runtime. However, RDL files do not contain some information that the design-time of the ReportViewer control depends on for automatically generating data-binding code. Bymanually binding data, RDL files can be used in the ReportViewer control.

Note that the ReportViewer control does not contain any logic for connecting to databases or executing queries. By separating out such logic, the ReportViewer has been made compatible with all data sources, including non-database data sources. However this means that when an RDL file is used by the ReportViewer control, the SQL related information in the RDL file is simply ignored by the control. It is the host application's responsibility to connect to databases, execute queries and supply data to the ReportViewer control in the form of ADO.NET DataTables.

|||

Thanks Tamer Fathy. But I have certain doubts. I can build reports using the .rdlc files provided by VS 2005. The data could be fetched from any database.To display the report, we have got the reportviewer. The reports as far as I understand will be hosted on the application server not on Report Server as in case of
SSRS 2005. So what are the additional advantages of SSRS 2005 and what are the components that I should install to receive the benefits? I have got sql server 2000 as my backend.

Thanks in advance

|||

you don't need reporting service as you use rdlc read this areticle and see the samples

http://www.gotreportviewer.com/

|||

Thanks Tamer Fathy. But I did not understand the following abstract from the article you asked me to go through.

Q: Why doesn't the ReportViewer control support parameter prompting in local mode?

A: The ReportViewer control does not prompt for parameters when in local mode. It prompts for parameters when it is connected to a Report Server.

In local mode it does not make sense for ReportViewer to prompt for parameters. The rationale is as follows: The most common use of report parameters is to pass to queries as values of query parameters. But unlike the Report Server, the ReportViewer control does not execute queries itself. Rather, queries are executed by the host application, and the result is passed to the ReportViewer control. So the ReportViewer control does not have the opportunity to set query parameters. Applications should take advantage of the parameterization features of Visual Studio data wizards instead.

|||

You welcome any time :),

concerning your question it was easy, this is the difference between the RDL and RDLC in case you need to pass parameters to your reports if you use RDLC which in client side processing as get the data from the database and assign it to the report you need to handle the passing of the parameters by developing the form which get the parameters from the user and then use it in your query then when you get the results you pass it to the report to display.

but if you use server side processing you can use the report viewer control (custom control used to view reports in your application (web or windows)) to handle the parameti hope i explain it in good way and i help you

|||

Thanks Tamer Fathy. But I have one more doubt. Making use of .rdlc file type and the reportviewer provided by VS2005 instead of SSRS 2005 would mean that the reports will be on the application server rather than being hosted on the reportserver since I won't be having a seprate report server. Will this affect the performance of my application server?

Thanks in advance.

|||

no this will not affect your application performance as it wil be as you query the data base for specific data

Difference between #table and # # Table?

If i create a ##table using my stored procedure, I can do the select * from ##table

but when i created the #table using the stored procedure and tried to do the select * from #table

I am getting the error message invalid object #table

that means it is going out of scope.

But if i create the ##table, will that table going to remain in the database even until i drop the ##table or it gets dropped when i close the database connection.

Thank you very much.
-RajFrom SQL Server Books OnLine:

There are two types of temporary tables:

Local temporary tables
The names of these tables begin with one number sign (#). These tables are visible only to the connection that created them.

Global temporary tables
The names of these tables begin with two number signs (##). These tables are visible to all connections. If the tables are not dropped explicitly before the connection that created them disconnects, they are dropped as soon as all other tasks stop referencing them. No new tasks can reference a global temporary table after the connection that created it disconnects. The association between a task and a table is always dropped when the current statement completes executing; therefore, global temporary tables are usually dropped soon after the connection that created them disconnects.

Diff between xxx_data.mdf and xxx.mdf files

What is difference between "xxx_data.mdf" and "xxxx.mdf"? IN Sql2k, I create
d, attach and detach database manytimes. SOme time its shows the database fi
le name as "xxx_data.mdb and xxx_log.mdb" and sometimes it only shows file n
ame as "xxx.mdf and xxx.ldf", why? However in Enterprise manager it shows da
tabase na as "xxx".
I just want to know difference these file name conventions, what was the log
ic behind this?
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.715 / Virus Database: 471 - Release Date: 07/04/2004I don't think there is any specific logic behind the file names really, it's
just what the naming convention was at the time the databases were created.
The actual database name is independent of the file name (and a database ca
n consist of multiple files anyway, so it wouldn't make much sense to name t
he files after the database).
--
Jacco Schalkwijk
SQL Server MVP
"Ashish Kanoongo" <ashishk@.armour.com> wrote in message news:e8c%23paoYEHA.3
988@.tk2msftngp13.phx.gbl...
What is difference between "xxx_data.mdf" and "xxxx.mdf"? IN Sql2k, I create
d, attach and detach database manytimes. SOme time its shows the database fi
le name as "xxx_data.mdb and xxx_log.mdb" and sometimes it only shows file n
ame as "xxx.mdf and xxx.ldf", why? However in Enterprise manager it shows da
tabase na as "xxx".
I just want to know difference these file name conventions, what was the log
ic behind this?
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.715 / Virus Database: 471 - Release Date: 07/04/2004

Diff between xxx_data.mdf and xxx.mdf files

What is difference between "xxx_data.mdf" and "xxxx.mdf"? IN Sql2k, I created, attach and detach database manytimes. SOme time its shows the database file name as "xxx_data.mdb and xxx_log.mdb" and sometimes it only shows file name as "xxx.mdf and xxx.ldf", why? However in Enterprise manager it shows database na as "xxx".
I just want to know difference these file name conventions, what was the logic behind this?
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.715 / Virus Database: 471 - Release Date: 07/04/2004
I don't think there is any specific logic behind the file names really, it's just what the naming convention was at the time the databases were created. The actual database name is independent of the file name (and a database can consist of multiple files anyway, so it wouldn't make much sense to name the files after the database).
Jacco Schalkwijk
SQL Server MVP
"Ashish Kanoongo" <ashishk@.armour.com> wrote in message news:e8c%23paoYEHA.3988@.tk2msftngp13.phx.gbl...
What is difference between "xxx_data.mdf" and "xxxx.mdf"? IN Sql2k, I created, attach and detach database manytimes. SOme time its shows the database file name as "xxx_data.mdb and xxx_log.mdb" and sometimes it only shows file name as "xxx.mdf and xxx.ldf", why? However in Enterprise manager it shows database na as "xxx".
I just want to know difference these file name conventions, what was the logic behind this?
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.715 / Virus Database: 471 - Release Date: 07/04/2004

Diff between xxx_data.mdf and xxx.mdf files

What is difference between "xxx_data.mdf" and "xxxx.mdf"? IN Sql2k, I created, attach and detach database manytimes. SOme time its shows the database file name as "xxx_data.mdb and xxx_log.mdb" and sometimes it only shows file name as "xxx.mdf and xxx.ldf", why? However in Enterprise manager it shows database na as "xxx".
I just want to know difference these file name conventions, what was the logic behind this?
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.715 / Virus Database: 471 - Release Date: 07/04/2004
There is no special significance to the suffixes _data and _log. They are
just the naming conventions used when the database was created. You can name
database files as anything you like, however the standard extensions for SQL
Server files are .MDF for data files and .LDF for log files.
MDB is the standard name for Access databases and isn't normally used for
SQL Server files.
(I've ignored your irrelevant cross-postings. Please don't cross-post. This
clearly has nothing to do with DTS, Clients or Connections so why post
there?)
David Portas
SQL Server MVP
|||I don't think there is any specific logic behind the file names really, it's just what the naming convention was at the time the databases were created. The actual database name is independent of the file name (and a database can consist of multiple files anyway, so it wouldn't make much sense to name the files after the database).
Jacco Schalkwijk
SQL Server MVP
"Ashish Kanoongo" <ashishk@.armour.com> wrote in message news:e8c%23paoYEHA.3988@.tk2msftngp13.phx.gbl...
What is difference between "xxx_data.mdf" and "xxxx.mdf"? IN Sql2k, I created, attach and detach database manytimes. SOme time its shows the database file name as "xxx_data.mdb and xxx_log.mdb" and sometimes it only shows file name as "xxx.mdf and xxx.ldf", why? However in Enterprise manager it shows database na as "xxx".
I just want to know difference these file name conventions, what was the logic behind this?
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.715 / Virus Database: 471 - Release Date: 07/04/2004
sql

Diff between xxx_data.mdf and xxx.mdf files

What is difference between "xxx_data.mdf" and "xxxx.mdf"? IN Sql2k, I created, attach and detach database manytimes. SOme time its shows the database file name as "xxx_data.mdb and xxx_log.mdb" and sometimes it only shows file name as "xxx.mdf and xxx.ldf", why? However in Enterprise manager it shows database na as "xxx".
I just want to know difference these file name conventions, what was the logic behind this?
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.715 / Virus Database: 471 - Release Date: 07/04/2004
I don't think there is any specific logic behind the file names really, it's just what the naming convention was at the time the databases were created. The actual database name is independent of the file name (and a database can consist of multiple files anyway, so it wouldn't make much sense to name the files after the database).
Jacco Schalkwijk
SQL Server MVP
"Ashish Kanoongo" <ashishk@.armour.com> wrote in message news:e8c%23paoYEHA.3988@.tk2msftngp13.phx.gbl...
What is difference between "xxx_data.mdf" and "xxxx.mdf"? IN Sql2k, I created, attach and detach database manytimes. SOme time its shows the database file name as "xxx_data.mdb and xxx_log.mdb" and sometimes it only shows file name as "xxx.mdf and xxx.ldf", why? However in Enterprise manager it shows database na as "xxx".
I just want to know difference these file name conventions, what was the logic behind this?
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.715 / Virus Database: 471 - Release Date: 07/04/2004

Diff between xxx_data.mdf and xxx.mdf files

What is difference between "xxx_data.mdf" and "xxxx.mdf"? IN Sql2k, I create
d, attach and detach database manytimes. SOme time its shows the database fi
le name as "xxx_data.mdb and xxx_log.mdb" and sometimes it only shows file n
ame as "xxx.mdf and xxx.ldf", why? However in Enterprise manager it shows da
tabase na as "xxx".
I just want to know difference these file name conventions, what was the log
ic behind this?
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.715 / Virus Database: 471 - Release Date: 07/04/2004There is no special significance to the suffixes _data and _log. They are
just the naming conventions used when the database was created. You can name
database files as anything you like, however the standard extensions for SQL
Server files are .MDF for data files and .LDF for log files.
MDB is the standard name for Access databases and isn't normally used for
SQL Server files.
(I've ignored your irrelevant cross-postings. Please don't cross-post. This
clearly has nothing to do with DTS, Clients or Connections so why post
there?)
David Portas
SQL Server MVP
--|||I don't think there is any specific logic behind the file names really, it's
just what the naming convention was at the time the databases were created.
The actual database name is independent of the file name (and a database ca
n consist of multiple files anyway, so it wouldn't make much sense to name t
he files after the database).
--
Jacco Schalkwijk
SQL Server MVP
"Ashish Kanoongo" <ashishk@.armour.com> wrote in message news:e8c%23paoYEHA.3
988@.tk2msftngp13.phx.gbl...
What is difference between "xxx_data.mdf" and "xxxx.mdf"? IN Sql2k, I create
d, attach and detach database manytimes. SOme time its shows the database fi
le name as "xxx_data.mdb and xxx_log.mdb" and sometimes it only shows file n
ame as "xxx.mdf and xxx.ldf", why? However in Enterprise manager it shows da
tabase na as "xxx".
I just want to know difference these file name conventions, what was the log
ic behind this?
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.715 / Virus Database: 471 - Release Date: 07/04/2004

Diagramming Error?

I am using the April CTP.

I created a diagram. Via the diagramming tool, I added a new table. Added some columns. Decided I didn't like it. Deleted the table from the database.

Later I decided I did want the table. So I tried to create it again, but the diagram tool said that the table is make for deletion and couldn't be added. I looked at the table list and it was not there.

What can I do so that I can create another table with the same name?Hi Jim,
I could reproduce your results if I deleted the table before saving the diagram. Essentially the table never gets added to the database, but the diagram tool has the name recorded somewhere and that cache isn't getting cleared. I've filed a bug on your behalf for this incorrect behavior.

As a work around, you should be able to reuse the table name if you close SQL Server Management Studio, reopen SSMS and then modify the diagram.|||Thank you!

Diagram to Image

Hello

I have created a Database Diagram for the tables I have in the database and set the relationships of the tables with the fields.

Now I want to export this diagram to the Image format (jpeg, gif or any other one), so i can
add this image in my documentation (ms-word-xp doc) of the project..

I have looked into the options, but i did'nt find any way to export it. So i thought something went wrong while installation, but was made sure that was fine.

Please let me know what is the way to export that diagram to image. (its a exigency)

hope to your all valuable response as soon.

thanks, (in advance) and for your time.Right-click in your diagram, and copy it to the clipboard. You can then paste it into your doc.|||before you give any suggestions, please make sure that your words holds true.

copying diagram from SQL EM to office xp is not supported.

Anyway, thanks for investing your precious time in your one line.|||

try copying into MSPaint, and then using that image in your Doc.

BTW, the copy to clipboard method works fine in Office 2003, for anyone wondering.

|||Andrew Badera, thanks for your time again.

Just give a try of copying from SQL EM to MSPaint, IT IS NOT SUPPORTED.
I dont know how you have checked.

and thanks for suggestion on telling me try OFFICE 2003 (which I am not going to do).
For this simple thing, I cant change the office version i am using, which is really a waste of time.

Anyway, my problem solved long before.
|||

Beau Peep wrote:

Andrew Badera, thanks for your time again.

Just give a try of copying from SQL EM to MSPaint, IT IS NOT SUPPORTED.
I dont know how you have checked.

sorry, should have been more specific I guess: get a screen capture. copy that into mspaint.

|||

I realize this may not help the original poster, but for those that run across this thread by chance ...

My work around is to print to the Microsoft Office Document Image Writer. The file can be saved as either .mdi or .tiff.

I work remotely and cannot connect to my remote development environment with my printer (never figured that one out) ... anyway, because of this, I am not able to print my diagrams directly from EM. After printing to the Image Writer, I simply move the file to my local machine, where it will automatically open in Microsoft Office Document Imaging. From there I can print it to my local printer.

Of course, this option depends on whether or not Microsoft Office Document Image Writer is available on your system. I work with Windows XP and Windows Server 2003, and can confirm that the Document Image Writer is available.

Thanks

Jen

Diagram to Image

Hello
I have created a Database Diagram for the tables I have in the database and
set the relationships of the tables with the fields.
Now I want to export this diagram to the Image format (jpeg, gif or any
other one), so i can add this image in my documentation (ms-word-xp doc) of
the project documentation.
I have looked into the options, but i did'nt find any way to export it. So i
thought something went wrong while installation, but was made sure that was
fine.
Please let me know what is the way to export that diagram to image. (its a
exigency)
hope to see your all valuable response as soon.
thanks, (in advance) and for your time.
=========
NuclearWeapon.ExecTimeOut=10;
NuclearWeapon.Launch=True;
OhWhatIHaveDone();
Beau,
If you are using SQL Server 2005, and generated the diagram in
Management Studio:
1. Right-click in the diagram pane
2. Choose "Copy Diagram to Clipboard"
3. Paste in the destination program.
If you are using 2000 and Enterprise Manager, one option
is to print to the Microsoft Office Document Image Writer,
and choose TIFF output at a low resolution. Other options are
to capture the screen with Alt-PrtSc or a utility (like SnagIt) that can
capture a scrolling window's contents.
Steve Kass
Drew University
Beau Peep wrote:

>Hello
>I have created a Database Diagram for the tables I have in the database and
>set the relationships of the tables with the fields.
>Now I want to export this diagram to the Image format (jpeg, gif or any
>other one), so i can add this image in my documentation (ms-word-xp doc) of
>the project documentation.
>I have looked into the options, but i did'nt find any way to export it. So i
>thought something went wrong while installation, but was made sure that was
>fine.
>Please let me know what is the way to export that diagram to image. (its a
>exigency)
>hope to see your all valuable response as soon.
>thanks, (in advance) and for your time.
>
|||Hello Steve Kass,
Thanks for replying.
Actually, I am using MS-SQL 2000 Enterprises Manager on Windows 2000
Advanced Server. I looked in to your points, but I did'nt get any of such
option that you have mentioned ("Microsoft Office Image Writer"). Could you
please
guide me with the proper steps to achive this and How to configure this "TIFF"
stuff. (I have know idea).
Hope to see your response as soon.
=========
NuclearWeapon.ExecTimeOut=10;
NuclearWeapon.Launch=True;
OhWhatIHaveDone();
"Steve Kass" wrote:

> Beau,
> If you are using SQL Server 2005, and generated the diagram in
> Management Studio:
> 1. Right-click in the diagram pane
> 2. Choose "Copy Diagram to Clipboard"
> 3. Paste in the destination program.
> If you are using 2000 and Enterprise Manager, one option
> is to print to the Microsoft Office Document Image Writer,
> and choose TIFF output at a low resolution. Other options are
> to capture the screen with Alt-PrtSc or a utility (like SnagIt) that can
> capture a scrolling window's contents.
> Steve Kass
> Drew University
> Beau Peep wrote:
>
|||The microsoft office document image writer is part of Office, to get
this option
Office needs to be installed on the machine (think Office 2003 is
required).
Alternatively use Adobe PDF writer or the freeware option Cute PDF
(http://www.CutePDF.com)
Regards,
David
|||Hello David,
Thanks for the suggestion.
I downloaded that just checked. Its really great creating things in PDF.
But what I was expecting was to print this Database diagram completly in one
page. That CutePDF will prints all these images in page wise. ITs like
breaking the
complete image to page wise. I tried setting the page size but none of them
helped.
Is there any idea that I can get this diagram in complete one page?
Hope to see your response as soon. Thanks anyway. Its really a great tool.
=========
NuclearWeapon.ExecTimeOut=10;
NuclearWeapon.Launch=True;
OhWhatIHaveDone();
"David" wrote:

> The microsoft office document image writer is part of Office, to get
> this option
> Office needs to be installed on the machine (think Office 2003 is
> required).
> Alternatively use Adobe PDF writer or the freeware option Cute PDF
> (http://www.CutePDF.com)
> Regards,
> David
>
|||Hi, try to change the paper size in the print dialogue to A3 (the
largest available),
then change width and height to the maximum 91 cm. This is the largest
page
Ive found, then print it to the PDF and you get it all on one page
(hopefully).
Cheers,
David
|||Helllo David,
I tried this setting to A3 but i did'nt find any option for setting the
width and height
to 91cm. I just tried the setting A3 and printed to see how it comes. Dont
ASK.
Half of the Diagram was chopped off.
I guess, only microsoft should provide some functionality to export that
diagram to
any image format.
Well, any suggestions left, please let me know. if possible guide me how to
set the
width and height of the page?
Anyway thanks for the help and your ideas, hope to see your response as soon.
=========
NuclearWeapon.ExecTimeOut=10;
NuclearWeapon.Launch=True;
OhWhatIHaveDone();
"David" wrote:

> Hi, try to change the paper size in the print dialogue to A3 (the
> largest available),
> then change width and height to the maximum 91 cm. This is the largest
> page
> Ive found, then print it to the PDF and you get it all on one page
> (hopefully).
> Cheers,
> David
>

Diagram to Image

Hello

I have created a Database Diagram for the tables I have in the database and set the relationships of the tables with the fields.

Now I want to export this diagram to the Image format (jpeg, gif or any other one), so i can
add this image in my documentation (ms-word-xp doc) of the project..

I have looked into the options, but i did'nt find any way to export it. So i thought something went wrong while installation, but was made sure that was fine.

Please let me know what is the way to export that diagram to image. (its a exigency)

hope to your all valuable response as soon.

thanks, (in advance) and for your time.Right-click in your diagram, and copy it to the clipboard. You can then paste it into your doc.|||before you give any suggestions, please make sure that your words holds true.

copying diagram from SQL EM to office xp is not supported.

Anyway, thanks for investing your precious time in your one line.|||

try copying into MSPaint, and then using that image in your Doc.

BTW, the copy to clipboard method works fine in Office 2003, for anyone wondering.

|||Andrew Badera, thanks for your time again.

Just give a try of copying from SQL EM to MSPaint, IT IS NOT SUPPORTED.
I dont know how you have checked.

and thanks for suggestion on telling me try OFFICE 2003 (which I am not going to do).
For this simple thing, I cant change the office version i am using, which is really a waste of time.

Anyway, my problem solved long before.
|||

Beau Peep wrote:

Andrew Badera, thanks for your time again.

Just give a try of copying from SQL EM to MSPaint, IT IS NOT SUPPORTED.
I dont know how you have checked.

sorry, should have been more specific I guess: get a screen capture. copy that into mspaint.

|||

I realize this may not help the original poster, but for those that run across this thread by chance ...

My work around is to print to the Microsoft Office Document Image Writer. The file can be saved as either .mdi or .tiff.

I work remotely and cannot connect to my remote development environment with my printer (never figured that one out) ... anyway, because of this, I am not able to print my diagrams directly from EM. After printing to the Image Writer, I simply move the file to my local machine, where it will automatically open in Microsoft Office Document Imaging. From there I can print it to my local printer.

Of course, this option depends on whether or not Microsoft Office Document Image Writer is available on your system. I work with Windows XP and Windows Server 2003, and can confirm that the Document Image Writer is available.

Thanks

Jen

Diagram keeps resetting page breaks

I am using SQL Server 2005. I have created a database diagram and using page setup, I have set the page to 100% scale. On the diagram, I display page breaks. When I go to print the diagram (or click reset page breaks), all of the diagram objects shift down about half a page. Is anyone else having this problem? Does anyone have a fix? This is getting really frustrating! I am trying to avoid having tables span accross pages as fields tend to get lost due to margin issues.

Thanks in advance!

-Julie

I have found the Diagramming tool to be a very frustrating tool to create acceptable printouts.

So I recommend using Visio to create your Diagrams. And with Visio, you have full control of the printouts (I often use continuous Size D paper on a plotter.)

Diagram bug in 2005 Developer edition

I have a few databases which were created using sql server 2000 developer
edition. I copied them to the directory where the sql server 2005 databases
are located. I used "Attach" by right clicking on databases and attached the
databases. When I went to view the diagrams, I got a message that database
diagram support can not be installed because the database does not have a
valid user. Strange I thought since I'm using a laptop and everything else
was installed under the same Windows XP login. So I changed the owner to 'sa
'
and I got the same error message. I fixed the problem by changing the
compatability from 8.0 to 9.0. I did not change the owner on the other
databases that I attached. I got a message for sql server to install object
support, I had it install it and then I could view the diagrams just fine.I don't know if it's considered a bug but it is documented
in the read me file - ReadMeSQL2005.htm which should be off
the root of your installation media. I believe the next
update to BOL will have this documented as well. In the read
me file, check section 4.8.1 titled
Considerations for Installing Database Diagram Support
-Sue
On Thu, 13 Apr 2006 10:22:01 -0700, Doctor Who
<DoctorWho@.discussions.microsoft.com> wrote:

>I have a few databases which were created using sql server 2000 developer
>edition. I copied them to the directory where the sql server 2005 databases
>are located. I used "Attach" by right clicking on databases and attached th
e
>databases. When I went to view the diagrams, I got a message that database
>diagram support can not be installed because the database does not have a
>valid user. Strange I thought since I'm using a laptop and everything else
>was installed under the same Windows XP login. So I changed the owner to 's
a'
>and I got the same error message. I fixed the problem by changing the
>compatability from 8.0 to 9.0. I did not change the owner on the other
>databases that I attached. I got a message for sql server to install object
>support, I had it install it and then I could view the diagrams just fine.

Diagram bug in 2005 Developer edition

I have a few databases which were created using sql server 2000 developer
edition. I copied them to the directory where the sql server 2005 databases
are located. I used "Attach" by right clicking on databases and attached the
databases. When I went to view the diagrams, I got a message that database
diagram support can not be installed because the database does not have a
valid user. Strange I thought since I'm using a laptop and everything else
was installed under the same windows xp login. So I changed the owner to 'sa'
and I got the same error message. I fixed the problem by changing the
compatability from 8.0 to 9.0. I did not change the owner on the other
databases that I attached. I got a message for sql server to install object
support, I had it install it and then I could view the diagrams just fine.I don't know if it's considered a bug but it is documented
in the read me file - ReadMeSQL2005.htm which should be off
the root of your installation media. I believe the next
update to BOL will have this documented as well. In the read
me file, check section 4.8.1 titled
Considerations for Installing Database Diagram Support
-Sue
On Thu, 13 Apr 2006 10:22:01 -0700, Doctor Who
<DoctorWho@.discussions.microsoft.com> wrote:
>I have a few databases which were created using sql server 2000 developer
>edition. I copied them to the directory where the sql server 2005 databases
>are located. I used "Attach" by right clicking on databases and attached the
>databases. When I went to view the diagrams, I got a message that database
>diagram support can not be installed because the database does not have a
>valid user. Strange I thought since I'm using a laptop and everything else
>was installed under the same windows xp login. So I changed the owner to 'sa'
>and I got the same error message. I fixed the problem by changing the
>compatability from 8.0 to 9.0. I did not change the owner on the other
>databases that I attached. I got a message for sql server to install object
>support, I had it install it and then I could view the diagrams just fine.

Developer to DBA role

This is probably a wide open question but:
I'm coming from a developer role for the pass 12 years. I've created
everything from, components, web app, windows apps, mobile device
applications, etc. Now I'm getting ready to take over work on our databases,
Our DBA has left and I'm kind of stepping in to take on that role. So my
question is, coming from developer background, what do I need to know beyond
creating stored procedures and select statements to be a successful DBA? I
know from in the pass in working with DBA's that they do more then just
create stored procedures and database, what do I need to know such as,
replication, mirroring, security, performance, etc. where do I begin, is
there anything out there to help me get an understanding of a DBA role, or
should I just 'fly by the seam of my pants' on this one? (probably not a
good idea, but willing to try it)
thanks for any help and or suggestions you may have to offer, (good or bad
are accepted)just to add I know how to create users in the database, SSIS packages, I
guess its more on triggers, indexes, performance issues, replication,
mirroring, etc, suff like that I guess is what i'm looking for.
and other things a DBA does within this role.
"Mike" <Mike@.community.nospam.com> wrote in message
news:%23G$Syd3rHHA.1168@.TK2MSFTNGP03.phx.gbl...
> This is probably a wide open question but:
> I'm coming from a developer role for the pass 12 years. I've created
> everything from, components, web app, windows apps, mobile device
> applications, etc. Now I'm getting ready to take over work on our
> databases, Our DBA has left and I'm kind of stepping in to take on that
> role. So my question is, coming from developer background, what do I need
> to know beyond creating stored procedures and select statements to be a
> successful DBA? I know from in the pass in working with DBA's that they do
> more then just create stored procedures and database, what do I need to
> know such as, replication, mirroring, security, performance, etc. where do
> I begin, is there anything out there to help me get an understanding of a
> DBA role, or should I just 'fly by the seam of my pants' on this one?
> (probably not a good idea, but willing to try it)
>
> thanks for any help and or suggestions you may have to offer, (good or
> bad are accepted)
>
>|||http://groups.google.com/group/microsoft.public.sqlserver.programming/browse_thread/thread/f696a9ae540bf1a0/01482ed3de91192f?hl=en#01482ed3de91192f|||I was in the same boat. Microsoft has some really good training
classes and I'd highly recommend getting into one of those as soon as
you can. They'll cover a broad range of your day to day operations
like backups and security. Also, get familiar with some networking
knowledge as well. You're going to be walking the line between
hardware and software. But, the first thing is with only SQL Dev
experience I'd see what, if any, training classes you can get into. If
anything the book can be used for reference for TSQL statements.|||First and most importantly, you need to be able to put the system back the
way it was yesterday, data and all. Fully document the system and make sure
your recovery strategy is in place and tested.
Second, all developers are now your natural enemy. They write code to
destroy the data and performance. It is your job to limit the damage they
can do. See requirement #1.
Performance monitoring and tuning must now be regular parts of your routine.
Security just became your problem. You don't want to be the next headline
on data lost or hacked.
There are lots more, but this should keep you up nights for the next few
months.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Mike" <Mike@.community.nospam.com> wrote in message
news:OinW2i3rHHA.632@.TK2MSFTNGP03.phx.gbl...
> just to add I know how to create users in the database, SSIS packages, I
> guess its more on triggers, indexes, performance issues, replication,
> mirroring, etc, suff like that I guess is what i'm looking for.
> and other things a DBA does within this role.
>
> "Mike" <Mike@.community.nospam.com> wrote in message
> news:%23G$Syd3rHHA.1168@.TK2MSFTNGP03.phx.gbl...
>> This is probably a wide open question but:
>> I'm coming from a developer role for the pass 12 years. I've created
>> everything from, components, web app, windows apps, mobile device
>> applications, etc. Now I'm getting ready to take over work on our
>> databases, Our DBA has left and I'm kind of stepping in to take on that
>> role. So my question is, coming from developer background, what do I need
>> to know beyond creating stored procedures and select statements to be a
>> successful DBA? I know from in the pass in working with DBA's that they
>> do more then just create stored procedures and database, what do I need
>> to know such as, replication, mirroring, security, performance, etc.
>> where do I begin, is there anything out there to help me get an
>> understanding of a DBA role, or should I just 'fly by the seam of my
>> pants' on this one? (probably not a good idea, but willing to try it)
>>
>> thanks for any help and or suggestions you may have to offer, (good or
>> bad are accepted)
>>
>|||Thanks, I'm now second guessing myself for taken this task on and learn
something new.
> First and most importantly, you need to be able to put the system back the
> way it was yesterday, data and all. Fully document the system and make
> sure your recovery strategy is in place and tested.
I can say I was successful in restoring all the databases when the
server actually crashed. I learned that process hands on. The only thing
though I had to add all of the logins again manually. Is there a way to back
up the 'Security' folder so I can all Login ID and Privilages or no?
> Second, all developers are now your natural enemy. They write code to
> destroy the data and performance. It is your job to limit the damage they
> can do. See requirement #1.
Coming from development, I admit I either brought down a DB or locked a db
in my development days.
> Security just became your problem. You don't want to be the next headline
> on data lost or hacked.
this part I like because I handled alot of the security for the
applications I developed. Though this is a different level of security.
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:OtZbfu3rHHA.1476@.TK2MSFTNGP06.phx.gbl...
> First and most importantly, you need to be able to put the system back the
> way it was yesterday, data and all. Fully document the system and make
> sure your recovery strategy is in place and tested.
> Second, all developers are now your natural enemy. They write code to
> destroy the data and performance. It is your job to limit the damage they
> can do. See requirement #1.
> Performance monitoring and tuning must now be regular parts of your
> routine.
> Security just became your problem. You don't want to be the next headline
> on data lost or hacked.
> There are lots more, but this should keep you up nights for the next few
> months.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
>
> "Mike" <Mike@.community.nospam.com> wrote in message
> news:OinW2i3rHHA.632@.TK2MSFTNGP03.phx.gbl...
>> just to add I know how to create users in the database, SSIS packages, I
>> guess its more on triggers, indexes, performance issues, replication,
>> mirroring, etc, suff like that I guess is what i'm looking for.
>> and other things a DBA does within this role.
>>
>> "Mike" <Mike@.community.nospam.com> wrote in message
>> news:%23G$Syd3rHHA.1168@.TK2MSFTNGP03.phx.gbl...
>> This is probably a wide open question but:
>> I'm coming from a developer role for the pass 12 years. I've created
>> everything from, components, web app, windows apps, mobile device
>> applications, etc. Now I'm getting ready to take over work on our
>> databases, Our DBA has left and I'm kind of stepping in to take on that
>> role. So my question is, coming from developer background, what do I
>> need to know beyond creating stored procedures and select statements to
>> be a successful DBA? I know from in the pass in working with DBA's that
>> they do more then just create stored procedures and database, what do I
>> need to know such as, replication, mirroring, security, performance,
>> etc. where do I begin, is there anything out there to help me get an
>> understanding of a DBA role, or should I just 'fly by the seam of my
>> pants' on this one? (probably not a good idea, but willing to try it)
>>
>> thanks for any help and or suggestions you may have to offer, (good or
>> bad are accepted)
>>
>>
>|||Thanks, I'm going to be looking online this weekend for classes in my area.
"Pawn" <TheRealPawn@.gmail.com> wrote in message
news:1181932262.511711.220810@.q66g2000hsg.googlegroups.com...
>I was in the same boat. Microsoft has some really good training
> classes and I'd highly recommend getting into one of those as soon as
> you can. They'll cover a broad range of your day to day operations
> like backups and security. Also, get familiar with some networking
> knowledge as well. You're going to be walking the line between
> hardware and software. But, the first thing is with only SQL Dev
> experience I'd see what, if any, training classes you can get into. If
> anything the book can be used for reference for TSQL statements.
>|||what about replication, mirroring, or clustering? Or should I not worry
about that until the time comes? According to the mgr none of the above are
used Just backups of the db's on a nightly basis.
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:OtZbfu3rHHA.1476@.TK2MSFTNGP06.phx.gbl...
> First and most importantly, you need to be able to put the system back the
> way it was yesterday, data and all. Fully document the system and make
> sure your recovery strategy is in place and tested.
> Second, all developers are now your natural enemy. They write code to
> destroy the data and performance. It is your job to limit the damage they
> can do. See requirement #1.
> Performance monitoring and tuning must now be regular parts of your
> routine.
> Security just became your problem. You don't want to be the next headline
> on data lost or hacked.
> There are lots more, but this should keep you up nights for the next few
> months.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
>
> "Mike" <Mike@.community.nospam.com> wrote in message
> news:OinW2i3rHHA.632@.TK2MSFTNGP03.phx.gbl...
>> just to add I know how to create users in the database, SSIS packages, I
>> guess its more on triggers, indexes, performance issues, replication,
>> mirroring, etc, suff like that I guess is what i'm looking for.
>> and other things a DBA does within this role.
>>
>> "Mike" <Mike@.community.nospam.com> wrote in message
>> news:%23G$Syd3rHHA.1168@.TK2MSFTNGP03.phx.gbl...
>> This is probably a wide open question but:
>> I'm coming from a developer role for the pass 12 years. I've created
>> everything from, components, web app, windows apps, mobile device
>> applications, etc. Now I'm getting ready to take over work on our
>> databases, Our DBA has left and I'm kind of stepping in to take on that
>> role. So my question is, coming from developer background, what do I
>> need to know beyond creating stored procedures and select statements to
>> be a successful DBA? I know from in the pass in working with DBA's that
>> they do more then just create stored procedures and database, what do I
>> need to know such as, replication, mirroring, security, performance,
>> etc. where do I begin, is there anything out there to help me get an
>> understanding of a DBA role, or should I just 'fly by the seam of my
>> pants' on this one? (probably not a good idea, but willing to try it)
>>
>> thanks for any help and or suggestions you may have to offer, (good or
>> bad are accepted)
>>
>>
>|||Hey, not ALL developers are bad. Just the great majority. Coming out
of the trenches yourself you probably get along well with them so when
you see a performance problem they will most likely be very receptive
to your suggestions on how to fix it. SQL Profiler and Performance
Monitor have just become some of your best friends. Though they do add
overhead to the server so use them sparingly.
This site may help you figure out some more details about performance
monitors:
http://www.sql-server-performance.com/
Here's a link on what your day-to-day's may include:
http://www.databasedesign-resource.com/sql-server-dba.html
On Jun 15, 2:33 pm, "Geoff N. Hiten" <SQLCrafts...@.gmail.com> wrote:
> First and most importantly, you need to be able to put the system back the
> way it was yesterday, data and all. Fully document the system and make sure
> your recovery strategy is in place and tested.
> Second, all developers are now your natural enemy. They write code to
> destroy the data and performance. It is your job to limit the damage they
> can do. See requirement #1.
> Performance monitoring and tuning must now be regular parts of your routine.
> Security just became your problem. You don't want to be the next headline
> on data lost or hacked.
> There are lots more, but this should keep you up nights for the next few
> months.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
> "Mike" <M...@.community.nospam.com> wrote in message
> news:OinW2i3rHHA.632@.TK2MSFTNGP03.phx.gbl...
> > just to add I know how to create users in the database, SSIS packages, I
> > guess its more on triggers, indexes, performance issues, replication,
> > mirroring, etc, suff like that I guess is what i'm looking for.
> > and other things a DBA does within this role.
> > "Mike" <M...@.community.nospam.com> wrote in message
> >news:%23G$Syd3rHHA.1168@.TK2MSFTNGP03.phx.gbl...
> >> This is probably a wide open question but:
> >> I'm coming from a developer role for the pass 12 years. I've created
> >> everything from, components, web app, windows apps, mobile device
> >> applications, etc. Now I'm getting ready to take over work on our
> >> databases, Our DBA has left and I'm kind of stepping in to take on that
> >> role. So my question is, coming from developer background, what do I need
> >> to know beyond creating stored procedures and select statements to be a
> >> successful DBA? I know from in the pass in working with DBA's that they
> >> do more then just create stored procedures and database, what do I need
> >> to know such as, replication, mirroring, security, performance, etc.
> >> where do I begin, is there anything out there to help me get an
> >> understanding of a DBA role, or should I just 'fly by the seam of my
> >> pants' on this one? (probably not a good idea, but willing to try it)
> >> thanks for any help and or suggestions you may have to offer, (good or
> >> bad are accepted)|||thanks I greatly appreciate the information.
This Database stuff is a whole new world to me (from a true dba perspective)
and I was willing to give it a shot.
"Pawn" <TheRealPawn@.gmail.com> wrote in message
news:1181933280.917354.9000@.p77g2000hsh.googlegroups.com...
> Hey, not ALL developers are bad. Just the great majority. Coming out
> of the trenches yourself you probably get along well with them so when
> you see a performance problem they will most likely be very receptive
> to your suggestions on how to fix it. SQL Profiler and Performance
> Monitor have just become some of your best friends. Though they do add
> overhead to the server so use them sparingly.
> This site may help you figure out some more details about performance
> monitors:
> http://www.sql-server-performance.com/
> Here's a link on what your day-to-day's may include:
> http://www.databasedesign-resource.com/sql-server-dba.html
> On Jun 15, 2:33 pm, "Geoff N. Hiten" <SQLCrafts...@.gmail.com> wrote:
>> First and most importantly, you need to be able to put the system back
>> the
>> way it was yesterday, data and all. Fully document the system and make
>> sure
>> your recovery strategy is in place and tested.
>> Second, all developers are now your natural enemy. They write code to
>> destroy the data and performance. It is your job to limit the damage
>> they
>> can do. See requirement #1.
>> Performance monitoring and tuning must now be regular parts of your
>> routine.
>> Security just became your problem. You don't want to be the next
>> headline
>> on data lost or hacked.
>> There are lots more, but this should keep you up nights for the next few
>> months.
>> --
>> Geoff N. Hiten
>> Senior Database Administrator
>> Microsoft SQL Server MVP
>> "Mike" <M...@.community.nospam.com> wrote in message
>> news:OinW2i3rHHA.632@.TK2MSFTNGP03.phx.gbl...
>> > just to add I know how to create users in the database, SSIS packages,
>> > I
>> > guess its more on triggers, indexes, performance issues, replication,
>> > mirroring, etc, suff like that I guess is what i'm looking for.
>> > and other things a DBA does within this role.
>> > "Mike" <M...@.community.nospam.com> wrote in message
>> >news:%23G$Syd3rHHA.1168@.TK2MSFTNGP03.phx.gbl...
>> >> This is probably a wide open question but:
>> >> I'm coming from a developer role for the pass 12 years. I've created
>> >> everything from, components, web app, windows apps, mobile device
>> >> applications, etc. Now I'm getting ready to take over work on our
>> >> databases, Our DBA has left and I'm kind of stepping in to take on
>> >> that
>> >> role. So my question is, coming from developer background, what do I
>> >> need
>> >> to know beyond creating stored procedures and select statements to be
>> >> a
>> >> successful DBA? I know from in the pass in working with DBA's that
>> >> they
>> >> do more then just create stored procedures and database, what do I
>> >> need
>> >> to know such as, replication, mirroring, security, performance, etc.
>> >> where do I begin, is there anything out there to help me get an
>> >> understanding of a DBA role, or should I just 'fly by the seam of my
>> >> pants' on this one? (probably not a good idea, but willing to try it)
>> >> thanks for any help and or suggestions you may have to offer, (good
>> >> or
>> >> bad are accepted)
>
>|||> Is there a way to back up the 'Security' folder so I can all Login ID and Privilages or no?
You need to "get" the architecture of SQL Server. Logins are in the master database, so with proper
backup of master, you have your logins. Having said that, Google for sp_help_revlogin.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Mike" <Mike@.community.nospam.com> wrote in message news:eeD1Sz3rHHA.5032@.TK2MSFTNGP02.phx.gbl...
> Thanks, I'm now second guessing myself for taken this task on and learn something new.
>> First and most importantly, you need to be able to put the system back the way it was yesterday,
>> data and all. Fully document the system and make sure your recovery strategy is in place and
>> tested.
> I can say I was successful in restoring all the databases when the server actually crashed. I
> learned that process hands on. The only thing though I had to add all of the logins again
> manually. Is there a way to back up the 'Security' folder so I can all Login ID and Privilages or
> no?
>
>> Second, all developers are now your natural enemy. They write code to destroy the data and
>> performance. It is your job to limit the damage they can do. See requirement #1.
> Coming from development, I admit I either brought down a DB or locked a db in my development
> days.
>
>> Security just became your problem. You don't want to be the next headline on data lost or
>> hacked.
> this part I like because I handled alot of the security for the applications I developed.
> Though this is a different level of security.
>
> "Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
> news:OtZbfu3rHHA.1476@.TK2MSFTNGP06.phx.gbl...
>> First and most importantly, you need to be able to put the system back the way it was yesterday,
>> data and all. Fully document the system and make sure your recovery strategy is in place and
>> tested.
>> Second, all developers are now your natural enemy. They write code to destroy the data and
>> performance. It is your job to limit the damage they can do. See requirement #1.
>> Performance monitoring and tuning must now be regular parts of your routine.
>> Security just became your problem. You don't want to be the next headline on data lost or
>> hacked.
>> There are lots more, but this should keep you up nights for the next few months.
>> --
>> Geoff N. Hiten
>> Senior Database Administrator
>> Microsoft SQL Server MVP
>>
>>
>>
>> "Mike" <Mike@.community.nospam.com> wrote in message news:OinW2i3rHHA.632@.TK2MSFTNGP03.phx.gbl...
>> just to add I know how to create users in the database, SSIS packages, I guess its more on
>> triggers, indexes, performance issues, replication, mirroring, etc, suff like that I guess is
>> what i'm looking for.
>> and other things a DBA does within this role.
>>
>> "Mike" <Mike@.community.nospam.com> wrote in message
>> news:%23G$Syd3rHHA.1168@.TK2MSFTNGP03.phx.gbl...
>> This is probably a wide open question but:
>> I'm coming from a developer role for the pass 12 years. I've created everything from,
>> components, web app, windows apps, mobile device applications, etc. Now I'm getting ready to
>> take over work on our databases, Our DBA has left and I'm kind of stepping in to take on that
>> role. So my question is, coming from developer background, what do I need to know beyond
>> creating stored procedures and select statements to be a successful DBA? I know from in the
>> pass in working with DBA's that they do more then just create stored procedures and database,
>> what do I need to know such as, replication, mirroring, security, performance, etc. where do I
>> begin, is there anything out there to help me get an understanding of a DBA role, or should I
>> just 'fly by the seam of my pants' on this one? (probably not a good idea, but willing to try
>> it)
>>
>> thanks for any help and or suggestions you may have to offer, (good or bad are accepted)
>>
>>
>>
>|||As a trainer, I know the (MS) SQL Server courses inside out. Here's my recommendation:
2780, which is an admin class. Sure, you might know bits here and there already, but if you are
about to shift position, they (your managers) would want to invest a bit. Make sure you get the 5
days revision of the course (B rev), and preferably from a reputable instructor. Added value differs
a lot. I have difficulties managing to teach this class for the specified time, while other say
there is way too much time allocated.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Mike" <Mike@.community.nospam.com> wrote in message news:OziQgz3rHHA.3500@.TK2MSFTNGP04.phx.gbl...
> Thanks, I'm going to be looking online this weekend for classes in my area.
>
> "Pawn" <TheRealPawn@.gmail.com> wrote in message
> news:1181932262.511711.220810@.q66g2000hsg.googlegroups.com...
>>I was in the same boat. Microsoft has some really good training
>> classes and I'd highly recommend getting into one of those as soon as
>> you can. They'll cover a broad range of your day to day operations
>> like backups and security. Also, get familiar with some networking
>> knowledge as well. You're going to be walking the line between
>> hardware and software. But, the first thing is with only SQL Dev
>> experience I'd see what, if any, training classes you can get into. If
>> anything the book can be used for reference for TSQL statements.
>|||Unless you are currently using or expect to use a technology, I would not
> worry about it on day one. Getting a handle on managing, recovering, and
> operating the server AS IS should be your top priority. Learn about what
> new technologies can and cannot do so you can make intelligent
> recommendations, but unless they are part of your current environment,
> they are not part of your current problem set.
Ok and as of now nothing is really used (replication, mirroring, etc)
> As for the developer comments, I have worked as a developer, a system
> admin, and as a DBA over the course of my career. Each has a different
> perspective on the system and different goals. Sometimes those goals are
> in wildly different directions.
Myself as well, I started out as a helpdesk person many years ago when I
started in the corporate IT world, and done everything in IT you can think
of from helpdesk, sys admin, email server admin, developer, architecture,
and now the new task of DBA (I'm ready for a new challange)
> Don't rely on luck to restore a system. Have a plan and practice it.
> Test your backups regularly. Training classes will help give you the
> knowledge to build an effective operations and recovery plan, but you have
> to do the heavy lifting. Remember, management does not care about
> backups, they care about restores.
I'm actually building a test server with SQL on it that has not app
connected to it. I want to get more familiar with the OS crashing, the DB
crashing, etc and work on restoring the DB as close to possible as it was
prior to the 'crash'
> Good luck. I figure we will see you around here quite a bit in the months
> to come. :)
thanks, I need some luck, yeah. I'll probably live here for the next few
months with tons of questions.
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:uNeVj83rHHA.1168@.TK2MSFTNGP03.phx.gbl...
> Unless you are currently using or expect to use a technology, I would not
> worry about it on day one. Getting a handle on managing, recovering, and
> operating the server AS IS should be your top priority. Learn about what
> new technologies can and cannot do so you can make intelligent
> recommendations, but unless they are part of your current environment,
> they are not part of your current problem set.
> As for the developer comments, I have worked as a developer, a system
> admin, and as a DBA over the course of my career. Each has a different
> perspective on the system and different goals. Sometimes those goals are
> in wildly different directions.
> Don't rely on luck to restore a system. Have a plan and practice it.
> Test your backups regularly. Training classes will help give you the
> knowledge to build an effective operations and recovery plan, but you have
> to do the heavy lifting. Remember, management does not care about
> backups, they care about restores.
> Good luck. I figure we will see you around here quite a bit in the months
> to come. :)
>
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "Mike" <Mike@.community.nospam.com> wrote in message
> news:O70I913rHHA.4548@.TK2MSFTNGP03.phx.gbl...
>> what about replication, mirroring, or clustering? Or should I not worry
>> about that until the time comes? According to the mgr none of the above
>> are used Just backups of the db's on a nightly basis.
>>
>> "Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
>> news:OtZbfu3rHHA.1476@.TK2MSFTNGP06.phx.gbl...
>> First and most importantly, you need to be able to put the system back
>> the way it was yesterday, data and all. Fully document the system and
>> make sure your recovery strategy is in place and tested.
>> Second, all developers are now your natural enemy. They write code to
>> destroy the data and performance. It is your job to limit the damage
>> they can do. See requirement #1.
>> Performance monitoring and tuning must now be regular parts of your
>> routine.
>> Security just became your problem. You don't want to be the next
>> headline on data lost or hacked.
>> There are lots more, but this should keep you up nights for the next few
>> months.
>> --
>> Geoff N. Hiten
>> Senior Database Administrator
>> Microsoft SQL Server MVP
>>
>>
>>
>> "Mike" <Mike@.community.nospam.com> wrote in message
>> news:OinW2i3rHHA.632@.TK2MSFTNGP03.phx.gbl...
>> just to add I know how to create users in the database, SSIS packages,
>> I guess its more on triggers, indexes, performance issues, replication,
>> mirroring, etc, suff like that I guess is what i'm looking for.
>> and other things a DBA does within this role.
>>
>> "Mike" <Mike@.community.nospam.com> wrote in message
>> news:%23G$Syd3rHHA.1168@.TK2MSFTNGP03.phx.gbl...
>> This is probably a wide open question but:
>> I'm coming from a developer role for the pass 12 years. I've created
>> everything from, components, web app, windows apps, mobile device
>> applications, etc. Now I'm getting ready to take over work on our
>> databases, Our DBA has left and I'm kind of stepping in to take on
>> that role. So my question is, coming from developer background, what
>> do I need to know beyond creating stored procedures and select
>> statements to be a successful DBA? I know from in the pass in working
>> with DBA's that they do more then just create stored procedures and
>> database, what do I need to know such as, replication, mirroring,
>> security, performance, etc. where do I begin, is there anything out
>> there to help me get an understanding of a DBA role, or should I just
>> 'fly by the seam of my pants' on this one? (probably not a good idea,
>> but willing to try it)
>>
>> thanks for any help and or suggestions you may have to offer, (good
>> or bad are accepted)
>>
>>
>>
>>
>|||Unless you are currently using or expect to use a technology, I would not
worry about it on day one. Getting a handle on managing, recovering, and
operating the server AS IS should be your top priority. Learn about what
new technologies can and cannot do so you can make intelligent
recommendations, but unless they are part of your current environment, they
are not part of your current problem set.
As for the developer comments, I have worked as a developer, a system admin,
and as a DBA over the course of my career. Each has a different perspective
on the system and different goals. Sometimes those goals are in wildly
different directions.
Don't rely on luck to restore a system. Have a plan and practice it. Test
your backups regularly. Training classes will help give you the knowledge
to build an effective operations and recovery plan, but you have to do the
heavy lifting. Remember, management does not care about backups, they care
about restores.
Good luck. I figure we will see you around here quite a bit in the months
to come. :)
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Mike" <Mike@.community.nospam.com> wrote in message
news:O70I913rHHA.4548@.TK2MSFTNGP03.phx.gbl...
> what about replication, mirroring, or clustering? Or should I not worry
> about that until the time comes? According to the mgr none of the above
> are used Just backups of the db's on a nightly basis.
>
> "Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
> news:OtZbfu3rHHA.1476@.TK2MSFTNGP06.phx.gbl...
>> First and most importantly, you need to be able to put the system back
>> the way it was yesterday, data and all. Fully document the system and
>> make sure your recovery strategy is in place and tested.
>> Second, all developers are now your natural enemy. They write code to
>> destroy the data and performance. It is your job to limit the damage
>> they can do. See requirement #1.
>> Performance monitoring and tuning must now be regular parts of your
>> routine.
>> Security just became your problem. You don't want to be the next
>> headline on data lost or hacked.
>> There are lots more, but this should keep you up nights for the next few
>> months.
>> --
>> Geoff N. Hiten
>> Senior Database Administrator
>> Microsoft SQL Server MVP
>>
>>
>>
>> "Mike" <Mike@.community.nospam.com> wrote in message
>> news:OinW2i3rHHA.632@.TK2MSFTNGP03.phx.gbl...
>> just to add I know how to create users in the database, SSIS packages, I
>> guess its more on triggers, indexes, performance issues, replication,
>> mirroring, etc, suff like that I guess is what i'm looking for.
>> and other things a DBA does within this role.
>>
>> "Mike" <Mike@.community.nospam.com> wrote in message
>> news:%23G$Syd3rHHA.1168@.TK2MSFTNGP03.phx.gbl...
>> This is probably a wide open question but:
>> I'm coming from a developer role for the pass 12 years. I've created
>> everything from, components, web app, windows apps, mobile device
>> applications, etc. Now I'm getting ready to take over work on our
>> databases, Our DBA has left and I'm kind of stepping in to take on that
>> role. So my question is, coming from developer background, what do I
>> need to know beyond creating stored procedures and select statements to
>> be a successful DBA? I know from in the pass in working with DBA's that
>> they do more then just create stored procedures and database, what do I
>> need to know such as, replication, mirroring, security, performance,
>> etc. where do I begin, is there anything out there to help me get an
>> understanding of a DBA role, or should I just 'fly by the seam of my
>> pants' on this one? (probably not a good idea, but willing to try it)
>>
>> thanks for any help and or suggestions you may have to offer, (good or
>> bad are accepted)
>>
>>
>>
>|||2072A is the one that I took but I don't think it's offered anymore
On Jun 15, 3:04 pm, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> As a trainer, I know the (MS) SQL Server courses inside out. Here's my recommendation:
> 2780, which is an admin class. Sure, you might know bits here and there already, but if you are
> about to shift position, they (your managers) would want to invest a bit. Make sure you get the 5
> days revision of the course (B rev), and preferably from a reputable instructor. Added value differs
> a lot. I have difficulties managing to teach this class for the specified time, while other say
> there is way too much time allocated.
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi
> "Mike" <M...@.community.nospam.com> wrote in messagenews:OziQgz3rHHA.3500@.TK2MSFTNGP04.phx.gbl...
> > Thanks, I'm going to be looking online this weekend for classes in my area.
> > "Pawn" <TheRealP...@.gmail.com> wrote in message
> >news:1181932262.511711.220810@.q66g2000hsg.googlegroups.com...
> >>I was in the same boat. Microsoft has some really good training
> >> classes and I'd highly recommend getting into one of those as soon as
> >> you can. They'll cover a broad range of your day to day operations
> >> like backups and security. Also, get familiar with some networking
> >> knowledge as well. You're going to be walking the line between
> >> hardware and software. But, the first thing is with only SQL Dev
> >> experience I'd see what, if any, training classes you can get into. If
> >> anything the book can be used for reference for TSQL statements.|||And for my first SQL task at hand is to convert all 10 servers running SQL
2000 to SQL 2005 and each server has a range from 10 to 125 databases on
them.
So this is to start Monday and end by July 1. So I guess I'm hitting the DB
world running.
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:uNeVj83rHHA.1168@.TK2MSFTNGP03.phx.gbl...
> Unless you are currently using or expect to use a technology, I would not
> worry about it on day one. Getting a handle on managing, recovering, and
> operating the server AS IS should be your top priority. Learn about what
> new technologies can and cannot do so you can make intelligent
> recommendations, but unless they are part of your current environment,
> they are not part of your current problem set.
> As for the developer comments, I have worked as a developer, a system
> admin, and as a DBA over the course of my career. Each has a different
> perspective on the system and different goals. Sometimes those goals are
> in wildly different directions.
> Don't rely on luck to restore a system. Have a plan and practice it.
> Test your backups regularly. Training classes will help give you the
> knowledge to build an effective operations and recovery plan, but you have
> to do the heavy lifting. Remember, management does not care about
> backups, they care about restores.
> Good luck. I figure we will see you around here quite a bit in the months
> to come. :)
>
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "Mike" <Mike@.community.nospam.com> wrote in message
> news:O70I913rHHA.4548@.TK2MSFTNGP03.phx.gbl...
>> what about replication, mirroring, or clustering? Or should I not worry
>> about that until the time comes? According to the mgr none of the above
>> are used Just backups of the db's on a nightly basis.
>>
>> "Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
>> news:OtZbfu3rHHA.1476@.TK2MSFTNGP06.phx.gbl...
>> First and most importantly, you need to be able to put the system back
>> the way it was yesterday, data and all. Fully document the system and
>> make sure your recovery strategy is in place and tested.
>> Second, all developers are now your natural enemy. They write code to
>> destroy the data and performance. It is your job to limit the damage
>> they can do. See requirement #1.
>> Performance monitoring and tuning must now be regular parts of your
>> routine.
>> Security just became your problem. You don't want to be the next
>> headline on data lost or hacked.
>> There are lots more, but this should keep you up nights for the next few
>> months.
>> --
>> Geoff N. Hiten
>> Senior Database Administrator
>> Microsoft SQL Server MVP
>>
>>
>>
>> "Mike" <Mike@.community.nospam.com> wrote in message
>> news:OinW2i3rHHA.632@.TK2MSFTNGP03.phx.gbl...
>> just to add I know how to create users in the database, SSIS packages,
>> I guess its more on triggers, indexes, performance issues, replication,
>> mirroring, etc, suff like that I guess is what i'm looking for.
>> and other things a DBA does within this role.
>>
>> "Mike" <Mike@.community.nospam.com> wrote in message
>> news:%23G$Syd3rHHA.1168@.TK2MSFTNGP03.phx.gbl...
>> This is probably a wide open question but:
>> I'm coming from a developer role for the pass 12 years. I've created
>> everything from, components, web app, windows apps, mobile device
>> applications, etc. Now I'm getting ready to take over work on our
>> databases, Our DBA has left and I'm kind of stepping in to take on
>> that role. So my question is, coming from developer background, what
>> do I need to know beyond creating stored procedures and select
>> statements to be a successful DBA? I know from in the pass in working
>> with DBA's that they do more then just create stored procedures and
>> database, what do I need to know such as, replication, mirroring,
>> security, performance, etc. where do I begin, is there anything out
>> there to help me get an understanding of a DBA role, or should I just
>> 'fly by the seam of my pants' on this one? (probably not a good idea,
>> but willing to try it)
>>
>> thanks for any help and or suggestions you may have to offer, (good
>> or bad are accepted)
>>
>>
>>
>>
>|||Thanks, I'll be looking over the weekend and even next week for SQL courses
in my area.
I've seen online courses and I've even taken some of them for .NET. How
would they work for the SQL side of the house?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:1E9EE097-CD31-4291-A4D1-874541D7BC6B@.microsoft.com...
> As a trainer, I know the (MS) SQL Server courses inside out. Here's my
> recommendation:
> 2780, which is an admin class. Sure, you might know bits here and there
> already, but if you are about to shift position, they (your managers)
> would want to invest a bit. Make sure you get the 5 days revision of the
> course (B rev), and preferably from a reputable instructor. Added value
> differs a lot. I have difficulties managing to teach this class for the
> specified time, while other say there is way too much time allocated.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Mike" <Mike@.community.nospam.com> wrote in message
> news:OziQgz3rHHA.3500@.TK2MSFTNGP04.phx.gbl...
>> Thanks, I'm going to be looking online this weekend for classes in my
>> area.
>>
>> "Pawn" <TheRealPawn@.gmail.com> wrote in message
>> news:1181932262.511711.220810@.q66g2000hsg.googlegroups.com...
>>I was in the same boat. Microsoft has some really good training
>> classes and I'd highly recommend getting into one of those as soon as
>> you can. They'll cover a broad range of your day to day operations
>> like backups and security. Also, get familiar with some networking
>> knowledge as well. You're going to be walking the line between
>> hardware and software. But, the first thing is with only SQL Dev
>> experience I'd see what, if any, training classes you can get into. If
>> anything the book can be used for reference for TSQL statements.
>>
>|||On Jun 15, 3:12 pm, "Mike" <M...@.community.nospam.com> wrote:
> Thanks, I'll be looking over the weekend and even next week for SQL courses
> in my area.
> I've seen online courses and I've even taken some of them for .NET. How
> would they work for the SQL side of the house?
> "Tibor Karaszi" <tibor_please.no.email_kara...@.hotmail.nomail.com> wrote in
> messagenews:1E9EE097-CD31-4291-A4D1-874541D7BC6B@.microsoft.com...
>
> > As a trainer, I know the (MS) SQL Server courses inside out. Here's my
> > recommendation:
> > 2780, which is an admin class. Sure, you might know bits here and there
> > already, but if you are about to shift position, they (your managers)
> > would want to invest a bit. Make sure you get the 5 days revision of the
> > course (B rev), and preferably from a reputable instructor. Added value
> > differs a lot. I have difficulties managing to teach this class for the
> > specified time, while other say there is way too much time allocated.
> > --
> > Tibor Karaszi, SQL Server MVP
> >http://www.karaszi.com/sqlserver/default.asp
> >http://sqlblog.com/blogs/tibor_karaszi
> > "Mike" <M...@.community.nospam.com> wrote in message
> >news:OziQgz3rHHA.3500@.TK2MSFTNGP04.phx.gbl...
> >> Thanks, I'm going to be looking online this weekend for classes in my
> >> area.
> >> "Pawn" <TheRealP...@.gmail.com> wrote in message
> >>news:1181932262.511711.220810@.q66g2000hsg.googlegroups.com...
> >>I was in the same boat. Microsoft has some really good training
> >> classes and I'd highly recommend getting into one of those as soon as
> >> you can. They'll cover a broad range of your day to day operations
> >> like backups and security. Also, get familiar with some networking
> >> knowledge as well. You're going to be walking the line between
> >> hardware and software. But, the first thing is with only SQL Dev
> >> experience I'd see what, if any, training classes you can get into. If
> >> anything the book can be used for reference for TSQL statements.- Hide quoted text -
> - Show quoted text -
Wrox press has a good book on SQL 2005 Administration. It basically
covers the basics of a lot of things...|||Yes, 2072 is for 2000, and 2780 is the successor for 2005. 2780 was initially 3 days, covering same
areas as 2072, since customers requested shorter courses. This wasn't doable (3 days), of course, so
after some lobbying a revision B of the course was (is) released upped to 5 days.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Pawn" <TheRealPawn@.gmail.com> wrote in message
news:1181934688.597868.276400@.n2g2000hse.googlegroups.com...
> 2072A is the one that I took but I don't think it's offered anymore
> On Jun 15, 3:04 pm, "Tibor Karaszi"
> <tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
>> As a trainer, I know the (MS) SQL Server courses inside out. Here's my recommendation:
>> 2780, which is an admin class. Sure, you might know bits here and there already, but if you are
>> about to shift position, they (your managers) would want to invest a bit. Make sure you get the 5
>> days revision of the course (B rev), and preferably from a reputable instructor. Added value
>> differs
>> a lot. I have difficulties managing to teach this class for the specified time, while other say
>> there is way too much time allocated.
>> --
>> Tibor Karaszi, SQL Server
>> MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi
>> "Mike" <M...@.community.nospam.com> wrote in messagenews:OziQgz3rHHA.3500@.TK2MSFTNGP04.phx.gbl...
>> > Thanks, I'm going to be looking online this weekend for classes in my area.
>> > "Pawn" <TheRealP...@.gmail.com> wrote in message
>> >news:1181932262.511711.220810@.q66g2000hsg.googlegroups.com...
>> >>I was in the same boat. Microsoft has some really good training
>> >> classes and I'd highly recommend getting into one of those as soon as
>> >> you can. They'll cover a broad range of your day to day operations
>> >> like backups and security. Also, get familiar with some networking
>> >> knowledge as well. You're going to be walking the line between
>> >> hardware and software. But, the first thing is with only SQL Dev
>> >> experience I'd see what, if any, training classes you can get into. If
>> >> anything the book can be used for reference for TSQL statements.
>|||Obviously SQL Server has been designed & built by developers (c:
Regards,
Regards,
Greg Linwood
SQL Server MVP
http://blogs.sqlserver.org.au/blogs/greg_linwood
http://www.SQLBenchmarkPro.com
"Pawn" <TheRealPawn@.gmail.com> wrote in message
news:1181933280.917354.9000@.p77g2000hsh.googlegroups.com...
> Hey, not ALL developers are bad. Just the great majority. Coming out
> of the trenches yourself you probably get along well with them so when
> you see a performance problem they will most likely be very receptive
> to your suggestions on how to fix it. SQL Profiler and Performance
> Monitor have just become some of your best friends. Though they do add
> overhead to the server so use them sparingly.
> This site may help you figure out some more details about performance
> monitors:
> http://www.sql-server-performance.com/
> Here's a link on what your day-to-day's may include:
> http://www.databasedesign-resource.com/sql-server-dba.html
> On Jun 15, 2:33 pm, "Geoff N. Hiten" <SQLCrafts...@.gmail.com> wrote:
>> First and most importantly, you need to be able to put the system back
>> the
>> way it was yesterday, data and all. Fully document the system and make
>> sure
>> your recovery strategy is in place and tested.
>> Second, all developers are now your natural enemy. They write code to
>> destroy the data and performance. It is your job to limit the damage
>> they
>> can do. See requirement #1.
>> Performance monitoring and tuning must now be regular parts of your
>> routine.
>> Security just became your problem. You don't want to be the next
>> headline
>> on data lost or hacked.
>> There are lots more, but this should keep you up nights for the next few
>> months.
>> --
>> Geoff N. Hiten
>> Senior Database Administrator
>> Microsoft SQL Server MVP
>> "Mike" <M...@.community.nospam.com> wrote in message
>> news:OinW2i3rHHA.632@.TK2MSFTNGP03.phx.gbl...
>> > just to add I know how to create users in the database, SSIS packages,
>> > I
>> > guess its more on triggers, indexes, performance issues, replication,
>> > mirroring, etc, suff like that I guess is what i'm looking for.
>> > and other things a DBA does within this role.
>> > "Mike" <M...@.community.nospam.com> wrote in message
>> >news:%23G$Syd3rHHA.1168@.TK2MSFTNGP03.phx.gbl...
>> >> This is probably a wide open question but:
>> >> I'm coming from a developer role for the pass 12 years. I've created
>> >> everything from, components, web app, windows apps, mobile device
>> >> applications, etc. Now I'm getting ready to take over work on our
>> >> databases, Our DBA has left and I'm kind of stepping in to take on
>> >> that
>> >> role. So my question is, coming from developer background, what do I
>> >> need
>> >> to know beyond creating stored procedures and select statements to be
>> >> a
>> >> successful DBA? I know from in the pass in working with DBA's that
>> >> they
>> >> do more then just create stored procedures and database, what do I
>> >> need
>> >> to know such as, replication, mirroring, security, performance, etc.
>> >> where do I begin, is there anything out there to help me get an
>> >> understanding of a DBA role, or should I just 'fly by the seam of my
>> >> pants' on this one? (probably not a good idea, but willing to try it)
>> >> thanks for any help and or suggestions you may have to offer, (good
>> >> or
>> >> bad are accepted)
>
>|||This is very good advice - it often isn't clear to a developer moving into a
DBA role how important protecting the system, data & the company's uptime is
until they experience a failure. When disaster calls, some get lucky due to
their predecessors following good procedures but some new DBAs get fired for
not performing their #1 responsibility. I agree with Geoff - make sure you
fully understand, document & know how to restore your system in case you
need to. Also, make sure your employer knows you're spending time protecting
them & do your best to actually practice restoring your system (just as a
dev tests code, DBAs should test restoring systems).
Everything else is of secondary (although significant) importance.
Regards,
Regards,
Greg Linwood
SQL Server MVP
http://blogs.sqlserver.org.au/blogs/greg_linwood
http://www.SQLBenchmarkPro.com
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:OtZbfu3rHHA.1476@.TK2MSFTNGP06.phx.gbl...
> First and most importantly, you need to be able to put the system back the
> way it was yesterday, data and all. Fully document the system and make
> sure your recovery strategy is in place and tested.
> Second, all developers are now your natural enemy. They write code to
> destroy the data and performance. It is your job to limit the damage they
> can do. See requirement #1.
> Performance monitoring and tuning must now be regular parts of your
> routine.
> Security just became your problem. You don't want to be the next headline
> on data lost or hacked.
> There are lots more, but this should keep you up nights for the next few
> months.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
>
> "Mike" <Mike@.community.nospam.com> wrote in message
> news:OinW2i3rHHA.632@.TK2MSFTNGP03.phx.gbl...
>> just to add I know how to create users in the database, SSIS packages, I
>> guess its more on triggers, indexes, performance issues, replication,
>> mirroring, etc, suff like that I guess is what i'm looking for.
>> and other things a DBA does within this role.
>>
>> "Mike" <Mike@.community.nospam.com> wrote in message
>> news:%23G$Syd3rHHA.1168@.TK2MSFTNGP03.phx.gbl...
>> This is probably a wide open question but:
>> I'm coming from a developer role for the pass 12 years. I've created
>> everything from, components, web app, windows apps, mobile device
>> applications, etc. Now I'm getting ready to take over work on our
>> databases, Our DBA has left and I'm kind of stepping in to take on that
>> role. So my question is, coming from developer background, what do I
>> need to know beyond creating stored procedures and select statements to
>> be a successful DBA? I know from in the pass in working with DBA's that
>> they do more then just create stored procedures and database, what do I
>> need to know such as, replication, mirroring, security, performance,
>> etc. where do I begin, is there anything out there to help me get an
>> understanding of a DBA role, or should I just 'fly by the seam of my
>> pants' on this one? (probably not a good idea, but willing to try it)
>>
>> thanks for any help and or suggestions you may have to offer, (good or
>> bad are accepted)
>>
>>
>

Developed one Report in Excel and want to Deploy on Report Server

I have created one SQL Server OLAP Report through Excel. I want to deploy this report on Report Server. Is it possible?

Regards,

Dinesh Patel

Unfortunately this is not a supported scenario.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Deteted file still imports

Have created a Job with 2 Steps. Step1 imports data into a table from a text
file on another drive. Step2 deletes the file. All executes fine and the
text file disappears from the other drive. If I execute the Job a second
time, the same data is imported even though the file no longer exists. How
can this be'Never mind. I found the issue. Forgot to modify DTS pathway!!!
"Ray" wrote:

> Have created a Job with 2 Steps. Step1 imports data into a table from a te
xt
> file on another drive. Step2 deletes the file. All executes fine and the
> text file disappears from the other drive. If I execute the Job a second
> time, the same data is imported even though the file no longer exists. How
> can this be'