Best SQL DBA and BI magazines to order

Hi...I would like to order some magazines about SQL DBA and BI. would
anybody suggest some good options?
Thanks.SQL Magazine would be my first choice. http://www.sqlmag.com
Andrew J. Kelly SQL MVP
Solid Quality Mentors
<yvette.ye@.gmail.com> wrote in message
news:48ba86d8-e399-40d0-bfa6-f1fa41e404a1@.y21g2000hsf.googlegroups.com...
> Hi...I would like to order some magazines about SQL DBA and BI. would
> anybody suggest some good options?
> Thanks.|||On Apr 22, 6:27=A0pm, "Andrew J. Kelly" <sqlmvpnooos...@.shadhawk.com>
wrote:
> SQLMagazinewould be my first choice. =A0http://www.sqlmag.com
> --
> Andrew J. Kelly =A0 =A0SQL MVP
> Solid Quality Mentors
> <yvette...@.gmail.com> wrote in message
> news:48ba86d8-e399-40d0-bfa6-f1fa41e404a1@.y21g2000hsf.googlegroups.com...
>
> > Hi...I would like to order some magazines about SQL DBA and BI. would
> > anybody suggest some good options?
> > Thanks.- Hide quoted text -
> - Show quoted text -
Any other options, other than SQLMag? Is there any magazine for BI
(Business Intelligence)?|||SQL Mag does have BI content as well but I don't know of any BI specific
magazines related to SQL Server off hand.
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
<yvette.ye@.gmail.com> wrote in message
news:dfa0ad5f-a16f-4eae-88d6-3197c8933efa@.x35g2000hsb.googlegroups.com...
On Apr 22, 6:27 pm, "Andrew J. Kelly" <sqlmvpnooos...@.shadhawk.com>
wrote:
> SQLMagazinewould be my first choice. http://www.sqlmag.com
> --
> Andrew J. Kelly SQL MVP
> Solid Quality Mentors
> <yvette...@.gmail.com> wrote in message
> news:48ba86d8-e399-40d0-bfa6-f1fa41e404a1@.y21g2000hsf.googlegroups.com...
>
> > Hi...I would like to order some magazines about SQL DBA and BI. would
> > anybody suggest some good options?
> > Thanks.- Hide quoted text -
> - Show quoted text -
Any other options, other than SQLMag? Is there any magazine for BI
(Business Intelligence)?

best provider for connection to SQL ?

Hi ,
any one can suggest me wich is the best provider connection I can use
for my program to connect to an MSSQL 2000, currently I use the
"Microsoft ADO OLEDB for SQL" .
Thanks,
Paolol
OLEDB will give you more functionality than ODBC so that's a
good choice. You want to look at the latest (or at least one
of the later ones) version of MDAC to have more stability.
-Sue
On Fri, 21 Oct 2005 16:18:00 +0200, paolol
<paolol@._nospamma_salsan.net> wrote:

>Hi ,
>any one can suggest me wich is the best provider connection I can use
>for my program to connect to an MSSQL 2000, currently I use the
>"Microsoft ADO OLEDB for SQL" .
>Thanks,
>Paolol

best provider for connection to SQL ?

Hi ,
any one can suggest me wich is the best provider connection I can use
for my program to connect to an MSSQL 2000, currently I use the
"Microsoft ADO OLEDB for SQL" .
Thanks,
PaololOLEDB will give you more functionality than ODBC so that's a
good choice. You want to look at the latest (or at least one
of the later ones) version of MDAC to have more stability.
-Sue
On Fri, 21 Oct 2005 16:18:00 +0200, paolol
<paolol@._nospamma_salsan.net> wrote:

>Hi ,
>any one can suggest me wich is the best provider connection I can use
>for my program to connect to an MSSQL 2000, currently I use the
>"Microsoft ADO OLEDB for SQL" .
>Thanks,
>Paololsql

best practices for writing SQL server stored procedures

Dear All,

Please suggest some of the best practices for writing SQL server
stored procedures?
I'm writing a business function (stored procedure), which calls
many-stored procedure one after another.
I want this to be best optimized, so that speed can be very good.

Suggestion in this regard will be appreciated.

Thanks in advance,
T.S.NegiHere are some of the best practices that I use:
http://www.extremeexperts.com/SQL/A...tPractices.aspx

--
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

"T.S.Negi" <tilak.negi@.mind-infotech.com> wrote in message
news:a1930058.0502132116.761a1b9a@.posting.google.c om...
> Dear All,
> Please suggest some of the best practices for writing SQL server
> stored procedures?
> I'm writing a business function (stored procedure), which calls
> many-stored procedure one after another.
> I want this to be best optimized, so that speed can be very good.
> Suggestion in this regard will be appreciated.
> Thanks in advance,
> T.S.Negi

Best book for SQL Server 2005 Administration

Can anyone please suggest a good book for SQL Server 2005 Administration for
experienced SQL Server 2000 DBA.
Thanks in advance.
ManuManu,
I can personally recommend these 2 books:
As a good general coverage - "Pro SQL Server 2005"
http://www.itbookworm.com/Review.asp?ID=11
For the internals in detail: "Inside Microsoft SQL Server 2005: The Storage
Engine"
http://www.amazon.com/Inside-Micros...ie=UTF8&s=books
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

Best book for SQL Server 2005 Administration

Can anyone please suggest a good book for SQL Server 2005 Administration for
experienced SQL Server 2000 DBA.
Thanks in advance.
Manu
Manu,
I can personally recommend these 2 books:
As a good general coverage - "Pro SQL Server 2005"
http://www.itbookworm.com/Review.asp?ID=11
For the internals in detail: "Inside Microsoft SQL Server 2005: The Storage
Engine"
http://www.amazon.com/Inside-Microsoft-SQL-Server-2005/dp/0735621055/sr=8-1/qid=1167940895/ref=pd_bbs_sr_1/102-9099990-2949748?ie=UTF8&s=books
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .