Dazzler

Hi

Can anyobne recommend good reference books for the above please? I know that 2005 is very new and will probably change a bit in the coming months so there probably isn't much around at the mo, but if there are any please let me know.

Thanks

ChefDude

are you a dba or a coder?

Dazzler

A consultant who would probably fit more in the dba role.

ChefDude

ah, shame, i know some corking coder/sql server/transact related books.

dba world is different to mine.

(more dosh generally )

Dazzler

Okay, no worries

Dazzler

Anyone else got any suggested books they use as reference?

ChefDude

I'd have a look at the top rated books in amazon and read the reviews.

i tend to go for Wrox myself.

Mutts Nutts

Hi,

I've just done the Microsoft SQL 2005 course for 2000 DBA's and got the official MS curriculum stuff I can let you have a copy of, I'll dig out some stuff for you, links etc. Theres some undocumented tricks and tips that are mentioned on the course can post up these links for you.

I'm now more of a coder than a DBA also, to an extent you cant be a developer without knowing some of the dba role and vice versa. This is even more appaerent for 2005 as I have seen so far, in 2005 the DBA cant avoid rolling there sleaves up and getting down to some coding, The new SQL Management Objects that is aimed at DBA's is in itself a programming interface with Visual Studio 2005 embedded/ integrated and appears as Buisness Intelligence Development Studio as a menu option in the SQLServer programs group. So as is much the case in the Sys Admin's case for the OS to work smarter as a DBA you need to be ab;e to automate/ code some of the routine DBA tasks.
If you can learn to script or programmatically run your routine Admin tasks lifes sweet

I'll give you an addy for FTP when i put them up

Mutts Nutts

Yep, some of the stuff has had about 3 major rewrites between beta and final release (DB Mirroring) and MS in their own words are not 100% confident about it still

little'un

iTrader: (9)

I'm DBA, and would like to learn more

I'll keep an eye out

Mutts Nutts

I know... I was loosing the will to live at some points in the course... For a DBA course though we spent the majority of the time in the BI Tool (Visual Studio 2005) and tyhe New Query analyser, which was good for me ... but a lot of lost vacant expresssions from the hardcore DBA's ... so DBA's beware

Dazzler

Cheers Mutts! I've done the MS SQL 2000 Admin course, and only the Updating your admin skills for 2005, so your notes would be very helpful.

The guy running the course for 2005 said that he strongly believes that it will change quite a bit from its initial release look and feel, as it is very biased towards developers at the mo, plus there are a few things that need ironing out. Can't elaborate more unfortunately, sorry!
If anyone else can that'd be useful too?

ChefDude

actually for not being a dba, i've spent most of the last week in query analyser!

Mutts Nutts

[quote=Dazzler] ... as it is very biased towards developers at the mo ...quote]

yep, its a developers dreams answered (well not quite ) It is well accepted that the mean reason to consider 2005 would be the .Net Integration. the 2005 Database engine hosts the .NET CLR giving the developer the opportunity to code using their preffered .Net language rather than using TSQL. On the course we wrote some stuff in Visual C# .. creating a stored procedure.

I'll post the stuff i got when i got a moment

TopBanana

The .net integration stuff isn't intended to replace TSQL, it's equivalent to the unmanaged extended stored procs.

Mutts Nutts

interesting topic @ http://www.adtmag.com/article.asp?id=11148