New to SQL -- Any good reads?

With my recent employment at my internship, I've been given the task to start
learning as much about SQL servers and querying(sp?) as possible.
I was wondering if there is anybody out there knows of some good
articles/books that would send me on my way?
I'm not looking for "super" basic stuff but as I've been exposed to
databases in the past but would like to get into more deeper topics. I guess
something along the lines of not a novice but no where near being able to
administer a DB myself.
Thanks,
BenSome good ones.
Microsoft SQL Server Books
http://vyaskn.tripod.com/sqlbooks.htm
AMB
"Ben" wrote:
> With my recent employment at my internship, I've been given the task to start
> learning as much about SQL servers and querying(sp?) as possible.
> I was wondering if there is anybody out there knows of some good
> articles/books that would send me on my way?
> I'm not looking for "super" basic stuff but as I've been exposed to
> databases in the past but would like to get into more deeper topics. I guess
> something along the lines of not a novice but no where near being able to
> administer a DB myself.
> Thanks,
> Ben|||Kalen Delaney's Inside SQL Server is my desktop bible, offers enough info on
almost all facets in depth enough to make it invaluable.
"Ben" wrote:
> With my recent employment at my internship, I've been given the task to start
> learning as much about SQL servers and querying(sp?) as possible.
> I was wondering if there is anybody out there knows of some good
> articles/books that would send me on my way?
> I'm not looking for "super" basic stuff but as I've been exposed to
> databases in the past but would like to get into more deeper topics. I guess
> something along the lines of not a novice but no where near being able to
> administer a DB myself.
> Thanks,
> Ben|||Hi,
SQL Server Books online will be a very good option.
Thanks
Hari
SQL Server MVP
"Ben" <Ben@.discussions.microsoft.com> wrote in message
news:BEA56BB4-BE39-4C1B-89EB-24B2AEE2BC81@.microsoft.com...
> With my recent employment at my internship, I've been given the task to
> start
> learning as much about SQL servers and querying(sp?) as possible.
> I was wondering if there is anybody out there knows of some good
> articles/books that would send me on my way?
> I'm not looking for "super" basic stuff but as I've been exposed to
> databases in the past but would like to get into more deeper topics. I
> guess
> something along the lines of not a novice but no where near being able to
> administer a DB myself.
> Thanks,
> Ben

New to SQL -- Any good reads?

With my recent employment at my internship, I've been given the task to start
learning as much about SQL servers and querying(sp?) as possible.
I was wondering if there is anybody out there knows of some good
articles/books that would send me on my way?
I'm not looking for "super" basic stuff but as I've been exposed to
databases in the past but would like to get into more deeper topics. I guess
something along the lines of not a novice but no where near being able to
administer a DB myself.
Thanks,
Ben
Some good ones.
Microsoft SQL Server Books
http://vyaskn.tripod.com/sqlbooks.htm
AMB
"Ben" wrote:

> With my recent employment at my internship, I've been given the task to start
> learning as much about SQL servers and querying(sp?) as possible.
> I was wondering if there is anybody out there knows of some good
> articles/books that would send me on my way?
> I'm not looking for "super" basic stuff but as I've been exposed to
> databases in the past but would like to get into more deeper topics. I guess
> something along the lines of not a novice but no where near being able to
> administer a DB myself.
> Thanks,
> Ben
|||Kalen Delaney's Inside SQL Server is my desktop bible, offers enough info on
almost all facets in depth enough to make it invaluable.
"Ben" wrote:

> With my recent employment at my internship, I've been given the task to start
> learning as much about SQL servers and querying(sp?) as possible.
> I was wondering if there is anybody out there knows of some good
> articles/books that would send me on my way?
> I'm not looking for "super" basic stuff but as I've been exposed to
> databases in the past but would like to get into more deeper topics. I guess
> something along the lines of not a novice but no where near being able to
> administer a DB myself.
> Thanks,
> Ben
|||Hi,
SQL Server Books online will be a very good option.
Thanks
Hari
SQL Server MVP
"Ben" <Ben@.discussions.microsoft.com> wrote in message
news:BEA56BB4-BE39-4C1B-89EB-24B2AEE2BC81@.microsoft.com...
> With my recent employment at my internship, I've been given the task to
> start
> learning as much about SQL servers and querying(sp?) as possible.
> I was wondering if there is anybody out there knows of some good
> articles/books that would send me on my way?
> I'm not looking for "super" basic stuff but as I've been exposed to
> databases in the past but would like to get into more deeper topics. I
> guess
> something along the lines of not a novice but no where near being able to
> administer a DB myself.
> Thanks,
> Ben
sql

New to SQL -- Any good reads?

With my recent employment at my internship, I've been given the task to star
t
learning as much about SQL servers and querying(sp?) as possible.
I was wondering if there is anybody out there knows of some good
articles/books that would send me on my way?
I'm not looking for "super" basic stuff but as I've been exposed to
databases in the past but would like to get into more deeper topics. I gues
s
something along the lines of not a novice but no where near being able to
administer a DB myself.
Thanks,
BenSome good ones.
Microsoft SQL Server Books
http://vyaskn.tripod.com/sqlbooks.htm
AMB
"Ben" wrote:

> With my recent employment at my internship, I've been given the task to st
art
> learning as much about SQL servers and querying(sp?) as possible.
> I was wondering if there is anybody out there knows of some good
> articles/books that would send me on my way?
> I'm not looking for "super" basic stuff but as I've been exposed to
> databases in the past but would like to get into more deeper topics. I gu
ess
> something along the lines of not a novice but no where near being able to
> administer a DB myself.
> Thanks,
> Ben|||Kalen Delaney's Inside SQL Server is my desktop bible, offers enough info on
almost all facets in depth enough to make it invaluable.
"Ben" wrote:

> With my recent employment at my internship, I've been given the task to st
art
> learning as much about SQL servers and querying(sp?) as possible.
> I was wondering if there is anybody out there knows of some good
> articles/books that would send me on my way?
> I'm not looking for "super" basic stuff but as I've been exposed to
> databases in the past but would like to get into more deeper topics. I gu
ess
> something along the lines of not a novice but no where near being able to
> administer a DB myself.
> Thanks,
> Ben|||Hi,
SQL Server Books online will be a very good option.
Thanks
Hari
SQL Server MVP
"Ben" <Ben@.discussions.microsoft.com> wrote in message
news:BEA56BB4-BE39-4C1B-89EB-24B2AEE2BC81@.microsoft.com...
> With my recent employment at my internship, I've been given the task to
> start
> learning as much about SQL servers and querying(sp?) as possible.
> I was wondering if there is anybody out there knows of some good
> articles/books that would send me on my way?
> I'm not looking for "super" basic stuff but as I've been exposed to
> databases in the past but would like to get into more deeper topics. I
> guess
> something along the lines of not a novice but no where near being able to
> administer a DB myself.
> Thanks,
> Ben

New to MS SQL 2000

How do I backup databases, onto Veritas Backup? In the Enterprise Edition if
I expand the database server I could select all task, backup database and
select the destination.
"OSA" <OSA@.discussions.microsoft.com> wrote in message
news:58C5D3AA-D2FC-419E-B560-DD5703546B5A@.microsoft.com...
> How do I backup databases, onto Veritas Backup? In the Enterprise Edition
if
> I expand the database server I could select all task, backup database and
> select the destination.
If you've got the Veritas netbackup SQL Server agent, you can configure
netback to capture all relevant databases. If not, you can use the SQL
Server backup database task wizard to backup your databases, then use
netbackup to backup these files.
Steve

New release of SqlClrProject

I thought I better post before this year ends. :-)
Anyway, you may know that I have developed a MSBUILD task dll for
deployment of SQLCLR assemblies. I also created some templates for use
from with Visual Studio 2005, the SQLCLRProject.
I have re-created this as an Add-In for VS, so you now have the ability
to automatically deploy from inside of VS as well as debug! I have also
created a GUI front-end for those who don't use VS which allows
deploying of assemblies using this front-end (setting properties etc).
So what exactly does all this do:
The SqlClrProject is a project type for Visual Studio 2005 for creation
and deployment of assemblies to SQL Server 2005. It consists of
templates for both Visual C# (C#) and Visual Basic (VB) with skeleton
code for creation of CLR methods to be used as stored procedures, User
Defined Functions (UDF's), triggers, User Defined Types (UDT's) and User
Defined Aggregates (UDA's). Some of the features are:
* Ability to deploy the assembly to SQL Server and create the SQL
Server methods, all from inside the Visual Studio IDE.
* Automatic creation of T-SQL deployment scripts.
* Automatic creation of T-SQL DML scripts for testing of the created
objects.
* Ability to alter an assembly and only deploy newly added methods
from the assembly.
* Ability to create objects in a non default schema
"schemaname.objectname".
* Debug facilities from inside VS.
For you who have used the SQL Server Project project type from VS to do
this, you may wonder what the differences are. Things that the
SqlClrProject allows you to do, which the VS SQL Server project can't
do:
* Automatic creation of T-SQL deployment scripts.
* Automatic creation of T-SQL DML scripts for testing of the created
objects.
* Ability to alter an assembly and only deploy newly added methods
from the assembly.
* Ability to create objects in a non default schema
"schemaname.objectname".
Anyway, if you are interested you can download all needed from here:
[0].
Un-zip the file and read the README.txt file in the root directory.
Comments are as usual very welcome!!!
Finally I wish you all a very Happy New Year!!!
Niels
[0]: http://staff.develop.com/nielsb/cod...ropAndAddIn.zip
****************************************
**********
* Niels Berglund
* http://staff.develop.com/nielsb
* nielsb@.no-spam.develop.com
* "A First Look at SQL Server 2005 for Developers"
* http://www.awprofessional.com/title/0321180593
****************************************
**********Thanks Niels! I'll check it out. It would be to put up at Channel9
sandbox if you get a chance.
William Stacey [MVP]
"Niels Berglund" <nielsb@.develop.com> wrote in message
news:Xns97388D87ACF40nielsbdevelopcom@.20
7.46.248.16...
>I thought I better post before this year ends. :-)
> Anyway, you may know that I have developed a MSBUILD task dll for
> deployment of SQLCLR assemblies. I also created some templates for use

New release of SqlClrProject

I thought I better post before this year ends. :-)
Anyway, you may know that I have developed a MSBUILD task dll for
deployment of SQLCLR assemblies. I also created some templates for use
from with Visual Studio 2005, the SQLCLRProject.
I have re-created this as an Add-In for VS, so you now have the ability
to automatically deploy from inside of VS as well as debug! I have also
created a GUI front-end for those who don't use VS which allows
deploying of assemblies using this front-end (setting properties etc).
So what exactly does all this do:
The SqlClrProject is a project type for Visual Studio 2005 for creation
and deployment of assemblies to SQL Server 2005. It consists of
templates for both Visual C# (C#) and Visual Basic (VB) with skeleton
code for creation of CLR methods to be used as stored procedures, User
Defined Functions (UDF's), triggers, User Defined Types (UDT's) and User
Defined Aggregates (UDA's). Some of the features are:
* Ability to deploy the assembly to SQL Server and create the SQL
Server methods, all from inside the Visual Studio IDE.
* Automatic creation of T-SQL deployment scripts.
* Automatic creation of T-SQL DML scripts for testing of the created
objects.
* Ability to alter an assembly and only deploy newly added methods
from the assembly.
* Ability to create objects in a non default schema
"schemaname.objectname".
* Debug facilities from inside VS.
For you who have used the SQL Server Project project type from VS to do
this, you may wonder what the differences are. Things that the
SqlClrProject allows you to do, which the VS SQL Server project can't
do:
* Automatic creation of T-SQL deployment scripts.
* Automatic creation of T-SQL DML scripts for testing of the created
objects.
* Ability to alter an assembly and only deploy newly added methods
from the assembly.
* Ability to create objects in a non default schema
"schemaname.objectname".
Anyway, if you are interested you can download all needed from here:
[0].
Un-zip the file and read the README.txt file in the root directory.
Comments are as usual very welcome!!!
Finally I wish you all a very Happy New Year!!!
Niels
[0]: http://staff.develop.com/nielsb/code...opAndAddIn.zip
**************************************************
* Niels Berglund
* http://staff.develop.com/nielsb
* nielsb@.no-spam.develop.com
* "A First Look at SQL Server 2005 for Developers"
* http://www.awprofessional.com/title/0321180593
**************************************************
Thanks Niels! I'll check it out. It would be cool to put up at Channel9
sandbox if you get a chance.
William Stacey [MVP]
"Niels Berglund" <nielsb@.develop.com> wrote in message
news:Xns97388D87ACF40nielsbdevelopcom@.207.46.248.1 6...
>I thought I better post before this year ends. :-)
> Anyway, you may know that I have developed a MSBUILD task dll for
> deployment of SQLCLR assemblies. I also created some templates for use

New MS SQL Server

How do I backup databases, onto Veritas Backup? In the Enterprise Edition if
I expand the database server I could select all task, backup database and
select the destination. Which is the proper way to backup these databases.
You could get a Veritas agent that will be able to back up the database real
time. The problem with using the plain vanilla Backup EXEC is that it can't
back up a file that is in use. Alternatively, you can use a scheduled task
within Enterprise Manager to back up the database before you backup to tape.
We have ours set up this way and it works well...
Regards,
Hank Arnold
"OSA" <OSA@.discussions.microsoft.com> wrote in message
news:12671BDC-34F2-427E-80EF-753A96DC4818@.microsoft.com...
> How do I backup databases, onto Veritas Backup? In the Enterprise Edition
> if
> I expand the database server I could select all task, backup database and
> select the destination. Which is the proper way to backup these databases.