Joe Celko Avoiding the EAV of Destruction
by Joe Celko | 18 June 2009 |  7 comments |
A forum posting, from someone who wanted a better solution to the common problem of handling global settings in a database, leads Joe Celko into a fascinating discussion of the ramifications of the various solutions. Read more...
Brad McGehee Brad's Sure Guide to Indexes
by Brad McGehee | 11 June 2009 |  15 comments |
In order to best appreciate the reasons for, or importance of, the various administrative tasks that are needed for indexes, it is a good idea to take a look at how the various types of indexes work. Who better to help with a clear expanation for this than Brad McGehee? Read more...
James Moore DBA:M and the SQL Backup 6.0 pre-release
by James Moore | 29 May 2009 |
Rodney Landrum, DBA manager in Pensacola, Florida, puts the pain of DBA:M into context as we learn about how SQL Backup can evolve to keep pace. Take a look at the changes we’ve got planned to help time-pressed DBAs in the forthcoming pre-release of version 6.0,... Read more...
  Learn SQL Server (34 articles)
  SQL Training (6 articles)

  Database Administration (45 articles)
  SQL Server 2005 (18 articles)

  T-SQL Programming (61 articles)
  Performance (12 articles)

  Backup and Recovery (17 articles)
  SQL Tools (41 articles)










Phil Factor
To Boldly Ask IT for Development Work
 Phil has always been mystified by the way that, in Science-Fiction films, the crew of space-ships are able to... Read more...



 View the blog
Beginning SQL Server 2005 Reporting Services Part 1
 Steve Joubert begins an in-depth tour of SQL Server 2005 Reporting Services with a step-by-step guide... Read more...

Ten Common Database Design Mistakes
 Database design and implementation is the cornerstone of any data centric project (read 99.9% of... Read more...

Beginning SQL Server 2005 Reporting Services Part 2
 Continuing his in-depth tour of SQL Server 2005 Reporting Services, Steve Joubert demonstrates the most... Read more...

SQL Server Full Text Search Language Features
 SQL Full-text Search (SQL FTS) is an optional component of SQL Server 7 and later, which allows fast... Read more...

Executing SSIS Packages
 Nigel Rivett demonstrates how to execute all SSIS packages in a given folder using either an SSIS... Read more...

Over 150,000 Microsoft professionals subscribe to the Simple-Talk technical journal. Join today, it's fast, simple, free and secure.

Join Simple Talk