SQL Server

Comparing SQL Server constraints and DML triggers

This article sheds some light on when to use constraints and when to use DML triggers. Read more »

Iterating through tables and databases in SQL Server

We look at two very useful stored procedures that live in the master database but are not mentioned in SQL Server Books Online. These system procedures come in very handy for jobs such as determining the space used, the number of rows, the indexes on the user tables, and so on. Read more »

Using NOLOCK and READPAST table hints in SQL Server

Table locking hints provide developers much tighter control of their transactions. Look at the benefits and disadvantages of using the NOLOCK and READPAST table hints in SQL Server. Read more »

Defining cascading referential integrity constraints in SQL Server

By using cascading referential integrity constraints, you can define the actions that SQL Server 2005 takes when a user tries to delete or update a key to which existing foreign keys point. Read more »

Execute SQL statements in Integration Services

This tutorial walks you through the process of adding SQL statements to your SSIS packages and bundling them into logical units of work if necessary. Read more »

How do I ... reject alpha characters in a SQL Server character column?

Enforcing your data's integrity is probably the single most important issue you face when designing a database. Validating user input is one way of keeping bad data from making its way into your analyses and reports. Read more »

Finding dependencies in SQL Server 2005

This tutorial will show how you can write a procedure that will look up all of the objects that are dependent upon other objects. Read more »

Generate synchronisation scripts in SQL Server with TableDiff

DBAs often have to find the differences between lookup tables in different database environments. SQL Server comes with a tool called TableDiff that allows you to easily compare the data in tables. Read more »

Simplify SQL Server 2005 queries with a Dates table

Learn what a Dates table is and how to create one, and then try it out for yourself. Read more »

Build directory structures using SQL Server 2005

If you store directory structures in the database, you are aware of what it takes to retrieve the data. Writing queries to pull this information is sometimes difficult to achieve and inefficient. You can use the recursion and XML features in SQL Server 2005 to build a file location on the fly. Read more »

Log in


Sign up | Forgot your password?

Blogs

RSS feed

  • Lana Kovacevic What's new in GWT 1.5?

    I recently wrote an introduction to the Google Web Toolkit based on Lars Rasmussen's session at the Google Developer Day 2008 in Sydney. Following the introductory session Lars gave us a deeper insight into GWT, particularly what's new in version 1.5. Read more »

    -- posted by Lana Kovacevic

  • Lana Kovacevic The Portal of the Future

    At this year's Gartner Application Development, Integration and Web Services Summit, I attended Gene Phifer talk: "Portal of the Future: What's Beyond Web 2.0?". Read more »

    -- posted by Lana Kovacevic

  • Staff Google's new foray into image search

    Google is developing visual crawling software that can be used for facial recognition and scene analysis. In addition images can be matched with display ads and utilise geotagging information for various applications. Read more »

    -- posted by Staff

What's on?

  • Club Builder: Sports, Gates and Gears

    This week on Club Builder: Steve Ballmer gives a teary goodbye to Bill Gates, Mark Taylor moves into IT endorsements and we ask some Google Gears questions.