|
SQL
Server Links
Spotlight: Inside Microsoft SQL Server 2000
Fun Link: Think
Geek
Go directly to:
Magazines and Books Tools
Orgs,Grps,Conferences
Q & A
Microsoft Links
My Articles
Main
SQL Server Page
Magazines
and Books
Kalen
Delaney is THE expert on SQL Server. Her
"Inside SQL" series gives great information on the internals of SQL
Server, the "why it does this" stuff. These books are invaluable to
DBAs and developers. She, along with many other SQL Server experts and
MVPs, can be found at Soild Quality
Learning.
Here's the review I wrote for bn.com on
Inside SQL Server 2000:
An absolute 'must buy' for the serious DBA!
This book is INVALUABLE as a troubleshooting reference, as well as in the proper
physical design of a database. The concepts in this book give the reader a solid
foundation for understanding how and why internal things work the way they do.
Once you understand the internals, you can follow up with other books on the
bells and whistles that exist outside of the internal engines. This is a book
for people who want to understand 'why' things work they way they do, so the
book doesn't clutter things up with teaching newbies 'how' to do things. For
some reason there seems to be an expectation that the book should cover XML, but
there are a couple of reasons why that is not reasonable. First of all, XML is
not really 'inside' SQL Server 2000. Only very base level XML functionality was
present at the time the product and the book were released. XML functionality
has since been added in separate SQLXML releases (not in the SQL Server service
packs). Since XML is not part of the internals AND it was not available at the
time the book went to press, there is no reason to expect XML to be included in
this book. If future versions of SQL Server truly include XML in the internals,
and include them at release time, then the expection can reasonably change. If
you want to know about XML, then there are books available to tell you all about
it :-) All in all, this book is a must-have for anyone working as a SQL Server
DBA!
Ken
Henderson has some great "Guru's Guide" books on TSQL, XML, and
architecture. While Kalen concentrates on the
"why", Ken tells us about the "how".
| SQL Server Magazine
|
Technical, how-to
information. Some of the information is public and some if available
only by subscription.
Subscribe to SQL Server Magazine
Update - a FREE, weekly, email newsletter covering the latest SQL Server
news and tips.
|
| SQL
Server Professional |
Newsletter
with lots of helpful tips. |
| MCP
Magazine |
The latest independent information on Microsoft products and
the MCP program. |
Back to Top
SQL Server Organizations, Groups, and Conferences
| SSWUG |
SQL Server Worldwide User Group |
| NTSSUG
|
North Texas SQL Server Users Group |
| PASS
|
Professional Association for SQL Server |
Back to Top
Tools
| insertXPress |
Automatically generates INSERT scripts |
| Log
Explorer |
Log Explorer is the first and only product available to use the log information
to selectively recover data, analyze user and application problems, and audit
activity; all without run-time overhead. |
| mssqlXpress
|
Development tool for
Microsoft® SQL Server that connects with Microsoft® Visual SourceSafe |
Back to Top
Get Your
Questions Answered
| SQL
Monster |
Tips, tricks, forums |
| SQL
Server Portal |
Tools, hardware, books, etc. |
| SQL
Junkies |
SQL Blogs and more |
| SQL
Dev |
SQL Server Developer's Network |
| SQL-Server-Performance |
Your Source for SQL Server Performance Tuning and Optimization Tips |
| SQL Security |
Dedicated to SQL
Server security |
|
SQL Server Magazine |
SQLMag discussion group |
| MSSQLServer |
SQL MVP Michael Hotek's site
with lots of articles, tips, scripts, etc. |
| SQL Server Central |
Scripts, columns, and much more |
|
DevX
|
Get help with SQL
Server |
| Search Database
|
Targeted Searches |
| SQLDTS |
DTS resource |
| Mark Allison |
SQL
Contractor in the UK |
| Vyas' SQL Information |
Resources,
FAQ, etc. |
| Umachandar |
SQL Technical
resources from a SQL MVP |
| Common SQL Answers
|
Things to try when resolving a
problem |
Back to Top
Official
Microsoft Links
Back to Top
SQL
Server Directory - My articles
How to Troubleshoot a Performance
Problem
Troubleshooting Blocking
How to Move a Database
Get the Latest Service Pack
Misc. Tips and Tools
SQL Server Knowledge Base Articles
Common
SQL Server Answers
SQL
Server and Related Links
Back to Top
Main SQL Server Page
|
