October 4, 2004 at 3:11 pm
Hi guys
Quick question for you......I need some recommendations for a text
book. I have novice/intermediate esperience of SQL andam looking
to expand my knowledge of SQL programming (especially SQL Server).
any ideas of some good books which focusses on SQL coding/sql server rather
than 100% database design?
Also, I couldnt find any good forums on VBA. Im at an intermediate level in VB but have never used
VBa before. Any good suggestions for VBA books, covering the wider
aspect of VBA, i.e. excel/access and general VBA syntax. etc...
Thanks guys, help appreciated!
If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!
October 4, 2004 at 7:03 pm
Inside SQL Server 2000 by Kalen Delaney/Ron Soukop is a very good detailed look at SQL Server. It does not just address writing SQL, it also tells you how the internals work, which is important for you to understand if you want to optimize your queries.
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
October 4, 2004 at 11:39 pm
Some other books for writing T-SQL:
Advanced Transact-SQL for SQL Server 2000, Itzik Ben-Gan and Dr. Tom Moreau
The Guru's Guide to Transact-SQL, Ken Henderson
Professional SQL Server 2000 Programming, Robert Vieira
K. Brian Kelley
@kbriankelley
October 5, 2004 at 6:15 am
For getting started w/T-SQL I found this book useful:
Microsoft SQL Server 2000 Programing by Example, Guerrero and Rojas
October 5, 2004 at 6:44 am
A very good way to learn VBA is try to automate an existing business process that uses Word, Excel, PowerPoint etc. The macro recorder in Excel is a great tool for getting a handle on the VBA syntax.
The Excel Power Programming books by Walkenbach are very good.
The Access Developer's Handbook series is very good for learing about programming Access (Getz,Litwin & Gunderloy)
The VBA Developers Handbook (Getz & Gilbert) is also very good.
October 5, 2004 at 9:36 am
I have found the following books to be very helpful...
Microsoft SQL Server 2000 Administrator's Pocket Consultant (Microsoft Press)
The Guru's Guide to Transact-SQL (Ken Henderson)
SQL Server 2000: The Complete Reference (Jeffrey Shapiro)
Professional SQL Server 2000 DTS (Brian Knight, Todd Robinson)
October 5, 2004 at 9:36 am
VBA Forum
Not exclusively VBA but a good source of info. Like one of the previous posters suggested using Excel Macro recorder is a good way to pick up some VBA. I started with "Microsoft Excel VBA Programming for the Absolute Beginner" by Duane Birnbaum. Read the first half of the book to get basic syntax down and then went off on my own from there.
MSDN website has good VBA info.
Also Safari Books allows you to keep a bookshelf of books you can read and search online for a monthly fee.
http://www.safaribooksonline.com/
Sean Wyatt
seanwyatt.com
October 5, 2004 at 9:42 am
I'm also a big fan of Safari. Safari is well-worth the money, IMO. I use it extensively. Most of my Active Directory library is sitting out on Safari right now.
K. Brian Kelley
@kbriankelley
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply