A service from Red Gate
Home SQL .NET SysAdmin Opinion Blogs Forums Books
Sign in  | Join  | Help
SQL Home
Andrew Clarke SQL Source Control: The Development Story, Part II
by Andrew Clarke | 02 September 2010 |
When creating SQL Source Control, the team had to make decisions as to which source control systems the tool would support, and needed to accomodate a range of different development practices. It also had to avoid the potential problems from the fundemental... Read more...
Auke Teeninga Minesweeper in T-SQL
by Auke Teeninga | 02 September 2010 |
Whatever happened to the idea that programming in TSQL can be fun? A Simple-Talk reader contributes an article to remind us all that there is more to TSQL than wrestling with DMVs and pumelling recalcitrant correlated subqueries. Read more...
Joe Celko The DIS-Information Principle, Part II
by Joe Celko | 01 September 2010 |  2 comments |
Database design simply involves populating a schema with tables that model sets of entities and relationships. A table will contain Columns that model an entity's attributes and contain scalar values. What could go wrong? Plenty, unfortunately, when these simple... Read more...
TITLE PUBLISHED RATING VOTES
 The MERGE Statement in SQL Server 2008 27 August 2010 6 votes
 Rebuilding Indexes using the SSMS Database Maintenance Wizard 18 August 2010 9 votes
 The DIS-Information Principle: A Splitting Headache 17 August 2010 26 votes
 DMVs for Query Plan Metadata 17 August 2010 22 votes
 SSN Matching Speed Phreakery 05 August 2010 11 votes
 Brad's Sure Guide to SQL Virtual Restore 05 August 2010 16 votes
 When Database Source Control Goes Bad 05 August 2010 38 votes
 SQL Source Control - no more database development without it 03 August 2010 10 votes
 Creative Solutions by Using a Number Table 03 August 2010 16 votes
 Product Review: Schema Compare for Oracle 23 July 2010 8 votes
 Implementing the OUTPUT Clause in SQL Server 2008 22 July 2010 22 votes
 SQL Source Control: The Development Story 22 July 2010 11 votes
 VALUES() and Long Parameter Lists 22 July 2010 35 votes
 Automate and Improve Your Database Maintenance Using Ola Hallengren's Free Script 20 July 2010 32 votes
 SQL Server CRUD-Generation from System Views 09 July 2010 21 votes
 Redesigning Red Gate's SQL Monitoring and Alerting Tool 08 July 2010 9 votes
 Gathering Perfmon Data with Powershell 08 July 2010 37 votes
 Database Source Control - The Cribsheet 08 July 2010 27 votes
 Showplan Operator of the Week - Row Count Spool 06 July 2010 14 votes
 New Features in Reporting Services 2008 and 2008 R2 06 July 2010 46 votes
  Learn SQL Server (53 articles)

  Database Administration (82 articles)
  T-SQL Programming (104 articles)

  Performance (23 articles)
  Backup and Recovery (18 articles)

  SQL Tools (52 articles)
  SSIS (14 articles)

  Reporting Services (16 articles)

Insider Insights
 Read more...
  SQL Home

  Learn SQL Server (53 articles)

  SQL Training

  Database Administration (82 articles)

  T-SQL Programming (104 articles)

  Performance (23 articles)

  Backup and Recovery (18 articles)

  SQL Tools (52 articles)

  SSIS (14 articles)

  Reporting Services (16 articles)

Phil Factor
SQL Server CRUD-Generation from System Views
 If you are not keen on repetitive typing, you can still rapidly produce production-quality documented code by... 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...

Reading and Writing Files in SQL Server using T-SQL
 SQL Server provides several "standard" techniques by which to read and write to files but, just... 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...

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

Join Simple Talk


Privacy policy | Terms and conditions | ©2005-2010 Red Gate Software
About | Site map | Become an author | Newsletters | Contact us