Book Recommendations

Hello -
My background is networking and system administration. I know basic
programming constructs, and have done .bat, VBA, and *nix shell
scripting/programming. I am looking for, at most, two books that can
help me in my new role as DBA. Most of my SQL work will be bringing
in data that our database application's GUI can't deal with. An
example is to do Inserts Where IDs are In a list.
What recommendations do you have on books that will serve my purpose?
Thanks
-tomThe Guru's guide to Transact by SQL Ken Henderson
Inside SQL server 2000 by Kalen Delaney
http://sqlservercode.blogspot.com/
"tom" wrote:

> Hello -
> My background is networking and system administration. I know basic
> programming constructs, and have done .bat, VBA, and *nix shell
> scripting/programming. I am looking for, at most, two books that can
> help me in my new role as DBA. Most of my SQL work will be bringing
> in data that our database application's GUI can't deal with. An
> example is to do Inserts Where IDs are In a list.
> What recommendations do you have on books that will serve my purpose?
> Thanks
> -tom
>|||"The Guru's guide to Transact by SQL Ken Henderson" is a great book for SQL
programmers.
I would also recommend "Sams teach yourself MS SQL Server in 21 days" for
more dba related issues.
Archer
"SQL" wrote:
> The Guru's guide to Transact by SQL Ken Henderson
> Inside SQL server 2000 by Kalen Delaney
>
> http://sqlservercode.blogspot.com/
>
> "tom" wrote:
>|||Tom,
1. Inside SQL server 2000 by Kalen Delaney -- by far the most indepth and
the best
2. Microsoft SQL Server 2000 Unleashed by Ray Rankins
or
Microsoft SQL Server 2000 Bible by Paul Nielsen
Optional 3rd - for T-SQL programming:
3. Professional SQL Server 2000 Programming by Robert Vieira
HTH
Jerry
"tom" <tomfeldsten@.hotmail.com> wrote in message
news:1127404813.829779.198790@.z14g2000cwz.googlegroups.com...
> Hello -
> My background is networking and system administration. I know basic
> programming constructs, and have done .bat, VBA, and *nix shell
> scripting/programming. I am looking for, at most, two books that can
> help me in my new role as DBA. Most of my SQL work will be bringing
> in data that our database application's GUI can't deal with. An
> example is to do Inserts Where IDs are In a list.
> What recommendations do you have on books that will serve my purpose?
> Thanks
> -tom
>|||Get a book on RDBMS basics. SQL is a declarative, high level language
which is nothing like you have seen or used before. Once you have
foundations, then get some of my books. SQL FOR SMARTIES is a classic,
but you might want to start with SQL PROGRAMMING STYLE or DATA &
DATABASES.
.|||Tom,
SQL for Smarties is a fine book. I do not have a copy of the others but I'm
sure they are good as well.
Nice job by the way Joe.
Jerry
"--CELKO--" <jcelko212@.earthlink.net> wrote in message
news:1127415608.320083.296190@.g43g2000cwa.googlegroups.com...
> Get a book on RDBMS basics. SQL is a declarative, high level language
> which is nothing like you have seen or used before. Once you have
> foundations, then get some of my books. SQL FOR SMARTIES is a classic,
> but you might want to start with SQL PROGRAMMING STYLE or DATA &
> DATABASES.
> .
>|||>The Guru's guide to Transact by SQL Ken Henderson
in fact, all the books by Ken Henderson|||Joe Celko highly recommends The Guru's Guide to Transact SQL by Ken Henderso
n.
I have read SQL for Smarties and it's good, I really enjoyed SQL Puzzles and
Answers.
Joe do you intend to write an updated puzzle book any time soon?
If so let us know.
http://sqlservercode.blogspot.com/
"Jerry Spivey" wrote:

> Tom,
> SQL for Smarties is a fine book. I do not have a copy of the others but I
'm
> sure they are good as well.
> Nice job by the way Joe.
> Jerry
> "--CELKO--" <jcelko212@.earthlink.net> wrote in message
> news:1127415608.320083.296190@.g43g2000cwa.googlegroups.com...
>
>|||> but you might want to start with SQL PROGRAMMING STYLE
well I have ped insed, thanks to Amazon, and I'm a little bit
surprised
the recommendation to use stored procedures (p. 122) and not to use
functions (p. 123). is it really consistent?
you list "portabilty problems" as reason to avoid UDFs, but for
- T-SQL (MS SQL Server)
- PL/SQL (Oracle)
- SQL-PL (DB2)
SQL UDFs are just as portatble, or not portable, as stored procedures
I don't see any major difference in portability between stored
prodeures and UDFs. Could you please explain?|||also the statement on the same that udfs are not inline seems to be not
true, sometimes they are (MS SQL Server):
create table states(state char(2))
insert into states values('IL')
insert into states values('MI')
insert into states values('WI')
create table stateNames(state char(2), sname varchar(20))
insert into stateNames values('IL', 'Illinois')
insert into stateNames values('MI', 'Michigan')
insert into stateNames values('WI', 'Wisconsin')
CREATE FUNCTION getAllStateNames()
RETURNS TABLE
AS
RETURN ( select sname from stateNames )
now look at the execution plan of this statement:
select * from states,getAllStateNames()
obviously the UDF's body is compiled into it. the plan clearly
describes access to stateNames
AFAIK in Oracle the plan would not display what is accessed inside the
UDF, but Oracle is very different

Body BackgroundImage not displayed in browser

I have been trying to set up reports with a background image. The background displays correctly on the preview tab in Visual Studio, but is not visible when deployed to the report server and rendered in Internet Explorer.

However, if the report is printed, or exported to PDF or Excel, the background displays correctly.

It does not seem to make any difference if the image is external or embedded. Also, the problem only seems to affect the Body properties; a background image attached to a table, for example, seems to display correctly.

Has anybody else seen this behavior? I have not done extensive testing, but every report that I have tried seems to have the same problem. Is there a setting someplace that I am missing, or is this perhaps a bug in IE?

This sounds like a known issue in RS 2005 SP1 where the background images does not show up when rendering with the ReportViewer control. This was addressed in a Hotfix and will also be fixed in Visual Studio 2005 SP1.

-Chris

|||

I am running RS 2005 with SP2. When I render a RS report to Internet Explorer the background image still is not displaying, though the image does print. Exactly as described in the origional message. Any ideas?

Thanks!

Body BackgroundImage not displayed in browser

I have been trying to set up reports with a background image. The background displays correctly on the preview tab in Visual Studio, but is not visible when deployed to the report server and rendered in Internet Explorer.

However, if the report is printed, or exported to PDF or Excel, the background displays correctly.

It does not seem to make any difference if the image is external or embedded. Also, the problem only seems to affect the Body properties; a background image attached to a table, for example, seems to display correctly.

Has anybody else seen this behavior? I have not done extensive testing, but every report that I have tried seems to have the same problem. Is there a setting someplace that I am missing, or is this perhaps a bug in IE?

This sounds like a known issue in RS 2005 SP1 where the background images does not show up when rendering with the ReportViewer control. This was addressed in a Hotfix and will also be fixed in Visual Studio 2005 SP1.

-Chris

|||

I am running RS 2005 with SP2. When I render a RS report to Internet Explorer the background image still is not displaying, though the image does print. Exactly as described in the origional message. Any ideas?

Thanks!

Black server reports after installing SP2

After installing SQL Server 2005 SP2 all of our server reports are being rendered with a black background and white text, which needless to say is reversed of how they were being drawn before installing SP2. This only happens when the report viewer is displaying the report in “Print Layout” mode. Normal mode shows the report as expected.

Has anyone else had this problem or suggest a solution? Thanks in advance.

It turned out that this is an issue introduced with SP2 that affects certain video cards. I am also experiencing the same problem but t never occurred to me that this could be actually a bug during the SP2 testing so I never reported it back . The RS team is reviewing currently this issue. Please contact product support and request a hotfix when available.|||

user hotfix :

Replace the "Microsoft.ReportingServices.ImageRendering.dll" from SP2 with "Microsoft.ReportingServices.ImageRendering.dll" from SP1.
The directory is "x:\Program Files\Microsoft SQL Server\MSSQL.x\Reporting Services\ReportServer\bin"

|||

Thanks for the feedback on this Michael. I thought this might work but afer replacing the ImageRendering.dll I get the following error:

"An attempt has been made to use a rendering extension that is not registered for this report server."

Did you get a similar result when you replaced this DLL with the original from SP1?

|||

I am having the same problem: Reports in Print Layout are rendered in a black background

|||As a workaround, you should be able to fix this issue by changing the background color to White instead of Transparent.|||

Yes, this work.

Tanks

|||Hi,

Does anyone know if there's a list yet of cards that have not been affected?

Cheers,
Martin|||

I haven't heard of a resolution that is acceptable yet, with the exception of geting back through all the server reports and deliberatly making the background color white. I'm not too convinced this is nessesarily a video card issue, since every single machine we have seen this on is doing the back background.

Does anyone know if some sort of hotfix has been made available? Just copying in the old DLL from SP1 dosen't work.

|||

Hello,

This issue was indeed introduced in Yukon SP2. It only affects Report Designer preview, it doesn't matter what video card you have, the workaround is to specify background = white in the RDL, and we're working on a QFE.

Regards.

Mike

|||

I am also having the problem ;(

I was a beta tester for SP2, how did we let this slip through? I guess I don't normally use the print preview mode in the report viewer, but apparently my users do!

|||By the way, I have tried making the background white on these reports but there is still a lot of ugly black showing thorugh. I only see options to make the body, header, and footer white. Is there some other background property that I'm missing that would make the entire background of the report white including the margins?|||It didn't resolve the issue for me either. I am also getting blank pages on reports that worked fine before.|||Is there any timeframe for the hotfix on this? There seems to be nothing that we can do to eliminate the black in the margins of the reports and cannot roll back to SP1 in any way. Seems like the only open we have is to completely remove SQL Server and reinstall with SP1.|||I've contacted Microsoft Support about this and they said they couldn't offer a hotfix until there was a KB article number to go by. Is there any work being done to get this fixed? Our clients have been suffering with this problem for weeks now and the response from Microsoft has been mute. Any information would help.

Black server reports after installing SP2

After installing SQL Server 2005 SP2 all of our server reports are being rendered with a black background and white text, which needless to say is reversed of how they were being drawn before installing SP2. This only happens when the report viewer is displaying the report in “Print Layout” mode. Normal mode shows the report as expected.

Has anyone else had this problem or suggest a solution? Thanks in advance.

It turned out that this is an issue introduced with SP2 that affects certain video cards. I am also experiencing the same problem but t never occurred to me that this could be actually a bug during the SP2 testing so I never reported it back . The RS team is reviewing currently this issue. Please contact product support and request a hotfix when available.|||

user hotfix :

Replace the "Microsoft.ReportingServices.ImageRendering.dll" from SP2 with "Microsoft.ReportingServices.ImageRendering.dll" from SP1.
The directory is "x:\Program Files\Microsoft SQL Server\MSSQL.x\Reporting Services\ReportServer\bin"

|||

Thanks for the feedback on this Michael. I thought this might work but afer replacing the ImageRendering.dll I get the following error:

"An attempt has been made to use a rendering extension that is not registered for this report server."

Did you get a similar result when you replaced this DLL with the original from SP1?

|||

I am having the same problem: Reports in Print Layout are rendered in a black background

|||As a workaround, you should be able to fix this issue by changing the background color to White instead of Transparent.|||

Yes, this work.

Tanks

|||Hi,

Does anyone know if there's a list yet of cards that have not been affected?

Cheers,
Martin
|||

I haven't heard of a resolution that is acceptable yet, with the exception of geting back through all the server reports and deliberatly making the background color white. I'm not too convinced this is nessesarily a video card issue, since every single machine we have seen this on is doing the back background.

Does anyone know if some sort of hotfix has been made available? Just copying in the old DLL from SP1 dosen't work.

|||

Hello,

This issue was indeed introduced in Yukon SP2. It only affects Report Designer preview, it doesn't matter what video card you have, the workaround is to specify background = white in the RDL, and we're working on a QFE.

Regards.

Mike

|||

I am also having the problem ;(

I was a beta tester for SP2, how did we let this slip through? I guess I don't normally use the print preview mode in the report viewer, but apparently my users do!

|||By the way, I have tried making the background white on these reports but there is still a lot of ugly black showing thorugh. I only see options to make the body, header, and footer white. Is there some other background property that I'm missing that would make the entire background of the report white including the margins?|||It didn't resolve the issue for me either. I am also getting blank pages on reports that worked fine before.|||Is there any timeframe for the hotfix on this? There seems to be nothing that we can do to eliminate the black in the margins of the reports and cannot roll back to SP1 in any way. Seems like the only open we have is to completely remove SQL Server and reinstall with SP1.|||I've contacted Microsoft Support about this and they said they couldn't offer a hotfix until there was a KB article number to go by. Is there any work being done to get this fixed? Our clients have been suffering with this problem for weeks now and the response from Microsoft has been mute. Any information would help.

Black server reports after installing SP2

After installing SQL Server 2005 SP2 all of our server reports are being rendered with a black background and white text, which needless to say is reversed of how they were being drawn before installing SP2. This only happens when the report viewer is displaying the report in “Print Layout” mode. Normal mode shows the report as expected.

Has anyone else had this problem or suggest a solution? Thanks in advance.

It turned out that this is an issue introduced with SP2 that affects certain video cards. I am also experiencing the same problem but t never occurred to me that this could be actually a bug during the SP2 testing so I never reported it back . The RS team is reviewing currently this issue. Please contact product support and request a hotfix when available.|||

user hotfix :

Replace the "Microsoft.ReportingServices.ImageRendering.dll" from SP2 with "Microsoft.ReportingServices.ImageRendering.dll" from SP1.
The directory is "x:\Program Files\Microsoft SQL Server\MSSQL.x\Reporting Services\ReportServer\bin"

|||

Thanks for the feedback on this Michael. I thought this might work but afer replacing the ImageRendering.dll I get the following error:

"An attempt has been made to use a rendering extension that is not registered for this report server."

Did you get a similar result when you replaced this DLL with the original from SP1?

|||

I am having the same problem: Reports in Print Layout are rendered in a black background

|||As a workaround, you should be able to fix this issue by changing the background color to White instead of Transparent.|||

Yes, this work.

Tanks

|||Hi,

Does anyone know if there's a list yet of cards that have not been affected?

Cheers,
Martin
|||

I haven't heard of a resolution that is acceptable yet, with the exception of geting back through all the server reports and deliberatly making the background color white. I'm not too convinced this is nessesarily a video card issue, since every single machine we have seen this on is doing the back background.

Does anyone know if some sort of hotfix has been made available? Just copying in the old DLL from SP1 dosen't work.

|||

Hello,

This issue was indeed introduced in Yukon SP2. It only affects Report Designer preview, it doesn't matter what video card you have, the workaround is to specify background = white in the RDL, and we're working on a QFE.

Regards.

Mike

|||

I am also having the problem ;(

I was a beta tester for SP2, how did we let this slip through? I guess I don't normally use the print preview mode in the report viewer, but apparently my users do!

|||By the way, I have tried making the background white on these reports but there is still a lot of ugly black showing thorugh. I only see options to make the body, header, and footer white. Is there some other background property that I'm missing that would make the entire background of the report white including the margins?|||It didn't resolve the issue for me either. I am also getting blank pages on reports that worked fine before.|||Is there any timeframe for the hotfix on this? There seems to be nothing that we can do to eliminate the black in the margins of the reports and cannot roll back to SP1 in any way. Seems like the only open we have is to completely remove SQL Server and reinstall with SP1.|||I've contacted Microsoft Support about this and they said they couldn't offer a hotfix until there was a KB article number to go by. Is there any work being done to get this fixed? Our clients have been suffering with this problem for weeks now and the response from Microsoft has been mute. Any information would help.

Black server reports after installing SP2

After installing SQL Server 2005 SP2 all of our server reports are being rendered with a black background and white text, which needless to say is reversed of how they were being drawn before installing SP2. This only happens when the report viewer is displaying the report in “Print Layout” mode. Normal mode shows the report as expected.

Has anyone else had this problem or suggest a solution? Thanks in advance.

It turned out that this is an issue introduced with SP2 that affects certain video cards. I am also experiencing the same problem but t never occurred to me that this could be actually a bug during the SP2 testing so I never reported it back . The RS team is reviewing currently this issue. Please contact product support and request a hotfix when available.|||

user hotfix :

Replace the "Microsoft.ReportingServices.ImageRendering.dll" from SP2 with "Microsoft.ReportingServices.ImageRendering.dll" from SP1.
The directory is "x:\Program Files\Microsoft SQL Server\MSSQL.x\Reporting Services\ReportServer\bin"

|||

Thanks for the feedback on this Michael. I thought this might work but afer replacing the ImageRendering.dll I get the following error:

"An attempt has been made to use a rendering extension that is not registered for this report server."

Did you get a similar result when you replaced this DLL with the original from SP1?

|||

I am having the same problem: Reports in Print Layout are rendered in a black background

|||As a workaround, you should be able to fix this issue by changing the background color to White instead of Transparent.|||

Yes, this work.

Tanks

|||Hi,

Does anyone know if there's a list yet of cards that have not been affected?

Cheers,
Martin|||

I haven't heard of a resolution that is acceptable yet, with the exception of geting back through all the server reports and deliberatly making the background color white. I'm not too convinced this is nessesarily a video card issue, since every single machine we have seen this on is doing the back background.

Does anyone know if some sort of hotfix has been made available? Just copying in the old DLL from SP1 dosen't work.

|||

Hello,

This issue was indeed introduced in Yukon SP2. It only affects Report Designer preview, it doesn't matter what video card you have, the workaround is to specify background = white in the RDL, and we're working on a QFE.

Regards.

Mike

|||

I am also having the problem ;(

I was a beta tester for SP2, how did we let this slip through? I guess I don't normally use the print preview mode in the report viewer, but apparently my users do!

|||By the way, I have tried making the background white on these reports but there is still a lot of ugly black showing thorugh. I only see options to make the body, header, and footer white. Is there some other background property that I'm missing that would make the entire background of the report white including the margins?|||It didn't resolve the issue for me either. I am also getting blank pages on reports that worked fine before.|||Is there any timeframe for the hotfix on this? There seems to be nothing that we can do to eliminate the black in the margins of the reports and cannot roll back to SP1 in any way. Seems like the only open we have is to completely remove SQL Server and reinstall with SP1.|||I've contacted Microsoft Support about this and they said they couldn't offer a hotfix until there was a KB article number to go by. Is there any work being done to get this fixed? Our clients have been suffering with this problem for weeks now and the response from Microsoft has been mute. Any information would help.

Black server reports after installing SP2

After installing SQL Server 2005 SP2 all of our server reports are being rendered with a black background and white text, which needless to say is reversed of how they were being drawn before installing SP2. This only happens when the report viewer is displaying the report in “Print Layout” mode. Normal mode shows the report as expected.

Has anyone else had this problem or suggest a solution? Thanks in advance.

It turned out that this is an issue introduced with SP2 that affects certain video cards. I am also experiencing the same problem but t never occurred to me that this could be actually a bug during the SP2 testing so I never reported it back . The RS team is reviewing currently this issue. Please contact product support and request a hotfix when available.|||

user hotfix :

Replace the "Microsoft.ReportingServices.ImageRendering.dll" from SP2 with "Microsoft.ReportingServices.ImageRendering.dll" from SP1.
The directory is "x:\Program Files\Microsoft SQL Server\MSSQL.x\Reporting Services\ReportServer\bin"

|||

Thanks for the feedback on this Michael. I thought this might work but afer replacing the ImageRendering.dll I get the following error:

"An attempt has been made to use a rendering extension that is not registered for this report server."

Did you get a similar result when you replaced this DLL with the original from SP1?

|||

I am having the same problem: Reports in Print Layout are rendered in a black background

|||As a workaround, you should be able to fix this issue by changing the background color to White instead of Transparent.|||

Yes, this work.

Tanks

|||Hi,

Does anyone know if there's a list yet of cards that have not been affected?

Cheers,
Martin
|||

I haven't heard of a resolution that is acceptable yet, with the exception of geting back through all the server reports and deliberatly making the background color white. I'm not too convinced this is nessesarily a video card issue, since every single machine we have seen this on is doing the back background.

Does anyone know if some sort of hotfix has been made available? Just copying in the old DLL from SP1 dosen't work.

|||

Hello,

This issue was indeed introduced in Yukon SP2. It only affects Report Designer preview, it doesn't matter what video card you have, the workaround is to specify background = white in the RDL, and we're working on a QFE.

Regards.

Mike

|||

I am also having the problem ;(

I was a beta tester for SP2, how did we let this slip through? I guess I don't normally use the print preview mode in the report viewer, but apparently my users do!

|||By the way, I have tried making the background white on these reports but there is still a lot of ugly black showing thorugh. I only see options to make the body, header, and footer white. Is there some other background property that I'm missing that would make the entire background of the report white including the margins?|||It didn't resolve the issue for me either. I am also getting blank pages on reports that worked fine before.|||Is there any timeframe for the hotfix on this? There seems to be nothing that we can do to eliminate the black in the margins of the reports and cannot roll back to SP1 in any way. Seems like the only open we have is to completely remove SQL Server and reinstall with SP1.|||I've contacted Microsoft Support about this and they said they couldn't offer a hotfix until there was a KB article number to go by. Is there any work being done to get this fixed? Our clients have been suffering with this problem for weeks now and the response from Microsoft has been mute. Any information would help.

Black server reports after installing SP2

After installing SQL Server 2005 SP2 all of our server reports are being rendered with a black background and white text, which needless to say is reversed of how they were being drawn before installing SP2. This only happens when the report viewer is displaying the report in “Print Layout” mode. Normal mode shows the report as expected.

Has anyone else had this problem or suggest a solution? Thanks in advance.

It turned out that this is an issue introduced with SP2 that affects certain video cards. I am also experiencing the same problem but t never occurred to me that this could be actually a bug during the SP2 testing so I never reported it back . The RS team is reviewing currently this issue. Please contact product support and request a hotfix when available.|||

user hotfix :

Replace the "Microsoft.ReportingServices.ImageRendering.dll" from SP2 with "Microsoft.ReportingServices.ImageRendering.dll" from SP1.
The directory is "x:\Program Files\Microsoft SQL Server\MSSQL.x\Reporting Services\ReportServer\bin"

|||

Thanks for the feedback on this Michael. I thought this might work but afer replacing the ImageRendering.dll I get the following error:

"An attempt has been made to use a rendering extension that is not registered for this report server."

Did you get a similar result when you replaced this DLL with the original from SP1?

|||

I am having the same problem: Reports in Print Layout are rendered in a black background

|||As a workaround, you should be able to fix this issue by changing the background color to White instead of Transparent.|||

Yes, this work.

Tanks

|||Hi,

Does anyone know if there's a list yet of cards that have not been affected?

Cheers,
Martin
|||

I haven't heard of a resolution that is acceptable yet, with the exception of geting back through all the server reports and deliberatly making the background color white. I'm not too convinced this is nessesarily a video card issue, since every single machine we have seen this on is doing the back background.

Does anyone know if some sort of hotfix has been made available? Just copying in the old DLL from SP1 dosen't work.

|||

Hello,

This issue was indeed introduced in Yukon SP2. It only affects Report Designer preview, it doesn't matter what video card you have, the workaround is to specify background = white in the RDL, and we're working on a QFE.

Regards.

Mike

|||

I am also having the problem ;(

I was a beta tester for SP2, how did we let this slip through? I guess I don't normally use the print preview mode in the report viewer, but apparently my users do!

|||By the way, I have tried making the background white on these reports but there is still a lot of ugly black showing thorugh. I only see options to make the body, header, and footer white. Is there some other background property that I'm missing that would make the entire background of the report white including the margins?|||It didn't resolve the issue for me either. I am also getting blank pages on reports that worked fine before.|||Is there any timeframe for the hotfix on this? There seems to be nothing that we can do to eliminate the black in the margins of the reports and cannot roll back to SP1 in any way. Seems like the only open we have is to completely remove SQL Server and reinstall with SP1.|||I've contacted Microsoft Support about this and they said they couldn't offer a hotfix until there was a KB article number to go by. Is there any work being done to get this fixed? Our clients have been suffering with this problem for weeks now and the response from Microsoft has been mute. Any information would help.