Joe Celko SQL and the Snare of Three-Valued Logic
by Joe Celko | 07 May 2009 |  10 comments |
The whole subject of the Three-Valued (also known as ternary, trivalent or 3VL) Logic of SQL tends to trip people up. This is hardly surprising in view of the fact that it involves an esoteric Polish mathematician and because it behaves differently in the DDL (Data... Read more...
Robert Sheldon SQL Server Data Warehouse Cribsheet
by Robert Sheldon | 03 November 2008 |  4 comments |
It is time to shed light on Data Warehousing and to explain how SSAS, SSRS and Business Intelligence fit into the puzzle. Who better to explain it all then Robert Sheldon. Read more...
Hugh Bin-Haad. The Concept of Cardinal Reciprocity- A Primer
by Hugh Bin-Haad. | 01 April 2008 |  25 comments |
Too many authors in the field of relational theory have neglected the concept of Cardinal Reciprocity. This can cause a number of subtle problems with database design in terms of its derivability, redundancy, and consistency. . Increasingly, this little-understood... Read more...
Douglas Reilly SQL Server and .NET training and career development Part 3
by Douglas Reilly | 07 June 2006 |  4 comments |
How do you keep your skills current? How will you prepare yourself for what you will be doing 5 years from now? In this article, part III of the series, I discuss books and the role they can play in keeping the developer up to date. Read more...
Douglas Reilly SQL Server and .NET Training and Career Development (part 2)
by Douglas Reilly | 22 March 2006 |  7 comments |
In Part I of this series, I discussed the role and value of conferences in the career development of SQL Server and .NET developers. In this article, I move on to discuss online technical forums, focusing on what to do before you post on a newsgroup or forum in... Read more...
Douglas Reilly SQL Server and .NET Training and Career Development
by Douglas Reilly | 24 February 2006 |  6 comments |
A number of years ago, I wrote a blog entry entitled “Who is Responsible for your Career?“. It was perhaps the second most popular post I ever wrote (judging by reads and referrals), and it generated a large number of comments and other blog entries, both pro and con. 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
Phil Factor We Don't Need Another Hero
 Stan, the SQL Hero, had a meteoric career at the large Financial Services Company where I worked. He burned red-hot...  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