Advanced

External Article

Using Views to Enforce Business Rules

  • Article

A view is most commonly thought of as a SELECT statement. Most developers will simply create a view to "group" complex SELECT statements for reuse within another view or stored procedures. It makes typing easier! But the really power of views is their ability to implement business rules.

2007-04-23

4,528 reads

SQLServerCentral Article

Sic Semper NULL

  • Article

The great debate over NULLs will probably never end. Should we use them in our databases? What meaning do they have? These are all
valid questions. In this article SQL Server expert Michael Coles takes a look at the problems that are inherent in eliminating NULLs completely from
a database.

5 (2)

You rated this post out of 5. Change rating

2007-04-10

5,931 reads

External Article

Database Design: A Point in Time Architecture

  • Article

In most relational database implementations. Update and Delete commands destroy the data that was there prior to their issue. However, some systems require that no information is ever physically deleted from or updated in the database. In this article, Arthur Fuller presents a solution to this requirement in the form of a Point-in-Time architecture: a database design which allows a user to recreate an image of the database as it existed at any previous point in time, without destroying the current image.

2007-02-28

3,723 reads

External Article

Refactoring Databases: The Process

  • Article

This article describes how to implement a single refactoring within your database. It contains a worked example of the Move Column structural refactoring, whereby we move the Customer.Balance column to the Account table, a seemingly straightforward change to improve the database design.

2007-01-16

3,244 reads

SQLServerCentral Article

Table Defaults

  • Article

In working on an existing database, DBAs often look to normalize tables and correct obvious flaws in design. Recently Andy Warren was working on a consulting project and realized that defaults would prevent many issues.

4.4 (5)

You rated this post out of 5. Change rating

2007-12-28 (first published: )

7,178 reads

Technical Article

Design Challenge: Global Address

  • Article

Are you up to the latest design challenge? A great way to sharpen our analysis and modeling skills is to continuously address real-world scenarios. A modeling scenario with suggested solutions appears each month in this Design Challenge column. The scenario is emailed to more than 1,000 modelers. The responses are then consolidated into this column.

2006-10-16

2,039 reads

Blogs

Opening the SQL Prompt Command Palette

By

A few years ago SQL Prompt added a command palette to let you search...

Common Mistakes in SQL Server – Part 2

By

The  Identity property creates an incremental value for the specified column automatically, which is...

Enable PowerShell Remoting

By

Enable PowerShell Remoting I use PowerShell quite a lot...

Read the latest Blogs

Forums

Restore With Standby; A Review and A Lesson Learned

By Andy Warren

Comments posted to this topic are about the item Restore With Standby; A Review...

Are You Worried About AI?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Are You Worried About AI?

The Upgraded Procedure part 2

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Upgraded Procedure part 2

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers